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