//Изменение Должности PUT
//public static void PutJobPosition(JobPositionTable job)
//{
// string EditJobPosition = @"
// UPDATE JobPosition SET
// JobPosition='" + job.JobPosition + @"'
// WHERE Id='" + job.Id + @"'";
// using (SqlConnection connection = new SqlConnection(connectionString))
// {
// connection.Open();
// SqlCommand command = new SqlCommand(EditJobPosition, connection);
// command.ExecuteNonQuery();
// }
//}
public void Update(JobPositionTable jobPosition)
{
using (IDbConnection db = new SqlConnection(connectionString))
{
var sqlQuery = "UPDATE JobPosition SET JobPosition= @JobPosition WHERE Id = @id";
db.Execute(sqlQuery, jobPosition);
}
}
//Добавление Должности POST
//public static void PostJobPosition(JobPositionTable job)
//{
// string AddJobPosition = @"INSERT INTO JobPosition
// (JobPosition) VALUES
// ('" + job.JobPosition + @"')";
// using (SqlConnection connection = new SqlConnection(connectionString))
// {
// connection.Open();
// SqlCommand command = new SqlCommand(AddJobPosition, connection);
// command.ExecuteNonQuery();
// }
//}
public void Create(JobPositionTable jobPosition)
{
using (IDbConnection db = new SqlConnection(connectionString))
{
var sqlQuery = "INSERT INTO JobPosition (JobPosition) VALUES (@JobPosition)";
db.Execute(sqlQuery, jobPosition);
}
}
public JsonResult Put(JobPositionTable job)
{
_jobPositionTable.Update(job);
//JobPositionManager.PutJobPosition(job);
return(new JsonResult("Put запрос выполнен!"));
}
public JsonResult Post(JobPositionTable job)
{
_jobPositionTable.Create(job);
//JobPositionManager.PostJobPosition(job);
return(new JsonResult("Post запрос выполнен!"));
}
