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