public List <string> Update(SettingsGroupDataObject group) { List <string> keys = new List <string>(); using (var context = new IdeaPoolEntities()) { List <Setting> settings = context .SettingsGroups .Where(x => x.Key == group.Key) .Include(x => x.Settings) .SelectMany(x => x.Settings) .ToList(); foreach (var setting in settings) { SettingsDataObject obj = group.Settings.SingleOrDefault(x => x.Key == setting.Key); if (obj != null && setting.Value != obj.Value) { setting.Value = obj.Value; context.Entry(setting).State = EntityState.Modified; keys.Add(setting.Key); } } context.SaveChanges(); } return(keys); }
public int Update(IdeaDataObject ideaData) { using (var context = new IdeaPoolEntities()) { int ideastatusid = context.IdeaStatus .Where(x => x.Key == (ideaData.IsDraft ? IdeaStatusKeys.DRAFT : IdeaStatusKeys.SUBMITTED)) .Single().Id; Idea idea = context.Ideas .Where(x => x.Id == ideaData.Id) .Include(x => x.Files) .Include(x => x.IdeasFieldOfWaters) .Single(); bool isInDraftBeforeUpdate = idea.IsDraft; idea.IdeaStatusId = ideastatusid; idea.PlainContent = ideaData.Description; idea.HtmlContent = ideaData.DescriptionHtml; idea.Title = ideaData.Title; idea.LastUpdated = DateTime.UtcNow; idea.IsDraft = ideaData.IsDraft; if (ideaData.IsNew) { idea.CreatedDate = DateTime.UtcNow; } UpdateFiles(context, ideaData.Files, idea); UpdateFieldOfWater(context, ideaData.FieldOfWater, idea); if (!isInDraftBeforeUpdate) { InsertIdeaHistory(context, idea.Id, idea.UserId, ActivityKeys.UPDATE_IDEA_DETAILS, ideaData.Reason); } context.Entry(idea).State = EntityState.Modified; context.SaveChanges(); return(idea.Id); } }
private void UpdateFieldOfWater(IdeaPoolEntities context, List <FieldOfWaterDataObject> fieldOfWaters, Idea ideaData) { List <int> fieldOfWaterIds = new List <int>(); foreach (IdeasFieldOfWater fieldOfWater in ideaData.IdeasFieldOfWaters.ToList()) { if (!fieldOfWaters.Any(x => x.Id == fieldOfWater.FieldOfWaterId)) { context.IdeasFieldOfWaters.Remove(fieldOfWater); } else { if (fieldOfWater.FieldOfWaterId == FIELDOFWATER_OTHER_ID) { var other = fieldOfWaters.Single(x => x.Id == FIELDOFWATER_OTHER_ID); if (fieldOfWater.Description != other.Description) { fieldOfWater.Description = other.Description; context.Entry(fieldOfWater).State = EntityState.Modified; } } fieldOfWaterIds.Add(fieldOfWater.FieldOfWaterId); } } fieldOfwaterData.InsertIdeaFieldOfWater(context, ideaData.Id, fieldOfWaters.Where(x => !fieldOfWaterIds.Contains(x.Id)).ToList()); }
public void ResetPassword(int userId, string password) { using (var context = new IdeaPoolEntities()) { Login login = context.Logins.Where(x => x.UserId == userId).Single(); login.Password = password; context.Entry(login).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); } }
public void ResetPassword(string token, string password) { using (var context = new IdeaPoolEntities()) { Login login = context.ForgotPasswords.Where(x => x.Token == token).Select(x => x.User.Login).Single(); login.Password = password; context.Entry(login).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); } }
public void Delete(string token) { using (var context = new IdeaPoolEntities()) { ForgotPassword passwordtoken = context.ForgotPasswords.SingleOrDefault(x => x.Token == token); if (passwordtoken != null) { context.Entry(passwordtoken).State = System.Data.Entity.EntityState.Deleted; context.SaveChanges(); } } }
public void UpdateLoginDateTime(int userId) { using (var context = new IdeaPoolEntities()) { Login login = context.Logins.SingleOrDefault(l => l.UserId == userId); if (login != null) { login.LastLogin = DateTime.UtcNow; context.Entry(login).State = EntityState.Modified; context.SaveChanges(); } } }
public void Activate(int fieldOfWaterId) { using (var context = new IdeaPoolEntities()) { FieldOfWater fieldOfWater = context .FieldOfWaters .Where(x => x.Id == fieldOfWaterId) .Single(); fieldOfWater.IsActive = true; context.Entry(fieldOfWater).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); } }
public void Update(UserDataObject user) { using (var context = new IdeaPoolEntities()) { User entity = context.Users.Where(x => x.Id == user.Id).Single(); entity.FirstName = user.FirstName; entity.LastName = user.LastName; entity.Company = user.Company; entity.Phone = user.Phone; entity.IsSubscriptionEnabled = user.IsSubscriptionEnabled; context.Entry(entity).State = EntityState.Modified; context.SaveChanges(); } }
public bool UpdateLoginStatus(int userId, bool status) { bool saved = false; using (var context = new IdeaPoolEntities()) { Login login = context.Logins.Where(x => x.UserId == userId).SingleOrDefault(); if (login != null) { login.IsActivated = status; context.Entry(login).State = EntityState.Modified; context.SaveChanges(); saved = true; } } return(saved); }
public bool UpdateAccountStatus(int userid, bool status) { bool saved = false; using (var context = new IdeaPoolEntities()) { User usr = context.Users.Where(user => user.Id == userid).SingleOrDefault(); if (usr != null) { usr.IsActive = status; context.Entry(usr).State = EntityState.Modified; context.SaveChanges(); saved = true; } } return(saved); }
public bool Activate(string email) { bool isActivated = false; using (var context = new IdeaPoolEntities()) { Login login = context.Users.Where(user => user.Email == email).Select(u => u.Login).SingleOrDefault(); if (login != null) { login.IsActivated = true; isActivated = true; context.Entry(login).State = EntityState.Modified; context.SaveChanges(); } } return(isActivated); }
public bool UpdateStatus(int ideaId, int statusId, int userId) { bool isUpdate = false; using (var context = new IdeaPoolEntities()) { Idea idea = context.Ideas.SingleOrDefault(x => x.Id == ideaId); IdeaStatus status = context.IdeaStatus.SingleOrDefault(x => x.Id == statusId); if (idea != null && status != null) { idea.IdeaStatus = status; context.Entry(idea).State = EntityState.Modified; InsertIdeaHistory(context, ideaId, userId, ActivityKeys.UPDATE_IDEA_STATUS, status.Status); context.SaveChanges(); isUpdate = true; } } return(isUpdate); }
public void Insert(FieldOfWaterDataObject fieldOfWater) { using (var context = new IdeaPoolEntities()) { FieldOfWater other = context.FieldOfWaters.Where(x => x.Id == FIELDOFWATER_OTHER_ID).Single(); context .FieldOfWaters .Add(new FieldOfWater { CreatedByUserId = fieldOfWater.CreatedByUserId, Name = fieldOfWater.Name, Description = fieldOfWater.Description, IsActive = true, Order = other.Order // set the order to last but one }); // Increment the order of other field of water to last other.Order = other.Order + 1; context.Entry(other).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); } }
public void InsertOrUpdate(int userId, string token) { using (var context = new IdeaPoolEntities()) { ForgotPassword forgotpassword = context.ForgotPasswords.SingleOrDefault(x => x.UserId == userId); if (forgotpassword == null) { context.ForgotPasswords.Add(new ForgotPassword { UserId = userId, Token = token, ExpiryDateTime = DateTime.UtcNow.AddDays(1) }); } else { forgotpassword.Token = token; forgotpassword.ExpiryDateTime = DateTime.UtcNow.AddDays(1); context.Entry(forgotpassword).State = System.Data.Entity.EntityState.Modified; } context.SaveChanges(); } }
private void Update(IdeaPoolEntities context, IdeaStatus status) { context.Entry(status).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); }