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