public ActionResult OrderHistoryDetails(int id) { List <OrderHistory_ViewModel> ohvmlist = new List <OrderHistory_ViewModel>(); var obj = db.OrderDetail_Table.Where(x => x.Orderid == id).ToList(); Service_Table s = new Service_Table(); User_Table uobj = new User_Table(); foreach (var item in obj) { var service = db.OrderDetail_Table.Where(x => x.Orderid == id).Select(x => x.Serviceid).FirstOrDefault(); // var servicename = db.Service_Table.Where(x => x.ServiceId == service).Select(x => x.ServiceName).FirstOrDefault(); s = db.Service_Table.Where(x => x.ServiceId == service).FirstOrDefault(); uobj = db.User_Table.Where(x => x.UserId == s.ServiceProviderid).FirstOrDefault(); var product_desc = db.Product_Table.Where(x => x.ProductId == item.Productid).Select(x => x.ProductDesc).FirstOrDefault(); var product = db.Product_Table.Where(x => x.ProductId == item.Productid).Select(x => x.ProductName).FirstOrDefault(); var deliveryadd = db.Order_Table.Where(x => x.OrderId == id).Select(x => x.OrderDeliveryAddress).FirstOrDefault(); var deliverydate = db.Order_Table.Where(x => x.OrderId == id).Select(x => x.OrderDeliveryDate).FirstOrDefault(); var image = db.Image_Table.Where(x => x.Productid == item.Productid).Select(x => x.BinaryImage).FirstOrDefault(); OrderHistory_ViewModel obj1 = new OrderHistory_ViewModel(); obj1.ProductName = product; obj1.ProductDesc = product_desc; obj1.OrderDelivryAddress = deliveryadd; obj1.Amount = (decimal)item.Amount; obj1.OrderDeliveryDate = (DateTime)deliverydate; obj1.ServiceName = uobj.UserName; obj1.BinaryImage = image; ohvmlist.Add(obj1); } return(View(ohvmlist)); }
public ActionResult ServiceDelete(int serviceId) { Service_Table service = db.Service_Table.Find(serviceId); service.ServiceIsDeleted = true; service.ServiceUpdatedBy = Session["user"].ToString(); service.ServiceUpdatedDate = System.DateTime.Now; db.SaveChanges(); bool result = true; var redirectUrl = new UrlHelper(Request.RequestContext).Action("Manage_Service", "Service"); return(Json(new { Url = redirectUrl, result })); }
public ActionResult service_name_all(string id) { Session["location"] = id; List <SelectListItem> ServiceList = new List <SelectListItem>(); List <Service_Table> s = new List <Service_Table>(); int locId = Convert.ToInt32(id); // var ser = db.Service_Table.Where(x => x.Locationid == locId).Select(x => x.ServiceProviderid).ToList(); var ser = db.Service_Table.Where(x => x.Locationid == locId).ToList(); int previd = 0; foreach (var items in ser) { if (previd != items.ServiceProviderid) { Service_Table excuseme = db.Service_Table.Where(x => x.ServiceProviderid == items.ServiceProviderid).FirstOrDefault(); previd = excuseme.ServiceProviderid; s.Add(excuseme); } } int total_pro = Convert.ToInt32(TempData["count"]); List <int> availid = TempData["avail"] as List <int>; foreach (var item1 in s) { int count = 0; foreach (var item in availid) { int pid = Convert.ToInt32(item); Service_Table obj = db.Service_Table.Where(x => x.Productid == pid & x.ServiceProviderid == item1.ServiceProviderid).FirstOrDefault(); if (obj != null) { count++; } } if (count == total_pro) { string sname = db.Service_Table.Where(x => x.ServiceProviderid == item1.ServiceProviderid).Select(x => x.ServiceName).FirstOrDefault(); User_Table uobj = db.User_Table.Where(x => x.UserId == item1.ServiceProviderid).FirstOrDefault(); ServiceList.Add(new SelectListItem { Text = uobj.UserName, Value = uobj.UserId.ToString(), }); } } return(Json(ServiceList, JsonRequestBehavior.AllowGet)); }
public ActionResult purchase_all(Book obj) { string name = Session["user"].ToString(); int usid = db.User_Table.Where(x => x.UserName == name).Select(x => x.UserId).FirstOrDefault(); Order_Table order = db.Order_Table.Where(x => x.OrderStatus == 0 & x.OrderIsDeleted == false & x.Userid == usid).FirstOrDefault(); order.OrderDeliveryAddress = obj.OrderDelivryAddress; order.TotalAmount = Convert.ToInt32(TempData["tcart_amt"]); order.OrderNotification = "00"; order.OrderDeliveryDate = System.DateTime.Now.AddDays(5); order.OrderStatus = 1; db.SaveChanges(); var odetail = db.OrderDetail_Table.Where(x => x.Orderid == order.OrderId).Select(x => x.OrderDetailId).ToList(); foreach (var item in odetail) { int flag = 0; List <int> availid1 = TempData["avail1"] as List <int>; OrderDetail_Table obj1 = db.OrderDetail_Table.Where(x => x.OrderDetailId == item).FirstOrDefault(); foreach (var pro in availid1) { if (obj1.Productid == pro) { Product_Table pobj = db.Product_Table.Where(x => x.ProductId == pro).FirstOrDefault(); int stock = Convert.ToInt32(pobj.ProductStock); int qty = Convert.ToInt32(obj1.Quantity); pobj.ProductStock = stock - qty; db.SaveChanges(); flag = 1; } } if (flag == 1) { int lid = Convert.ToInt32(Session["location"]); Service_Table serboj = db.Service_Table.Where(x => x.ServiceProviderid == obj.UserId && x.Locationid == lid).FirstOrDefault(); obj1.Serviceid = serboj.ServiceId; db.SaveChanges(); } else { db.OrderDetail_Table.Remove(obj1); db.SaveChanges(); } } count_cart(); Session["location"] = null; return(RedirectToAction("notification")); }
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")); } }
public ActionResult order(Book obj, string amt) { string name = Session["user"].ToString(); int pid = Convert.ToInt32(Session["pro_id"].ToString()); int stock = db.Product_Table.Where(x => x.ProductId == pid).Select(x => x.ProductStock).FirstOrDefault(); if (obj.Quantity <= stock) { Order_Table order = new Order_Table(); OrderDetail_Table order_detail = new OrderDetail_Table(); order.TotalAmount = Convert.ToInt32(amt); order.OrderDeliveryAddress = obj.OrderDelivryAddress; order.OrderDeliveryDate = System.DateTime.Now.AddDays(5); order.Userid = db.User_Table.Where(x => x.UserName == name).Select(x => x.UserId).FirstOrDefault(); order.OrderCreatedBy = name; order.OrderUpdatedBy = name; order.OrderCreatedDate = System.DateTime.Now; order.OrderUpdatedDate = System.DateTime.Now; order.OrderIsDeleted = false; order.OrderStatus = 1; order.OrderNotification = "00"; db.Order_Table.Add(order); db.SaveChanges(); int oid = order.OrderId; order_detail.Orderid = oid; order_detail.Productid = pid; int lid = Convert.ToInt32(Session["location"]); Service_Table serboj = db.Service_Table.Where(x => x.ServiceProviderid == obj.UserId && x.Locationid == lid).FirstOrDefault(); order_detail.Serviceid = serboj.ServiceId; order_detail.Quantity = obj.Quantity; order_detail.Amount = Convert.ToInt32(amt); db.OrderDetail_Table.Add(order_detail); db.SaveChanges(); Product_Table pobj = db.Product_Table.Where(x => x.ProductId == pid).FirstOrDefault(); pobj.ProductStock = stock - obj.Quantity; db.SaveChanges(); } Session["location"] = null; return(RedirectToAction("notification")); }
public JsonResult ServiceEdit(int ServiceId, string ServiceName, decimal DeliveryCharge, string ServiceDesc, string LocationName, string ProductName) { Product_Table product = new Product_Table(); Location_Table location = new Location_Table(); Service_Table service = db.Service_Table.Find(ServiceId); service.ServiceName = ServiceName; service.DeliveryCharge = DeliveryCharge; service.ServiceDesc = ServiceDesc; int locationId = (from l in db.Location_Table where l.LocationName == LocationName select l.LocationId).FirstOrDefault(); service.Locationid = locationId; int productId = (from p in db.Product_Table where p.ProductName == ProductName select p.ProductId).FirstOrDefault(); service.Productid = productId; service.ServiceUpdatedBy = Session["user"].ToString(); service.ServiceUpdatedDate = System.DateTime.Now; db.SaveChanges(); var redirectUrl = new UrlHelper(Request.RequestContext).Action("Manage_Service", "Service"); return(Json(new { ServiceId = ServiceId, ServiceName = ServiceName, DeliveryCharge = DeliveryCharge, ServiceDesc = ServiceDesc, LocationName = LocationName, ProductName = ProductName, Url = redirectUrl }, JsonRequestBehavior.AllowGet)); }