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();
// }
//}
//}
}
