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));
}
}
}
