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);
}
