private void Load_MRP(string docnumber) { string query = "SELECT TOP (100) PERCENT tbl_MRP_List.*, vw_AXEntityTable.NAME AS EntityCodeDesc, vw_AXOperatingUnitTable.NAME AS BUCodeDesc, tbl_MRP_Status.StatusName, tbl_Users.Lastname, tbl_Users.Firstname FROM tbl_MRP_List LEFT OUTER JOIN tbl_Users ON tbl_MRP_List.CreatorKey = tbl_Users.PK LEFT OUTER JOIN vw_AXOperatingUnitTable ON tbl_MRP_List.BUCode = vw_AXOperatingUnitTable.OMOPERATINGUNITNUMBER LEFT OUTER JOIN tbl_MRP_Status ON tbl_MRP_List.StatusKey = tbl_MRP_Status.PK LEFT OUTER JOIN vw_AXEntityTable ON tbl_MRP_List.EntityCode = vw_AXEntityTable.ID WHERE dbo.tbl_MRP_List.DocNumber = '" + docnumber + "' ORDER BY dbo.tbl_MRP_List.DocNumber DESC"; SqlConnection conn = new SqlConnection(GlobalClass.SQLConnString()); conn.Open(); SqlCommand cmd = new SqlCommand(query, conn); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { mrp_key = Convert.ToInt32(reader["PK"].ToString()); entitycode = reader["EntityCode"].ToString(); DocNum.Text = reader["DocNumber"].ToString(); DateCreated.Text = reader["DateCreated"].ToString(); EntityCode.Text = reader["EntityCodeDesc"].ToString(); BUCode.Text = reader["BUCodeDesc"].ToString(); buCode = reader["BUCode"].ToString(); Month.Text = MRPClass.Month_Name(Int32.Parse(reader["MRPMonth"].ToString())); Year.Text = reader["MRPYear"].ToString(); Status.Text = reader["StatusName"].ToString(); firstname = reader["Firstname"].ToString(); lastname = reader["Lastname"].ToString(); } reader.Close(); conn.Close(); Creator.Text = EncryptionClass.Decrypt(firstname) + " " + EncryptionClass.Decrypt(lastname); iStatusKey = MRPClass.MRP_Line_Status(mrp_key, wrkflwln); }
private void Load_MRP(string docnumber) { string query = "SELECT tbl_MRP_List.*, " + " vw_AXEntityTable.NAME AS EntityCodeDesc, " + " vw_AXOperatingUnitTable.NAME AS BUCodeDesc, " + " tbl_MRP_Status.StatusName, tbl_Users.Lastname, " + " tbl_Users.Firstname, tbl_MRP_List.EntityCode, " + " tbl_MRP_List.BUCode " + " FROM tbl_MRP_List LEFT OUTER JOIN tbl_Users ON tbl_MRP_List.CreatorKey = tbl_Users.PK " + " LEFT OUTER JOIN vw_AXOperatingUnitTable ON tbl_MRP_List.BUCode = vw_AXOperatingUnitTable.OMOPERATINGUNITNUMBER " + " LEFT OUTER JOIN tbl_MRP_Status ON tbl_MRP_List.StatusKey = tbl_MRP_Status.PK " + " LEFT OUTER JOIN vw_AXEntityTable ON tbl_MRP_List.EntityCode = vw_AXEntityTable.ID " + " WHERE dbo.tbl_MRP_List.DocNumber = '" + docnumber + "' " + " ORDER BY dbo.tbl_MRP_List.DocNumber DESC"; SqlConnection conn = new SqlConnection(GlobalClass.SQLConnString()); conn.Open(); SqlCommand cmd = new SqlCommand(query, conn); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { //DocNum.Text = reader["DocNumber"].ToString(); //DateCreated.Text = reader["DateCreated"].ToString(); mrp_key = Convert.ToInt32(reader["PK"]); entitycode = reader["EntityCode"].ToString(); dateCreated = Convert.ToDateTime(reader["DateCreated"]); EntityCode.Text = reader["EntityCodeDesc"].ToString(); buCode = reader["BUCode"].ToString(); BUCode.Text = reader["BUCodeDesc"].ToString(); Month.Text = MRPClass.Month_Name(Int32.Parse(reader["MRPMonth"].ToString())); Year.Text = reader["MRPYear"].ToString(); Creator.Text = EncryptionClass.Decrypt(reader["Firstname"].ToString()) + " " + EncryptionClass.Decrypt(reader["Lastname"].ToString()); Status.Text = reader["StatusName"].ToString(); //Status.Text = reader["StatusName"].ToString(); } reader.Close(); conn.Close(); iStatusKey = MRPClass.MRP_Line_Status(mrp_key, wrkflwln); StatusHidden["hidden_preview_iStatusKey"] = iStatusKey; WrkFlowHidden["hidden_preview_wrkflwln"] = wrkflwln; //MRPClass.PrintString(entitycode); string docnum = DocNum.Text.ToString(); }
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); } //} }
private void Load_MRP(string docnumber) { string query = "SELECT tbl_MRP_List.*, " + " vw_AXEntityTable.NAME AS EntityCodeDesc, " + " vw_AXOperatingUnitTable.NAME AS BUCodeDesc, " + " tbl_MRP_Status.StatusName, tbl_Users.Lastname, " + " tbl_Users.Firstname, tbl_MRP_List.EntityCode, " + " tbl_MRP_List.BUCode " + " FROM tbl_MRP_List LEFT OUTER JOIN tbl_Users ON tbl_MRP_List.CreatorKey = tbl_Users.PK " + " LEFT OUTER JOIN vw_AXOperatingUnitTable ON tbl_MRP_List.BUCode = vw_AXOperatingUnitTable.OMOPERATINGUNITNUMBER " + " LEFT OUTER JOIN tbl_MRP_Status ON tbl_MRP_List.StatusKey = tbl_MRP_Status.PK " + " LEFT OUTER JOIN vw_AXEntityTable ON tbl_MRP_List.EntityCode = vw_AXEntityTable.ID " + " WHERE dbo.tbl_MRP_List.DocNumber = '" + docnumber + "' " + " ORDER BY dbo.tbl_MRP_List.DocNumber DESC"; SqlConnection conn = new SqlConnection(GlobalClass.SQLConnString()); conn.Open(); SqlCommand cmd = new SqlCommand(query, conn); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { //DocNum.Text = reader["DocNumber"].ToString(); //DateCreated.Text = reader["DateCreated"].ToString(); mrp_key = Convert.ToInt32(reader["PK"]); entitycode = reader["EntityCode"].ToString(); dateCreated = Convert.ToDateTime(reader["DateCreated"]); EntityCode.Text = reader["EntityCodeDesc"].ToString(); buCode = reader["BUCode"].ToString(); BUCode.Text = reader["BUCodeDesc"].ToString(); Month.Text = MRPClass.Month_Name(Int32.Parse(reader["MRPMonth"].ToString())); Year.Text = reader["MRPYear"].ToString(); Creator.Text = EncryptionClass.Decrypt(reader["Firstname"].ToString()) + " " + EncryptionClass.Decrypt(reader["Lastname"].ToString()); Status.Text = reader["StatusName"].ToString(); //Status.Text = reader["StatusName"].ToString(); } reader.Close(); conn.Close(); iStatusKey = MRPClass.MRP_Line_Status(mrp_key, wrkflwln); StatusHidden["hidden_preview_iStatusKey"] = iStatusKey; WrkFlowHidden["hidden_preview_wrkflwln"] = wrkflwln; //MRPClass.PrintString(entitycode); string docnum = DocNum.Text.ToString(); RevListView.DataSource = Preview.Preview_Revenue(docnum, entitycode); RevListView.DataBind(); TARevenue.InnerText = Preview.preview_total_revenue(docnum); SummaryListView.DataSource = Preview.MRP_PrevTotalSummary(DocNum.Text.ToString(), entitycode); SummaryListView.DataBind(); TotalSummary.InnerText = Preview.Prev_Summary_Total(); DMListView.DataSource = Preview.Preview_DM(DocNum.Text.ToString(), entitycode); DMListView.DataBind(); TotalDM.InnerText = Preview.preview_total_directmaterials(docnum); TotalEDM.InnerText = Preview.preview_requestedtotal_directmaterials(docnum); OpexListView.DataSource = Preview.Preview_OP(DocNum.Text.ToString(), entitycode); OpexListView.DataBind(); TotalOpex.InnerText = Preview.preview_total_opex(docnum); TotalEOpex.InnerText = Preview.preview_requestedtotal_opex(docnum); ManListView.DataSource = Preview.Preview_MAN(DocNum.Text.ToString(), entitycode); ManListView.DataBind(); TotalManpower.InnerText = Preview.preview_total_manpower(docnum); TotalEManpower.InnerText = Preview.preview_requestedtotal_manpower(docnum); CapexListView.DataSource = Preview.Preview_CA(docnum, entitycode); CapexListView.DataBind(); TotalCapex.InnerText = Preview.preview_total_capex(docnum); TotalECapex.InnerText = Preview.preview_requestedtotal_capex(docnum); }
protected void Submit_Click(object sender, EventArgs e) { CheckCreatorKey(); iStatusKey = MRPClass.MRP_Line_Status(mrp_key, wrkflwln); //if (wrkflwln == 0) //{ // if (iStatusKey == 1) // { // //MRPClass.Submit_MRP(docnumber.ToString(), mrp_key, wrkflwln + 1, entitycode, buCode, Convert.ToInt32(Session["CreatorKey"])); // PopupSubmit.ShowOnPageLoad = false; // 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"])); // Load_MRP(docnumber); // BindDirectMaterials(docnumber); // BindOpex(docnumber); // BindManPower(docnumber); // BindCapex(docnumber); // MRPNotificationMessage.Text = "Successfully Submitted"; // MRPNotify.HeaderText = "Info"; // MRPNotify.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; // //MRPNotify. // } //} //else //{ if (MRPClass.MRP_Line_Status(mrp_key, wrkflwln) == 0) { //MRPClass.Submit_MRP(docnumber.ToString(), mrp_key, wrkflwln + 1, entitycode, buCode, Convert.ToInt32(Session["CreatorKey"])); PopupSubmit.ShowOnPageLoad = false; //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"])); Load_MRP(docnumber); BindDirectMaterials(docnumber); BindOpex(docnumber); BindManPower(docnumber); BindCapex(docnumber); //BindRevenue(docnumber); MRPNotificationMessage.Text = "Successfully Submitted"; MRPNotify.HeaderText = "Info"; MRPNotify.ShowOnPageLoad = true; } else { ScriptManager.RegisterStartupScript(this.Page, typeof(string), "Resize", "changeWidth.resizeWidth();", true); MRPNotificationMessage.Text = "Document already submitted to Inventory Analyst for review."; MRPNotify.HeaderText = "Alert"; MRPNotify.ShowOnPageLoad = true; } //} }
private void Load_MRP(string docnumber) { ASPxHiddenField hidStatusKey = Page.FindControl("StatusKey") as ASPxHiddenField; string query = "SELECT tbl_MRP_List.*, " + " vw_AXEntityTable.NAME AS EntityCodeDesc, " + " vw_AXOperatingUnitTable.NAME AS BUCodeDesc, " + " tbl_MRP_Status.StatusName, tbl_Users.Lastname, " + " tbl_Users.Firstname, tbl_MRP_List.EntityCode, " + " tbl_MRP_List.BUCode " + " FROM tbl_MRP_List LEFT OUTER JOIN tbl_Users ON tbl_MRP_List.CreatorKey = tbl_Users.PK " + " LEFT OUTER JOIN vw_AXOperatingUnitTable ON tbl_MRP_List.BUCode = vw_AXOperatingUnitTable.OMOPERATINGUNITNUMBER " + " LEFT OUTER JOIN tbl_MRP_Status ON tbl_MRP_List.StatusKey = tbl_MRP_Status.PK " + " LEFT OUTER JOIN vw_AXEntityTable ON tbl_MRP_List.EntityCode = vw_AXEntityTable.ID " + " WHERE dbo.tbl_MRP_List.DocNumber = '" + docnumber + "' " + " ORDER BY dbo.tbl_MRP_List.DocNumber DESC"; SqlConnection conn = new SqlConnection(GlobalClass.SQLConnString()); conn.Open(); string firstname = "", lastname = ""; SqlCommand cmd = new SqlCommand(query, conn); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { mrp_key = Convert.ToInt32(reader["PK"].ToString()); entitycode = reader["EntityCode"].ToString(); DocNum.Text = reader["DocNumber"].ToString(); DateCreated.Text = reader["DateCreated"].ToString(); dateCreated = Convert.ToDateTime(reader["DateCreated"]); EntityCode.Text = reader["EntityCodeDesc"].ToString(); BUCode.Text = reader["BUCodeDesc"].ToString(); Month.Text = MRPClass.Month_Name(Int32.Parse(reader["MRPMonth"].ToString())); Year.Text = reader["MRPYear"].ToString(); Status.Text = reader["StatusName"].ToString(); iStatusKey = Convert.ToInt32(reader["StatusKey"]); firstname = reader["Firstname"].ToString(); lastname = reader["Lastname"].ToString(); entitycode = reader["EntityCode"].ToString(); Entity.Text = reader["EntityCode"].ToString(); BU.Text = reader["BUCode"].ToString(); buCode = reader["BUCode"].ToString(); Creator.Text = EncryptionClass.Decrypt(firstname) + " " + EncryptionClass.Decrypt(lastname); } reader.Close(); iStatusKey = MRPClass.MRP_Line_Status(mrp_key, wrkflwln); WorkFlowLineLbl.Text = wrkflwln.ToString(); WorkFlowLineTxt.Text = wrkflwln.ToString(); StatusKeyLbl.Text = iStatusKey.ToString(); StatusKeyTxt.Text = iStatusKey.ToString(); Creator.Text = EncryptionClass.Decrypt(firstname) + " " + EncryptionClass.Decrypt(lastname); DirectMaterialsRoundPanel.HeaderText = "[" + DocNum.Text.ToString().Trim() + "] Direct Materials"; OpexRoundPanel.HeaderText = "[" + DocNum.Text.ToString().Trim() + "] Operational Expense"; ManpowerRoundPanel.HeaderText = "[" + DocNum.Text.ToString().Trim() + "] Man Power"; CapexRoundPanel.HeaderText = "[" + DocNum.Text.ToString().Trim() + "] Capital Expenditure"; //ASPxPageControl pageControl = grid.FindEditFormTemplateControl("RevenuePageControl") as ASPxPageControl; ASPxHiddenField hfwrkLine = ASPxPageControl1.FindControl("ASPxHiddenFieldDMWrkFlwLnInventAnal") as ASPxHiddenField; ASPxHiddenField hfstatKey = ASPxPageControl1.FindControl("ASPxHiddenFieldDMStatusKeyInventAnal") as ASPxHiddenField; hfwrkLine["hidden_value"] = wrkflwln.ToString(); hfstatKey["hidden_value"] = iStatusKey.ToString(); }