protected void Create_Click(object sender, EventArgs e)
{
List <object> fieldValues = MainGrid_PO.GetSelectedFieldValues(new string[] { "PK", "TableIdentifier", "DocumentNumber", "ItemCode", "ItemDescription", "Qty", "Cost", "TotalCost", "UOM" }) as List <object>;
ASPxLoadingPanel loadingPanelMas = (ASPxLoadingPanel)this.Master.FindControl("loadingPanelMaster");
//MRPClass.PrintString("--->>>" + fieldValues.Count.ToString());
if (fieldValues.Count == 0)
{
//ModalPopupExtenderLoading.Hide();
loadingPanelMas.Visible = false;
return;
}
else
{
string userkey = Session["CreatorKey"].ToString();
string delete = "DELETE FROM [dbo].[tbl_POCreation_Tmp] WHERE [UserKey] = '" + userkey + "'";
SqlConnection conn = new SqlConnection(GlobalClass.SQLConnString());
conn.Open();
SqlCommand cmd = new SqlCommand(delete, conn);
cmd.ExecuteNonQuery();
foreach (object[] obj in fieldValues)
{
string[] arr = obj[0].ToString().Split('-');
string pk = arr[0];
string identifier = obj[1].ToString();
string docnum = obj[2].ToString();
string itemcode = obj[3].ToString();
string itemdesc = obj[4].ToString();
string qty = obj[5].ToString();
string cost = obj[6].ToString();
string totalcost = obj[7].ToString();
string uom = obj[8].ToString();
int wVAT = 0;
string insert = "INSERT INTO [dbo].[tbl_POCreation_Tmp] ([UserKey], [MOPNumber], [ItemPK], [ItemIdentifier], [POUOM], [wVAT]) VALUES (@userkey, @mopnumber, @itempk, @itemidentifier, @uom, @wVAT)";
cmd = new SqlCommand(insert, conn);
cmd.Parameters.AddWithValue("@userkey", userkey);
cmd.Parameters.AddWithValue("@mopnumber", docnum);
cmd.Parameters.AddWithValue("@itempk", pk);
cmd.Parameters.AddWithValue("@itemidentifier", identifier);
cmd.Parameters.AddWithValue("@uom", uom);
cmd.Parameters.AddWithValue("@wVAT", wVAT);
cmd.ExecuteNonQuery();
}
//ModalPopupExtenderLoading.Hide();
loadingPanelMas.Visible = false;
Response.Redirect("mrp_po_create.aspx");
}
}
private void BindTable(string docnumber, int month, string year, ArrayList prod)
{
//if (month == -1) return;
int checkedBox = 0;
if (CheckboxAll.Checked)
{
checkedBox = 1;
}
MainGrid_PO.DataSource = POClass.POSelecetedItemTable(checkedBox, docnumber, month, year, prod);
MainGrid_PO.KeyFieldName = "PK";
MainGrid_PO.DataBind();
}
