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