public void Update_Record(BE_Expense NewBEObj) { SqlTransaction sqlTransaction = (SqlTransaction)null; try { string Qry = @"Update trans_Expenses set AssignDate=@Date, Expenses=@Expenses, Amount=@Amount, Description=@Description, Modify_At=@Modify_At, IsActive=@IsActive where ExpenseID=@ExpenseID"; SqlConnection sqlConnection = new SqlConnection(this.ConnString); SqlCommand command = new SqlCommand(Qry, sqlConnection); sqlConnection.Open(); sqlTransaction = sqlConnection.BeginTransaction(); command.Transaction = sqlTransaction; command.CommandType = CommandType.Text; command.CommandText = Qry; command.Parameters.AddWithValue("@ExpenseID", (object)NewBEObj.ExpenseID); command.Parameters.AddWithValue("@Date", (object)NewBEObj.AssignDate); command.Parameters.AddWithValue("@Expenses", (object)NewBEObj.Expenses); command.Parameters.AddWithValue("@Amount", (object)NewBEObj.Amount); command.Parameters.AddWithValue("@Description", (object)NewBEObj.Description); command.Parameters.AddWithValue("@Modify_At", (object)NewBEObj.Modify_At); command.Parameters.AddWithValue("@IsActive", NewBEObj.IsActive); command.ExecuteNonQuery(); command.Parameters.Clear(); sqlTransaction.Commit(); sqlConnection.Close(); command.Dispose(); sqlTransaction.Dispose(); } catch (Exception ex) { int num = (int)MessageBox.Show(ex.Message, DataAccess.ProjectName, MessageBoxButtons.OK, MessageBoxIcon.Hand); sqlTransaction.Rollback(); } }
public void Insert_Record(BE_Expense NewBEObj) { SqlTransaction sqlTransaction = (SqlTransaction)null; try { string Qry = @"Insert into trans_Expenses(ExpenseID,AssignDate,Expenses,Amount,Description,Created_At,Modify_At,IsActive) Values (@ExpenseID,@Date,@Expenses,@Amount,@Description,@Created_At,@Modify_At,@IsActive)"; SqlConnection sqlConnection = new SqlConnection(this.ConnString); SqlCommand command = new SqlCommand(Qry, sqlConnection); sqlConnection.Open(); sqlTransaction = sqlConnection.BeginTransaction(); //command.CommandText = "INSERT INTO Trans_InvestmentPosting\r\n (InvestmentPostingID,InvestorsID, InvestmentDate, ModifiedDate, Amount, IsActive)\r\n VALUES (@InvestmentPostingID,@InvestorsID, @InvestmentDate, @ModifiedDate, @Amount, @IsActive)"; command.Transaction = sqlTransaction; command.CommandType = CommandType.Text; command.CommandText = Qry; this.InvestmentPosting = int.Parse(DataAccess.GetMaxNO("ExpenseID", "Trans_Expenses").ToString()); NewBEObj.ExpenseID = this.InvestmentPosting; command.Parameters.AddWithValue("@ExpenseID", (object)NewBEObj.ExpenseID); command.Parameters.AddWithValue("@Date", (object)NewBEObj.AssignDate); command.Parameters.AddWithValue("@Expenses", (object)NewBEObj.Expenses); command.Parameters.AddWithValue("@Amount", (object)NewBEObj.Amount); command.Parameters.AddWithValue("@Description", (object)NewBEObj.Description); command.Parameters.AddWithValue("@Created_At", (object)NewBEObj.Created_At); command.Parameters.AddWithValue("@Modify_At", (object)"1900-01-01"); command.Parameters.AddWithValue("@IsActive", NewBEObj.IsActive); command.ExecuteNonQuery(); command.Parameters.Clear(); sqlTransaction.Commit(); sqlConnection.Close(); command.Dispose(); sqlTransaction.Dispose(); } catch (Exception ex) { int num = (int)MessageBox.Show(ex.Message, DataAccess.ProjectName, MessageBoxButtons.OK, MessageBoxIcon.Hand); sqlTransaction.Rollback(); } }