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