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