public User FindByEmail(string email) { APCRSHREntities context = new APCRSHREntities(); var _email = email.ToString(); return(context.Users.Where(u => u.Email == _email).SingleOrDefault()); }
public IList <Admin> GetAdminsExceptMe(string adminID) { using (APCRSHREntities context = new APCRSHREntities()) { return(context.Admins.Where(a => !a.AdminID.Equals(adminID) && !a.UserName.Equals("administrator", StringComparison.OrdinalIgnoreCase) && a.Type != 1).ToList()); } }
public IList <Experience> FindByOrganization(string organization) { using (APCRSHREntities context = new APCRSHREntities()) { return(context.Experiences.Where(e => e.Organization.Equals(organization)).ToList()); } }
public IList <Admin> FindStandardAdmins() { using (APCRSHREntities context = new APCRSHREntities()) { return(context.Admins.Where(a => a.Type != 1).ToList()); } }
public void Update(Admin item) { using (APCRSHREntities context = new APCRSHREntities()) { var admin = context.Admins.Where(a => a.AdminID.Equals(item.AdminID)).SingleOrDefault(); if (admin != null) { admin.BirthDate = item.BirthDate; admin.Email = item.Email; admin.FirstName = item.FirstName; admin.LastName = item.LastName; admin.Locked = item.Locked; admin.Password = string.IsNullOrEmpty(item.Password) ? admin.Password : Encryption.ComputeHash(item.Password, Algorithm.SHA384, null); admin.Phone = item.Phone; admin.UserName = item.UserName; admin.Type = item.Type; context.SaveChanges(); } else { throw new Exception(string.Format("Admin id {0} invalid", item.AdminID)); } } }
public IList <Role> FindAll() { using (APCRSHREntities context = new APCRSHREntities()) { return(context.Roles.ToList()); } }
public IList <Role> FindAllExceptAdministrator() { using (APCRSHREntities context = new APCRSHREntities()) { return(context.Roles.Where(r => !r.RoleID.Equals(ADMINISTRATOR_ROLE_ID)).ToList()); } }
public Album FindByID(object id) { APCRSHREntities context = new APCRSHREntities(); var _id = id.ToString(); return(context.Albums.Where(a => a.AlbumID.Equals(_id)).SingleOrDefault()); }
public IList <ConferenceDeclaration> FindAll() { using (APCRSHREntities context = new APCRSHREntities()) { return(context.ConferenceDeclarations.OrderByDescending(n => n.CreatedDate).ToList()); } }
public Article FindByActionURL(string actionURL) { using (APCRSHREntities context = new APCRSHREntities()) { return(context.Articles.Where(a => a.ActionURL.Equals(actionURL)).SingleOrDefault()); } }
public IList <Presentation> FindAll() { using (APCRSHREntities context = new APCRSHREntities()) { return(context.Presentations.OrderByDescending(n => n.CreatedDate).ToList()); } }
public void Update(Article item) { using (APCRSHREntities context = new APCRSHREntities()) { var article = context.Articles.Where(a => a.ArticleID.Equals(item.ArticleID)).SingleOrDefault(); if (article != null) { if (!string.IsNullOrEmpty(item.ActionURL)) { article.ActionURL = item.ActionURL; } if (!string.IsNullOrEmpty(item.ImageURL)) { article.ImageURL = item.ImageURL; } article.Contents = item.Contents; article.Language = item.Language; article.MenuID = item.MenuID; article.ShortContent = item.ShortContent; article.Title = item.Title; article.UpdatedBy = item.UpdatedBy; article.UpdatedDate = DateTime.Now; article.HomeDisplay = item.HomeDisplay; context.SaveChanges(); } else { throw new Exception(string.Format("Article id {0} invalid", item.ArticleID)); } } }
public IList <Article> FindTopHomeDisplay(int top) { using (APCRSHREntities context = new APCRSHREntities()) { return(context.Articles.Where(a => a.HomeDisplay == true).OrderByDescending(a => a.CreatedDate).Take(top).ToList()); } }
public IList <Article> FindByMenuID(string menuID) { using (APCRSHREntities context = new APCRSHREntities()) { return(context.Articles.Where(a => a.MenuID.Equals(menuID)).ToList()); } }
public UserSubmission FindBySubmissionNumber(string submissionNumber) { using (APCRSHREntities context = new APCRSHREntities()) { return(context.UserSubmissions.Where(a => a.SubmissionNumber.Equals(submissionNumber)).SingleOrDefault()); } }
public ConferenceDeclaration FindByActionURL(string actionURL) { using (APCRSHREntities context = new APCRSHREntities()) { return(context.ConferenceDeclarations.Where(a => a.ActionURL.Equals(actionURL)).SingleOrDefault()); } }
public Role FindByName(string name) { using (APCRSHREntities context = new APCRSHREntities()) { return(context.Roles.Where(a => a.Name.Equals(name)).SingleOrDefault()); } }
public void Update(ConferenceDeclaration item) { using (APCRSHREntities context = new APCRSHREntities()) { var result = context.ConferenceDeclarations.Where(n => n.ConferenceID.Equals(item.ConferenceID)).SingleOrDefault(); if (result != null) { result.Title = item.Title; if (!string.IsNullOrEmpty(item.ActionURL)) { result.ActionURL = item.ActionURL; } if (!string.IsNullOrEmpty(item.AttachmentURL)) { result.AttachmentURL = item.AttachmentURL; } if (!string.IsNullOrEmpty(item.ImageURL)) { result.ImageURL = item.ImageURL; } result.Contents = item.Contents; result.ShortContent = item.ShortContent; result.UpdatedBy = item.UpdatedBy; result.UpdatedDate = DateTime.Now; context.SaveChanges(); } else { throw new Exception(string.Format("Conference's id {0} invalid", item.ConferenceID)); } } }
public IList <Role> FindAllAssignedRoles(string adminID) { using (APCRSHREntities context = new APCRSHREntities()) { return(context.Roles.SqlQuery("SELECT * FROM [Role] WHERE [RoleID] IN (SELECT [RoleID] FROM [AdminRole] WHERE [AdminID] = @p0) AND [RoleID] != @p1", adminID, ADMINISTRATOR_ROLE_ID).ToList()); } }
public void ExecuteQuery(string query) { using (APCRSHREntities context = new APCRSHREntities()) { context.Database.ExecuteSqlCommand(query); } }
public Admin FindByUserName(string username) { using (APCRSHREntities context = new APCRSHREntities()) { return(context.Admins.Where(a => a.UserName.Equals(username)).SingleOrDefault()); } }
public IList <Resource> FindAllAssignedResources(string roleID) { using (APCRSHREntities context = new APCRSHREntities()) { return(context.Resources.SqlQuery("SELECT * FROM [Resource] WHERE [ResourceID] IN (SELECT [ResourceID] FROM [RoleResource] WHERE [RoleID] = @p0)", roleID).ToList()); } }
public Admin FindAdminByEmail(string email) { using (APCRSHREntities context = new APCRSHREntities()) { return(context.Admins.Where(a => a.Email.Equals(email)).SingleOrDefault()); } }
public Resource FindAuthorizedResource(string adminID, string resourceURL) { using (APCRSHREntities context = new APCRSHREntities()) { return(context.Resources.SqlQuery("SELECT * FROM [Resource] WHERE [ResourceID] IN (SELECT [ResourceID] FROM [RoleResource] WHERE [RoleID] IN (SELECT [RoleID] FROM [AdminRole] WHERE [AdminID] = @p0)) AND [URL] = @p1", adminID, resourceURL).SingleOrDefault()); } }
public IList <Admin> FindAll() { using (APCRSHREntities context = new APCRSHREntities()) { return(context.Admins.ToList()); } }
public IList <UserSubmission> FindAll() { using (APCRSHREntities context = new APCRSHREntities()) { return(context.UserSubmissions.ToList()); } }
public IList <Experience> FindAll() { using (APCRSHREntities context = new APCRSHREntities()) { return(context.Experiences.ToList()); } }
public IList <UserSubmission> FindByUserID(string userID) { using (APCRSHREntities context = new APCRSHREntities()) { return(context.UserSubmissions.Where(s => s.UserID.Equals(userID)).ToList()); } }
public IList <Experience> FindByYouthScholarshipID(string scholarshipID) { using (APCRSHREntities context = new APCRSHREntities()) { return(context.Experiences.Where(e => e.YouthScholarshipID.Equals(scholarshipID)).ToList()); } }
public void Update(User item) { using (APCRSHREntities context = new APCRSHREntities()) { var user = context.Users.Where(u => u.UserID.Equals(item.UserID)).SingleOrDefault(); if (user != null) { user.Email = item.Email; user.DateOfBirth = item.DateOfBirth; user.FullName = item.FullName; user.Locked = item.Locked; user.OtherEmail = item.OtherEmail; user.Password = string.IsNullOrEmpty(item.Password) ? user.Password : Encryption.ComputeHash(item.Password, Algorithm.SHA384, null); //user.UserName = item.UserName; user.UpdatedDate = DateTime.Now; user.Sex = item.Sex; user.PhoneNumber = item.PhoneNumber; user.Title = item.Title; user.MealPreference = item.MealPreference; user.DisabilitySpecialTreatment = item.DisabilitySpecialTreatment; user.Address = item.Address; user.City = item.City; user.Country = item.Country; user.WorkAddress = item.WorkAddress; user.Organization = item.Organization; user.RegistrationStatus = item.RegistrationStatus; context.SaveChanges(); } else { throw new Exception(string.Format("User id {0} invalid", item.UserID)); } } }