public override void DeleteCashCRUDLog(CashLogObject logObject)
{
using (DBClass = new MSSQLDatabase())
{
using (DbTransaction txn = DBClass.BeginTransaction())
{
try
{
var cmd = DBClass.GetStoredProcedureCommand("DELETE_CASHFLOW") as SqlCommand;
DBClass.AddSimpleParameter(cmd, "@CashId", logObject.CashID);
DBClass.AddSimpleParameter(cmd, "@SalesVoucher", logObject.SalesVoucher);
var affectedRows = DBClass.ExecuteNonQuery(cmd, txn);
if (affectedRows == 0)
{
throw new Exception("Hapus log gagal");
}
txn.Commit();
}
catch (Exception)
{
txn.Rollback();
throw;
}
}
}
}
public override int SaveCashCRUDLog(CashLogObject logObject)
{
int objID = 0;
using (DBClass = new MSSQLDatabase())
{
var cmd = DBClass.GetStoredProcedureCommand("SAVE_NEW_CASHFLOW") as SqlCommand;
DBClass.AddSimpleParameter(cmd, "@DepartementId", logObject.DepartementID);
DBClass.AddSimpleParameter(cmd, "@Description", logObject.Description);
DBClass.AddSimpleParameter(cmd, "@SalesVoucher", logObject.SalesVoucher);
DBClass.AddSimpleParameter(cmd, "@Deposit", logObject.Deposit);
DBClass.AddSimpleParameter(cmd, "@Withdraw", logObject.Withdraw);
DBClass.AddSimpleParameter(cmd, "@Note", logObject.Note);
DBClass.AddSimpleParameter(cmd, "@CreatedBy", logObject.CreatedBy);
DBClass.AddSimpleParameter(cmd, "@CreatedDate", logObject.CreatedDate);
var reader = DBClass.ExecuteReader(cmd);
while (reader.Read())
{
objID = int.Parse(reader[0].ToString());
}
if (objID == 0)
{
throw new Exception();
}
}
return(objID);
}
public virtual void DeleteCashCRUDLog(CashLogObject logObject)
{
}
public virtual int SaveCashCRUDLog(CashLogObject logObject)
{
return(default(int));
}
