public AccInfor getAccInfor(string UseName, string PassWord) { AccInfor result = Service.getAccInfor(UseName, PassWord); if (result != null) { return(result); } else { throw new HttpResponseException(Request.CreateResponse(HttpStatusCode.BadRequest, "invalid account")); } }
//Cai nay phai dieu chinh lai dataBase de dieu chinh lai khoa ngoai giua KHACHHANG, ADMIN toi ACCOUNT. Thieu mat IDACCOUT // lay inforAccount public AccInfor getAccInfor(string _userName, string _passWord) { AccInfor result = new AccInfor(); if (checkAcc(_userName, _passWord) == false) { return(null); } #region if have exist account else { var q = (from e in db.ACCOUNTs where e.Username == _userName && e.Password == _passWord select new { useName = e.Username, passWord = e.Password, idType = e.IDType }).ToList(); result.Username = q[0].useName; result.Password = q[0].passWord; result.IDType = q[0].idType; if (result.IDType == "TYP01") { var r = (from e in db.ACCOUNTs join f in db.ACCOUNTADMINs on e.Username equals f.Account where e.Username == _userName && e.Password == _passWord select new { id = f.ID, Ten = f.Ten, Email = f.Email, SDT = f.SDT }).ToList(); result.Ten = r[0].Ten; result.SDT = r[0].SDT; result.Email = r[0].Email; result.ID = r[0].id.ToString(); } else { var r = (from e in db.ACCOUNTs join f in db.KHACHHANGs on e.Username equals f.IDAccount where e.Username == _userName && e.Password == _passWord select new { id = f.ID, Ten = f.Ten, Email = f.Email, SDT = f.SDT, DiaChi = f.DiaChi }).ToList(); result.Ten = r[0].Ten; result.SDT = r[0].SDT; result.Email = r[0].Email; result.ID = r[0].id.ToString(); result.DiaChi = r[0].DiaChi; } } #endregion return(result); }