public static string NewBestID()
{
List <HuongDanVien> list = HuongDanVien.All();
if (list.Count > 0)
{
string id = list[list.Count - 1].ID;
string[] s = id.Split('V');
id = s[1];
int newMaSo = MyConvert.ToInt32(id) + 1;
if (newMaSo >= 99999)
{
MessageBox.Show("Cạn kho mã số cho hướng dẫn viên!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return("");
}
id = newMaSo.ToString();
while (id.Length < 4)
{
id = "0" + id;
}
id = "HDV" + id;
return(id);
}
return("HDV0000");
}
public static bool Update(HuongDanVien hdv, List <HDV_Tour> list)
{
object rs = DataProvider.Instance.ExecuteNonQuery("HDV_Update", hdv.ID, hdv.Ho, hdv.Ten, hdv.NgaySinh, hdv.GioiTinh, hdv.DiaChi, hdv.QuocGia, hdv.DienThoai, hdv.TrangThai);
int affected = MyConvert.ToInt32(rs);
if (affected > 0)
{
foreach (HDV_Tour i in list)
{
if (!HDV_Tour.Add(i))
{
MessageBox.Show(String.Format("Adding the specialized tour is faile at ID = {0}", i.MTour), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
return(true);
}
return(false);
}
public static List <PhanCongHDV> FindByMHDV(HuongDanVien hdv)
{
return(CBO.FillCollection <PhanCongHDV>(DataProvider.Instance.ExecuteReader("PhanCongHDV_FindByMHDV", hdv.ID)));
}
public static bool Add(HuongDanVien hdv)
{
object rs = DataProvider.Instance.ExecuteNonQuery("HDV_Add", hdv.ID, hdv.Ho, hdv.Ten, hdv.NgaySinh, hdv.GioiTinh, hdv.DiaChi, hdv.QuocGia, hdv.DienThoai, hdv.TrangThai);
return(MyConvert.ToInt32(rs) > 0);
}
