public ActionResult AddMonth(AddMonthViewModel addMonthViewModel) { if (ModelState.IsValid) { AddNewMonth(addMonthViewModel); return Json(new { success = true }); } return View(addMonthViewModel); }
public void AddNewMonth(AddMonthViewModel addMonthViewModel) { try { using (ASJDE context = new ASJDE()) { var user = Session["user"] as User; List<decimal> locations = (from l in context.Locations where l.CountryID == addMonthViewModel.CountryID && l.LocationStatusID == 1 select l.ID).ToList(); List<decimal> existingLocations = (from h in context.HoursWorkeds where h.CountryID == addMonthViewModel.CountryID && h.Month == addMonthViewModel.Month && h.Year == addMonthViewModel.Year select h.LocationID).ToList(); var locationsThatNeedAdded = locations.Except(existingLocations); foreach (var location in locationsThatNeedAdded) { HoursWorked hoursWorked = new HoursWorked { CountryID = addMonthViewModel.CountryID, LocationID = location, Year = addMonthViewModel.Year, Month = addMonthViewModel.Month, CreatedByDate = DateTime.Now, CreatedBy = user.LastName + ", " + user.FirstName, CreatedByUserName = user.UserName }; context.HoursWorkeds.Add(hoursWorked); } context.SaveChanges(); } } catch (DbEntityValidationException dbEx) { logger.Error("Exception", dbEx); } catch (Exception e) { logger.Error("Exception", e); } }
public ActionResult AddMonth() { AddMonthViewModel addMonthViewModel = new AddMonthViewModel(); return View(addMonthViewModel); }