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 UpdateBudgetMenguru(BudgetMenguru objBudgetMenguru, List <int> LstSegmentDetailIDs) { BudgetMenguru obj = GetBudgetMengurus(LstSegmentDetailIDs) .Where(x => x.PeriodMengurusID == objBudgetMenguru.PeriodMengurusID && x.AccountCode == objBudgetMenguru.AccountCode).FirstOrDefault(); string changes = new EventLogDAL().ObjectDifference(obj, objBudgetMenguru); try { obj.Amount = objBudgetMenguru.Amount; obj.Status = objBudgetMenguru.Status; obj.Remarks = objBudgetMenguru.Remarks; obj.ModifiedBy = objBudgetMenguru.ModifiedBy; obj.ModifiedTimeStamp = objBudgetMenguru.ModifiedTimeStamp; db.SaveChanges(); BPEventLog bpe = new BPEventLog(); bpe.Object = "Budget Mengurus-" + obj.PeriodMenguru.MengurusYear + "-" + obj.PeriodMenguru.FieldMenguru.FieldMengurusDesc; bpe.ObjectName = GetAccountCodePrefix(LstSegmentDetailIDs) + "-" + objBudgetMenguru.AccountCode; bpe.ObjectChanges = changes; bpe.EventMassage = "Success"; bpe.Status = "I"; bpe.CreatedBy = objBudgetMenguru.ModifiedBy; bpe.CreatedTimeStamp = objBudgetMenguru.ModifiedTimeStamp; new EventLogDAL().AddEventLog(bpe); return(true); } catch (Exception ex) { BPEventLog bpe = new BPEventLog(); bpe.Object = "Budget Mengurus-" + obj.PeriodMenguru.MengurusYear + "-" + obj.PeriodMenguru.FieldMenguru.FieldMengurusDesc; bpe.ObjectName = GetAccountCodePrefix(LstSegmentDetailIDs) + "-" + objBudgetMenguru.AccountCode; bpe.ObjectChanges = changes; bpe.EventMassage = "Failure"; bpe.Status = "I"; bpe.CreatedBy = objBudgetMenguru.ModifiedBy; bpe.CreatedTimeStamp = objBudgetMenguru.ModifiedTimeStamp; new EventLogDAL().AddEventLog(bpe); throw ex; } }