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