public void saveC4Pdf(ArrayList obj)
{
try
{
strConn = ConfigurationManager.AppSettings["Connection_String"].ToString();
conn = new SqlConnection(strConn);
conn.Open();
for (int i = 0; i < obj.Count; i++)
{
FormsBO objForm = new FormsBO();
objForm = (FormsBO)obj[i];
string query = "INSERT INTO [txn_pdf_c4auth] ([i_case_id],[sz_company_id],[s_control_name],[s_value],[s_control_type],[s_pdf_control_name],[dt_created],[sz_user_id])VALUES('" + objForm.i_case_id + "','" + objForm.sz_company_id + "','" + objForm.s_control_name + "','" + objForm.s_value + "','" + objForm.s_control_type + "','" + objForm.s_pdf_control_name + "',GETDATE(),'" + objForm.sz_user_id + "')";
SqlCommand Cmd = new SqlCommand(query, conn);
Cmd.CommandTimeout = Convert.ToInt32(ConfigurationManager.AppSettings["CommandTimeOut"].ToString());
Cmd.ExecuteNonQuery();
}
}
catch (Exception ex)
{
Elmah.ErrorSignal.FromCurrentContext().Raise(ex);
}
finally { conn.Close(); }
}
public override bool Delete(params object[] keys)
{
try
{
this.ConnectionHandler.StartTransaction(IsolationLevel.ReadUncommitted);
this.FormGeneratorConnection.StartTransaction(IsolationLevel.ReadUncommitted);
var congressFormsBo = new FormsBO();
var obj = congressFormsBo.Get(this.ConnectionHandler, keys);
if (!congressFormsBo.Delete(this.ConnectionHandler, keys))
{
throw new Exception("خطایی در حذف فرم وجود دارد");
}
if (!FormGeneratorComponent.Instance.FormStructureTransactionalFacade(this.FormGeneratorConnection).Delete(obj.FormId))
{
throw new Exception("خطایی در حذف فرم وجود دارد");
}
this.ConnectionHandler.CommitTransaction();
this.FormGeneratorConnection.CommitTransaction();
return(true);
}
catch (KnownException knownException)
{
this.ConnectionHandler.RollBack();
this.FormGeneratorConnection.RollBack();
throw new KnownException(knownException.Message, knownException);
}
catch (Exception ex)
{
this.ConnectionHandler.RollBack();
this.FormGeneratorConnection.RollBack();
throw new KnownException(ex.Message, ex);
}
}
public void saveMG2Pdf(ArrayList obj)
{
try
{
strConn = ConfigurationManager.AppSettings["Connection_String"].ToString();
conn = new SqlConnection(strConn);
conn.Open();
FormsBO objForm1 = new FormsBO();
objForm1 = (FormsBO)obj[0];
//string query1 = "Delete from txn_pdf_c4auth where i_case_id='" + objForm1.i_case_id + "' and sz_company_id='" + objForm1.sz_company_id + "'";
//SqlCommand Cmd1 = new SqlCommand(query1, conn);
comm = new SqlCommand("sp_delete_MG2Pdf", conn);
comm.CommandTimeout = Convert.ToInt32(ConfigurationManager.AppSettings["CommandTimeOut"].ToString());
comm.CommandType = CommandType.StoredProcedure;
comm.Parameters.AddWithValue("@i_case_id", objForm1.i_case_id);
comm.Parameters.AddWithValue("@z_company_id", objForm1.sz_company_id);
comm.ExecuteNonQuery();
for (int i = 0; i < obj.Count; i++)
{
FormsBO objForm = new FormsBO();
objForm = (FormsBO)obj[i];
//string query = "INSERT INTO [txn_pdf_mg2] ([i_case_id],[sz_company_id],[s_control_name],[s_value],[s_control_type],[s_pdf_control_name],[dt_created],[sz_user_id])VALUES('" + objForm.i_case_id + "','" + objForm.sz_company_id + "','" + objForm.s_control_name + "','" + objForm.s_value + "','" + objForm.s_control_type + "','" + objForm.s_pdf_control_name + "',GETDATE(),'" + objForm.sz_user_id + "')";
//SqlCommand Cmd = new SqlCommand(query, conn);
comm = new SqlCommand("sp_save_MG2Pdf", conn);
comm.CommandTimeout = Convert.ToInt32(ConfigurationManager.AppSettings["CommandTimeOut"].ToString());
comm.CommandType = CommandType.StoredProcedure;
comm.Parameters.AddWithValue("@i_case_id", objForm.i_case_id);
comm.Parameters.AddWithValue("@sz_company_id", objForm.sz_company_id);
comm.Parameters.AddWithValue("@s_control_name", objForm.s_control_name);
comm.Parameters.AddWithValue("@s_value", objForm.s_value);
comm.Parameters.AddWithValue("@s_control_type", objForm.s_control_type);
comm.Parameters.AddWithValue("@s_pdf_control_name", objForm.s_pdf_control_name);
comm.Parameters.AddWithValue("@sz_user_id", objForm.sz_user_id);
comm.ExecuteNonQuery();
}
}
catch (Exception ex)
{
Elmah.ErrorSignal.FromCurrentContext().Raise(ex);
}
finally { conn.Close(); }
}
public void deleteC4ByCaseID(ArrayList obj)
{
try
{
strConn = ConfigurationManager.AppSettings["Connection_String"].ToString();
conn = new SqlConnection(strConn);
conn.Open();
for (int i = 0; i < obj.Count; i++)
{
FormsBO objForm = new FormsBO();
objForm = (FormsBO)obj[i];
string query = "Delete from txn_pdf_c4auth where i_case_id='" + objForm.i_case_id + "' and sz_company_id='" + objForm.sz_company_id + "'";
SqlCommand Cmd = new SqlCommand(query, conn);
Cmd.CommandTimeout = Convert.ToInt32(ConfigurationManager.AppSettings["CommandTimeOut"].ToString());
Cmd.ExecuteNonQuery();
}
}
catch (Exception ex)
{
Elmah.ErrorSignal.FromCurrentContext().Raise(ex);
}
finally { conn.Close(); }
}
