public bool InsertAccountCode(AccountCode objAccountCode)
{
try
{
db.AccountCodes.Add(objAccountCode);
db.SaveChanges();
BPEventLog bpe = new BPEventLog();
bpe.Object = "AccountCode";
bpe.ObjectName = objAccountCode.AccountCode1;
bpe.ObjectChanges = string.Empty;
bpe.EventMassage = "Success";
bpe.Status = "A";
bpe.CreatedBy = objAccountCode.CreatedBy;
bpe.CreatedTimeStamp = objAccountCode.CreatedTimeStamp;
new EventLogDAL().AddEventLog(bpe);
return(true);
}
catch (Exception ex)
{
BPEventLog bpe = new BPEventLog();
bpe.Object = "AccountCode";
bpe.ObjectName = objAccountCode.AccountCode1;
bpe.ObjectChanges = string.Empty;
bpe.EventMassage = "Failure";
bpe.Status = "A";
bpe.CreatedBy = objAccountCode.CreatedBy;
bpe.CreatedTimeStamp = objAccountCode.CreatedTimeStamp;
new EventLogDAL().AddEventLog(bpe);
return(true);
throw ex;
}
}
public bool UpdateAccountCode(AccountCode objAccountCode)
{
AccountCode obj = db.AccountCodes.Where(x => x.AccountCode1 == objAccountCode.AccountCode1).FirstOrDefault();
string changes = new EventLogDAL().ObjectDifference(obj, objAccountCode);
try
{
if (obj != null && changes != string.Empty)
{
//obj.AccountCode1 = objAccountCode.AccountCode1;
obj.AccountDesc = objAccountCode.AccountDesc;
obj.ParentAccountCode = objAccountCode.ParentAccountCode;
obj.Keterangan = objAccountCode.Keterangan;
obj.Pengiraan = objAccountCode.Pengiraan;
obj.Status = objAccountCode.Status;
obj.ModifiedBy = objAccountCode.ModifiedBy;
obj.ModifiedTimeStamp = objAccountCode.ModifiedTimeStamp;
db.SaveChanges();
BPEventLog bpe = new BPEventLog();
bpe.Object = "AccountCode";
bpe.ObjectName = objAccountCode.AccountCode1;
bpe.ObjectChanges = changes;
bpe.EventMassage = "Success";
bpe.Status = "A";
bpe.CreatedBy = objAccountCode.ModifiedBy;
bpe.CreatedTimeStamp = objAccountCode.ModifiedTimeStamp;
new EventLogDAL().AddEventLog(bpe);
}
return(true);
}
catch (Exception ex)
{
BPEventLog bpe = new BPEventLog();
bpe.Object = "AccountCode";
bpe.ObjectName = objAccountCode.AccountCode1;
bpe.ObjectChanges = changes;
bpe.EventMassage = "Failure";
bpe.Status = "A";
bpe.CreatedBy = objAccountCode.ModifiedBy;
bpe.CreatedTimeStamp = objAccountCode.ModifiedTimeStamp;
new EventLogDAL().AddEventLog(bpe);
throw ex;
}
}
public AccountCode GetParentAccountCode(AccountCode AccountCode)
{
return(db.AccountCodes.Where(x => x.AccountCode1 == AccountCode.ParentAccountCode).FirstOrDefault());
}