public string LoadStateFromStorage(string key) { StringBuilder sb = new StringBuilder(); string query = ""; string sql = "SELECT * FROM CUSTOM_REPORT_INDEX"; using (OracleConnection conn = WebTools.GetIpmsConnection()) { using (OracleCommand cmd = new OracleCommand(sql, conn)) { using (OracleDataReader dataReader = cmd.ExecuteReader()) { while (dataReader.Read()) { if (dataReader["REPORT_QUERY"] != DBNull.Value) { byte[] byteArray = (Byte[])dataReader["REPORT_QUERY"]; query = Encoding.ASCII.GetString(byteArray); } } } } } return(query); }
private void CollectPDFs(ZipFile zip_file, string dirObject) { //string path = WebTools.SessionDataPath(); string sql = ""; string FileName = ""; string folderPath = WebTools.GetExpr("path", "dir_objects", " folder_name='" + dirObject + "'"); string filePath = string.Empty; using (OracleConnection conn = WebTools.GetIpmsConnection()) { //Isometric sql = "SELECT * FROM VIEW_BULK_PDF_EXPORT WHERE USER_NAME='" + Session["USER_NAME"].ToString() + "' AND EXPORT_OPTION = '" + dirObject + "'"; using (OracleCommand cmd = new OracleCommand(sql, conn)) { using (OracleDataReader dataReader = cmd.ExecuteReader()) { while (dataReader.Read()) { FileName = WebTools.SessionDataPath() + dataReader["PDF_FILE_NAME"]; if (File.Exists(FileName)) { File.Delete(FileName); } string filee = folderPath + dataReader["PDF_FILE_NAME"]; if (File.Exists(folderPath + dataReader["PDF_FILE_NAME"])) { zip_file.AddFile(folderPath + dataReader["PDF_FILE_NAME"]); } } } //OracleDataReader1 } //OracleCommand1 } //OracleConnection }
private void Update_List() { string user_name = WebTools.GetExpr("USER_NAME", "USERS", " WHERE USER_ID = " + Request.QueryString["USER_ID"]); string queryString = "SELECT * FROM VIEW_USER_MODULE WHERE USER_ID=" + Request.QueryString["USER_ID"] + " AND MODULE_ID=" + ddlModule.SelectedValue + " ORDER BY SEQ"; using (OracleConnection connection = WebTools.GetIpmsConnection()) { OracleCommand command = new OracleCommand(queryString, connection); //connection.Open(); using (OracleDataReader reader = command.ExecuteReader()) { while (reader.Read()) { Role_ListBoxDestination.Items.Add(new Telerik.Web.UI.RadListBoxItem( reader["HIDE_COL_NAME"].ToString(), reader["SEQ"].ToString() )); for (int i = 0; i < Role_ListBoxSource.Items.Count; i++) { if (Role_ListBoxSource.Items[i].Text.ToString() == reader["HIDE_COL_NAME"].ToString()) { Role_ListBoxSource.Items.Remove(Role_ListBoxSource.Items[i]); } } } } } }
private void Update_List() { string queryString = "SELECT * FROM VIEW_USERS_ROLE WHERE USER_ID=" + Session["popup_USER_ID"].ToString() + " ORDER BY ROLE_NAME"; using (OracleConnection connection = WebTools.GetIpmsConnection()) { OracleCommand command = new OracleCommand(queryString, connection); //connection.Open(); using (OracleDataReader reader = command.ExecuteReader()) { while (reader.Read()) { Role_ListBoxDestination.Items.Add(new Telerik.Web.UI.RadListBoxItem( reader["ROLE_NAME"].ToString(), reader["ROLE_NAME"].ToString() )); for (int i = 0; i < Role_ListBoxSource.Items.Count; i++) { if (Role_ListBoxSource.Items[i].Value.ToString() == reader["ROLE_NAME"].ToString()) { Role_ListBoxSource.Items.Remove(Role_ListBoxSource.Items[i]); } } } } } }
protected void btnSave_Click(object sender, EventArgs e) { try { string file_ext = Right(FileUpload1.FileName, 3); string FileName = WebTools.SessionDataPath() + "user_pic." + file_ext; if (File.Exists(FileName)) { System.IO.File.Delete(FileName); } FileUpload1.SaveAs(FileName); FileInfo f = new FileInfo(FileName); if (f.Length > 200000) { Master.ShowWarn("File size can't be more than 200kb!"); return; } byte[] byteArray = null; using (FileStream fs = new FileStream (FileName, FileMode.Open, FileAccess.Read, FileShare.Read)) { byteArray = new byte[fs.Length]; int iBytesRead = fs.Read(byteArray, 0, (int)fs.Length); } string sql = "UPDATE USERS SET ACCOUNT_PIC=:ACCOUNT_PIC, ACCOUNT_PIC_EXT=:ACCOUNT_PIC_EXT WHERE PROJECT_ID=" + Session["PROJECT_ID"].ToString() + " AND USER_NAME='" + Session["USER_NAME"].ToString() + "'"; using (OracleConnection conn = WebTools.GetIpmsConnection()) { using (OracleCommand cmd = new OracleCommand(sql, conn)) { cmd.Parameters.Add("ACCOUNT_PIC", OracleType.Blob); cmd.Parameters[0].Value = byteArray; cmd.Parameters.Add("ACCOUNT_PIC_EXT", OracleType.VarChar); cmd.Parameters[1].Value = file_ext; cmd.ExecuteNonQuery(); } } Load_Profile_Picture(); Master.ShowMessage("Picture Uploaded!"); } catch (Exception ex) { Master.ShowError(ex.Message); } }
protected void Page_Load(object sender, EventArgs e) { con = WebTools.GetIpmsConnection(); if (con.State == ConnectionState.Closed) { con.Open(); } }
private void Load_Document() { if (string.IsNullOrEmpty(tc_id)) { return; } string sql = "SELECT * FROM PIP_TEST_CARDS WHERE TC_ID=" + tc_id; string FilePath = ""; string FileName = ""; string baseUrl = Request.Url.Scheme + "://" + Request.Url.Authority + Request.ApplicationPath.TrimEnd('/') + "/"; using (OracleConnection conn = WebTools.GetIpmsConnection()) { using (OracleCommand cmd = new OracleCommand(sql, conn)) { using (OracleDataReader dataReader = cmd.ExecuteReader()) { while (dataReader.Read()) { FileName = dataReader["TC_ID"] + "_mtc.pdf"; FilePath = WebTools.SessionDataPath() + FileName; if (File.Exists(FilePath)) { File.Delete(FilePath); } if (dataReader["MTC_BLOB"] != DBNull.Value) { byte[] byteArray = (Byte[])dataReader["MTC_BLOB"]; using (FileStream fs = new FileStream(FilePath, FileMode.CreateNew, FileAccess.Write)) { fs.Write(byteArray, 0, byteArray.Length); if (PDF_URL_Label.Text.Length > 0) { PDF_URL_Label.Text += "<br/>"; } PDF_URL_Label.Text += string.Format("<a href='{0}' target='_blank'>{1}</a>", baseUrl + "SessionData/" + Session.SessionID.ToString() + @"\" + FileName, dataReader["TC_CODE"]); } } } } } } if (PDF_URL_Label.Text == "") { PDF_URL_Label.Text = "No PDF"; } }
protected void btnDownloadIR_Click(object sender, EventArgs e) { if (itemsGrid.SelectedIndexes.Count == 0) { Master.ShowError("Select IRN to continue"); return; } ZipFile zip_file = new ZipFile(); string irn_id = itemsGrid.SelectedValue.ToString(); string irn_no = WebTools.GetExpr("IRN_NO", "PIP_PO_IRN", " WHERE IRN_ID='" + irn_id + "'"); string sql = ""; string FileName = ""; string folderPath = WebTools.GetExpr("path", "dir_objects", " DIR_ID='" + 6 + "'"); string filePath = string.Empty; string path = WebTools.SessionDataPath(); string zip_file_path = path + "IRN" + ".zip"; using (OracleConnection conn = WebTools.GetIpmsConnection()) { //Isometric sql = "SELECT * FROM VIEW_PO_IRN_IR_FILES WHERE IRN_ID='" + irn_id + "'"; using (OracleCommand cmd = new OracleCommand(sql, conn)) { using (OracleDataReader dataReader = cmd.ExecuteReader()) { while (dataReader.Read()) { FileName = WebTools.SessionDataPath() + dataReader["FILE_NAME"]; if (File.Exists(FileName)) { File.Delete(FileName); } if (File.Exists(folderPath + dataReader["FILE_NAME"])) { zip_file.AddFile(folderPath + dataReader["FILE_NAME"], "files"); } } } //OracleDataReader1 } //OracleCommand1 } //OracleConnection zip_file.Save(zip_file_path); var updateFile = new FileInfo(zip_file_path); Response.ContentType = "application/octet-stream"; Response.AddHeader("content-disposition", "attachment;filename=\"" + Path.GetFileName(updateFile.FullName) + "\""); Response.AddHeader("content-length", updateFile.Length.ToString()); Response.TransmitFile(updateFile.FullName); Response.Flush(); }
protected void btnUpdateWelders_Click(object sender, EventArgs e) { //New OracleConnection conn = WebTools.GetIpmsConnection(); if (conn.State != ConnectionState.Open) { conn.Open(); } OracleCommand cmd = new OracleCommand(); cmd.CommandType = CommandType.Text; cmd.Connection = conn; OracleCommand cmd2 = new OracleCommand(); cmd2.CommandType = CommandType.Text; cmd2.Connection = conn; //Root & Hot cmd.CommandText = "SELECT * FROM VIEW_JOINT_WELDERS_UPDATE WHERE ROOT_HOT_WELDER_UPDATE='Y'"; OracleDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { cmd2.CommandText = "UPDATE PIP_SPOOL_JOINTS SET ROOT_HOT_WELDER='" + dr["ROOT_HOT_WELDER_NEW"] + "' WHERE JOINT_ID=" + dr["JOINT_ID"]; cmd2.ExecuteNonQuery(); } //Fill & Cap cmd.CommandText = "SELECT * FROM VIEW_JOINT_WELDERS_UPDATE WHERE FILL_CAP_WELDER_UPDATE='Y'"; dr = cmd.ExecuteReader(); while (dr.Read()) { cmd2.CommandText = "UPDATE PIP_SPOOL_JOINTS SET FILL_CAP_WELDER='" + dr["FILL_CAP_WELDER_NEW"] + "' WHERE JOINT_ID=" + dr["JOINT_ID"]; cmd2.ExecuteNonQuery(); } //Finally cmd.Dispose(); cmd2.Dispose(); conn.Close(); conn.Dispose(); NotificationBox.show_success("Joint Welders Updated!"); }
public void download_zip(int type_id, string ref_id, string downloadsuffix, string dir_obj, HttpResponse respone) { ZipFile zip_file = new ZipFile(); // string irn_no = WebTools.GetExpr("MIR_NO", "PRC_MAT_INSP", " WHERE MIR_ID='" + mir_id+ "'"); string sql = ""; string FileName = ""; string folderPath = WebTools.GetExpr("path", "dir_objects", " DIR_OBJ='" + dir_obj + "'"); string filePath = string.Empty; string path = WebTools.SessionDataPath(); string zip_file_path = path + downloadsuffix + ".zip"; using (OracleConnection conn = WebTools.GetIpmsConnection()) { //Isometric sql = "SELECT * FROM VIEW_UPLOAD_FILES WHERE TYPE_ID=" + type_id + " AND REF_ID='" + ref_id + "'"; using (OracleCommand cmd = new OracleCommand(sql, conn)) { using (OracleDataReader dataReader = cmd.ExecuteReader()) { while (dataReader.Read()) { FileName = WebTools.SessionDataPath() + dataReader["FILE_NAME"]; if (File.Exists(FileName)) { File.Delete(FileName); } if (File.Exists(folderPath + dataReader["FILE_NAME"])) { zip_file.AddFile(folderPath + dataReader["FILE_NAME"], "files"); } } } //OracleDataReader1 } //OracleCommand1 } //OracleConnection zip_file.Save(zip_file_path); var updateFile = new FileInfo(zip_file_path); respone.ContentType = "application/octet-stream"; respone.AddHeader("content-disposition", "attachment;filename=\"" + Path.GetFileName(updateFile.FullName) + "\""); respone.AddHeader("content-length", updateFile.Length.ToString()); respone.TransmitFile(updateFile.FullName); respone.Flush(); }
private void Load_PDF() { string sql = "SELECT * FROM VIEW_TEST_CARDS WHERE TC_ID=" + Session["popup_TC_ID"].ToString(); string sg_FileName = WebTools.SessionDataPath(); string baseUrl = Request.Url.Scheme + "://" + Request.Url.Authority + Request.ApplicationPath.TrimEnd('/') + "/"; string sg_pdf_html = ""; string hc_pdf_html = ""; string hc_url = WebTools.GetExpr("PATH", "DIR_OBJECTS", " PROJECT_ID = '" + Session["PROJECT_ID"].ToString() + "' AND DIR_OBJ = 'MTC'"); string hc_url1 = WebTools.GetExpr("PATH", "DIR_OBJECTS", " PROJECT_ID = '" + Session["PROJECT_ID"].ToString() + "' AND DIR_OBJ = 'MTC'"); string hc_asp_url = WebTools.GetExpr("ASP_PATH", "DIR_OBJECTS", " PROJECT_ID = '" + Session["PROJECT_ID"].ToString() + "' AND DIR_OBJ = 'MTC'"); string hc_asp_url1 = WebTools.GetExpr("ASP_PATH", "DIR_OBJECTS", " PROJECT_ID = '" + Session["PROJECT_ID"].ToString() + "' AND DIR_OBJ = 'MTC'"); using (OracleConnection conn = WebTools.GetIpmsConnection()) { using (OracleCommand cmd = new OracleCommand(sql, conn)) { using (OracleDataReader dataReader = cmd.ExecuteReader()) { while (dataReader.Read()) { // HC_PDF_BLOB { string hc_FileName = dataReader["PDF_FILE_NAME"].ToString(); hc_url = hc_url1 + hc_FileName; if (File.Exists(hc_url)) { hc_asp_url = hc_asp_url1 + hc_FileName; hc_pdf_html += "<br/>"; hc_pdf_html += string.Format("<a href='{0}' target='_blank'>{1}</a>", hc_asp_url, dataReader["PDF_TITLE"]); } } } // dataReader.Read() if (hc_pdf_html.Length > 0) { PDF_URL_Label.Text += "<b>MTC PDF</b><br/>" + hc_pdf_html + "<br/>"; } } } } }
protected void cboJoints_SelectedIndexChanged(object sender, EventArgs e) { WPS_NO_RadAutoCompleteBox.Enabled = true; WPS_NO_RadAutoCompleteBox.Entries.Clear(); if (IsPostBack) { OracleConnection conn = WebTools.GetIpmsConnection(); if (conn.State != ConnectionState.Open) { conn.Open(); } OracleCommand cmd = new OracleCommand(); cmd.CommandType = CommandType.Text; cmd.Connection = conn; cmd.CommandText = "SELECT * FROM PIP_SPOOL_JOINTS WHERE JOINT_ID=" + cboJoints.SelectedValue.ToString(); using (OracleDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { txtReportNo.Text = dr["WELD_REP_NO"].ToString(); txtInsp.Text = dr["WELD_INSP"].ToString(); if (!string.IsNullOrEmpty(dr["WPS_NO"].ToString())) { string wps_no = dr["WPS_NO"].ToString(); WPS_NO_RadAutoCompleteBox.Entries.Add(new Telerik.Web.UI.AutoCompleteBoxEntry(wps_no, wps_no)); } if (!string.IsNullOrEmpty(dr["WELD_DATE"].ToString())) { txtWeldDate.SelectedDate = DateTime.Parse(dr["WELD_DATE"].ToString()); } } } //Finally cmd.Dispose(); conn.Close(); conn.Dispose(); } }
public void SaveStateToStorage(string key, string serializedState) { OracleConnection connection = WebTools.GetIpmsConnection(); byte[] byteArray = null; byteArray = Encoding.ASCII.GetBytes(serializedState); string query = "UPDATE CUSTOM_REPORT_INDEX SET REPORT_QUERY=:REPORT_QUERY"; using (OracleConnection conn = WebTools.GetIpmsConnection()) { using (OracleCommand cmd = new OracleCommand(query, connection)) { cmd.Parameters.Add("REPORT_QUERY", OracleType.Blob); cmd.Parameters[0].Value = byteArray; cmd.ExecuteNonQuery(); } } }
protected void Page_Load(object sender, EventArgs e) { con = WebTools.GetIpmsConnection(); if (con.State == ConnectionState.Closed) { con.Open(); } try { adp = new OracleDataAdapter("SELECT USER_NAME,EMAIL,CODE FROM USERS WHERE CODE='" + Request.QueryString["CODE"].ToString() + "' AND(EMAIL='" + Request.QueryString["EMAIL"].ToString() + "' OR USER_NAME='" + Request.QueryString["USER_NAME"].ToString() + "')", con); dt = new DataTable(); adp.Fill(dt); if (dt.Rows.Count == 0) { divExpire.Visible = true; divpwd1.Visible = false; divpwd2.Visible = false; btn_change_pwd.Visible = false; return; } else { divExpire.Visible = false; divpwd1.Visible = true; divpwd2.Visible = true; btn_change_pwd.Visible = true; } } catch (Exception ex) { lbl_msg.Text = ex.Message; lbl_msg.ForeColor = System.Drawing.Color.Red; } finally { } }
private void Load_Profile_Picture() { string sql = "SELECT * FROM USERS WHERE PROJECT_ID=" + Session["PROJECT_ID"].ToString() + " AND USER_NAME='" + Session["USER_NAME"].ToString() + "'"; string FilePath = ""; string baseUrl = Request.Url.Scheme + "://" + Request.Url.Authority + Request.ApplicationPath.TrimEnd('/') + "/"; using (OracleConnection conn = WebTools.GetIpmsConnection()) { using (OracleCommand cmd = new OracleCommand(sql, conn)) { using (OracleDataReader dataReader = cmd.ExecuteReader()) { while (dataReader.Read()) { if (dataReader["ACCOUNT_PIC"] != DBNull.Value) { Random rnd = new Random(); string file_name = rnd.Next(1000, 9999).ToString() + "." + dataReader["ACCOUNT_PIC_EXT"]; FilePath = WebTools.SessionDataPath() + file_name; if (File.Exists(FilePath)) { File.Delete(FilePath); } byte[] byteArray = (Byte[])dataReader["ACCOUNT_PIC"]; using (FileStream fs = new FileStream(FilePath, FileMode.CreateNew, FileAccess.Write)) { fs.Write(byteArray, 0, byteArray.Length); AccountImage.ImageUrl = baseUrl + "SessionData/" + Session.SessionID.ToString() + @"/" + file_name; AccountImage.DataBind(); } } } } } } }
private void CreateTextFile(string file_name, string sql) { StreamWriter sr = new StreamWriter(file_name); using (OracleConnection conn = WebTools.GetIpmsConnection()) { using (OracleCommand cmd = new OracleCommand(sql, conn)) { using (OracleDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { sr.WriteLine(dr["TEXT_DATA"].ToString()); } } // dr } // cmd } // conn sr.Close(); sr.Dispose(); }
protected void btnSubmit_Click1(object sender, EventArgs e) { string USER_ID = Request.QueryString["USER_ID"]; OracleConnection connection = WebTools.GetIpmsConnection(); OracleCommand command = new OracleCommand(); command.Connection = connection; command.CommandType = CommandType.Text; try { //Save Roles //============================================================ WebTools.ExeSql("DELETE USER_MODULE_ROLES WHERE USER_ID=" + USER_ID + " AND MODULE_ID=" + ddlModule.SelectedValue); foreach (Telerik.Web.UI.RadListBoxItem role in Role_ListBoxDestination.Items) { command.CommandText = "INSERT INTO USER_MODULE_ROLES (USER_ID, SEQ,MODULE_ID) VALUES(" + USER_ID + ",'" + role.Value.ToString() + "'," + ddlModule.SelectedValue + " )"; command.ExecuteNonQuery(); } //============================================================ Master.show_success(" Saved!"); } catch (Exception ex) { Master.show_error(ex.Message); } finally { command.Dispose(); connection.Close(); connection.Dispose(); } }
protected void btnSubmit_Click1(object sender, EventArgs e) { string USER_ID = Session["popup_USER_ID"].ToString(); OracleConnection connection = WebTools.GetIpmsConnection(); OracleCommand command = new OracleCommand(); command.Connection = connection; command.CommandType = CommandType.Text; try { if (txtPassword.Enabled == true) { if (txtPassword.Text.Length == 0) { Master.show_error("No Password provided!"); return; } else if (txtPassword.Text.Length < 5) { Master.show_error("Minimum Password Length is 5!"); return; } else if (txtPassword.Text != txtPassword2.Text) { Master.show_error("Password does not match!"); return; } WebTools.ExeSql("UPDATE USERS SET PASSKEY='" + WebTools.MD5Str(txtPassword.Text.ToLower()) + "' WHERE USER_ID=" + USER_ID); } //Save Roles //============================================================ WebTools.ExeSql("DELETE USERS_ROLE WHERE USER_ID=" + USER_ID); foreach (Telerik.Web.UI.RadListBoxItem role in Role_ListBoxDestination.Items) { command.CommandText = "INSERT INTO USERS_ROLE(USER_ID, ROLE_NAME) VALUES(" + USER_ID + ",'" + role.Value.ToString() + "')"; command.ExecuteNonQuery(); } //============================================================ if (txtPassword.Enabled == true) { Master.show_success("User Info Saved and Password Changed!"); } else { Master.show_success(txtUserName.Text + " Saved!"); } } catch (Exception ex) { Master.show_error(ex.Message); } finally { command.Dispose(); connection.Close(); connection.Dispose(); } }
private void Save_Welding() { using (OracleConnection conn = WebTools.GetIpmsConnection()) { // update weld_date, wps_no using (OracleCommand cmd = new OracleCommand("SELECT DISTINCT JOINT_ID, WELDED_DATE, WPS_NO, WELD_DATE_UPD, WPS_NO_UPD FROM VIEW_FIELD_WELDING_IMP_A " + "WHERE JOINT_ID IS NOT NULL AND CAT_ID IN (2, 4) AND (WELD_DATE_UPD='Y' OR WPS_NO_UPD='Y')", conn)) { using (OracleDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { OracleCommand cmd2 = new OracleCommand(); cmd2.Connection = conn; cmd2.CommandText = "UPDATE PIP_SPOOL_JOINTS SET "; bool have_col = false; if (dr["WELD_DATE_UPD"].ToString() == "Y") { have_col = true; cmd2.CommandText += "WELD_DATE='" + DateTime.Parse(dr["WELDED_DATE"].ToString()).ToString("dd-MMM-yyyy") + "'"; } if (dr["WPS_NO_UPD"].ToString() == "Y") { if (have_col) { cmd2.CommandText += ","; } have_col = true; cmd2.CommandText += "WPS_NO='" + dr["WPS_NO"].ToString() + "'"; } if (have_col) { cmd2.CommandText += " WHERE JOINT_ID=" + dr["JOINT_ID"].ToString(); cmd2.ExecuteNonQuery(); } cmd2.Dispose(); } // while } // dr } // cmd // add new welders using (OracleCommand cmd = new OracleCommand("SELECT * FROM VIEW_FIELD_WLD_WELDERS WHERE WELDER_ID IS NULL", conn)) { using (OracleDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { OracleCommand cmd2 = new OracleCommand(); cmd2.Connection = conn; cmd2.CommandText = "INSERT INTO PIP_WELDERS(WELDER_NO, W_NAME, SC_ID, EMP_DATE, PROJECT_ID) " + "VALUES (:WELDER_NO, :W_NAME, :SC_ID, :EMP_DATE, :PROJECT_ID)"; cmd2.Parameters.Add("WELDER_NO", OracleType.VarChar); cmd2.Parameters["WELDER_NO"].Value = dr["WELDER_NO"].ToString(); cmd2.Parameters.Add("W_NAME", OracleType.VarChar); cmd2.Parameters["W_NAME"].Value = dr["WELDER_NO"].ToString(); cmd2.Parameters.Add("SC_ID", OracleType.Number); cmd2.Parameters["SC_ID"].Value = dr["SUB_CON_ID"].ToString(); cmd2.Parameters.Add("EMP_DATE", OracleType.DateTime); cmd2.Parameters["EMP_DATE"].Value = DateTime.Now.ToString("dd-MMM-yyyy"); cmd2.Parameters.Add("PROJECT_ID", OracleType.Number); cmd2.Parameters["PROJECT_ID"].Value = Session["PROJECT_ID"].ToString(); cmd2.ExecuteNonQuery(); } // while } // dr } // new welders added // add weling details using (OracleCommand cmd = new OracleCommand("SELECT * FROM VIEW_FIELD_WLD_DETAIL", conn)) { using (OracleDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { OracleCommand cmd2 = new OracleCommand(); cmd2.Connection = conn; cmd2.CommandText = "INSERT INTO PIP_SPOOL_WELDING(JOINT_ID, REWORK_CODE, WELD_DATE, WELDER_ID, PASS_ID, WELD_PROCESS) " + "VALUES (:JOINT_ID, :REWORK_CODE, :WELD_DATE, :WELDER_ID, :PASS_ID, :WELD_PROCESS)"; cmd2.Parameters.Add("JOINT_ID", OracleType.Number); cmd2.Parameters["JOINT_ID"].Value = dr["JOINT_ID"].ToString(); cmd2.Parameters.Add("REWORK_CODE", OracleType.VarChar); cmd2.Parameters["REWORK_CODE"].Value = dr["REWORK_CODE"].ToString(); cmd2.Parameters.Add("WELD_DATE", OracleType.DateTime); cmd2.Parameters["WELD_DATE"].Value = DateTime.Parse(dr["WELDED_DATE"].ToString()).ToString("dd-MMM-yyyy"); cmd2.Parameters.Add("WELDER_ID", OracleType.Number); cmd2.Parameters["WELDER_ID"].Value = dr["WELDER_ID"].ToString(); string work_on = dr["WORK_ON"].ToString(); string pass_id = "1"; if (work_on == "R" || work_on == "RF") { pass_id = "1"; } else { pass_id = "4"; // F } cmd2.Parameters.Add("PASS_ID", OracleType.Number); cmd2.Parameters["PASS_ID"].Value = pass_id; cmd2.Parameters.Add("WELD_PROCESS", OracleType.VarChar); cmd2.Parameters["WELD_PROCESS"].Value = dr["WELD_PROCESS"].ToString(); cmd2.ExecuteNonQuery(); // welding details // RF Case if (work_on == "RF") { cmd2.Parameters["PASS_ID"].Value = 4; cmd2.ExecuteNonQuery(); } } // while } // dr } // welder details added } Master.ShowSuccess("Field Welding data imported!"); }
public void createTable_NEW_QR(string FileName, int spl_id, string id_1) { System.Text.Encoding enc = new System.Text.UTF8Encoding(true, true); //Get the BOM byte[] bom = enc.GetPreamble(); //Get the raw bytes for the string byte[] bytes = enc.GetBytes(""); //Combine the byte arrays byte[] final = new byte[bom.Length + bytes.Length]; System.Buffer.BlockCopy(bom, 0, final, 0, bom.Length); System.Buffer.BlockCopy(bytes, 0, final, bom.Length, bytes.Length); var r = new Rectangle(160, 100) { //BackgroundColor=new BaseColor(179,227,238), remove this in original code Border = 0 }; Document dc = new Document(r, 0, 0, 0, 0); // PdfWriter writer = PdfWriter.GetInstance(dc, new FileStream(HttpContext.Current.Request.PhysicalApplicationPath + FileName + "/" + spl_id + ".pdf", FileMode.Create)); PdfWriter writer = PdfWriter.GetInstance(dc, new FileStream(HttpContext.Current.Request.PhysicalApplicationPath + FileName + "/" + id_1 + ".pdf", FileMode.Create)); dc.Open(); // BaseFont customfont = BaseFont.CreateFont("d:\\ss.ttf", BaseFont.CP1252, BaseFont.EMBEDDED); BaseFont customfont = BaseFont.CreateFont(); int a = spl_id; //string connectionString = "Data Source=ALRAR;Persist Security Info=True;User ID=AMOGH;Password=ALRAR2020;Unicode=True"; OracleConnection conn = WebTools.GetIpmsConnection(); // string query = "SELECT iso_title1,spl_rev,spool,round(spl_size,2) as spl_size ,area_l1,round(weight,2),mat_type,line_no,unit FROM view_total_spool_list WHERE spl_id=" + spl_id; string query = "SELECT mat_code1,heat_no,nvl(paint_code,'NA') as paint_code,wall_thk,joint_thk,size1,nvl(mat_type,'XXX') as mat_type,substr(mat_descr,1,100) AS mat_descr, SubStr(mat_descr,101,100) AS mat_descr2, SubStr(mat_descr,201,100) AS mat_descr3 FROM view_bulk_paint_barcode WHERE spl_id=" + spl_id; OracleCommand cmd = new OracleCommand(query, conn); if (conn.State == ConnectionState.Closed) { conn.Open(); } OracleDataReader rdr = cmd.ExecuteReader(); // Font bigFont = new Font(Font.FontFamily.TIMES_ROMAN, 6.5f, Font.NORMAL); Font bigFont = FontFactory.GetFont("Calibri", BaseFont.CP1252, BaseFont.EMBEDDED, 8, Font.BOLD, BaseColor.BLACK); Font smallFont = FontFactory.GetFont("Calibri", BaseFont.CP1252, BaseFont.EMBEDDED, 7, Font.BOLD, BaseColor.BLACK); Font mediumFont = FontFactory.GetFont("Calibri", BaseFont.CP1252, BaseFont.EMBEDDED, 6, Font.BOLD, BaseColor.BLACK); Font mediumFont_a = FontFactory.GetFont("Calibri", BaseFont.CP1252, BaseFont.EMBEDDED, 4, Font.BOLD, BaseColor.BLACK); Font headfont = new Font(Font.FontFamily.COURIER, 14f, Font.BOLD); iTextSharp.text.pdf.PdfContentByte cb = writer.DirectContent; //table.AddCell(new Paragraph("Item code:" + rdr[0].ToString(), mediumFont)); //table.AddCell(new Paragraph("Paint Code:" + rdr[2].ToString(), mediumFont)); //table.AddCell(new Paragraph("Heat No:" + rdr[1].ToString(), mediumFont)); //table.AddCell(new Paragraph("Sch & Thk:" + rdr[3].ToString() + " & " + rdr[4].ToString(), mediumFont)); //table.AddCell(new Paragraph("Pipe-Size:" + rdr[5].ToString(), mediumFont)); //table.AddCell(new Paragraph("Main-Mat:" + rdr[6].ToString(), mediumFont)); //table.AddCell(new Paragraph("Pipe-Description:" + rdr[7].ToString(), mediumFont_a)); //table.AddCell(new Paragraph(rdr[8].ToString(), mediumFont_a)); //table.AddCell(new Paragraph(rdr[9].ToString(), mediumFont_a)); rdr.Read(); string s1 = "Item-Code / Paint-Code :" + " " + rdr[0].ToString() + "/" + rdr[2].ToString(); string s2 = " " + "Heat-No / Sch &Thk :" + " " + rdr[1].ToString() + "/" + rdr[3].ToString() + " & " + rdr[4].ToString(); string s3 = " " + "Pipe-Size / Main-Mat :" + rdr[5].ToString() + "/" + rdr[6].ToString(); string s4 = " " + "Pipe-Description :" + rdr[7].ToString(); BarcodeQRCode bcd = new BarcodeQRCode(s1.ToString() + " " + s2.ToString() + " " + s3.ToString() + " " + s4.ToString(), 10, 10, null); PdfPTable table = new PdfPTable(2); table.SetWidthPercentage(new float[] { 70, 70 }, r); //table.SetWidths(new float[] { 145, 80 }); table.SetWidths(new float[] { 100, 80 }); table.DefaultCell.Border = Rectangle.NO_BORDER; table.DefaultCell.NoWrap = true; // PdfPCell cell = new PdfPCell(new Paragraph("Petrofac / Rabigh")); //PdfPCell cell = new PdfPCell(new Paragraph("Petrofac / JI-2014", headfont)); PdfPCell cell = new PdfPCell(); cell.Image = iTextSharp.text.Image.GetInstance(bcd.GetImage()); cell.Colspan = 2; cell.Border = 0; cell.HorizontalAlignment = 1; //0=Left, 1=Centre, 2=Right table.AddCell(cell); conn.Close(); dc.Add(table); dc.Close(); //Barcode128 bc = new Barcode128(); //bc.ChecksumText = true; //bc.Code = a.ToString().PadLeft(16, '0'); //bc.Size = 4; //bc.BarHeight = 15; //bc.Baseline = 4; //PdfPTable table = new PdfPTable(2); //// table.SetWidths(new float[]{158,68}); //table.SetWidthPercentage(new float[] { 100, 100 }, r); //table.SetWidths(new float[] { 145, 80 }); //table.DefaultCell.Border = Rectangle.NO_BORDER; //table.DefaultCell.NoWrap = true; //// PdfPCell cell = new PdfPCell(new Paragraph("Petrofac / Rabigh")); //PdfPCell cell = new PdfPCell(new Paragraph("Job: Petrofac/JI-2037", headfont)); //cell.Colspan = 2; //cell.Rowspan = 4; //cell.HorizontalAlignment = 1; //0=Left, 1=Centre, 2=Right //cell.Border = 0; //cell.Padding = 4; //table.AddCell(cell); //cell = new PdfPCell(); //cell.Image = iTextSharp.text.Image.GetInstance(bc.CreateImageWithBarcode(cb, null, null)); //cell.Colspan = 2; //cell.Border = 0; //cell.HorizontalAlignment = 1; //0=Left, 1=Centre, 2=Right //table.AddCell(cell); //rdr.Read(); //table.AddCell(new Paragraph("Item code:" + rdr[0].ToString(), mediumFont)); //table.AddCell(new Paragraph("Paint Code:" + rdr[2].ToString(), mediumFont)); //table.AddCell(new Paragraph("Heat No:" + rdr[1].ToString(), mediumFont)); //table.AddCell(new Paragraph("Sch & Thk:" + rdr[3].ToString() + " & " + rdr[4].ToString(), mediumFont)); //table.AddCell(new Paragraph("Pipe-Size:" + rdr[5].ToString(), mediumFont)); //table.AddCell(new Paragraph("Main-Mat:" + rdr[6].ToString(), mediumFont)); //table.AddCell(new Paragraph("Pipe-Description:" + rdr[7].ToString(), mediumFont_a)); //table.AddCell(new Paragraph(rdr[8].ToString(), mediumFont_a)); //table.AddCell(new Paragraph(rdr[9].ToString(), mediumFont_a)); //table.AddCell(""); ////NEW CONDITION //rdr.Close(); ////END //conn.Close(); //dc.Add(table); //dc.Close(); }
public void createTable(string FileName, int joint_d, string id_1) { var r = new Rectangle(220, 144) { //BackgroundColor=new BaseColor(179,227,238), remove this in original code Border = 0 }; Document dc = new Document(r, 0, 0, 0, 0); // PdfWriter writer = PdfWriter.GetInstance(dc, new FileStream(HttpContext.Current.Request.PhysicalApplicationPath + FileName + "/" + spl_id + ".pdf", FileMode.Create)); PdfWriter writer = PdfWriter.GetInstance(dc, new FileStream(HttpContext.Current.Request.PhysicalApplicationPath + FileName + "/" + id_1 + ".pdf", FileMode.Create)); dc.Open(); // BaseFont customfont = BaseFont.CreateFont("d:\\ss.ttf", BaseFont.CP1252, BaseFont.EMBEDDED); BaseFont customfont = BaseFont.CreateFont(); int a = joint_d; //string connectionString = "Data Source=ALRAR;Persist Security Info=True;User ID=AMOGH;Password=ALRAR2020;Unicode=True"; OracleConnection conn = WebTools.GetIpmsConnection(); // string query = "SELECT iso_title1,spl_rev,spool,round(spl_size,2) as spl_size ,area_l1,round(weight,2),mat_type,line_no,unit FROM view_total_spool_list WHERE spl_id=" + spl_id; string query = "SELECT * FROM VIEW_BC_IMAGE_DETAIL_FLANGE WHERE JOINT_ID=" + joint_d; OracleCommand cmd = new OracleCommand(query, conn); if (conn.State == ConnectionState.Closed) { conn.Open(); } OracleDataReader rdr = cmd.ExecuteReader(); // Font bigFont = new Font(Font.FontFamily.TIMES_ROMAN, 6.5f, Font.NORMAL); Font bigFont = FontFactory.GetFont("Calibri", BaseFont.CP1252, BaseFont.EMBEDDED, 8, Font.BOLD, BaseColor.BLACK); Font smallFont = FontFactory.GetFont("Calibri", BaseFont.CP1252, BaseFont.EMBEDDED, 7, Font.BOLD, BaseColor.BLACK); Font headfont = new Font(Font.FontFamily.COURIER, 14f, Font.BOLD); iTextSharp.text.pdf.PdfContentByte cb = writer.DirectContent; Barcode128 bc = new Barcode128(); bc.ChecksumText = true; bc.Code = a.ToString().PadLeft(16, '0'); bc.Size = 4; bc.BarHeight = 15; bc.Baseline = 4; PdfPTable table = new PdfPTable(2); // table.SetWidths(new float[]{158,68}); table.SetWidthPercentage(new float[] { 100, 100 }, r); table.SetWidths(new float[] { 145, 80 }); table.DefaultCell.Border = Rectangle.NO_BORDER; table.DefaultCell.NoWrap = true; // PdfPCell cell = new PdfPCell(new Paragraph("Petrofac / Rabigh")); PdfPCell cell = new PdfPCell(new Paragraph("Job: BIFP/P11570", headfont)); cell.Colspan = 2; cell.Rowspan = 4; cell.HorizontalAlignment = 1; //0=Left, 1=Centre, 2=Right cell.Border = 0; cell.Padding = 4; table.AddCell(cell); cell = new PdfPCell(); rdr.Read(); string iso = rdr[0].ToString(); string jnt = rdr[2].ToString(); // bc.AltText = iso + spl; cell.Image = iTextSharp.text.Image.GetInstance(bc.CreateImageWithBarcode(cb, null, null)); cell.Colspan = 2; cell.Border = 0; cell.HorizontalAlignment = 1; //0=Left, 1=Centre, 2=Right table.AddCell(cell); table.AddCell(new Paragraph("Iso:" + rdr[0].ToString(), smallFont)); table.AddCell(new Paragraph("Rev:" + rdr[1].ToString(), bigFont)); table.AddCell(new Paragraph("Joint-No:" + rdr[2].ToString(), bigFont)); table.AddCell(new Paragraph("Joint-Size:" + rdr[4].ToString(), bigFont)); table.AddCell(new Paragraph("Wbs-No:" + rdr[5].ToString(), bigFont)); table.AddCell(new Paragraph("bolt-qty:" + rdr[6].ToString(), bigFont)); table.AddCell(new Paragraph("Main Mat:" + rdr[7].ToString(), bigFont)); table.AddCell(new Paragraph("Unit:" + rdr[9].ToString(), bigFont)); table.AddCell(new Paragraph("Line:" + rdr[8].ToString(), smallFont)); // table.AddCell(new Paragraph("UniqueNo:" + rdr[9].ToString(), smallFont)); table.AddCell(""); //NEW CONDITION rdr.Close(); //END conn.Close(); dc.Add(table); dc.Close(); }
//public void createTable_QR(string FileName, int spl_id, string id_1) //{ // //PdfPTable table = new PdfPTable(8); // //PdfPCell cell; // //cell = new PdfPCell(); // ////cell.setRowspan(2); // //cell.Rowspan = 2; // //table.AddCell(cell); // //for (int aw = 0; aw < 8; aw++) // //{ // // table.AddCell("hi"); // //} // System.Text.Encoding enc = new System.Text.UTF8Encoding(true, true); // //Get the BOM // byte[] bom = enc.GetPreamble(); // //Get the raw bytes for the string // byte[] bytes = enc.GetBytes(""); // //Combine the byte arrays // byte[] final = new byte[bom.Length + bytes.Length]; // System.Buffer.BlockCopy(bom, 0, final, 0, bom.Length); // System.Buffer.BlockCopy(bytes, 0, final, bom.Length, bytes.Length); // var r = new Rectangle(165, 71) // { // //BackgroundColor=new BaseColor(179,227,238), remove this in original code // Border = 0 // }; // Document dc = new Document(r, 0, 0, 0, 0); // PdfWriter writer = PdfWriter.GetInstance(dc, new FileStream(HttpContext.Current.Request.PhysicalApplicationPath + FileName + "/" + id_1 + ".pdf", FileMode.Create)); // dc.Open(); // // BaseFont customfont = BaseFont.CreateFont("d:\\ss.ttf", BaseFont.CP1252, BaseFont.EMBEDDED); // BaseFont customfont = BaseFont.CreateFont(); // int a = spl_id; // string connectionString = WebTools.GetIpmsConnection().ConnectionString; // OracleConnection conn = new OracleConnection(connectionString); // // string query = "SELECT iso_title1,spl_rev,spool,round(spl_size,2) as spl_size ,area_l1,round(weight,2),mat_type,line_no,unit FROM view_total_spool_list WHERE spl_id=" + spl_id; // string query = "SELECT iso_title1,spl_rev,spool,spl_size,area_l1,weight,unit,mat_type,line_no FROM view_bc_image_dt WHERE spl_id=" + spl_id; // OracleCommand cmd = new OracleCommand(query, conn); // conn.Open(); // OracleDataReader rdr = cmd.ExecuteReader(); // // Font bigFont = new Font(Font.FontFamily.TIMES_ROMAN, 6.5f, Font.NORMAL); // Font bigFont = FontFactory.GetFont("Calibri", BaseFont.CP1252, BaseFont.EMBEDDED, 6.3f, Font.BOLD, BaseColor.BLACK); // Font headfont = new Font(Font.FontFamily.COURIER, 14f, Font.BOLD); // iTextSharp.text.pdf.PdfContentByte cb = writer.DirectContent; // rdr.Read(); // string qrstring = rdr[0].ToString() + " / " + rdr[2].ToString(); // BarcodeQRCode bcd = new BarcodeQRCode(qrstring.ToString(), 7000, 7000, null); // // a table with three columns // PdfPTable table_100 = new PdfPTable(2); // // table_100.SetWidthPercentage(new float[] { 40, 120 }, r); // // table_100.SetWidths(new float[] { 50, 120 }); // table_100.SetWidthPercentage(new float[] { 75, 100 }, r); // table_100.SetWidths(new float[] { 75, 100 }); // table_100.DefaultCell.Border = Rectangle.NO_BORDER; // // the cell object // PdfPCell cell_100 = new PdfPCell(); // table_100.HorizontalAlignment = Element.ALIGN_LEFT; // cell_100.Border = 0; // cell_100.PaddingTop = 3; // cell_100.Image = iTextSharp.text.Image.GetInstance(bcd.GetImage()); // cell_100.HorizontalAlignment = 0; //0=Left, 1=Centre, 2=Right // table_100.AddCell(cell_100); // //var splitter = "Iso:" + rdr[0].ToString() + "\n" + "\n" + "Spool:" + rdr[2].ToString(); // var splitter = "Line No :" + rdr[8].ToString() + "\n" + "\n" + "Iso:" + rdr[0].ToString() + "\n" + "\n" + "Spool:" + rdr[2].ToString() + "\n" + "\n" + "Weight:" + rdr[5].ToString(); // var splitter1 = splitter.Split('_'); // //var splitter1 = splitter.Split('_'); // iTextSharp.text.Paragraph paragraph; // paragraph = new Paragraph(); // paragraph.Add(new Chunk(ConvertStringArrayToString(splitter1), bigFont)); // cell_100 = new PdfPCell(paragraph); // cell_100.PaddingTop = 8; // cell_100.Border = 0; // table_100.AddCell(cell_100); // //table_100.AddCell(new Paragraph(ConvertStringArrayToString(splitter1), bigFont)); // conn.Close(); // dc.Add(table_100); // dc.Close(); //} public void createTable_QR(string FileName, int joint_id, string id_1) { System.Text.Encoding enc = new System.Text.UTF8Encoding(true, true); //Get the BOM byte[] bom = enc.GetPreamble(); //Get the raw bytes for the string byte[] bytes = enc.GetBytes(""); //Combine the byte arrays byte[] final = new byte[bom.Length + bytes.Length]; System.Buffer.BlockCopy(bom, 0, final, 0, bom.Length); System.Buffer.BlockCopy(bytes, 0, final, bom.Length, bytes.Length); var r = new Rectangle(216, 144) //var r = new Rectangle(216, 144) { //BackgroundColor=new BaseColor(179,227,238), remove this in original code }; Document dc = new Document(r, 0, 0, 0, 0); PdfWriter writer = PdfWriter.GetInstance(dc, new FileStream(HttpContext.Current.Request.PhysicalApplicationPath + FileName + "/" + id_1 + ".pdf", FileMode.Create)); dc.Open(); BaseFont customfont = BaseFont.CreateFont(); int a = joint_id; OracleConnection conn = WebTools.GetIpmsConnection(); // string query = "SELECT iso_title1,spl_rev,spool,round(spl_size,2) as spl_size ,area_l1,round(weight,2),mat_type,line_no,unit FROM view_total_spool_list WHERE spl_id=" + spl_id; string query = "SELECT * FROM VIEW_BC_IMAGE_DETAIL_FLANGE WHERE JOINT_ID=" + joint_id; OracleCommand cmd = new OracleCommand(query, conn); if (conn.State == ConnectionState.Closed) { conn.Open(); } OracleDataReader rdr = cmd.ExecuteReader(); // Font bigFont = new Font(Font.FontFamily.TIMES_ROMAN, 6.5f, Font.NORMAL); Font bigFont = FontFactory.GetFont("Arial", BaseFont.CP1252, BaseFont.EMBEDDED, 7, Font.BOLD, BaseColor.BLACK); Font headfont = new Font(Font.FontFamily.COURIER, 14f, Font.BOLD); iTextSharp.text.pdf.PdfContentByte cb = writer.DirectContent; rdr.Read(); string qrstring = rdr[0].ToString() + " / " + rdr[2].ToString(); BarcodeQRCode bcd = new BarcodeQRCode(qrstring.ToString(), 300, 300, null); // a table with three columns PdfPTable table_100 = new PdfPTable(2); // table_100.SetWidthPercentage(new float[] { 40, 120 }, r); // table_100.SetWidths(new float[] { 50, 120 }); table_100.SetWidthPercentage(new float[] { 90, 170 }, r); table_100.SetWidths(new float[] { 90, 170 }); Font headerFont = new Font(Font.FontFamily.COURIER, 15f, Font.BOLD); PdfPCell cell = new PdfPCell(new Paragraph("Job: BIFP/P11570", headerFont)); cell.Colspan = 2; cell.HorizontalAlignment = 1; //0=Left, 1=Centre, 2=Right cell.Border = 0; table_100.AddCell(cell); // the cell object PdfPCell cell_100 = new PdfPCell(); table_100.HorizontalAlignment = Element.ALIGN_LEFT; cell_100.Border = 0; cell_100.PaddingTop = 10; cell_100.PaddingRight = 0; cell_100.Image = iTextSharp.text.Image.GetInstance(bcd.GetImage()); cell_100.HorizontalAlignment = 0; //0=Left, 1=Centre, 2=Right table_100.AddCell(cell_100); //var splitter = "Iso:" + rdr[0].ToString() + "\n" + "\n" + "Spool:" + rdr[2].ToString(); //var splitter = "\n" + "\n"+"Iso:" + rdr[0].ToString() + "\n" + "\n" + "Joint:" + rdr[2].ToString() + "\n" + "\n" + "Joint size:" + rdr[4].ToString(); var splitter = "Line No:" + rdr[8].ToString() + "\n" + "\n" + "Iso:" + rdr[0].ToString() + "\n" + "\n" + "Joint:" + rdr[2].ToString() + "\n" + "\n" + "Joint size:" + rdr[4].ToString() + "\n" + "\n" + "Item Code1:" + rdr[11].ToString() + "\n" + "\n" + "Item Code2:" + rdr[12].ToString(); var splitter1 = splitter.Split('_'); //var splitter1 = splitter.Split('_'); iTextSharp.text.Paragraph paragraph; paragraph = new Paragraph(); paragraph.Add(new Chunk(ConvertStringArrayToString(splitter1), bigFont)); cell_100 = new PdfPCell(paragraph); cell_100.PaddingTop = 15; cell_100.PaddingLeft = 0; cell_100.Border = 0; table_100.AddCell(cell_100); //table_100.AddCell(new Paragraph(ConvertStringArrayToString(splitter1), bigFont)); conn.Close(); dc.Add(table_100); dc.Close(); }
public void createTable(string FileName, int mat_id, string id_1) { //72 point =1 inch // // var r = new iTextSharp.text.Rectangle(220, 144) var r = new iTextSharp.text.Rectangle(144, 72) { //BackgroundColor=new BaseColor(179,227,238), remove this in original code Border = 0 }; Document dc = new Document(r, 0, 0, 0, 0); // PdfWriter writer = PdfWriter.GetInstance(dc, new FileStream(HttpContext.Current.Request.PhysicalApplicationPath + FileName + "/" + spl_id + ".pdf", FileMode.Create)); PdfWriter writer = PdfWriter.GetInstance(dc, new FileStream(HttpContext.Current.Request.PhysicalApplicationPath + FileName + "/" + id_1 + ".pdf", FileMode.Create)); dc.Open(); // BaseFont customfont = BaseFont.CreateFont("d:\\ss.ttf", BaseFont.CP1252, BaseFont.EMBEDDED); BaseFont customfont = BaseFont.CreateFont(); int a = mat_id; //string connectionString = "Data Source=ALRAR;Persist Security Info=True;User ID=AMOGH;Password=ALRAR2020;Unicode=True"; OracleConnection conn = WebTools.GetIpmsConnection(); // string query = "SELECT iso_title1,spl_rev,spool,round(spl_size,2) as spl_size ,area_l1,round(weight,2),mat_type,line_no,unit FROM view_total_spool_list WHERE spl_id=" + spl_id; string query = "SELECT mat_code1,mat_code2,size_desc,THK1, ITEM_NAM FROM view_stock WHERE mat_id=" + mat_id; OracleCommand cmd = new OracleCommand(query, conn); if (conn.State == ConnectionState.Closed) { conn.Open(); } OracleDataReader rdr = cmd.ExecuteReader(); // Font bigFont = new Font(Font.FontFamily.TIMES_ROMAN, 6.5f, Font.NORMAL); Font bigFont = FontFactory.GetFont("Calibri", BaseFont.CP1252, BaseFont.EMBEDDED, 8, Font.BOLD, BaseColor.BLACK); Font smallFont = FontFactory.GetFont("Calibri", BaseFont.CP1252, BaseFont.EMBEDDED, 7, Font.BOLD, BaseColor.BLACK); Font headfont = new Font(Font.FontFamily.COURIER, 14f, Font.BOLD); iTextSharp.text.pdf.PdfContentByte cb = writer.DirectContent; Barcode128 bc = new Barcode128(); bc.ChecksumText = true; bc.Code = a.ToString().PadLeft(16, '0'); bc.Size = 4; bc.BarHeight = 25; bc.Baseline = 4; PdfPTable table = new PdfPTable(2); // table.SetWidths(new float[]{158,68}); table.SetWidthPercentage(new float[] { 100, 100 }, r); table.SetWidths(new float[] { 144, 72 }); table.DefaultCell.Border = Rectangle.NO_BORDER; table.DefaultCell.NoWrap = true; // PdfPCell cell = new PdfPCell(new Paragraph("Petrofac / Rabigh")); PdfPCell cell = new PdfPCell(new Paragraph()); cell.Colspan = 2; cell.Rowspan = 4; cell.HorizontalAlignment = 1; //0=Left, 1=Centre, 2=Right cell.Border = 0; cell.Padding = 4; table.AddCell(cell); cell = new PdfPCell(); //cell.Image = iTextSharp.text.Image.GetInstance(bc.CreateImageWithBarcode(cb, null, null)); iTextSharp.text.Image img = iTextSharp.text.Image.GetInstance(bc.CreateImageWithBarcode(cb, null, null)); img.ScaleToFit(r); cell.Colspan = 2; cell.Border = 0; cell.HorizontalAlignment = 1; //0=Left, 1=Centre, 2=Right table.AddCell(cell); rdr.Read(); table.AddCell(new Paragraph("Mat Code1:" + rdr[0].ToString(), smallFont)); // table.AddCell(new Paragraph("MESC Code:" + rdr[1].ToString(), bigFont)); // table.AddCell(new Paragraph("Size:" + rdr[2].ToString(), bigFont)); // table.AddCell(new Paragraph("Thk/Sch:" + rdr[3].ToString(), bigFont)); // table.AddCell(new Paragraph("Description:" + rdr[4].ToString(), bigFont)); table.AddCell(""); //NEW CONDITION rdr.Close(); //END conn.Close(); dc.Add(img); dc.Close(); Response.Write(bc.BarcodeSize.ToString()); }
public static void ExportToCSV(string query, string fileName) { //Add Response header HttpResponse Response = HttpContext.Current.Response; Response.Clear(); Response.AddHeader("content-disposition", string.Format("attachment;filename={0}.csv", fileName)); Response.Charset = ""; Response.ContentType = "application/vnd.xls"; //GET Data From Database OracleConnection cn = WebTools.GetIpmsConnection(); OracleCommand cmd = new OracleCommand(query, cn); cmd.CommandTimeout = 999999; cmd.CommandType = CommandType.Text; try { //cn.Open(); OracleDataReader dr = cmd.ExecuteReader(); StringBuilder sb = new StringBuilder(); //CSV Header for (int count = 0; count < dr.FieldCount; count++) { if (dr.GetName(count) != null) { sb.Append(dr.GetName(count)); } if (count < dr.FieldCount - 1) { sb.Append(","); } } Response.Write(sb.ToString() + "\n"); Response.Flush(); //CSV Body while (dr.Read()) { sb = new StringBuilder(); for (int col = 0; col < dr.FieldCount - 1; col++) { if (!dr.IsDBNull(col)) { if (dr.GetDataTypeName(col).ToUpper() == "DATE") { sb.Append(DateTime.Parse(dr.GetValue(col).ToString()).ToString("dd-MMM-yyyy")); } else { sb.Append(dr.GetValue(col).ToString().Replace(",", " ")); } } sb.Append(","); } if (!dr.IsDBNull(dr.FieldCount - 1)) { if (!dr.IsDBNull(dr.FieldCount - 1)) { if (dr.GetDataTypeName(dr.FieldCount - 1).ToUpper() == "DATE") { sb.Append(DateTime.Parse(dr.GetValue(dr.FieldCount - 1).ToString()).ToString("dd-MMM-yyyy")); } else { sb.Append(dr.GetValue(dr.FieldCount - 1).ToString().Replace(",", " ")); } } } Response.Write(sb.ToString() + "\n"); Response.Flush(); } dr.Dispose(); } catch (Exception ex) { Response.Write(ex.Message); } finally { cmd.Connection.Close(); cn.Close(); } Response.End(); }
public static void ImportDataTable(DataTable data, string TableName, string TablePk, string ProjIdField, string ProjIdValue) { DataTable dt = new DataTable(); dt = data; bool has_pj_id = string.IsNullOrEmpty(ProjIdField) ? false : true; bool first_col = true; string sql = "INSERT " + (string.IsNullOrEmpty(TablePk) ? "" : string.Format(@"/*+ IGNORE_ROW_ON_DUPKEY_INDEX({0},{1}) */", TableName, TablePk)) + " INTO " + TableName + " ("; // add proj_id field if (has_pj_id) { sql += ProjIdField; first_col = false; } foreach (DataColumn col in dt.Columns) { if (!first_col) { sql += ","; } else { first_col = false; } sql += col.ColumnName; } sql += ") VALUES ("; first_col = true; // add proj_id field if (has_pj_id) { sql += ":" + ProjIdField; first_col = false; } foreach (DataColumn col in dt.Columns) { if (!first_col) { sql += ","; } else { first_col = false; } sql += ":" + col.ColumnName; } sql += ")"; using (OracleConnection conn = WebTools.GetIpmsConnection()) // will open connection too { List <TableFieldInfo> columns = GetColumns(conn, TableName); OracleCommand cmd = new OracleCommand(sql, conn); for (int rowindex = 1; rowindex < dt.Rows.Count; rowindex++) // row 0 is heading { DataRow row = dt.Rows[rowindex]; cmd.Parameters.Clear(); // add proj_id value if (has_pj_id) { OracleParameter proj_par = new OracleParameter(ProjIdField, ProjIdValue); cmd.Parameters.Add(proj_par); } foreach (DataColumn col in dt.Columns) { string data_type = columns.Where(x => x.FieldName == col.ColumnName).First().FieldDataType; int data_len = columns.Where(x => x.FieldName == col.ColumnName).First().FieldSize; string col_val = row[col].ToString().Trim(); if (data_type.ToLower().Contains("date")) { DateTime value; if (DateTime.TryParse(col_val, out value)) { col_val = value.ToString("dd-MMM-yyyy"); //col_val = ""; } else { col_val = ""; } } else if (data_type.ToLower().Contains("varchar")) { if (col_val.Length > data_len) { col_val = col_val.Substring(0, data_len); } } OracleParameter parm = new OracleParameter(col.ColumnName, col_val); cmd.Parameters.Add(parm); } cmd.ExecuteNonQuery(); } cmd.Dispose(); } }
public static void Import_Excel_File(string FilePath, string Extension, string TableName, string TablePk, string ProjIdField, string ProjIdValue) { string conStr = ""; switch (Extension) { case ".xls": //Excel 97-03 conStr = ConnStrHelper.Excel03ConString(); break; case ".xlsx": //Excel 07 conStr = ConnStrHelper.Excel07ConString(); break; default: return; // not supported } conStr = String.Format(conStr, FilePath, "Yes"); OleDbConnection connExcel = new OleDbConnection(conStr); OleDbCommand cmdExcel = new OleDbCommand(); OleDbDataAdapter oda = new OleDbDataAdapter(); DataTable dt = new DataTable(); cmdExcel.Connection = connExcel; //Get the name of First Sheet connExcel.Open(); DataTable dtExcelSchema; dtExcelSchema = connExcel.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null); string SheetName = dtExcelSchema.Rows[0]["TABLE_NAME"].ToString(); connExcel.Close(); //Read Data from First Sheet connExcel.Open(); cmdExcel.CommandText = "SELECT * From [" + SheetName + "]"; oda.SelectCommand = cmdExcel; oda.Fill(dt); connExcel.Close(); bool has_pj_id = string.IsNullOrEmpty(ProjIdField) ? false : true; bool first_col = true; string sql = "INSERT " + (string.IsNullOrEmpty(TablePk) ? "" : string.Format(@"/*+ IGNORE_ROW_ON_DUPKEY_INDEX({0},{1}) */", TableName, TablePk)) + " INTO " + TableName + " ("; // add proj_id field if (has_pj_id) { sql += ProjIdField; first_col = false; } foreach (DataColumn col in dt.Columns) { if (!first_col) { sql += ","; } else { first_col = false; } sql += col.ColumnName; } sql += ") VALUES ("; first_col = true; // add proj_id field if (has_pj_id) { sql += ":" + ProjIdField; first_col = false; } foreach (DataColumn col in dt.Columns) { if (!first_col) { sql += ","; } else { first_col = false; } sql += ":" + col.ColumnName; } sql += ")"; using (OracleConnection conn = WebTools.GetIpmsConnection()) // will open connection too { OracleCommand cmd = new OracleCommand(sql, conn); foreach (DataRow row in dt.Rows) { cmd.Parameters.Clear(); // add proj_id value if (has_pj_id) { OracleParameter proj_par = new OracleParameter(ProjIdField, ProjIdValue); cmd.Parameters.Add(proj_par); } foreach (DataColumn col in dt.Columns) { string col_val = row[col].ToString(); if (col.ColumnName.ToUpper().Contains("DATE") && !string.IsNullOrEmpty(col_val)) { DateTime value; if (DateTime.TryParse(col_val, out value)) { col_val = value.ToString("dd-MMM-yyyy"); } else { col_val = ""; } } OracleParameter parm = new OracleParameter(col.ColumnName, col_val); cmd.Parameters.Add(parm); } cmd.ExecuteNonQuery(); } cmd.Dispose(); } //Bind Data to GridView //GridView1.Caption = Path.GetFileName(FilePath); //jointsGridView.DataSource = dt; //jointsGridView.DataBind(); }
private void CollectPDFs(ZipFile zip_file) { //string path = WebTools.SessionDataPath(); string sql = ""; string FileName = ""; string folderPath = WebTools.GetExpr("path", "dir_objects", " dir_obj='ISO_SPOOLGEN'"); string filePath = string.Empty; using (OracleConnection conn = WebTools.GetIpmsConnection()) { //Isometric sql = "SELECT * FROM VIEW_ISO_PDF_BLOB_WO_MIV WHERE ISSUE_ID=" + mivGridView.SelectedValue.ToString(); using (OracleCommand cmd = new OracleCommand(sql, conn)) { using (OracleDataReader dataReader = cmd.ExecuteReader()) { while (dataReader.Read()) { FileName = WebTools.SessionDataPath() + dataReader["PDF_FILE_NAME"]; if (File.Exists(FileName)) { File.Delete(FileName); } if (File.Exists(folderPath + dataReader["PDF_FILE_NAME"])) { zip_file.AddFile(folderPath + dataReader["PDF_FILE_NAME"]); } } } //OracleDataReader1 } //OracleCommand1 //Spool Piece sql = "SELECT * FROM VIEW_SPOOL_PDF_WO_MIV WHERE ISSUE_ID=" + mivGridView.SelectedValue.ToString(); folderPath = WebTools.GetExpr("path", "dir_objects", " dir_obj='SPL_SPOOLGEN'"); using (OracleCommand cmd = new OracleCommand(sql, conn)) { using (OracleDataReader dataReader = cmd.ExecuteReader()) { while (dataReader.Read()) { FileName = WebTools.SessionDataPath() + dataReader["PDF_FILE_NAME"]; if (File.Exists(FileName)) { File.Delete(FileName); } if (File.Exists(folderPath + dataReader["PDF_FILE_NAME"])) { zip_file.AddFile(folderPath + dataReader["PDF_FILE_NAME"]); } } } //OracleDataReader2 } //OracleCommand2 // Iso As Built sql = "SELECT * FROM VIEW_ISO_PDF_BLOB_WO_MIV WHERE ISSUE_ID=" + mivGridView.SelectedValue.ToString(); folderPath = WebTools.GetExpr("path", "dir_objects", " dir_obj='ISO_AB'"); using (OracleCommand cmd = new OracleCommand(sql, conn)) { using (OracleDataReader dataReader = cmd.ExecuteReader()) { while (dataReader.Read()) { FileName = WebTools.SessionDataPath() + dataReader["PDF_FILE_NAME"]; if (File.Exists(FileName)) { File.Delete(FileName); } if (File.Exists(folderPath + dataReader["PDF_FILE_NAME"])) { zip_file.AddFile(folderPath + dataReader["PDF_FILE_NAME"]); } } } //OracleDataReader2 } //OracleCommand2 } //OracleConnection }
private void CollectPDFs(ZipFile zip_file) { //string path = WebTools.SessionDataPath(); string sql = ""; string FileName = ""; string folderPath = WebTools.GetExpr("path", "dir_objects", " dir_obj='ISO_SPOOLGEN'"); string filePath = string.Empty; using (OracleConnection conn = WebTools.GetIpmsConnection()) { //Isometric sql = "SELECT * FROM VIEW_ISO_PDF_BLOB_WO WHERE WO_ID=" + jcGridView.SelectedValue.ToString(); using (OracleCommand cmd = new OracleCommand(sql, conn)) { using (OracleDataReader dataReader = cmd.ExecuteReader()) { while (dataReader.Read()) { FileName = WebTools.SessionDataPath() + dataReader["PDF_FILE_NAME"]; if (File.Exists(FileName)) { File.Delete(FileName); } //if (dataReader["SG_PDF_BLOB"] == DBNull.Value) continue; //byte[] byteArray = (Byte[])dataReader["SG_PDF_BLOB"]; if (File.Exists(folderPath + dataReader["PDF_FILE_NAME"])) { zip_file.AddFile(folderPath + dataReader["PDF_FILE_NAME"]); } } } //OracleDataReader1 } //OracleCommand1 //Spool Piece sql = "SELECT * FROM VIEW_SPOOL_PDF_WO WHERE WO_ID=" + jcGridView.SelectedValue.ToString(); folderPath = WebTools.GetExpr("path", "dir_objects", " dir_obj='SPL_SPOOLGEN'"); using (OracleCommand cmd = new OracleCommand(sql, conn)) { using (OracleDataReader dataReader = cmd.ExecuteReader()) { while (dataReader.Read()) { FileName = WebTools.SessionDataPath() + dataReader["PDF_FILE_NAME"]; if (File.Exists(FileName)) { File.Delete(FileName); } //if (dataReader["SG_PDF_BLOB"] == DBNull.Value) continue; //byte[] byteArray = (Byte[])dataReader["SG_PDF_BLOB"]; //using (FileStream fs = new FileStream(FileName, FileMode.CreateNew, FileAccess.Write)) //{ // fs.Write(byteArray, 0, byteArray.Length); // zip_file.AddFile(FileName, "SPOOL"); //} if (File.Exists(folderPath + dataReader["PDF_FILE_NAME"])) { zip_file.AddFile(folderPath + dataReader["PDF_FILE_NAME"]); } } } //OracleDataReader2 } //OracleCommand2 // Iso AS Built sql = "SELECT * FROM VIEW_ISO_PDF_BLOB_WO WHERE WO_ID=" + jcGridView.SelectedValue.ToString(); folderPath = WebTools.GetExpr("path", "dir_objects", " dir_obj='ISO_AB'"); using (OracleCommand cmd = new OracleCommand(sql, conn)) { using (OracleDataReader dataReader = cmd.ExecuteReader()) { while (dataReader.Read()) { FileName = WebTools.SessionDataPath() + dataReader["PDF_FILE_NAME"]; if (File.Exists(FileName)) { File.Delete(FileName); } if (File.Exists(folderPath + dataReader["PDF_FILE_NAME"])) { zip_file.AddFile(folderPath + dataReader["PDF_FILE_NAME"]); } } } } }//OracleConnection }
protected void btnSubmit_Click(object sender, EventArgs e) { string po_id = WebTools.GetExpr("PO_ID", "PIP_PO", "PROJECT_ID=" + Session["PROJECT_ID"].ToString() + " AND PO_NO='" + PO_NO_HiddenField.Value + "'"); if (po_id.Length == 0) { Master.ShowWarn("PO Number not found!"); return; } string FileName = WebTools.SessionDataPath() + txtTC_No.Text.Replace("/", "-") + ".pdf"; if (File.Exists(FileName)) { System.IO.File.Delete(FileName); } if (PDF_Upload.HasFile == true) { PDF_Upload.SaveAs(FileName); } //Saving to Oracle byte[] byteArray = null; if (PDF_Upload.HasFile == true) { using (FileStream fs = new FileStream (FileName, FileMode.Open, FileAccess.Read, FileShare.Read)) { byteArray = new byte[fs.Length]; int iBytesRead = fs.Read(byteArray, 0, (int)fs.Length); } } string sql = " INSERT INTO PIP_TEST_CARDS (PROJECT_ID, TC_CODE, REMARKS, PO_ID, MTC_BLOB) VALUES (:PROJECT_ID, :TC_CODE, :REMARKS, :PO_ID, :MTC_BLOB)"; using (OracleConnection conn = WebTools.GetIpmsConnection()) { //conn.Open(); using (OracleCommand cmd = new OracleCommand(sql, conn)) { cmd.Parameters.Add("PROJECT_ID", OracleType.Number); cmd.Parameters[0].Value = Session["PROJECT_ID"].ToString(); cmd.Parameters.Add("TC_CODE", OracleType.VarChar); cmd.Parameters[1].Value = txtTC_No.Text; cmd.Parameters.Add("REMARKS", OracleType.VarChar); cmd.Parameters[2].Value = txtRemarks.Text; cmd.Parameters.Add("PO_ID", OracleType.Number); cmd.Parameters[3].Value = po_id; cmd.Parameters.Add("MTC_BLOB", OracleType.Blob); if (byteArray != null) { cmd.Parameters[4].Value = byteArray; } else { cmd.Parameters[4].Value = DBNull.Value; } cmd.ExecuteNonQuery(); } Master.ShowMessage(txtTC_No.Text + " Saved!"); } }
public static void ExportToExcelNopi(string FilePath, string SqlQuery) { DataTable dt = new DataTable(); OracleConnection conn = WebTools.GetIpmsConnection(); OracleCommand cmd = new OracleCommand(SqlQuery, conn); // create data adapter OracleDataAdapter da = new OracleDataAdapter(cmd); // this will query your database and return the result to your datatable da.Fill(dt); // close objects conn.Close(); da.Dispose(); cmd.Dispose(); using (FileStream stream = new FileStream(FilePath, FileMode.Create, FileAccess.Write)) { IWorkbook wb = new XSSFWorkbook(); ISheet sheet = wb.CreateSheet("Sheet1"); ICreationHelper cH = wb.GetCreationHelper(); // create header IRow header_row = sheet.CreateRow(0); // first row = 0 // style for heading IFont boldFont = wb.CreateFont(); boldFont.Boldweight = (short)FontBoldWeight.Bold; ICellStyle header_style = wb.CreateCellStyle(); header_style.SetFont(boldFont); //boldStyle.BorderBottom = BorderStyle.Medium; header_style.FillForegroundColor = NPOI.HSSF.Util.HSSFColor.Grey25Percent.Index; header_style.FillPattern = FillPattern.SolidForeground; header_style.Alignment = HorizontalAlignment.Center; header_style.VerticalAlignment = VerticalAlignment.Center; for (int j = 0; j < dt.Columns.Count; j++) { ICell cell = header_row.CreateCell(j); cell.SetCellValue(cH.CreateRichTextString(dt.Columns[j].ColumnName)); cell.CellStyle = header_style; } for (int i = 0; i < dt.Rows.Count; i++) { IRow row = sheet.CreateRow(i + 1); for (int j = 0; j < dt.Columns.Count; j++) { DataRow drow = dt.Rows[i]; string str_value = drow.ItemArray[j].ToString(); ICell cell = row.CreateCell(j); if (dt.Columns[j].DataType == typeof(DateTime) && drow.ItemArray[j] != DBNull.Value) { cell.SetCellValue(DateTime.Now); IDataFormat dataFormatCustom = wb.CreateDataFormat(); DateTime?date_field = drow.Field <DateTime?>(j); //cell.CellStyle.DataFormat = dataFormatCustom.GetFormat("yyyyMMdd HH:mm:ss"); //DateTime.ParseExact(str_value, "dd/M/yyyy hh:mm:ss tt", CultureInfo.InvariantCulture) cell.SetCellValue(date_field.Value); ICellStyle date_style = wb.CreateCellStyle(); date_style.DataFormat = dataFormatCustom.GetFormat("dd-mmm-yyyy;@"); cell.CellStyle = date_style; } { cell.SetCellValue(cH.CreateRichTextString(str_value.ToString())); } } } wb.Write(stream); } }