private void Load_MRP(string docnum) { //string query = "SELECT TOP (100) PERCENT dbo.tbl_MRP_List.PK, dbo.tbl_MRP_List.DocNumber, " + // " dbo.tbl_MRP_List.DateCreated, dbo.tbl_MRP_List.EntityCode, dbo.vw_AXEntityTable.NAME AS EntityCodeDesc, " + // " dbo.tbl_MRP_List.BUCode, dbo.vw_AXOperatingUnitTable.NAME AS BUCodeDesc, dbo.tbl_MRP_List.MRPMonth, " + // " dbo.tbl_MRP_List.MRPYear, dbo.tbl_MRP_List.StatusKey, dbo.tbl_MRP_Status.StatusName, " + // " dbo.tbl_MRP_List.CreatorKey, dbo.tbl_MRP_List.LastModified " + // " FROM dbo.tbl_MRP_List LEFT OUTER JOIN " + // " dbo.vw_AXOperatingUnitTable ON dbo.tbl_MRP_List.BUCode = dbo.vw_AXOperatingUnitTable.OMOPERATINGUNITNUMBER LEFT OUTER JOIN " + // " dbo.tbl_MRP_Status ON dbo.tbl_MRP_List.StatusKey = dbo.tbl_MRP_Status.PK LEFT OUTER JOIN " + // " dbo.vw_AXEntityTable ON dbo.tbl_MRP_List.EntityCode = dbo.vw_AXEntityTable.ID " + // " WHERE(dbo.tbl_MRP_List.DocNumber = '" + DocNum.Text.ToString().Trim() + "') " + // " ORDER BY dbo.tbl_MRP_List.DocNumber DESC"; 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 = '" + docnum + "' " + " 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(); dateCreated = Convert.ToDateTime(reader["DateCreated"]); mrp_key = Convert.ToInt32(reader["PK"]); entitycode = reader["EntityCode"].ToString(); 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(); //Status.Text = reader["StatusName"].ToString(); Creator.Text = EncryptionClass.Decrypt(reader["Firstname"].ToString()) + " " + EncryptionClass.Decrypt(reader["Lastname"].ToString()); Status.Text = reader["StatusName"].ToString(); } reader.Close(); conn.Close(); iStatusKey = MRPClass.MRP_ApprvLine_Status(mrp_key, appflwln); StatusHidden["hidden_preview_iStatusKey"] = iStatusKey; WorkLineHidden["hidden_preview_wrkflwln"] = appflwln; BindAll(); }
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; //} }