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");
}
}
public void settingJavascript()
{
if (RuleObject != null)
{
ButtonNextManufacturerSetting.ClientSideEvents.Click = "function(s, e){" + this.RuleObject.MainCpClientInstanceName + ".PerformCallback('Next');}";
ButtonBackManufacturerSetting.ClientSideEvents.Click = "function(s, e){" + this.RuleObject.MainCpClientInstanceName + ".PerformCallback('Back');}";
ButtonFinishManufacturerSetting.ClientSideEvents.Click = "function(s, e){" + this.RuleObject.MainCpClientInstanceName + ".PerformCallback('Save');}";
ASPxLoadingPanel loadingPanel = new ASPxLoadingPanel();
loadingPanel.ID = this.RuleObject.MainCpClientInstanceName + "loadingPanel";
if (this.FindControl(loadingPanel.ID) == null)
{
loadingPanel.ClientInstanceName = loadingPanel.ID;
loadingPanel.LoadingDivStyle.BackColor = System.Drawing.Color.Transparent;
loadingPanel.Text = "Đang xử lý";
loadingPanel.Modal = true;
this.Controls.Add(loadingPanel);
cpSettingManufacturerList.ClientSideEvents.BeginCallback = "function(s, e){ " + loadingPanel.ClientInstanceName + ".Show(); }";
cpSettingManufacturerList.ClientSideEvents.EndCallback = "function(s, e){ " + loadingPanel.ClientInstanceName + ".Hide(); }";
}
}
}
/* Page PreInit */
protected void Page_PreInit(object sender, EventArgs e)
{
//string themeName = DefaultThemeName;
if (!Page.IsCallback)
{
if (TimeOut())
{
return;
}
}
//if (Page.Request.Cookies[GetThemeCookieName()] != null)
//{
// themeName = HttpUtility.UrlDecode(Page.Request.Cookies[GetThemeCookieName()].Value);
//}
//string clientScriptBlock = "var DXCurrentThemeCookieName = \"" + GetThemeCookieName() + "\";";
//Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "DXCurrentThemeCookieName", clientScriptBlock, true);
//this.Theme = themeName;
loading = new ASPxLoadingPanel()
{
ID = "loading",
};
}
