public HttpResponseMessage Post(tblBid bid) { DbContextTransaction transaction = entities.Database.BeginTransaction(); try { entities.sp_approveBid(bid.bId, bid.CropId); entities.SaveChanges(); tblCropForSale crop = entities.tblCropForSales.Where(c => c.CropId == bid.CropId).FirstOrDefault(); tblFarmer farmer = entities.tblFarmers.Where(f => f.fId == crop.FarmerId).FirstOrDefault(); EmailModel mail = new EmailModel(); mail.to = farmer.fEmailId; mail.subject = "Crop Sold "; mail.body = "Your crop sold id" + bid.CropId + "\t of type\t" + crop.CropType + "is sold for amount " + bid.BidAmount + "Rs/-;\n money will be credited after crop is shipped"; HttpClient http = new HttpClient(); http.BaseAddress = new Uri("http://localhost:61674/api/Email"); var consumewebApi = http.PostAsJsonAsync <EmailModel>("email", mail); //Sending confirmation to bidder EmailModel bidderMail = new EmailModel(); tblBidder bidder = entities.tblBidders.Where(b => bid.BidderId == b.bId).FirstOrDefault(); bidderMail.to = bidder.bEmailId; bidderMail.subject = "Congrats..! Your Bid Cinfirmed"; bidderMail.body = "your bid is confirmed for crop id" + bid.CropId + "with Amount Of" + bid.BidAmount + "<button>MakePaymet</button>"; var consumewebApi2 = http.PostAsJsonAsync <EmailModel>("email", bidderMail); transaction.Commit(); } catch (Exception) { transaction.Rollback(); return(Request.CreateErrorResponse(HttpStatusCode.Conflict, "Something went Wrong Try to bid again")); } return(Request.CreateResponse(HttpStatusCode.OK)); }
public IHttpActionResult PuttblBidder(int id, tblBidder tblBidder) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != tblBidder.BidderId) { return(BadRequest()); } db.Entry(tblBidder).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!tblBidderExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public IHttpActionResult Post([FromUri] int id, int adminid) { tblBidder tblBidder = db.tblBidders.Find(id); tblBidder.BidderApproved = true; tblBidder.ApprovalAdminId = adminid; db.Entry(tblBidder).State = EntityState.Modified; db.SaveChanges(); return(Ok("OK")); }
public IHttpActionResult GettblBidder(int id) { tblBidder tblBidder = db.tblBidders.Find(id); if (tblBidder == null) { return(NotFound()); } return(Ok(tblBidder)); }
public IHttpActionResult PosttblBidder(tblBidder tblBidder) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.tblBidders.Add(tblBidder); db.SaveChanges(); return(CreatedAtRoute("DefaultApi", new { id = tblBidder.BidderId }, tblBidder)); }
public IHttpActionResult DeletetblBidder(int id) { tblBidder tblBidder = db.tblBidders.Find(id); if (tblBidder == null) { return(NotFound()); } db.tblBidders.Remove(tblBidder); db.SaveChanges(); return(Ok(tblBidder)); }
public HttpResponseMessage Post(tblBidder bidder) { DbContextTransaction transaction = entities.Database.BeginTransaction(); try { entities.sp_approveBidder(bidder.bId, bidder.ApprovedBy, bidder.ApprovedDate, bidder.bPassword, bidder.bEmailId); 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 Getid([FromUri] string email, string user) { if (user == "admin") { List <tblAdmin> resadmin = db.tblAdmins.ToList(); tblAdmin outputadmin = new tblAdmin(); foreach (tblAdmin item in resadmin) { if (item.AdminEmail.Equals(email)) { outputadmin = item; break; } } return(Request.CreateResponse(HttpStatusCode.OK, outputadmin.AdminId)); } if (user == "farmer") { List <tblFarmer> res = db.tblFarmers.ToList(); tblFarmer output = new tblFarmer(); foreach (tblFarmer item in res) { if (item.FarmerEmail == email) { output = item; break; } } return(Request.CreateResponse(HttpStatusCode.OK, output.FarmerId)); } List <tblBidder> resbid = db.tblBidders.ToList(); tblBidder outputbid = new tblBidder(); foreach (tblBidder item in resbid) { if (item.BidderEmail.Equals(email)) { outputbid = item; break; } } return(Request.CreateResponse(HttpStatusCode.OK, outputbid.BidderId)); }
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 RejectBidder(string message, tblBidder bidder) { try { EmailModel mail = new EmailModel(); mail.to = bidder.bEmailId; mail.subject = "Application Rejected"; mail.body = "Your account not approved because of follwing reason. " + message + "kindly register again"; HttpClient http = new HttpClient(); http.BaseAddress = new Uri("http://localhost:61674/api/Email"); var consumewebApi = http.PostAsJsonAsync <EmailModel>("email", mail); entities.Entry(bidder).State = System.Data.Entity.EntityState.Deleted; entities.SaveChanges(); } catch (Exception) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Email Not Found ")); } return(Request.CreateResponse(HttpStatusCode.OK)); }
public IHttpActionResult WayTwo() { string imageName = ""; string imageName1 = ""; string Qty = ""; var httpRequest = HttpContext.Current.Request; //Upload Image var postedFile = httpRequest.Files["Image"]; var postedFile1 = httpRequest.Files["Image1"]; //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); tblBidder br = new tblBidder(); //Save to DB using (dbProjectEntities1 db = new dbProjectEntities1()) { List <tblBidder> bidders = db.tblBidders.ToList(); List <tblBank> banks = db.tblBanks.ToList(); foreach (tblBidder tblBidder1 in bidders) { if (tblBidder1.BidderEmail == httpRequest["BidderEmail"]) { return(Ok("Email")); } } foreach (tblBank tblBank1 in banks) { if (tblBank1.AccountNo == httpRequest["AccountNo"]) { return(Ok("Account")); } } try { #region saving details into db br.BidderAadhar = imageName; br.BidderTradeLicense = imageName1; br.BidderName = httpRequest["BidderName"]; br.BidderEmail = httpRequest["BidderEmail"]; br.BidderContactNo = httpRequest["BidderContactNo"]; br.BidderAddress = httpRequest["BidderAddress"]; br.BidderCity = httpRequest["BidderCity"]; br.BidderState = httpRequest["BidderState"]; br.BidderPincocde = httpRequest["BidderPincocde"]; br.BidderPassword = httpRequest["BidderPassword"]; byte[] encData_byte = new byte[br.BidderPassword.Length]; encData_byte = System.Text.Encoding.UTF8.GetBytes(br.BidderPassword); string encodedpassword = Convert.ToBase64String(encData_byte); br.BidderPassword = encodedpassword; br.BidderApproved = false; db.tblBidders.Add(br); db.SaveChanges(); List <tblBidder> res = db.tblBidders.ToList(); foreach (tblBidder item in res) { if (item.BidderEmail == br.BidderEmail) { bid = item.Bidderid; break; } } tblBank tb1 = new tblBank(); tb1.Farmerid = null; tb1.AccountNo = httpRequest["AccountNo"]; tb1.IFSC_Code = httpRequest["IFSC_Code"]; tb1.Bidderid = bid; db.tblBanks.Add(tb1); db.SaveChanges(); #endregion } catch { return(Ok("Error")); } } return(Ok("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")); }