public HttpResponseMessage Get(int salon_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()) { tblsalon selectedSalon = entities.tblsalons.FirstOrDefault(e => e.salon_id == salon_id); if (selectedSalon != null) { return(Request.CreateResponse(HttpStatusCode.OK, new { Success = true, Message = "Salon retrieved successfully!", Salon_details = new { selectedSalon.salon_id, selectedSalon.salon_name, selectedSalon.owner_id, owner_name = entities.tblshop_owner.Where(x => x.owner_id == selectedSalon.owner_id).Select(x => x.name).First(), selectedSalon.salon_location, selectedSalon.contact_no, selectedSalon.email, selectedSalon.seating_capacity, selectedSalon.opening_time, selectedSalon.closing_time } })); } else { return(Messages.GetInstance().HandleException("Retrieve failed! Salon with id = ", salon_id.ToString())); } } } catch (Exception) { return(Messages.GetInstance().HandleException("An error occured! Failed to retrieve salon details.")); } }
public HttpResponseMessage Post([FromBody] JObject salon_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." }); int owner_id = int.Parse(salon_details["owner_id"].ToString()); string name = salon_details["name"].ToString(); string location = salon_details["location"].ToString(); string contact_no = salon_details["contact_no"].ToString().Trim(); string email = salon_details["email"].ToString(); int no_of_seats = int.Parse(salon_details["no_of_seats"].ToString()); string opening_time = salon_details["opening_time"].ToString(); string closing_time = salon_details["closing_time"].ToString(); using (SalonDbEntities entities = new SalonDbEntities()) { // Validate salon - check if the salon already exists bool selectedSalon = entities.tblsalons.Any(e => e.contact_no.ToString().Trim() == contact_no || e.email.ToUpper().Trim() == email.ToUpper().Trim()); // If a salon already exists if (selectedSalon) { return(Messages.GetInstance().HandleRequest("Salon", ActionType.INSERT, true)); } else { // Validates the contact no if (!Utilities.getInstance().ValidateContactNumber(contact_no)) { return(Messages.GetInstance().ValidateFields("Salon", ActionType.INSERT, isContactNumber: true)); } // Validates the email if (email != null && !Utilities.getInstance().ValidateEmail(email)) { return(Messages.GetInstance().ValidateFields("Salon", ActionType.INSERT, isEmail: true)); } // Validates the no of seats if (no_of_seats <= 0) { return(Messages.GetInstance().HandleException("Failed to create salon! No of seats should be > 0.")); } using (var transaction = entities.Database.BeginTransaction()) { tblsalon obj = new tblsalon { owner_id = owner_id, salon_name = name.Trim(), salon_location = location.Trim(), contact_no = int.Parse(contact_no), email = email.Trim(), seating_capacity = no_of_seats, opening_time = DateTime.Parse(opening_time, System.Globalization.CultureInfo.CurrentCulture).TimeOfDay, closing_time = DateTime.Parse(closing_time, System.Globalization.CultureInfo.CurrentCulture).TimeOfDay }; entities.tblsalons.Add(obj); entities.SaveChanges(); Utilities.getInstance().UpdateChanges(entities, transaction, obj.salon_id.ToString(), typeof(tblsalon).Name, ActionType.INSERT); return(Messages.GetInstance().HandleRequest("Salon", ActionType.INSERT)); } } } } catch (Exception) { return(Messages.GetInstance().HandleException("An error occured! Failed to create salon.")); } }