//Tim Kiem Khach Hang Fullname public static DataTable TimKiemKH_Fullname(string fullname) { SqlConnection cnn = SQLconnectionData.HamKetNoi(); SqlCommand cmd = new SqlCommand("TimKiemKH_Fullname", cnn); cmd.Parameters.AddWithValue("@fullname", fullname); cmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter apdt = new SqlDataAdapter(cmd); DataTable table = new DataTable(); apdt.Fill(table); return(table); }
//Xoa mot Tai Xe public static void XoaMotTaiXe(string maTX) { try { SqlConnection cnn = SQLconnectionData.HamKetNoi(); SqlCommand cmd = new SqlCommand("Xoa_TX", cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@MaTX", maTX); cnn.Open(); cmd.ExecuteNonQuery(); cnn.Close(); } catch (Exception ex) { throw ex; } }
public static void XoaXe(string bienSo) { try { SqlConnection cnn = SQLconnectionData.HamKetNoi(); SqlCommand cmd = new SqlCommand("XoaXe", cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@BienSoXe", bienSo); cnn.Open(); cmd.ExecuteNonQuery(); cmd.Clone(); } catch (Exception ex) { throw ex; } }
public static DataTable LoadDanhSachLoaiXe() { try { SqlConnection cnn = SQLconnectionData.HamKetNoi(); SqlCommand cmd = new SqlCommand("LayDanhSachCacLoaiXe", cnn); cmd.CommandType = CommandType.Text; SqlDataAdapter adpt = new SqlDataAdapter(cmd); DataTable table = new DataTable(); adpt.Fill(table); return(table); } catch (Exception ex) { throw ex; } }
//Lay Danh sach cac chuyen di cua Khach Hang public static DataTable LayDanhSachCacChuyenDi_KH(string maKH) { try { SqlCommand cmd = new SqlCommand("LayDanhSachCacChuyenDiCuaKH", SQLconnectionData.HamKetNoi()); cmd.Parameters.AddWithValue("@MaKH", maKH); cmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter apdt = new SqlDataAdapter(cmd); DataTable table = new DataTable(); apdt.Fill(table); return(table); } catch (Exception ex) { throw ex; } }
//Loat danh sach tat ca Khach Hang: public static DataTable LoadDanhSachTatCaKH() { try { SqlConnection cnn = SQLconnectionData.HamKetNoi(); SqlCommand cmd = new SqlCommand("LayDanhSachTatCaKhachHang", cnn); cmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter apdt = new SqlDataAdapter(cmd); DataTable table = new DataTable(); apdt.Fill(table); return(table); } catch (Exception ex) { throw ex; } }
//Tim theo ma Tai Xe public static DataTable TimTheoMaTaiXe(string maTX) { try { SqlConnection cnn = SQLconnectionData.HamKetNoi(); SqlCommand cmd = new SqlCommand("LayDanhSachTaiXeTheoMa", cnn); cmd.Parameters.AddWithValue("@MaTX", maTX); cmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter apdt = new SqlDataAdapter(cmd); DataTable table = new DataTable(); apdt.Fill(table); return(table); } catch (Exception ex) { throw ex; } }
public static DataTable TimXeTheoBienSo(string bienSo) { try { SqlConnection cnn = SQLconnectionData.HamKetNoi(); SqlCommand cmd = new SqlCommand("LayDanhSachXeTheoBienSo", cnn); cmd.Parameters.AddWithValue("@BienSoXe", bienSo); cmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter adpt = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); adpt.Fill(dt); return(dt); } catch (Exception ex) { throw ex; } }
//Kiem Tra Fullname Khach Hang Co Ton Tai public static int KiemTraFullnameKH(string fullname) { SqlConnection cnn = SQLconnectionData.HamKetNoi(); SqlCommand cmd = new SqlCommand("KiemTraFullnameKH", cnn); cmd.Parameters.AddWithValue("@fullname", fullname); SqlParameter output = new SqlParameter("@KQ", SqlDbType.Int); output.Direction = ParameterDirection.Output; cmd.Parameters.Add(output); cmd.CommandType = CommandType.StoredProcedure; cnn.Open(); cmd.ExecuteNonQuery(); int KQ = Convert.ToInt16(output.Value.ToString()); cnn.Close(); return(KQ); }
public static void SuaKhachThongTinXe(Xe_DTO xe) { try { SqlConnection cnn = SQLconnectionData.HamKetNoi(); SqlCommand cmd = new SqlCommand("SuaThongTinXe", cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@BienSoXe", xe.BienSoXe); cmd.Parameters.AddWithValue("@MaLoaiXe", xe.MaLoaiXe); cmd.Parameters.AddWithValue("@MaTaiXe", xe.MaTaiXe); cnn.Open(); cmd.ExecuteNonQuery(); cnn.Close(); } catch (Exception ex) { throw ex; } }
//Sua Khach Hang public static void SuaKhachHang(KhachHang_DTO KhachHang) { try { SqlConnection cnn = SQLconnectionData.HamKetNoi(); SqlCommand cmd = new SqlCommand("Sua_KH", cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@MaKH", KhachHang.MaKH); cmd.Parameters.AddWithValue("@HoKH", KhachHang.HoKH); cmd.Parameters.AddWithValue("@TenKH", KhachHang.TenKH); cmd.Parameters.AddWithValue("@DienThoai", KhachHang.TenKH); cmd.Parameters.AddWithValue("@Email", KhachHang.Email); cnn.Open(); cmd.ExecuteNonQuery(); cnn.Close(); } catch (Exception ex) { throw ex; } }
//Kiem tra su ton tai cua ten Khach Hang public static int KiemTraTenKH_CoTonTai(string tenKH) { try { SqlConnection cnn = SQLconnectionData.HamKetNoi(); SqlCommand cmd = new SqlCommand("KiemTraTenKH", cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@TenKH", tenKH); SqlParameter output = new SqlParameter("@KQ", SqlDbType.Int); output.Direction = ParameterDirection.Output; cmd.Parameters.Add(output); cnn.Open(); cmd.ExecuteNonQuery(); int KQ = Convert.ToInt16(output.Value.ToString()); cnn.Close(); return(KQ); } catch (Exception ex) { throw ex; } }
//Them mot Tai Xe moi public static void ThemMotTaiXeMoi(TaiXe_DTO TaiXe) { try { SqlConnection cnn = SQLconnectionData.HamKetNoi(); SqlCommand cmd = new SqlCommand("ThemTX", cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@MaTX", TaiXe.MaTaiXe); cmd.Parameters.AddWithValue("@HoTX", TaiXe.hoTX); cmd.Parameters.AddWithValue("@TenTX", TaiXe.TenTX); cmd.Parameters.AddWithValue("@CMND", TaiXe.CMND); cmd.Parameters.AddWithValue("@NgaySinh", TaiXe.NgaySinh); cmd.Parameters.AddWithValue("@DienThoai", TaiXe.Dienthoai); cnn.Open(); cmd.ExecuteNonQuery(); cnn.Close(); } catch (Exception ex) { throw ex; } }
public static int KiemTraBienSoXe_CoTonTai(string bienSo) { int kq; try { SqlConnection cnn = SQLconnectionData.HamKetNoi(); SqlCommand cmd = new SqlCommand("KiemTraBienSoXe_CoTonTai", cnn); cmd.Parameters.AddWithValue("@BienSoXe", bienSo); SqlParameter output = new SqlParameter("@KetQua", SqlDbType.Int); output.Direction = ParameterDirection.Output; cmd.Parameters.Add(output); cmd.CommandType = CommandType.StoredProcedure; cnn.Open(); cmd.ExecuteNonQuery(); kq = Convert.ToInt16(output.Value.ToString()); cnn.Close(); } catch (Exception ex) { throw ex; } return(kq); }