public DBContextResult<MST_UserInfo> GetUserValidity(string p_Email) { return ExecuteDALMethod(db, (DataContext, P_Email) => { MST_UserInfo UserObj = DataContext.MST_UserInfo.SingleOrDefault(x => x.Email.Equals(P_Email) && x.IsActive == true); return UserObj; }, p_Email); }
public DBContextResult<MST_UserInfo> Insert(MST_UserInfo p_MST_UserInfo) { return ExecuteDALMethod(db, (DataContext, P_MST_UserInfo) => { DataContext.MST_UserInfo.Add(P_MST_UserInfo); DataContext.SaveChanges(); return DataContext.MST_UserInfo.OrderByDescending(x => x.UserId).FirstOrDefault(); }, p_MST_UserInfo); }
public DBContextResult<object> Delete(int p_UserId) { return ExecuteDALMethod<int, object>(db, (DataContext, P_UserId) => { MST_UserInfo Obj = DataContext.MST_UserInfo.Find(P_UserId); Obj.IsActive = false; DataContext.SaveChanges(); return null; }, p_UserId); }
public DBContextResult<object> Update(MST_UserInfo p_MST_UserInfo) { return ExecuteDALMethod<MST_UserInfo, object>(db, (DataContext, P_MST_UserInfo) => { MST_UserInfo UserObj = DataContext.MST_UserInfo.Find(P_MST_UserInfo.UserId); UserObj.FirstName = P_MST_UserInfo.FirstName; UserObj.LastName = P_MST_UserInfo.LastName; UserObj.CountryId = P_MST_UserInfo.CountryId; UserObj.Email = P_MST_UserInfo.Email; UserObj.Password = P_MST_UserInfo.Password; DataContext.SaveChanges(); return null; }, p_MST_UserInfo); }
public bool SaveNewPassword(string p_Email, string NewHashedPassword) { try { MST_UserInfo MST_UserInfo = db.MST_UserInfo.FirstOrDefault(x => x.Email.Equals(p_Email)); MST_UserInfo.Password = NewHashedPassword; db.SaveChanges(); return true; } catch (Exception ex) { new LogError(ex); return false; } }
public bool AddOrRemoveAdmin(List <string> lstUserIds, bool p_IsAdmin) { try { foreach (var UserId in lstUserIds) { MST_UserInfo User = db.MST_UserInfo.Find(Convert.ToInt32(UserId)); User.IsAdmin = p_IsAdmin; db.SaveChanges(); } return(true); } catch (Exception ex) { new LogError(ex); return(false); } }