public IHttpActionResult PostCompanyPosition(CompanyPosition companyPosition)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.CompanyPositions.Add(companyPosition);
try
{
db.SaveChanges();
}
catch (DbUpdateException)
{
if (CompanyPositionExists(companyPosition.Name))
{
return(Conflict());
}
else
{
throw;
}
}
return(CreatedAtRoute("DefaultApi", new { id = companyPosition.Name }, companyPosition));
}
public IHttpActionResult PutCompanyPosition(string id, CompanyPosition companyPosition)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != companyPosition.Name)
{
return(BadRequest());
}
db.Entry(companyPosition).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!CompanyPositionExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public CompanyPosition Post([FromBody] CompanyPosition model)
{
// POST: api/User
// this post method insert the new row or update the current row if there is a record with same ID
CompanyPositionDE de = new CompanyPositionDE();
CompanyPosition sonuc = de.AddCompanyPosition(model);
return(sonuc);
}
public IEnumerable <CompanyPosition> Get(int id)
{
// GET: api/CompanyPosition
//HttpContext.RiseError(new InvalidOperationException("Test"));
CompanyPosition model = new CompanyPosition();
CompanyPositionDE de = new CompanyPositionDE();
return(de.GetCompanyPosition(id));
}
public IHttpActionResult GetCompanyPosition(string id)
{
CompanyPosition companyPosition = db.CompanyPositions.Find(id);
if (companyPosition == null)
{
return(NotFound());
}
return(Ok(companyPosition));
}
public IHttpActionResult DeleteCompanyPosition(string id)
{
CompanyPosition companyPosition = db.CompanyPositions.Find(id);
if (companyPosition == null)
{
return(NotFound());
}
db.CompanyPositions.Remove(companyPosition);
db.SaveChanges();
return(Ok(companyPosition));
}
public IActionResult Put([FromBody] CompanyPosition model)
{
// POST: api/CompanyPosition
// this post method insert the new row or update the current row if there is a record with same ID
CompanyPositionDE de = new CompanyPositionDE();
bool sonuc = de.UpdateCompanyPosition(model);
if (sonuc)
{
return(Ok());
}
else
{
return(NotFound());
}
}
public CompanyPosition AddCompanyPosition(CompanyPosition cp)
{
if (cp != null)
{
var paramu = new
{
Title = cp.Title,
CompanyID = cp.Company.CompanyID
};
using (IDbConnection cnn = new SqlConnection(Helper.GetConnectionString()))
{
string sql = "dbo.SP_CompanyPositionSET";
CompanyPosition us = cnn.QuerySingle <CompanyPosition>(sql, paramu,
commandType: CommandType.StoredProcedure);
return(us);
}
}
else
{
return(null);
}
}
public bool UpdateCompanyPosition(CompanyPosition cp)
{
if (cp != null)
{
var paramu = new
{
CompanyPositionID = cp.CompanyPositionID,
Title = cp.Title,
CompanyID = cp.Company.CompanyID
};
using (IDbConnection cnn = new SqlConnection(Helper.GetConnectionString()))
{
string sql = "dbo.SP_CompanyPositionUpdate";
int affectedRow = int.Parse(cnn.ExecuteScalar(sql, paramu,
commandType: CommandType.StoredProcedure).ToString());
return(affectedRow > 0 ? true : false);
}
}
else
{
return(false);
}
}
