public IHttpActionResult PutSOFR(int id, SOFR sOFR)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != sOFR.Id)
{
return(BadRequest());
}
db.Entry(sOFR).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!SOFRExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult GetSOFR(int id)
{
SOFR sOFR = db.SOFRs.Find(id);
if (sOFR == null)
{
return(NotFound());
}
return(Ok(sOFR));
}
public IHttpActionResult DeleteSOFR(int id)
{
SOFR sOFR = db.SOFRs.Find(id);
if (sOFR == null)
{
return(NotFound());
}
db.SOFRs.Remove(sOFR);
db.SaveChanges();
return(Ok(sOFR));
}
public IHttpActionResult PostSOFR(SOFR sOFR)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
//db.SOFRs.Add(sOFR);
//db.SaveChanges();
var sofrIndex = db.SP_INS_SOFR(0, sOFR.Date, sOFR.SOFR_Index, 0, 0, 0);
return(CreatedAtRoute("DefaultApi", new { id = sOFR.Id }, sOFR));
}
public IHttpActionResult sofrPOST(SOFR sofr)
{
try
{
SOFREntities liborEnty = new SOFREntities();
liborEnty.SOFRs.Add(sofr);
liborEnty.SaveChanges();
return(Content(HttpStatusCode.Created, "Data Saved successfully"));
}
catch (Exception)
{
return(Content(HttpStatusCode.BadRequest, "Error Found"));
}
}
