public static int GetLogCountByStoryName(string storyName)
{
using (MoreHolidaysDBEntities db = new MoreHolidaysDBEntities())
{
return(db.Logs.Where(x => x.StoryName == storyName).Count());
}
}
public static void UpdateAdminById(UserProfile admin, int UserId)
{
using (MoreHolidaysDBEntities db = new MoreHolidaysDBEntities())
{
var q = db.UserProfiles.FirstOrDefault(a => a.UserId == UserId);
if (q != null)
{
q.Address = admin.Address;
q.BirthDate = admin.BirthDate;
q.Email = admin.Email;
q.FirstName = admin.FirstName;
q.LastName = admin.LastName;
q.Name = admin.Name;
q.Phone1 = admin.Phone1;
q.Phone2 = admin.Phone2;
q.ProfilePictureUrl = admin.ProfilePictureUrl;
q.Status = admin.Status;
q.UserName = admin.UserName;
q.webpages_Roles = admin.webpages_Roles;
q.RolesId = (int)UserRoles.Admin;
db.SaveChanges();
AdminRepositories.InsertAdminInRole(q.UserId, (int)q.RolesId);
}
}
}
public static Client GetClientById(int id)
{
using (MoreHolidaysDBEntities db = new MoreHolidaysDBEntities())
{
return(db.Clients.FirstOrDefault(a => a.Id == id && a.IsDeleted == false));
}
}
public static Feature GetFeatureById(int id)
{
using (MoreHolidaysDBEntities db = new MoreHolidaysDBEntities())
{
return(db.Features.FirstOrDefault(a => a.Id == id && a.IsDeleted == false));
}
}
public static int GetLogCount()
{
using (MoreHolidaysDBEntities db = new MoreHolidaysDBEntities())
{
return(db.Logs.Count());
}
}
public static Solution GetSolutionById(int id)
{
using (MoreHolidaysDBEntities db = new MoreHolidaysDBEntities())
{
return(db.Solutions.FirstOrDefault(a => a.Id == id && a.IsDeleted == false));
}
}
public static UserProfile GetAdminById(int id)
{
using (MoreHolidaysDBEntities db = new MoreHolidaysDBEntities())
{
return(db.UserProfiles.FirstOrDefault(a => a.UserId == id && a.LockedUser == false));
}
}
public static Vacancy GetVacancyById(int id)
{
using (MoreHolidaysDBEntities db = new MoreHolidaysDBEntities())
{
return(db.Vacancies.FirstOrDefault(a => a.Id == id && a.IsDeleted == false));
}
}
public static List <Feature> GetFeaturesBySolutionId(int solutionId, int skipCount, int takeCount)
{
using (MoreHolidaysDBEntities db = new MoreHolidaysDBEntities())
{
var q = db.Features.Where(f => f.SolutionId == solutionId && f.IsDeleted == false).ToList();
return(q.Skip(skipCount).Take(takeCount).ToList());
}
}
public static void InsertNewJobRequirement(JobRequirement jobRequirement)
{
using (MoreHolidaysDBEntities db = new MoreHolidaysDBEntities())
{
db.JobRequirements.Add(jobRequirement);
db.SaveChanges();
}
}
public static List <JobRequirement> GetRequirementsByVacancyId(int vacancyId, int skipCount, int takeCount)
{
using (MoreHolidaysDBEntities db = new MoreHolidaysDBEntities())
{
var q = db.JobRequirements.Where(f => f.VacancyId == vacancyId & f.IsDeleted == false).ToList();
return(q.Skip(skipCount).Take(takeCount).ToList());
}
}
public static List <Solution> GetSolutionsList(int skipCount, int takeCount)
{
using (MoreHolidaysDBEntities db = new MoreHolidaysDBEntities())
{
var q = db.Solutions.Where(p => p.IsDeleted == false);
return(q.OrderBy(m => m.Id).Skip(skipCount).Take(takeCount).ToList());
}
}
public static void InsertNewVacancy(Vacancy vacancy)
{
using (MoreHolidaysDBEntities db = new MoreHolidaysDBEntities())
{
db.Vacancies.Add(vacancy);
db.SaveChanges();
}
}
public static void InsertNewSolution(Solution solution)
{
using (MoreHolidaysDBEntities db = new MoreHolidaysDBEntities())
{
db.Solutions.Add(solution);
db.SaveChanges();
}
}
public static void InsertLog(Log log)
{
using (MoreHolidaysDBEntities db = new MoreHolidaysDBEntities())
{
log.CreateDate = DateTime.Now;
db.Logs.Add(log);
db.SaveChanges();
}
}
public static void InsertNewProject(Project project)
{
using (MoreHolidaysDBEntities db = new MoreHolidaysDBEntities())
{
project.CreateDate = DateTime.Now;
db.Projects.Add(project);
db.SaveChanges();
}
}
public static void InsertNewFeature(Feature feature)
{
using (MoreHolidaysDBEntities db = new MoreHolidaysDBEntities())
{
feature.CreateDate = DateTime.Now;
db.Features.Add(feature);
db.SaveChanges();
}
}
public static void InsertNewClient(Client client)
{
using (MoreHolidaysDBEntities db = new MoreHolidaysDBEntities())
{
client.CreateDate = DateTime.Now;
db.Clients.Add(client);
db.SaveChanges();
}
}
public static UserProfile GetAdminByName(String name)
{
using (MoreHolidaysDBEntities db = new MoreHolidaysDBEntities())
{
UserProfile user = new UserProfile();
user = db.UserProfiles.FirstOrDefault(a => a.UserName == name && a.LockedUser == false);
return(user);
}
}
public static List <UserProfile> GetAdminList(int skipCount, int takeCount)
{
int RoleId = (int)UserRoles.Admin;
using (MoreHolidaysDBEntities db = new MoreHolidaysDBEntities())
{
var q = db.UserProfiles.Where(p => p.RolesId == RoleId).ToList();
return(q.Skip(skipCount).Take(takeCount).ToList());
}
}
public static void InsertAdminInRole(int AdminId, int RoleId)
{
using (MoreHolidaysDBEntities db = new MoreHolidaysDBEntities())
{
webpages_UsersInRoles UserInRole = new webpages_UsersInRoles()
{
UserId = AdminId, RoleId = RoleId
};
db.webpages_UsersInRoles.Add(UserInRole);
db.SaveChanges();
}
}
public static void DeleteLogsByStoryName(string storyName)
{
using (MoreHolidaysDBEntities db = new MoreHolidaysDBEntities())
{
List <Log> log = db.Logs.Where(a => a.StoryName == storyName).ToList();
foreach (var item in log)
{
db.Logs.Remove(item);
db.SaveChanges();
}
}
}
public static void DeleteLog(int logId)
{
using (MoreHolidaysDBEntities db = new MoreHolidaysDBEntities())
{
Log log = db.Logs.FirstOrDefault(a => a.Id == logId);
if (log != null)
{
db.Logs.Remove(log);
db.SaveChanges();
}
}
}
public static void DeleteSolution(int id)
{
using (MoreHolidaysDBEntities db = new MoreHolidaysDBEntities())
{
var q = db.Solutions.FirstOrDefault(a => a.Id == id);
if (q != null)
{
q.IsDeleted = true;
db.SaveChanges();
}
}
}
public static void UpdateVacancy(Vacancy vacancy)
{
using (MoreHolidaysDBEntities db = new MoreHolidaysDBEntities())
{
var q = db.Vacancies.FirstOrDefault(a => a.Id == vacancy.Id);
if (q != null)
{
q.Name = vacancy.Name;
q.ArabicName = vacancy.ArabicName;
db.SaveChanges();
}
}
}
public static void UpdateJobRequirement(JobRequirement jobRequirement)
{
using (MoreHolidaysDBEntities db = new MoreHolidaysDBEntities())
{
var q = db.JobRequirements.FirstOrDefault(a => a.Id == jobRequirement.Id);
if (q != null)
{
q.Details = jobRequirement.Details;
q.ArabicDetails = jobRequirement.ArabicDetails;
db.SaveChanges();
}
}
}
public static ChangePasswordDetails GetAdminPasswordDetails(int userId)
{
using (MoreHolidaysDBEntities db = new MoreHolidaysDBEntities())
{
var q = (from user in db.UserProfiles
.Where(a => a.UserId == userId && a.LockedUser == false)
select new ChangePasswordDetails()
{
UserName = user.UserName,
Name = user.FirstName + " " + user.LastName,
})
.FirstOrDefault();
return(q);
}
}
public static void UpdateSolution(Solution solution)
{
using (MoreHolidaysDBEntities db = new MoreHolidaysDBEntities())
{
var q = db.Solutions.FirstOrDefault(a => a.Id == solution.Id);
if (q != null)
{
q.Name = solution.Name;
q.ArabicName = solution.ArabicName;
q.Overview = solution.Overview;
q.ArabicOverview = solution.Overview;
q.ImgUrl = solution.ImgUrl;
db.SaveChanges();
}
}
}
public static void DeleteAdmin(int id, bool isLocked)
{
using (MoreHolidaysDBEntities db = new MoreHolidaysDBEntities())
{
var q = db.UserProfiles.FirstOrDefault(a => a.UserId == id);
if (isLocked)
{
q.LockedUser = false;
}
else
{
q.LockedUser = true;
}
db.SaveChanges();
}
}
public static void UpdateFeature(Feature feature)
{
using (MoreHolidaysDBEntities db = new MoreHolidaysDBEntities())
{
var q = db.Features.FirstOrDefault(a => a.Id == feature.Id);
if (q != null)
{
q.LastUpdateDate = DateTime.Now;
q.Name = feature.Name;
q.ArabicName = feature.ArabicName;
q.Description = feature.Description;
q.ArabicDescription = feature.ArabicDescription;
db.SaveChanges();
}
}
}
