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