public static void DeleteEverything(HrPestContext context) { context.JobApplications.RemoveRange(context.JobApplications.Where(x => x.JobOffer != null)); context.JobOffers.RemoveRange(context.JobOffers.Where(x => x.Id != null)); context.Companies.RemoveRange(context.Companies.Where(x => x.CreatedOn != null)); context.Users.RemoveRange(context.Users.Where(x => x.Id != null)); context.SaveChanges(); }
public static void AddEverything(HrPestContext context) { AddUsers(context); AddCompanies(context); context.SaveChanges(); AddJobOffers(context); context.SaveChanges(); AddJobApplications(context); context.SaveChanges(); }
public static void AddUsers(HrPestContext context) { if (context.Users.Count() <= 1) { context.Users.Add(new BL.Model.User { EmailAddress = "*****@*****.**", Name = "Filip", Surname = "Doe", UserType = BL.Enum.UserType.APPLICANT, GithubAccount = "spankie1337" }); context.Users.Add(new BL.Model.User { EmailAddress = "*****@*****.**", Name = "Jane", Surname = "Doe", UserType = BL.Enum.UserType.HR }); } }
public static void AddJobOffers(HrPestContext context) { if (context.JobOffers.Count() <= 1) { context.JobOffers.Add(new BL.Model.JobOffer { CreatedBy = context.Users.Where(u => u.UserType == BL.Enum.UserType.HR).FirstOrDefault(), CreatedByEmail = "*****@*****.**", CreatedOn = DateTime.Now, CreatedFor = context.Companies.Where(x => x.Name == "Google").FirstOrDefault(), Location = "Warsaw", EmploymentType = BL.Enum.EmploymentType.B2B, ActiveUntil = DateTime.Now.AddDays(120), HoursWeekly = 40, JobBenefits = "Costam CostamCostam CostamCostam CostamCostam CostamCostam CostamCostam CostamCostam CostamCostam CostamCostam CostamCostam Costam", JobDescription = "Costam CostamCostam CostamCostam CostamCostam CostamCostam CostamCostam CostamCostam CostamCostam CostamCostam CostamCostam Costam", JobRequirements = "Costam CostamCostam CostamCostam CostamCostam CostamCostam CostamCostam CostamCostam CostamCostam CostamCostam CostamCostam Costam", MaximumPay = 10000, MinimumPay = 5000, PositionLevel = BL.Enum.PositionLevel.ENTRY_LEVEL, PositionName = "Mistrz swiata 1", RemoteHoursWeekly = 8, UsualTasks = "Costam CostamCostam CostamCostam CostamCostam CostamCostam CostamCostam CostamCostam CostamCostam CostamCostam CostamCostam Costam" }); context.JobOffers.Add(new BL.Model.JobOffer { CreatedBy = context.Users.Where(u => u.UserType == BL.Enum.UserType.HR).FirstOrDefault(), CreatedOn = DateTime.Now.AddDays(-3), CreatedByEmail = "*****@*****.**", EmploymentType = BL.Enum.EmploymentType.B2B, ActiveUntil = DateTime.Now.AddDays(-1), HoursWeekly = 40, CreatedFor = context.Companies.Where(x => x.Name == "Google").FirstOrDefault(), Location = "Warsaw", JobBenefits = "Costam CostamCostam CostamCostam CostamCostam CostamCostam CostamCostam CostamCostam CostamCostam CostamCostam CostamCostam Costam", JobDescription = "Costam CostamCostam CostamCostam CostamCostam CostamCostam CostamCostam CostamCostam CostamCostam CostamCostam CostamCostam Costam", JobRequirements = "Costam CostamCostam CostamCostam CostamCostam CostamCostam CostamCostam CostamCostam CostamCostam CostamCostam CostamCostam Costam", MaximumPay = 3000, MinimumPay = 1000, PositionLevel = BL.Enum.PositionLevel.JUNIOR, PositionName = "Mistrz swiata 2", RemoteHoursWeekly = 8, UsualTasks = "Costam CostamCostam CostamCostam CostamCostam CostamCostam CostamCostam CostamCostam CostamCostam CostamCostam CostamCostam Costam" }); context.JobOffers.Add(new BL.Model.JobOffer { CreatedBy = context.Users.Where(u => u.UserType == BL.Enum.UserType.HR).FirstOrDefault(), CreatedOn = DateTime.Now, CreatedByEmail = "*****@*****.**", EmploymentType = BL.Enum.EmploymentType.B2B, ActiveUntil = DateTime.Now.AddDays(120), HoursWeekly = 120, CreatedFor = context.Companies.Where(x => x.Name == "Google").FirstOrDefault(), Location = "Warsaw", JobBenefits = "Costam CostamCostam CostamCostam CostamCostam CostamCostam CostamCostam CostamCostam CostamCostam CostamCostam CostamCostam Costam", JobDescription = "Costam CostamCostam CostamCostam CostamCostam CostamCostam CostamCostam CostamCostam CostamCostam CostamCostam CostamCostam Costam", JobRequirements = "Costam CostamCostam CostamCostam CostamCostam CostamCostam CostamCostam CostamCostam CostamCostam CostamCostam CostamCostam Costam", MaximumPay = 10000, MinimumPay = 5000, PositionLevel = BL.Enum.PositionLevel.ENTRY_LEVEL, PositionName = "Mistrz swiata 3", RemoteHoursWeekly = 8, UsualTasks = "Costam CostamCostam CostamCostam CostamCostam CostamCostam CostamCostam CostamCostam CostamCostam CostamCostam CostamCostam Costam" }); } }
public static void DeleteUsers(HrPestContext context) { context.JobApplications.RemoveRange(context.JobApplications.Where(x => x.Id != null)); context.Users.RemoveRange(context.Users.Where(x => x.Id != null)); context.SaveChanges(); }
public static void DeleteCompanies(HrPestContext context) { context.Companies.RemoveRange(context.Companies.Where(x => x.CreatedOn != null)); context.SaveChanges(); }
public static void AddJobApplications(HrPestContext context) { if (context.JobApplications.Count() <= 1) { context.JobApplications.Add(new BL.Model.JobApplication { AdditionalInformation = "dhwudahwidhiawd", Applicant = context.Users.FirstOrDefault(x => x.Name == "Filip"), ApplicationStatus = BL.Enum.ApplicationStatus.NO_DECISION_MADE, ApplicationStatusText = EnumHelper.GetDisplayName(BL.Enum.ApplicationStatus.NO_DECISION_MADE), CreatedOn = DateTime.Now, EditedOn = DateTime.Now, ApplicantEmail = "*****@*****.**", CvHandle = "https://hrpest.blob.core.windows.net/uploads/2020-01-02/20200102T130412548.docx", JobOffer = context.JobOffers.FirstOrDefault(x => x.PositionName == "Mistrz swiata 1") }); context.JobApplications.Add(new BL.Model.JobApplication { AdditionalInformation = "dhwudahwidwadwadawdawddhiawd", Applicant = context.Users.FirstOrDefault(x => x.Name == "Jane"), ApplicationStatus = BL.Enum.ApplicationStatus.APPROVED, ApplicantEmail = "*****@*****.**", ApplicationStatusText = EnumHelper.GetDisplayName(BL.Enum.ApplicationStatus.APPROVED), CreatedOn = DateTime.Now, EditedOn = DateTime.Now, CvHandle = "https://hrpest.blob.core.windows.net/uploads/2020-01-02/20200102T130412548.docx", JobOffer = context.JobOffers.FirstOrDefault(x => x.PositionName == "Mistrz swiata 1") }); context.JobApplications.Add(new BL.Model.JobApplication { AdditionalInformation = "dhwudahwidhiawd", ApplicantEmail = "*****@*****.**", Applicant = context.Users.FirstOrDefault(x => x.Name == "Filip"), ApplicationStatus = BL.Enum.ApplicationStatus.NO_DECISION_MADE, ApplicationStatusText = EnumHelper.GetDisplayName(BL.Enum.ApplicationStatus.NO_DECISION_MADE), CreatedOn = DateTime.Now, EditedOn = DateTime.Now, CvHandle = "https://hrpest.blob.core.windows.net/uploads/2020-01-02/20200102T130412548.docx", JobOffer = context.JobOffers.FirstOrDefault(x => x.PositionName == "Mistrz swiata 1") }); context.JobApplications.Add(new BL.Model.JobApplication { AdditionalInformation = "dhwudahwidwadwadawdawddhiawd", ApplicantEmail = "*****@*****.**", Applicant = context.Users.FirstOrDefault(x => x.Name == "Jane"), ApplicationStatus = BL.Enum.ApplicationStatus.APPROVED, ApplicationStatusText = EnumHelper.GetDisplayName(BL.Enum.ApplicationStatus.APPROVED), CreatedOn = DateTime.Now, EditedOn = DateTime.Now, CvHandle = "Djwidoawdwadwadawdawdawdawdhjoiwa", JobOffer = context.JobOffers.FirstOrDefault(x => x.PositionName == "Mistrz swiata 1") }); context.JobApplications.Add(new BL.Model.JobApplication { AdditionalInformation = "dhwudahwidwadwadawdawddhiawd", ApplicantEmail = "*****@*****.**", Applicant = context.Users.FirstOrDefault(x => x.Name == "Jane"), ApplicationStatus = BL.Enum.ApplicationStatus.APPROVED, ApplicationStatusText = EnumHelper.GetDisplayName(BL.Enum.ApplicationStatus.APPROVED), CreatedOn = DateTime.Now, EditedOn = DateTime.Now, CvHandle = "Djwidoawdwadwadawdawdawdawdhjoiwa", JobOffer = context.JobOffers.FirstOrDefault(x => x.PositionName == "Mistrz swiata 1") }); context.JobApplications.Add(new BL.Model.JobApplication { AdditionalInformation = "dhwudahwidwadwadawdawddhiawd", ApplicantEmail = "*****@*****.**", Applicant = context.Users.FirstOrDefault(x => x.Name == "Jane"), ApplicationStatus = BL.Enum.ApplicationStatus.APPROVED, ApplicationStatusText = EnumHelper.GetDisplayName(BL.Enum.ApplicationStatus.APPROVED), CreatedOn = DateTime.Now, EditedOn = DateTime.Now, CvHandle = "Djwidoawdwadwadawdawdawdawdhjoiwa", JobOffer = context.JobOffers.FirstOrDefault(x => x.PositionName == "Mistrz swiata 1") }); context.JobApplications.Add(new BL.Model.JobApplication { AdditionalInformation = "dhwudahwidwadwadawdawddhiawd", ApplicantEmail = "*****@*****.**", Applicant = context.Users.FirstOrDefault(x => x.Name == "Jane"), ApplicationStatus = BL.Enum.ApplicationStatus.APPROVED, ApplicationStatusText = EnumHelper.GetDisplayName(BL.Enum.ApplicationStatus.APPROVED), CreatedOn = DateTime.Now, EditedOn = DateTime.Now, CvHandle = "Djwidoawdwadwadawdawdawdawdhjoiwa", JobOffer = context.JobOffers.FirstOrDefault(x => x.PositionName == "Mistrz swiata 1") }); context.JobApplications.Add(new BL.Model.JobApplication { AdditionalInformation = "dhwudahwidwadwadawdawddhiawd", ApplicantEmail = "*****@*****.**", Applicant = context.Users.FirstOrDefault(x => x.Name == "Jane"), ApplicationStatus = BL.Enum.ApplicationStatus.APPROVED, ApplicationStatusText = EnumHelper.GetDisplayName(BL.Enum.ApplicationStatus.APPROVED), CreatedOn = DateTime.Now, EditedOn = DateTime.Now, CvHandle = "Djwidoawdwadwadawdawdawdawdhjoiwa", JobOffer = context.JobOffers.FirstOrDefault(x => x.PositionName == "Mistrz swiata 1") }); context.JobApplications.Add(new BL.Model.JobApplication { AdditionalInformation = "dhwudahwidhiawd", ApplicantEmail = "*****@*****.**", Applicant = context.Users.FirstOrDefault(x => x.Name == "Filip"), ApplicationStatus = BL.Enum.ApplicationStatus.REJECTED, ApplicationStatusText = EnumHelper.GetDisplayName(BL.Enum.ApplicationStatus.REJECTED), CreatedOn = DateTime.Now, EditedOn = DateTime.Now, CvHandle = "Djwidoawdhjoiwa", JobOffer = context.JobOffers.FirstOrDefault(x => x.PositionName == "Mistrz swiata 2") }); context.JobApplications.Add(new BL.Model.JobApplication { AdditionalInformation = "dhwudahwidhiawd", ApplicantEmail = "*****@*****.**", Applicant = context.Users.FirstOrDefault(x => x.Name == "Filip"), ApplicationStatus = BL.Enum.ApplicationStatus.APPROVED, ApplicationStatusText = EnumHelper.GetDisplayName(BL.Enum.ApplicationStatus.APPROVED), CreatedOn = DateTime.Now, EditedOn = DateTime.Now, CvHandle = "Djwidoawdhjoiwa", JobOffer = context.JobOffers.FirstOrDefault(x => x.PositionName == "Mistrz swiata 3") }); } }
public static void AddCompanies(HrPestContext context) { if (context.Companies.Count() <= 1) { context.Companies.Add(new BL.Model.Company { CreatedOn = DateTime.Now, EditedOn = DateTime.Now, Name = "Google", Description = "DNWIJDIAWHIUDHWAIUHDIUAWHIDHUIAWYDHIUWAIUHDIUAWHDIUIWAUHDIUWAHDIUAWIHDIUHWAIHUDAW", Location = "Warsaw", NumberOfEmployees = 10000, YearOfEstablishment = 1980, DefaultEmploymentType = BL.Enum.EmploymentType.UOD, DefaultNumberOfHoursWeekly = 40, DefaultNumberOfRemoteHoursWeekly = 20 }); context.Companies.Add(new BL.Model.Company { CreatedOn = DateTime.Now, EditedOn = DateTime.Now, Name = "Microsoft", Description = "DNWIJDIAWHIUDHWAIUHDIUAWHIDHUIAWYDHIUWAIUHDIUAWHDIUIWAUHDIUWAHDIUAWIHDIUHWAIHUDAW", Location = "Sillicon Valley", NumberOfEmployees = 40, YearOfEstablishment = 1920, DefaultEmploymentType = BL.Enum.EmploymentType.UOD, DefaultNumberOfHoursWeekly = 40, DefaultNumberOfRemoteHoursWeekly = 20 }); context.Companies.Add(new BL.Model.Company { EditedOn = DateTime.Now, CreatedOn = DateTime.Now, Name = "Intel", Description = "DNWIJDIAWHIUDHWAIUHDIUAWHIDHUIAWYDHIUWAIUHDIUAWHDIUIWAUHDIUWAHDIUAWIHDIUHWAIHUDAW", Location = "Boston", NumberOfEmployees = 1000, YearOfEstablishment = 2010, DefaultEmploymentType = BL.Enum.EmploymentType.UOP, DefaultNumberOfHoursWeekly = 20, DefaultNumberOfRemoteHoursWeekly = 19 }); context.Companies.Add(new BL.Model.Company { CreatedOn = DateTime.Now, EditedOn = DateTime.Now, Name = "Apple", Description = "DNWIJDIAWHIUDHWAIUHDIUAWHIDHUIAWYDHIUWAIUHDIUAWHDIUIWAUHDIUWAHDIUAWIHDIUHWAIHUDAW", Location = "Warsaw", NumberOfEmployees = 10000, YearOfEstablishment = 1980, DefaultEmploymentType = BL.Enum.EmploymentType.UOZ, DefaultNumberOfHoursWeekly = 40, DefaultNumberOfRemoteHoursWeekly = 20 }); context.Companies.Add(new BL.Model.Company { CreatedOn = DateTime.Now, EditedOn = DateTime.Now, Name = "HP", Description = "DNWIJDIAWHIUDHWAIUHDIUAWHIDHUIAWYDHIUWAIUHDIUAWHDIUIWAUHDIUWAHDIUAWIHDIUHWAIHUDAW", Location = "Sillicon Valley", NumberOfEmployees = 40, YearOfEstablishment = 1980, DefaultEmploymentType = BL.Enum.EmploymentType.OTHER, DefaultNumberOfHoursWeekly = 40, DefaultNumberOfRemoteHoursWeekly = 20 }); context.Companies.Add(new BL.Model.Company { EditedOn = DateTime.Now, CreatedOn = DateTime.Now, Name = "TescikTescik", Description = "DNWIJDIAWHIUDHWAIUHDIUAWHIDHUIAWYDHIUWAIUHDIUAWHDIUIWAUHDIUWAHDIUAWIHDIUHWAIHUDAW", Location = "Boston", NumberOfEmployees = 1000, YearOfEstablishment = 1980, DefaultEmploymentType = BL.Enum.EmploymentType.B2B, DefaultNumberOfHoursWeekly = 40, DefaultNumberOfRemoteHoursWeekly = 20 }); } }