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