protected string set_current_page_settings()
{
string query = "UPDATE SIMULATION_SETTING SET "
+ " SML_CAT='SITE'"
+ ", SITE_SML_TIME=TO_CHAR(SYSDATE,'dd-Mon-yyyy HH:MI AM')"
+ ", SITE_SML_USER='******'"
+ ", DWG_STATUS='" + rdoDwgStatus.SelectedValue + "'"
+ ", ON_SFR_FIRST='" + rdoSpoolSFR.SelectedValue + "'"
+ ", ON_SELECTED_ISOME='" + rdoSelectedIsome.SelectedValue + "'"
+ ", AGUG='" + rdoAGUG.SelectedValue + "'"
+ ", SML_PRIORITY='" + rdoPriority.SelectedValue + "'"
+ ", EXCLUDE_HOLD='" + rdoHoldStatus.SelectedValue + "'"
+ ", MATERIAL_SOURCE='" + rdoMaterialSource.SelectedValue + "'"
+ ", USE_COMMON_STORE='" + rdoUseCommonStore.SelectedValue + "'";
try
{
WebTools.ExeSql(query);
}
catch (Exception exc)
{
return("<font color='red'>Something went wrong <br/>" + exc.Message + "</font>");
}
return("Settings saved !");
}
protected void btnDeleteAll_Click(object sender, EventArgs e)
{
if (grdMRIRItems.SelectedIndexes.Count == 0)
{
Master.ShowMessage("Select Material to Delete.");
return;
}
string MIR_ITEM_ID = "";
string sql = string.Empty;
try
{
foreach (GridDataItem item in grdMRIRItems.SelectedItems)
{
MIR_ITEM_ID = item["MIR_ITEM_ID"].Text;
sql = WebTools.ExeSql("DELETE FROM PRC_MAT_INSP_DETAIL WHERE MIR_ITEM_ID=" + MIR_ITEM_ID);
Master.ShowSuccess("Successfully Deleted all Items");
grdMRIRItems.Rebind();
}
}
catch (Exception ex)
{
Master.ShowError(ex.Message);
}
}
protected void btnSaveErec_Click(object sender, EventArgs e)
{
if (rowsGridView.SelectedIndex < 0)
{
Master.ShowMessage("Select the support!");
return;
}
//if (txtErecDate.Text == string.Empty || txtErecReportNo.Text == string.Empty)
if (txtErecDate.Text == string.Empty)
{
Master.ShowWarn("Enter Erection date!");
return;
}
try
{
WebTools.ExeSql("UPDATE PIP_BOM SET EREC_DATE='" +
txtErecDate.Text + "' WHERE BOM_ID=" + rowsGridView.SelectedValue.ToString());
rowsGridView.DataBind();
Master.ShowMessage("Erection Date Updated!");
}
catch (Exception ex)
{
Master.ShowWarn(ex.Message);
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
VIEW_SITE_JCTableAdapter issue = new VIEW_SITE_JCTableAdapter();
try
{
int result = issue.InsertQuery(txtIssueNumber.Text,
txtIssueDate.SelectedDate,
txtIssuedBy.Text,
Decimal.Parse(Session["PROJECT_ID"].ToString()),
decimal.Parse(cboSubcon.SelectedValue.ToString()), decimal.Parse(cboMatSubcon.SelectedValue.ToString()),
txtArea.Text,
txtMaterialType.Text,
txtRemarks.Text, checkJCType.SelectedItem.Text);
if (result > 0)
{
DateTime rev_date = DateTime.Parse(txtRevDate.SelectedDate.ToString());
string sql = "UPDATE PIP_MAT_ISSUE_LOOSE SET JC_REV='" + txtJC_REV.Text + "', REV_DATE='" + rev_date.ToString("dd-MMM-yyyy") + "'";
sql += " WHERE ISSUE_NO = '" + txtIssueNumber.Text + "'";
WebTools.ExeSql(sql);
}
Master.ShowSuccess("Site Job Card " + txtIssueNumber.Text + " created successfully.");
}
catch (Exception ex)
{
Master.ShowError(ex.Message);
}
finally
{
issue.Dispose();
}
}
protected void btnNarrative_Click(object sender, EventArgs e)
{
string query = "UPDATE DASHBOARD_NARRATIVE SET TEXT='" + txtNarrative.Text + "' WHERE LABEL='FLANGE_NARRATIVE'";
WebTools.ExeSql(query);
//Master.ShowError(query+" "+txt);
}
//protected void btnBulkImport_Click(object sender, EventArgs e)
// {
// Response.Redirect("~/BulkImport/BulkReportImport.aspx?IMPORT_ID=12&RetUrl=~/Procurement/POBatchPlan.aspx");
// }
protected void ddlStatus_SelectedIndexChanged(object sender, Telerik.Web.UI.DropDownListEventArgs e)
{
if (ddlStatus.SelectedValue != "")
{
if (!WebTools.UserInRole("BATCH_ADMIN"))
{
RadWindowManager1.RadAlert("Access denied.", 300, 150, "Warning", "");
return;
}
if (itemsGrid.SelectedIndexes.Count == 0)
{
Master.ShowWarn("Please select a record to continue.");
return;
}
try
{
string batch_id = itemsGrid.SelectedValue.ToString();
string sql = "UPDATE PIP_PO_BATCH_PLAN SET STATUS='" + ddlStatus.SelectedValue + "' WHERE BATCH_ID=" + batch_id;
WebTools.ExeSql(sql);
RadWindowManager1.RadAlert("Batch Status Updated.", 300, 150, "Success", "");
}
catch (Exception ex)
{
Master.ShowError(ex.Message);
}
itemsGrid.Rebind();
ddlStatus.DataBind();
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (SPL_ListBoxDestination.Items.Count == 0)
{
Master.ShowMessage("No Spools selected!");
return;
}
try
{
for (int i = 0; i < SPL_ListBoxDestination.Items.Count; i++)
{
WebTools.ExeSql("UPDATE PIP_SPOOL SET NDE_CMPLT='" + txtClearDate.SelectedDate.Value.ToString("dd-MMM-yyyy") +
"', NDE_CMPLT_BY='" + Session["USER_NAME"].ToString() +
"' WHERE SPL_ID=" + SPL_ListBoxDestination.Items[i].Value.ToString());
}
Master.ShowMessage("NDE Date updated for selected spools!");
}
catch (Exception ex)
{
Master.ShowMessage(ex.Message);
}
finally
{
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
PIP_WPS_NOTableAdapter wps = new PIP_WPS_NOTableAdapter();
string wps_id = string.Empty;
string sql = string.Empty;
try
{
wps.InsertQuery(decimal.Parse(Session["PROJECT_ID"].ToString()), decimal.Parse(cboSubcon.SelectedValue.ToString()),
txtWPS1.Text, txtWPS2.Text, txtRevision.Text, cboMatList.SelectedValue, cboProcessList.SelectedValue, radPWHTList.SelectedValue,
decimal.Parse(txtSizeFrom.Text), decimal.Parse(txtSizeTo.Text), decimal.Parse(txtThkFrom.Text),
decimal.Parse(txtThkTo.Text), cboConnA.SelectedValue.ToString(), cboConnB.SelectedValue.ToString(),
"", txtRemarks.Text, AllsubconRadioButton.SelectedValue);
wps_id = WebTools.GetExpr("WPS_ID", "PIP_WPS_NO", " WHERE WPS_NO1 = '" + txtWPS1.Text + "'");
for (int i = 0; i < cboPipeClass.Items.Count; i++)
{
if (cboPipeClass.Items[i].Checked)
{
sql = "INSERT INTO PIP_WPS_SPEC (WPS_ID, CLASS) VALUES ('" + wps_id + "', '" + cboPipeClass.Items[i].Text + "')";
WebTools.ExeSql(sql);
}
}
Master.ShowMessage("WPS Created successfully!");
}
catch (Exception ex)
{
Master.ShowWarn(ex.Message);
}
}
protected void btnDeleteAll_Click(object sender, EventArgs e)
{
if (itemsGrid.SelectedIndexes.Count == 0)
{
Master.ShowMessage("Select Material to Delete.");
return;
}
string RCV_ITEM_ID = "";
string sql = string.Empty;
try
{
foreach (GridDataItem item in itemsGrid.SelectedItems)
{
RCV_ITEM_ID = item["RCV_ITEM_ID"].Text;
sql = WebTools.ExeSql("DELETE FROM PIP_MAT_TRANSFER_RCV_DT WHERE RCV_ITEM_ID=" + RCV_ITEM_ID);
Master.ShowSuccess("Successfully Deleted Selected Items");
itemsGrid.Rebind();
}
}
catch (Exception ex)
{
Master.ShowError(ex.Message);
}
}
protected void btnDeleteAll_Click(object sender, EventArgs e)
{
if (itemsGridView.SelectedIndexes.Count == 0)
{
Master.ShowMessage("Select Material to Delete.");
return;
}
string ADD_ISSUE_ID = "";
string MAT_ID = "";
string HEAT_NO = "";
string CABLE_DRUM_NO = "";
string sql = string.Empty;
try
{
foreach (GridDataItem item in itemsGridView.SelectedItems)
{
ADD_ISSUE_ID = item["ADD_ISSUE_ID"].Text;
MAT_ID = item["MAT_ID"].Text;
HEAT_NO = item["HEAT_NO"].Text;
CABLE_DRUM_NO = item["CABLE_DRUM_NO"].Text;
sql = WebTools.ExeSql("DELETE FROM PIP_MAT_ISSUE_ADD_DETAIL WHERE ADD_ISSUE_ID='" + ADD_ISSUE_ID + "' AND MAT_ID='" + MAT_ID + "' AND HEAT_NO='" + HEAT_NO + "' AND CABLE_DRUM_NO='" + CABLE_DRUM_NO + "'");
Master.ShowSuccess("Successfully Deleted Selected Items");
itemsGridView.Rebind();
}
}
catch (Exception ex)
{
Master.ShowError(ex.Message);
}
}
protected void btnSavePaint_Click(object sender, EventArgs e)
{
if (spoolGridView.SelectedIndexes.Count == 0)
{
Master.ShowMessage("Select the support!");
return;
}
if (txtPaintDate.Text == string.Empty || txtPaintReportNo.Text == string.Empty)
{
Master.ShowWarn("Enter Paint report no and date!");
return;
}
try
{
WebTools.ExeSql("UPDATE PIP_SUPP_JC_DETAIL SET PAINT_REP_NO='" +
txtPaintReportNo.Text +
"', PAINT_DATE='" + txtPaintDate.Text +
"' WHERE BOM_ID=" + spoolGridView.SelectedValue.ToString());
spoolGridView.DataBind();
Master.ShowMessage("Paint Report No Updated!");
}
catch (Exception ex)
{
Master.ShowWarn(ex.Message);
}
}
protected void btnDeleteAll_Click(object sender, EventArgs e)
{
if (!WebTools.UserInRole("MM_DELETE_ALL"))
{
RadWindowManager1.RadAlert("Access denied.", 300, 150, "Warning", "");
return;
}
if (itemsGrid.SelectedIndexes.Count == 0)
{
Master.ShowMessage("Select Material to Delete.");
return;
}
string IRN_ITEM_ID = "";
string sql = string.Empty;
try
{
foreach (GridDataItem item in itemsGrid.SelectedItems)
{
IRN_ITEM_ID = item["IRN_ITEM_ID"].Text;
sql = WebTools.ExeSql("DELETE FROM PIP_PO_IRN_DETAIL WHERE IRN_ITEM_ID=" + IRN_ITEM_ID);
}
Master.ShowSuccess("Successfully Deleted Selected Items");
itemsGrid.Rebind();
}
catch (Exception ex)
{
Master.ShowError(ex.Message);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
string sql;
//Update nde status
sql = "INSERT INTO PIP_NDE_REQUEST_SEGMENT(NDE_ITEM_ID, RT_SEGMENT, RT_DEFECT, REPAIR_LEN, REPAIR_WELDER_ID, PASS_FLG_ID) VALUES(";
sql += HiddenNDE_ITEM_ID.Value + ",'" + txtRT_Segment.Text.Trim() + "','" + ddDefect.SelectedItem.Value.ToString() + "',";
sql += (txtRepairLen.Text.Length > 0 ? txtRepairLen.Text : "NULL") + ",";
sql += (ddWelder.SelectedValue.ToString() != "-1" ? ddWelder.SelectedValue.ToString() : "NULL") + ",";
sql += (ddPassFlag.SelectedValue.ToString() != "-1" ? ddPassFlag.SelectedValue.ToString() : "NULL");
sql += ")";
try
{
WebTools.ExeSql(sql);
RadGrid1.DataBind();
Master.show_success(txtRT_Segment.Text + " Saved!");
}
catch (Exception ex)
{
Master.show_error(ex.Message);
}
}
protected void btnSubmit_Click1(object sender, EventArgs e)
{
try
{
if (txtPassword.Text.Length == 0)
{
Master.show_error("No Password provided!");
return;
}
else if (txtPassword.Text.Length < 5)
{
Master.show_error("Minimum Password Length is 5!");
return;
}
else if (txtPassword.Text != txtPasswordConfirm.Text)
{
Master.show_error("Password does not match!");
return;
}
WebTools.ExeSql("UPDATE USERS SET PASSKEY='" + WebTools.MD5Str(txtPassword.Text) +
"' WHERE PROJECT_ID=" + Session["PROJECT_ID"].ToString() + " AND USER_NAME='" + Session["USER_NAME"].ToString() + "'");
Master.show_success("Password Changed!");
}
catch (Exception ex)
{
Master.show_error(ex.Message);
}
finally
{
}
}
protected string Register()
{
string trans_id = string.Empty;
string to_sc_id = WebTools.GetExpr("SC_ID", "PIP_COATING_JC", " WHERE JC_ID = '" + Request.QueryString["JC_ID"] + "'");
string from_sc_id = WebTools.GetExpr("FROM_SC", "PIP_COATING_JC", " WHERE JC_ID = '" + Request.QueryString["JC_ID"] + "'");
string prefix = WebTools.GetExpr("JOB_CODE", "PROJECT_INFORMATION", " WHERE PROJECT_ID = '" + Session["PROJECT_ID"].ToString() + "'");
prefix += "-";
prefix += WebTools.GetExpr("SHORT_NAME", "SUB_CONTRACTOR", " WHERE SUB_CON_ID = '" + from_sc_id + "'");
prefix += "-SPL-TRANS-";
string trans_no = WebTools.NextSerialNo("PIP_SPL_TRANSFER", "TRANS_NO", prefix, 4, " WHERE FROM_SC = '" + from_sc_id + "'");
string sql = "INSERT INTO PIP_SPL_TRANSFER (PROJECT_ID, TRANS_NO, TRANS_DATE, TRANS_BY, FROM_SC, TO_SC, TRANSFER_REASON, REMARKS) VALUES ";
sql += " (1, '" + trans_no + "', '" + System.DateTime.Today.ToString("dd-MMM-yyyy") + "', '" + Session["USER_NAME"] + "', " + from_sc_id;
sql += ", " + to_sc_id + ", 'FOR COATING', '')";
WebTools.ExeSql(sql);
trans_id = WebTools.GetExpr("TRANS_ID", "PIP_SPL_TRANSFER", " WHERE TRANS_NO = '" + trans_no + "'");
//register document number
string doc = WebTools.GetExpr("COAT_JC_NO", "PIP_COATING_JC", " WHERE JC_ID='" + Request.QueryString["JC_ID"] + "'");
sql = "INSERT INTO PIP_SPL_TRANSFER_DOC (TRANS_ID, DOC_REF_NO) VALUES ('" + trans_id + "', '" + doc + "')";
WebTools.ExeSql(sql);
return(trans_id);
}
protected void btnSavePaint_Click(object sender, EventArgs e)
{
if (spoolGridView.SelectedIndex < 0)
{
Master.ShowMessage("Select the spool!");
return;
}
if (txtPaintDate.IsEmpty)
{
Master.ShowWarn("Select Hot Dip Date!");
txtPaintDate.Focus();
return;
}
try
{
WebTools.ExeSql("UPDATE PIP_SPOOL SET HOT_DIP_DATE='" + txtPaintDate.SelectedDate.Value.ToString("dd-MMM-yyyy") + "' WHERE SPL_ID=" + spoolGridView.SelectedValue.ToString());
spoolGridView.DataBind();
Master.ShowMessage("Hot Dip Updated!");
}
catch (Exception ex)
{
Master.ShowWarn(ex.Message);
}
}
protected void btnDelete_Click(object sender, EventArgs e)
{
string sql = "DELETE FROM TBL_IDF_MTO WHERE ISO_TITLE IN (SELECT ISO_TITLE FROM VIEW_UNREGIS_IDF)";
WebTools.ExeSql(sql);
RadGrid1.Rebind();
}
protected void btnSetFlagCmplt_Click(object sender, EventArgs e)
{
WebTools.ExeSql("UPDATE PROJECT_JOB_LIST SET CURRENT_STATUS='COMPLETED'");
WebTools.ExeSql("UPDATE SIMULATION_HEADER SET STATUS='PS' WHERE STATUS<>'PS'");
WebTools.ExeSql("UPDATE UPDATE_HEADER SET STATUS='PS' WHERE STATUS<>'PS'");
lblMessage.Text = "All running & waiting flags are set as Completed";
}
protected void btnDeleteUnRegIDF_Click(object sender, EventArgs e)
{
//Delete Isometric MTO of drawings which are not yet received or deleted.
try
{
string status = WebTools.GetExpr("CURRENT_STATUS", "PROJECT_JOB_LIST", "PROCESS_NAME='DELETE_X_REVISION_ISO'");
if (status.Equals("COMPLETED"))
{
string sql = "";
sql = "UPDATE PROJECT_JOB_LIST SET CURRENT_STATUS='RUNNING' WHERE PROCESS_NAME='DELETE_X_REVISION_ISO'";
WebTools.ExeSql(sql);
sql = WebTools.GetExpr("SQL_TO_RUN", "PROJECT_JOB_LIST", " PROCESS_NAME='DELETE_X_REVISION_ISO'");
WebTools.ExeSql(sql);
lblMessage.Text = "You request is under process, please wait...";
}
else
{
lblMessage.Text = "<font color='red'>Sorry, your request can not be processed now !!!</font>";
}
}
catch (Exception exc)
{
lblMessage.Text = exc.Message;
}
}
protected void btnDeleteAll_Click(object sender, EventArgs e)
{
if (RadGrid1.SelectedIndexes.Count == 0)
{
Master.ShowMessage("Select Material to Delete.");
return;
}
string MR_ITEM_NO = "";
string MAT_REQ_ID = "";
string sql = string.Empty;
try
{
foreach (GridDataItem item in RadGrid1.SelectedItems)
{
MAT_REQ_ID = Request.QueryString["MAT_REQ_ID"];
MR_ITEM_NO = item["MR_ITEM_NO"].Text;
sql = WebTools.ExeSql("DELETE FROM MATERIAL_REQUEST_DETAIL WHERE MAT_REQ_ID=" + MAT_REQ_ID + " AND MR_ITEM_NO=" + MR_ITEM_NO);
Master.ShowSuccess("Successfully Deleted Selected Items");
RadGrid1.Rebind();
}
}
catch (Exception ex)
{
Master.ShowError(ex.Message);
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
PIP_WORK_ORDTableAdapter wo = new PIP_WORK_ORDTableAdapter();
try
{
string user_id = WebTools.GetExpr("USER_ID", "USERS",
"UPPER(USER_NAME)='" + Session["USER_NAME"].ToString().ToUpper() + "'");
wo.InsertQuery(decimal.Parse(Session["PROJECT_ID"].ToString()), txtJcNumber.Text,
txtCreateDate.SelectedDate,
decimal.Parse(subconDDL.SelectedValue.ToString()),
ddPS.SelectedValue.ToString(),
decimal.Parse(ddJobcardType.SelectedValue.ToString()),
ddMatType.SelectedValue.ToString(),
txtRemarks.Text, decimal.Parse(user_id), txtRev.Text, txtRevDate.SelectedDate, txtTargetDate.SelectedDate);
string sql = "UPDATE PIP_WORK_ORD SET MAT_AVL = '" + radJCMatAvail.SelectedValue + "' WHERE WO_NAME = '" + txtJcNumber.Text + "'";
WebTools.ExeSql(sql);
Master.show_success("Job Card Created.");
}
catch (Exception ex)
{
Master.show_error(ex.Message);
}
finally
{
wo.Dispose();
}
}
private Boolean CollectAreas()
{
//lblMessage.Text = "";
var collection = ddAreaForSml.CheckedItems;
if (collection.Count != 0)
{
try
{
string query = "DELETE FROM PIP_SML_AREA";
WebTools.exec_non_qry(query);
foreach (var area in collection)
{
query = "INSERT INTO PIP_SML_AREA(AREA_L2) VALUES ('" + area.Text.ToString() + "')";
WebTools.ExeSql(query);
//lblSmlTime.Text = query;
//return false;
}
}
catch (Exception exc)
{
Master.ShowWarn(exc.Message);
return(false);
}
return(true);
}
else
{
Master.ShowWarn("Select any area !");
return(false);
}
}
protected void WeldSave_Click(object sender, EventArgs e)
{
string welder = string.Empty;
string joint_id = Request.QueryString["JOINT_ID"].ToString();
if (weldersListBox.Items.Count <= 0)
{
Master.show_error("Select Welder");
return;
}
//Add Welders
if (weldersListBox.Items.Count > 0)
{
for (int i = 0; i < weldersListBox.Items.Count; i++)
{
welder = weldersListBox.Items[i].Value.ToString();
string welder_exist = WebTools.GetExpr("WELDER_ID", "PIP_SPOOL_WELDING", " WHERE JOINT_ID=" + joint_id + " AND WELDER_ID=" + welder.Substring(0, welder.IndexOf("-")) + " AND PASS_ID=" + welder.Substring(welder.IndexOf("-") + 1));
if (welder_exist == "")
{
WebTools.ExeSql("INSERT INTO PIP_SPOOL_WELDING(JOINT_ID, WELDER_ID, PASS_ID) VALUES(" + joint_id + "," +
welder.Substring(0, welder.IndexOf("-")) + "," + welder.Substring(welder.IndexOf("-") + 1) + ")");
}
}
string root_hot = WebTools.GetExpr("ROOT_HOT", "VIEW_JNT_WELDER_UPDATE", " WHERE JOINT_ID=" + joint_id);
string fill_cap = WebTools.GetExpr("FILL_CAP", "VIEW_JNT_WELDER_UPDATE", " WHERE JOINT_ID=" + joint_id);;
string weld_jnt_sql = "UPDATE PIP_SPOOL_JOINTS SET ROOT_HOT_WELDER='" + root_hot + "',FILL_CAP_WELDER='" + fill_cap + "' where joint_id=" + joint_id;
WebTools.ExeSql(weld_jnt_sql);
SpoolWeldingObjectDataSource.DataBind();
Master.show_success("Welders Updated");
}
}
protected void Import(string trans_id)
{
string spl_id, sql, doc_no;
try
{
foreach (GridDataItem row in itemsGrid.Items)
{
CheckBox cb = row["Check_Col"].FindControl("CheckBox1") as CheckBox;
if (cb.Checked)
{
spl_id = row.GetDataKeyValue("SPL_ID").ToString();
doc_no = row["COAT_JC_NO"].Text;
sql = "INSERT INTO PIP_SPL_TRANSFER_DETAIL (TRANS_ID, SPL_ID, DOC_NO) VALUES ";
sql += " ('" + trans_id + "', '" + spl_id + "', '" + doc_no + "')";
WebTools.ExeSql(sql);
}
}
string trans_no = WebTools.GetExpr("TRANS_NO", "PIP_SPL_TRANSFER", " WHERE TRANS_ID='" + trans_id + "'");
Master.ShowMessage("Data Imported to Transfer No " + trans_no + ".");
itemsGrid.Rebind();
}
catch (Exception ex)
{
Master.ShowError(ex.Message);
}
}
protected void btnSetFlagCmplt_Click(object sender, EventArgs e)
{
WebTools.ExeSql("UPDATE PROJECT_JOB_LIST SET CURRENT_STATUS='COMPLETED'");
lblMessage.Text = "All running & waiting flags are set as Completed";
gvProcesses.DataBind();
gvExceptions.DataBind();
}
protected void btnSplUpload_Click(object sender, EventArgs e)
{
string sql, iso_id, spl_id, spl_id2;
if (splUploader.HasFile)
{
string proj_id = Session["PROJECT_ID"].ToString();
string FileName = Path.GetFileName(splUploader.PostedFile.FileName);
string Extension = Path.GetExtension(splUploader.PostedFile.FileName);
string FolderPath = WebTools.SessionDataPath();
string FilePath = FolderPath + FileName;
splUploader.SaveAs(FilePath);
FileStream stream = new FileStream(FilePath, FileMode.Open, FileAccess.Read);
DataTable dt = new DataTable();
dt = ExcelImport.xlsxToDT2(stream);
try
{
switch (rdoUploadOption.SelectedValue)
{
case "DELETE":
sql = "DELETE FROM PIP_SML_SPOOL";
WebTools.ExeSql(sql);
break;
}
foreach (DataRow dr in dt.Rows)
{
if (dr[0].ToString().Trim().Equals("ISO_TITLE1"))
{
continue;
}
iso_id = WebTools.GetExpr("ISO_ID", "PIP_ISOMETRIC", "ISO_TITLE1='" + dr[0].ToString() + "'");
spl_id = WebTools.GetExpr("SPL_ID", "PIP_SPOOL", "ISO_ID='" + iso_id + "'" + " AND SPOOL='" + dr[1].ToString() + "'");
spl_id2 = WebTools.GetExpr("SPL_ID", "PIP_SML_SPOOL", " SPL_ID='" + spl_id + "'");
if (spl_id2.Trim().Length == 0 && spl_id.Trim().Length > 0)
{
sql = "INSERT INTO PIP_SML_SPOOL (PROJECT_ID, LIST_NAME, SPL_ID) VALUES (1, '" + FileName + "', '" + spl_id + "')";
WebTools.ExeSql(sql);
}
}
Master.ShowSuccess("Selected Spools Imported.");
}
catch (Exception ex)
{
Master.ShowWarn(ex.Message + " Invalid ISO / Spool Provided");
}
}
else
{
Master.ShowWarn("Please Select a file to upload");
return;
}
}
protected void btnIsoUpload_Click(object sender, EventArgs e)
{
string sql, iso_title1;
if (isoUploader.HasFile)
{
string proj_id = Session["PROJECT_ID"].ToString();
string FileName = Path.GetFileName(isoUploader.PostedFile.FileName);
string Extension = Path.GetExtension(isoUploader.PostedFile.FileName);
string FolderPath = WebTools.SessionDataPath();
string FilePath = FolderPath + FileName;
isoUploader.SaveAs(FilePath);
//lblSmlUser.Text = FilePath;
//return;
FileStream stream = new FileStream(FilePath, FileMode.Open, FileAccess.Read);
DataTable dt = new DataTable();
dt = ExcelImport.xlsxToDT2(stream);
try
{
switch (rdoUploadOption.SelectedValue)
{
case "DELETE":
sql = "DELETE FROM PIP_SML_ISOME";
WebTools.ExeSql(sql);
break;
}
foreach (DataRow dr in dt.Rows)
{
//iso_title1 = WebTools.GetExpr("ISO_ID", "PIP_ISOMETRIC", "ISO_TITLE1='" + dr[0].ToString() + "'");
if (dr[0].ToString().Trim().Equals("ISO_TITLE1"))
{
continue;
}
iso_title1 = dr[0].ToString().Trim();
if (iso_title1.Trim().Length > 0)
{
sql = "INSERT INTO PIP_SML_ISOME (ISO_TITLE) VALUES ('" + iso_title1 + "')";
WebTools.ExeSql(sql);
}
}
Master.ShowSuccess("Selected Isometrics Imported.");
}
catch (Exception ex)
{
Master.ShowWarn(ex.Message);
}
}
else
{
Master.ShowWarn("Please Select a file to upload");
return;
}
}
protected void Reset()
{
if (RadListBoxSource.SelectedItem != null || RadListBox1.SelectedValue != "")
{
string export_option = RadListBoxSource.SelectedValue;
if (export_option == "")
{
export_option = RadListBox1.SelectedValue;
}
string sql = string.Empty;
//Master.show_info(export_option);
switch (export_option)
{
case "SPOOL":
sql = "DELETE FROM PROJECT_PRIORITY_SPOOL";
break;
case "MAIN_MAT":
sql = "DELETE FROM PROJECT_PRIORITY_MAIN_MAT";
break;
case "AREA":
sql = "DELETE FROM PROJECT_PRIORITY_AREA";
break;
case "SERVICE":
sql = "DELETE FROM PROJECT_PRIORITY_SERVICE";
break;
case "LINE":
sql = "DELETE FROM PROJECT_PRIORITY_LINE";
break;
case "ISOMETRIC":
sql = "DELETE FROM PROJECT_PRIORITY_ISOMETRIC";
break;
case "SPLIT_WBS":
sql = "DELETE FROM PROJECT_PRIORITY_SPLIT_WBS";
break;
case "EQP":
sql = "DELETE FROM PROJECT_PRIORITY_EQP_EREC";
break;
case "CRD":
sql = "UPDATE PIP_ISOMETRIC SET CRD_DATE = NULL";
break;
}
WebTools.ExeSql(sql);
Master.show_success("Priority has been reset for " + export_option);
}
else
{
lblMessage.Text = "<font color='red'>Please select an item !!!</font>";
}
}
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 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);
}
}
