public void InsertChuyen(DTO_Chuyen c)
{
DAL dal = new DAL();
dal.Connect();
dal.ExecuteNonQuery(CommandType.StoredProcedure, "insertChuyen",
new SqlParameter {
ParameterName = "ID_Chuyen", Value = c.ID_Chuyen
},
new SqlParameter {
ParameterName = "Tuyen", Value = c.Tuyen_ID_Tuyen
},
new SqlParameter {
ParameterName = "GKH", Value = c.Gio_khoi_hanh
},
new SqlParameter {
ParameterName = "Ghichu", Value = c.Ghi_chu
},
new SqlParameter {
ParameterName = "Xe", Value = c.Xe_XeID
},
new SqlParameter {
ParameterName = "TaiXe", Value = c.Tai_xe_ID_TaiXe
});
dal.DisConnected();
}
public void DeleteChuyen(int ID_Chuyen)
{
DAL dal = new DAL();
dal.Connect();
dal.ExecuteNonQuery(CommandType.StoredProcedure, "deleteChuyen",
new SqlParameter {
ParameterName = "ID_Chuyen", Value = ID_Chuyen
});
dal.DisConnected();
}
