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