public override void DeleteStockCRUDLog(CRUDLogObject logObject)
{
var obj = logObject as StockLogObject;
using (DBClass = new MSSQLDatabase())
{
using (var txn = DBClass.BeginTransaction())
{
try
{
var cmd = DBClass.GetStoredProcedureCommand("DELETE_STOCKFLOW_PO") as SqlCommand;
DBClass.AddSimpleParameter(cmd, "@ProductId", obj.ProductID);
DBClass.AddSimpleParameter(cmd, "@DepartementId", obj.DepartementID);
DBClass.AddSimpleParameter(cmd, "@PurchaseVoucher", obj.PurchaseVoucher);
DBClass.AddSimpleParameter(cmd, "@CreatedDate", obj.CreatedDate);
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 SaveStockCRUDLog(CRUDLogObject logObject)
{
var obj = logObject as StockLogObject;
int objID = 0;
using (DBClass = new MSSQLDatabase())
{
var cmd = DBClass.GetStoredProcedureCommand("SAVE_NEW_STOCKFLOW") as SqlCommand;
DBClass.AddSimpleParameter(cmd, "@DepartementId", obj.DepartementID);
DBClass.AddSimpleParameter(cmd, "@ProductId", obj.ProductID);
DBClass.AddSimpleParameter(cmd, "@Description", obj.Description);
DBClass.AddSimpleParameter(cmd, "@PurchaseVoucher", obj.PurchaseVoucher);
DBClass.AddSimpleParameter(cmd, "@Deposit", obj.Deposit);
DBClass.AddSimpleParameter(cmd, "@Withdraw", obj.Withdraw);
DBClass.AddSimpleParameter(cmd, "@Note", obj.Note);
DBClass.AddSimpleParameter(cmd, "@CreatedBy", obj.CreatedBy);
DBClass.AddSimpleParameter(cmd, "@CreatedDate", obj.CreatedDate);
var reader = DBClass.ExecuteReader(cmd);
while (reader.Read())
{
objID = int.Parse(reader[0].ToString());
}
}
return(objID);
}
public virtual int SaveStockCRUDLog(CRUDLogObject logObject)
{
return(default(int));
}
public virtual void DeleteStockCRUDLog(CRUDLogObject logObject)
{
}
