public void UpdateBalance(string empId, DateTime monthYearReport, int balance) { try { var report = dbContext.PTO_Reports.FirstOrDefault(p => p.EmployeeId == empId && p.MonthYearReport.Year == monthYearReport.Year && p.MonthYearReport.Month == monthYearReport.Month); if (report != null) { report.CarriedForward = balance; report.UpdateDate = DateTime.Now; report.UpdatedBy = HttpContext.Current.User.Identity.Name; } else { //insert balance to the previous month -> carried forward report = new PTO_Report() { EmployeeId = empId, MonthYearReport = monthYearReport, CarriedForward = balance, CreateDate = DateTime.Now, CreatedBy = HttpContext.Current.User.Identity.Name, UpdateDate = DateTime.Now, UpdatedBy = HttpContext.Current.User.Identity.Name }; dbContext.PTO_Reports.InsertOnSubmit(report); } dbContext.SubmitChanges(); } catch { } }
public void UpdateVacationSerinority(PTO_Report objUI,int vacationThisMonth) { PTO_Report objDb = GetByID(objUI.ID); if (objDb != null) { objDb.MonthlyVacation = vacationThisMonth; dbContext.SubmitChanges(); } }
/// <summary> /// Update a PTO Report /// </summary> /// <param name="holiday"></param> /// <returns></returns> public Message Update(PTO_Report report) { Message msg = null; try { PTO_Report reportDb = GetPTO(report.ID); //Another user has updated this holiday if (!reportDb.UpdateDate.ToString().Trim().Equals(report.UpdateDate.ToString().Trim())) { msg = new Message(MessageConstants.E0025, MessageType.Error, "EOM balance"); } //Successful case else { reportDb.CarriedForward = report.CarriedForward; reportDb.MonthlyVacation = report.MonthlyVacation; reportDb.Comment = report.Comment; reportDb.UpdatedBy = report.UpdatedBy; reportDb.UpdateDate = DateTime.Now; dbContext.SubmitChanges(); msg = new Message(MessageConstants.I0001, MessageType.Info, "EOM balance of " + reportDb.EmployeeId + " - " + reportDb.Employee.FirstName + " " + reportDb.Employee.MiddleName + " " + reportDb.Employee.LastName, "updated"); } } catch { msg = new Message(MessageConstants.E0007, MessageType.Error); } return msg; }