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."));
}
}
