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();
}
