public static tblVacancy ConvertTotblVacancy(this VacancyModel data) { return(new tblVacancy() { ID = Convert.ToInt64(data.id), VacancyType = data.vacancyType, CustomerID = data.customerId, StartDate = data.startDate, EndDate = data.endDate, SubmissionDueDate = data.submissionDueDate, HiringManager = data.hiringManager, ReportingManager = data.reportingManager, PositionTitle = data.positionTitle, NoOfPositions = data.noOfPositions, VacancyDescription = data.vacancyDescription, YearOfExperience = data.yearOfExperience.ToString(), ShowCustomerDetailsToSupplier = data.showCustomerDetailsToSupplier, MinPayRate = data.minPayRate, MaxPayRate = data.maxPayRate, TargetPayRate = data.targetPayRate, PayRateMarkUp = data.payRateMarkUp, IsActive = data.isActive, IsDeleted = data.isDeleted ?? false, CreatedUserID = data.createdUserID, UpdatedUserID = data.updatedUserID, CreatedTimestamp = data.createdTimestamp ?? DateTime.Now, UpdatedTimestamp = data.updatedTimestamp ?? DateTime.Now, JobStatusID = Convert.ToInt16(data.jobStatusId ?? null) }); }
private async Task Insert(IDbConnection connection, VacancyModel vacancy) { var sql = @" INSERT INTO vacancies(Id, Name, SalaryFrom, SalaryTo, Organization, ContactFullName, Address, Phone, Type, Description, Requierments, Responsibility) VALUES (@Id, @Name, @SalaryFrom, @SalaryTo, @Organization, @ContactFullName, @Address, @Phone, @Type, @Description, @Requierments, @Responsibility)"; await connection.ExecuteAsync(sql, vacancy); }
/// <summary> /// Добавляет вакансию /// </summary> /// <param name="vacancy"></param> /// <returns></returns> public bool InsertVacancy(VacancyModel vacancy) { using (var db = new CMSdb(_context)) { using (var tr = db.BeginTransaction()) { var log = new LogModel { PageId = vacancy.Id, PageName = vacancy.Title, Section = LogModule.Vacancies, Action = LogAction.insert }; InsertLog(log); bool result = db.vacancy_vacancies.Insert(() => new vacancy_vacancies { id = vacancy.Id, c_title = vacancy.Title, c_text = vacancy.Text, c_experience = vacancy.Experience, c_salary = vacancy.Salary, b_temporary = vacancy.IsTemporary, d_date = vacancy.Date, b_disabled = vacancy.IsDisabled, f_site = _siteId }) > 0; tr.Commit(); return(result); } } }
/// <summary> /// Обновляет вакансию /// </summary> /// <param name="vacancy"></param> /// <returns></returns> public bool UpdateVacancy(VacancyModel vacancy) { using (var db = new CMSdb(_context)) { using (var tr = db.BeginTransaction()) { var log = new LogModel { PageId = vacancy.Id, PageName = vacancy.Title, Section = LogModule.Vacancies, Action = LogAction.update }; InsertLog(log); bool result = db.vacancy_vacancies .Where(w => w.id == vacancy.Id) .Set(s => s.c_title, vacancy.Title) .Set(s => s.c_text, vacancy.Text) .Set(s => s.c_experience, vacancy.Experience) .Set(s => s.c_salary, vacancy.Salary) .Set(s => s.b_temporary, vacancy.IsTemporary) .Set(s => s.d_date, vacancy.Date) .Set(s => s.b_disabled, vacancy.IsDisabled) .Update() > 0; tr.Commit(); return(result); } } }
public async Task <bool> CreateVacancy(VacancyModel data) { _ = await _dbContext.AddAsync(data); var saved = await _dbContext.SaveChangesAsync() > 0; return(saved); }
public static void DummyData() { VacancyListModels.Clear(); for (int i = 0; i <= 20; ++i) { VacancyModel model = new VacancyModel(); model.Title = "Sentimus Title" + i; model.Salary = "1000" + i; VacancyListModels.Add(model); } }
protected override bool Check(VacancyModel vacancy) { if (vacancy.Salary == null) { return(false); } var salary = vacancy.Salary ?? 0; var isValid = CheckMin(salary) && CheckMax(salary); return(isValid); }
public static VacancyResponse ToResponse( this VacancyModel model, IDatabaseOrganizationService organizationService) => new VacancyResponse { Id = model.Id, Title = model.Title, Salary = model.Salary, Description = model.Description, Organization = ((model.Organization == null) ? organizationService.Get(model.OrganizationId) : model.Organization ).ToResponse(), EmploymentType = model.EmploymentType?.ToList()?.ToStringName(), ContactPerson = model.ContactPerson, ContactPhone = model.ContactPhone, LastUpdated = model.LastUpdated, CreatedAt = model.CreatedAt };
public ActionResult EditVacancy(VacancyModel model) { if (ModelState.IsValid) { Vacancy vacancy = new Vacancy(); VacancyReposit vacancyreposit = new VacancyReposit(); VacancyModel vacancyModel = new VacancyModel(); vacancy = vacancyreposit.GetVacancyForId(model.Id); vacancy.Name = model.Name; vacancy.Description = model.Description; vacancy.Time = model.Time; vacancy.CompanyName = model.CompanyName; vacancy.Request = model.Request; vacancy.Pay = model.Pay; vacancy.OpenVacancy = model.OpenVacancy; vacancyreposit.Update(vacancy); } return(RedirectToAction("Index", "V1")); }
public ActionResult EditVacancy(string id) { int realId = Int32.Parse(id); Vacancy vacancy = new Vacancy(); VacancyReposit vacancyreposit = new VacancyReposit(); VacancyModel vacancyModel = new VacancyModel(); vacancy = vacancyreposit.GetVacancyForId(realId); vacancyModel.Id = vacancy.Id; vacancyModel.Name = vacancy.Name; vacancyModel.Description = vacancy.Description; vacancyModel.Time = vacancy.Time; vacancyModel.CompanyName = vacancy.CompanyName; vacancyModel.Request = vacancy.Request; vacancyModel.Pay = vacancy.Pay; vacancyModel.NameAutor = vacancy.NameAutor; vacancyModel.OpenVacancy = vacancy.OpenVacancy; return(View(vacancyModel)); }
public VacancyModel Convert(Vacancy vacancy) { var model = new VacancyModel(); model.Id = Guid.NewGuid(); model.Name = vacancy.Name; model.Organization = vacancy.Employer?.Name; model.Phone = GetContactPhone(vacancy); model.ContactFullName = vacancy.Contacts?.Name; model.Address = GetAddress(vacancy); model.SalaryFrom = GetSalaryFrom(vacancy); model.SalaryTo = GetSalaryTo(vacancy); model.Type = GetType(vacancy); model.Description = vacancy.Description; model.Requierments = vacancy.Snippet?.Requirement; model.Responsibility = vacancy.Snippet?.Responsibility; return(model); }
public static VacancyModel ToModel( this VacancyCreateModel request, IDatabaseOrganizationService organizationService) { var result = new VacancyModel { Title = request.Title, Salary = request.Salary, Description = request.Description, ContactPhone = request.ContactPhone, ContactPerson = request.ContactPerson, EmploymentType = request.EmploymentType }; var organizationName = request.Organization; result.OrganizationId = organizationService.CreateIfAbsent(organizationName); return(result); }
public ActionResult CreateVacancy(VacancyModel model) { Logger.Info("Создание вакансии {0} с названием {1}", model.CompanyName, model.Name); if (!ModelState.IsValid) { return(View()); } _jobVacancyService.AddVacancy(new Entities.JobVacancy() { Name = model.Name, CompanyName = model.CompanyName, Date = model.Date, Description = model.Description, Requirements = model.Requirements, Salary = model.Salary, User = _userService.GetByLogin(User.Identity.Name) // Needs current user }); return(Redirect("../Home/Index")); }
public async Task <IActionResult> UpdateOrCreate([FromBody] VacancyModel model) { var user = await _crudService.Find <User>(u => u.Id == _webSession.UserId); if (String.IsNullOrEmpty(user.Profile.Name)) { return(BadRequest(ValidationResultMessages.CantCreateVacancyProfileEmpty)); } var vacancy = await _crudService.Find <Vacancy>(v => v.UserId == _webSession.UserId && v.Id == model.Id); if (vacancy == null) { model.Date = DateTime.Now; vacancy = Mapper.Map <Vacancy>(model); vacancy.UserId = _webSession.UserId; vacancy = await _crudService.Create(vacancy); model.Id = vacancy.Id; } else { await _crudService.Update <VacancyModel, Vacancy>(model.Id, model, (to, from) => { to.Description = from.Description; to.Title = from.Title; to.IsClosed = from.IsClosed; to.VacancyFilter.MinExpirience = from.VacancyFilter.MinExpirience; to.VacancyFilter.MinRating = from.VacancyFilter.MinRating; to.VacancyFilter.JsonMusicianRoles = from.VacancyFilter.MusicianRoles.ToJson(); to.VacancyFilter.JsonMusicGenres = from.VacancyFilter.MusicGenres.ToJson(); to.VacancyFilter.JsonCities = from.VacancyFilter.Cities.ToJson(); to.VacancyFilter.JsonWorkTypes = from.VacancyFilter.WorkTypes.ToJson(); }); } return(Ok(model)); }
private static List <VacancyModel> CreateModels(IEnumerable xelements) { List <VacancyModel> vacancyModels = new List <VacancyModel>(); foreach (XElement e in xelements) { VacancyModel vModel = new VacancyModel(); if (e.Element("id") != null) { vModel.ID = e.Element("id").Value; } if (e.Element("summary") != null) { vModel.Summary = e.Element("summary").Value; } if (e.Element("title") != null) { vModel.Title = e.Element("title").Value; } if (e.Element("description") != null) { vModel.Description = e.Element("description").Value; } if (e.Element("salary") != null) { vModel.Salary = e.Element("salary").Value; } if (e.Element("city") != null) { vModel.City = e.Element("city").Value; } if (e.Element("zip") != null) { vModel.Zip = e.Element("zip").Value; } vacancyModels.Add(vModel); } return(vacancyModels); }
/// <inheritdoc/> public string AddVacancy(string title, string salar, string organization, string contactPerson, string numberPhone, string employmentType, string vacancyDescription) { var newVacancy = new VacancyModel() { Title = title, Salary = float.Parse(salar), Organization = organization, ContactPerson = contactPerson, NumberPhone = numberPhone, EmploymentType = employmentType, VacancyDescription = vacancyDescription }; using (var context = new DataBaseContext()) { context.VacancyModels.Add(newVacancy); context.SaveChanges(); var addVacancy = new VacancyViewModel(); //addVacancy.AddVacancy(newVacancy); return("Вакансия добавлена"); } }
protected abstract bool Check(VacancyModel vacancy);
protected override bool Check(VacancyModel vacancy) => Predicates.All((predicate) => predicate(vacancy));
protected override bool Check(VacancyModel vacancy) => CheckMethods.All((method) => method(vacancy));
public ActionResult RegVac(VacancyModel model) { if (ModelState.IsValid) { string connectionString = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\Igory\source\ElmaTask\ElmaTask\ElmaTask\App_Data\DB.mdf;Integrated Security=True"; SqlConnection connection = new SqlConnection(connectionString); connection.Open(); string sqlExpression = "SaveVac"; SqlCommand command = new SqlCommand(sqlExpression, connection); command.CommandType = System.Data.CommandType.StoredProcedure; SqlParameter nameParam = new SqlParameter { ParameterName = "@Name", Value = model.Name }; command.Parameters.Add(nameParam); SqlParameter DescriptionParam = new SqlParameter { ParameterName = "@Description", Value = model.Description }; command.Parameters.Add(DescriptionParam); SqlParameter TimeParam = new SqlParameter { ParameterName = "@Time", Value = model.Time }; command.Parameters.Add(TimeParam); SqlParameter CompanyNameParam = new SqlParameter { ParameterName = "@CompanyName", Value = model.CompanyName }; command.Parameters.Add(CompanyNameParam); SqlParameter RequestParam = new SqlParameter { ParameterName = "@Request", Value = model.Request }; command.Parameters.Add(RequestParam); SqlParameter PayParam = new SqlParameter { ParameterName = "@Pay", Value = model.Pay }; command.Parameters.Add(PayParam); SqlParameter NameAutorParam = new SqlParameter { ParameterName = "@NameAutor", Value = User.Identity.Name }; command.Parameters.Add(NameAutorParam); SqlParameter OpenParam = new SqlParameter { ParameterName = "@OpenVacancy", Value = true }; command.Parameters.Add(OpenParam); command.ExecuteScalar(); UserReposit userReposit = new UserReposit(); var user = userReposit.GetLogin(User.Identity.Name); user.CountVacancy++; userReposit.Update(user); connection.Close(); } return(RedirectToAction("Index", "V1")); }
protected override bool Check(VacancyModel vacancy) => vacancy.OrganizationId == Id;
public string Add(VacancyModel vacancy) => VacancyService.Add(vacancy);