Exemplo n.º 1
0
        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"));
        }
Exemplo n.º 2
0
        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."));
            }
        }
Exemplo n.º 3
0
        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"));
        }
Exemplo n.º 4
0
        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."));
            }
        }