protected void btnChangePW_Click(object sender, EventArgs e)
{
if (captcha.IsValid && ASPxEdit.ValidateEditorsInContainer(this))
{
//PopupChangePW.HeaderText = "Confirm";
//PopupChangePW.ShowOnPageLoad = true;
string qry = "", _sPassword = "";
SqlCommand cmd = null;
_sPassword = EncryptionClass.Encrypt(newPasswordCH.Text.ToString().Trim());
SqlConnection con = new SqlConnection(GlobalClass.SQLConnString());
con.Open();
qry = "UPDATE tbl_Users " +
" SET Password = '******' " +
" WHERE (PK = " + Session["CreatorKey"] + ")";
cmd = new SqlCommand(qry);
cmd.Connection = con;
cmd.ExecuteNonQuery();
con.Close();
ModalPopupExtenderLoading.Hide();
Response.Redirect("home.aspx");
}
}
protected void OK_SUBMIT_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection(GlobalClass.SQLConnString());
DataTable dt = new DataTable();
SqlCommand cmd = null;
SqlDataAdapter adp;
DataTable dt1 = new DataTable();
SqlCommand cmd1 = null;
SqlDataAdapter adp1;
ponumber = gridCreatedPO.GetRowValues(gridCreatedPO.FocusedRowIndex, "PONumber").ToString();
string qry = "SELECT tbl_POCreation_Details.* FROM tbl_POCreation_Details WHERE (PONumber = '" + ponumber + "')";
cmd = new SqlCommand(qry);
cmd.Connection = conn;
adp = new SqlDataAdapter(cmd);
adp.Fill(dt);
if (dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
if (row["TaxGroup"].ToString().Trim() == "")
{
ModalPopupExtenderLoading.Hide();
POListNotify.HeaderText = "Error...";
POListNotifyLbl.Text = "Details has no Tax Group.";
POListNotify.ShowOnPageLoad = true;
return;
}
if (row["TaxItemGroup"].ToString().Trim() == "")
{
ModalPopupExtenderLoading.Hide();
POListNotify.HeaderText = "Error...";
POListNotifyLbl.Text = "Details has no Tax Item Group.";
POListNotify.ShowOnPageLoad = true;
return;
}
}
}
else
{
ModalPopupExtenderLoading.Hide();
POListNotify.HeaderText = "Error...";
POListNotifyLbl.Text = "No Data to submit.";
POListNotify.ShowOnPageLoad = true;
return;
}
dt.Clear();
conn.Close();
//Submit_Method();
//POClass.SubmitToAX(ponumber, POListNotify, POListNotifyLbl, ModalPopupExtenderLoading);
POClass.SubmitToAXTable(ponumber, Session["UserCompleteName"].ToString(), POListNotify, POListNotifyLbl, ModalPopupExtenderLoading);
Bind_PO_List();
}
protected void BtnAddSOA_Click(object sender, EventArgs e)
{
List <object> fieldValues = gridWayBill.GetSelectedFieldValues(new string[] { "Waybill", "Year", "WeekNum", "CustCode" }) as List <object>;
string userkey = Session["CreatorKey"].ToString();
string delete = "DELETE FROM [dbo].[tbl_HLS_StatementOfAccount_Temp] WHERE [UserKey] = " + Convert.ToInt32(userkey) + "";
SqlConnection conn = new SqlConnection(GlobalClass.SQLConnString());
conn.Open();
SqlCommand cmd = new SqlCommand(delete, conn);
cmd.ExecuteNonQuery();
string sWeekYear = "";
string sWeekNum = "";
string sCustCode = "";
foreach (object[] obj in fieldValues)
{
//string[] arr = obj[0].ToString().Split('-');
string waybill = obj[0].ToString();
sWeekYear = obj[1].ToString();
sWeekNum = obj[2].ToString();
sCustCode = obj[3].ToString();
string insert = "INSERT INTO [dbo].[tbl_HLS_StatementOfAccount_Temp] ([UserKey], [WeekYear], [WeekNum], [CustCode], [WaybillNum]) VALUES (@userkey, @WeekYear, @WeekNum, @CustCode, @WaybillNum)";
cmd = new SqlCommand(insert, conn);
cmd.Parameters.AddWithValue("@userkey", Convert.ToInt32(userkey));
cmd.Parameters.AddWithValue("@WeekYear", Convert.ToInt32(sWeekYear));
cmd.Parameters.AddWithValue("@WeekNum", Convert.ToInt32(sWeekNum));
cmd.Parameters.AddWithValue("@CustCode", sCustCode);
cmd.Parameters.AddWithValue("@WaybillNum", waybill);
cmd.ExecuteNonQuery();
}
ModalPopupExtenderLoading.Hide();
Session["HLS_Trans"] = "Add";
Session["HLS_Add_Year"] = sWeekYear;
Session["HLS_Add_WeekNum"] = sWeekNum;
Session["HLS_Add_CustCode"] = sCustCode;
Session["HLS_Add_SOANum"] = "";
Response.Redirect("hlsSOA_Add.aspx");
}
protected void OK_ChangePW_Click(object sender, EventArgs e)
{
string qry = "", _sPassword = "";
SqlCommand cmd = null;
_sPassword = EncryptionClass.Encrypt(newPasswordCH.Text.ToString().Trim());
SqlConnection con = new SqlConnection(GlobalClass.SQLConnString());
con.Open();
qry = "UPDATE tbl_Users " +
" SET Password = '******' " +
" WHERE (PK = " + Session["CreatorKey"] + ")";
cmd = new SqlCommand(qry);
cmd.Connection = con;
cmd.ExecuteNonQuery();
con.Close();
ModalPopupExtenderLoading.Hide();
Response.Redirect("home.aspx");
}
protected void OK_SUBMIT_Click(object sender, EventArgs e)
{
CheckCreatorKey();
if (MRPClass.MRP_Line_Status(mrp_key, wrkflwln) == 0)
{
bool isAllowed = false;
if (GlobalClass.IsSuperAdmin(Convert.ToInt32(Session["CreatorKey"])))
{
isAllowed = true;
}
else
{
switch (wrkflwln)
{
case 1:
{
isAllowed = GlobalClass.IsAllowed(Convert.ToInt32(Session["CreatorKey"]), "MOPBULead", dateCreated, entitycode, buCode);
break;
}
case 2:
{
isAllowed = GlobalClass.IsAllowed(Convert.ToInt32(Session["CreatorKey"]), "MOPInventoryAnalyst", dateCreated);
break;
}
//case 3:
// {
// isAllowed = GlobalClass.IsAllowed(Convert.ToInt32(Session["CreatorKey"]), "MOPBudget_PerEntBU", dateCreated, entitycode, buCode);
// break;
// }
case 3:
{
isAllowed = GlobalClass.IsAllowed(Convert.ToInt32(Session["CreatorKey"]), "MOPInventoryAnalyst", dateCreated);
break;
}
}
}
if (isAllowed == true)
{
PopupSubmitPreviewAnal.ShowOnPageLoad = false;
//MRPClass.Submit_MRP(docnumber.ToString(), mrp_key, wrkflwln + 1, entitycode, buCode, Convert.ToInt32(Session["CreatorKey"]));
//ScriptManager.RegisterStartupScript(this.Page, typeof(string), "Resize", "changeWidth.resizeWidth();", true);
MRPSubmitClass.MRP_Submit(docnumber.ToString(), mrp_key, dateCreated, wrkflwln, entitycode, buCode, Convert.ToInt32(Session["CreatorKey"]));
Submit.Enabled = false;
ModalPopupExtenderLoading.Hide();
MRPNotificationMessage.Text = MRPClass.successfully_submitted;
MRPNotificationMessage.ForeColor = System.Drawing.Color.Black;
MRPNotify.HeaderText = "Info";
MRPNotify.ShowOnPageLoad = true;
}
else
{
MRPNotificationMessage.Text = "You have no permission to perform this command!" + Environment.NewLine + "Access Denied!";
MRPNotificationMessage.ForeColor = System.Drawing.Color.Red;
MRPNotify.HeaderText = "Info";
MRPNotify.ShowOnPageLoad = true;
}
}
else
{
//ScriptManager.RegisterStartupScript(this.Page, typeof(string), "Resize", "changeWidth.resizeWidth();", true);
}
//}
}
protected void Submit_Click(object sender, EventArgs e)
{
bool cancel = false;
ASPxGridView grid = POAddEditGrid as ASPxGridView;
for (int i = 0; i < grid.VisibleRowCount; i++)
{
object taxgroup = grid.GetRowValues(i, "TaxGroup");
object taxitemgroup = grid.GetRowValues(i, "TaxItemGroup");
object identifier = grid.GetRowValues(i, "Identifier");
object cip = grid.GetRowValues(i, "CapexCIP");
object prodcat = grid.GetRowValues(i, "ProdCat");
if (string.IsNullOrEmpty(taxgroup.ToString()) || string.IsNullOrEmpty(taxitemgroup.ToString()))
{
cancel = true;
break;
}
if (identifier.ToString() == "4")
{
MRPClass.PrintString(prodcat.ToString());
MRPClass.PrintString(string.IsNullOrEmpty(cip.ToString()).ToString());
if (prodcat.ToString() != "CIP")
{
if (string.IsNullOrEmpty(cip.ToString()))
{
cancel = true;
break;
}
}
}
}
if (cancel)//if empty taxgroup this is true
{
ModalPopupExtenderLoading.Hide();
PONotify.HeaderText = "Alert";
PONotifyLbl.Text = "Some selected items are empty.";
PONotify.ShowOnPageLoad = true;
}
else
{
if (grid.VisibleRowCount > 0)
{
//Submit_Method();
//POClass.SubmitToAX(ponumber, PONotify, PONotifyLbl, ModalPopupExtenderLoading);
POClass.SubmitToAXTable(ponumber, Session["UserCompleteName"].ToString(), PONotify, PONotifyLbl, ModalPopupExtenderLoading);
}
else
{
ModalPopupExtenderLoading.Hide();
Submit.ClientEnabled = false;
PONotify.HeaderText = "Alert";
PONotifyLbl.Text = "No data to submit";
PONotify.ShowOnPageLoad = true;
}
}
ScriptManager.RegisterStartupScript(this.Page, typeof(string), "Resize", "changeWidth.resizeWidth();", true);
BindData();
}
protected void signUp_Click(object sender, EventArgs e)
{
int iEmployeeKey = 0;
//MRPClass.PrintString("pass clicked signup");
if (captcha.IsValid && ASPxEdit.ValidateEditorsInContainer(this))
{
ModalPopupExtenderLoading.Show();
//MRPClass.PrintString("pass inside validation");
DataTable dt = new DataTable();
SqlCommand cmd = null;
SqlDataAdapter adp;
string qry = "";
using (SqlConnection conHRIS = new SqlConnection(GlobalClass.SQLConnStringHRIS()))
{
//MRPClass.PrintString("pass inside hris");
qry = "SELECT PK, IDNumber FROM dbo.tbl_EmployeeIDNumber WHERE(IDNumber = '" + IDNumTextBox.Text.ToString() + "')";
cmd = new SqlCommand(qry);
cmd.Connection = conHRIS;
adp = new SqlDataAdapter(cmd);
adp.Fill(dt);
if (dt.Rows.Count > 0)
{
//MRPClass.PrintString("pass inside hris with id");
foreach (DataRow row in dt.Rows)
{
iEmployeeKey = Convert.ToInt32(row["PK"]);
}
}
else
{
//Page.ClientScript.RegisterStartupScript(this.GetType(), "alert",
// @"<script type=""text/javascript"">setTimeout(()=>{alert('ID Number not found in Employee MasterList!')},0);</script>");
ModalPopupExtenderLoading.Hide();
CreateAccntNotify.HeaderText = "Error...";
CreateAccntNotifyLbl.Text = "ID Number not found in Employee MasterList!";
CreateAccntNotifyLbl.ForeColor = System.Drawing.Color.Red;
CreateAccntNotify.ShowOnPageLoad = true;
return;
}
dt.Clear();
conHRIS.Close();
}
DataTable dtUser = AccountClass.UserList();
//dtUser.CaseSensitive = true;
string expressionID = "EmployeeKey = '" + iEmployeeKey.ToString().Trim() + "'";
string sortOrderID = "PK ASC";
DataRow[] foundRowsID;
foundRowsID = dtUser.Select(expressionID, sortOrderID);
if (foundRowsID.Length > 0)
{
//Page.ClientScript.RegisterStartupScript(this.GetType(), "alert",
// @"<script type=""text/javascript"">setTimeout(()=>{alert('Found Duplicate ID Number!')},0);</script>");
ModalPopupExtenderLoading.Hide();
CreateAccntNotify.HeaderText = "Error...";
CreateAccntNotifyLbl.Text = "Found Duplicate ID Number!";
CreateAccntNotifyLbl.ForeColor = System.Drawing.Color.Red;
CreateAccntNotify.ShowOnPageLoad = true;
return;
}
dtUser.CaseSensitive = true;
string expressionName = "Lastname = '" + lastNameTextBox.Text.ToString().Trim() + "' AND Firstname = '" + firstNameTextBox.Text.ToString().Trim() + "'";
string sortOrderName = "PK ASC";
DataRow[] foundRowsName;
foundRowsName = dtUser.Select(expressionName, sortOrderName);
if (foundRowsName.Length > 0)
{
//Page.ClientScript.RegisterStartupScript(this.GetType(), "alert",
// @"<script type=""text/javascript"">setTimeout(()=>{alert('Found Duplicate Lastname and Firstname!')},0);</script>");
ModalPopupExtenderLoading.Hide();
CreateAccntNotify.HeaderText = "Error...";
CreateAccntNotifyLbl.Text = "Found Duplicate Lastname and Firstname!";
CreateAccntNotifyLbl.ForeColor = System.Drawing.Color.Red;
CreateAccntNotify.ShowOnPageLoad = true;
return;
}
string expressionEmail = "Email = '" + eMailTextBox.Text.ToString().Trim() + "'";
string sortOrderEmail = "PK ASC";
DataRow[] foundRowsEmail;
foundRowsEmail = dtUser.Select(expressionEmail, sortOrderEmail);
if (foundRowsEmail.Length > 0)
{
//Page.ClientScript.RegisterStartupScript(this.GetType(), "alert",
// @"<script type=""text/javascript"">setTimeout(()=>{alert('Found Duplicate Email!')},0);</script>");
ModalPopupExtenderLoading.Hide();
CreateAccntNotify.HeaderText = "Error...";
CreateAccntNotifyLbl.Text = "Found Duplicate Email!";
CreateAccntNotifyLbl.ForeColor = System.Drawing.Color.Red;
CreateAccntNotify.ShowOnPageLoad = true;
return;
}
string expressionUName = "Username = '******'";
string sortOrderUName = "PK ASC";
DataRow[] foundRowsUName;
foundRowsUName = dtUser.Select(expressionUName, sortOrderUName);
if (foundRowsUName.Length > 0)
{
//Page.ClientScript.RegisterStartupScript(this.GetType(), "alert",
// @"<script type=""text/javascript"">setTimeout(()=>{alert('Found Duplicate Username!')},0);</script>");
ModalPopupExtenderLoading.Hide();
CreateAccntNotify.HeaderText = "Error...";
CreateAccntNotifyLbl.Text = "Found Duplicate Username!";
CreateAccntNotifyLbl.ForeColor = System.Drawing.Color.Red;
CreateAccntNotify.ShowOnPageLoad = true;
return;
}
using (SqlConnection con = new SqlConnection(GlobalClass.SQLConnString()))
{
string _sLastName, _sFirstName, _sEmail, _sUserName, _sPassword, _sIDNum;
int _Gender = 0;
_sLastName = EncryptionClass.Encrypt(GlobalClass.UpperCaseFirstLetter(lastNameTextBox.Text.ToString().Trim()));
_sFirstName = EncryptionClass.Encrypt(GlobalClass.UpperCaseFirstLetter(firstNameTextBox.Text.ToString().Trim()));
_Gender = gender_int;
_sEmail = EncryptionClass.Encrypt(eMailTextBox.Text.ToString().Trim());
_sUserName = EncryptionClass.Encrypt(userNameTextBox.Text.ToString().Trim());
_sPassword = EncryptionClass.Encrypt(passwordTextBox.Text.ToString().Trim());
_sIDNum = EncryptionClass.Encrypt(IDNumTextBox.Text.ToString().Trim());
con.Open();
qry = "INSERT INTO tbl_Users " +
" (Lastname, Firstname, Username, Password, Email, EmployeeKey, Gender) " +
" VALUES ('" + _sLastName + "', '" + _sFirstName + "', '" + _sUserName + "', " +
" '" + _sPassword + "', '" + _sEmail + "', " + iEmployeeKey + ", " + _Gender + ")";;
try
{
cmd = new SqlCommand(qry);
cmd.Connection = con;
cmd.ExecuteNonQuery();
con.Close();
//Page.ClientScript.RegisterStartupScript(this.GetType(), "alert",
// @"<script type=""text/javascript"">setTimeout(()=>{alert('You have successfully registered')},0);</script>");
//MRPClass.PrintString("pass saved");
ModalPopupExtenderLoading.Hide();
CreateAccntNotify.HeaderText = "Info";
CreateAccntNotifyLbl.Text = "You is successfully registered.";
CreateAccntNotifyLbl.ForeColor = System.Drawing.Color.Black;
CreateAccntNotify.ShowOnPageLoad = true;
Response.Redirect("default.aspx");
}
catch (SqlException ex)
{
//MRPClass.PrintString(ex.ToString());
con.Close();
//Page.ClientScript.RegisterStartupScript(this.GetType(), "alert",
// @"<script type=""text/javascript"">setTimeout(()=>{alert('" + ex.ToString() + "')},0);</script>");
CreateAccntNotify.HeaderText = "Error...";
CreateAccntNotifyLbl.Text = ex.ToString();
CreateAccntNotifyLbl.ForeColor = System.Drawing.Color.Red;
CreateAccntNotify.ShowOnPageLoad = true;
}
}
}
}
protected void Save_Click(object sender, EventArgs e)
{
CheckCreatorKey();
SqlConnection conn = new SqlConnection(GlobalClass.SQLConnString());
conn.Open();
SqlDataReader reader = null;
SqlCommand cmd = null;
DataTable dt = new DataTable();
SqlDataAdapter adp;
//Declare Variables
string DocPref = "", strDocNum = "", PONumber = "", delete = "", update = "", query = "", insert = "", insert_po_details = "";
int POSeriesNum = 0;
string mopnumber = MOPReference.Text;
string entitycode = "", bucode = "";
query = "SELECT [PK],[EntityCode],[BUCode] FROM[dbo].[tbl_MRP_List] WHERE DocNumber = '" + mopnumber + "'";
cmd = new SqlCommand(query, conn);
reader = cmd.ExecuteReader();
while (reader.Read())
{
entitycode = reader["EntityCode"].ToString();
bucode = reader["BUCode"].ToString();
}
reader.Close();
string vendor = Vendor.Text.ToString();
string payment = Terms.Text.ToString();
string currency = Currency.Text.ToString();
string site = Site.Text.ToString();
string warehouse = Warehouse.Text.ToString();
string location = Location.Text.ToString();
string remarks = Remarks.Text.ToString();
query = "SELECT tbl_PONumber.* FROM tbl_PONumber WHERE (EntityCode = '" + entitycode + "')";
cmd = new SqlCommand(query);
cmd.Connection = conn;
adp = new SqlDataAdapter(cmd);
adp.Fill(dt);
if (dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
POSeriesNum = Convert.ToInt32(row["LastNumber"]) + 1;
PONumber = row["Prefix"].ToString() + "-" + row["EntityCode"].ToString() + "-" + row["BeforeSeries"].ToString() + POSeriesNum.ToString("0000000#");
insert = "INSERT INTO [dbo].[tbl_POCreation] ([PONumber],[DateCreated],[CreatorKey],[MRPNumber], [ExpectedDate], [VendorCode], [PaymentTerms], [CurrencyCode], [InventSite], [InventSiteWarehouse], [InventSiteWarehouseLocation], [EntityCode], [BUSSUCode], [Remarks]) VALUES (@PONumber, @DateCreated, @CreatorKey, @MRPNumber, @ExpectedDate, @VendorCode, @PaymentTerms, @CurrencyCode, @InventSite, @InventSiteWarehouse, @InventSiteWarehouseLocation, @EntityCode, @BUSSUCode, @Remarks)";
cmd = new SqlCommand(insert, conn);
cmd.Parameters.AddWithValue("@PONumber", PONumber);
cmd.Parameters.AddWithValue("@CreatorKey", Session["CreatorKey"].ToString());
cmd.Parameters.AddWithValue("@MRPNumber", mopnumber);
cmd.Parameters.AddWithValue("@EntityCode", entitycode);
cmd.Parameters.AddWithValue("@BUSSUCode", bucode);
cmd.Parameters.AddWithValue("@DateCreated", DateTime.Now);
cmd.Parameters.AddWithValue("@ExpectedDate", ExpDel.Value.ToString());
cmd.Parameters.AddWithValue("@VendorCode", vendor);
cmd.Parameters.AddWithValue("@PaymentTerms", payment);
cmd.Parameters.AddWithValue("@CurrencyCode", currency);
cmd.Parameters.AddWithValue("@InventSite", site);
cmd.Parameters.AddWithValue("@InventSiteWarehouse", warehouse);
cmd.Parameters.AddWithValue("@InventSiteWarehouseLocation", location);
cmd.Parameters.AddWithValue("@Remarks", remarks);
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
ASPxGridView grid = POCreateGrid as ASPxGridView;
for (int i = 0; i < grid.VisibleRowCount; i++)
{
object PK = grid.GetRowValues(i, "PK");
object MOPNumber = grid.GetRowValues(i, "MOPNumber");
object ItemPK = grid.GetRowValues(i, "ItemPK");
object TableIdentifier = grid.GetRowValues(i, "TableIdentifier");
object ItemCode = grid.GetRowValues(i, "ItemCode");
object Description = grid.GetRowValues(i, "Description");
object RequestedQty = grid.GetRowValues(i, "RequestedQty");
object Cost = grid.GetRowValues(i, "Cost");
object TotalCost = grid.GetRowValues(i, "TotalCost");
object POUOM = grid.GetRowValues(i, "POUOM");
object POQty = grid.GetRowValues(i, "POQty");
object POCost = grid.GetRowValues(i, "POCost");
object TotalPOCost = grid.GetRowValues(i, "TotalPOCost");
object wVAT = grid.GetRowValues(i, "wVAT");
object POCostwVAT = grid.GetRowValues(i, "POCostwVAT");
object TotalPOCostwVAT = grid.GetRowValues(i, "TotalPOCostwVAT");
object TaxGroup = grid.GetRowValues(i, "TaxGroup");
object TaxItemGroup = grid.GetRowValues(i, "TaxItemGroup");
int iVat = 0;
if (Convert.ToBoolean(wVAT))
{
iVat = 1;
}
insert_po_details = "INSERT INTO [dbo].[tbl_POCreation_Details] ([PONumber],[MOPNumber], [ItemPK], [Identifier], [ItemCode], [TaxGroup], [TaxItemGroup], [Qty], [Cost], [POUOM], [wVAT], [CostwVAT]) VALUES (@PONumber,@MOPNumber, @ItemPK, @Identifier, @ItemCode, @TaxGroup, @TaxItemGroup, @Qty, @Cost, @POUOM, @wVAT, @CostwVAT)";
cmd = new SqlCommand(insert_po_details, conn);
cmd.Parameters.AddWithValue("@PONumber", PONumber);
cmd.Parameters.AddWithValue("@MOPNumber", MOPNumber);
cmd.Parameters.AddWithValue("@ItemPK", ItemPK);
cmd.Parameters.AddWithValue("@Identifier", TableIdentifier);
cmd.Parameters.AddWithValue("@ItemCode", ItemCode);
cmd.Parameters.AddWithValue("@TaxGroup", TaxGroup);
cmd.Parameters.AddWithValue("@TaxItemGroup", TaxItemGroup);
cmd.Parameters.AddWithValue("@POUOM", POUOM);
cmd.Parameters.AddWithValue("@Qty", Convert.ToDouble(POQty));
cmd.Parameters.AddWithValue("@Cost", Convert.ToDouble(POCost));
//cmd.Parameters.AddWithValue("@TotalCost", Convert.ToDouble(TotalPOCost));
cmd.Parameters.AddWithValue("@CostwVAT", Convert.ToDouble(POCostwVAT));
//cmd.Parameters.AddWithValue("@TotalCostwVAT", Convert.ToDouble(TotalPOCostwVAT));
cmd.Parameters.AddWithValue("@wVAT", iVat);
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
switch (TableIdentifier.ToString())
{
case "1": //Direct Material
update = "UPDATE " + MRP_Constants.DirectMaterials_TableName() + " SET [QtyPO] = '" + Convert.ToDouble(POQty) + "' WHERE [PK] = '" + ItemPK + "'";
cmd = new SqlCommand(update, conn);
cmd.ExecuteNonQuery();
break;
case "2": //Opex
update = "UPDATE " + MRP_Constants.OperatingExpense_TableName() + " SET [QtyPO] = '" + Convert.ToDouble(POQty) + "' WHERE [PK] = '" + ItemPK + "'";
cmd = new SqlCommand(update, conn);
cmd.ExecuteNonQuery();
break;
case "4": //CAPEX
update = "UPDATE [dbo].[tbl_MRP_List_CAPEX] SET [QtyPO] = '" + Convert.ToDouble(POQty) + "' WHERE [PK] = '" + ItemPK + "'";
cmd = new SqlCommand(update, conn);
cmd.ExecuteNonQuery();
break;
}
}
delete = "DELETE FROM [dbo].[tbl_POCreation_Tmp] WHERE [UserKey] = '" + Session["CreatorKey"].ToString() + "'";
cmd = new SqlCommand(delete, conn);
cmd.ExecuteNonQuery();
update = "UPDATE [dbo].[tbl_PONumber] SET LastNumber = " + POSeriesNum + " WHERE ([EntityCode] = '" + entitycode + "')";
cmd = new SqlCommand(update, conn);
cmd.ExecuteNonQuery();
ModalPopupExtenderLoading.Hide();
Response.Redirect("mrp_po_addedit.aspx?PONum=" + PONumber);
}
}
else
{
ScriptManager.RegisterStartupScript(this.Page, typeof(string), "Resize", "changeWidth.resizeWidth();", true);
POCreateNotify.HeaderText = "Alert!";
POCreateNotifyLbl.Text = "Please Call Administrator." + Environment.NewLine + Environment.NewLine + "No PO Number Setup.";
POCreateNotifyLbl.ForeColor = System.Drawing.Color.Red;
POCreateNotify.ShowOnPageLoad = true;
}
dt.Clear();
conn.Close();
}
protected void Submit_Click(object sender, EventArgs e)
{
CheckCreatorKey();
iStatusKey = MRPClass.MRP_ApprvLine_Status(mrp_key, appflwln);
StatusHidden["hidden_preview_iStatusKey"] = iStatusKey;
//MRPClass.PrintString(appflwln.ToString());
if (iStatusKey == 0)
{
bool isAllowed = false;
if (GlobalClass.IsSuperAdmin(Convert.ToInt32(Session["CreatorKey"])))
{
isAllowed = true;
}
else
{
switch (appflwln)
{
case 1:
{
isAllowed = GlobalClass.IsAllowed(Convert.ToInt32(Session["CreatorKey"]), "MOPSCMLead", dateCreated);
break;
}
case 2:
{
isAllowed = GlobalClass.IsAllowed(Convert.ToInt32(Session["CreatorKey"]), "MOPFinanceLead", dateCreated);
break;
}
case 3:
{
isAllowed = GlobalClass.IsAllowed(Convert.ToInt32(Session["CreatorKey"]), "MOPExecutive", dateCreated);
break;
}
}
}
if (isAllowed == true)
{
//MRPClass.PrintString("Approved");
PopupSubmitAppPreview.ShowOnPageLoad = false;
ScriptManager.RegisterStartupScript(this.Page, typeof(string), "Resize", "changeWidth.resizeWidth();", true);
MRPApproveClass.MRP_Approve(docnum.ToString(), mrp_key, dateCreated, appflwln, entitycode, buCode, Convert.ToInt32(Session["CreatorKey"]));
Submit.Enabled = false;
Load_MRP(docnum);
ModalPopupExtenderLoading.Hide();
MRPNotifyMsgPrevApp.Text = MRPClass.successfully_approved;
MRPNotifyMsgPrevApp.ForeColor = System.Drawing.Color.Black;
MRPNotifyPrevApp.HeaderText = "Info";
MRPNotifyPrevApp.ShowOnPageLoad = true;
}
else
{
MRPNotifyMsgPrevApp.Text = "You have no permission to perform this command!" + Environment.NewLine + "Access Denied!";
MRPNotifyMsgPrevApp.ForeColor = System.Drawing.Color.Red;
MRPNotifyPrevApp.HeaderText = "Info";
MRPNotifyPrevApp.ShowOnPageLoad = true;
}
}
//else
//{
// //ScriptManager.RegisterStartupScript(this.Page, typeof(string), "Resize", "changeWidth.resizeWidth();", true);
// //MRPNotificationMessage.Text = "Document already submitted to BU / SSU Lead for review.";
// //MRPNotify.HeaderText = "Alert";
// //MRPNotify.ShowOnPageLoad = true;
//}
}
