コード例 #1
0
        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()));
        }
コード例 #3
0
 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);
     }
 }
コード例 #4
0
        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));
        }
コード例 #6
0
        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);
        }