//Update ve xe
public static bool Update(VeXe vx)
{
try
{
int result = DataProvider.Instance.ExecuteNonQuery("VeXe_Update", vx.MaVe, vx.HoTen, vx.GioiTinh, vx.Tuoi, vx.DiaChi, vx.SoDT, vx.NgayXuatBen, vx.TrangThaiVeXe, vx.MaTG, vx.MaTuyen, vx.MaXe, vx.MaTKKH, vx.Printt);
return(result > 0);
}
catch
{
return(false);
}
}
//Add ve xe
public static bool Add(VeXe vx)
{
try
{
//lay soghemax cua cung chuyen xe
object result = DataProvider.Instance.ExecuteNonQueryWithOutput("@MaVe", "VeXe_Add", vx.MaVe, vx.HoTen, vx.GioiTinh, vx.Tuoi, vx.DiaChi, vx.SoDT, vx.NgayXuatBen, vx.TrangThaiVeXe, vx.MaTG, vx.MaTuyen, vx.MaXe, vx.MaTKKH, vx.Printt);
return(Convert.ToInt32(result) > 0);
}
catch
{
return(false);
}
}
//Lay du lieu de cap nhat
private VeXe GetData()
{
VeXe data = null;
if (lbMaVe.Text != "")
{
data = VeXe.VeXe_Single(lbMaVe.Text);
}
else
{
data = new VeXe();
}
data.HoTen = txtHoVaTen.Text;
string gt = "";
if (RadioButtonNam.Checked)
{
gt = "Nam";
}
else
{
gt = "Nữ";
}
data.GioiTinh = gt;
data.Tuoi = int.Parse(txtTuoi.Text);
data.DiaChi = txtDiaChi.Text;
data.SoDT = txtSoDT.Text;
data.NgayXuatBen = DateTime.Parse(txtNgayThangXuatBen.Text);
data.TrangThaiVeXe = CheckBoxTrangThaiVeXe.Checked;
data.MaTG = Convert.ToInt32(DropDownListThoiGian.SelectedValue);
data.MaTuyen = Convert.ToInt32(DropDownListTuyenDiTuyenDen.SelectedValue);
data.MaXe = Convert.ToInt32(DropDownListLoaiXe.SelectedValue);
data.MaTKKH = lbUsername.Text;
return data;
}
//Update ve xe
public static bool Update(VeXe vx)
{
try
{
int result = DataProvider.Instance.ExecuteNonQuery("VeXe_Update", vx.MaVe, vx.HoTen, vx.GioiTinh, vx.Tuoi, vx.DiaChi, vx.SoDT, vx.NgayXuatBen, vx.TrangThaiVeXe, vx.MaTG, vx.MaTuyen, vx.MaXe, vx.MaTKKH,vx.Printt);
return result > 0;
}
catch
{
return false;
}
}
//Add ve xe
public static bool Add(VeXe vx)
{
try
{
//lay soghemax cua cung chuyen xe
object result = DataProvider.Instance.ExecuteNonQueryWithOutput("@MaVe", "VeXe_Add", vx.MaVe, vx.HoTen, vx.GioiTinh, vx.Tuoi, vx.DiaChi, vx.SoDT, vx.NgayXuatBen, vx.TrangThaiVeXe, vx.MaTG, vx.MaTuyen, vx.MaXe, vx.MaTKKH,vx.Printt);
return Convert.ToInt32(result) > 0;
}
catch
{
return false;
}
}
