public bool InsertBudgetMenguru(BudgetMenguru objBudgetMenguru, List <JuncBgtMengurusSegDtl> lstBgtMengurusSegDtl)
{
PeriodMenguru per = db.PeriodMengurus.Where(x => x.PeriodMengurusID == objBudgetMenguru.PeriodMengurusID).FirstOrDefault();
try
{
db.BudgetMengurus.Add(objBudgetMenguru);
foreach (JuncBgtMengurusSegDtl obj in lstBgtMengurusSegDtl)
{
JuncBgtMengurusSegDtl item = new JuncBgtMengurusSegDtl();
item.BudgetMenguru = objBudgetMenguru;
item.SegmentDetailID = obj.SegmentDetailID;
item.CreatedBy = objBudgetMenguru.CreatedBy;
item.CreatedTimeStamp = DateTime.Now;
item.ModifiedBy = objBudgetMenguru.CreatedBy;
item.ModifiedTimeStamp = DateTime.Now;
db.JuncBgtMengurusSegDtls.Add(item);
}
db.SaveChanges();
BPEventLog bpe = new BPEventLog();
bpe.Object = "Budget Mengurus-" + per.MengurusYear + "-" + per.FieldMenguru.FieldMengurusDesc;
bpe.ObjectName = GetAccountCodePrefix(lstBgtMengurusSegDtl) + "-" + objBudgetMenguru.AccountCode;
bpe.ObjectChanges = "<tr><td>Status</td><td>O</td><td>S</td></tr> <tr><td>Amount</td><td>0.00</td><td>" + objBudgetMenguru.Amount.ToString("F") + "</td></tr>";
bpe.EventMassage = "Success";
bpe.Status = "I";
bpe.CreatedBy = objBudgetMenguru.CreatedBy;
bpe.CreatedTimeStamp = objBudgetMenguru.CreatedTimeStamp;
new EventLogDAL().AddEventLog(bpe);
return(true);
}
catch (Exception ex)
{
BPEventLog bpe = new BPEventLog();
bpe.Object = "Budget Mengurus-" + per.MengurusYear + "-" + per.FieldMenguru.FieldMengurusDesc;
bpe.ObjectName = GetAccountCodePrefix(lstBgtMengurusSegDtl) + "-" + objBudgetMenguru.AccountCode;
bpe.ObjectChanges = "<tr><td>Status</td><td>O</td><td>S</td></tr> <tr><td>Amount</td><td>0.00</td><td>" + objBudgetMenguru.Amount.ToString("F") + "</td></tr>";
bpe.EventMassage = "Failure";
bpe.Status = "I";
bpe.CreatedBy = objBudgetMenguru.CreatedBy;
bpe.CreatedTimeStamp = objBudgetMenguru.CreatedTimeStamp;
new EventLogDAL().AddEventLog(bpe);
throw ex;
}
}
public bool UpdatePeriodMenguru(PeriodMenguru objPeriodMenguru)
{
PeriodMenguru obj = db.PeriodMengurus.Where(x => x.PeriodMengurusID == objPeriodMenguru.PeriodMengurusID).FirstOrDefault();
string changes = new EventLogDAL().ObjectDifference(obj, objPeriodMenguru);
try
{
if (obj != null)
{
obj.FieldMengurusID = objPeriodMenguru.FieldMengurusID;
obj.MengurusYear = objPeriodMenguru.MengurusYear;
obj.Status = objPeriodMenguru.Status;
obj.ModifiedBy = objPeriodMenguru.ModifiedBy;
obj.ModifiedTimeStamp = objPeriodMenguru.ModifiedTimeStamp;
db.SaveChanges();
BPEventLog bpe = new BPEventLog();
bpe.Object = "Period Mengurus";
bpe.ObjectName = obj.FieldMenguru.FieldMengurusDesc + " - " + objPeriodMenguru.MengurusYear;
bpe.ObjectChanges = changes;
bpe.EventMassage = "Success";
bpe.Status = "A";
bpe.CreatedBy = objPeriodMenguru.ModifiedBy;
bpe.CreatedTimeStamp = objPeriodMenguru.ModifiedTimeStamp;
new EventLogDAL().AddEventLog(bpe);
}
return(true);
}
catch (Exception ex)
{
BPEventLog bpe = new BPEventLog();
bpe.Object = "Period Mengurus";
bpe.ObjectName = obj.FieldMenguru.FieldMengurusDesc + " - " + objPeriodMenguru.MengurusYear;
bpe.ObjectChanges = changes;
bpe.EventMassage = "Failure";
bpe.Status = "A";
bpe.CreatedBy = objPeriodMenguru.ModifiedBy;
bpe.CreatedTimeStamp = objPeriodMenguru.ModifiedTimeStamp;
new EventLogDAL().AddEventLog(bpe);
throw ex;
}
}
public bool InsertPeriodMenguru(PeriodMenguru objPeriodMenguru)
{
FieldMenguru objfm = db.FieldMengurus.Where(x => x.FieldMengurusID == objPeriodMenguru.FieldMengurusID).FirstOrDefault();
try
{
db.PeriodMengurus.Add(objPeriodMenguru);
db.SaveChanges();
BPEventLog bpe = new BPEventLog();
bpe.Object = "Period Mengurus";
bpe.ObjectName = objfm.FieldMengurusDesc + " - " + objPeriodMenguru.MengurusYear;
bpe.ObjectChanges = string.Empty;
bpe.EventMassage = "Success";
bpe.Status = "A";
bpe.CreatedBy = objPeriodMenguru.CreatedBy;
bpe.CreatedTimeStamp = objPeriodMenguru.CreatedTimeStamp;
new EventLogDAL().AddEventLog(bpe);
return(true);
}
catch (Exception ex)
{
BPEventLog bpe = new BPEventLog();
bpe.Object = "Period Mengurus";
bpe.ObjectName = objfm.FieldMengurusDesc + " - " + objPeriodMenguru.MengurusYear;
bpe.ObjectChanges = string.Empty;
bpe.EventMassage = "Failure";
bpe.Status = "A";
bpe.CreatedBy = objPeriodMenguru.CreatedBy;
bpe.CreatedTimeStamp = objPeriodMenguru.CreatedTimeStamp;
new EventLogDAL().AddEventLog(bpe);
throw ex;
}
}
