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