public List <KhachVIP> GetListOfKhachVIPs() { List <KhachVIP> lstKhachVIP = new List <KhachVIP>(); DataTable dt = new DataTable(); dt = new Data.DM.KhachVIP().GetDanhSachKhachVIPs(string.Empty);// lay ta ca if (dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { KhachVIP objKhachVIP = new KhachVIP(); objKhachVIP.MaKhachVIP = StringTools.TrimSpace(dr["Ma_KhachVIP"].ToString()); objKhachVIP.Name = StringTools.TrimSpace(dr["Name"].ToString()); objKhachVIP.Address = StringTools.TrimSpace(dr["Address"].ToString()); objKhachVIP.Phones = StringTools.TrimSpace(dr["Phones"].ToString()); objKhachVIP.Fax = StringTools.TrimSpace(dr["Fax"].ToString()); objKhachVIP.Email = StringTools.TrimSpace(dr["Email"].ToString()); objKhachVIP.Notes = dr["Notes"].ToString(); objKhachVIP.IsActive = dr["IsActive"].ToString() == "1" ? true : false; lstKhachVIP.Add(objKhachVIP); } } return(lstKhachVIP); }
/// <summary> /// Lay thong tin cua khach VIP boi SoDienThoai /// </summary> /// <param name="PhoneNumber"></param> /// <returns></returns> public static KhachVIP GetKhachVIPByPhoneNumber(string PhoneNumber) { KhachVIP objKhachVIP = new KhachVIP(); DataTable dt = new DataTable(); dt = new Data.DM.KhachVIP().GetKhachVIPByPhoneNumber(PhoneNumber); if (dt.Rows.Count == 1) { objKhachVIP.MaKhachVIP = StringTools.TrimSpace(dt.Rows[0]["Ma_KhachVIP"].ToString()); objKhachVIP.Name = StringTools.TrimSpace(dt.Rows[0]["Name"].ToString()); objKhachVIP.Address = StringTools.TrimSpace(dt.Rows[0]["Address"].ToString()); objKhachVIP.Phones = StringTools.TrimSpace(dt.Rows[0]["Phones"].ToString()); objKhachVIP.Fax = StringTools.TrimSpace(dt.Rows[0]["Fax"].ToString()); objKhachVIP.Email = StringTools.TrimSpace(dt.Rows[0]["Email"].ToString()); objKhachVIP.Notes = dt.Rows[0]["Notes"].ToString(); objKhachVIP.IsActive = dt.Rows[0]["IsActive"].ToString() == "1" ? true : false; } dt.Dispose(); dt = null; return(objKhachVIP); }