Esempio n. 1
0
    protected void btnSaveSettings_Click(object sender, EventArgs e)
    {
        try
        {
            string sml_status = WebTools.GetExpr("CURRENT_STATUS", "PROJECT_JOB_LIST", " WHERE PROCESS_NAME = '" + process_name + "'");
            if (sml_status.Equals("RUNNING"))
            {
                Master.ShowWarn("Simulation Already Running. Please Try Again Later.");
                return;
            }

            sml_status = WebTools.CountExpr("STATUS", "SIMULATION_HEADER", " WHERE STATUS = 'PR'");
            if (!sml_status.Equals("0"))
            {
                Master.ShowWarn("Simulation Already Running. Please Try Again Later.");
                return;
            }
            string message = set_current_page_settings();
            Master.ShowSuccess(message);
        }
        catch (Exception ex)
        {
            Master.ShowWarn(ex.Message);
        }
    }
Esempio n. 2
0
    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);
                }
            }
        }
    }
Esempio n. 3
0
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            Master.HeadingMessage("Remove Unregistered/Deleted IDF MTO");

            string count = WebTools.CountExpr("1", "VIEW_UNREGIS_IDF", " WHERE 1=1");

            lblStatus.Text = "Total IDFs : " + count;
        }
    }
    protected void btnUpload2_Click(object sender, EventArgs e)
    {
        if (itemsGrid.SelectedIndexes.Count == 0)
        {
            Master.ShowError("Select IRN to continue");
            return;
        }

        //string filepath = "G:\\AMC work\\temp\\ir\\";
        string filepath = WebTools.GetExpr("PATH", "DIR_OBJECTS", " WHERE DIR_ID=6");
        //Server.MapPath("\\Upload");
        HttpFileCollection uploadedFiles = Request.Files;

        try
        {
            string irn_id = itemsGrid.SelectedValue.ToString();
            string irn_no = WebTools.GetExpr("IRN_NO", "PIP_PO_IRN", " WHERE IRN_ID='" + irn_id + "'");
            irn_no = irn_no.Replace("/", "-");
            string queryupload = "SELECT COUNT(IRN_ID) FROM PIP_PO_IR_DOCS WHERE IRN_ID='" + irn_id + "'";
            string maxdoc      = WebTools.CountExpr("IRN_ID", "PIP_PO_IR_DOCS", " WHERE IRN_ID=" + irn_id);
            int    doccnt      = 0;
            if (maxdoc == "")
            {
                doccnt = 1;
            }
            else
            {
                doccnt = int.Parse(maxdoc);
            }
            for (int i = 0; i < uploadedFiles.Count; i++)
            {
                ++doccnt;
                HttpPostedFile userPostedFile = uploadedFiles[i];
                if (userPostedFile.ContentLength > 0)
                {
                    string Extension   = Path.GetExtension(userPostedFile.FileName);
                    string u_file_name = Path.GetFileName(userPostedFile.FileName);
                    u_file_name = u_file_name.Replace("'", "");
                    string Filename = irn_no + "_" + doccnt + Extension;
                    userPostedFile.SaveAs(filepath + "\\" + Filename);
                    string query = "INSERT INTO PIP_PO_IR_DOCS(IRN_ID,DOC_NAME,DOC_EXT,DIR_ID,U_FILE_NAME) VALUES(" + irn_id + ",'" + Filename + "','" + Extension + "','" + 6 + "','" + u_file_name + "')";
                    WebTools.ExeSql(query);
                }
            }
            Master.ShowSuccess("IR Files Saved");
        }

        catch (Exception Ex)
        {
            Master.ShowError(Ex.Message);
        }
    }
Esempio n. 5
0
    protected void btnSave_Click(object sender, EventArgs e)
    {
        VIEW_ADAPTER_MAT_RCV_DETAILTableAdapter mrr = new VIEW_ADAPTER_MAT_RCV_DETAILTableAdapter();
        decimal mat_id;
        string  mat_code1;
        string  bal_to_recv, mr_item;
        string  rel_qty;
        string  irn_id = "";

        try
        {
            foreach (GridDataItem item in itemsGrid.SelectedItems)
            {
                mat_code1 = item["MAT_CODE1"].Text;
                //mat_id = WebTools.GetMatId(mat_code1, decimal.Parse(Session["PROJECT_ID"].ToString()));
                mat_id = decimal.Parse(WebTools.GetExpr("MAT_ID", "PIP_MAT_STOCK", " WHERE MAT_CODE1='" + mat_code1 + "'"));
                //irn_id = WebTools.GetExpr("IRN_ID", "PIP_MAT_RECEIVE_IRN", " WHERE MAT_RCV_ID = '" + Request.QueryString["MAT_RCV_ID"].ToString()+ "'");
                irn_id      = WebTools.GetExpr("IRN_ID", "PIP_PO_IRN", " WHERE IRN_NO = '" + item["IRN_NO"].Text + "'");
                bal_to_recv = WebTools.GetExpr("BAL_TO_RECV", "VIEW_IRN_BAL_TO_RECV", " WHERE IRN_ID = '" + irn_id + "' AND PO_ITEM='" + item["PO_ITEM"].Text +
                                               "' AND MAT_ID='" + mat_id + "'");
                //bal_to_recv = (item["BAL_TO_RECV"].FindControl("BAL_TO_RECVLabel") as TextBox).Text;
                mr_item = WebTools.CountExpr("(1)", "PIP_MAT_RECEIVE_DETAIL", " WHERE MAT_RCV_ID='" + Request.QueryString["MAT_RCV_ID"].ToString() + "'");
                string RECV_QTY = (item["BAL_TO_RECV"].FindControl("BAL_TO_RECVLabel") as TextBox).Text;


                if ((decimal.Parse(item["RELEASE_QTY"].Text) - decimal.Parse(item["RECV_QTY"].Text)) < decimal.Parse(bal_to_recv))
                {
                    Master.ShowError("Receive Quantity cannot be more than release qty. ");
                    return;
                }
                string pieces = (item["BAL_TO_RECV_PIECES"].FindControl("BAL_TO_RECV_PIECESLabel") as TextBox).Text;

                if (pieces == "N/A" || pieces == "")
                {
                    pieces = "0";
                }
                mrr.InsertQuery(decimal.Parse(Request.QueryString["MAT_RCV_ID"]), mat_id, decimal.Parse(RECV_QTY), null, null,
                                item["PO_ITEM"].Text, null, (Decimal.Parse(mr_item) + 1).ToString(), null, (decimal.Parse(item["IRN_ID"].Text)), decimal.Parse(pieces));
            }
            Master.ShowMessage("Selected Items Added to MRR.");
        }
        catch (Exception ex)
        {
            Master.ShowError(ex.Message);
        }
        finally {
            itemsGrid.Rebind();
        }
    }
    protected void RadGrid1_ItemCommand(object sender, Telerik.Web.UI.GridCommandEventArgs e)
    {
        try
        {
            if (e.CommandName == "Delete")
            {
                int    index       = e.Item.RowIndex;
                var    item        = RadGrid1.Items[index - 2] as Telerik.Web.UI.GridDataItem;
                var    joint_id    = item.GetDataKeyValue("JOINT_ID");
                var    repair_code = item.GetDataKeyValue("REPAIR_CODE");
                string count       = WebTools.CountExpr("JOINT_ID", "PIP_NDE_REQUEST_JOINTS", " REPAIR_CODE IS NOT NULL AND JOINT_ID=" + joint_id + " AND REPAIR_CODE='" + repair_code + "'");
                if (count.ToString() != "0")
                {
                    e.Canceled = true;
                    ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('This Joint exists in other modules.It cannot be deleted!')", true);
                    return;
                }
                else
                {
                    e.Canceled = false;
                }
            }

            if (e.CommandName == "Edit")
            {
                int index    = e.Item.RowIndex;
                var item     = RadGrid1.Items[index - 2] as Telerik.Web.UI.GridDataItem;
                var joint_id = item.GetDataKeyValue("JOINT_ID");
                //  HiddenField1.Value = WebTools.GetExpr("WPS_NO", "PIP_SPOOL_JOINTS", " WHERE JOINT_ID=" + joint_id);
                HiddenField2.Value = WebTools.GetExpr("JOINT_SIZE_DEC", "PIP_SPOOL_JOINTS", " WHERE JOINT_ID=" + joint_id);
                HiddenField3.Value = WebTools.GetExpr("JOINT_THK", "PIP_SPOOL_JOINTS", " WHERE JOINT_ID=" + joint_id);
                string cat_id = WebTools.GetExpr("CAT_ID", "PIP_SPOOL_JOINTS", " WHERE  JOINT_ID=" + joint_id);
                if (cat_id == "1" || cat_id == "3")
                {
                    HiddenField1.Value = "1";
                }
                else
                {
                    HiddenField1.Value = "2";
                }
            }
        }
        catch (Exception exc)
        {
            Master.ShowError(exc.Message);
        }
    }
Esempio n. 7
0
    protected void btnSimulation_Click(object sender, EventArgs 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 = "", temp_sml_status = "";

            temp_sml_status = WebTools.GetExpr("CURRENT_STATUS", "PROJECT_JOB_LIST", "PROCESS_NAME='TEMP_SIMULATION'");
            if (temp_sml_status.Equals("RUNNING"))
            {
                lblMessage.Text = "Temp Simulation is already running!!!";
                return;
            }

            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='TEMP_SIMULATION'");
                sql = WebTools.GetExpr("SQL_TO_RUN", "PROJECT_JOB_LIST", " PROCESS_NAME='TEMP_SIMULATION'");
                WebTools.ExeSql(sql);
                lblMessage.Text = "You request is under process, please wait...";
            }
            //If bom simulation is not running
            else
            {
                WebTools.ExeSql("UPDATE PROJECT_JOB_LIST SET CURRENT_STATUS='REQUEST_TO_RUN' WHERE  PROCESS_NAME='TEMP_SIMULATION'");
            }
            Master.show_info("Close the window and check the progress Utilities Page !");
        }
        catch (Exception exc)
        {
            Master.show_error(exc.Message);
        }
    }
Esempio n. 8
0
    protected void btnImport_Click(object sender, EventArgs e)
    {
        try
        {
            if (!FileUpload1.HasFile)
            {
                return;
            }

            string proj_id    = Session["PROJECT_ID"].ToString();
            string FileName   = Path.GetFileName(FileUpload1.PostedFile.FileName);
            string Extension  = Path.GetExtension(FileUpload1.PostedFile.FileName);
            string FolderPath = WebTools.SessionDataPath();

            string FilePath = FolderPath + FileName;
            FileUpload1.SaveAs(FilePath);

            // delete old data
            WebTools.ExecNonQuery("DELETE FROM TBL_ISO_ATTRIB_IMP WHERE PROJECT_ID = '" + Session["PROJECT_ID"].ToString() + "'");

            FileStream stream = new FileStream(FilePath, FileMode.Open, FileAccess.Read);

            DataTable dt = new DataTable();
            dt = ExcelImport.xlsxToDT2(stream);

            ExcelImport.ImportDataTable(dt, "TBL_ISO_ATTRIB_IMP", "", "PROJECT_ID", proj_id);

            WebTools.ExecNonQuery("BEGIN " +
                                  "PKG_PAGE_VALIDATION.PROC_UDPATE_ISO_ATTRIBUTE; " +
                                  " END;");

            string ErrorCount = WebTools.CountExpr("ISO_TITLE1", "TBL_ISO_ATTRIB_IMP", " ISO_ID IS NULL OR ERROR_MSG IS NOT NULL");

            Master.show_success("Isometric Attribute Data Imported Successfully with " + ErrorCount + " Errors.");

            if (Convert.ToInt32(ErrorCount) > 0)
            {
                linkDownloadError.Visible = true;
            }
        }
        catch (Exception ex)
        {
            Master.show_error(ex.Message);
        }
    }
