private string SaveToDatabase(byte[] btReport, string id) { // Write to J Drive string filepath = ""; string timestamp = DateTime.Now.ToString("MMddHHmmssfff"); string filename = "fax" + id + "_" + timestamp + ".pdf"; string credentials = Data.getJCredential(); String[] credentialsArray = credentials.Split("|".ToCharArray()); string COMPUTER_IP = credentialsArray[0].ToString().Split(':')[1]; string DOMAIN = credentialsArray[1].ToString().Split(':')[1]; string USER_NAME = credentialsArray[2].ToString().Split(':')[1]; string PASSWORD = credentialsArray[3].ToString().Split(':')[1]; try { using (NetworkShareAccesser.Access(COMPUTER_IP, DOMAIN, USER_NAME, PASSWORD)) { filepath = "\\\\" + COMPUTER_IP + "\\j_drive\\Clients\\LifeEvent\\" + filename; File.WriteAllBytes(filepath, btReport); filepath = filepath.Replace("\\\\" + COMPUTER_IP + "\\j_drive\\", "J:\\"); } } catch { } // Save to Database Oracle.DataAccess.Client.OracleConnection conn = SQLStatic.SQL.OracleConnection(); try { Oracle.DataAccess.Client.OracleCommand cmd = new Oracle.DataAccess.Client.OracleCommand("pkg_Enrollment_Wizard_LE.SaveFaxImage", conn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.CommandTimeout = 30; SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "doc_record_id", Request.Params["DpNo"]); SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "user_name_", SQLStatic.Sessions.GetUserName(HttpContext.Current.Request.Cookies["Session_ID"].Value.ToString())); Oracle.DataAccess.Client.OracleParameter parm; parm = new Oracle.DataAccess.Client.OracleParameter( "value_", Oracle.DataAccess.Client.OracleDbType.Blob, btReport.Length, System.Data.ParameterDirection.Input, true, ((System.Byte)(0)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, btReport); cmd.Parameters.Add(parm); try { cmd.ExecuteNonQuery(); } finally { cmd.Dispose(); } } finally { conn.Close(); conn.Dispose(); } return(filename); }
public static void SaveArray(int intCount, string[] strRecordID, string[] strFieldName, string[] strRate, string[] strUserName) { Oracle.DataAccess.Client.OracleConnection conn = SQLStatic.SQL.OracleConnection(); Oracle.DataAccess.Client.OracleCommand cmd = new Oracle.DataAccess.Client.OracleCommand(" pkg_automated_rate_update.saverate", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.ArrayBindCount = intCount; OracleParameter paramRecordID = new OracleParameter("record_id_", OracleDbType.Varchar2); paramRecordID.Direction = ParameterDirection.Input; paramRecordID.Value = strRecordID; cmd.Parameters.Add(paramRecordID); OracleParameter paramFieldName = new OracleParameter("fieldname_", OracleDbType.Varchar2); paramFieldName.Direction = ParameterDirection.Input; paramFieldName.Value = strFieldName; cmd.Parameters.Add(paramFieldName); OracleParameter paramRates = new OracleParameter("rates_", OracleDbType.Varchar2); paramRates.Direction = ParameterDirection.Input; paramRates.Value = strRate; cmd.Parameters.Add(paramRates); OracleParameter paramUserName = new OracleParameter("user_name_", OracleDbType.Varchar2); paramUserName.Direction = ParameterDirection.Input; paramUserName.Value = strUserName; cmd.Parameters.Add(paramUserName); try { cmd.ExecuteNonQuery(); } finally { conn.Close(); conn.Dispose(); cmd.Dispose(); } }
private void SaveToDatabase2(byte[] btReport) { // SQLStatic.SQL.ExecScaler("select max(record_id) from ee_dependent_verify_docs v where v.dep_pending_id = " + Request.Params["DpNo"]).ToString(); //string reccord_id = Data.newFaxDocRecordID(Request.Params["DpNo"]); //if (reccord_id.Equals("-1")) // return; //SQLStatic.Sessions.SetSessionValue(Request.Cookies["Session_ID"].Value.ToString(), "reprt", reccord_id); //SQLStatic.Sessions.SetBLOBSessionValue(Request.Cookies["Session_ID"].Value.ToString(), "reprt", btReport); Oracle.DataAccess.Client.OracleConnection conn = SQLStatic.SQL.OracleConnection(); try { Oracle.DataAccess.Client.OracleCommand cmd = new Oracle.DataAccess.Client.OracleCommand("pkg_Dependents_Audit.SaveFaxImage", conn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.CommandTimeout = 30; SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "doc_record_id", Request.Params["DpNo"]); Oracle.DataAccess.Client.OracleParameter parm; parm = new Oracle.DataAccess.Client.OracleParameter( "value_", Oracle.DataAccess.Client.OracleDbType.Blob, btReport.Length, System.Data.ParameterDirection.Input, true, ((System.Byte)(0)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, btReport); cmd.Parameters.Add(parm); try { cmd.ExecuteNonQuery(); } finally { cmd.Dispose(); } } finally { conn.Close(); conn.Dispose(); } }
public static void SaveCBArray(int intCount, string[] account_number, string[] processing_year, string[] in_open_enrollment, string[] category_code, string[] categoty_plan, string[] class_code, string[] batch_id) { Oracle.DataAccess.Client.OracleConnection conn = SQLStatic.SQL.OracleConnection(); Oracle.DataAccess.Client.OracleCommand cmd = new Oracle.DataAccess.Client.OracleCommand(" pkg_automated_rate_update.Save_In_OE", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.ArrayBindCount = intCount; OracleParameter parmaAccountNumber = new OracleParameter("account_number_", OracleDbType.Varchar2); parmaAccountNumber.Direction = ParameterDirection.Input; parmaAccountNumber.Value = account_number; cmd.Parameters.Add(parmaAccountNumber); OracleParameter paramprocessing_year = new OracleParameter("processing_year_", OracleDbType.Varchar2); paramprocessing_year.Direction = ParameterDirection.Input; paramprocessing_year.Value = processing_year; cmd.Parameters.Add(paramprocessing_year); OracleParameter paramRates = new OracleParameter("in_open_enrollment_", OracleDbType.Varchar2); paramRates.Direction = ParameterDirection.Input; paramRates.Value = in_open_enrollment; cmd.Parameters.Add(paramRates); OracleParameter paramcategory_code = new OracleParameter("category_code_", OracleDbType.Varchar2); paramcategory_code.Direction = ParameterDirection.Input; paramcategory_code.Value = category_code; cmd.Parameters.Add(paramcategory_code); OracleParameter parmcategoty_plan = new OracleParameter("categoty_plan_", OracleDbType.Varchar2); parmcategoty_plan.Direction = ParameterDirection.Input; parmcategoty_plan.Value = categoty_plan; cmd.Parameters.Add(parmcategoty_plan); OracleParameter paramclass_code = new OracleParameter("class_code_", OracleDbType.Varchar2); paramclass_code.Direction = ParameterDirection.Input; paramclass_code.Value = class_code; cmd.Parameters.Add(paramclass_code); OracleParameter parambatch_id = new OracleParameter("batch_id_", OracleDbType.Varchar2); parambatch_id.Direction = ParameterDirection.Input; parambatch_id.Value = batch_id; cmd.Parameters.Add(parambatch_id); try { cmd.ExecuteNonQuery(); } finally { conn.Close(); conn.Dispose(); cmd.Dispose(); } }
private void SaveToDatabase(byte[] btReport) { // SQLStatic.SQL.ExecScaler("select max(record_id) from ee_dependent_verify_docs v where v.dep_pending_id = " + Request.Params["DpNo"]).ToString(); string reccord_id = Data.newFaxDocRecordID(Request.Params["DpNo"]); if (reccord_id.Equals("-1")) { return; } SQLStatic.Sessions.SetSessionValue(Request.Cookies["Session_ID"].Value.ToString(), "reprt", reccord_id); SQLStatic.Sessions.SetBLOBSessionValue(Request.Cookies["Session_ID"].Value.ToString(), ViewState["EE"].ToString() + " " + Request.Params["DpNo"], btReport); Oracle.DataAccess.Client.OracleConnection conn = SQLStatic.SQL.OracleConnection(); try { Oracle.DataAccess.Client.OracleCommand cmd = new Oracle.DataAccess.Client.OracleCommand("pkg_Dependents_Audit.SaveFaxImage", conn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.CommandTimeout = 30; SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "doc_record_id", reccord_id); Oracle.DataAccess.Client.OracleParameter parm; parm = new Oracle.DataAccess.Client.OracleParameter( "value_", Oracle.DataAccess.Client.OracleDbType.Blob, btReport.Length, System.Data.ParameterDirection.Input, true, ((System.Byte)(0)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, btReport); cmd.Parameters.Add(parm); try { cmd.ExecuteNonQuery(); } finally { cmd.Dispose(); } } finally { conn.Close(); conn.Dispose(); } // Here you save bytes to the database //using (OracleConnection con = new OracleConnection(ConnStr)) //{ // using (OracleCommand cmd = new OracleCommand("PKG_Name.Procedure_Save_PDF", con)) // { // con.Open(); // try // { // foreach (ReportParameters p in parameters) // { // try // { // // GenerateReportByteArray will return byte array for the database // cmd.Parameters.Add("file_blob_", OracleDbType.Blob, ParameterDirection.Input); // cmd.Parameters["file_blob_"].Value = btReport; // cmd.ExecuteNonQuery(); // } // catch (Exception ex) // { // Message = ex.Message; // } // } // Message = "Insert done"; // } // catch (Exception ex) // { // Message = ex.Message; // } // finally // { // if (con.State != ConnectionState.Closed) con.Close(); // } //} //} }