public IHttpActionResult Puttbl_Policies(int id, tbl_Policies tbl_Policies) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != tbl_Policies.Id) { return(BadRequest()); } db.Entry(tbl_Policies).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!tbl_PoliciesExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public IHttpActionResult Posttbl_Payment(tbl_Payment tbl_Payment) { List <string> successDetails = new List <string>(); string[] success = new string[6]; if (!ModelState.IsValid) { return(BadRequest(ModelState)); } tbl_Payment.Payment_Date = DateTime.Now; tbl_Payment.Payment_Status = "Done"; db.tbl_Payment.Add(tbl_Payment); db.SaveChanges(); //int? vehicleid = db.tbl_Policy.ToList().Find(m => m.Id == tbl_Policy.Id).Veh_Id; //tbl_VehicleInfo tbl_VehicleInfo = db.tbl_VehicleInfo.Where(m => m.Id == vehicleid).First(); //int? customerId = db.tbl_VehicleInfo.ToList().Find(m => m.Id == vehicleid).Cust_Id; int?policyid = db.tbl_Payment.ToList().Find(m => m.Id == tbl_Payment.Id).Pol_Id; tbl_Policies tbl_Policiesss = db.tbl_Policies.Find(policyid); if (tbl_Policiesss == null) { return(NotFound()); } tbl_Policies tbl_Policy = db.tbl_Policies.Where(m => m.Id == policyid).First(); int? vehicleId = db.tbl_Policies.ToList().Find(m => m.Id == policyid).Veh_Id; tbl_VehicleInfo tbl_VehicleInfo2 = db.tbl_VehicleInfo.Where(m => m.Id == vehicleId).First(); int? customerId = db.tbl_VehicleInfo.ToList().Find(m => m.Id == vehicleId).Cust_Id; tbl_User tbl_User = db.tbl_User.Where(m => m.Id == customerId).First(); string carModel = tbl_VehicleInfo2.Veh_Model; string carManufacturer = tbl_VehicleInfo2.Manufacturer; string registerationNumber = tbl_VehicleInfo2.Registration_Number; string userName = tbl_User.Firstname; success[0] = carModel; success[1] = carManufacturer; success[2] = registerationNumber; success[3] = userName; success[4] = tbl_Payment.Pol_Id.Value.ToString(); success[5] = tbl_Payment.Id.ToString(); //db.sp_paymentStatuses(tbl_Payment.Pol_Id); db.sp_PaymentStatuss(tbl_Payment.Pol_Id); // db.sp_paymentStatusesforRenew(tbl_Payment.Pol_Id); return(CreatedAtRoute("DefaultApi", new { id = tbl_Payment.Id }, success)); }
public IHttpActionResult Gettbl_Policies(int id) { tbl_Policies tbl_Policies = db.tbl_Policies.Find(id); if (tbl_Policies == null) { return(NotFound()); } return(Ok(tbl_Policies)); }
public IHttpActionResult Deletetbl_Policies(int id) { tbl_Policies tbl_Policies = db.tbl_Policies.Find(id); if (tbl_Policies == null) { return(NotFound()); } db.tbl_Policies.Remove(tbl_Policies); db.SaveChanges(); return(Ok(tbl_Policies)); }
public IHttpActionResult Posttbl_RenewPolicies(tbl_RenewPolicies tbl_RenewPolicies) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } int[] paymentDetails = new int[5]; int? previousPolicyId = tbl_RenewPolicies.previousPolicyId; tbl_Policies tbl_policy = db.tbl_Policies.Where(m => m.Id == previousPolicyId).First(); if (tbl_RenewPoliciesExists(previousPolicyId.Value)) { return(NotFound()); } tbl_RenewPolicies.Policy_Type = tbl_policy.Policy_Type; tbl_RenewPolicies.Veh_Id = tbl_policy.Veh_Id; tbl_RenewPolicies.Policy_Amount = ((tbl_policy.Policy_Amount) - tbl_policy.Policy_Amount * 4 / 100); tbl_RenewPolicies.Policy_StartDate = DateTime.Now; tbl_RenewPolicies.Policy_Purchase_Date = DateTime.Now; tbl_RenewPolicies.Total_IDV = ((tbl_policy.Total_IDV - tbl_policy.Total_IDV * 5 / 100)); int duration = tbl_RenewPolicies.Duration.Value; tbl_RenewPolicies.Policy_Expiry_Date = tbl_RenewPolicies.Policy_Purchase_Date.Value.AddDays(duration); tbl_RenewPolicies.Policy_Approve_Status = "Yet To Be Approved"; tbl_RenewPolicies.Policy_Payment_Status = "Not Done"; tbl_RenewPolicies.Cust_Id = tbl_policy.Cust_Id; db.tbl_RenewPolicies.Add(tbl_RenewPolicies); db.SaveChanges(); paymentDetails[0] = tbl_RenewPolicies.Id; paymentDetails[1] = tbl_RenewPolicies.Policy_Amount; paymentDetails[2] = tbl_RenewPolicies.Total_IDV.Value; paymentDetails[3] = tbl_RenewPolicies.Veh_Id.Value; paymentDetails[4] = tbl_RenewPolicies.Cust_Id.Value; return(CreatedAtRoute("DefaultApi", new { id = tbl_RenewPolicies.Id }, paymentDetails)); }
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); }
public IHttpActionResult Posttbl_Policies(tbl_Policies tbl_Policies) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (tbl_Policies.Duration > 3) { return(BadRequest()); } if (tbl_Policies.Duration == 0) { return(BadRequest()); } if (tbl_Policies.Duration < 0) { return(BadRequest()); } int[] paymentDetails = new int[5]; int? previousPolicyId = tbl_Policies.Prev_Policy; tbl_Policies tbl_Policiesexception = db.tbl_Policies.Find(previousPolicyId); if (tbl_Policiesexception == null) { return(BadRequest()); } tbl_Policies tbl_policy = db.tbl_Policies.Where(m => m.Id == previousPolicyId).First(); tbl_Policies prevPolicy = db.tbl_Policies.Find(previousPolicyId); //if(prevPolicy.Policy_Approve_Status=="Deactivated") //{ // return BadRequest(); //} tbl_Policies.Policy_Type = tbl_policy.Policy_Type; tbl_Policies.Veh_Id = tbl_policy.Veh_Id; tbl_Policies.Policy_Amount = ((tbl_policy.Policy_Amount) - tbl_policy.Policy_Amount * 4 / 100); tbl_Policies.Policy_Date = DateTime.Now; tbl_Policies.Policy_Purchase_Date = DateTime.Now; tbl_Policies.Total_IDV = ((tbl_policy.Total_IDV - tbl_policy.Total_IDV * 5 / 100)); int duration = tbl_Policies.Duration; tbl_Policies.Policy_Expiry_Date = tbl_Policies.Policy_Purchase_Date.AddYears(duration); tbl_Policies.Policy_Approve_Status = "Activated"; tbl_Policies.Policy_Payment_Status = "Not Done"; tbl_Policies.Cust_Id = tbl_policy.Cust_Id; prevPolicy.Policy_Expiry_Date = DateTime.Now; db.sp_deactivatePolicy(previousPolicyId); db.tbl_Policies.Add(tbl_Policies); db.SaveChanges(); paymentDetails[0] = tbl_Policies.Id; paymentDetails[1] = tbl_Policies.Policy_Amount; paymentDetails[2] = tbl_Policies.Total_IDV; paymentDetails[3] = tbl_Policies.Veh_Id.Value; paymentDetails[4] = tbl_Policies.Cust_Id.Value; return(CreatedAtRoute("DefaultApi", new { id = tbl_Policies.Id }, paymentDetails)); }
public IHttpActionResult Posttbl_Policy(tbl_Policies tbl_Policy) { if (tbl_Policy.Policy_Type != "Third Party") { if (tbl_Policy.Policy_Type != "Comprehensive") { return(BadRequest()); } } if (tbl_Policy.Duration > 3) { return(BadRequest()); } if (tbl_Policy.Duration == 0) { return(BadRequest()); } if (tbl_Policy.Duration < 0) { return(BadRequest()); } tbl_Policy.Policy_Purchase_Date = DateTime.Today; int year = tbl_Policy.Duration; tbl_Policy.Policy_Date = DateTime.Today; tbl_Policy.Policy_Expiry_Date = tbl_Policy.Policy_Purchase_Date.AddYears(year); tbl_Policy.Policy_Approve_Status = "Deactivated"; tbl_Policy.Policy_Payment_Status = "Not Done"; tbl_Policy.Approved_By = "Admin"; int[] paymentDetails = new int[5]; if (tbl_Policy.Policy_Type == "Third Party") { tbl_Policy.Total_IDV = tbl_Policy.Total_IDV / 50; tbl_Policy.Policy_Amount = tbl_Policy.Policy_Amount / 100; } if (tbl_Policy.Total_IDV < 5000) { tbl_Policy.Total_IDV = 6460; } if (tbl_Policy.Policy_Amount < 1000) { tbl_Policy.Policy_Amount = 2900; } tbl_Policy.Policy_Amount = tbl_Policy.Policy_Amount * tbl_Policy.Duration; if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.tbl_Policies.Add(tbl_Policy); db.SaveChanges(); paymentDetails[0] = tbl_Policy.Id; paymentDetails[1] = tbl_Policy.Policy_Amount; paymentDetails[2] = tbl_Policy.Total_IDV; int?vehicleid = db.tbl_Policies.ToList().Find(m => m.Id == tbl_Policy.Id).Veh_Id; tbl_VehicleInfo tbl_VehicleInfo = db.tbl_VehicleInfo.Where(m => m.Id == vehicleid).First(); int? customerId = db.tbl_VehicleInfo.ToList().Find(m => m.Id == vehicleid).Cust_Id; tbl_User tbl_User = db.tbl_User.Where(m => m.Id == customerId).First(); int UserID = tbl_User.Id; int?VehicleId = tbl_Policy.Veh_Id; //int? vehicleid = db.tbl_Policy.ToList().Find(m => m.Id == tbl_Policy.Id).Veh_Id; // tbl_VehicleInfo tbl_VehicleInfo = db.tbl_VehicleInfo.Find(vehicleid); paymentDetails[3] = VehicleId.Value; paymentDetails[4] = UserID; return(CreatedAtRoute("DefaultApi", new { id = tbl_Policy.Id }, paymentDetails)); }