Dear All,
i had a problem when update data in SQL DB
Based on below code, i have write if the quantity.text input values, then it will plus with other table quantity, but it doesnt update . kindly advise. thank you
<%@ Page Title="" Language="C#" MasterPageFile="~/Site.Master" AutoEventWireup="true" CodeBehind="MMS_IssuesTrans.aspx.cs" Inherits="acmkweb.MM.MMS_IssuesTrans" %>
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="ajax" %>
<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">
<asp:ScriptManager ID="ScriptManager1" AsyncPostBackTimeOut="3600" runat="server">
</asp:ScriptManager>
<asp:Table ID="Table1" runat="server">
<asp:TableHeaderRow ID="TableHeaderRow1" runat="server" ForeColor="Black" Font-Size="Medium">
<asp:TableHeaderCell BorderColor="Black" BorderWidth="0" ColumnSpan="4" HorizontalAlign="Center">
MMS-Issues Transaction ...
</asp:TableHeaderCell>
</asp:TableHeaderRow >
<asp:TableRow ID="ErrorRow" runat="server" ForeColor="White" Visible="false">
<asp:TableHeaderCell BorderColor="Black" BorderWidth="1" HorizontalAlign="Left" BackColor="Red">
Error :
</asp:TableHeaderCell>
<asp:TableHeaderCell BorderColor="Black" BorderWidth="1" HorizontalAlign="Left" BackColor="White" ColumnSpan="3" ForeColor="Black">
<asp:label id="lblResults" runat="server"></asp:label>
</asp:TableHeaderCell>
</asp:TableRow>
</asp:Table>
<asp:Table ID="QueryTypeTBL" runat="server">
<asp:TableRow ID="TableRow1" runat="server" ForeColor="White">
<asp:TableHeaderCell BorderColor="Black" BorderWidth="1" HorizontalAlign="Left" BackColor="#0C0C25">
InventoryType :
</asp:TableHeaderCell>
<asp:TableHeaderCell BorderColor="Black" BorderWidth="1" BackColor="ControlLight" HorizontalAlign="Left" ForeColor="Black">
<asp:DropDownList ID="WMItemType" runat="server" RepeatDirection="Horizontal" AutoPostBack="True" OnSelectedIndexChanged="WMItem_SelectedIndexChanged" ></asp:DropDownList>
</asp:TableHeaderCell>
</asp:TableRow>
</asp:Table>
<asp:Table ID="QueryDetTBL" runat="server" Width="682px">
<asp:TableHeaderRow ID="TableRow2" runat="server" ForeColor="Black" Font-Size="Medium">
<asp:TableHeaderCell BorderColor="Black" BorderWidth="0" ColumnSpan="4" HorizontalAlign="Center" >
MMS-Issues Transaction ...
</asp:TableHeaderCell>
</asp:TableHeaderRow >
<asp:TableRow ID="TableRow3" runat="server" ForeColor="Red">
<asp:TableHeaderCell BorderColor="Black" BorderWidth="1" ColumnSpan="4" HorizontalAlign="Left" BackColor="ControlLight">
*** Mandatory Field
</asp:TableHeaderCell>
</asp:TableRow>
<asp:TableRow ID="TableRow17" runat="server" ForeColor="White">
<asp:TableHeaderCell BorderColor="Black" BorderWidth="1" HorizontalAlign="Left" BackColor="#0C0C25">
Inventory ID :
</asp:TableHeaderCell>
<asp:TableHeaderCell BorderColor="Black" BorderWidth="1" BackColor="ControlLight" HorizontalAlign="Left" ForeColor="Black">
<asp:DropDownList ID="WMItem" runat="server" RepeatDirection="Horizontal" AutoPostBack="True" OnSelectedIndexChanged="WMVendor_SelectedIndexChanged"></asp:DropDownList>
</asp:TableHeaderCell>
<asp:TableHeaderCell BorderColor="Black" BorderWidth="1" BackColor="#0C0C25" ForeColor="White">Description :</asp:TableHeaderCell>
<asp:TableHeaderCell BorderColor="Black" BorderWidth="1" Width="200" HorizontalAlign="Left" BackColor="ControlLight">
<asp:TextBox ID="Inv_Desc" runat="server" columns="40" ReadOnly ="true" ForeColor="blue"></asp:TextBox>
</asp:TableHeaderCell>
</asp:TableRow>
<asp:TableRow ID="TableRow4" runat="server" ForeColor="Teal">
<asp:TableHeaderCell Font-Bold="true" ForeColor="Red">
<asp:label id="Label2" runat="server">
</asp:label>
<asp:TextBox ID="WMFENewID" runat="server" Visible="false" ForeColor="#0C0C25"></asp:TextBox>
<asp:TextBox ID="WMFECDATE" runat="server" Visible="false" ForeColor="#0C0C25"></asp:TextBox>
<asp:TextBox ID="WMFECUSER" runat="server" Visible="false" ForeColor="#0C0C25"></asp:TextBox>
</asp:TableHeaderCell>
</asp:TableRow>
<asp:TableRow ID="TableRow9" runat="server" ForeColor="Teal">
<asp:TableHeaderCell BorderColor="Black" BorderWidth="1" BackColor="#0C0C25" ForeColor="White">Location:</asp:TableHeaderCell>
<asp:TableHeaderCell BorderColor="Black" BorderWidth="1" Width="200" HorizontalAlign="Left" BackColor="ControlLight">
<asp:DropDownList ID="Inv_Loc" runat="server" AutoPostBack = "False"></asp:DropDownList>
</asp:TableHeaderCell>
</asp:TableRow>
<asp:TableRow ID="TableRow5" runat="server" ForeColor="Teal">
<asp:TableHeaderCell BorderColor="Black" BorderWidth="1" BackColor="#0C0C25" ForeColor="White">Vendor Name:</asp:TableHeaderCell>
<asp:TableHeaderCell BorderColor="Black" BorderWidth="1" Width="200" HorizontalAlign="Left" BackColor="ControlLight">
<asp:DropDownList ID="Inv_Vendorname" runat="server" AutoPostBack = "False"></asp:DropDownList>
</asp:TableHeaderCell>
<asp:TableHeaderCell BorderColor="Black" BorderWidth="1" BackColor="#0C0C25" ForeColor="White">Requester :</asp:TableHeaderCell>
<asp:TableHeaderCell BorderColor="Black" BorderWidth="1" Width="200" HorizontalAlign="Left" BackColor="ControlLight">
<asp:TextBox ID="Inv_Requestor" runat="server" ForeColor="#0C0C25"></asp:TextBox>
</asp:TableHeaderCell>
</asp:TableRow>
<asp:TableRow ID="TableRow6" runat="server" ForeColor="Red">
<asp:TableHeaderCell BorderColor="Black" BorderWidth="1" ColumnSpan="4" HorizontalAlign="Left" BackColor="ControlLight">
</asp:TableHeaderCell>
</asp:TableRow>
<asp:TableRow ID="TableRow8" runat="server" ForeColor="Teal">
<asp:TableHeaderCell BorderColor="Black" BorderWidth="1" BackColor="#0C0C25" ForeColor="White">Ref Number:</asp:TableHeaderCell>
<asp:TableHeaderCell BorderColor="Black" BorderWidth="1" Width="200" HorizontalAlign="Left" ForeColor="Red" BackColor="ControlLight">
<asp:TextBox ID="Inv_Ref" runat="server"></asp:TextBox>
<asp:RequiredFieldValidator ID="Inv_RefRFV" runat="server" ErrorMessage="***" ControlToValidate="Inv_Ref" ValidationGroup="Add"></asp:RequiredFieldValidator>
</asp:TableHeaderCell>
<asp:TableHeaderCell BorderColor="Black" BorderWidth="1" BackColor="#0C0C25" ForeColor="White">Quantity :</asp:TableHeaderCell>
<asp:TableHeaderCell BorderColor="Black" BorderWidth="1" Width="200" HorizontalAlign="Left" ForeColor="Red" BackColor="ControlLight">
<asp:TextBox ID="Inv_Qty" runat="server" ForeColor="#0C0C25"></asp:TextBox>
<asp:TextBox ID="Inv_Unit" runat="server" ReadOnly ="true" ForeColor="blue"></asp:TextBox>
<asp:RequiredFieldValidator ID="Inv_QtyRFV" runat="server" ErrorMessage="***" ControlToValidate="Inv_Qty" ValidationGroup="Add"></asp:RequiredFieldValidator>
</asp:TableHeaderCell>
</asp:TableRow>
<asp:TableRow ID="TableRow12" runat="server" ForeColor="Red">
<asp:TableHeaderCell BorderColor="Black" BorderWidth="1" ColumnSpan="4" HorizontalAlign="Left" BackColor="ControlLight">
</asp:TableHeaderCell>
</asp:TableRow>
<asp:TableRow ID="TableRow13" runat="server" ForeColor="Teal">
<asp:TableHeaderCell BorderColor="Black" BorderWidth="1" BackColor="#0C0C25" ForeColor="White">Reason ID :</asp:TableHeaderCell>
<asp:TableHeaderCell BorderColor="Black" BorderWidth="1" Width="200" HorizontalAlign="Left" ForeColor="Red" BackColor="ControlLight">
<asp:DropDownList ID="Inv_ReasonID" runat="server" AutoPostBack = "False" ></asp:DropDownList>
<asp:RequiredFieldValidator ID="Inv_ReasonIDRFV" runat="server" ErrorMessage="***" InitialValue="--Select Type--" ControlToValidate="Inv_ReasonID" ValidationGroup="Add"></asp:RequiredFieldValidator>
</asp:TableHeaderCell>
</asp:TableRow>
<asp:TableRow ID="TableRow7" runat="server" ForeColor="Teal">
<asp:TableHeaderCell BorderColor="Black" BorderWidth="1" BackColor="#0C0C25" ForeColor="White">Reason Remark:</asp:TableHeaderCell>
<asp:TableHeaderCell BorderColor="Black" BorderWidth="1" ColumnSpan="4" Width="200" HorizontalAlign="Left" BackColor="ControlLight">
<asp:TextBox ID="Inv_ReasonRemark" runat="server" columns="40" TextMode="multiline" ForeColor="#0C0C25"></asp:TextBox>
</asp:TableHeaderCell>
</asp:TableRow>
<asp:TableRow ID="TableRow15" runat="server" ForeColor="Teal">
<asp:TableHeaderCell BorderColor="Black" BorderWidth="1" BackColor="#0C0C25" ForeColor="White">Transaction Remark:</asp:TableHeaderCell>
<asp:TableHeaderCell BorderColor="Black" BorderWidth="1" ColumnSpan="4" Width="200" HorizontalAlign="Left" BackColor="ControlLight">
<asp:TextBox ID="Inv_Remark" runat="server" columns="40" TextMode="multiline" ForeColor="#0C0C25"></asp:TextBox>
</asp:TableHeaderCell>
</asp:TableRow>
<asp:TableRow ID="TableRow16" runat="server" ForeColor="Teal">
<asp:TableHeaderCell BorderColor="Black" BorderWidth="1" ColumnSpan="4" HorizontalAlign="Center" >
<asp:Button ID="Add" runat="server" Text="Add" ValidationGroup="Add" OnClick="WMAdd_Click" />
</asp:TableHeaderCell>
</asp:TableRow>
<asp:TableRow ID="TableRow18" runat="server" ForeColor="Teal">
<asp:TableHeaderCell Font-Bold="true" ForeColor="#0C0C25" ColumnSpan="4">
<asp:label id="StatLabel" runat="server">
</asp:label>
</asp:TableHeaderCell>
</asp:TableRow>
</asp:Table>
<asp:Table ID="GridViewFE" runat="server" ForeColor="Teal">
<asp:TableRow ID="TableRow19" runat="server" ForeColor="Teal">
<asp:TableHeaderCell BorderColor="Black" BorderWidth="1" ForeColor="BLACK" HorizontalAlign="Center" >
<asp:GridView ID="GridView1" runat="server" OnRowDeleting="GridView1_RowDeleting" AutoGenerateDeleteButton="true"></asp:GridView>
<asp:Button ID="Button1" runat="server" Text="Submit" OnClick="WMSubmit_Click" />
</asp:TableHeaderCell>
</asp:TableRow>
</asp:Table>
</asp:Content>
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Collections;
using System.Configuration;
using System.Web.Security;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Text;
using System.IO;
namespace acmkweb.MM
{
public partial class MMS_IssuesTrans : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
SystemDate();
TransID();
if (!Page.IsPostBack)
{
QueryDetTBL.Visible = false;
GridViewFE.Visible = false;
FillReasonID();
FillLocation();
DateTypeRD_Select();
}
ScriptManager scriptManager = ScriptManager.GetCurrent(this.Page);
}
protected void TransID()
{
string qtransid = WMFENewID.Text;
string UniIDSQL = "SELECT ISNULL(MAX(CAST(INV_TRANS_ID AS INT)),0) AS TRANSID FROM OTH_INV_TRANSACTION";
using (SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["CIMProRPT01ConnectionString"].ConnectionString))
{
using (SqlCommand cmd = new SqlCommand(UniIDSQL, con))
{
SqlDataReader reader;
qtransid = qtransid + "1";
try
{
con.Open();
reader = cmd.ExecuteReader();
if (reader.HasRows)
{
reader.Read();
WMFENewID.Text = reader["TRANSID"].ToString();
reader.Close();
}
}
catch (Exception err)
{
lblResults.Text = "Error getting Unique ID ";
lblResults.Text += err.Message;
}
con.Close();
}
}
}
private void SystemDate()
{
WMFECDATE.Text = "";
WMFECUSER.Text = "";
MembershipUser currentUser = Membership.GetUser();
string selectSQL = "SELECT LEFT(REPLACE(REPLACE(CONVERT(VARCHAR(20), GETDATE(), 121),'-',''),':',''),15) AS SYSTEMDATE";
SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["CIMProRPT01ConnectionString"].ConnectionString);
SqlCommand cmd = new SqlCommand(selectSQL, con);
SqlDataReader reader;
try
{
con.Open();
reader = cmd.ExecuteReader();
while (reader.Read())
{
WMFECDATE.Text = reader["SYSTEMDATE"].ToString();
WMFECUSER.Text = currentUser.ToString();
}
reader.Close();
}
catch (Exception err)
{
lblResults.Text = "Error getting System Date ";
lblResults.Text += err.Message;
}
finally
{
con.Close();
}
}
private void FillReasonID()
{
Inv_ReasonID.Items.Clear();
string selectSQL = "SELECT INV_REASON_ID,INV_REASON_DESC,INV_REASON_TYPE FROM [CIMProRPT01].[dbo].[OTH_INV_REASON] WHERE INV_REASON_ID = 'DO'";
SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["CIMProRPT01ConnectionString"].ConnectionString);
SqlCommand cmd = new SqlCommand(selectSQL, con);
SqlDataReader reader;
try
{
con.Open();
reader = cmd.ExecuteReader();
Inv_ReasonID.Items.Add("--Select Type--");
while (reader.Read())
{
ListItem newItem = new ListItem();
newItem.Text = reader["INV_REASON_ID"].ToString() + " - " + reader["INV_REASON_DESC"].ToString(); ;
newItem.Value = reader["INV_REASON_ID"].ToString();
Inv_ReasonID.Items.Add(newItem);
}
reader.Close();
}
catch (Exception err)
{
lblResults.Text = "Error reading list of Transaction Type. ";
lblResults.Text += err.Message;
}
finally
{
con.Close();
}
}
private void FillLocation()
{
Inv_Loc.Items.Clear();
string selectSQL = "SELECT INV_LOCATION,INV_DESC FROM [CIMProRPT01].[dbo].[OTH_INV_LOCATION]";
SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["CIMProRPT01ConnectionString"].ConnectionString);
SqlCommand cmd = new SqlCommand(selectSQL, con);
SqlDataReader reader;
try
{
con.Open();
reader = cmd.ExecuteReader();
Inv_Loc.Items.Add("--Select Type--");
while (reader.Read())
{
ListItem newItem = new ListItem();
newItem.Text = reader["INV_LOCATION"].ToString();
newItem.Value = reader["INV_LOCATION"].ToString();
Inv_Loc.Items.Add(newItem);
}
reader.Close();
}
catch (Exception err)
{
lblResults.Text = "Error reading list of Transaction Type. ";
lblResults.Text += err.Message;
}
finally
{
con.Close();
}
}
protected void DateTypeRD_Select()
{
SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["CIMProRPT01ConnectionString"].ConnectionString);
con.Open();
SqlCommand cmd = new SqlCommand("SELECT INV_TYPE FROM CIMProRPT01.dbo.OTH_INV_CATEGORY ORDER BY INV_TYPE DESC", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
con.Close();
WMItemType.DataSource = ds;
WMItemType.DataTextField = "INV_TYPE";
WMItemType.DataValueField = "INV_TYPE";
WMItemType.DataBind();
WMItemType.Items.Insert(0, new ListItem("--Select--", "0"));
}
protected void WMItem_SelectedIndexChanged(object sender, EventArgs e)
{
QueryDetTBL.Visible = true;
string ItemType = WMItemType.SelectedValue;
SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["CIMProRPT01ConnectionString"].ConnectionString);
con.Open();
SqlCommand cmd = new SqlCommand("SELECT INV_ID,INV_TYPE + '-' + INV_SHORTDESC AS DESCRIPTION FROM CIMProRPT01.dbo.OTH_INV_DETAILS WHERE INV_TYPE ='" + ItemType + "'", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
// DataSet ds = new DataSet();
DataTable ds = new DataTable();
da.Fill(ds);
WMItem.DataSource = ds;
WMItem.DataTextField = "INV_ID";
WMItem.DataValueField = "INV_ID";
con.Close();
WMItem.DataBind();
WMItem.Items.Insert(0, new ListItem("--Select--", "0"));
if (WMItem.SelectedValue == "0")
{
Inv_Vendorname.Items.Clear();
Inv_Vendorname.Items.Insert(0, new ListItem("--Select--", "0"));
}
}
protected void WMVendor_SelectedIndexChanged(object sender, EventArgs e)
{
string Item = WMItem.SelectedValue;
SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["CIMProRPT01ConnectionString"].ConnectionString);
con.Open();
SqlCommand cmd = new SqlCommand("SELECT INV_ID,INV_DESC,INV_UNIT, ALLVENDOR FROM ( SELECT INV_ID,INV_DESC,INV_UNIT,INV_VENDOR1 AS ALLVENDOR FROM OTH_INV_DETAILS UNION ALL SELECT INV_ID, INV_DESC, INV_UNIT,INV_VENDOR2 AS ALLVENDOR FROM OTH_INV_DETAILS UNION ALL SELECT INV_ID, INV_DESC, INV_UNIT,INV_VENDOR3 AS ALLVENDOR FROM OTH_INV_DETAILS UNION ALL SELECT INV_ID, INV_DESC,INV_UNIT, INV_VENDOR4 AS ALLVENDOR FROM OTH_INV_DETAILS UNION ALL SELECT INV_ID, INV_DESC,INV_UNIT, INV_VENDOR5 AS ALLVENDOR FROM OTH_INV_DETAILS)VENDOR WHERE INV_ID = '" + Item + "'", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds, "[CIMProRPT01].[dbo].[OTH_INV_DETAILS]");
con.Close();
Inv_Vendorname.DataSource = ds;
if (ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow Dr in ds.Tables[0].Rows)
{
Inv_Vendorname.Items.Add(new ListItem(Dr["ALLVENDOR"].ToString()));
Inv_Desc.Text = Dr["INV_DESC"].ToString();
Inv_Unit.Text = Dr["INV_UNIT"].ToString();
}
}
}
private void BindGrid(int rowcount)
{
DataTable dt = new DataTable();
DataRow dr;
dt.Columns.Add(new System.Data.DataColumn("Trans_ID", typeof(String))); // 1
dt.Columns.Add(new System.Data.DataColumn("INV_ID", typeof(String))); // 1
dt.Columns.Add(new System.Data.DataColumn("LOCATION", typeof(String)));// 4
dt.Columns.Add(new System.Data.DataColumn("Quantity", typeof(String)));// 8
dt.Columns.Add(new System.Data.DataColumn("Requestor", typeof(String)));// 6
dt.Columns.Add(new System.Data.DataColumn("REF Number", typeof(String)));// 7
dt.Columns.Add(new System.Data.DataColumn("TransactionRemark", typeof(String))); //11
dt.Columns.Add(new System.Data.DataColumn("ReasonID", typeof(String)));// 9
dt.Columns.Add(new System.Data.DataColumn("ReasonRemark", typeof(String))); //10
dt.Columns.Add(new System.Data.DataColumn("CREATEUSER", typeof(String))); //12
dt.Columns.Add(new System.Data.DataColumn("CREATEDATE", typeof(String))); //13
dt.Columns.Add(new System.Data.DataColumn("VendorName", typeof(String))); //11
if (ViewState["CurrentData"] != null)
{
for (int i = 0; i < rowcount + 1; i++)
{
dt = (DataTable)ViewState["CurrentData"];
if (dt.Rows.Count > 0)
{
dr = dt.NewRow();
dr[0] = dt.Rows[0][0].ToString();
}
}
dr = dt.NewRow();
dr[0] = WMFENewID.Text;
dr[1] = WMItem.SelectedValue;
dr[2] = Inv_Loc.SelectedValue;
dr[3] = Inv_Qty.Text;
dr[4] = Inv_Requestor.Text;
dr[5] = Inv_Ref.Text;
dr[6] = Inv_Remark.Text;
dr[7] = Inv_ReasonID.SelectedValue;
dr[8] = Inv_ReasonRemark.Text;
dr[9] = WMFECDATE.Text;
dr[10] = WMFECUSER.Text;
dr[11] = Inv_Vendorname.Text;
dt.Rows.Add(dr);
}
else
{
dr = dt.NewRow();
dr[0] = WMFENewID.Text;
dr[1] = WMItem.SelectedValue;
dr[2] = Inv_Loc.SelectedValue;
dr[3] = Inv_Qty.Text;
dr[4] = Inv_Requestor.Text;
dr[5] = Inv_Ref.Text;
dr[6] = Inv_Remark.Text;
dr[7] = Inv_ReasonID.SelectedValue;
dr[8] = Inv_ReasonRemark.Text;
dr[9] = WMFECDATE.Text;
dr[10] = WMFECUSER.Text;
dr[11] = Inv_Vendorname.Text;
dt.Rows.Add(dr);
}
// If ViewState has a data then use the value as the DataSource
if (ViewState["CurrentData"] != null)
{
GridView1.DataSource = (DataTable)ViewState["CurrentData"];
GridView1.DataBind();
}
else
{
// Bind GridView with the initial data assocaited in the DataTable
GridView1.DataSource = dt;
GridView1.DataBind();
}
// Store the DataTable in ViewState to retain the values
ViewState["CurrentData"] = dt;
}
protected void WMAdd_Click(object sender, EventArgs e)
{
GridViewFE.Visible = true;
// Check if the ViewState has a data assoiciated within it. If
if (ViewState["CurrentData"] != null)
{
DataTable dt = (DataTable)ViewState["CurrentData"];
int count = dt.Rows.Count;
BindGrid(count);
}
else
{
BindGrid(1);
}
// Inv_Qty.Text = string.Empty;
Inv_Requestor.Text = string.Empty;
Inv_Ref.Text = string.Empty;
Inv_ReasonRemark.Focus();
Inv_Remark.Focus();
// Inv_Qty.Focus();
Inv_Requestor.Focus();
Inv_Ref.Focus();
Inv_ReasonRemark.Focus();
Inv_Remark.Focus();
}
protected void WMSubmit_Click(object sender, EventArgs e)
{
foreach (GridViewRow oItem in GridView1.Rows)
{
string str1 = oItem.Cells[1].Text;
string str2 = oItem.Cells[2].Text;
string str3 = oItem.Cells[3].Text;
string str4 = oItem.Cells[4].Text;
string str5 = oItem.Cells[5].Text;
string str6 = oItem.Cells[6].Text;
string str7 = oItem.Cells[7].Text;
string str8 = oItem.Cells[8].Text;
string str9 = oItem.Cells[9].Text;
string str10 = oItem.Cells[10].Text;
string str11 = oItem.Cells[11].Text;
string str12 = oItem.Cells[12].Text;
insertData(str1,str2,str3,str4,str5,str6,str7,str8,str9,str10,str11,str12);
}
Response.Redirect("MMS_IssuesTrans.aspx?stat=insert");
}
public void insertData(string str1, string str2, string str3, string str4, string str5, string str6, string str7, string str8, string str9, string str10, string str11, string str12)
{
SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["CIMProRPT01ConnectionString"].ConnectionString);
con.Open();
string UpdateWMMRSQL = "UPDATE [CIMProRPT01].[dbo].[OTH_INV_QTY_LOC] SET INV_QTY = INV_QTY + '" + Inv_Qty + "' WHERE INV_ID = '" + WMItem + "' AND INV_LOCATION = '" + Inv_Loc + "' ";
string sql = "INSERT INTO OTH_INV_TRANSACTION (INV_TRANS_ID,INV_ID,INV_TRANS_LOCATION,INV_TRANS_QTY,INV_TRANS_REQUESTOR,INV_TRANS_REFNO,INV_TRANS_REMARK,INV_REASON_ID,INV_REASON_REMARK,INV_CREATE_DATE,INV_CREATE_USER,INV_VENDORS) VALUES ('" + str1 + "','" + str2 + "','" + str3 + "','" + str4 + "','" + str5 + "','" + str6 + "','" + str7 + "','" + str8 + "','" + str9 + "','" + str10 + "','" + str11 + "','" + str12 + "')";
SqlCommand cmd1 = new SqlCommand(UpdateWMMRSQL, con);
SqlCommand cmd2 = new SqlCommand(sql, con);
cmd1.ExecuteNonQuery();
cmd2.ExecuteNonQuery();
con.Close();
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
DataTable dt = (DataTable)ViewState["CurrentData"];
dt.Rows[e.RowIndex].Delete();
GridView1.DataSource = dt;
GridView1.DataBind();
}
}
}
