public IActionResult saveRoutePointStatus(routePointStatus routePointStatus)
{
try
{
if (routePointStatus.routePointId < 0 || routePointStatus.routePointId == null)
{
return(StatusCode((int)HttpStatusCode.BadRequest, new { ErrorMessage = "Please enter routePointId" }));
}
else if (routePointStatus.userId < 0 || routePointStatus.userId == null)
{
return(StatusCode((int)HttpStatusCode.BadRequest, new { ErrorMessage = "Please enter userId" }));
}
DataTable dt = Data.Route.saveRoutePointStatus(routePointStatus);
string Response = dt.Rows[0][0].ToString();
if (Response == "Success")
{
return(StatusCode((int)HttpStatusCode.OK, "RoutePointStatus Successfully Created"));
}
else
{
if (Response.Contains("FK__tblRouteP__displ__787EE5A0") == true)
{
return(StatusCode((int)HttpStatusCode.InternalServerError, new { ErrorMessage = "Invalid displayId" }));
}
else if (Response.Contains("FK__tblRouteP__route__778AC167") == true)
{
return(StatusCode((int)HttpStatusCode.Forbidden, new { ErrorMessage = "Invalid routeId" }));
}
else
{
return(StatusCode((int)HttpStatusCode.Forbidden, new { ErrorMessage = Response }));
}
}
}
catch (Exception e)
{
string SaveErrorLog = Data.Common.SaveErrorLog("saveRoutePointStatus", e.Message);
if (e.Message.Contains("FK__tblRouteP__displ__787EE5A0") == true)
{
return(StatusCode((int)HttpStatusCode.InternalServerError, new { ErrorMessage = "Invalid displayId" }));
}
else if (e.Message.Contains("FK__tblRouteP__route__778AC167") == true)
{
return(StatusCode((int)HttpStatusCode.InternalServerError, new { ErrorMessage = "Invalid routeId" }));
}
else
{
return(StatusCode((int)HttpStatusCode.InternalServerError, new { ErrorMessage = e.Message }));
}
}
}
public static DataTable saveRoutePointStatus([FromBody] routePointStatus routePointStatus)
{
try
{
string ConnectionString = Common.GetConnectionString();
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(new SqlParameter("@routePointId", routePointStatus.routePointId));
parameters.Add(new SqlParameter("@userId", routePointStatus.userId));
using (DataTable dt = SqlHelper.ExecuteDataset(ConnectionString, CommandType.StoredProcedure, "spsaveRoutePointStatus", parameters.ToArray()).Tables[0])
{
return(dt);
}
}
catch (Exception e)
{
throw e;
}
}
