protected void btnImport_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);
// delete old data
WebTools.ExecNonQuery("DELETE FROM PIP_ISOMETRIC_IMPORT WHERE PROJECT_ID IN (0, -1, " + proj_id + ")");
ExcelImport.Import_Excel_File(FilePath, Extension, "PIP_ISOMETRIC_IMPORT", "PIP_ISOMETRIC_IMPORT_PK",
"PROJECT_ID", Session["PROJECT_ID"].ToString());
WebTools.ExecNonQuery("BEGIN PKG_IMPORT_ISO.PRC_IMPORT_ISO(" + proj_id + ");END;");
Master.ShowSuccess("Isometric list imported!");
} // method
private static void ImportSPS(string Extension, string FilePath, string proj_id)
{
WebTools.ExecNonQuery("DELETE FROM PIP_SUPP_MTO_SPS WHERE PROJECT_ID IN (0, -1, " + proj_id + ")");
ExcelImport.Import_Excel_File(FilePath, Extension, "PIP_SUPP_MTO_SPS", "PK_SUPP_MTO_SPS", "PROJECT_ID", proj_id);
WebTools.ExecNonQuery("DELETE FROM PIP_SUPP_MTO_SPS WHERE ITEM_NAME='TEXT' OR ITEM_TYPE='TEXT'");
}
private static void ImportSuppMTO(string Extension, string FilePath, string proj_id)
{
WebTools.ExecNonQuery("DELETE FROM PIP_SUPP_MTO_LINE_ID WHERE PROJECT_ID IN (0, -1, " + proj_id + ")");
ExcelImport.Import_Excel_File(FilePath, Extension, "PIP_SUPP_MTO_LINE_ID", "UK_PIP_SUPP_MTO_LINE_ID", "PROJECT_ID", proj_id);
WebTools.ExecNonQuery("DELETE FROM PIP_SUPP_MTO_LINE_ID WHERE ITEM_NAME='TEXT' OR ITEM_TYPE='TEXT'");
WebTools.ExecNonQuery("UPDATE PIP_SUPP_MTO_LINE_ID SET NOTE=UPPER(NOTE)");
WebTools.ExecNonQuery("UPDATE PIP_SUPP_MTO_LINE_ID SET SCOPE_NAME=UPPER(SCOPE_NAME)");
WebTools.ExecNonQuery("UPDATE PIP_SUPP_MTO_LINE_ID SET AREA_NAME=UPPER(AREA_NAME)");
WebTools.ExecNonQuery("BEGIN PKG_UPDATE_SUPP_MTO.INSERT_MTO(" + proj_id + ");END;");
}
protected void btnImport_Click(object sender, EventArgs e)
{
if (FileUpload1.HasFile)
{
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 FIELD_WELDING_IMPORT WHERE PROJECT_ID=" + Session["PROJECT_ID"].ToString());
//Import_Excel_File(FilePath, Extension, "Yes");
ExcelImport.Import_Excel_File(FilePath, Extension, "FIELD_WELDING_IMPORT", "PK_FIELD_WELDING_IMPORT",
"PROJECT_ID", Session["PROJECT_ID"].ToString());
// update proj_id
WebTools.ExecNonQuery("UPDATE FIELD_WELDING_IMPORT SET PROJECT_ID=" + Session["PROJECT_ID"].ToString() + " WHERE PROJECT_ID IS NULL");
Save_Welding();
}
}
