// GET: Sales Budget/Edit/By ID public ActionResult Edit(long id) { var errorViewModel = new ErrorViewModel(); try { var model = _SalesBudgetService.BMSUnit.SalesBudgetRepository.GetByID(id); Session["SalesBudgetMasterId"] = model.Id; var sbuList = SelectListItemExtension.PopulateDropdownList(_SalesBudgetService.BMSUnit.SBURepository.GetAll().ToList <tblSBU>(), "Id", "SBUName").ToList(); var productList = SelectListItemExtension.PopulateDropdownList(_SalesBudgetService.BMSUnit.ProductRepository.GetAll().ToList <tblProduct>(), "Id", "ProductName").ToList(); var SalesPersonName = HttpContext.User.Identity.Name; var SalesPersonId = _SalesBudgetService.BMSUnit.UserInfoNameRepository.GetAll().Where(c => c.UserName == SalesPersonName).ToList().FirstOrDefault().Id; //var divisionName = var divCount = _SalesBudgetService.BMSUnit.SalesPersonRepository.GetAll().Where(c => c.SalesPersonId == SalesPersonName).ToList().Count(); string divisionName = null; if (divCount > 0) { var divisionId = _SalesBudgetService.BMSUnit.SalesPersonRepository.GetAll().Where(c => c.SalesPersonId == SalesPersonName).ToList().FirstOrDefault().DivisionId; divisionName = _SalesBudgetService.BMSUnit.DivisionRepository.GetAll().Where(c => c.Id == divisionId).ToList().FirstOrDefault().DivisionName; } if (model != null) { SalesBudgetModel viewModel = new SalesBudgetModel { Id = Convert.ToInt64(model.Id), SalesPersonId = Convert.ToInt64(model.SalesPersonId), SalesPersonName = SalesPersonName, DivisionName = divisionName, BudgetYear = model.BudgetYear, SBUId = Convert.ToInt64(model.SBUId), ProductId = Convert.ToInt64(model.ProductId), ddlSBU = sbuList, ddlProduct = productList }; return(PartialView("_Edit", viewModel)); } else { errorViewModel.ErrorMessage = CommonMessage.ErrorOccurred; return(PartialView("_ErrorPopUp", errorViewModel)); } } catch (Exception ex) { errorViewModel.ErrorMessage = CommonExceptionMessage.GetExceptionMessage(ex); return(PartialView("_ErrorPopUp", errorViewModel)); } }
public ActionResult Create() { var errorViewModel = new ErrorViewModel(); try { var sbuList = SelectListItemExtension.PopulateDropdownList(_SalesBudgetService.BMSUnit.SBURepository.GetAll().ToList <tblSBU>(), "Id", "SBUName").ToList(); var productList = SelectListItemExtension.PopulateDropdownList(_SalesBudgetService.BMSUnit.ProductRepository.GetAll().ToList <tblProduct>(), "Id", "ProductName").ToList(); var customerList = SelectListItemExtension.PopulateDropdownList(_SalesBudgetService.BMSUnit.CustomerRepository.GetAll().ToList <tblCustomer>(), "Id", "CustomerName").ToList(); var supplierList = SelectListItemExtension.PopulateDropdownList(_SalesBudgetService.BMSUnit.SupplierRepository.GetAll().ToList <tblSupplier>(), "Id", "SupplierName").ToList(); var SalePersonName = HttpContext.User.Identity.Name; var SalePersonId = _SalesBudgetService.BMSUnit.UserInfoNameRepository.GetAll().Where(c => c.UserName == SalePersonName).ToList().FirstOrDefault().Id; //var divisionName = var divCount = _SalesBudgetService.BMSUnit.SalesPersonRepository.GetAll().Where(c => c.SalesPersonId == SalePersonName).ToList().Count(); string divisionName = null; if (divCount > 0) { var divisionId = _SalesBudgetService.BMSUnit.SalesPersonRepository.GetAll().Where(c => c.SalesPersonId == SalePersonName).ToList().FirstOrDefault().DivisionId; divisionName = _SalesBudgetService.BMSUnit.DivisionRepository.GetAll().Where(c => c.Id == divisionId).ToList().FirstOrDefault().DivisionName; } var model = new SalesBudgetModel() { BudgetYear = DateTime.Now.Year.ToString(), SalesPersonId = Convert.ToInt64(SalePersonId), SalesPersonName = SalePersonName, DivisionName = divisionName, ddlSBU = sbuList, ddlProduct = productList }; return(PartialView("_Create", model)); } catch (Exception ex) { errorViewModel.ErrorMessage = CommonExceptionMessage.GetExceptionMessage(ex); return(PartialView("_ErrorPopUp", errorViewModel)); } }
public ActionResult Create(SalesBudgetModel viewModel) { var strMessage = string.Empty; try { if (Session["lstSampleRequestDetails"] != null) { if (ModelState.IsValid) { #region Current User var userName = HttpContext.User.Identity.Name; viewModel.IUser = userName; viewModel.IDate = DateTime.Now; viewModel.EDate = DateTime.Now; #endregion //List<SalesBudgetDetailViewModel> list = new List<SalesBudgetDetailViewModel>(); //if (Session["lstSampleRequestDetails"] != null) //{ // list = (List<SalesBudgetDetailViewModel>)Session["lstSampleRequestDetails"]; //} var entity = viewModel.ToEntity(); _SalesBudgetService.BMSUnit.SalesBudgetRepository.Add(entity); _SalesBudgetService.BMSUnit.SalesBudgetRepository.SaveChanges(); Session["SampleRequestMasterId"] = entity.Id; #region Save SampleRequest Detail //if (list != null && list.Count > 0) //{ // foreach (SampleRequestDetailModel detail in list) // { // detail.RequestId = Convert.ToInt64(entity.Id); // var detailEntity = detail.ToEntity(); // _SalesBudgetService.BMSUnit.SampleRequestDetailsRepository.Add(detailEntity); // _SalesBudgetService.BMSUnit.SampleRequestDetailsRepository.SaveChanges(); // } //} //Session["lstSampleRequestDetails"] = null; //#endregion //#region Save Sample Request Document //foreach (SampleDocumentModel doc in viewModel.sampleDocumentModels) //{ // if (doc.IsSelected == true) // { // SampleRequestDocumentModel aaa = new SampleRequestDocumentModel(); // aaa.RequestId = Convert.ToInt64(entity.Id); // aaa.DocumentId = doc.Id; // var detailDocumentEntity = aaa.ToEntity(); // _SalesBudgetService.BMSUnit.SampleRequestDocumentRepository.Add(detailDocumentEntity); // _SalesBudgetService.BMSUnit.SampleRequestDocumentRepository.SaveChanges(); // } //} #endregion return(Content(Boolean.TrueString)); } } strMessage = Common.GetModelStateErrorMessage(ModelState); } catch (Exception ex) { strMessage = CommonExceptionMessage.GetExceptionMessage(ex, CommonAction.Save); } return(Content(strMessage)); }
public JsonResult SetSalesBudgetForUpdate(List <SalesBudgetModel> lstSampleSubmissionMaster, List <SalesBudgetDetailViewModel> lstSampleSubmissionDetails, string UpdateId) { var strMessage = string.Empty; // Clear detail list //Session["lstSampleRequestDetails"] = null; try { if (ModelState.IsValid) { Int64 Id = Convert.ToInt64(UpdateId); var model = _SalesBudgetService.BMSUnit.SalesBudgetRepository.GetByID(Id); //var lst = _SalesBudgetService.BMSUnit.SalesBudgetRepository.GetAll().Where( // q => q.Id == model.Id); //foreach (var dt in lst) //{ // _SalesBudgetService.BMSUnit.SalesBudgetRepository.Delete_64Bit(Convert.ToInt64(dt.Id)); //} List <SalesBudgetModel> masterList = new List <SalesBudgetModel>(); foreach (var item in lstSampleSubmissionMaster) { SalesBudgetModel masterEntityModel = new SalesBudgetModel(); #region Current User var userName = HttpContext.User.Identity.Name; masterEntityModel.IUser = model.IUser; masterEntityModel.IDate = model.IDate; masterEntityModel.EUser = userName; masterEntityModel.EDate = DateTime.Now; #endregion masterEntityModel.SalesPersonId = item.SalesPersonId; masterEntityModel.BudgetYear = item.BudgetYear; masterEntityModel.ProductId = item.ProductId; masterEntityModel.SBUId = item.SBUId; masterEntityModel.Id = Id; //masterList.Add(masterEntityModel); var entity = masterEntityModel.ToEntity(); _SalesBudgetService.BMSUnit.SalesBudgetRepository.Update(entity); _SalesBudgetService.BMSUnit.SalesBudgetRepository.SaveChanges(); Session["SalesBudgetId"] = entity.Id; } var lst = _SalesBudgetService.BMSUnit.SalesBudgetDetailRepository.GetAll().Where( q => q.SalesBudgetId == Convert.ToInt64(Session["SalesBudgetId"])); foreach (var dt in lst) { _SalesBudgetService.BMSUnit.SalesBudgetDetailRepository.Delete_64Bit(Convert.ToInt64(dt.Id)); } // Add new detail information foreach (var item in lstSampleSubmissionDetails) { SalesBudgetDetail entityDetailModel = new SalesBudgetDetail(); entityDetailModel.SalesBudgetId = Convert.ToInt64(Convert.ToInt64(Session["SalesBudgetId"])); entityDetailModel.CustomerId = item.CustomerId; entityDetailModel.SupplierId = item.SupplierId; entityDetailModel.BudgetMonth = 1; entityDetailModel.Quantity = item.JanQty; entityDetailModel.Value = item.JanVal; entityDetailModel.Commission = item.JanCom; var detailEntityjan = entityDetailModel.ToEntity(); _SalesBudgetService.BMSUnit.SalesBudgetDetailRepository.Add(detailEntityjan); _SalesBudgetService.BMSUnit.SalesBudgetDetailRepository.SaveChanges(); entityDetailModel.SalesBudgetId = Convert.ToInt64(Convert.ToInt64(Session["SalesBudgetId"])); entityDetailModel.CustomerId = item.CustomerId; entityDetailModel.SupplierId = item.SupplierId; entityDetailModel.BudgetMonth = 2; entityDetailModel.Quantity = item.FebQty; entityDetailModel.Value = item.FebVal; entityDetailModel.Commission = item.FebCom; var detailEntityFeb = entityDetailModel.ToEntity(); _SalesBudgetService.BMSUnit.SalesBudgetDetailRepository.Add(detailEntityFeb); _SalesBudgetService.BMSUnit.SalesBudgetDetailRepository.SaveChanges(); entityDetailModel.SalesBudgetId = Convert.ToInt64(Convert.ToInt64(Session["SalesBudgetId"])); entityDetailModel.CustomerId = item.CustomerId; entityDetailModel.SupplierId = item.SupplierId; entityDetailModel.BudgetMonth = 3; entityDetailModel.Quantity = item.MarQty; entityDetailModel.Value = item.MarVal; entityDetailModel.Commission = item.MarCom; var detailEntityMarch = entityDetailModel.ToEntity(); _SalesBudgetService.BMSUnit.SalesBudgetDetailRepository.Add(detailEntityMarch); _SalesBudgetService.BMSUnit.SalesBudgetDetailRepository.SaveChanges(); entityDetailModel.SalesBudgetId = Convert.ToInt64(Convert.ToInt64(Session["SalesBudgetId"])); entityDetailModel.CustomerId = item.CustomerId; entityDetailModel.SupplierId = item.SupplierId; entityDetailModel.BudgetMonth = 4; entityDetailModel.Quantity = item.AprQty; entityDetailModel.Value = item.AprVal; entityDetailModel.Commission = item.AprCom; var detailEntityApril = entityDetailModel.ToEntity(); _SalesBudgetService.BMSUnit.SalesBudgetDetailRepository.Add(detailEntityApril); _SalesBudgetService.BMSUnit.SalesBudgetDetailRepository.SaveChanges(); entityDetailModel.SalesBudgetId = Convert.ToInt64(Convert.ToInt64(Session["SalesBudgetId"])); entityDetailModel.CustomerId = item.CustomerId; entityDetailModel.SupplierId = item.SupplierId; entityDetailModel.BudgetMonth = 5; entityDetailModel.Quantity = item.MayQty; entityDetailModel.Value = item.MayVal; entityDetailModel.Commission = item.MayCom; var detailEntityMay = entityDetailModel.ToEntity(); _SalesBudgetService.BMSUnit.SalesBudgetDetailRepository.Add(detailEntityMay); _SalesBudgetService.BMSUnit.SalesBudgetDetailRepository.SaveChanges(); entityDetailModel.SalesBudgetId = Convert.ToInt64(Convert.ToInt64(Session["SalesBudgetId"])); entityDetailModel.CustomerId = item.CustomerId; entityDetailModel.SupplierId = item.SupplierId; entityDetailModel.BudgetMonth = 6; entityDetailModel.Quantity = item.JunQty; entityDetailModel.Value = item.JunVal; entityDetailModel.Commission = item.JunCom; var detailEntityJun = entityDetailModel.ToEntity(); _SalesBudgetService.BMSUnit.SalesBudgetDetailRepository.Add(detailEntityJun); _SalesBudgetService.BMSUnit.SalesBudgetDetailRepository.SaveChanges(); entityDetailModel.SalesBudgetId = Convert.ToInt64(Convert.ToInt64(Session["SalesBudgetId"])); entityDetailModel.CustomerId = item.CustomerId; entityDetailModel.SupplierId = item.SupplierId; entityDetailModel.BudgetMonth = 7; entityDetailModel.Quantity = item.JulyQty; entityDetailModel.Value = item.JulyVal; entityDetailModel.Commission = item.JulyCom; var detailEntityJuly = entityDetailModel.ToEntity(); _SalesBudgetService.BMSUnit.SalesBudgetDetailRepository.Add(detailEntityJuly); _SalesBudgetService.BMSUnit.SalesBudgetDetailRepository.SaveChanges(); entityDetailModel.SalesBudgetId = Convert.ToInt64(Convert.ToInt64(Session["SalesBudgetId"])); entityDetailModel.CustomerId = item.CustomerId; entityDetailModel.SupplierId = item.SupplierId; entityDetailModel.BudgetMonth = 8; entityDetailModel.Quantity = item.AugQty; entityDetailModel.Value = item.AugVal; entityDetailModel.Commission = item.AugCom; var detailEntityAugest = entityDetailModel.ToEntity(); _SalesBudgetService.BMSUnit.SalesBudgetDetailRepository.Add(detailEntityAugest); _SalesBudgetService.BMSUnit.SalesBudgetDetailRepository.SaveChanges(); entityDetailModel.SalesBudgetId = Convert.ToInt64(Convert.ToInt64(Session["SalesBudgetId"])); entityDetailModel.CustomerId = item.CustomerId; entityDetailModel.SupplierId = item.SupplierId; entityDetailModel.BudgetMonth = 9; entityDetailModel.Quantity = item.SepQty; entityDetailModel.Value = item.SepVal; entityDetailModel.Commission = item.SepVal; var detailEntitySeptember = entityDetailModel.ToEntity(); _SalesBudgetService.BMSUnit.SalesBudgetDetailRepository.Add(detailEntitySeptember); _SalesBudgetService.BMSUnit.SalesBudgetDetailRepository.SaveChanges(); entityDetailModel.SalesBudgetId = Convert.ToInt64(Convert.ToInt64(Session["SalesBudgetId"])); entityDetailModel.CustomerId = item.CustomerId; entityDetailModel.SupplierId = item.SupplierId; entityDetailModel.BudgetMonth = 10; entityDetailModel.Quantity = item.OctQty; entityDetailModel.Value = item.OctVal; entityDetailModel.Commission = item.OctCom; var detailEntityOctober = entityDetailModel.ToEntity(); _SalesBudgetService.BMSUnit.SalesBudgetDetailRepository.Add(detailEntityOctober); _SalesBudgetService.BMSUnit.SalesBudgetDetailRepository.SaveChanges(); entityDetailModel.SalesBudgetId = Convert.ToInt64(Convert.ToInt64(Session["SalesBudgetId"])); entityDetailModel.CustomerId = item.CustomerId; entityDetailModel.SupplierId = item.SupplierId; entityDetailModel.BudgetMonth = 11; entityDetailModel.Quantity = item.NovQty; entityDetailModel.Value = item.NovVal; entityDetailModel.Commission = item.NovCom; var detailEntityNovember = entityDetailModel.ToEntity(); _SalesBudgetService.BMSUnit.SalesBudgetDetailRepository.Add(detailEntityNovember); _SalesBudgetService.BMSUnit.SalesBudgetDetailRepository.SaveChanges(); entityDetailModel.SalesBudgetId = Convert.ToInt64(Convert.ToInt64(Session["SalesBudgetId"])); entityDetailModel.CustomerId = item.CustomerId; entityDetailModel.SupplierId = item.SupplierId; entityDetailModel.BudgetMonth = 12; entityDetailModel.Quantity = item.DecQty; entityDetailModel.Value = item.DecVal; entityDetailModel.Commission = item.DecCom; var detailEntityDecember = entityDetailModel.ToEntity(); _SalesBudgetService.BMSUnit.SalesBudgetDetailRepository.Add(detailEntityDecember); _SalesBudgetService.BMSUnit.SalesBudgetDetailRepository.SaveChanges(); //list.Add(entityDetailModel); } } //Session["lstSampleRequestDetails"] = list; //return Json(_SampleRequestModel, JsonRequestBehavior.AllowGet); //strMessage = Boolean.TrueString; strMessage = "Information has been Updated successfully"; } catch (Exception ex) { strMessage = CommonExceptionMessage.GetExceptionMessage(ex, CommonAction.Save); } return(Json(new { strMessage = strMessage })); }
public static tblSalesBudget ToEntity(this SalesBudgetModel model) { return(Mapper.Map <SalesBudgetModel, tblSalesBudget>(model)); }