void getTenTram()
{
BUS_Tram bus = new BUS_Tram();
DTO_TramTrungGian dto_ttg = new DTO_TramTrungGian();
DataTable dt = new DataTable();
dt = bus.listTram();
foreach (DataRow r in dt.Rows)
{
cbTenTram.Items.Add(r["TenTram"]);
cbTramIdTram.Items.Add(r["ID_Tram"]);
}
}
public bool InsertTramTG(DTO_TramTrungGian tramTG)
{
SqlConnection conn = DBConnect.Connect();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "InsertTramTrungGian";
SqlParameter prm1 = new SqlParameter("@id_Tuyen", tramTG.TuyenIDTuyen);
SqlParameter prm2 = new SqlParameter("@id_Tram", tramTG.TramIDTram);
cmd.Parameters.Add(prm1);
cmd.Parameters.Add(prm2);
int row = cmd.ExecuteNonQuery();
DBConnect.Close(conn);
if (row > 0)
{
return(true);
}
return(false);
}
public bool InsertTramTG(DTO_TramTrungGian ttg)
{
return(dal_ttg.InsertTramTG(ttg));
}
