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(); }