public ResultLoginRowData GetInfoUser(AccountRowData data) { ResultLoginRowData result = new ResultLoginRowData(); try { string sql = @" SELECT USER_ID, FULL_NAME, EMAIL, PHONE, PASSWORD, ADDRESS, USER_TYPE FROM S_USER WHERE EMAIL = '" + data.Email + @"' OR PHONE = '" + data.Email + @"' "; result = dbcontext.Database.SqlQuery <ResultLoginRowData>(sql).FirstOrDefault(); if (result != null) { result.IS_SUCCESS = true; } } catch (Exception ex) { logger.Error(ex); } return(result); }
public string GetSessionUserID(AccountRowData model) { string userID = string.Empty; try { userID = dbcontext.S_USER.FirstOrDefault(x => x.EMAIL == model.Email || x.PHONE == model.Email).USER_ID; } catch (Exception ex) { logger.Error("GetSessionEmail - " + ex); } return(userID); }
public string GetSessionEmail(AccountRowData model) { string email = string.Empty; try { email = dbcontext.S_USER.FirstOrDefault(x => x.EMAIL == model.Email || x.PHONE == model.Email).EMAIL; } catch (Exception ex) { logger.Error("GetSessionEmail - " + ex); } return(email); }
public string GetFullName(AccountRowData model) { string fullname = string.Empty; try { fullname = dbcontext.S_USER.FirstOrDefault(x => x.EMAIL == model.Email || x.PHONE == model.Email).FULL_NAME; } catch (Exception ex) { logger.Error("GetFullName - " + ex); } return(fullname); }
/// <summary> /// check group is admin or user /// </summary> /// <param name="username"></param> /// <returns>true : group admin, false : group user</returns> public bool checkGoupAdmin(AccountRowData model) { bool result = false; try { string sql = @" SELECT COUNT(*) FROM S_USER S INNER JOIN D_GROUP_PERMISSION D ON S.USER_ID = D.USER_ID WHERE (S.EMAIL = '" + model.Email + @"' OR S.PHONE = '" + model.Email + @"') AND D.PERMISSION_ID = '" + ConstantClass.GROUP_ADMIN + @"' "; int res = dbcontext.Database.SqlQuery <int>(sql).FirstOrDefault(); result = (res > 0 ? true : false); } catch (Exception ex) { logger.Error("checkGoupAdmin - " + ex); result = false; } return(result); }
public ResultLoginRowData CheckLoginMobile(AccountRowData data) { ResultLoginRowData result = new ResultLoginRowData(); try { bool isResult = Login(data); if (isResult) { result = GetInfoUser(data); } else { result.IS_SUCCESS = false; } } catch (Exception ex) { logger.Error(ex); } return(result); }
/// <summary> /// Login /// </summary> /// <param name="username"></param> /// <param name="password"></param> /// <returns>true : login success, false : login false</returns> public bool Login(AccountRowData data) { bool result = false; try { var pass = commomFunction.MD5Hash(data.Password); string sql = @" SELECT COUNT(*) FROM S_USER WHERE (EMAIL = '" + data.Email + "' OR PHONE = '" + data.Email + "') AND PASSWORD = '******' "; int record = dbcontext.Database.SqlQuery <int>(sql).FirstOrDefault(); result = record != 0 ? true : false; return(result); } catch (Exception ex) { // write log logger.Error("Login - " + ex); result = false; } return(result); }