public void UpdateFiscalYear(SqlTransaction sqlTransaction, FiscalYear fiscalYear) { const string sqlText = @"UPDATE FiscalYear SET close_date = @close_date, open_date = @open_date, name = @name WHERE id = @id"; using (OpenCbsCommand command = new OpenCbsCommand(sqlText, sqlTransaction.Connection, sqlTransaction)) { if (fiscalYear.OpenDate != null) { command.AddParam("@open_date", ((DateTime)fiscalYear.OpenDate).Date); } else { command.AddParam("@open_date", null); } if (fiscalYear.CloseDate != null) { command.AddParam("@close_date", ((DateTime)fiscalYear.CloseDate).Date); } else { command.AddParam("@close_date", null); } command.AddParam("@name", fiscalYear.Name); command.AddParam("@id", fiscalYear.Id); command.ExecuteNonQuery(); } }
public void DeleteFiscalYear(SqlTransaction sqlTransaction, FiscalYear fiscalYear) { const string sqlText = @"DELETE FROM dbo.FiscalYear WHERE id = @id"; using (OpenCbsCommand command = new OpenCbsCommand(sqlText, sqlTransaction.Connection, sqlTransaction)) { command.AddParam("@id", fiscalYear.Id); command.ExecuteNonQuery(); } }
public void InsertFiscalYear(SqlTransaction sqlTransaction, FiscalYear fiscalYear) { const string sqlText = @"INSERT INTO dbo.FiscalYear ( name , open_date , close_date ) VALUES ( @name , @open_date , @close_date )"; using (OpenCbsCommand command = new OpenCbsCommand(sqlText, sqlTransaction.Connection, sqlTransaction)) { command.AddParam("@name", fiscalYear.Name); if (fiscalYear.OpenDate != null) { command.AddParam("@open_date", ((DateTime) fiscalYear.OpenDate).Date); } else { command.AddParam("@open_date", null); } if (fiscalYear.CloseDate != null) { command.AddParam("@close_date", ((DateTime) fiscalYear.CloseDate).Date); } else { command.AddParam("@close_date", null); } command.ExecuteNonQuery(); } }
public void UpdateFiscalYear(FiscalYear fiscalYear) { using (SqlConnection conn = _accountManagement.GetConnection()) { SqlTransaction sqlTransac = conn.BeginTransaction(); try { _accountManagement.UpdateFiscalYear(sqlTransac, fiscalYear); sqlTransac.Commit(); } catch (Exception ex) { sqlTransac.Rollback(); throw ex; } } }