Esempio n. 9
0
    protected void btnSubmit_Click(object sender, EventArgs e)
    {
        dsMaterialCTableAdapters.VIEW_ADP_SUBSTITUTE_DTTableAdapter substitu = new dsMaterialCTableAdapters.VIEW_ADP_SUBSTITUTE_DTTableAdapter();
        string old_mat_id, old_mat_qty;

        old_mat_id  = WebTools.GetExpr("MAT_ID", "PIP_BOM", "BOM_ID=" + ddBomItem.SelectedValue.ToString());
        old_mat_qty = WebTools.GetExpr("NET_QTY", "PIP_BOM", "BOM_ID=" + ddBomItem.SelectedValue.ToString());
        decimal new_mat_id = WebTools.GetMatId(txtItemCode.Text, decimal.Parse(Session["PROJECT_ID"].ToString()));

        if (new_mat_id == 0)
        {
            Master.show_error("Material Not Found");
            return;
        }
        try
        {
            substitu.InsertQuery(decimal.Parse(Request.QueryString["REQ_ID"]), decimal.Parse(ddBomItem.SelectedValue.ToString()),
                                 decimal.Parse(old_mat_id), decimal.Parse(old_mat_qty),
                                 new_mat_id, decimal.Parse(txtNewQty.Text), txtRemarks.Text);

            string count = WebTools.CountExpr("1", "PIP_MAT_SUBSTITUTE_DETAIL", "  WHERE  BOM_ID=" + ddBomItem.SelectedValue.ToString());
            //if (count == "1")
            //{
            //    //NEW  ADDITION
            //    string sql1 = "UPDATE  PIP_BOM  SET  OLD_MAT_ID=" + old_mat_id + "  WHERE BOM_ID=" + ddBomItem.SelectedValue.ToString();
            //    WebTools.exec_non_qry(sql1);
            //}
            string sql3 = "UPDATE  PIP_BOM  SET  NET_QTY=" + txtNewQty.Text + "  WHERE  BOM_ID=" + ddBomItem.SelectedValue.ToString();
            string sql2 = "UPDATE  PIP_BOM  SET  MAT_ID=" + new_mat_id.ToString() + "  WHERE  BOM_ID=" + ddBomItem.SelectedValue.ToString();
            WebTools.exec_non_qry(sql3);
            WebTools.exec_non_qry(sql2);
            Master.show_success("New Item Added.");
        }
        catch (Exception ex)
        {
            Master.show_error(ex.Message);
            return;
        }
        finally
        {
            substitu.Dispose();
        }
    }
Esempio n. 10
0
    protected void btnProceed_Click(object sender, EventArgs e)
    {
        string process_name = "UPDATE_ALL";
        string upd_status   = WebTools.GetExpr("CURRENT_STATUS", "PROJECT_JOB_LIST", " WHERE PROCESS_NAME = '" + process_name + "'");

        if (upd_status.Equals("RUNNING"))
        {
            Master.ShowWarn("Server update is running, please check status of project jobs!");
            return;
        }

        upd_status = WebTools.CountExpr("STATUS", "UPDATE_HEADER", " WHERE STATUS = 'PR'");
        if (!upd_status.Equals("0"))
        {
            Master.ShowWarn("Server update is running, please check status of update headers!");
            return;
        }

        try
        {
            string sql = WebTools.GetExpr("SQL_TO_RUN", "PROJECT_JOB_LIST", " PROCESS_NAME='" + process_name + "'");
            WebTools.ExeSql(sql);
            string user_id = WebTools.GetExpr("USER_ID", "USERS", "UPPER(USER_NAME)='" + Session["USER_NAME"].ToString().ToUpper().Trim() + "'");
            sql = "INSERT INTO UPDATE_HEADER(UPD_USER_ID, UPD_DATE, STATUS) VALUES ('" + user_id + "',SYSDATE,'PR')";
            WebTools.ExeSql(sql);

            gridUpdHistory.DataBind();
            grdiProgress.DataBind();
            Master.ShowMessage("Server update run started...");
        }
        catch (Exception exc)
        {
            if (exc.Message.Contains("ORA-27478"))
            {
                Master.ShowWarn("Server Update is already running !!!");
            }
            else
            {
                Master.ShowWarn(exc.Message);
            }
        }
    }
Esempio n. 11
0
    protected void btnRunSimulation_Click(object sender, EventArgs e)
    {
        if (CollectSubCons() && CollectAreas())
        {
            sml_status = WebTools.GetExpr("CURRENT_STATUS", "PROJECT_JOB_LIST", " WHERE PROCESS_NAME = '" + process_name + "'");
            if (sml_status.Equals("RUNNING"))
            {
                Master.ShowWarn("Simulation is running, please check status of project jobs!");
                return;
            }

            sml_status = WebTools.CountExpr("STATUS", "SIMULATION_HEADER", " WHERE STATUS = 'PR'");
            if (!sml_status.Equals("0"))
            {
                Master.ShowWarn("Simulation is running, please check status of simulation headers!");
                return;
            }

            btnSaveSettings_Click(sender, e);

            try
            {
                string sql = WebTools.GetExpr("SQL_TO_RUN", "PROJECT_JOB_LIST", " PROCESS_NAME='" + process_name + "'");
                WebTools.ExeSql(sql);
                gridSmlHistory.DataBind();
                Master.ShowSuccess("Current settings saved and Simulation Run started !!!");
            }
            catch (Exception exc)
            {
                if (exc.Message.Contains("ORA-27478"))
                {
                    Master.ShowWarn("Simulation is already running !!!");
                }
                else
                {
                    Master.ShowWarn(exc.Message);
                }
            }
        }
    }
