public JsonResult AddStandingTeeTime(BookStandingTeeTimeReservationVM objBoookstanding) { string message = string.Empty; bool status = false; try { if (objBoookstanding != null) { string[] reserve = objBoookstanding.RequestedTime.Split(','); int hours = int.Parse(reserve[0]); int minutes = int.Parse(reserve[1]); if (reserve[2] == "PM" && hours != 12) { hours += 12; } var timeTee = hours.ToString() + ":" + minutes.ToString(); objBoookstanding.RequestedTime = timeTee; var response = new ReservationRepository().AddStandingReservation(objBoookstanding); if (response) { status = response; message = "Successfully added"; return(Json(new { status = status, message = message }, JsonRequestBehavior.AllowGet)); } } } catch (Exception ex) { status = false; message = ex.Message.ToString(); return(Json(new { status = status, message = message }, JsonRequestBehavior.AllowGet)); } return(Json(new { status = status, message = message }, JsonRequestBehavior.AllowGet)); }
public bool AddStandingReservation(BookStandingTeeTimeReservationVM obj) { bool success = true; SqlConnection MadhuriKathiriaClubBAIST = new SqlConnection(); MadhuriKathiriaClubBAIST.ConnectionString = ConfigurationManager.ConnectionStrings["MadhuriKathiriaClubBAIST"].ConnectionString; MadhuriKathiriaClubBAIST.Open(); SqlCommand command = new SqlCommand(); command.CommandText = "AddStandingReservation"; command.CommandType = CommandType.StoredProcedure; command.Connection = MadhuriKathiriaClubBAIST; SqlParameter parameter = new SqlParameter(); parameter.SqlDbType = SqlDbType.Date; parameter.Value = ValueOrNull(obj.StartDate.Date); parameter.ParameterName = "@StartDate"; command.Parameters.Add(parameter); parameter = new SqlParameter(); parameter.SqlDbType = SqlDbType.Date; parameter.Value = ValueOrNull(obj.EndDate.Date); parameter.ParameterName = "@EndDate"; command.Parameters.Add(parameter); parameter = new SqlParameter(); parameter.SqlDbType = SqlDbType.Time; TimeSpan time = TimeSpan.Parse(obj.RequestedTime); parameter.Value = time; parameter.ParameterName = "@RequestedTime"; command.Parameters.Add(parameter); parameter = new SqlParameter(); parameter.SqlDbType = SqlDbType.NVarChar; parameter.Value = ValueOrNull(obj.DayOfWeek); parameter.ParameterName = "@DayOfWeek"; command.Parameters.Add(parameter); parameter = new SqlParameter(); parameter.SqlDbType = SqlDbType.Int; parameter.Value = ValueOrNull(obj.MemberNumber1); parameter.ParameterName = "@MemberNumber1"; command.Parameters.Add(parameter); parameter = new SqlParameter(); parameter.SqlDbType = SqlDbType.Int; parameter.Value = ValueOrNull(obj.MemberNumber2); parameter.ParameterName = "@MemberNumber2"; command.Parameters.Add(parameter); parameter = new SqlParameter(); parameter.SqlDbType = SqlDbType.Int; parameter.Value = ValueOrNull(obj.MemberNumber3); parameter.ParameterName = "@MemberNumber3"; command.Parameters.Add(parameter); parameter = new SqlParameter(); parameter.SqlDbType = SqlDbType.NVarChar; parameter.Value = ValueOrNull(obj.MemberName1); parameter.ParameterName = "@MemberName1"; command.Parameters.Add(parameter); parameter = new SqlParameter(); parameter.SqlDbType = SqlDbType.NVarChar; parameter.Value = ValueOrNull(obj.MemberName2); parameter.ParameterName = "@MemberName2"; command.Parameters.Add(parameter); parameter = new SqlParameter(); parameter.SqlDbType = SqlDbType.NVarChar; parameter.Value = ValueOrNull(obj.MemberName3); parameter.ParameterName = "@MemberName3"; command.Parameters.Add(parameter); try { command.ExecuteNonQuery(); MadhuriKathiriaClubBAIST.Close(); } catch (Exception ex) { success = false; MadhuriKathiriaClubBAIST.Close(); } return(success); }