public ActionResult Add_Service() { Notification_Count(); Service_ViewModel svm_obj = new Service_ViewModel(); List <BaseCategory_Table> baseCategoryList = new List <BaseCategory_Table>(); var productListItem = new List <SelectListItem>(); baseCategoryList = db.BaseCategory_Table.Where(x => x.BaseCatIsDeleted == false).ToList(); foreach (var item in baseCategoryList) { productListItem.Add(new SelectListItem { Text = item.BaseCatName.ToString(), Value = item.BaseCatId.ToString(), }); ViewBag.BaseCategory = productListItem; } svm_obj.locationList = db.Location_Table.Where(x => x.LocationIsDeleted == false).ToList(); svm_obj.selectedLocation = 0; ViewBag.message = TempData["Message"]; return(View(svm_obj)); }
public ActionResult Add_Service(Service_ViewModel model, string[] productIds) { try { Notification_Count(); string name = Session["user"].ToString(); int serviceProviderId = db.User_Table.Where(x => x.UserName == name).Select(x => x.UserId).FirstOrDefault(); List <Order_Table> orderList = new List <Order_Table>(); for (int i = 0; i < productIds.Count(); i++) { int currentProduct = Convert.ToInt32(productIds[i]); var product = (from s in db.Service_Table where s.Productid == currentProduct && s.Locationid == model.selectedLocation && s.ServiceProviderid == serviceProviderId && s.ServiceIsDeleted == false select s).FirstOrDefault(); if (product == null) { Service_Table service = new Service_Table(); service.Locationid = model.selectedLocation; service.DeliveryCharge = model.deliveryCharge; service.ServiceDesc = model.serviceDescription; service.Productid = Convert.ToInt32(productIds[i]); service.ServiceName = model.serviceName; service.ServiceProviderid = serviceProviderId; service.ServiceCreatedDate = System.DateTime.Now; service.ServiceUpdatedDate = System.DateTime.Now; service.ServiceCreatedBy = Session["user"].ToString(); service.ServiceUpdatedBy = Session["user"].ToString(); service.ServiceIsDeleted = false; db.Service_Table.Add(service); db.SaveChanges(); } else { var productName = (from p in db.Product_Table where p.ProductId == currentProduct select p.ProductName).FirstOrDefault(); string message = String.Format("Same location already added for the product " + productName); TempData["Message"] = message; return(RedirectToAction("Add_Service")); } } TempData["Message"] = "Service Added"; return(RedirectToAction("Add_Service")); } catch (Exception e) { TempData["Message"] = "fill all fileds"; return(RedirectToAction("Add_Service")); } }