public Trip_Satus_Info View_Status(int id)
{
con.Open();
SqlCommand cmd = new SqlCommand("View_Status", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter p = new SqlParameter();
p = cmd.Parameters.Add("@trip_status_id", SqlDbType.Int);
p.Value = id;
SqlDataReader read = cmd.ExecuteReader();
Trip_Satus_Info t_info = new Trip_Satus_Info();
read.Read();
if (read.HasRows)
{
t_info.Brt_Id = int.Parse(read["brt_id"].ToString());
t_info.Date = DateTime.Parse(read["date"].ToString());
t_info.Trip_Status = read["trip_status"].ToString();
}
read.Close();
con.Close();
return(t_info);
}
public void Add_Status(Trip_Satus_Info info)
{
con.Open();
SqlCommand cmd = new SqlCommand("Add_Status", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter p = new SqlParameter();
p = cmd.Parameters.Add("@brt_id", SqlDbType.Int);
p.Value = info.Brt_Id;
p = cmd.Parameters.Add("@date", SqlDbType.DateTime);
p.Value = info.Date;
p = cmd.Parameters.Add("@trip_status", SqlDbType.VarChar);
p.Value = info.Trip_Status;
cmd.ExecuteNonQuery();
con.Close();
}
