public IHttpActionResult PuttblUser(string id, tblUser tblUser) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != tblUser.EmailId) { return(BadRequest()); } db.Entry(tblUser).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!tblUserExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public HttpResponseMessage Post(tblFarmer farmer) { DbContextTransaction transaction = entities.Database.BeginTransaction(); try { entities.sp_approveFarmer(farmer.fId, farmer.ApprovedBy, farmer.ApprovedDate, farmer.fPassword, farmer.fEmailId); entities.SaveChanges(); transaction.Commit(); } catch (Exception) { transaction.Rollback(); return(Request.CreateErrorResponse(HttpStatusCode.Conflict, "Not able to approve the user")); } return(Request.CreateResponse(HttpStatusCode.OK)); }
public HttpResponseMessage Reset_Password(string email, string password) { tblUser user = entities.tblUsers.Where(f => f.EmailId == email).FirstOrDefault(); try { if (user != null) { user.Password = Pass.ConvertToEncrypt(password); entities.SaveChanges(); if (user.fId != null) { tblFarmer farmer = entities.tblFarmers.Where(f => f.fId == user.fId).FirstOrDefault(); farmer.fPassword = Pass.ConvertToEncrypt(password); entities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, "Password updated")); } else if (user.bId != null) { tblBidder bidder = entities.tblBidders.Where(b => b.bId == user.bId).FirstOrDefault(); bidder.bPassword = Pass.ConvertToEncrypt(password); entities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, "Password updated")); } else { return(Request.CreateResponse(HttpStatusCode.OK, "Password updated for admin")); } } else { return(Request.CreateResponse(HttpStatusCode.OK, "User not found")); } } catch (Exception) { return(Request.CreateErrorResponse(HttpStatusCode.NotModified, "Password not updated")); } // return Request.CreateResponse(HttpStatusCode.NotFound, "Password updated for admin"); }
public HttpResponseMessage postapplyinsurance(tblInsurance insurance) { int x = Convert.ToInt32(insurance.FarmerId); /*ObjectParameter sumfinal = new ObjectParameter("sumfinal", typeof(float)); * ObjectParameter fshare = new ObjectParameter("fshare", typeof(float)); * ObjectParameter gvtshare = new ObjectParameter("gvtshare", typeof(float)); * * * var result = entities.proc_calculateInsurance(insurance.CropType, insurance.CropName, insurance.Area, sumfinal, fshare, gvtshare); * calculateinsurance ci = new calculateinsurance(); * ci.InsuranceCompany = "AGRICULTURE INSURANCE COMPANY"; * var msp = entities.tblCropDetails.Where(c => c.CropName == insurance.CropName).Select(t => t.MspPerQuintal).FirstOrDefault(); * var yeild = entities.tblCropDetails.Where(c => c.CropName == insurance.CropName).Select(t => t.YeildPerHectareTons).FirstOrDefault(); * ci.SumInsuredPerHectare = Convert.ToSingle(msp) * Convert.ToSingle(yeild) * 10; * ci.SharePremium = Convert.ToSingle(gvtshare.Value); * ci.PremiumAmount = Convert.ToSingle(fshare.Value); * ci.CropName = insurance.CropName; * ci.Area = Convert.ToSingle(insurance.Area); * ci.SumInsured = Convert.ToSingle(sumfinal.Value);*/ var msp = entities.tblCropDetails.Where(c => c.CropName == insurance.CropName).Select(t => t.MspPerQuintal).FirstOrDefault(); var yeild = entities.tblCropDetails.Where(c => c.CropName == insurance.CropName).Select(t => t.YeildPerHectareTons).FirstOrDefault(); insurance.SumInsured = Convert.ToDecimal((msp) * Convert.ToDecimal(yeild) * 10); insurance.DateofApplication = DateTime.Now; insurance.FarmerId = x; entities.tblInsurances.Add(insurance); entities.SaveChanges(); var sum = Convert.ToDouble(insurance.SumInsured * Convert.ToDecimal(insurance.Area)); var obj = entities.tblUsers.Where(f => f.fId == x).FirstOrDefault(); var policyno = entities.tblInsurances.Where(k => k.FarmerId == x).FirstOrDefault(); //sending email string to = obj.EmailId; MailMessage mm = new MailMessage(); mm.From = new MailAddress("*****@*****.**"); mm.To.Add(to); mm.Subject = "Insurance details"; mm.Body = "your policyno:" + policyno.InsuranceApplicationId + " Suminsured by company is:" + sum; mm.IsBodyHtml = false; SmtpClient smtp = new SmtpClient("smtp.gmail.com"); smtp.UseDefaultCredentials = true; smtp.Port = 587; smtp.EnableSsl = true; smtp.Credentials = new System.Net.NetworkCredential("*****@*****.**", "farmerfriend"); smtp.Send(mm); //return Request.CreateResponse(HttpStatusCode.OK, "Email sent"); return(Request.CreateResponse(HttpStatusCode.OK, "Succesfully applied")); }
public HttpResponseMessage Post(int fid, tblBid bid) { //entities.tblBids.Add(bid); DbContextTransaction transaction = entities.Database.BeginTransaction(); try { entities.sp_newBid(bid.CropId, bid.BidderId, bid.BidAmount, bid.DateOfBid); entities.SaveChanges(); int bidID = entities.tblBids.Max(x => x.bId); entities.sp_InsertintoBidCrops(bidID, fid, bid.CropId, bid.BidderId); entities.SaveChanges(); transaction.Commit(); }catch (Exception) { transaction.Rollback(); return(Request.CreateErrorResponse(HttpStatusCode.Conflict, "Could not insert data ")); } return(Request.CreateResponse(HttpStatusCode.Created)); }
public HttpResponseMessage AddCropDetails() { string document = null; var httpRequest = HttpContext.Current.Request; var postedFile = httpRequest.Files["SPhCert"]; document = new String(Path.GetFileNameWithoutExtension(postedFile.FileName).Take(15).ToArray()).Replace(" ", "-"); document = document + DateTime.Now.ToString("yymmssfff") + Path.GetExtension(postedFile.FileName); var filePath = HttpContext.Current.Server.MapPath("~/Image/" + document); postedFile.SaveAs(filePath); tblCropForSale cropForSale = new tblCropForSale(); cropForSale.SoilPhCertificate = filePath; cropForSale.CropType = httpRequest["croptype"]; cropForSale.CropName = httpRequest["cropname"]; cropForSale.Quantity = Convert.ToInt32(httpRequest["quantity"]); cropForSale.FertilizerType = httpRequest["fertilizertype"]; cropForSale.StatusOfCropSaleReq = "pending"; var x = httpRequest["farmerid"]; cropForSale.FarmerId = Convert.ToInt32(x); // cropForSale.FarmerId = Convert.ToInt32(httpRequest["farmerid"]); DbContextTransaction transaction = entities.Database.BeginTransaction(); if (ModelState.IsValid) { try { entities.sp_Place_Request(cropForSale.FarmerId, cropForSale.CropType, cropForSale.CropName, cropForSale.Quantity, cropForSale.FertilizerType, cropForSale.SoilPhCertificate); entities.SaveChanges(); transaction.Commit(); } catch (Exception) { transaction.Rollback(); return(Request.CreateErrorResponse(HttpStatusCode.NotAcceptable, "Could not Place Request")); } } return(Request.CreateResponse(HttpStatusCode.Created, cropForSale)); }
public HttpResponseMessage postclaiminsurance(tblInsuranceClaim insuranceClaim) { //check for farmerid in session matches with farmerid in tblinsurance(this says he applied for insurance) if (insuranceClaim.Policyno == entities.tblInsurances.Select(t => t.InsuranceApplicationId).FirstOrDefault()) { if (insuranceClaim.SumInsured == entities.tblInsurances.Select(t => t.SumInsured).FirstOrDefault()) { insuranceClaim.ClaimStatus = "pending"; Convert.ToDecimal(insuranceClaim.SumInsured); entities.tblInsuranceClaims.Add(insuranceClaim); entities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, "your insurance is claimed")); } else { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "you should enter the correct suminsured by company")); } } else { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "policy no mismatch")); } }
public HttpResponseMessage Post(tblFarmer farmer) { DbContextTransaction transaction = entities.Database.BeginTransaction(); try { entities.sp_approveFarmer(farmer.fId, farmer.ApprovedBy, farmer.ApprovedDate, farmer.fPassword, farmer.fEmailId); entities.SaveChanges(); EmailModel mail = new EmailModel(); mail.to = farmer.fEmailId; mail.subject = "Account Activated"; mail.body = "username:"******"\n password:"******"http://localhost:61674/api/Email"); var consumewebApi = http.PostAsJsonAsync <EmailModel>("email", mail); transaction.Commit(); } catch (Exception) { transaction.Rollback(); return(Request.CreateErrorResponse(HttpStatusCode.Conflict, "Not able to approve the user")); } return(Request.CreateResponse(HttpStatusCode.OK)); }
public HttpResponseMessage Register() { DbContextTransaction transaction = entities.Database.BeginTransaction(); string imageName = null; string imageName1 = null; string imageName2 = null; var httpRequest = HttpContext.Current.Request; //Upload Image try { var postedFile = httpRequest.Files["Image"]; var postedFile1 = httpRequest.Files["Pan"]; var postedFile2 = httpRequest.Files["TraderLicense"]; //Create custom filename imageName = new String(Path.GetFileNameWithoutExtension(postedFile.FileName).Take(10).ToArray()).Replace(" ", "-"); imageName = imageName + DateTime.Now.ToString("yymmssfff") + Path.GetExtension(postedFile.FileName); var filePath = HttpContext.Current.Server.MapPath("~/Image/" + imageName); postedFile.SaveAs(filePath); imageName1 = new String(Path.GetFileNameWithoutExtension(postedFile1.FileName).Take(10).ToArray()).Replace(" ", "-"); imageName1 = imageName1 + DateTime.Now.ToString("yymmssfff") + Path.GetExtension(postedFile1.FileName); var filePath1 = HttpContext.Current.Server.MapPath("~/Image/" + imageName1); postedFile1.SaveAs(filePath1); imageName2 = new String(Path.GetFileNameWithoutExtension(postedFile2.FileName).Take(10).ToArray()).Replace(" ", "-"); imageName2 = imageName2 + DateTime.Now.ToString("yymmssfff") + Path.GetExtension(postedFile2.FileName); var filePath2 = HttpContext.Current.Server.MapPath("~/Image/" + imageName2); postedFile2.SaveAs(filePath2); tblBidder br = new tblBidder(); //Save to db using (dbFarmerScheme3Entities db = new dbFarmerScheme3Entities()) { string email = httpRequest["Email"]; var e = db.tblBidders.Where(x => x.bEmailId == email).FirstOrDefault(); if (e == null) { string acc = httpRequest["AccountNo"]; var a = db.tblBidders.Where(x => x.bAccountNo == acc).FirstOrDefault(); if (a == null) { try { br.bAadhar = filePath; br.bUserName = httpRequest["Username"]; br.bContactNo = httpRequest["Contact"]; br.bEmailId = httpRequest["Email"]; br.bAddress = httpRequest["Address"]; br.bCity = httpRequest["City"]; br.bState = httpRequest["State"]; br.bPincode = httpRequest["Pincode"]; br.bAccountNo = httpRequest["AccountNo"]; br.bIFSCcode = httpRequest["ifsccode"]; br.bPan = filePath1; br.bTraderLicense = filePath2; br.bPassword = httpRequest["Password"]; br.StatusOfBidderDocx = "pending"; entities.tblBidders.Add(br); entities.SaveChanges(); transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message)); } } else { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Account No already exist")); } } else { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Email already exist")); } } } catch (Exception) { return(Request.CreateErrorResponse(HttpStatusCode.NotAcceptable, "File size should be less than 2MB")); } return(Request.CreateResponse(HttpStatusCode.Created, "Successfully Registered")); }