public ActionResult editServicedetails(tblservice serv) { ViewBag.dist = de.tbldistricts.ToList(); ViewBag.cit = de.tblcities.ToList(); ViewBag.vereg = de.tblvehicleregs.ToList(); tblservice rs = de.tblservices.Find(serv.serviceid); rs.regid = serv.regid; rs.renewdate = serv.renewdate; rs.details = serv.details; de.SaveChanges(); return(RedirectToAction("listService")); }
public HttpResponseMessage Post([FromBody] JObject service_details) { try { // Check if a session already exists or if it's expired //if (HttpContext.Current.Session["Token"] == null) // return Request.CreateResponse(HttpStatusCode.Unauthorized, new { Success = false, Message = "Session expired! Unable to authenticate user." }); string service_name = service_details["service_name"].ToString().Trim(); int salon_id = int.Parse(service_details["salon_id"].ToString()); Decimal price = Decimal.Parse(service_details["price"].ToString()); string duration = service_details["duration"].ToString().Trim(); using (SalonDbEntities entities = new SalonDbEntities()) { // Validate service - check if the service already exists in that particular salon bool selectedService = entities.tblservices.Any(e => e.service_name.ToUpper().Trim() == service_name.ToUpper().Trim() && e.salon_id == salon_id); // If a service already exists if (selectedService) { return(Messages.GetInstance().HandleRequest("Service", ActionType.INSERT, true)); } else { using (var transaction = entities.Database.BeginTransaction()) { tblservice obj = new tblservice { service_name = service_name, salon_id = salon_id, price = price, duration = Convert.ToInt32(TimeSpan.Parse(duration).TotalSeconds) }; entities.tblservices.Add(obj); entities.SaveChanges(); Utilities.getInstance().UpdateChanges(entities, transaction, obj.service_id.ToString(), typeof(tblservice).Name, ActionType.INSERT); return(Messages.GetInstance().HandleRequest("Service", ActionType.INSERT)); } } } } catch (Exception) { return(Messages.GetInstance().HandleException("An error occured! Failed to create service.")); } }
public ActionResult ServiceVehicleReg(tblservice tbls) { int model = de.tblservices.Where(a => a.regid == tbls.regid).Count(); if (model == 0) { ViewBag.dist = de.tbldistricts.ToList(); ViewBag.cit = de.tblcities.ToList(); ViewBag.vereg = de.tblvehicleregs.ToList(); int id = Convert.ToInt32(Session["logid"]); tbls.loginid = id; de.tblservices.Add(tbls); de.SaveChanges(); } else { TempData["dataalready"] = "Vehicle No has completed 1st service. To add more services, edit the particular vehicle id"; } return(RedirectToAction("ServiceVehicleReg")); }
public HttpResponseMessage GetSelectedService(int service_id) { try { // Check if a session already exists or if it's expired //if (HttpContext.Current.Session["Token"] == null) // return Request.CreateResponse(HttpStatusCode.Unauthorized, new { Success = false, Message = "Session expired! Unable to authenticate user." }); using (SalonDbEntities entities = new SalonDbEntities()) { tblservice selectedService = entities.tblservices.FirstOrDefault(e => e.service_id == service_id); if (selectedService != null) { return(Request.CreateResponse(HttpStatusCode.OK, new { Success = true, Message = "Service retrieved successfully!", Service_details = new { selectedService.service_id, selectedService.service_name, selectedService.salon_id, selectedService.price, selectedService.duration } })); } else { return(Messages.GetInstance().HandleException("Retrieve failed! Service with id = ", service_id.ToString())); } } } catch (Exception) { return(Messages.GetInstance().HandleException("An error occured! Failed to retrieve service details.")); } }