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