public HttpResponseMessage approveclaim(DateTime dateofloss, tblInsurance insurance) { DbContextTransaction transaction = entities.Database.BeginTransaction(); try { entities.proc_checkexpiredateofclaim(Convert.ToInt32(insurance.InsuranceApplicationId), insurance.DateofApplication, dateofloss, insurance.FarmerId, insurance.CropType); entities.SaveChanges(); transaction.Commit(); } catch (Exception e) { transaction.Rollback(); return(Request.CreateErrorResponse(HttpStatusCode.Ambiguous, e.Message)); } return(Request.CreateResponse(HttpStatusCode.OK)); }