public speed_tabe_info ViewSpeed_Category(string trip_category)
{
con.Open();
SqlCommand cmd = new SqlCommand("ViewSpeed_Category", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter p = new SqlParameter();
p = cmd.Parameters.Add("@trip_category", SqlDbType.VarChar);
p.Value = trip_category;
SqlDataReader read = cmd.ExecuteReader();
speed_tabe_info info = new speed_tabe_info();
if (read.Read())
{
info.Speed = float.Parse(read["speed"].ToString());
info.Trip_Category = read["trip_category"].ToString();
}
else
{
info.Speed = 1000.1000F;
}
read.Close();
con.Close();
return(info);
}
public void UpdateSpeed(speed_tabe_info info)
{
con.Open();
SqlCommand cmd = new SqlCommand("Update_speed", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter p = new SqlParameter();
p = cmd.Parameters.Add("@trip_category", SqlDbType.VarChar);
p.Value = info.Trip_Category;
p = cmd.Parameters.Add("@speed", SqlDbType.Float);
p.Value = info.Speed;
cmd.ExecuteNonQuery();
con.Close();
}
