public IHttpActionResult Puttbl_Claims(int id, tbl_Claims tbl_Claims) { if (!ModelState.IsValid) { return BadRequest(ModelState); } if (id != tbl_Claims.Id) { return BadRequest(); } db.Entry(tbl_Claims).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!tbl_ClaimsExists(id)) { return NotFound(); } else { throw; } } return StatusCode(HttpStatusCode.NoContent); }
public IHttpActionResult Gettbl_Claims(int id) { tbl_Claims tbl_Claims = db.tbl_Claims.Find(id); if (tbl_Claims == null) { return(NotFound()); } //db.sp_claimApprove(id); try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!tbl_ClaimsExists(id)) { return(NotFound()); } else { throw; } } return(Ok(db.us_claimDetailsofAllUsers())); }
public tbl_Claims POST([FromBody] tbl_Claims claims) { using (ClaimyWebServies_dbEntities2 entity = new ClaimyWebServies_dbEntities2()) { entity.Configuration.ProxyCreationEnabled = false; entity.tbl_Claims.Add(claims); entity.SaveChanges(); return(claims); } }
public IHttpActionResult Deletetbl_Claims(int id) { tbl_Claims tbl_Claims = db.tbl_Claims.Find(id); if (tbl_Claims == null) { return NotFound(); } db.tbl_Claims.Remove(tbl_Claims); db.SaveChanges(); return Ok(tbl_Claims); }
public IHttpActionResult Posttbl_Claims(tbl_Claims tbl_Claims) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } int approvedAmount = tbl_Claims.Claim_Amount; int claimId = tbl_Claims.Id; db.us_claimApprovewithAmount(claimId, approvedAmount); // db.tbl_Claims.Add(tbl_Claims); db.SaveChanges(); return(CreatedAtRoute("DefaultApi", new { id = tbl_Claims.Id }, approvedAmount)); }
public IHttpActionResult Posttbl_Claims(tbl_Claims tbl_Claims) { if (!ModelState.IsValid) { return BadRequest(ModelState); } int? policyId = tbl_Claims.Pol_Id; tbl_Policies tbl_Policies = db.tbl_Policies.Find(policyId); if(tbl_Policies==null) { return BadRequest(); } if(tbl_Policies.Policy_Approve_Status=="Deactivated") { return BadRequest(); } int claimAmount = tbl_Policies.Total_IDV; tbl_Claims.Claim_Amount = claimAmount; tbl_Claims.Claim_Approved = "Pending"; tbl_Claims.Date_Of_Claim = DateTime.Now; int prevClaim = db.tbl_Claims.Where(u => u.Pol_Id == tbl_Claims.Pol_Id && u.Claim_Approved=="Pending").Count(); if (prevClaim >= 1) { //tbl_User tbl_User1 = db.tbl_User.Find(email); return BadRequest(); } db.tbl_Claims.Add(tbl_Claims); db.SaveChanges(); return CreatedAtRoute("DefaultApi", new { id = tbl_Claims.Id }, tbl_Claims.Id); }