public JsonResult BudgetGrid(int typeID) { int total; List <TPOMonthlyProductionBudgetModel> model = new List <TPOMonthlyProductionBudgetModel>(); TPOMonthlyProductionBudgetModel m = new TPOMonthlyProductionBudgetModel(); using (TPOMonthlyProductionBudgetService svc = new TPOMonthlyProductionBudgetService()) { for (int i = 1; i <= 12; i++) { var d = svc.GetByYear(typeID).Count(q => q.Month == i); if (d == 0) { ProductionBudgetDto dto = new ProductionBudgetDto(); using (TPOMonthlyProductionBudgetService service = new TPOMonthlyProductionBudgetService()) { Mapper.Map(m, dto); dto.TypeID = 1; dto.Year = typeID; dto.Month = i; dto.PlantID = CurrentPlantId; dto.LastModified = DateTime.Now; dto.ModifiedBy = CurrentUser; dto.DateEntered = DateTime.Now; dto.EnteredBy = CurrentUser; service.Add(dto); } } } var dtos = svc.GetByYear(typeID); total = dtos.Count; var currentDtos = dtos.OrderBy(r => r.Month).ToList(); model.AddRange(Mapper.Map <List <ProductionBudgetDto>, List <TPOMonthlyProductionBudgetModel> >(currentDtos)); } return(BuildJsonResult(model, total)); }
public JsonResult BudgetAjaxUpdate(string id) { TPO.Web.Core.ResponseMessage responseMessage; try { TPOMonthlyProductionBudgetService srsrv = new TPOMonthlyProductionBudgetService(); TPOMonthlyProductionBudgetModel model = JsonConvert.DeserializeObject <TPOMonthlyProductionBudgetModel>(id); if (model != null) { var x = srsrv.GetAll().Where(q => q.Year == model.Year).ToList(); if (!x.Any()) { ProductionBudgetDto dto = new ProductionBudgetDto(); using (TPOMonthlyProductionBudgetService service = new TPOMonthlyProductionBudgetService()) { Mapper.Map(model, dto); dto.TypeID = 1; dto.PlantID = CurrentPlantId; dto.LastModified = DateTime.Now; dto.ModifiedBy = CurrentUser; dto.DateEntered = DateTime.Now; dto.EnteredBy = CurrentUser; if (model.Id > 0) { service.Update(dto); } else { service.Add(dto); } } } else { ProductionBudgetDto dto = new ProductionBudgetDto(); using (TPOMonthlyProductionBudgetService service = new TPOMonthlyProductionBudgetService()) { Mapper.Map(model, dto); dto.TypeID = 1; dto.PlantID = CurrentPlantId; dto.LastModified = DateTime.Now; dto.ModifiedBy = CurrentUser; dto.DateEntered = DateTime.Now; dto.EnteredBy = CurrentUser; service.Update(dto); } } } responseMessage = SetResponseMesssage(ActionTypeMessage.SuccessfulSave); } catch (Exception exc) { responseMessage = SetResponseMesssage(ActionTypeMessage.FailedSave, exc.Message); } return(Json(responseMessage, JsonRequestBehavior.AllowGet)); }