/// <summary> /// /// </summary> /// <param name="employer"></param> /// <returns></returns> public bool DeleteEmployer(Entities.Employer employer) { bool isDeleted = false; try { using (DbCommand dbCommand = database.GetStoredProcCommand(DBStoredProcedure.DeleteEmployer)) { database.AddInParameter(dbCommand, "@employer_id", DbType.Int32, employer.EmployerId); database.AddInParameter(dbCommand, "@deleted_by", DbType.Int32, employer.DeletedBy); database.AddInParameter(dbCommand, "@deleted_by_ip", DbType.String, employer.DeletedByIP); database.AddOutParameter(dbCommand, "@return_value", DbType.Int32, 0); var result = database.ExecuteNonQuery(dbCommand); if (database.GetParameterValue(dbCommand, "@return_value") != DBNull.Value) { isDeleted = Convert.ToBoolean(database.GetParameterValue(dbCommand, "@return_value")); } } } catch (Exception e) { throw e; } return(isDeleted); }
/// <summary> /// /// </summary> /// <param name="employerId"></param> /// <returns></returns> public Entities.Employer GetEmployerDetailsById(Int32 employerId) { var employer = new Entities.Employer(); using (DbCommand dbCommand = database.GetStoredProcCommand(DBStoredProcedure.GetEmployerDetailsById)) { database.AddInParameter(dbCommand, "@employer_id", DbType.Int32, employerId); using (IDataReader reader = database.ExecuteReader(dbCommand)) { while (reader.Read()) { var _employer = new Entities.Employer { EmployerId = DRE.GetNullableInt32(reader, "employer_id", null), EmployerName = DRE.GetNullableString(reader, "employer_name", null), EmployerAddress = DRE.GetNullableString(reader, "employer_address", null), CountryId = DRE.GetNullableInt32(reader, "country_id", null), StateId = DRE.GetNullableInt32(reader, "state_id", null), CityId = DRE.GetNullableInt32(reader, "city_id", null), PinCode = DRE.GetNullableString(reader, "pin_code", null), Website = DRE.GetNullableString(reader, "website", null), GSTINNo = DRE.GetNullableString(reader, "gstin_no", null) }; employer = _employer; } } } return(employer); }
public List <Entities.Employer> GetEmployerIdAndNameByName(string employerName) { var employers = new List <Entities.Employer>(); try { using (DbCommand dbCommand = database.GetStoredProcCommand(DBStoredProcedure.GetEmployerIdAndNameByName)) { database.AddInParameter(dbCommand, "@employer_name", DbType.String, employerName); using (IDataReader reader = database.ExecuteReader(dbCommand)) { while (reader.Read()) { var employer = new Entities.Employer { EmployerId = DRE.GetNullableInt32(reader, "employer_id", 0), EmployerName = DRE.GetNullableString(reader, "employer_name", null) }; employers.Add(employer); } } } } catch (Exception ex) { throw ex; } return(employers); }
public async Task Execute(Entities.Employer employer) { _fileUploadContext.Employer.Update(employer).State = EntityState.Modified; int updatedRecordCount; try { updatedRecordCount = await _fileUploadContext.SaveAsync(); } catch (DbUpdateException due) { // Log throw; } }
public async Task Execute(Entities.Employer employer) { _fileUploadContext.Employer.Add(employer); int createdRecordCount; try { createdRecordCount = await _fileUploadContext.SaveAsync(); } catch (DbUpdateException due) { // Log throw; } }
public Int32 SaveEmployer(Entities.Employer employer) { var employerId = 0; if (employer.EmployerId == null || employer.EmployerId == 0) { employerId = AddEmployer(employer); } else if (employer.ModifiedBy != null || employer.ModifiedBy > 0) { employerId = UpdateEmployer(employer); } else if (employer.IsDeleted == true) { var result = DeleteEmployer(employer); } return(employerId); }
public static Entities.Employer Map(FileUploadEmployer fileEmployer, Entities.Employer employer) { if (employer == null) { employer = new Entities.Employer { Id = fileEmployer.Account }; } Enum.TryParse(fileEmployer.Aupa, out AupaStatus aupa); var companyType = GetCompanyType(fileEmployer.CompanyType); employer.AlsoKnownAs = fileEmployer.CompanyAka; employer.AupaStatus = (int)aupa; employer.CompanyName = fileEmployer.CompanyName; employer.CompanyType = (int)companyType; employer.CreatedOn = fileEmployer.Created; return(employer); }
public List <Entities.Employer> SearchEmployerByName(string employerName) { var employers = new List <Entities.Employer>(); try { using (DbCommand dbCommand = database.GetStoredProcCommand(DBStoredProcedure.SearchEmployerByName)) { database.AddInParameter(dbCommand, "@employer_name", DbType.String, employerName); using (IDataReader reader = database.ExecuteReader(dbCommand)) { while (reader.Read()) { var employer = new Entities.Employer { EmployerId = DRE.GetNullableInt32(reader, "employer_id", 0), EmployerName = DRE.GetNullableString(reader, "employer_name", null), EmployerAddress = DRE.GetNullableString(reader, "employer_address", null), CountryName = DRE.GetNullableString(reader, "country_name", null), StateName = DRE.GetNullableString(reader, "state_name", null), CityName = DRE.GetNullableString(reader, "city_name", null), PinCode = DRE.GetNullableString(reader, "pin_code", null), Website = DRE.GetNullableString(reader, "website", null), GSTINNo = DRE.GetNullableString(reader, "gstin_no", null) }; employers.Add(employer); } } } } catch (Exception ex) { throw ex; } return(employers); }
/// <summary> /// /// </summary> /// <param name="employer"></param> /// <returns></returns> private Int32 AddEmployer(Entities.Employer employer) { var employerId = 0; try { using (DbCommand dbCommand = database.GetStoredProcCommand(DBStoredProcedure.InsertEmployer)) { database.AddInParameter(dbCommand, "@employer_id", DbType.Int32, employer.EmployerId); database.AddInParameter(dbCommand, "@employer_name", DbType.String, employer.EmployerName); database.AddInParameter(dbCommand, "@employer_address", DbType.String, employer.EmployerAddress); database.AddInParameter(dbCommand, "@country_id", DbType.Int32, employer.CountryId); database.AddInParameter(dbCommand, "@state_id", DbType.Int32, employer.StateId); database.AddInParameter(dbCommand, "@city_id", DbType.Int32, employer.CityId); database.AddInParameter(dbCommand, "@pin_code", DbType.String, employer.PinCode); database.AddInParameter(dbCommand, "@website", DbType.String, employer.Website); database.AddInParameter(dbCommand, "@gstin_no", DbType.String, employer.GSTINNo); database.AddInParameter(dbCommand, "@created_by", DbType.Int32, employer.CreatedBy); database.AddInParameter(dbCommand, "@created_by_ip", DbType.String, employer.CreatedByIP); database.AddOutParameter(dbCommand, "@return_value", DbType.Int32, 0); employerId = database.ExecuteNonQuery(dbCommand); if (database.GetParameterValue(dbCommand, "@return_value") != DBNull.Value) { employerId = Convert.ToInt32(database.GetParameterValue(dbCommand, "@return_value")); } } } catch (Exception e) { throw e; } return(employerId); }
public Int32 SaveEmployer(Entities.Employer employer) { return(_employer.SaveEmployer(employer)); }
public static void Start(Entities.Employer employer, Database.Database db) { var logger = new Logger.ConsoleLogger(); var seeCvsLoop = true; var mainCvs = db.GetCvs(); IList <Cv> cvs = mainCvs; while (seeCvsLoop) { Console.Clear(); ExceptionHandle.Handle(CvHelper.SeeCvs, cvs); ConsoleScreen.PrintMenu(ConsoleScreen.FilterMenu, ConsoleColor.Blue); var filterMenuChoice = (FilterMenuEnum)ConsoleScreen.Input(ConsoleScreen.FilterMenu.Count); switch (filterMenuChoice) { case FilterMenuEnum.Select: { var loop3 = true; while (loop3) { Console.Clear(); if (!ExceptionHandle.Handle(CvHelper.SeeCvs, cvs)) { break; } Console.WriteLine("Cv id: "); var cvId = UserHelper.InputGuid(); try { var cv = CvHelper.GetCv(cvId, cvs); Console.Clear(); while (true) { var requestFromEmployer = cv.CheckEmployerRequest(employer.Guid); Console.Clear(); Console.WriteLine(cv++); // increase view count and print. Database.Database.Changes = true; Console.WriteLine(); Console.WriteLine($"1. {(requestFromEmployer ? "Cancel" : "Request")}"); Console.WriteLine("2. Back"); var choice = ConsoleScreen.Input(2); if (choice == 1) { if (requestFromEmployer) { cv.RemoveRequest(employer.Guid); } else { Vacancy vacancy = null; while (true) { Console.Clear(); if (!ExceptionHandle.Handle(employer.ShowAllAds, true)) { LoggerPublisher.OnLogInfo("Please add public Vacancy!"); ConsoleScreen.Clear(); break; } var vacancyId = UserHelper.InputGuid(); try { vacancy = VacancyHelper.GetVacancy(vacancyId, employer.Vacancies); break; } catch (Exception e) { LoggerPublisher.OnLogError(e.Message); ConsoleScreen.Clear(); } } if (vacancy != null) { cv.SendRequest(employer.Guid, vacancy.Guid); } } } else if (choice == 2) { if (ConsoleScreen.DisplayMessageBox("Info", "Do you want to see other Cvs?", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.No) { loop3 = false; } break; } } if (loop3) { continue; } } catch (Exception e) { LoggerPublisher.OnLogError(e.Message); } } break; } case FilterMenuEnum.ByCategory: { Console.Clear(); cvs = ExceptionHandle.Handle(CvFilter.FilterByCategory, UserHelper.InputCategory(), cvs); break; } case FilterMenuEnum.ByEducation: { Console.Clear(); cvs = ExceptionHandle.Handle(CvFilter.FilterByEducation, UserHelper.InputEducation(), cvs); break; } case FilterMenuEnum.ByExperience: { Console.Clear(); cvs = ExceptionHandle.Handle(CvFilter.FilterByExperience, UserHelper.InputExperience(), cvs); break; } case FilterMenuEnum.ByRegion: { Console.Clear(); cvs = ExceptionHandle.Handle(CvFilter.FilterByRegion, UserHelper.InputRegion(), cvs); break; } case FilterMenuEnum.BySalary: { Console.Clear(); var input = UserHelper.InputSalary(); var salary = UserHelper.ParseSalary(input); cvs = ExceptionHandle.Handle(CvFilter.FilterBySalary, salary, cvs); break; } case FilterMenuEnum.Reset: { cvs = mainCvs; break; } case FilterMenuEnum.Back: { seeCvsLoop = false; break; } } } }
public static void Start(Entities.Employer employer, Database.Database db) { var employerSideMainLoop = true; while (employerSideMainLoop) { Console.Title = $"Employer: {employer.Name}"; if (Database.Database.Changes) { FileHelper.WriteToJson(db); Database.Database.Changes = false; } Console.Clear(); ConsoleScreen.PrintMenu(ConsoleScreen.EmployerSideMainMenu, ConsoleColor.DarkGreen); var employerSideChoice = (EmployerSideMainMenu)ConsoleScreen.Input(ConsoleScreen.EmployerSideMainMenu.Count); Console.Clear(); switch (employerSideChoice) { case EmployerSideMainMenu.YourAds: { AdsSection.Start(employer); break; } case EmployerSideMainMenu.SeeCvs: { CvSection.Start(employer, db); break; } case EmployerSideMainMenu.AdsNotifications: { while (true) { Console.Clear(); if (!ExceptionHandle.Handle(employer.ShowAllAdsWithRequestCount)) { break; } var vacancyId = UserHelper.InputGuid(); Vacancy vacancy = null; try { vacancy = employer.GetVacancy(vacancyId); if (vacancy.RequestsFromWorkers.Count != 0) { var cvs = db.GetAllCvFromRequests(vacancy.RequestsFromWorkers); while (true) { Console.Clear(); if (!ExceptionHandle.Handle(EmployerHelper.ShowCvs, cvs)) { break; } var cvId = UserHelper.InputGuid(); var cv = cvs.SingleOrDefault(c => c.Guid == cvId); if (cv == null) { LoggerPublisher.OnLogError($"There is no cv associated this id -> {cvId}"); ConsoleScreen.Clear(); continue; } var worker = DatabaseHelper.GetUser(vacancy.RequestsFromWorkers .SingleOrDefault(r => r.Value == cv.Guid).Key, db.Users) as Worker; Console.Clear(); Console.WriteLine(cv); ConsoleScreen.PrintMenu(ConsoleScreen.CvAdsChoices, ConsoleColor.DarkGreen); var choice = (CvAdsChoices)ConsoleScreen.Input(ConsoleScreen.CvAdsChoices.Count); if (choice == CvAdsChoices.Back) { break; } try { switch (choice) { case CvAdsChoices.Accept: { vacancy.RemoveRequest(worker.Guid); NotificationPublisher.OnSend(worker, new Notification() { Title = "Your apply result", Message = $"Congratilations. Your cv accepted.\n Vacancy info:\n{vacancy}" }); LoggerPublisher.OnLogInfo("Accepted."); break; } case CvAdsChoices.Decline: { vacancy.RemoveRequest(worker.Guid); NotificationPublisher.OnSend(worker, new Notification() { Title = "Your apply result", Message = $"We are sorry! Your cv declined.\n Vacancy info:\n{vacancy}" }); LoggerPublisher.OnLogInfo("Declined."); break; } } } catch (Exception e) { LoggerPublisher.OnLogError(e.Message); ConsoleScreen.Clear(); } Database.Database.Changes = true; if (ConsoleScreen.DisplayMessageBox("Info", "Do you want to see other Cvs?", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.No) { break; } } } else { LoggerPublisher.OnLogError("There is no request!"); ConsoleScreen.Clear(); } } catch (Exception e) { LoggerPublisher.OnLogError(e.Message); ConsoleScreen.Clear(); } if (vacancy == null && ConsoleScreen.DisplayMessageBox("Info", "Do you want to try again?", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.No) { break; } } break; } case EmployerSideMainMenu.AllNotifications: { NotificationSide.AllNotificationsStart(employer); break; } case EmployerSideMainMenu.UnreadNotifications: { NotificationSide.OnlyUnReadNotificationsStart(employer); break; } case EmployerSideMainMenu.Logout: { employerSideMainLoop = false; break; } } } }
private static void RegisterSide(Database.Database db) { while (true) { Console.Title = "Register"; GetUserData(db, out string name, out string surname, out string mail, out string phone, out string username, out string password, out int age, out string city); User newUser = null; Console.Clear(); Console.WriteLine("Who are you?"); ConsoleScreen.PrintMenu(ConsoleScreen.UserType, ConsoleColor.Blue); var userType = (UserTypeEnum)(ConsoleScreen.Input(ConsoleScreen.UserType.Count)); Console.Clear(); if (userType == UserTypeEnum.Worker) { newUser = new Worker() { Name = name, Surname = surname, Mail = mail, Phone = phone, Username = username, Password = password, City = city, Age = age, } } ; else { newUser = new Entities.Employer() { Name = name, Surname = surname, Mail = mail, Phone = phone, Username = username, Password = password, City = city, Age = age, } }; try { UpWork.UserAccess.UserAccess.SendConfirmationCode(newUser.Mail); while (true) { Console.Clear(); Console.WriteLine("Confirmation code: "); if (UpWork.UserAccess.UserAccess.ConfirmationCode == UserHelper.GetNumeric(NumericTypes.INT).ToString()) { break; } LoggerPublisher.OnLogError("Confirmation code is wrong!"); } UpWork.UserAccess.UserAccess.Register(newUser, db.Users); FileHelper.WriteToJson(db); LoggerPublisher.OnLogInfo("Successfully created account. You can login now."); ConsoleScreen.Clear(); break; } catch (Exception e) { LoggerPublisher.OnLogError(e.Message); ConsoleScreen.Clear(); } } }
public static void Start(Entities.Employer employer) { var adsSectionLoop = true; while (adsSectionLoop) { Console.Clear(); ConsoleScreen.PrintMenu(ConsoleScreen.AdsSectionMenu, ConsoleColor.DarkGreen); var adsSectionChoice = (AdsSectionEnum)ConsoleScreen.Input(ConsoleScreen.AdsSectionMenu.Count); Console.Clear(); switch (adsSectionChoice) { case AdsSectionEnum.Show: { ExceptionHandle.Handle(employer.ShowAllAds, false); ConsoleScreen.Clear(); break; } case AdsSectionEnum.Add: { var addCvLoop = true; while (addCvLoop) { employer.Vacancies.Add(CreateNewVacancy()); LoggerPublisher.OnLogInfo("Vacancy added!"); if (ConsoleScreen.DisplayMessageBox("Info", "Do you want to add more Vacancy?", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.No) { addCvLoop = false; } Console.Clear(); } Database.Database.Changes = true; break; } case AdsSectionEnum.Update: { while (true) { Console.Clear(); if (!ExceptionHandle.Handle(employer.ShowAllAds, false)) { ConsoleScreen.Clear(); break; } var id = UserHelper.InputGuid(); try { var vacancy = employer.GetVacancy(id); VacancyUpdateSideStart(vacancy); if (ConsoleScreen.DisplayMessageBox("Info", "Do you want to update another Vacancy?", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.No) { break; } continue; } catch (Exception e) { LoggerPublisher.OnLogError(e.Message); } if (ConsoleScreen.DisplayMessageBox("Info", "Do you want to try again?", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.No) { break; } } break; } case AdsSectionEnum.Delete: { while (true) { Console.Clear(); if (!ExceptionHandle.Handle(employer.ShowAllAds, false)) { ConsoleScreen.Clear(); break; } var vacancyId = UserHelper.InputGuid(); if (ExceptionHandle.Handle(employer.DeleteVacancy, vacancyId)) { LoggerPublisher.OnLogInfo("Cv deleted!"); Database.Database.Changes = true; if (employer.Vacancies.Count == 0 || ConsoleScreen.DisplayMessageBox("Info", "Do you want to delete another Vacancy?", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.No) { break; } continue; } if (ConsoleScreen.DisplayMessageBox("Info", "Do you want to try again?", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.No) { break; } } break; } case AdsSectionEnum.Back: { adsSectionLoop = false; break; } } } }