public static DataSet saveRouteStatus([FromBody] rideStatus rideStatus)
{
try
{
string ConnectionString = Common.GetConnectionString();
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(new SqlParameter("@routeId", rideStatus.routeId));
parameters.Add(new SqlParameter("@userId", rideStatus.userId));
parameters.Add(new SqlParameter("@status", rideStatus.status));
using (DataSet ds = SqlHelper.ExecuteDataset(ConnectionString, CommandType.StoredProcedure, "spsaveRouteStatus", parameters.ToArray()))
{
return(ds);
}
}
catch (Exception e)
{
throw e;
}
}
public IActionResult saveRouteStatus(rideStatus rideStatus)
{
try
{
if (rideStatus.routeId < 0 || rideStatus.routeId == null)
{
return(StatusCode((int)HttpStatusCode.BadRequest, new { ErrorMessage = "Please enter routeId" }));
}
else if (rideStatus.userId < 0 || rideStatus.userId == null)
{
return(StatusCode((int)HttpStatusCode.BadRequest, new { ErrorMessage = "Please enter userId" }));
}
DataSet ds = Data.Route.saveRouteStatus(rideStatus);
string Response = ds.Tables[0].Rows[0][0].ToString();
if (Response == "Success" & rideStatus.status == "Start")
{
string rideStatusId = ds.Tables[1].Rows[0]["rideStatusId"].ToString();
return(StatusCode((int)HttpStatusCode.OK, new { rideStatusId, message = "RouteStatus Successfully Created" }));
}
else if (Response == "Success" & rideStatus.status == null | rideStatus.status == "")
{
return(StatusCode((int)HttpStatusCode.OK, new { message = "RouteStatus Successfully Updated" }));
}
else
{
if (Response.Contains("FK__tblRideSt__route__02084FDA") == true)
{
return(StatusCode((int)HttpStatusCode.InternalServerError, new { ErrorMessage = "Invalid routeId" }));
}
else if (Response.Contains("FK__tblRideSt__userI__02FC7413") == true)
{
return(StatusCode((int)HttpStatusCode.Forbidden, new { ErrorMessage = "Invalid userId" }));
}
else
{
return(StatusCode((int)HttpStatusCode.Forbidden, new { ErrorMessage = Response }));
}
}
}
catch (Exception e)
{
string SaveErrorLog = Data.Common.SaveErrorLog("saveRouteStatus", e.Message);
if (e.Message.Contains("FK__tblRideSt__route__02084FDA") == true)
{
return(StatusCode((int)HttpStatusCode.InternalServerError, new { ErrorMessage = "Invalid routeId" }));
}
else if (e.Message.Contains("FK__tblRideSt__userI__02FC7413") == true)
{
return(StatusCode((int)HttpStatusCode.InternalServerError, new { ErrorMessage = "Invalid userId" }));
}
else
{
return(StatusCode((int)HttpStatusCode.InternalServerError, new { ErrorMessage = e.Message }));
}
}
}
