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;
//}
}
