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