public bool InsertYearEnd(YearEnd objYearEnd) { try { db.YearEnds.Add(objYearEnd); db.SaveChanges(); BPEventLog bpe = new BPEventLog(); bpe.Object = "Year End"; bpe.ObjectName = objYearEnd.BudgetType + " - " + objYearEnd.BudgetYear; bpe.ObjectChanges = "<tr><td>Status</td><td></td><td>" + ((objYearEnd.Status == "A") ? "Active" : "Ended") + "</td></tr>"; bpe.EventMassage = "Success"; bpe.Status = "A"; bpe.CreatedBy = objYearEnd.CreatedBy; bpe.CreatedTimeStamp = objYearEnd.CreatedTimeStamp; new EventLogDAL().AddEventLog(bpe); return(true); } catch (Exception ex) { BPEventLog bpe = new BPEventLog(); bpe.Object = "Year End"; bpe.ObjectName = objYearEnd.BudgetType + " - " + objYearEnd.BudgetYear; bpe.ObjectChanges = "<tr><td>Status</td><td></td><td>" + ((objYearEnd.Status == "A") ? "Active" : "Ended") + "</td></tr>"; bpe.EventMassage = "Failure"; bpe.Status = "A"; bpe.CreatedBy = objYearEnd.CreatedBy; bpe.CreatedTimeStamp = objYearEnd.CreatedTimeStamp; new EventLogDAL().AddEventLog(bpe); throw ex; } }
public bool UpdateYearEnd(YearEnd objYearEnd) { YearEnd obj = db.YearEnds.Where(x => x.BudgetType == objYearEnd.BudgetType && x.BudgetYear == objYearEnd.BudgetYear).FirstOrDefault(); string changes = new EventLogDAL().ObjectDifference(obj, objYearEnd); try { if (obj != null) { obj.BudgetType = objYearEnd.BudgetType; obj.BudgetYear = objYearEnd.BudgetYear; obj.Status = objYearEnd.Status; obj.ModifiedBy = objYearEnd.ModifiedBy; obj.ModifiedTimeStamp = objYearEnd.ModifiedTimeStamp; db.SaveChanges(); BPEventLog bpe = new BPEventLog(); bpe.Object = "Year End"; bpe.ObjectName = objYearEnd.BudgetType + " - " + objYearEnd.BudgetYear;; bpe.ObjectChanges = changes; bpe.EventMassage = "Success"; bpe.Status = "A"; bpe.CreatedBy = objYearEnd.ModifiedBy; bpe.CreatedTimeStamp = objYearEnd.ModifiedTimeStamp; new EventLogDAL().AddEventLog(bpe); } return(true); } catch (Exception ex) { BPEventLog bpe = new BPEventLog(); bpe.Object = "Year End"; bpe.ObjectName = objYearEnd.BudgetType + " - " + objYearEnd.BudgetYear; bpe.ObjectChanges = changes; bpe.EventMassage = "Failure"; bpe.Status = "A"; bpe.CreatedBy = objYearEnd.ModifiedBy; bpe.CreatedTimeStamp = objYearEnd.ModifiedTimeStamp; new EventLogDAL().AddEventLog(bpe); throw ex; } }