public IHttpActionResult GetRouteInfo(string selectedRoute) { //string s = ""; RouteMasterModel route = new RouteMasterModel(); try { SqlConnection con; SqlCommand cmdselect; SqlDataReader dtrdrive; con = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["Servosms"]); con.Open(); cmdselect = new SqlCommand("Select Route_name,Route_km From Route where Route_name=@Route_name", con); cmdselect.Parameters.AddWithValue("@Route_name", selectedRoute.ToString().Trim()); dtrdrive = cmdselect.ExecuteReader(); while (dtrdrive.Read()) { route.Route_Name = dtrdrive.GetString(0); route.Route_Km = dtrdrive.GetString(1); } dtrdrive.Close(); con.Close(); if (route == null) { return(Content(HttpStatusCode.NotFound, "Route data Not found.")); } return(Ok(route)); } catch (Exception ex) { return(Content(HttpStatusCode.NotFound, "Route data Not found.")); } }
public IHttpActionResult UpdateRoute(RouteMasterModel route) { try { SqlConnection con2; string strUpdate; SqlCommand cmdselect2; SqlDataReader dtredit2; con2 = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["Servosms"]); con2.Open(); strUpdate = "Update Route set Route_name=@Route_name,Route_km=@Route_km where Route_name=@Route2"; cmdselect2 = new SqlCommand(strUpdate, con2); if (route.Route_Name == "") { cmdselect2.Parameters.AddWithValue("@Route_name", ""); } else { cmdselect2.Parameters.AddWithValue("@Route_name", route.Route_Name.Trim()); } if (route.Route_Km == "") { cmdselect2.Parameters.AddWithValue("@Route_km", ""); } else { cmdselect2.Parameters.AddWithValue("@Route_km", route.Route_Km.Trim()); } if (route.Index_Route_Name == "0") { cmdselect2.Parameters.AddWithValue("@Route2", ""); } else { cmdselect2.Parameters.AddWithValue("@Route2", route.Selected_Route_Name.ToString()); } dtredit2 = cmdselect2.ExecuteReader(); return(Ok(true)); } catch (Exception ex) { return(Content(HttpStatusCode.NotFound, "Route could not update.")); } }
public IHttpActionResult InsertRoute(RouteMasterModel route) { try { SqlConnection con4; string strInsert4; SqlCommand cmdInsert4; con4 = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["Servosms"]); con4.Open(); strInsert4 = "Insert Route(Route_name,Route_km)values (@Route_name,@Route_km)"; cmdInsert4 = new SqlCommand(strInsert4, con4); cmdInsert4.Parameters.AddWithValue("@Route_name", route.Route_Name.Trim()); cmdInsert4.Parameters.AddWithValue("@Route_km", route.Route_Km.Trim()); cmdInsert4.ExecuteNonQuery(); con4.Close(); return(Ok(true)); } catch (Exception ex) { return(Content(HttpStatusCode.NotFound, "Route could not update.")); } }