protected void UploadFile(FileUpload f, string DestinationTable) { string proj_id = Session["PROJECT_ID"].ToString(); string FileName = Path.GetFileName(f.PostedFile.FileName); string Extension = Path.GetExtension(f.PostedFile.FileName); string FolderPath = WebTools.SessionDataPath(); string FilePath = FolderPath + FileName; f.SaveAs(FilePath); // delete old data WebTools.ExecNonQuery("DELETE FROM " + DestinationTable + " WHERE PROJECT_ID = '" + Session["PROJECT_ID"].ToString() + "'"); FileStream stream = new FileStream(FilePath, FileMode.Open, FileAccess.Read); DataTable dt = new DataTable(); dt = ExcelImport.xlsxToDT2(stream); dt.Columns.Add("IMPORT_BY"); foreach (DataRow r in dt.Rows) { r["IMPORT_BY"] = Session["USER_NAME"].ToString(); } ExcelImport.ImportDataTable(dt, DestinationTable, "", "PROJECT_ID", proj_id); }
protected void UploadETAFile() { try { string proj_id = Session["PROJECT_ID"].ToString(); string FileName = Path.GetFileName(matEtaUploader.PostedFile.FileName); string Extension = Path.GetExtension(matEtaUploader.PostedFile.FileName); string FolderPath = WebTools.SessionDataPath(); string FilePath = FolderPath + FileName; matEtaUploader.SaveAs(FilePath); // delete old data WebTools.ExecNonQuery("DELETE FROM TBL_TEMP_SML_MAT_ETA 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_TEMP_SML_MAT_ETA", "", "PROJECT_ID", proj_id); } catch (Exception ex) { Master.show_error("Error ETA File : " + ex.Message); } }
protected void btnSplUpload_Click(object sender, EventArgs e) { string sql, iso_id, spl_id, spl_id2; if (splUploader.HasFile) { string proj_id = Session["PROJECT_ID"].ToString(); string FileName = Path.GetFileName(splUploader.PostedFile.FileName); string Extension = Path.GetExtension(splUploader.PostedFile.FileName); string FolderPath = WebTools.SessionDataPath(); string FilePath = FolderPath + FileName; splUploader.SaveAs(FilePath); FileStream stream = new FileStream(FilePath, FileMode.Open, FileAccess.Read); DataTable dt = new DataTable(); dt = ExcelImport.xlsxToDT2(stream); try { switch (rdoUploadOption.SelectedValue) { case "DELETE": sql = "DELETE FROM PIP_SML_SPOOL"; WebTools.ExeSql(sql); break; } foreach (DataRow dr in dt.Rows) { if (dr[0].ToString().Trim().Equals("ISO_TITLE1")) { continue; } iso_id = WebTools.GetExpr("ISO_ID", "PIP_ISOMETRIC", "ISO_TITLE1='" + dr[0].ToString() + "'"); spl_id = WebTools.GetExpr("SPL_ID", "PIP_SPOOL", "ISO_ID='" + iso_id + "'" + " AND SPOOL='" + dr[1].ToString() + "'"); spl_id2 = WebTools.GetExpr("SPL_ID", "PIP_SML_SPOOL", " SPL_ID='" + spl_id + "'"); if (spl_id2.Trim().Length == 0 && spl_id.Trim().Length > 0) { sql = "INSERT INTO PIP_SML_SPOOL (PROJECT_ID, LIST_NAME, SPL_ID) VALUES (1, '" + FileName + "', '" + spl_id + "')"; WebTools.ExeSql(sql); } } Master.ShowSuccess("Selected Spools Imported."); } catch (Exception ex) { Master.ShowWarn(ex.Message + " Invalid ISO / Spool Provided"); } } else { Master.ShowWarn("Please Select a file to upload"); return; } }
protected void btnIsoUpload_Click(object sender, EventArgs e) { string sql, iso_title1; if (isoUploader.HasFile) { string proj_id = Session["PROJECT_ID"].ToString(); string FileName = Path.GetFileName(isoUploader.PostedFile.FileName); string Extension = Path.GetExtension(isoUploader.PostedFile.FileName); string FolderPath = WebTools.SessionDataPath(); string FilePath = FolderPath + FileName; isoUploader.SaveAs(FilePath); //lblSmlUser.Text = FilePath; //return; FileStream stream = new FileStream(FilePath, FileMode.Open, FileAccess.Read); DataTable dt = new DataTable(); dt = ExcelImport.xlsxToDT2(stream); try { switch (rdoUploadOption.SelectedValue) { case "DELETE": sql = "DELETE FROM PIP_SML_ISOME"; WebTools.ExeSql(sql); break; } foreach (DataRow dr in dt.Rows) { //iso_title1 = WebTools.GetExpr("ISO_ID", "PIP_ISOMETRIC", "ISO_TITLE1='" + dr[0].ToString() + "'"); if (dr[0].ToString().Trim().Equals("ISO_TITLE1")) { continue; } iso_title1 = dr[0].ToString().Trim(); if (iso_title1.Trim().Length > 0) { sql = "INSERT INTO PIP_SML_ISOME (ISO_TITLE) VALUES ('" + iso_title1 + "')"; WebTools.ExeSql(sql); } } Master.ShowSuccess("Selected Isometrics Imported."); } catch (Exception ex) { Master.ShowWarn(ex.Message); } } else { Master.ShowWarn("Please Select a file to upload"); return; } }
public void ImportTable(string table_name, string file_path, string project_field) { WebTools.ExecNonQuery("DELETE FROM " + table_name); FileStream stream; DataTable dt; stream = new FileStream(file_path, FileMode.Open, FileAccess.Read); dt = new DataTable(); dt = ExcelImport.xlsxToDT2(stream); ExcelImport.ImportDataTable(dt, table_name, "", project_field, "1"); }
protected void btnImport_Click(object sender, EventArgs e) { try { if (RadAsyncUpload1.UploadedFiles.Count == 0) { Master.show_error("Please Upload File to proceed."); return; } string proj_id = Session["PROJECT_ID"].ToString(); string user_id = WebTools.GetExpr("USER_ID", "USERS", " WHERE USER_NAME ='" + Session["USER_NAME"] + "'"); //string FileName = Path.GetFileName(FileUpload1.PostedFile.FileName); //string Extension = Path.GetExtension(FileUpload1.PostedFile.FileName); string FolderPath = WebTools.SessionDataPath(); string FileName = Path.GetFileName(RadAsyncUpload1.UploadedFiles[0].FileName); string Extension = Path.GetExtension(RadAsyncUpload1.UploadedFiles[0].FileName); string FilePath = FolderPath + FileName; //FileUpload1.SaveAs(FilePath); RadAsyncUpload1.UploadedFiles[0].SaveAs(FilePath); // delete old data WebTools.ExecNonQuery("DELETE FROM PIP_PO_IMPORT WHERE PROJECT_ID = '" + Session["PROJECT_ID"].ToString() + "'"); FileStream stream = new FileStream(FilePath, FileMode.Open, FileAccess.Read); DataTable dt = new DataTable(); dt = ExcelImport.xlsxToDT2(stream); dt.Columns.Add("USER_ID"); for (int i = 0; i < dt.Rows.Count; i++) { dt.Rows[i]["USER_ID"] = user_id; } ExcelImport.ImportDataTable(dt, "PIP_PO_IMPORT", "", "PROJECT_ID", proj_id); WebTools.ExecNonQuery("BEGIN PKG_BULK_IMPORT.PROC_PO_IMPORT('" + user_id + "') ; END;"); Master.show_success("PO Data Imported Successfully."); } catch (Exception ex) { Master.show_error(ex.Message); } }
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); } }
protected void btnImport_Click(object sender, EventArgs e) { try { //if (!FileUpload1.HasFile) return; if (RadAsyncUpload1.UploadedFiles.Count == 0) { Master.show_error("Please Upload File to proceed."); return; } string user_id = WebTools.GetExpr("USER_ID", "USERS", "USER_NAME='" + Session["USER_NAME"].ToString() + "'"); string proj_id = Session["PROJECT_ID"].ToString(); string FolderPath = WebTools.SessionDataPath(); string FileName = Path.GetFileName(RadAsyncUpload1.UploadedFiles[0].FileName); string Extension = Path.GetExtension(RadAsyncUpload1.UploadedFiles[0].FileName); string FilePath = FolderPath + FileName; RadAsyncUpload1.UploadedFiles[0].SaveAs(FilePath); WebTools.ExecNonQuery("DELETE FROM PIP_BULK_JC_SHOP_IMPORT WHERE PROJECT_ID = '" + Session["PROJECT_ID"].ToString() + "' AND USER_ID=" + user_id); FileStream stream = new FileStream(FilePath, FileMode.Open, FileAccess.Read); DataTable dt = new DataTable(); dt = ExcelImport.xlsxToDT2(stream); DataColumn user_id_col = new DataColumn("USER_ID", typeof(int)); user_id_col.DefaultValue = int.Parse(user_id); dt.Columns.Add(user_id_col); ExcelImport.ImportDataTable(dt, "PIP_BULK_JC_SHOP_IMPORT", "", "PROJECT_ID", proj_id); Master.show_success("Proceed to check status"); btnProceed.Visible = true; } catch (Exception ex) { Master.show_error(ex.Message); } }
protected void btnImport_Click(object sender, EventArgs e) { try { //if (!FileUpload1.HasFile) return; if (RadAsyncUpload1.UploadedFiles.Count == 0) { Master.show_error("Please Upload File to proceed."); 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 FileName = Path.GetFileName(RadAsyncUpload1.UploadedFiles[0].FileName); string Extension = Path.GetExtension(RadAsyncUpload1.UploadedFiles[0].FileName); string FilePath = FolderPath + FileName; //FileUpload1.SaveAs(FilePath); RadAsyncUpload1.UploadedFiles[0].SaveAs(FilePath); // delete old data WebTools.ExecNonQuery("DELETE FROM TEMP_TBL_IDF_MTO 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, "TEMP_TBL_IDF_MTO", "", "PROJECT_ID", proj_id); WebTools.ExecNonQuery("BEGIN PKG_PAGE_VALIDATION.proc_update_idf_mto_data; END;"); Master.show_success("IDF MTO Data Imported Successfully."); } catch (Exception ex) { Master.show_error(ex.Message); } }
protected void ImportData(string tablename, string exp_type) { //tablename = "PIP_BULK_EXPORT_FILE"; if (RadAsyncUpload1.UploadedFiles.Count == 0) { return; } string proj_id = Session["PROJECT_ID"].ToString(); string FileName = Path.GetFileName(RadAsyncUpload1.UploadedFiles[0].FileName); string Extension = Path.GetExtension(RadAsyncUpload1.UploadedFiles[0].FileName); string FolderPath = WebTools.SessionDataPath(); string sql = "DELETE FROM " + tablename + " WHERE USER_NAME = '" + Session["USER_NAME"] + "'"; try { //WebTools.ExeSql(sql); string FilePath = FolderPath + FileName; RadAsyncUpload1.UploadedFiles[0].SaveAs(FilePath); FileStream stream = new FileStream(FilePath, FileMode.Open, FileAccess.Read); DataTable dt = new DataTable(); dt = ExcelImport.xlsxToDT2(stream); dt.Columns.Add("USER_NAME", typeof(System.String)); dt.Columns.Add("EXPORT_OPTION", typeof(System.String)); foreach (DataRow row in dt.Rows) { row["USER_NAME"] = Session["USER_NAME"].ToString(); row["EXPORT_OPTION"] = exp_type; } ExcelImport.ImportDataTable(dt, tablename, "", "PROJECT_ID", proj_id); } catch (Exception ex) { Master.ShowError(ex.Message); } }
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 PIP_LINE_MTO 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, "PIP_LINE_MTO", "", "PROJECT_ID", proj_id); WebTools.ExecNonQuery("BEGIN " + "PKG_PAGE_VALIDATION.UPDATE_LINE_MTO('" + Session["PROJECT_ID"].ToString() + "'); " + " END;"); Master.show_success("LINE MTO Data Imported Successfully."); } catch (Exception ex) { Master.show_error(ex.Message); } }
protected void btnUpload_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); if (RadioButtonList1.SelectedValue == "0") { // delete old data WebTools.ExecNonQuery("DELETE FROM PIP_PPCS_ADD_MAT 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, "PIP_PPCS_ADD_MAT", "", "PROJECT_ID", proj_id); Master.show_success("Data Imported Successfully."); } catch (Exception ex) { Master.show_error(ex.Message); } }
protected void btnUpload_Click(object sender, EventArgs e) { if (!uploadPriorityExcel.HasFile) { return; } string proj_id = Session["PROJECT_ID"].ToString(); string FileName = Path.GetFileName(uploadPriorityExcel.PostedFile.FileName); string Extension = Path.GetExtension(uploadPriorityExcel.PostedFile.FileName); string FolderPath = WebTools.SessionDataPath(); string FilePath = FolderPath + FileName; uploadPriorityExcel.SaveAs(FilePath); string table_name = ""; string query = "", message = ""; string uploadOption = rdoUploadOption.SelectedValue; DataTable dt; FileStream stream; try { switch (selected_priority) { case "SPOOL": table_name = "PROJECT_PRIORITY_SPOOL"; if (uploadOption.Equals("DELETE")) { WebTools.ExeSql("TRUNCATE TABLE " + table_name); } stream = new FileStream(FilePath, FileMode.Open, FileAccess.Read); dt = new DataTable(); dt = ExcelImport.xlsxToDT2(stream); foreach (DataRow dr in dt.Rows) { query = "DELETE FROM " + table_name + " WHERE ISO_TITLE1='" + dr[0].ToString().ToUpper().Trim() + "' AND SPOOL='" + dr[1].ToString().ToUpper().Trim() + "'"; WebTools.ExeSql(query); string iso_id = WebTools.GetExpr("ISO_ID", "PIP_ISOMETRIC", "ISO_TITLE1='" + dr[0].ToString() + "'"); string spl_id = WebTools.GetExpr("SPL_ID", "PIP_SPOOL", "ISO_ID='" + iso_id + "' AND SPOOL='" + dr[1].ToString() + "'"); if (!string.IsNullOrEmpty(spl_id)) { query = "INSERT INTO " + table_name + " (ISO_TITLE1, SPOOL, PRIORITY,SPL_ID) " + " VALUES('" + dr[0].ToString() + "','" + dr[1].ToString() + "','" + dr[2].ToString() + "','" + spl_id + "')"; message = WebTools.ExeSql(query); } } break; case "MAIN_MAT": table_name = "PROJECT_PRIORITY_MAIN_MAT"; if (uploadOption.Equals("DELETE")) { WebTools.ExeSql("TRUNCATE TABLE " + table_name); } stream = new FileStream(FilePath, FileMode.Open, FileAccess.Read); dt = new DataTable(); dt = ExcelImport.xlsxToDT2(stream); foreach (DataRow dr in dt.Rows) { query = "DELETE FROM " + table_name + " WHERE MAIN_MAT='" + dr[0].ToString().ToUpper().Trim() + "'"; WebTools.ExeSql(query); } foreach (DataRow dr in dt.Rows) { query = "INSERT INTO " + table_name + " (MAIN_MAT, PRIORITY) VALUES ('" + dr[0].ToString() + "', '" + dr[1].ToString() + "')"; message = WebTools.ExeSql(query); } break; case "AREA": table_name = "PROJECT_PRIORITY_AREA"; if (uploadOption.Equals("DELETE")) { WebTools.ExeSql("TRUNCATE TABLE " + table_name); } stream = new FileStream(FilePath, FileMode.Open, FileAccess.Read); dt = new DataTable(); dt = ExcelImport.xlsxToDT2(stream); foreach (DataRow dr in dt.Rows) { query = "DELETE FROM " + table_name + " WHERE AREA='" + dr[0].ToString().ToUpper().Trim() + "'"; WebTools.ExeSql(query); } foreach (DataRow dr in dt.Rows) { query = "INSERT INTO " + table_name + " (AREA, PRIORITY) VALUES ('" + dr[0].ToString() + "','" + dr[1].ToString() + "')"; message = WebTools.ExeSql(query); } break; case "SERVICE": table_name = "PROJECT_PRIORITY_SERVICE"; if (uploadOption.Equals("DELETE")) { WebTools.ExeSql("TRUNCATE TABLE " + table_name); } stream = new FileStream(FilePath, FileMode.Open, FileAccess.Read); dt = new DataTable(); dt = ExcelImport.xlsxToDT2(stream); foreach (DataRow dr in dt.Rows) { query = "DELETE FROM " + table_name + " WHERE SERVICE='" + dr[0].ToString().ToUpper().Trim() + "'"; WebTools.ExeSql(query); } foreach (DataRow dr in dt.Rows) { query = "INSERT INTO " + table_name + " (SERVICE, PRIORITY) VALUES ('" + dr[0].ToString() + "','" + dr[1].ToString() + "')"; message = WebTools.ExeSql(query); } break; case "LINE": table_name = "PROJECT_PRIORITY_LINE"; if (uploadOption.Equals("DELETE")) { WebTools.ExeSql("TRUNCATE TABLE " + table_name); } stream = new FileStream(FilePath, FileMode.Open, FileAccess.Read); dt = new DataTable(); dt = ExcelImport.xlsxToDT2(stream); foreach (DataRow dr in dt.Rows) { query = "DELETE FROM " + table_name + " WHERE LINE_NO='" + dr[0].ToString().ToUpper().Trim() + "'"; WebTools.ExeSql(query); } foreach (DataRow dr in dt.Rows) { query = "INSERT INTO " + table_name + " (LINE_NO, PRIORITY) VALUES ('" + dr[0].ToString() + "','" + dr[1].ToString() + "')"; message = WebTools.ExeSql(query); } break; case "ISOMETRIC": table_name = "PROJECT_PRIORITY_ISOMETRIC"; if (rdoUploadOption.Equals("DELETE")) { WebTools.ExeSql("TRUNCATE TABLE " + table_name); } stream = new FileStream(FilePath, FileMode.Open, FileAccess.Read); dt = new DataTable(); dt = ExcelImport.xlsxToDT2(stream); foreach (DataRow dr in dt.Rows) { query = "DELETE FROM " + table_name + " WHERE ISO_TITLE1='" + dr[0].ToString().ToUpper().Trim() + "'"; WebTools.ExeSql(query); } foreach (DataRow dr in dt.Rows) { query = "INSERT INTO " + table_name + " (ISO_TITLE1, PRIORITY) VALUES ('" + dr[0].ToString() + "','" + dr[1].ToString() + "')"; message = WebTools.ExeSql(query); } break; case "SPLIT_WBS": table_name = "PROJECT_PRIORITY_SPLIT_WBS"; if (rdoUploadOption.Equals("DELETE")) { WebTools.ExeSql("TRUNCATE TABLE " + table_name); } stream = new FileStream(FilePath, FileMode.Open, FileAccess.Read); dt = new DataTable(); dt = ExcelImport.xlsxToDT2(stream); foreach (DataRow dr in dt.Rows) { query = "DELETE FROM " + table_name + " WHERE WBS_NO='" + dr[0].ToString().ToUpper().Trim() + "'"; WebTools.ExeSql(query); } foreach (DataRow dr in dt.Rows) { query = "INSERT INTO " + table_name + " (WBS_NO, PRIORITY) VALUES ('" + dr[0].ToString() + "','" + dr[1].ToString() + "')"; message = WebTools.ExeSql(query); } break; } Master.show_success("Data Imported Sucessfully!!!"); } catch (Exception ex) { Master.show_error(ex.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 btnImport_Click(object sender, EventArgs e) { try { //if (!FileUpload1.HasFile) return; if (RadAsyncUpload1.UploadedFiles.Count == 0) { Master.show_error("Please Upload File to proceed."); return; } string ImportOption = ImportOptions.SelectedValue; 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 FileName = Path.GetFileName(RadAsyncUpload1.UploadedFiles[0].FileName); string Extension = Path.GetExtension(RadAsyncUpload1.UploadedFiles[0].FileName); string FilePath = FolderPath + FileName; //FileUpload1.SaveAs(FilePath); RadAsyncUpload1.UploadedFiles[0].SaveAs(FilePath); // delete old data FileStream stream = new FileStream(FilePath, FileMode.Open, FileAccess.Read); DataTable dt = new DataTable(); dt = ExcelImport.xlsxToDT2(stream); switch (ImportOption) { case "ADD": break; case "REPLACE": DataView view = new DataView(dt); DeleteExisting(view.ToTable(true, "IRN_NO")); break; case "REIMPORT": WebTools.ExecNonQuery("DELETE FROM PO_VENDOR_DATA WHERE PROJECT_ID = '" + Session["PROJECT_ID"].ToString() + "'"); break; } dt.Columns.Add("CREATE_DATE"); dt.Columns.Add("CREATE_BY"); foreach (DataRow r in dt.Rows) { r["CREATE_DATE"] = System.DateTime.Today; r["CREATE_BY"] = Session["USER_NAME"]; } ExcelImport.ImportDataTable(dt, "PO_VENDOR_DATA", "", "PROJECT_ID", proj_id); //WebTools.ExecNonQuery("BEGIN PKG_PAGE_VALIDATION.proc_update_idf_mto_data; END;"); Master.show_success("Vendor Data Imported Successfully."); } catch (Exception ex) { Master.show_error(ex.Message); } }