public async Task <TH_HOSOKHACHHANG> GetHoSoKhachHang(int?ID) { try { using (APAXEntities3 db = new APAXEntities3()) { if (ID > 0) { TH_HOSOKHACHHANG model = await Task.Run(() => db.TH_HOSOKHACHHANG.FirstOrDefault(it => it.A_HOSOKHACHHANG == ID)); return(model); } return(null); } } catch { return(null); } }
public string[] GetAllRolesByUser(string userName) { try { using (APAXEntities3 db = new APAXEntities3()) { TH_HOSOKHACHHANG Quyen = db.TH_HOSOKHACHHANG.FirstOrDefault(it => it.TAIKHOAN.Equals(userName)); if (Quyen != null && Quyen.ID_QUYENNGUOIDUNG > 0) { var strQuyen = db.DM_QUYEN.FirstOrDefault(it => it.A_QUYEN == Quyen.ID_QUYENNGUOIDUNG); return(strQuyen != null?strQuyen.QUYENNGUOIDUNG.Split(',') : null); } return(null); } } catch { return(null); } }
public override string[] GetRolesForUser(string userName) { try { if (userName.Equals("Administrator")) { List <string> Quyen = new List <string>(); Quyen.Add("0=0"); return(Quyen.ToArray()); } using (APAXEntities3 db = new APAXEntities3()) { TH_HOSOKHACHHANG nguoiDung = db.TH_HOSOKHACHHANG.FirstOrDefault(it => it.TAIKHOAN.Equals(userName)); if (nguoiDung != null) { string[] _Quyen = null; List <string> Quyen = new List <string>(); string[] QuyenUser = GetAllRolesByUser(userName); if (QuyenUser != null) { Quyen.AddRange(QuyenUser); } if (Quyen.Count > 0) { _Quyen = Quyen.Distinct().ToArray(); } if (_Quyen == null) { _Quyen[0] = "IsNull"; } return(_Quyen); } } List <string> Quyen0 = new List <string>(); Quyen0.Add("IsNull"); return(Quyen0.ToArray()); } catch { List <string> Quyen = new List <string>(); Quyen.Add("IsNull"); return(Quyen.ToArray()); } }
public async Task <int> GetUserID(HttpCookieCollection Cookies) { try { using (APAXEntities3 db = new APAXEntities3()) { string userName = GetUserName().ToLower(); TH_HOSOKHACHHANG model = await Task.Run(() => db.TH_HOSOKHACHHANG .FirstOrDefault(it => it.TAIKHOAN.ToLower().Equals(userName))); if (model != null) { return(model.A_HOSOKHACHHANG); } else { return(1); } } } catch { return(1); } }