Esempio n. 12
0
    protected string set_current_page_settings()
    {
        string counter = WebTools.CountExpr("*", "SIMULATION_SETTING", " WHERE SML_CAT='" + sml_cat + "'");
        string query   = string.Empty;

        if (Int32.Parse(counter) > 0)
        {
            query = "UPDATE SIMULATION_SETTING SET "
                    + " SML_CAT='" + sml_cat + "'"
                    + ", SML_TIME=TO_CHAR(SYSDATE,'dd-Mon-yyyy HH:MI AM')"
                    + ", SML_USER='******'"
                    + ", DWG_STATUS='" + rdoDwgStatus.SelectedValue + "'"
                    + ", ON_SFR_FIRST='" + rdoSpoolSFR.SelectedValue + "'"
                    + ", ON_SELECTED_SPOOLS='" + rdoSelectedSpools.SelectedValue + "'"
                    + ", ON_SELECTED_ISOME='" + rdoSelectedIsos.SelectedValue + "'"
                    + ", AGUG='" + rdoAGUG.SelectedValue + "'"
                    + ", SML_PRIORITY='" + rdoPriority.SelectedValue + "'"
                    + ", EXCLUDE_HOLD='" + rdoHoldStatus.SelectedValue + "'"
                    + ", MATERIAL_SOURCE='" + rdoMaterialSource.SelectedValue + "'"
                    + ", USE_COMMON_STORE='" + rdoUseCommonStore.SelectedValue + "'"
                    + " WHERE SML_CAT='" + sml_cat + "'";
        }
        else
        {
            return("Setting info not updated !");
        }

        try
        {
            //return query;
            WebTools.ExeSql(query);
            return("Current settings saved !!!");
        }
        catch (Exception exc)
        {
            Master.ShowWarn(exc.Message);
            return(exc.Message);
        }
    }
 protected void btnSave_Click(object sender, EventArgs e)
 {
     try
     {
         int code_exist = int.Parse(WebTools.CountExpr("UNIQ_ID", "FLANGE_SYSPID_DATA", " WHERE PID_SEQ='" + Request.QueryString["PID_SEQ"] + "' AND " +
                                                       "SEQ=" + RadcobSysSub.SelectedValue));
         if (code_exist == 0)
         {
             FlangeDataSource.Insert();
             FlangeGridView.DataBind();
             Master.show_success(" Saved succesfully!");
         }
         else
         {
             Master.show_error("Already exist Data!");
         }
     }
     catch (Exception ex)
     {
         Master.show_error(ex.Message);
     }
 }
    protected void btnPOUpdate_Click(object sender, EventArgs e)
    {
        try
        {
            string po_status = "", any_update_run_count = "";

            any_update_run_count = WebTools.CountExpr("PROCESS_NAME", "PROJECT_JOB_LIST", "CURRENT_STATUS='RUNNING' "
                                                      + " AND (PROCESS_NAME LIKE '%SIMULATION%' OR PROCESS_GROUP='SERVER_UPDATE')");

            po_status = WebTools.GetExpr("CURRENT_STATUS", "PROJECT_JOB_LIST", "PROCESS_NAME='IMPORT_PO_DATA'");

            if ((po_status.Equals("COMPLETED") || po_status.Equals("REQUEST_TO_RUN")) &&
                any_update_run_count.Equals("0"))
            {
                string sql = "";
                sql = "UPDATE PROJECT_JOB_LIST SET CURRENT_STATUS='RUNNING' WHERE  PROCESS_NAME='IMPORT_PO_DATA'";
                WebTools.ExeSql(sql);

                sql = WebTools.GetExpr("SQL_TO_RUN", "PROJECT_JOB_LIST", " PROCESS_NAME='IMPORT_PO_DATA'");
                WebTools.ExeSql(sql);
                Master.ShowMessage("You request is under process, please wait...");
                SetPPCSRunning();
            }
            else if (!po_status.Equals("RUNNING"))
            {
                WebTools.ExeSql("UPDATE PROJECT_JOB_LIST SET CURRENT_STATUS='REQUEST_TO_RUN' WHERE  PROCESS_NAME='IMPORT_PO_DATA'");
                Master.ShowMessage("You request is under process, please wait...");
            }
            else
            {
                Master.ShowWarn("<font color='red'>Sorry, your request can not be processed now !!!</font>");
            }
        }
        catch (Exception exc)
        {
            Master.ShowWarn(exc.Message);
        }
    }
    protected void btnServerUpdate_Click(object sender, EventArgs e)
    {
        menuUpdateAll.Skin = "Sunset";
        try
        {
            string query = "UPDATE SIMULATION_SETTING SET UPDATE_USER='******', UPDATE_TIME=TO_CHAR(SYSDATE,'dd-Mon-yyyy (HH:MI AM)')";
            WebTools.exec_non_qry(query);

            string any_update_run_count = WebTools.CountExpr("PROCESS_NAME", "PROJECT_JOB_LIST", "CURRENT_STATUS='RUNNING'"
                                                             + " AND (PROCESS_GROUP='SERVER_UPDATE'  OR PROCESS_NAME='BOM_SIMULATION'  OR  PROCESS_NAME='FULL_SIMULATION'  OR PROCESS_NAME='IMPORT_PO_DATA')");

            string update_all_status = WebTools.GetExpr("CURRENT_STATUS", "PROJECT_JOB_LIST", "PROCESS_NAME='UPDATE_ALL'");

            if (any_update_run_count.Equals("0"))
            {
                string sql = "";
                sql = "UPDATE PROJECT_JOB_LIST SET CURRENT_STATUS='RUNNING' WHERE  PROCESS_GROUP='SERVER_UPDATE'";
                WebTools.ExeSql(sql);

                sql = WebTools.GetExpr("SQL_TO_RUN", "PROJECT_JOB_LIST", " PROCESS_NAME='UPDATE_ALL'");
                WebTools.ExeSql(sql);
                Master.ShowMessage("You request is under process, please wait...");
            }
            else if (!update_all_status.Equals("RUNNING"))
            {
                WebTools.ExeSql("UPDATE PROJECT_JOB_LIST SET CURRENT_STATUS='REQUEST_TO_RUN' WHERE  PROCESS_NAME='UPDATE_ALL'");
                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;
        }
    }
Esempio n. 16
0
    protected void btnRunSimulation_Click(object sender, EventArgs e)
    {
        sml_status = WebTools.GetExpr("CURRENT_STATUS", "PROJECT_JOB_LIST", " WHERE PROCESS_NAME = 'BOM_SIMULATION'");

        if (CollectSubCons())
        {
            if (sml_status.Equals("RUNNING"))
            {
                Master.ShowSuccess("Ooops... Simulation is already running !!!");
                //return;
            }

            btnSaveSettings_Click(sender, e);

            try
            {
                string user_id            = WebTools.GetExpr("USER_ID", "USERS", "UPPER(USER_NAME)=UPPER('" + Session["USER_NAME"].ToString() + "')");
                string sql_new_sml_header = "";
                sql_new_sml_header = "INSERT INTO SIMULATION_HEADER(sml_user_id,sml_cat_id,sml_date,exclude_hold,dwg_status,on_sfr_first" +
                                     ",agug,sml_priority,on_selected_spools,use_common_store,material_source)"
                                     + "VALUES('" + user_id + "','1',SYSDATE,'" + rdoHoldStatus.SelectedValue + "','" + rdoDwgStatus.SelectedValue + "','" + rdoSpoolSFR.SelectedValue +
                                     "','" + rdoAGUG.SelectedValue + "','" + rdoPriority.SelectedValue + "','" + rdoSelectedSpools.SelectedValue + "','" + rdoUseCommonStore.SelectedValue + "','" + rdoMaterialSource.SelectedValue + "')";
                WebTools.exec_non_qry(sql_new_sml_header);

                //Master.ShowSuccess(sql_new_sml_header); return;

                //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='BOM_SIMULATION'");
                    sql = WebTools.GetExpr("SQL_TO_RUN", "PROJECT_JOB_LIST", " PROCESS_NAME='BOM_SIMULATION'");

                    WebTools.ExeSql(sql);
                    Master.ShowSuccess("You request for 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='BOM_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("Simulation is already running !!!");
                }
                else
                {
                    Master.ShowWarn(exc.Message);
                }
            }
        }
    }
    protected void btnValidate_Click(object sender, EventArgs e)
    {
        if (!FileUpload1.HasFile)
        {
            return;
        }

        string proj_id    = Session["PROJECT_ID"].ToString();
        string FileName   = Path.GetFileName(FileUpload1.PostedFile.FileName);
        string Extension  = Path.GetExtension(FileUpload1.PostedFile.FileName);
        string FolderPath = WebTools.SessionDataPath();

        string FilePath = FolderPath + FileName;

        FileUpload1.SaveAs(FilePath);

        string tbl_name   = WebTools.GetExpr("IMP_REP_TABLE", "PIP_BULK_IMPORT_REP", " IMP_REP_ID=" + Request.QueryString["IMPORT_ID"]);
        string user_id    = WebTools.GetExpr("USER_ID", "USERS", " Upper(USER_NAME)='" + Session["USER_NAME"].ToString().ToUpper() + "'");
        string proj_field = WebTools.GetExpr("IMP_PROJ_ID_FIELD", "PIP_BULK_IMPORT_REP", " IMP_REP_ID=" + Request.QueryString["IMPORT_ID"]);

        // delete old data
        WebTools.ExecNonQuery("DELETE FROM " + tbl_name + " Where USER_ID = '" + user_id + "'");
        FileStream stream;
        DataTable  dt;

        stream = new FileStream(FilePath, FileMode.Open, FileAccess.Read);

        dt = new DataTable();
        dt = ExcelImport.xlsxToDT2(stream);

        dt.Columns.Add("USER_ID");
        foreach (DataRow r in dt.Rows)
        {
            r["USER_ID"] = user_id;
        }

        ExcelImport.ImportDataTable(dt, tbl_name, "", proj_field, proj_id);

        try
        {
            //WebTools.ExecNonQuery()
            string valid_pkg = WebTools.GetExpr("IMP_VALIDATE_PKG", "PIP_BULK_IMPORT_REP", " IMP_REP_ID=" + Request.QueryString["IMPORT_ID"]);
            string upd_pkg   = WebTools.GetExpr("IMP_UPDATE_PKG", "PIP_BULK_IMPORT_REP", " IMP_REP_ID=" + Request.QueryString["IMPORT_ID"]);

            if (valid_pkg.Trim().Length > 0)
            {
                WebTools.ExecNonQuery("BEGIN " + valid_pkg + "(" + user_id + "); " +
                                      " END;");
            }

            if (upd_pkg.Trim().Length > 0)
            {
                WebTools.ExecNonQuery("BEGIN " + upd_pkg + "(" + user_id + "); " +
                                      " END;");
            }
            //string user_id = WebTools.GetExpr("USER_ID", "USERS", " USER_NAME='" + Session["USER_NAME"].ToString() + "'");
            string sql = WebTools.GetExpr("GRID_SQL_TEXT", "PIP_BULK_IMPORT_REP", " IMP_REP_ID=" + Request.QueryString["IMPORT_ID"]);
            itemsDataSource.SelectCommand = sql.Replace("PARAM", user_id);
            sql = WebTools.GetExpr("IMP_ERR_LOG_SQL", "PIP_BULK_IMPORT_REP", " IMP_REP_ID=" + Request.QueryString["IMPORT_ID"]);
            itemsErrorSource.SelectCommand = sql.Replace("PARAM", user_id);
            linkImportFormat.NavigateUrl   = WebTools.GetExpr("SAMPLE_FILE_URL", "PIP_BULK_IMPORT_REP", " IMP_REP_ID=" + Request.QueryString["IMPORT_ID"]);
            itemsGrid.Rebind();

            string err_table = WebTools.GetExpr("IMP_REP_TABLE", "PIP_BULK_IMPORT_REP", " IMP_REP_ID=" + Request.QueryString["IMPORT_ID"]);
            int    totalRows = dt.Rows.Count - 1;
            int    ErrorRows = int.Parse(WebTools.CountExpr("STATUS", err_table, " USER_ID = " + user_id + "AND STATUS IS NOT NULL"));
            if (ErrorRows > 0)
            {
                Master.ShowError("Total Records : " + totalRows + " <br/> Successful : " + (totalRows - ErrorRows) + "  <br/> Errors : " + ErrorRows);
            }
            else
            {
                Master.ShowMessage("Total Records : " + totalRows + " <br/> Successful : " + (totalRows - ErrorRows));
            }
        }
        catch (Exception ex)
        {
            Master.ShowError(ex.Message);
        }
        finally
        {
            stream.Close();
            dt.Dispose();
        }
    }
    protected void btnSave_Click(object sender, EventArgs e)
    {
        string pwht_type          = string.Empty;
        string repair_cnt_nde_req = string.Empty;
        string repair_cnt_entry   = string.Empty;

        string repair_cnt_nde_req_ut = string.Empty;
        string repair_cnt_entry_ut   = string.Empty;


        pwht_type = WebTools.GetExpr("NVL(PWHT,'N')", "PIP_SPOOL_JOINTS", " JOINT_ID=" + Decimal.Parse(cboJoints.SelectedValue));

        repair_cnt_nde_req = WebTools.CountExpr("JOINT_ID", "PIP_NDE_REQUEST_JOINTS", " PASS_FLG_ID=2  AND  NDE_TYPE_ID IN (1,9,12,15)  AND  JOINT_ID=" + Decimal.Parse(cboJoints.SelectedValue) + "  GROUP BY JOINT_ID");
        repair_cnt_entry   = WebTools.CountExpr("JOINT_ID", "PIP_JOINTS_REPAIR_DWR", " JOINT_ID=" + Decimal.Parse(cboJoints.SelectedValue) + "  GROUP  BY JOINT_ID");


        if ((decimal.Parse(repair_cnt_nde_req.ToString()) > 0 && decimal.Parse(repair_cnt_entry.ToString()) > 0))
        {
            if ((decimal.Parse(repair_cnt_nde_req.ToString()) == decimal.Parse(repair_cnt_entry.ToString())))
            {
                Master.ShowError("Repair Information already exists, cannot be updated!");
                return;
            }
        }
        if (drpWelder1.SelectedValue == "-1" && drpWelder2.SelectedValue == "-1" && drpWelder3.SelectedValue == "-1" && drpWelder4.SelectedValue == "-1")
        {
            Master.ShowError("No Repair Welder Selected.");
            return;
        }

        if (drpRepairCode.SelectedIndex == -1)
        {
            Master.ShowError("Select Repair Code");
            return;
        }
        if (cboWps.SelectedIndex == -1)
        {
            Master.ShowError("Select WPS No.");
            return;
        }



        //    VIEW_ADAPTER_NDE_STATUSTableAdapter adpt = new VIEW_ADAPTER_NDE_STATUSTableAdapter();
        try
        {
            string   wps_no = string.Empty;
            DateTime REP_DATE;
            REP_DATE = DateTime.Parse(txtRepDate.SelectedDate.ToString());
            string REP_DATE_STRING;
            REP_DATE_STRING = REP_DATE.ToString("dd-MMM-yyyy");
            //DAILY_WLD_WPS in PROJECT_INFORMATION
            //A-->Dropdown
            //B-->Textbox
            //  string wps_entry = WebTools.GetExpr("DAILY_WLD_WPS", "PROJECT_INFORMATION"," WHERE PROJECT_ID=" + Session["PROJECT_ID"].ToString());

            wps_no = cboWps.SelectedItem.Text.ToString();

            string sql;
            sql  = "INSERT INTO PIP_JOINTS_REPAIR_DWR (JOINT_ID,REPAIR_CODE, REPAIR_DATE, WELD_REPORT_NO, WPS_NO) VALUES (";
            sql += Decimal.Parse(cboJoints.SelectedValue) + ",";
            sql += "'" + drpRepairCode.SelectedValue + "'" + ",";
            sql += "'" + REP_DATE_STRING + "'" + ",";
            sql += "'" + txtWeldRepNo.Text + "'" + ",";
            if (wps_no != "null")
            {
                sql += "'" + wps_no + "'" + ")";
            }
            else
            {
                sql += "''" + ")";
            }


            string weldersql = "";

            if (drpWelder1.SelectedValue != "null")
            {
                weldersql = "INSERT INTO PIP_SPOOL_WELDING(JOINT_ID,WELDER_ID,REPAIR_CODE,PASS_ID) VALUES(" + Decimal.Parse(cboJoints.SelectedValue) + "," + drpWelder1.SelectedValue + ",'" + drpRepairCode.SelectedValue.ToString() + "',1)";
                WebTools.ExeSql(weldersql);
            }
            if (drpWelder2.SelectedValue != "null")
            {
                weldersql = "INSERT INTO PIP_SPOOL_WELDING(JOINT_ID,WELDER_ID,REPAIR_CODE,PASS_ID) VALUES(" + Decimal.Parse(cboJoints.SelectedValue) + "," + drpWelder2.SelectedValue + ",'" + drpRepairCode.SelectedValue.ToString() + "',2)";
                WebTools.ExeSql(weldersql);
            }
            if (drpWelder3.SelectedValue != "null")
            {
                weldersql = "INSERT INTO PIP_SPOOL_WELDING(JOINT_ID,WELDER_ID,REPAIR_CODE,PASS_ID) VALUES(" + Decimal.Parse(cboJoints.SelectedValue) + "," + drpWelder3.SelectedValue + ",'" + drpRepairCode.SelectedValue.ToString() + "',3)";
                WebTools.ExeSql(weldersql);
            }
            if (drpWelder4.SelectedValue != "null")
            {
                weldersql = "INSERT INTO PIP_SPOOL_WELDING(JOINT_ID,WELDER_ID,REPAIR_CODE,PASS_ID) VALUES(" + Decimal.Parse(cboJoints.SelectedValue) + "," + drpWelder4.SelectedValue + ",'" + drpRepairCode.SelectedValue.ToString() + "',4)";
                WebTools.ExeSql(weldersql);
            }


            string rep_date_sql = "UPDATE PIP_SPOOL_JOINTS SET REPAIR_DATE=" + "'" + REP_DATE_STRING + "'" + " WHERE JOINT_ID=" + Decimal.Parse(cboJoints.SelectedValue);

            try
            {
                WebTools.ExeSql(sql);
                WebTools.ExeSql(rep_date_sql);
                RadGrid1.DataBind();
                Master.ShowSuccess("Saved Successfully!!");
                cboJoints.SelectedIndex = -1;
            }
            catch (Exception ex)
            {
                Master.ShowMessage(ex.Message);
                return;
            }
            //   adpt.Dispose();
            ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Repair Information Updated successfully!')", true);
        }
        catch (Exception ex)
        {
            //ScriptManager.RegisterStartupScript(this, GetType(), "show alert", "alert('Error!!!')", true);
            Master.ShowMessage(ex.Message);
            return;
        }
        finally
        {
            //  adpt.Dispose();
        }
    }
Esempio n. 19
0
    protected void btnImport_Click(object sender, EventArgs e)
    {
        try
        {
            if (RadAsyncUpload1.UploadedFiles.Count == 0 && RadAsyncUpload2.UploadedFiles.Count == 0)
            {
                Master.show_error("Please Upload File to proceed.");
                return;
            }
            if (Request.QueryString["REF_ID"] == "")
            {
                Master.show_error("Select Transmittal");
                return;
            }
            ///////////////////////////////////////////////////////////////////////////////////////////////////////
            if (RadAsyncUpload1.UploadedFiles.Count > 0)
            {
                int    type_id = int.Parse(Request.QueryString["TYPE_ID"]);
                int    ref_id  = int.Parse(Request.QueryString["REF_ID"].ToString());
                string proj_id = Session["PROJECT_ID"].ToString();

                string user_id  = WebTools.GetExpr("USER_ID", "USERS", " USER_NAME ='" + Session["USER_NAME"] + "'");
                string f_name   = "";
                string dir_obj  = "";
                string dir_id   = "";
                string delquery = "";
                // string irn_id = itemsGrid.SelectedValue.ToString();
                switch (type_id)
                {
                case 8:
                    f_name   = WebTools.GetExpr("MR_NO", "PIP_MAT_REQUISITION", " WHERE MR_ID='" + ref_id + "'");
                    dir_obj  = "REQUISITION";
                    delquery = "DELETE FROM PIP_FILE_UPLOAD WHERE type_id=" + type_id + " AND REF_ID=" + ref_id;
                    WebTools.ExeSql(delquery);
                    dir_id = WebTools.GetExpr("DIR_ID", "DIR_OBJECTS", " WHERE DIR_OBJ='" + dir_obj + "'");
                    break;

                case 9:
                    f_name   = WebTools.GetExpr("PO_NO", "PIP_PO", " WHERE PO_ID='" + ref_id + "'");
                    dir_obj  = "PO_MASTER";
                    delquery = "DELETE FROM PIP_FILE_UPLOAD WHERE type_id=" + type_id + " AND REF_ID=" + ref_id;
                    WebTools.ExeSql(delquery);
                    dir_id = WebTools.GetExpr("DIR_ID", "DIR_OBJECTS", " WHERE DIR_OBJ='" + dir_obj + "'");
                    break;

                case 10:
                    f_name   = WebTools.GetExpr("RFI_NO", "PIP_PO_INSP_REQUEST", " WHERE RFI_ID='" + ref_id + "'");
                    dir_obj  = "PO_RFI";
                    delquery = "DELETE FROM PIP_FILE_UPLOAD WHERE type_id=" + type_id + " AND REF_ID=" + ref_id;
                    WebTools.ExeSql(delquery);
                    dir_id = WebTools.GetExpr("DIR_ID", "DIR_OBJECTS", " WHERE DIR_OBJ='" + dir_obj + "'");
                    break;

                case 11:
                    f_name   = WebTools.GetExpr("MAT_RCV_NO", "PIP_MAT_RECEIVE", " WHERE MAT_RCV_ID='" + ref_id + "'");
                    dir_obj  = "MRR";
                    delquery = "DELETE FROM PIP_FILE_UPLOAD WHERE type_id=" + type_id + " AND REF_ID=" + ref_id;
                    WebTools.ExeSql(delquery);
                    dir_id = WebTools.GetExpr("DIR_ID", "DIR_OBJECTS", " WHERE DIR_OBJ='" + dir_obj + "'");
                    break;

                case 12:
                    f_name   = WebTools.GetExpr("RFI_NO", "PIP_MAT_INSP_REQUEST", " WHERE RFI_ID='" + ref_id + "'");
                    dir_obj  = "MAT_RFI";
                    delquery = "DELETE FROM PIP_FILE_UPLOAD WHERE type_id=" + type_id + " AND REF_ID=" + ref_id;
                    WebTools.ExeSql(delquery);
                    dir_id = WebTools.GetExpr("DIR_ID", "DIR_OBJECTS", " WHERE DIR_OBJ='" + dir_obj + "'");
                    break;

                case 13:
                    f_name   = WebTools.GetExpr("MIR_NO", "PRC_MAT_INSP", " WHERE MIR_ID='" + ref_id + "'");
                    dir_obj  = "MRIR";
                    delquery = "DELETE FROM PIP_FILE_UPLOAD WHERE type_id=" + type_id + " AND REF_ID=" + ref_id;
                    WebTools.ExeSql(delquery);
                    dir_id = WebTools.GetExpr("DIR_ID", "DIR_OBJECTS", " WHERE DIR_OBJ='" + dir_obj + "'");
                    break;

                case 14:
                    f_name   = WebTools.GetExpr("MAT_REQ_NO", "MATERIAL_REQUEST", " WHERE MAT_REQ_ID='" + ref_id + "'");
                    dir_obj  = "MAT_REQUEST";
                    delquery = "DELETE FROM PIP_FILE_UPLOAD WHERE type_id=" + type_id + " AND REF_ID=" + ref_id;
                    WebTools.ExeSql(delquery);
                    dir_id = WebTools.GetExpr("DIR_ID", "DIR_OBJECTS", " WHERE DIR_OBJ='" + dir_obj + "'");
                    break;

                case 15:
                    f_name   = WebTools.GetExpr("ISSUE_NO", "PIP_MAT_ISSUE_ADD", " WHERE ADD_ISSUE_ID='" + ref_id + "'");
                    dir_obj  = "MAT_ISSUE";
                    delquery = "DELETE FROM PIP_FILE_UPLOAD WHERE type_id=" + type_id + " AND REF_ID=" + ref_id;
                    WebTools.ExeSql(delquery);
                    dir_id = WebTools.GetExpr("DIR_ID", "DIR_OBJECTS", " WHERE DIR_OBJ='" + dir_obj + "'");
                    break;

                case 16:
                    f_name   = WebTools.GetExpr("TRANSF_NO", "PIP_MAT_TRANSF", " WHERE TRANSF_ID='" + ref_id + "'");
                    dir_obj  = "MAT_TRANSFER";
                    delquery = "DELETE FROM PIP_FILE_UPLOAD WHERE type_id=" + type_id + " AND REF_ID=" + ref_id;
                    WebTools.ExeSql(delquery);
                    dir_id = WebTools.GetExpr("DIR_ID", "DIR_OBJECTS", " WHERE DIR_OBJ='" + dir_obj + "'");
                    break;

                case 17:
                    f_name   = WebTools.GetExpr("RCV_NUMBER", "PIP_MAT_TRANSFER_RCV", " WHERE RCV_ID='" + ref_id + "'");
                    dir_obj  = "TRANSF_RCV";
                    delquery = "DELETE FROM PIP_FILE_UPLOAD WHERE type_id=" + type_id + " AND REF_ID=" + ref_id;
                    WebTools.ExeSql(delquery);
                    dir_id = WebTools.GetExpr("DIR_ID", "DIR_OBJECTS", " WHERE DIR_OBJ='" + dir_obj + "'");
                    break;

                case 28:
                    f_name   = WebTools.GetExpr("RETURN_NO", "PIP_MAT_RETURN", " WHERE MAT_RET_ID='" + ref_id + "'");
                    dir_obj  = "MAT_RETURN";
                    delquery = "DELETE FROM PIP_FILE_UPLOAD WHERE type_id=" + type_id + " AND REF_ID=" + ref_id;
                    WebTools.ExeSql(delquery);
                    dir_id = WebTools.GetExpr("DIR_ID", "DIR_OBJECTS", " WHERE DIR_OBJ='" + dir_obj + "'");
                    break;

                case 30:
                    f_name   = WebTools.GetExpr("VO_NO", "PIP_PO_VARIATION", " WHERE VO_ID='" + ref_id + "'");
                    dir_obj  = "PO_VO";
                    delquery = "DELETE FROM PIP_FILE_UPLOAD WHERE type_id=" + type_id + " AND REF_ID=" + ref_id;
                    WebTools.ExeSql(delquery);
                    dir_id = WebTools.GetExpr("DIR_ID", "DIR_OBJECTS", " WHERE DIR_OBJ='" + dir_obj + "'");
                    break;

                case 31:
                    f_name   = WebTools.GetExpr("REP_NO", "PIP_MAT_EXCEPTION_REP", " WHERE EXCP_ID='" + ref_id + "'");
                    dir_obj  = "ESD";
                    delquery = "DELETE FROM PIP_FILE_UPLOAD WHERE type_id=" + type_id + " AND REF_ID=" + ref_id;
                    WebTools.ExeSql(delquery);
                    dir_id = WebTools.GetExpr("DIR_ID", "DIR_OBJECTS", " WHERE DIR_OBJ='" + dir_obj + "'");
                    break;

                case 32:
                    f_name   = WebTools.GetExpr("QRNTINE_NO", "PIP_QUARANTINE", " WHERE QRNTINE_ID='" + ref_id + "'");
                    dir_obj  = "MAT_QUARANTINE";
                    delquery = "DELETE FROM PIP_FILE_UPLOAD WHERE type_id=" + type_id + " AND REF_ID=" + ref_id;
                    WebTools.ExeSql(delquery);
                    dir_id = WebTools.GetExpr("DIR_ID", "DIR_OBJECTS", " WHERE DIR_OBJ='" + dir_obj + "'");
                    break;
                }
                f_name = f_name.Replace("/", "-");
                string Extension   = Path.GetExtension(RadAsyncUpload1.UploadedFiles[0].GetExtension());
                string FileName    = f_name + Extension;
                string u_file_name = Path.GetFileName(RadAsyncUpload1.UploadedFiles[0].GetNameWithoutExtension());

                string FolderPath = WebTools.GetExpr("PATH", "DIR_OBJECTS", " WHERE DIR_OBJ='" + dir_obj + "'");
                string FilePath   = FolderPath + FileName;
                System.IO.File.Delete(FilePath);
                RadAsyncUpload1.UploadedFiles[0].SaveAs(FilePath);

                string query = "INSERT INTO PIP_FILE_UPLOAD(TYPE_ID,REF_ID,DOC_NAME,DOC_EXT,DIR_ID,U_FILE_NAME,CREATED_BY) VALUES(" + type_id + "," + ref_id + ",'" + FileName + "','" + Extension + "','" + dir_id + "','" + u_file_name + "'," + decimal.Parse(user_id) + ")";
                WebTools.ExeSql(query);
                Master.show_success("File Uploaded");
            }

            if (RadAsyncUpload2.UploadedFiles.Count > 0)
            {
                int    type_id = int.Parse(Request.QueryString["TYPE_ID"]);
                int    ref_id  = int.Parse(Request.QueryString["REF_ID"].ToString());
                string proj_id = Session["PROJECT_ID"].ToString();

                string user_id   = WebTools.GetExpr("USER_ID", "USERS", " USER_NAME ='" + Session["USER_NAME"] + "'");
                int    filecount = RadAsyncUpload2.UploadedFiles.Count;

                string maxdoc = WebTools.CountExpr("REF_ID", "PIP_SUPP_FILE_UPLOAD", " WHERE TYPE_ID = " + type_id + " AND REF_ID = " + ref_id);
                int    doccnt = 0;
                if (maxdoc == "")
                {
                    doccnt = 1;
                }
                else
                {
                    doccnt = int.Parse(maxdoc) + 1;
                }
                for (int i = 0; i < filecount; i++)
                {
                    string f_name  = "";
                    string dir_obj = "";
                    string dir_id  = "";
                    // string irn_id = itemsGrid.SelectedValue.ToString();
                    switch (type_id)
                    {
                    case 8:
                        f_name  = WebTools.GetExpr("MR_NO", "PIP_MAT_REQUISITION", " WHERE MR_ID='" + ref_id + "'");
                        dir_obj = "MR_SUPP";
                        dir_id  = WebTools.GetExpr("DIR_ID", "DIR_OBJECTS", " WHERE DIR_OBJ='" + dir_obj + "'");
                        break;

                    case 9:
                        f_name  = WebTools.GetExpr("PO_NO", "PIP_PO", " WHERE PO_ID='" + ref_id + "'");
                        dir_obj = "PO_MASTER_SUPP";
                        dir_id  = WebTools.GetExpr("DIR_ID", "DIR_OBJECTS", " WHERE DIR_OBJ='" + dir_obj + "'");
                        break;

                    case 10:
                        f_name  = WebTools.GetExpr("RFI_NO", "PIP_PO_INSP_REQUEST", " WHERE RFI_ID='" + ref_id + "'");
                        dir_obj = "PO_RFI_SUPP";
                        dir_id  = WebTools.GetExpr("DIR_ID", "DIR_OBJECTS", " WHERE DIR_OBJ='" + dir_obj + "'");
                        break;

                    case 11:
                        f_name  = WebTools.GetExpr("MAT_RCV_NO", "PIP_MAT_RECEIVE", " WHERE MAT_RCV_ID='" + ref_id + "'");
                        dir_obj = "MRR_SUPP";
                        dir_id  = WebTools.GetExpr("DIR_ID", "DIR_OBJECTS", " WHERE DIR_OBJ='" + dir_obj + "'");
                        break;

                    case 12:
                        f_name  = WebTools.GetExpr("RFI_NO", "PIP_MAT_INSP_REQUEST", " WHERE RFI_ID='" + ref_id + "'");
                        dir_obj = "MAT_RFI_SUPP";
                        dir_id  = WebTools.GetExpr("DIR_ID", "DIR_OBJECTS", " WHERE DIR_OBJ='" + dir_obj + "'");
                        break;

                    case 13:
                        f_name  = WebTools.GetExpr("MIR_NO", "PRC_MAT_INSP", " WHERE MIR_ID='" + ref_id + "'");
                        dir_obj = "MRIR_SUPP";
                        dir_id  = WebTools.GetExpr("DIR_ID", "DIR_OBJECTS", " WHERE DIR_OBJ='" + dir_obj + "'");
                        break;

                    case 14:
                        f_name  = WebTools.GetExpr("MAT_REQ_NO", "MATERIAL_REQUEST", " WHERE MAT_REQ_ID='" + ref_id + "'");
                        dir_obj = "MAT_REQ_SUPP";
                        dir_id  = WebTools.GetExpr("DIR_ID", "DIR_OBJECTS", " WHERE DIR_OBJ='" + dir_obj + "'");
                        break;

                    case 15:
                        f_name  = WebTools.GetExpr("ISSUE_NO", "PIP_MAT_ISSUE_ADD", " WHERE ADD_ISSUE_ID='" + ref_id + "'");
                        dir_obj = "MAT_ISSUE_SUPP";
                        dir_id  = WebTools.GetExpr("DIR_ID", "DIR_OBJECTS", " WHERE DIR_OBJ='" + dir_obj + "'");
                        break;

                    case 16:
                        f_name  = WebTools.GetExpr("TRANSF_NO", "PIP_MAT_TRANSF", " WHERE TRANSF_ID='" + ref_id + "'");
                        dir_obj = "MAT_TRANSF_SUPP";
                        dir_id  = WebTools.GetExpr("DIR_ID", "DIR_OBJECTS", " WHERE DIR_OBJ='" + dir_obj + "'");
                        break;

                    case 17:
                        f_name  = WebTools.GetExpr("RCV_NUMBER", "PIP_MAT_TRANSFER_RCV", " WHERE RCV_ID='" + ref_id + "'");
                        dir_obj = "TRANSF_RCV_SUPP";
                        dir_id  = WebTools.GetExpr("DIR_ID", "DIR_OBJECTS", " WHERE DIR_OBJ='" + dir_obj + "'");
                        break;

                    case 28:
                        f_name  = WebTools.GetExpr("RETURN_NO", "PIP_MAT_RETURN", " WHERE MAT_RET_ID='" + ref_id + "'");
                        dir_obj = "MAT_RETURN_SUPP";
                        dir_id  = WebTools.GetExpr("DIR_ID", "DIR_OBJECTS", " WHERE DIR_OBJ='" + dir_obj + "'");
                        break;

                    case 30:
                        f_name  = WebTools.GetExpr("VO_NO", "PIP_PO_VARIATION", " WHERE VO_ID='" + ref_id + "'");
                        dir_obj = "PO_VO_SUPP";
                        dir_id  = WebTools.GetExpr("DIR_ID", "DIR_OBJECTS", " WHERE DIR_OBJ='" + dir_obj + "'");
                        break;

                    case 31:
                        f_name  = WebTools.GetExpr("REP_NO", "PIP_MAT_EXCEPTION_REP", " WHERE EXCP_ID='" + ref_id + "'");
                        dir_obj = "ESD_SUPP";
                        dir_id  = WebTools.GetExpr("DIR_ID", "DIR_OBJECTS", " WHERE DIR_OBJ='" + dir_obj + "'");
                        break;

                    case 32:
                        f_name  = WebTools.GetExpr("QRNTINE_NO", "PIP_QUARANTINE", " WHERE QRNTINE_ID='" + ref_id + "'");
                        dir_obj = "MAT_QRTINE_SUPP";
                        dir_id  = WebTools.GetExpr("DIR_ID", "DIR_OBJECTS", " WHERE DIR_OBJ='" + dir_obj + "'");
                        break;
                    }
                    f_name = f_name.Replace("/", "-");

                    string Extension   = Path.GetExtension(RadAsyncUpload2.UploadedFiles[i].GetExtension());
                    string FileName    = f_name + "_" + doccnt++ + Extension;
                    string u_file_name = Path.GetFileName(RadAsyncUpload2.UploadedFiles[i].GetNameWithoutExtension());
                    u_file_name = u_file_name.Replace("'", "");
                    string FolderPath = WebTools.GetExpr("PATH", "DIR_OBJECTS", " WHERE DIR_OBJ='" + dir_obj + "'");
                    string FilePath   = FolderPath + FileName;

                    RadAsyncUpload2.UploadedFiles[i].SaveAs(FilePath);

                    string query = "INSERT INTO PIP_SUPP_FILE_UPLOAD(TYPE_ID,REF_ID,DOC_NAME,DOC_EXT,DIR_ID,U_FILE_NAME,CREATED_BY) VALUES(" + type_id + "," + ref_id + ",'" + FileName + "','" + Extension + "','" + dir_id + "','" + u_file_name + "'," + decimal.Parse(user_id) + ")";
                    WebTools.ExeSql(query);
                    Master.show_success("Files Uploaded");
                }
            }
        }
        catch (Exception ex)
        {
            Master.show_error(ex.Message);
        }
    }
    protected void btnSave_Click(object sender, EventArgs e)
    {
        try
        {
            if (chk4.Checked == true)
            {
                if (txtchk4.Text == "")
                {
                    Master.ShowError("Fill check box 4 text value");
                    return;
                }
            }
            if (chk7.Checked == true)
            {
                if (txtchk7.Text == "")
                {
                    Master.ShowError("Fill check box 7 text value");
                    return;
                }
            }
            string uname   = Session["USER_NAME"].ToString().ToUpper();
            string user_id = WebTools.GetExpr("USER_ID", "USERS", " WHERE UPPER(USER_NAME)='" + uname + "'");
            VIEW_PO_IRNTableAdapter irn = new VIEW_PO_IRNTableAdapter();
            string dclient = "N";
            if (chkDClient.Checked == true)
            {
                dclient = "Y";
            }

            string dsupp = "N";
            if (chkDSupp.Checked == true)
            {
                dsupp = "Y";
            }
            string dsubsupp = "N";
            if (chkDSubSup.Checked == true)
            {
                dsubsupp = "Y";
            }
            string dsubcon = "N";
            if (chkDSubcon.Checked == true)
            {
                dsubcon = "Y";
            }



            irn.InsertQuery(decimal.Parse(Session["PROJECT_ID"].ToString()), txtIRNNumber.Text, txtRev.Text, txtIRNCreateDate.SelectedDate, vendorType.SelectedValue,
                            poStatus.SelectedValue, decimal.Parse(ddlVendor.SelectedValue), vendorReport.SelectedValue, txtRemarks.Text, decimal.Parse(user_id), ddlInspResult.SelectedValue, decimal.Parse(ddlPO.SelectedValue),
                            txtPOContact.Text, txtPOEmail.Text, txtPOPhone.Text, txtVendorContactName.Text, txtVendorPhone.Text, dclient, dsupp, dsupp, dsubcon, txtPreparedBy.Text, txtReviewedBy.Text, txtApprovedBy.Text, ddlVO.SelectedValue);

            //register RFI
            var    collection = ddlRFINo.CheckedItems;
            string irn_id     = WebTools.GetExpr("IRN_ID", "PIP_PO_IRN", " WHERE IRN_NO='" + txtIRNNumber.Text + "'");
            foreach (var item in collection)
            {
                string q = "INSERT INTO PIP_PO_IRN_RFI VALUES(" + decimal.Parse(irn_id) + ",'" + item.Value + "')";
                WebTools.ExeSql(q);
            }

            //marjor irn reports
            var major = MajorIReports.CheckedItems;
            foreach (var item in major)
            {
                string q = "INSERT INTO PIP_PO_IRN_MAJOR_REPORT VALUES(" + decimal.Parse(irn_id) + ",'" + item.Value + "')";
                WebTools.ExeSql(q);
            }

            //irn result checkboxes need to move to for loop
            if (chk1.Checked == true)
            {
                string q = "INSERT INTO PIP_PO_IRN_RESULT(IRN_ID, RESULT_TEXT, REMARKS, IRN_RESULT_ID) VALUES(" + decimal.Parse(irn_id) + ",+'" + lb1.Text + "',null,1)";
                WebTools.ExeSql(q);
            }
            if (chk2.Checked == true)
            {
                string q = "INSERT INTO PIP_PO_IRN_RESULT(IRN_ID, RESULT_TEXT, REMARKS, IRN_RESULT_ID) VALUES(" + decimal.Parse(irn_id) + ",+'" + lb2.Text + "',null,2)";
                WebTools.ExeSql(q);
            }
            if (chk3.Checked == true)
            {
                string q = "INSERT INTO PIP_PO_IRN_RESULT(IRN_ID, RESULT_TEXT, REMARKS, IRN_RESULT_ID) VALUES(" + decimal.Parse(irn_id) + ",+'" + lb3.Text + "',null,3)";
                WebTools.ExeSql(q);
            }
            if (chk4.Checked == true)
            {
                string q = "INSERT INTO PIP_PO_IRN_RESULT(IRN_ID, RESULT_TEXT, REMARKS, IRN_RESULT_ID) VALUES(" + decimal.Parse(irn_id) + ",+'" + lb4.Text + txtchk4.Text + "','" + txtchk4.Text + "',4)";
                WebTools.ExeSql(q);
            }
            if (chk5.Checked == true)
            {
                string q = "INSERT INTO PIP_PO_IRN_RESULT(IRN_ID, RESULT_TEXT, REMARKS, IRN_RESULT_ID) VALUES(" + decimal.Parse(irn_id) + ",+'" + lb5.Text + "',null,5)";
                WebTools.ExeSql(q);
            }

            if (chk6.Checked == true)
            {
                string q = "INSERT INTO PIP_PO_IRN_RESULT(IRN_ID, RESULT_TEXT, REMARKS, IRN_RESULT_ID) VALUES(" + decimal.Parse(irn_id) + ",+'" + lb6.Text + "',null,6)";
                WebTools.ExeSql(q);
            }
            if (chk7.Checked == true)
            {
                string q = "INSERT INTO PIP_PO_IRN_RESULT(IRN_ID, RESULT_TEXT, REMARKS, IRN_RESULT_ID) VALUES(" + decimal.Parse(irn_id) + ",+'" + txtchk7.Text + "','" + txtchk7.Text + "',7)";
                WebTools.ExeSql(q);
            }

            //if (chk7.Checked == true)
            //{

            //    string[] chk7items = new string[txtchk7.Entries.Count];

            //    for (int i = 0; i < txtchk7.Entries.Count; i++)
            //    {
            //        chk7items[i] = txtchk7.Entries[i].Text;
            //        string q = "INSERT INTO PIP_PO_IRN_RESULT(IRN_ID, RESULT_TEXT, REMARKS, IRN_RESULT_ID) VALUES(" + decimal.Parse(irn_id) + ",+'" + txtchk7.Entries[i].Text + "','"+ txtchk7.Entries[i].Text+"',7)";
            //        WebTools.ExeSql(q);
            //    }
            //}
            /////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
            ///////////////////////////-------

            string irn_no  = WebTools.GetExpr("IRN_NO", "PIP_PO_IRN", " WHERE IRN_ID='" + irn_id + "'");
            string proj_id = Session["PROJECT_ID"].ToString();
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
            if (txtFileUpload1.HasFile)
            {
                string Extension = Path.GetExtension(txtFileUpload1.PostedFile.FileName);

                string u_file_name = Path.GetFileName(txtFileUpload1.PostedFile.FileName);

                string FolderPath = WebTools.GetExpr("PATH", "DIR_OBJECTS", " WHERE DIR_ID=6");

                string maxdoc = WebTools.CountExpr("IRN_ID", "PIP_PO_IR_DOCS", " WHERE IRN_ID=" + irn_id);
                int    doccnt = 0;
                if (maxdoc == "")
                {
                    doccnt = 1;
                }
                else
                {
                    doccnt = int.Parse(maxdoc) + 1;
                }
                string irn_no2 = irn_no.Replace("/", "-");
                u_file_name = u_file_name.Replace("'", "");
                string Filename = irn_no2 + "_" + doccnt + Extension;
                string FilePath = FolderPath + Filename;

                txtFileUpload1.SaveAs(FilePath);
                string   date1 = txtRepDate1.SelectedDate.ToString();
                DateTime dt    = DateTime.Parse(txtRepDate1.SelectedDate.ToString());
                string   query = "INSERT INTO PIP_PO_IR_DOCS(IRN_ID,DOC_NAME,DOC_EXT,DIR_ID,U_FILE_NAME,REPORT_NO,REP_DATE) VALUES(" + irn_id + ",'" + Filename + "','" + Extension + "','" + 6 + "','" + u_file_name + "','" + txtRep1.Text + "','" + dt.ToString("dd-MMM-yyyy") + "')";
                WebTools.ExeSql(query);
            }

            /////////2
            if (txtFileUpload2.HasFile)
            {
                string Extension = Path.GetExtension(txtFileUpload2.PostedFile.FileName);

                string u_file_name = Path.GetFileName(txtFileUpload2.PostedFile.FileName);

                string FolderPath = WebTools.GetExpr("PATH", "DIR_OBJECTS", " WHERE DIR_ID=6");

                string maxdoc = WebTools.CountExpr("IRN_ID", "PIP_PO_IR_DOCS", " WHERE IRN_ID=" + irn_id);
                int    doccnt = 0;
                if (maxdoc == "")
                {
                    doccnt = 1;
                }
                else
                {
                    doccnt = int.Parse(maxdoc) + 1;
                }
                string irn_no2 = irn_no.Replace("/", "-");
                u_file_name = u_file_name.Replace("'", "");
                string Filename = irn_no2 + "_" + doccnt + Extension;
                string FilePath = FolderPath + Filename;

                txtFileUpload2.SaveAs(FilePath);
                string   date1 = txtRepDate2.SelectedDate.ToString();
                DateTime dt    = DateTime.Parse(txtRepDate2.SelectedDate.ToString());
                string   query = "INSERT INTO PIP_PO_IR_DOCS(IRN_ID,DOC_NAME,DOC_EXT,DIR_ID,U_FILE_NAME,REPORT_NO,REP_DATE) VALUES(" + irn_id + ",'" + Filename + "','" + Extension + "','" + 6 + "','" + u_file_name + "','" + txtRep2.Text + "','" + dt.ToString("dd-MMM-yyyy") + "')";
                WebTools.ExeSql(query);
            }
            //////3
            if (txtFileUpload3.HasFile)
            {
                string Extension = Path.GetExtension(txtFileUpload3.PostedFile.FileName);

                string u_file_name = Path.GetFileName(txtFileUpload3.PostedFile.FileName);

                string FolderPath = WebTools.GetExpr("PATH", "DIR_OBJECTS", " WHERE DIR_ID=6");

                string maxdoc = WebTools.CountExpr("IRN_ID", "PIP_PO_IR_DOCS", " WHERE IRN_ID=" + irn_id);
                int    doccnt = 0;
                if (maxdoc == "")
                {
                    doccnt = 1;
                }
                else
                {
                    doccnt = int.Parse(maxdoc) + 1;
                }
                string irn_no2 = irn_no.Replace("/", "-");
                u_file_name = u_file_name.Replace("'", "");
                string Filename = irn_no2 + "_" + doccnt + Extension;
                string FilePath = FolderPath + Filename;

                txtFileUpload3.SaveAs(FilePath);
                string   date1 = txtRepDate3.SelectedDate.ToString();
                DateTime dt    = DateTime.Parse(txtRepDate3.SelectedDate.ToString());
                string   query = "INSERT INTO PIP_PO_IR_DOCS(IRN_ID,DOC_NAME,DOC_EXT,DIR_ID,U_FILE_NAME,REPORT_NO,REP_DATE) VALUES(" + irn_id + ",'" + Filename + "','" + Extension + "','" + 6 + "','" + u_file_name + "','" + txtRep3.Text + "','" + dt.ToString("dd-MMM-yyyy") + "')";
                WebTools.ExeSql(query);
            }
            //////4
            if (txtFileUpload4.HasFile)
            {
                string Extension = Path.GetExtension(txtFileUpload4.PostedFile.FileName);

                string u_file_name = Path.GetFileName(txtFileUpload4.PostedFile.FileName);

                string FolderPath = WebTools.GetExpr("PATH", "DIR_OBJECTS", " WHERE DIR_ID=6");

                string maxdoc = WebTools.CountExpr("IRN_ID", "PIP_PO_IR_DOCS", " WHERE IRN_ID=" + irn_id);
                int    doccnt = 0;
                if (maxdoc == "")
                {
                    doccnt = 1;
                }
                else
                {
                    doccnt = int.Parse(maxdoc) + 1;
                }
                string irn_no2 = irn_no.Replace("/", "-");
                u_file_name = u_file_name.Replace("'", "");
                string Filename = irn_no2 + "_" + doccnt + Extension;
                string FilePath = FolderPath + Filename;

                txtFileUpload4.SaveAs(FilePath);
                string   date1 = txtRepDate4.SelectedDate.ToString();
                DateTime dt    = DateTime.Parse(txtRepDate4.SelectedDate.ToString());
                string   query = "INSERT INTO PIP_PO_IR_DOCS(IRN_ID,DOC_NAME,DOC_EXT,DIR_ID,U_FILE_NAME,REPORT_NO,REP_DATE) VALUES(" + irn_id + ",'" + Filename + "','" + Extension + "','" + 6 + "','" + u_file_name + "','" + txtRep4.Text + "','" + dt.ToString("dd-MMM-yyyy") + "')";
                WebTools.ExeSql(query);
            }

            //5
            if (txtFileUpload5.HasFile)
            {
                string Extension = Path.GetExtension(txtFileUpload5.PostedFile.FileName);

                string u_file_name = Path.GetFileName(txtFileUpload5.PostedFile.FileName);

                string FolderPath = WebTools.GetExpr("PATH", "DIR_OBJECTS", " WHERE DIR_ID=6");

                string maxdoc = WebTools.CountExpr("IRN_ID", "PIP_PO_IR_DOCS", " WHERE IRN_ID=" + irn_id);
                int    doccnt = 0;
                if (maxdoc == "")
                {
                    doccnt = 1;
                }
                else
                {
                    doccnt = int.Parse(maxdoc) + 1;
                }
                string irn_no2 = irn_no.Replace("/", "-");
                u_file_name = u_file_name.Replace("'", "");
                string Filename = irn_no2 + "_" + doccnt + Extension;
                string FilePath = FolderPath + Filename;

                txtFileUpload5.SaveAs(FilePath);
                string   date1 = txtRepDate5.SelectedDate.ToString();
                DateTime dt    = DateTime.Parse(txtRepDate5.SelectedDate.ToString());
                string   query = "INSERT INTO PIP_PO_IR_DOCS(IRN_ID,DOC_NAME,DOC_EXT,DIR_ID,U_FILE_NAME,REPORT_NO,REP_DATE) VALUES(" + irn_id + ",'" + Filename + "','" + Extension + "','" + 6 + "','" + u_file_name + "','" + txtRep5.Text + "','" + dt.ToString("dd-MMM-yyyy") + "')";
                WebTools.ExeSql(query);
            }

            ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
            Master.ShowSuccess("IRN Created");
        }
        catch (Exception ex)
        {
            Master.ShowError(ex.Message);
        }
    }
Esempio n. 21
0
    protected void btnTextDataUpdate_Click(object sender, ImageClickEventArgs e)
    {
        try
        {
            //sg_text_imported_records
            string query6 = "BEGIN EXECUTE IMMEDIATE('TRUNCATE TABLE SG_TEXT_IMPORTED_RECORDS'); END;";
            WebTools.ExeSql(query6);

            string query = "BEGIN EXECUTE IMMEDIATE('TRUNCATE TABLE SG_IMPORT_ERROR'); END;";
            WebTools.ExeSql(query);

            string[] import_types = { "SPOOLINFO", "CUTLIST", "WELD", "SITEASSY", "LOM" };

            try
            {
                //Settings
                WebTools.ExeSql("UPDATE project_setting SET   sg_ignore_and_log__error='" + (chkIgnoreImportError.Checked ? "Y" : "N") + "'" +
                                ", sg_define_new_iso='" + (chkDefineNewIso.Checked ? "Y" : "N") + "', sg_ignore_imported_iso='" + (chkDontUploadImportedISO.Checked ? "Y" : "N") + "'" +
                                "WHERE project_id=" + Session["PROJECT_ID"].ToString());

                //Loop through each directory
                foreach (string import_type in import_types)
                {
                    //Get destination table names
                    string table_name = import_type == "CUTLIST" ? "SG_CUT_LIST"
                    : import_type == "LOM" ? "SG_MAT_CONTROL"
                    : import_type == "WELD" ? "SG_WELDING"
                    : import_type == "SPOOLINFO" ? "SG_SPL_INFO"
                    : import_type == "SITEASSY" ? "SG_SITE_ASSEMBLY" : "DUAL";

                    //sg_text_location = WebTools.GetExpr("PATH", "DIR_OBJECTS", "DIR_OBJ='SG_DATA_TEXT'");
                    string file_location = sg_text_location + import_type + "\\";

                    //Loop through each files in the directory
                    //  string file_location = MoveToNewDirectory(import_type);
                    foreach (string strFile in Directory.GetFiles(file_location))
                    {
                        FileInfo fi            = new FileInfo(strFile);
                        string   full_FileName = fi.FullName;
                        string   FileName      = fi.Name;
                        using (StreamReader reader = new StreamReader(full_FileName))
                        {
                            string line = "";
                            while ((line = reader.ReadLine()) != null)
                            {
                                line = line.Replace("'", "");
                                //lblMessage.Text = line + "</BR>";
                                try
                                {
                                    WebTools.ExeSql("INSERT INTO sg_text_imported_records(record_row, import_type, file_name)VALUES('" + line + "','" + import_type + "','" + FileName + "')");
                                }
                                catch (Exception exc)
                                {
                                    WebTools.exec_non_qry("INSERT INTO SG_IMPORT_ERROR(PROJECT_ID, FILE_NAME, ERROR_MSG, IMPORT_TYPE) " +
                                                          " VALUES('1', '" + FileName + "', 'During import : " + exc.Message + "', '" + import_type + "')");
                                    Master.ShowError(exc.Message);
                                    return;
                                }
                            }
                        }
                    }
                }

                string query7 = "BEGIN EXECUTE IMMEDIATE('TRUNCATE TABLE SG_IMPORT_ERR'); END;";
                WebTools.ExeSql(query7);

                string query1 = "BEGIN EXECUTE IMMEDIATE('TRUNCATE TABLE SG_CUT_LIST'); END;";
                WebTools.ExeSql(query1);

                string query2 = "BEGIN EXECUTE IMMEDIATE('TRUNCATE TABLE SG_MAT_CONTROL'); END;";
                WebTools.ExeSql(query2);

                string query3 = "BEGIN EXECUTE IMMEDIATE('TRUNCATE TABLE SG_SITE_ASSEMBLY'); END;";
                WebTools.ExeSql(query3);

                string query4 = "BEGIN EXECUTE IMMEDIATE('TRUNCATE TABLE SG_SPL_INFO'); END;";
                WebTools.ExeSql(query4);

                string query5 = "BEGIN EXECUTE IMMEDIATE('TRUNCATE TABLE SG_WELDING'); END;";
                WebTools.ExeSql(query5);
            }
            catch (Exception exc)
            {
                Master.ShowError(exc.Message);
            }

            try
            {
                WebTools.ExeSql("BEGIN  PROC_UPDATE_SG_UPLOADED (" + Session["PROJECT_ID"].ToString() + ");  END;");
                WebTools.ExeSql("BEGIN  update_sg_data;  END;");
            }
            catch (Exception ex)
            {
                lblMessage.Text = "<font color='red'>" + ex.Message + "</font>";
                return;
            }

            //ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Spoolgen Text Imported Successfully!!!');", true);

            string errors       = WebTools.CountExpr("ERROR_MSG", "SG_IMPORT_ERROR", "PROJECT_ID=" + Session["PROJECT_ID"].ToString());
            string errors2      = WebTools.CountExpr("SQL_ERROR", "packaged_exceptions", "PACKAGE_NAME='PKG_UPDATE_SG_DATA'");
            string total_errors = (Convert.ToInt32(errors) + Convert.ToInt32(errors2)).ToString();
            if (total_errors.Equals("0"))
            {
                lblMessage.Text = "Spoolgen Text Imported Successfully!! Please proceed for Server Updates!";
                //btnTextDataUpdate.Visible = false;
            }
            else
            {
                lblMessage.Text = "<font color='red'>" + total_errors + " error(s) occured during import !" + "</font>";
                //WebTools.ExportDataSetToExcel(SqlDataSource1, "SgImportErrorLog.xls");
            }
        }
        catch (Exception ex)
        {
            lblMessage.Text = "<font color='red'>" + ex.Message + "</font>";
            return;
        }
    }
Esempio n. 22
0
    protected void btnImport_Click(object sender, EventArgs e)
    {
        try
        {
            if (RadAsyncUpload1.UploadedFiles.Count == 0 && RadAsyncUpload2.UploadedFiles.Count == 0)
            {
                Master.show_error("Please Upload File to proceed.");
                return;
            }
            if (Request.QueryString["REF_ID"] == "")
            {
                Master.show_error("Select Request Number To Upload");
                return;
            }
            ///////////////////////////////////////////////////////////////////////////////////////////////////////
            if (RadAsyncUpload1.UploadedFiles.Count > 0)
            {
                int    type_id = int.Parse(Request.QueryString["TYPE_ID"]);
                int    ref_id  = int.Parse(Request.QueryString["REF_ID"].ToString());
                string proj_id = Session["PROJECT_ID"].ToString();

                string user_id  = WebTools.GetExpr("USER_ID", "USERS", " USER_NAME ='" + Session["USER_NAME"] + "'");
                string f_name   = "";
                string dir_obj  = "";
                string dir_id   = "";
                string delquery = "";
                // string irn_id = itemsGrid.SelectedValue.ToString();
                switch (type_id)
                {
                case 1:
                    f_name   = WebTools.GetExpr("REQ_NO", "PIP_MAT_SUBSTITUTE", " WHERE REQ_ID='" + ref_id + "'");
                    dir_obj  = "MAT_SUBSTITUTE";
                    delquery = "DELETE FROM PIP_FILE_UPLOAD WHERE type_id=" + type_id + " AND REF_ID=" + ref_id;
                    WebTools.ExeSql(delquery);
                    dir_id = WebTools.GetExpr("DIR_ID", "DIR_OBJECTS", " WHERE DIR_OBJ='" + dir_obj + "'");
                    break;
                }
                f_name = f_name.Replace("/", "-");
                string Extension   = Path.GetExtension(RadAsyncUpload1.UploadedFiles[0].GetExtension());
                string FileName    = f_name + Extension;
                string u_file_name = Path.GetFileName(RadAsyncUpload1.UploadedFiles[0].GetNameWithoutExtension());

                string FolderPath = WebTools.GetExpr("PATH", "DIR_OBJECTS", " WHERE DIR_OBJ='" + dir_obj + "'");
                string FilePath   = FolderPath + FileName;
                System.IO.File.Delete(FilePath);
                RadAsyncUpload1.UploadedFiles[0].SaveAs(FilePath);

                string query = "INSERT INTO PIP_FILE_UPLOAD(TYPE_ID,REF_ID,DOC_NAME,DOC_EXT,DIR_ID,U_FILE_NAME,CREATED_BY) VALUES(" + type_id + "," + ref_id + ",'" + FileName + "','" + Extension + "','" + dir_id + "','" + u_file_name + "'," + decimal.Parse(user_id) + ")";
                WebTools.ExeSql(query);
                Master.show_success("File Uploaded");
            }

            if (RadAsyncUpload2.UploadedFiles.Count > 0)
            {
                int    type_id = int.Parse(Request.QueryString["TYPE_ID"]);
                int    ref_id  = int.Parse(Request.QueryString["REF_ID"].ToString());
                string proj_id = Session["PROJECT_ID"].ToString();

                string user_id   = WebTools.GetExpr("USER_ID", "USERS", " USER_NAME ='" + Session["USER_NAME"] + "'");
                int    filecount = RadAsyncUpload2.UploadedFiles.Count;

                string maxdoc = WebTools.CountExpr("REF_ID", "PIP_SUPP_FILE_UPLOAD", " WHERE TYPE_ID = " + type_id + " AND REF_ID = " + ref_id);
                int    doccnt = 0;
                if (maxdoc == "")
                {
                    doccnt = 1;
                }
                else
                {
                    doccnt = int.Parse(maxdoc) + 1;
                }
                for (int i = 0; i < filecount; i++)
                {
                    string f_name  = "";
                    string dir_obj = "";
                    string dir_id  = "";
                    // string irn_id = itemsGrid.SelectedValue.ToString();
                    switch (type_id)
                    {
                    case 1:
                        f_name  = WebTools.GetExpr("REQ_NO", "PIP_MAT_SUBSTITUTE", " WHERE REQ_ID='" + ref_id + "'");
                        dir_obj = "MAT_SUBST_SUPP";
                        dir_id  = WebTools.GetExpr("DIR_ID", "DIR_OBJECTS", " WHERE DIR_OBJ='" + dir_obj + "'");
                        break;
                    }
                    f_name = f_name.Replace("/", "-");

                    string Extension   = Path.GetExtension(RadAsyncUpload2.UploadedFiles[i].GetExtension());
                    string FileName    = f_name + "_" + doccnt++ + Extension;
                    string u_file_name = Path.GetFileName(RadAsyncUpload2.UploadedFiles[i].GetNameWithoutExtension());
                    u_file_name = u_file_name.Replace("'", "");
                    string FolderPath = WebTools.GetExpr("PATH", "DIR_OBJECTS", " WHERE DIR_OBJ='" + dir_obj + "'");
                    string FilePath   = FolderPath + FileName;

                    RadAsyncUpload2.UploadedFiles[i].SaveAs(FilePath);

                    string query = "INSERT INTO PIP_SUPP_FILE_UPLOAD(TYPE_ID,REF_ID,DOC_NAME,DOC_EXT,DIR_ID,U_FILE_NAME,CREATED_BY) VALUES(" + type_id + "," + ref_id + ",'" + FileName + "','" + Extension + "','" + dir_id + "','" + u_file_name + "'," + decimal.Parse(user_id) + ")";
                    WebTools.ExeSql(query);
                    Master.show_success("Files Uploaded");
                }
            }
        }
        catch (Exception ex)
        {
            Master.show_error(ex.Message);
        }
    }
Esempio n. 23
0
    protected void btnSave_Click(object sender, EventArgs e)
    {
        try
        {
            string tc_id = "";

            if (txtAutoMTCCode.Entries.Count > 0)
            {
                string po_id = WebTools.GetExpr("PO_ID", "PRC_MAT_INSP", " MIR_ID='" + Session["popUp_MIR_ID"].ToString() + "'");
                tc_id = WebTools.GetExpr("TC_ID", "PIP_TEST_CARDS", " UPPER(TC_CODE) = '" + txtAutoMTCCode.Entries[0].Text.ToUpper() + "' and PO_ID = '" + po_id + "'");

                if (tc_id.Trim().Length == 0)
                {
                    //Register New MTC Code.
                    string sql = "INSERT INTO PIP_TEST_CARDS (PROJECT_ID, TC_CODE, PO_ID) VALUES ('" + Session["PROJECT_ID"].ToString() + "', '" +
                                 txtAutoMTCCode.Entries[0].Text.Trim() + "','" + po_id + "')";
                    WebTools.ExeSql(sql);

                    //Get TC_ID for New MTC Code
                    tc_id = WebTools.GetExpr("TC_ID", "PIP_TEST_CARDS", " UPPER(TC_CODE) = '" + txtAutoMTCCode.Entries[0].Text.ToUpper() + "'");
                }
            }
            else
            {
                Master.show_error("MTC Number cannot be blank.");
                return;
            }
            string mat_id = WebTools.GetExpr("MAT_ID", "PIP_MAT_STOCK", " MAT_CODE1='" + txtMatCode.Text + "'");


            string itemid = WebTools.GetExpr("ITEM_ID", "PIP_MAT_STOCK", " MAT_ID= " + mat_id);

            if (itemid != "19")
            {
                if (txtAcptQty.Text.ToString().IndexOf('.') > 0 || txtRcvQty.Text.ToString().IndexOf('.') > 0)
                {
                    Master.show_error("Selected Item cannot be in received in decimal Qty. <br/>Please Enter Integer Value.");
                    return;
                }
            }

            if (decimal.Parse(txtAcptQty.Text.ToString()) > decimal.Parse(txtRcvQty.Text.ToString()))
            {
                Master.show_error("Accepted quantity cannot be more than received qty. <br/>Please re-check and enter valid value.");
                return;
            }

            decimal?substore_id = null;
            if (ddlSubStorList.SelectedIndex > 0)
            {
                substore_id = decimal.Parse(ddlSubStorList.SelectedValue);
            }

            string heat_no = string.Empty;
            if (txtAutoHeatNo.Entries.Count == 0)
            {
                heat_no = "";
            }
            else
            {
                heat_no = txtAutoHeatNo.Entries[0].Text;
            }


            string sql1 = "";
            sql1  = "INSERT INTO PRC_MAT_INSP_DETAIL(MIR_ID, PO_ITEM, MIR_ITEM, MAT_ID, RCV_QTY, ACPT_QTY, HEAT_NO, PAINT_SYS, TC_ID, SUBSTORE_ID, REMARKS,CEVALUE, AS_PER_PL_QTY, EXC_QTY, SH_QTY, DAMAG_QTY) ";
            sql1 += "VALUES('" + Session["popUp_MIR_ID"].ToString() + "', '" + txtPOItemNO.Text + "','" + txtMIRItemNo.Text + "','" + mat_id + "','";
            sql1 += txtRcvQty.Text + "','" + txtAcptQty.Text + "','" + heat_no + "','" + txtPS.Text + "','" + tc_id + "','" + substore_id + "','";
            sql1 += txtRemarks.Text + "','', '', '" + txtExcessQty.Text + "','" + txtShortage.Text + "','" + txtDamage.Text + "')";
            // Master.show_success(sql1);
            WebTools.ExeSql(sql1);
            string query = string.Empty;
            try
            {
                //Update SRN No
                string   srn_no  = WebTools.GetExpr("SRN_NO", "PRC_MAT_INSP", " WHERE MIR_ID='" + Session["popUp_MIR_ID"].ToString() + "'");
                string   srn_no1 = string.Empty;
                string[] srn;

                if (srn_no.Contains(','))
                {
                    srn = srn_no.Split(',');
                    string po_id = WebTools.GetExpr("PO_ID", "PRC_MAT_INSP", " WHERE MIR_ID='" + Session["popUp_MIR_ID"].ToString() + "'");
                    string count = WebTools.CountExpr("DISTINCT SRN_NO", "PIP_PO_SPLIT_DETAIL", " WHERE PO_ID = '" + po_id + "' AND PO_ITEM = '" + txtPOItemNO.Text + "'");
                    if (decimal.Parse(count) == 1)
                    {
                        srn_no1 = WebTools.DMaxText("SRN_NO", "PIP_PO_SPLIT_DETAIL", " WHERE PO_ID = '" + po_id + "' AND PO_ITEM = '" + txtPOItemNO.Text + "'");
                    }
                    else
                    {
                        for (int i = 0; i < srn.Length; i++)
                        {
                            srn_no1 = WebTools.DMaxText("SRN_NO", "PIP_PO_SPLIT_DETAIL", " WHERE PO_ID = '" + po_id + "' AND PO_ITEM = '" + txtPOItemNO.Text + "' AND SRN_NO='" + srn[i] + "'");
                            if (srn_no1.Length > 0)
                            {
                                break;
                            }
                        }
                    }
                }
                else
                {
                    srn_no1 = srn_no;
                }

                query = "UPDATE PRC_MAT_INSP_DETAIL SET SRN_NO = '" + srn_no1 + "' WHERE MIR_ID = '" + Session["popUp_MIR_ID"].ToString() + "' " +
                        "  AND MIR_ITEM='" + txtMIRItemNo.Text + "'";

                WebTools.ExeSql(query);
            }
            catch (Exception ex)
            {
                //Don't do anything
            }
            Master.show_success(txtMatCode.Text + " Added Successfully.");
            //Master.show_success(query);
        }
        catch (Exception ex)
        {
            Master.show_error(ex.Message);
        }
    }
Esempio n. 24
0
    protected string collect_pdfs(string source_directory, string target_directory, string specific_file)
    {
        string message = null;

        int Total = Directory.GetFiles(source_directory).Count();

        RadProgressContext progress = RadProgressContext.Current;

        progress.Speed = "N/A";

        int i = 1;

        //non replacement drawings
        try
        {
            foreach (string f in Directory.GetFiles(source_directory))
            {
                progress.PrimaryTotal   = 1;
                progress.PrimaryValue   = 1;
                progress.PrimaryPercent = 100;

                progress.SecondaryTotal   = Total;
                progress.SecondaryValue   = i;
                progress.SecondaryPercent = Math.Round((double)(i * 100 / Total), 0);

                progress.CurrentOperationText = "Step " + i.ToString();

                if (!Response.IsClientConnected)
                {
                    //Cancel button was clicked or the browser was closed, so stop processing
                    break;
                }

                progress.TimeEstimated = (Total - i) * 100;
                //Stall the current thread for 0.1 seconds
                System.Threading.Thread.Sleep(100);

                string file_name = f.Replace(source_directory, "").Replace("\\", "").ToUpper();

                //CHECK  if pdf name does not contain SPL then its ISO pdf also ignore PDFs with transmittal name
                if (specific_file.Equals("ISO_SPOOLGEN"))
                {
                    if (file_name.Contains(".PDF") && !file_name.Contains("_SPL-") &&
                        WebTools.CountExpr("SERIAL_NO", "PIP_DWG_TRANS", "SERIAL_NO='" + file_name.Replace(".PDF", "") + "'").Equals("0"))
                    {
                        if (!File.Exists(target_directory + file_name))
                        {
                            File.Copy(f, target_directory + file_name, true);
                        }
                    }
                }
                else if (specific_file.Equals("SPL_SPOOLGEN"))
                {
                    if (file_name.Contains(".PDF") && file_name.Contains("_SPL-"))
                    {
                        if (!File.Exists(target_directory + file_name))
                        {
                            File.Copy(f, target_directory + file_name, true);
                        }
                    }
                }

                else if (specific_file.Equals("ISO_HARDCOPY"))
                {
                    if (file_name.EndsWith(".PDF") &&
                        !WebTools.CountExpr("ISO_TITLE1", "PIP_ISOMETRIC", "'" + file_name.Replace(".PDF", "") + "' LIKE ISO_TITLE1||'%'").Equals("0"))
                    {
                        if (!File.Exists(target_directory + file_name))
                        {
                            File.Copy(f, target_directory + file_name, true);
                        }
                    }
                }


                else if (specific_file.Equals("MTC_PDF"))
                {
                    if (file_name.EndsWith(".PDF") &&
                        !WebTools.CountExpr("TC_CODE", "TEST_CERTIFICATE", "'" + file_name.Replace(".PDF", "") + "' LIKE TC_CODE||'%'").Equals("0"))
                    {
                        if (!File.Exists(target_directory + file_name))
                        {
                            File.Copy(f, target_directory + file_name, true);
                        }
                    }
                }
                i++;
            }

            //foreach (string subDir in Directory.GetDirectories(@source_directory))
            //{
            //    collect_pdfs(subDir, target_directory, specific_file);
            //}
            Master.show_success("PDFs collected successfully ! Please proceed for flag update!");
        }
        catch (Exception ex)
        {
            message = "<font color='red'>" + ex.Message + "</font>";
        }
        return(message);
    }
Esempio n. 25
0
    private void RefreshButtons()
    {
        string amg_import  = "~/Import_Format/AmoghSgImport/";
        string Epic_import = "~/Import_Format/EpicSgImport/";

        string dir_obj = importformat.SelectedValue.ToString();


        if (dir_obj == "AMOGH_DATA_IMPORT")
        {
            HyperLink1.NavigateUrl = amg_import + "CUTLIST.xlsx";
            HyperLink2.NavigateUrl = amg_import + "SPOOL.xlsx";
            HyperLink3.NavigateUrl = amg_import + "JOINT.xlsx";
            HyperLink4.NavigateUrl = amg_import + "LOM.xlsx";
            HyperLink5.NavigateUrl = amg_import + "SITEJOINT.xlsx";
            txtAmoghOutput.Visible = true;
            txtEpicOutput.Visible  = false;


            string cutlist_cnt = WebTools.CountExpr("IMPORT_REMARKS", "CLIENT_CUT_LIST_AMOGH", " WHERE IMPORT_REMARKS IS NOT NULL ");
            string spl_cnt     = WebTools.CountExpr("IMPORT_REMARKS", "CLIENT_SPOOL_AMOGH", " WHERE IMPORT_REMARKS IS NOT NULL ");
            string jnt_cnt     = WebTools.CountExpr("IMPORT_REMARKS", "CLIENT_JOINT_AMOGH", " WHERE IMPORT_REMARKS IS NOT NULL ");
            string lom_cnt     = WebTools.CountExpr("IMPORT_REMARKS", "CLIENT_LOM_AMOGH", " WHERE IMPORT_REMARKS IS NOT NULL ");
            string siteJnt_cnt = WebTools.CountExpr("IMPORT_REMARKS", "CLIENT_SITE_JOINT_AMOGH", " WHERE IMPORT_REMARKS IS NOT NULL ");
            if (cutlist_cnt != "0")
            {
                btnCutlist.Visible = true;
            }
            else
            {
                btnCutlist.Visible = false;
            }
            if (spl_cnt != "0")
            {
                btnSpool.Visible = true;
            }
            else
            {
                btnSpool.Visible = false;
            }
            if (jnt_cnt != "0")
            {
                btnJoint.Visible = true;
            }
            else
            {
                btnJoint.Visible = false;
            }
            if (lom_cnt != "0")
            {
                btnLom.Visible = true;
            }

            else
            {
                btnLom.Visible = false;
            }
            if (siteJnt_cnt != "0")
            {
                btnFlange.Visible = true;
            }
            else
            {
                btnFlange.Visible = false;
            }
        }

        if (dir_obj == "EPIC_DATA_IMPORT")
        {
            HyperLink6.NavigateUrl = Epic_import + "SPOOL_EPIC.xlsx";
            HyperLink7.NavigateUrl = Epic_import + "JOINT_EPIC.xlsx";
            HyperLink8.NavigateUrl = Epic_import + "BOM_EPIC.xlsx";
            txtEpicOutput.Visible  = true;
            txtAmoghOutput.Visible = false;


            string spl_cnt = WebTools.CountExpr("IMPORT_REMARKS", "CLIENT_SPOOL_DATA_EPIC", " WHERE IMPORT_REMARKS IS NOT NULL ");
            string jnt_cnt = WebTools.CountExpr("IMPORT_REMARKS", "CLIENT_JOINT_EPIC", " WHERE IMPORT_REMARKS IS NOT NULL ");
            string lom_cnt = WebTools.CountExpr("IMPORT_REMARKS", "CLIENT_BOM_N_JC_EPIC", " WHERE IMPORT_REMARKS IS NOT NULL ");

            if (spl_cnt != "0")
            {
                btnEpicSpool.Visible = true;
            }
            else
            {
                btnEpicSpool.Visible = false;
            }
            if (jnt_cnt != "0")
            {
                btnEpicJoint.Visible = true;
            }
            else
            {
                btnEpicJoint.Visible = false;
            }
            if (lom_cnt != "0")
            {
                btnEpicBom.Visible = true;
            }
            else
            {
                btnEpicBom.Visible = false;
            }
        }
    }