protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string req_no = WebTools.GetExpr("PICKLING_REQ_NO", "PIP_PICKLING_SPL", " WHERE SPL_PICKLING_ID=" + Request.QueryString["SPL_PICKLING_ID"]);
Master.HeadingMessage = "Spool Pickling (" + req_no + ")";
HiddenSC.Value = WebTools.GetExpr("SC_ID", "PIP_PICKLING_SPL", " WHERE SPL_PICKLING_ID = '" + Request.QueryString["SPL_PICKLING_ID"] + "'");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string title = WebTools.GetExpr("ISO_TITLE1 || ' - ' || SHEET || ' - ' || SPOOL || ' - ' || 'P#' || PT_NO || ' - ' || MAT_CODE1",
"VIEW_BOM_TOTAL", "BOM_ID=" + Request.QueryString["BOM_ID"]);
Master.HeadingMessage = title + " Status";
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
HiddenField1.Value = WebTools.GetExpr("MAT_CODE1", "PIP_MAT_STOCK", " MAT_ID = '" + Request.QueryString["MAT_ID"] + "'");
Master.HeadingMessage = "LINE MTO<br/>";
Master.HeadingMessage += HiddenField1.Value;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Master.HeadingMessage = "PO Split Details (";
Master.HeadingMessage += WebTools.GetExpr("PO_NO", "PIP_PO", " WHERE PO_ID = '" + Request.QueryString["PO_ID"] + "'");
Master.HeadingMessage += ")";
}
}
protected void IssueGridView_ItemDataBound(object sender, Telerik.Web.UI.GridItemEventArgs e)
{
if (e.Item is GridDataItem)
{
GridDataItem item = (GridDataItem)e.Item;
string issue_id = item.GetDataKeyValue("ADD_ISSUE_ID").ToString();
string issue_no = WebTools.GetExpr("ISSUE_NO", "PIP_MAT_ISSUE_ADD", " ADD_ISSUE_ID = " + issue_id);
string filename = issue_no + ".pdf";
string pdf_url = WebTools.GetExpr("PATH", "DIR_OBJECTS", " PROJECT_ID = '" + Session["PROJECT_ID"].ToString() + "' AND DIR_OBJ = 'MAT_ISSUE'");
string pdf_asp_url = WebTools.GetExpr("ASP_PATH", "DIR_OBJECTS", " PROJECT_ID = '" + Session["PROJECT_ID"].ToString() + "' AND DIR_OBJ = 'MAT_ISSUE'");
string full_pdf_path = pdf_url + filename;
string full_asp_path = pdf_asp_url + filename;
Label pdf_label = (Label)item.FindControl("pdf");
if (File.Exists(full_pdf_path))
{
string url = "<a title='ISSUE PDF' href='" + full_asp_path + "' target='_blank'><img src='../Images/New-Icons/pdf.png'/></a>";
Label pdficon = (Label)item.FindControl("pdf");
if (pdficon != null)
{
pdficon.Text = url;
}
}
}
if (e.Item.IsInEditMode && e.Item is GridEditableItem)
{
string query = "SELECT * FROM USER_MODULE_COLUMNS WHERE NOT EXISTS (SELECT 1 FROM USER_MODULE_ROLES WHERE " +
" SEQ =USER_MODULE_COLUMNS.SEQ AND USER_ID IN (SELECT USER_ID FROM USERS WHERE USER_NAME ='" + Session["USER_NAME"] + "' )) AND HIDE_COL_NAME IS NOT NULL AND MODULE_ID =22 ";
DataTable dt = WebTools.getDataTable(query);
GridEditableItem dataItem = e.Item as GridEditableItem;
foreach (DataRow row in dt.Rows)
{
string hide_col = row["HIDE_COL_NAME"].ToString();
dataItem[hide_col].Enabled = false;
dataItem[hide_col].Controls[0].Visible = false;
}
string lbl_query = "SELECT * FROM USER_MODULE_COLUMNS WHERE NOT EXISTS (SELECT 1 FROM USER_MODULE_ROLES WHERE " +
" SEQ =USER_MODULE_COLUMNS.SEQ AND USER_ID IN (SELECT USER_ID FROM USERS WHERE USER_NAME ='" + Session["USER_NAME"] + "' )) AND LBL_COL_NAME IS NOT NULL AND MODULE_ID =22";
DataTable lbl_dt = WebTools.getDataTable(lbl_query);
Label[] descLabel = new Label[30];
int i = 0;
foreach (DataRow row in lbl_dt.Rows)
{
string lbl_col = row["LBL_COL_NAME"].ToString();
string str = (dataItem[lbl_col].Controls[0] as TextBox).Text;
descLabel[i] = new Label();
descLabel[i].Text = str;
dataItem[lbl_col].Controls.Add(descLabel[i]);
i++;
}
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
string result2;
result2 = WebTools.GetExpr(
"FNC_INSERT_SUPP_BOM_JC(" + Request.QueryString["JC_ID"] + ")", "DUAL", "");
Response.Redirect("Supp_JobCard.aspx");
}
protected void ddlMatCode_SelectedIndexChanged(object sender, RadComboBoxSelectedIndexChangedEventArgs e)
{
if (ddlMatCode.SelectedValue != "")
{
txtMatDescr.Text = WebTools.GetExpr("MAT_DESCR", "PIP_MAT_STOCK", " WHERE MAT_ID='" + ddlMatCode.SelectedValue + "'");
string sub_con_id = WebTools.GetExpr("SC_ID", "PIP_MAT_ISSUE_ADD", " WHERE ADD_ISSUE_ID='" + Request.QueryString["ADD_ISSUE_ID"] + "'");
txtAvlQty.Text = WebTools.GetExpr("BAL_QTY", "VIEW_ITEM_REP_A", " WHERE MAT_ID='" + ddlMatCode.SelectedValue + "' and sub_con_id = '" + sub_con_id + "'");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Master.HeadingMessage = "Quarantine Details";
Master.HeadingMessage += "<br/>";
Master.HeadingMessage += WebTools.GetExpr("QRNTINE_NO", "PIP_QUARANTINE", " WHERE QRNTINE_ID='" + Request.QueryString["id"].ToString() + "'");
}
}
protected void btnRunSimulation_Click(object sender, EventArgs e)
{
if (CollectSubCons())
{
if (sml_status.Equals("RUNNING"))
{
Master.ShowWarn("Ooops... Simulation is already running !!!");
return;
}
btnSaveSettings_Click(sender, e);
try
{
//CHECK status of
//1. PO link
//2. Line MTO simulation
//3. Updae server status
//if not running then proceed
string po_status = "", any_update_running = "";
po_status = WebTools.GetExpr("CURRENT_STATUS", "PROJECT_JOB_LIST", "PROCESS_NAME='IMPORT_PO_DATA'");
any_update_running = WebTools.CountExpr("PROCESS_NAME", "PROJECT_JOB_LIST", "PROCESS_GROUP='SERVER_UPDATE' AND CURRENT_STATUS='RUNNING'");
//If IDF simulation and PO, both are completed
if (!po_status.Equals("RUNNING") && any_update_running.Equals("0"))
{
string sql = "";
WebTools.ExeSql("UPDATE PROJECT_JOB_LIST SET CURRENT_STATUS='RUNNING' WHERE PROCESS_NAME='SITE_SIMULATION'");
sql = WebTools.GetExpr("SQL_TO_RUN", "PROJECT_JOB_LIST", " PROCESS_NAME='SITE_SIMULATION'");
WebTools.ExeSql(sql);
Master.ShowSuccess("You request for Site simulation has started !!!");
}
//If bom simulation is not running
else
{
WebTools.ExeSql("UPDATE PROJECT_JOB_LIST SET CURRENT_STATUS='REQUEST_TO_RUN' WHERE PROCESS_NAME='SITE_SIMULATION'");
Master.ShowSuccess("You request for Simulation process is waiting to run!!!");
}
//Response.Redirect("~/UTILITIES/Amogh_Utilities.aspx");
//UpateProgressContext();
}
catch (Exception exc)
{
if (exc.Message.Contains("ORA-27478"))
{
Master.ShowWarn("Site simulation is already running !!!");
}
else
{
Master.ShowWarn(exc.Message);
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string nde_req = WebTools.GetExpr("NDE_REQ_NO", "PIP_NDE_REQUEST", "NDE_REQ_ID=" + Request.QueryString["NDE_REQ_ID"]);
Master.HeadingMessage("Joint NDE Request : " + nde_req);
Update_JointsDropDown();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
scIdField.Value = WebTools.GetExpr("SUB_CON_ID", "PIP_FCRI", "FCRI_ID=" + Request.QueryString["FCRI_ID"]);
string rel_no = WebTools.GetExpr("FCRI_NO", "PIP_FCRI", "FCRI_ID=" + Request.QueryString["FCRI_ID"]);
Master.HeadingMessage = "Spools <br/>" + rel_no;
}
}
protected void cboMM_SELECTedIndexChanged(object sender, EventArgs e)
{
if (cboBOM.SelectedValue.ToString() != "-1")
{
string net_qty = WebTools.GetExpr("NET_QTY", "PIP_BOM", " WHERE BOM_ID=" +
cboBOM.SelectedValue.ToString());
//txtIssuedQty.Text = net_qty;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Master.HeadingMessage("Spool Receive Detail" + "<br/>" + WebTools.GetExpr("RCV_NO", "PIP_SPL_RECEIVE", " WHERE RCV_ID=" + Request.QueryString["id"]));
HiddenStoreID.Value = WebTools.GetExpr("STORE_ID", "PIP_SPL_RECEIVE", " WHERE RCV_ID=" + Request.QueryString["id"]);
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
if (cboStore.SelectedValue.ToString().Equals("-1"))
{
txtReportNo.Text = "";
Master.ShowWarn("Please select a store !");
return;
}
string sql = string.Empty;
string po_id = ddlPOList.SelectedValue;
if (ddlPOList.SelectedValue == "-11")
{
sql = "INSERT INTO PIP_PO (PROJECT_ID, PO_NO, PO_TITLE, PO_DATE, PO_REV, MANUFACTURE, CREATE_BY) VALUES ";
sql += " ('" + Session["PROJECT_ID"].ToString() + "', '" + txtPO.Text + "', '" + txtItemDescr.Text + "','" + System.DateTime.Today.ToString("dd-MMM-yyyy") + "',";
sql += " '0', '" + txtSupplier.Text + "', '" + Session["USER_NAME"] + "')";
WebTools.ExeSql(sql);
po_id = WebTools.GetExpr("PO_ID", "PIP_PO", " WHERE PO_NO='" + txtPO.Text + "'");
}
sql = "INSERT INTO PIP_MAT_RECEIVE (PROJECT_ID,MAT_RCV_NO,RECV_DATE,RECV_BY,SHIP_NO,STORE_ID, PO_ID, ITEM_DESCR, SUPPLIER)" +
" VALUES (" + Session["PROJECT_ID"].ToString() + ",'" +
txtReportNo.Text + "','" + txtCreateDate.SelectedDate.Value.ToString("dd-MMM-yyyy") + "','" +
txtRecvby.Text + "','" + txtShipNo.Text + "'," + cboStore.SelectedValue.ToString() +
",'" + po_id + "', '" + txtItemDescr.Text + "', '" + txtSupplier.Text + "')";
try
{
General_Functions.ExeSql(sql);
string mrv_id = WebTools.GetExpr("MAT_RCV_ID", "PIP_MAT_RECEIVE", " WHERE MAT_RCV_NO = '" + txtReportNo.Text + "'");
if (!string.IsNullOrEmpty(mrv_id.Trim()))
{
for (int i = 0; i < txtAutoSRNNo.Entries.Count; i++)
{
sql = "INSERT INTO PIP_MAT_RECEIVE_SRN (MRV_ID, SRN_NO) VALUES ('" + mrv_id + "', '" + txtAutoSRNNo.Entries[i].Text + "')";
WebTools.ExeSql(sql);
}
}
Master.ShowMessage("MRV created successfully.");
}
catch (Exception ex)
{
string mrv_id = WebTools.GetExpr("MAT_RCV_ID", "PIP_MAT_RECEIVE", " WHERE MAT_RCV_NO = '" + txtReportNo.Text + "'");
//string sql = string.Empty;
if (!string.IsNullOrEmpty(mrv_id.Trim()))
{
//reset ---- in case of any error
sql = "DELETE FROM PIP_MAT_RECEIVE_SRN WHERE MRV_ID = '" + mrv_id + "'";
WebTools.ExeSql(sql);
sql = "DELETE FROM PIP_MAT_RECEIVE WHERE MAT_RCV_ID = '" + mrv_id + "'";
WebTools.ExeSql(sql);
}
Master.ShowWarn(ex.Message);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Master.HeadingMessage = "MRV Import <br/>";
Master.HeadingMessage += WebTools.GetExpr("MAT_RCV_NO", "PIP_MAT_RECEIVE", " WHERE MAT_RCV_ID='" + Request.QueryString["MAT_RCV_ID"] + "'");
HiddenPOID.Value = WebTools.GetExpr("PO_ID", "PIP_MAT_RECEIVE", " WHERE MAT_RCV_ID='" + Request.QueryString["MAT_RCV_ID"] + "'");
//Master.HeadingMessage += ")";
}
}
protected void SetPPCSRunning()
{
string status = WebTools.GetExpr("CURRENT_STATUS", "PROJECT_JOB_LIST", " PROCESS_NAME = 'IMPORT_PO_DATA'");
if (status == "RUNNING")
{
menuUpdPOLink.Items[0].Text = "Processing";
menuUpdPOLink.Items[0].Enabled = false;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Master.HeadingMessage = "Material Requisition<br/>";
Master.HeadingMessage += WebTools.GetExpr("MR_NO", "PIP_MAT_REQUISITION", " MR_ID='" + Request.QueryString["MR_ID"] + "'");
Master.AddModalPopup("~/Material/MRItemAdd.aspx?MR_ID=" + Request.QueryString["MR_ID"], btnAdd.ClientID, 450, 650);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Master.HeadingMessage = "Material Substitution Request<br/>";
Master.HeadingMessage += WebTools.GetExpr("REQ_NO", "PIP_MAT_SUBSTITUTE", " REQ_ID='" + Request.QueryString["REQ_ID"].ToString() + "'");
Master.AddModalPopup("~/Material/MaterialSubstitutionItemNew.aspx?REQ_ID=" + Request.QueryString["REQ_ID"], btnAdd.ClientID, 450, 650);
Master.RadGridList = itemsGridDetail.ClientID;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string heading = "Add Contact Detail - ";
heading += WebTools.GetExpr("VENDOR_NAME", "VENDOR_MASTER", " VENDOR_ID='" + Request.QueryString["Arg1"] + "'");
Master.HeadingMessage(heading);
}
}
protected void ddlSubcon_SelectedIndexChanged(object sender, Telerik.Web.UI.DropDownListEventArgs e)
{
string job_code = WebTools.GetExpr("JOB_CODE", "PROJECT_INFORMATION", " PROJECT_ID ='" + Session["PROJECT_ID"].ToString() + "'");
string prefix = job_code + "-MRIR-" + WebTools.GetExpr("SHORT_NAME", "SUB_CONTRACTOR", " SUB_CON_ID='" + ddlSubcon.SelectedValue + "'");
prefix = prefix + "-";
txtMIRNo.Text = WebTools.NextSerialNo("PRC_MAT_INSP", "MIR_NO", prefix, 4, " WHERE MRIR_SC_ID='" + ddlSubcon.SelectedValue + "'");
ddlMRVList.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Master.HeadingMessage = "Additional Mat - BOM <br/>" +
WebTools.GetExpr("ISSUE_NO", "PIP_MAT_ISSUE_ADD", "ADD_ISSUE_ID=" + Request.QueryString["ADD_ISSUE_ID"]);
scidField.Value = WebTools.GetExpr("SC_ID", "PIP_MAT_ISSUE_ADD", "ADD_ISSUE_ID=" + Request.QueryString["ADD_ISSUE_ID"]);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string heading = "Add Reserve Items (";
heading += WebTools.GetExpr("MAT_RES_NO", "MAT_RESERVE", " MAT_RES_ID = '" + Request.QueryString["REQ_ID"] + "'");
heading += ")";
Master.HeadingMessage(heading);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string miv_no = WebTools.GetExpr("ISSUE_NO", "PIP_MAT_ISSUE_WO", " WHERE ISSUE_ID=" +
Request.QueryString["ISSUE_ID"]);
Master.HeadingMessage = "Not in Cutting-Plan <br/>" + miv_no;
}
}
private void set_req_no()
{
string prefix = WebTools.GetExpr("JOB_CODE", "PROJECT_INFORMATION", " WHERE PROJECT_ID='" + Session["PROJECT_ID"] + "'");
string sc_id = ddFrom.SelectedValue;
prefix += "-";
prefix += WebTools.GetExpr("SHORT_NAME", "SUB_CONTRACTOR", " WHERE SUB_CON_ID = '" + sc_id + "'");
prefix += "-MAT-REQ-";
txtRequestNo.Text = WebTools.NextSerialNo("MATERIAL_REQUEST", "MAT_REQ_NO", prefix, 4, " PROJECT_ID=" + Session["PROJECT_ID"].ToString() + " AND REQ_FROM='" + ddFrom.SelectedValue + "'");
}
protected void SerialNumber(string store_id)
{
string sc_id = WebTools.GetExpr("SC_ID", "STORES_DEF", " WHERE STORE_ID=" + store_id);
string prefix = WebTools.GetExpr("JOB_CODE", "PROJECT_INFORMATION", " WHERE PROJECT_ID='" + Session["PROJECT_ID"].ToString() + "'");
prefix += "-RFI-";
prefix += WebTools.GetExpr("SHORT_NAME", "SUB_CONTRACTOR", " WHERE SUB_CON_ID IN (SELECT SC_ID FROM STORES_DEF WHERE STORE_ID = '" + store_id + "')");
prefix += "-";
txtRFINo.Text = WebTools.NextSerialNo("PIP_MAT_INSP_REQUEST", "RFI_NO", prefix, 4, " WHERE STORE_ID IN (SELECT STORE_ID FROM STORES_DEF WHERE SC_ID=" + sc_id + ")");
}
protected void txtAutoMatCode_TextChanged(object sender, Telerik.Web.UI.AutoCompleteTextEventArgs e)
{
string matcode = txtAutoMatCode.Text;
if (!string.IsNullOrEmpty(matcode.Trim()))
{
string mat_id = WebTools.GetExpr("MAT_ID", "PIP_MAT_STOCK", " WHERE MAT_CODE1 = '" + matcode + "'");
Response.Redirect("MaterialStock_Recon_A.aspx?MAT_ID=" + mat_id);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string heading = WebTools.GetExpr("MIR_NO", "PRC_MAT_INSP", " MIR_ID='" + Session["popUp_MIR_ID"].ToString() + "'");
heading += " : PO Item : ";
heading += WebTools.GetExpr("PO_ITEM", "PRC_MAT_INSP_DETAIL", " MIR_ITEM_ID='" + Session["popUp_MIR_ITEM_ID"].ToString() + "'");
Master.HeadingMessage(heading);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string po = WebTools.GetExpr("PO_NO", "PIP_PO", " PO_ID = '" + Session["PO_ID"].ToString() + "'");
Master.HeadingMessage = "Inspection of Bought Out Items - " + po;
Master.AddModalPopup("~/Procurement/PO_BoughtOutItemsAdd.aspx", btnAdd.ClientID, 450, 650);
Master.RadGridList = RadGrid1.ClientID;
}
}
protected void ddlSubcon_SelectedIndexChanged(object sender, Telerik.Web.UI.DropDownListEventArgs e)
{
string prefix = WebTools.GetExpr("JOB_CODE", "PROJECT_INFORMATION", " WHERE PROJECT_ID='" + Session["PROJECT_ID"] + "'");
string sc_id = ddlSubcon.SelectedValue;
prefix += "-";
prefix += WebTools.GetExpr("SHORT_NAME", "SUB_CONTRACTOR", " WHERE SUB_CON_ID = '" + sc_id + "'");
prefix += "-QRNT-";
txtQuarantineNo.Text = WebTools.NextSerialNo("PIP_QUARANTINE", "QRNTINE_NO", prefix, 4, " PROJECT_ID=" + Session["PROJECT_ID"].ToString() + " AND SC_ID='" + ddlSubcon.SelectedValue + "'");
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string type_id = Request.QueryString["TYPE_ID"];
string trans = WebTools.GetExpr("TRANS_TYPE", "TPK_TRANS_TYPE", " WHERE TYPE_ID=" + type_id);
Master.HeadingMessage(trans);
set_trans_no();
}
}