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); } }
public int Insert(IdeaDataObject idea) { int id = -1; using (var context = new IdeaPoolEntities()) { int ideastatusid = context.IdeaStatus .Where(x => x.Key == (idea.IsDraft ? IdeaStatusKeys.DRAFT : IdeaStatusKeys.SUBMITTED)) .Single().Id; Idea ideaData = new Idea { Title = idea.Title, HtmlContent = idea.DescriptionHtml, PlainContent = idea.Description, UniqueId = Guid.NewGuid(), UserId = idea.UserId, CreatedDate = DateTime.UtcNow, LastUpdated = DateTime.UtcNow, IdeaStatusId = ideastatusid, IsDraft = idea.IsDraft }; fieldOfwaterData.InsertIdeaFieldOfWater(context, ideaData, idea.FieldOfWater); fileData.Insert(context, idea.Files, ideaData); context.Ideas.Add(ideaData); context.SaveChanges(); id = ideaData.Id; } return(id); }
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 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 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 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 MarkRead(int ideaId, int userId) { using (var context = new IdeaPoolEntities()) { UnReadDiscussion discussion = context.UnReadDiscussions.SingleOrDefault(x => x.IdeaId == ideaId && x.UserId == userId); if (discussion != null) { context.UnReadDiscussions.Remove(discussion); 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 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 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 void InsertMessage(int ideaId, int userId, string message) { using (var context = new IdeaPoolEntities()) { Discussion discussion = new Discussion { IdeaId = ideaId, UserId = userId, Message = message, CreateDate = DateTime.UtcNow }; context.Discussions.Add(discussion); context.SaveChanges(); } }
public void InsertFile(int ideaId, int userId, int fileId) { using (var context = new IdeaPoolEntities()) { Discussion discussion = new Discussion { IdeaId = ideaId, UserId = userId, FileId = fileId, CreateDate = DateTime.UtcNow }; context.Discussions.Add(discussion); context.SaveChanges(); } }
public int Add(UserDataObject userDataObject) { int userId = 0; using (var context = new IdeaPoolEntities()) { User user = new User { FirstName = userDataObject.FirstName, LastName = userDataObject.LastName, Company = userDataObject.Company, Email = userDataObject.Email, Phone = userDataObject.Phone, CreateDate = DateTime.UtcNow, IsSubscriptionEnabled = userDataObject.IsSubscriptionEnabled, IsActive = true }; Role submitterRole = context.Roles.Single(x => x.Key == RoleKeys.SUBMITTER); // Add submitter role user.Roles.Add(submitterRole); context.Users.Add(user); context.SaveChanges(); Login login = new Login { UserId = user.Id, Password = userDataObject.EncryptedPassword, IsActivated = false }; context.Logins.Add(login); context.SaveChanges(); userId = user.Id; } return(userId); }
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 void Insert(AuditDataObject audit) { using (var context = new IdeaPoolEntities()) { AuditType type = context.AuditTypes.Where(x => x.Key == audit.AuditTypeKey).Single(); context.Audits.Add(new Audit { AuditType = type, CreateDate = DateTime.UtcNow, Description = audit.Description, IdeaId = audit.IdeaId, LoginUserId = audit.LoginUserId, UpdateUserId = audit.UpdateUserId }); context.SaveChanges(); } }
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 void Insert(IdeaStatusDataObject status) { using (var context = new IdeaPoolEntities()) { context.IdeaStatus.Add(new IdeaStatus { Color = status.Color, CreatedByUserId = status.CreatedByUserId, Description = status.Description, Status = status.Name, IsActive = true, IsVisible = true, Key = status.Name.Replace(" ", "").ToUpper() }); context.SaveChanges(); } }
public void Insert(ExceptionDataObject exceptionObject) { using (var context = new IdeaPoolEntities()) { Exception exception = new Exception { Message = exceptionObject.Message, CallStack = exceptionObject.CallStack, CreatedDate = DateTime.UtcNow, ExceptionType = exceptionObject.ExceptionType, UserId = exceptionObject.UserId, UserAgent = exceptionObject.UserAgent }; context.Exceptions.Add(exception); context.SaveChanges(); } }
public void MarkUnread(int ideaId, List <int> userIds) { using (var context = new IdeaPoolEntities()) { foreach (int userid in userIds) { if (!context.UnReadDiscussions.Any(x => x.UserId == userid && x.IdeaId == ideaId)) { UnReadDiscussion unread = new UnReadDiscussion { IdeaId = ideaId, UserId = userid }; context.UnReadDiscussions.Add(unread); } } context.SaveChanges(); } }
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 int Insert(FileDataObject file, int ideaId) { int fileId; using (var context = new IdeaPoolEntities()) { File dbFile = new File { Content = file.Content, ContentType = file.ContentType, IdeaId = ideaId, Name = file.Name, Thumbnail = file.Thumbnail, SizeInKb = file.SizeInKb, UniqueID = Guid.NewGuid(), IsUploadedViaDiscussions = file.IsUploadedViaDiscussions }; context.Files.Add(dbFile); context.SaveChanges(); fileId = dbFile.Id; } return(fileId); }
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(); } }
public List <KeyValueDataObject> RemoveRole(int userId, string key) { List <KeyValueDataObject> roles = new List <KeyValueDataObject>(); using (var context = new IdeaPoolEntities()) { User user = context.Users .Include(x => x.Roles) .Where(x => x.Id == userId) .SingleOrDefault(); if (user != null) { Role role = context.Roles.Where(x => x.Key == key).SingleOrDefault(); if (role != null) { user.Roles.Remove(role); context.SaveChanges(); } roles = GetRoles(user); } } return(roles); }
private void Update(IdeaPoolEntities context, IdeaStatus status) { context.Entry(status).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); }