public IActionResult updateRoute([FromBody] createRoute updateRoute) { try { if (updateRoute.routeId <= 0) { return(StatusCode((int)HttpStatusCode.BadRequest, new { ErrorMessage = "Please enter routeId" })); } DataTable dt = Data.Route.updateRoute(updateRoute); string Response = dt.Rows[0][0].ToString(); if (Response == "Success") { return(StatusCode((int)HttpStatusCode.OK, "Updated Successfully")); } else { return(StatusCode((int)HttpStatusCode.Forbidden, new { ErrorMessage = Response })); } } catch (Exception e) { string SaveErrorLog = Data.Common.SaveErrorLog("updateRoute", e.Message); return(StatusCode((int)HttpStatusCode.InternalServerError, new { ErrorMessage = e.Message })); } }
public IActionResult createRoute(createRoute createRoute) { try { if (createRoute.routeName == "" || createRoute.routeName == null) { return(StatusCode((int)HttpStatusCode.BadRequest, new { ErrorMessage = "Please enter routeName" })); } else if (createRoute.designatedCharityId < 0 || createRoute.designatedCharityId == null) { return(StatusCode((int)HttpStatusCode.BadRequest, new { ErrorMessage = "Please enter userId" })); } DataSet ds = Data.Route.createRoute(createRoute); string Response = ds.Tables[0].Rows[0]["SuccessMessage"].ToString(); if (Response == "Success") { string routeId = ds.Tables[1].Rows[0]["routeId"].ToString(); return(StatusCode((int)HttpStatusCode.OK, new { routeId, message = "Route Created successfully" })); } else { return(StatusCode((int)HttpStatusCode.Forbidden, new { ErrorMessage = Response })); } } catch (Exception e) { string SaveErrorLog = Data.Common.SaveErrorLog("createRoute", e.Message); return(StatusCode((int)HttpStatusCode.InternalServerError, new { ErrorMessage = e.Message })); } }
public static DataSet createRoute([FromBody] createRoute createRoute) { try { string ConnectionString = Common.GetConnectionString(); List <SqlParameter> parameters = new List <SqlParameter>(); parameters.Add(new SqlParameter("@routeName", createRoute.routeName)); parameters.Add(new SqlParameter("@comments", createRoute.comments)); parameters.Add(new SqlParameter("@userId", createRoute.designatedCharityId)); parameters.Add(new SqlParameter("@isPrivate", createRoute.isPrivate)); using (DataSet ds = SqlHelper.ExecuteDataset(ConnectionString, CommandType.StoredProcedure, "spcreateRoute", parameters.ToArray())) { return(ds); } } catch (Exception e) { throw e; } }
public static DataTable updateRoute([FromBody] createRoute updateRoute) { try { string ConnectionString = Common.GetConnectionString(); List <SqlParameter> parameters = new List <SqlParameter>(); parameters.Add(new SqlParameter("@routeId", updateRoute.routeId)); parameters.Add(new SqlParameter("@routeName", updateRoute.routeName)); parameters.Add(new SqlParameter("@comments", updateRoute.comments)); parameters.Add(new SqlParameter("@designatedCharityId", updateRoute.designatedCharityId)); parameters.Add(new SqlParameter("@startingPoint", updateRoute.startingPoint)); parameters.Add(new SqlParameter("@endPoint", updateRoute.endPoint)); parameters.Add(new SqlParameter("@isPrivate", updateRoute.isPrivate)); using (DataTable dt = SqlHelper.ExecuteDataset(ConnectionString, CommandType.StoredProcedure, "spupdateRoute", parameters.ToArray()).Tables[0]) { return(dt); } } catch (Exception e) { throw e; } }