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