public dynamic UpdatePassword(string email, string password)
{
List <tblFarmer> far = db.tblFarmers.ToList();
List <tblBidder> bid = db.tblBidders.ToList();
foreach (var item in far)
{
if (item.FarmerEmail == email)
{
item.FarmerPassword = password;
byte[] encData_byte = new byte[item.FarmerPassword.Length];
encData_byte = System.Text.Encoding.UTF8.GetBytes(item.FarmerPassword);
string encodedpassword = Convert.ToBase64String(encData_byte);
item.FarmerPassword = encodedpassword;
db.Entry(item).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, "Valid"));
}
}
foreach (var item in bid)
{
if (item.BidderEmail == email)
{
item.BidderPassword = password;
db.Entry(item).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, "Valid"));
}
}
return(Request.CreateResponse(HttpStatusCode.NotFound, "NotFound"));
}
public HttpResponseMessage RemoveFromCart(int cartid, int productid)
{
var result = entities.proc_Remove_From_Cart(cartid, productid);
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, "Success"));
}
public IHttpActionResult PuttblInsuranceClaim(int id, tblInsuranceClaim tblInsuranceClaim)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != tblInsuranceClaim.CliamId)
{
return(BadRequest());
}
db.Entry(tblInsuranceClaim).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!tblInsuranceClaimExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult Post([FromUri] int Id, int bidderID, int latestbid)
{
tblBidding tblBidding = db.tblBiddings.Find(Id);
tblBidding.BidderId = bidderID;
tblBidding.PreviousBidPrice = tblBidding.CurrentBidPrice;
tblBidding.CurrentBidPrice = latestbid;
db.Entry(tblBidding).State = EntityState.Modified;
db.SaveChanges();
return(Ok("OK"));
}
public HttpResponseMessage ApproveRetailer(int retailerid, string retaileremail)
{
try
{
entities.proc_Approve_Retailer(retailerid, retaileremail);
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, "Accepted"));
}
catch (Exception)
{
return(Request.CreateResponse(HttpStatusCode.OK, "Error"));
}
}
public HttpResponseMessage UpdateUserPassword(string useremail, string userpassword)
{
try
{
tblUser user = entities.tblUsers.Find(useremail);
user.userpassword = userpassword;
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, "Valid"));
}
catch (Exception)
{
return(Request.CreateResponse(HttpStatusCode.OK, "Invalid"));
}
}
public IHttpActionResult DeletetblCropRequest(int id)
{
tblCropRequest tblCropRequest = db.tblCropRequests.Find(id);
if (tblCropRequest == null)
{
return(NotFound());
}
db.tblCropRequests.Remove(tblCropRequest);
db.SaveChanges();
return(Ok(tblCropRequest));
}
public HttpResponseMessage WayTwo()
{
string imageName = "";
string Qty = "";
var httpRequest = HttpContext.Current.Request;
//Upload Image
var postedFile = httpRequest.Files["Image"];
//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);
//Save to DB
using (dbProjectEntities db = new dbProjectEntities())
{
tblCropRequest cpr = new tblCropRequest();
cpr.SoilPhCertificate = imageName;
cpr.CropType = httpRequest["CropType"];
cpr.CropName = httpRequest["CropName"];
cpr.FertilizerType = httpRequest["FertilizerType"];
Qty = (httpRequest["Quantity"]);
//Quantity = 25
cpr.Quantity = Convert.ToInt32(Qty);
cpr.FarmerId = Convert.ToInt32(httpRequest["FarmerID"]);
cpr.CropApproved = false;
db.tblCropRequests.Add(cpr);
db.SaveChanges();
}
return(Request.CreateResponse(HttpStatusCode.Created));
}
public void Listing([FromBody] tblCropRequest cropRequest)
{
cropRequest.SoilPhCertificate = cropRequest.SoilPhCertificate.Replace("/", "-");
cropRequest.FarmerId = 100;
cropRequest.CropApproved = false;
db.tblCropRequests.Add(cropRequest);
db.SaveChanges();
}
public IHttpActionResult Post([FromUri] int Id, int adminId)
{
tblBidder bidder = db.tblBidders.Find(Id);
bidder.BidderApproved = true;
bidder.ApprovalAdminId = adminId;
db.Entry(bidder).State = EntityState.Modified;
db.SaveChanges();
return(Ok("OK"));
}
public HttpResponseMessage UserRegister(tblUser user)
{
try
{
if (CheckUserEmail(user.useremail))
{
entities.tblUsers.Add(user);
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, "success"));
}
else
{
return(Request.CreateResponse(HttpStatusCode.OK, "invalid"));
}
}
catch (Exception e)
{
return(Request.CreateResponse(HttpStatusCode.OK, e.Message));
}
}
public IHttpActionResult PostInsuranceRegistration(InsuranceApp regfom)
{
tblInsurance tblInsurance = new tblInsurance();
tblInsurance.Season = regfom.Season;
tblInsurance.Area = regfom.Area;
tblInsurance.FarmerId = Convert.ToInt32(regfom.Farmerid);
tblInsurance.CompanyName = regfom.CompanyName;
tblInsurance.SumInsured = regfom.SumAssured;
tblInsurance.Year = regfom.Year;
tblInsurance.DateOfInsurance = DateTime.Today;
tblInsurance.Crop = regfom.CropName;
db.tblInsurances.Add(tblInsurance);
db.SaveChanges();
return(Ok("OK"));
}
public IHttpActionResult Post([FromUri] string mail, int id)
{
var currentmsg = db.tblContactUs.Where(c => c.Email.Equals(mail))
.FirstOrDefault <tblContactU>();
if (currentmsg != null)
{
currentmsg.status = "Replied";
currentmsg.ApprovalAdminId = id;
db.SaveChanges();
}
else
{
return(NotFound());
}
return(Ok());
}
public void Post([FromBody] tblContactU contactU)
{
try
{
tblContactU c = new tblContactU();
c.ContactName = contactU.ContactName;
c.Email = contactU.Email;
c.RequestType = "Complaint";
c.message = contactU.message;
c.status = "Not Seen";
c.ApprovalAdminId = null;
db.tblContactUs.Add(c);
db.SaveChanges();
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
}
public HttpResponseMessage RetailerRegister(tblRetailer retailer)
{
try
{
retailer = new tblRetailer()
{
retailername = retailer.retailername,
retaileremail = retailer.retaileremail,
retailerpassword = retailer.retailerpassword,
approved = "pending"
};
db.tblRetailers.Add(retailer);
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, "valid"));
}
catch (Exception e)
{
return(Request.CreateResponse(HttpStatusCode.OK, "invalid"));
}
}
public HttpResponseMessage ProductUpload()
{
string imageName = null;
var httpRequest = HttpContext.Current.Request;
//Upload Image
var postedFile = httpRequest.Files["Image"];
//var postedFile = fileToUpload;
//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);
using (dbProjectEntities entities = new dbProjectEntities())
{
tblProduct tblProduct = new tblProduct();
tblProduct.retailerid = Convert.ToInt32(httpRequest["RetailerId"].ToString());
tblProduct.productname = httpRequest["ProductName"].ToString();
tblProduct.productdescription = httpRequest["ProductDescription"].ToString();
tblProduct.productbrand = httpRequest["ProductBrand"].ToString();
tblProduct.productquantity = Convert.ToInt32(httpRequest["ProductQuantity"].ToString());
tblProduct.productprice = Convert.ToInt32(httpRequest["ProductPrice"].ToString());
tblProduct.categoryid = Convert.ToInt32(httpRequest["CategoryId"].ToString());
tblProduct.productnotification = "add";
tblProduct.productstatus = "accepted";
tblProduct.productimage1 = imageName.ToString();
entities.tblProducts.Add(tblProduct);
entities.SaveChanges();
}
return(Request.CreateResponse(HttpStatusCode.OK, "Success"));
}
public void post([FromBody] tblInsuranceClaim insuranceCliam)
{
insuranceCliam.ApprovalStatus = "Not Approved";
db.tblInsuranceClaims.Add(insuranceCliam);
db.SaveChanges();
}
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);
//var filePath1 = HttpContext.Current.Server.MapPath("D:/Project_Angular/AgriFarmProj/src/assets/uploadeddocs/" + imageName1);
postedFile1.SaveAs(filePath1);
tblFarmer fmr = new tblFarmer();
//Save to DB
using (dbProjectEntities db = new dbProjectEntities())
{
#region saving data into db
List <tblFarmer> farmers = db.tblFarmers.ToList();
List <tblBank> banks = db.tblBanks.ToList();
foreach (tblFarmer tblFarmer1 in farmers)
{
if (tblFarmer1.FarmerEmail == httpRequest["FarmerEmail"])
{
return(Ok("Email"));
}
}
foreach (tblBank tblBank1 in banks)
{
if (tblBank1.AccountNo == httpRequest["AccountNo"])
{
return(Ok("Account"));
}
}
try
{
fmr.FarmerAadhar = imageName;
fmr.FarmerCertificate = imageName1;
fmr.FarmerName = httpRequest["FarmerName"];
fmr.FarmerContactNo = httpRequest["FarmerContactNo"];
fmr.FarmerAddress = httpRequest["FarmerAddress"];
fmr.FarmerCity = httpRequest["FarmerCity"];
fmr.FarmerState = httpRequest["FarmerState"];
fmr.FarmerPincocde = httpRequest["FarmerPincocde"];
fmr.FarmerEmail = httpRequest["FarmerEmail"];
fmr.FarmerPassword = httpRequest["FarmerPassword"];
fmr.FarmerApproved = false;
byte[] encData_byte = new byte[fmr.FarmerPassword.Length];
encData_byte = System.Text.Encoding.UTF8.GetBytes(fmr.FarmerPassword);
string encodedpassword = Convert.ToBase64String(encData_byte);
fmr.FarmerPassword = encodedpassword;
db.tblFarmers.Add(fmr);
db.SaveChanges();
// db.SaveChanges();
/*
* }*/
List <tblFarmer> res = db.tblFarmers.ToList();
foreach (tblFarmer item in res)
{
if (item.FarmerEmail == fmr.FarmerEmail)
{
fid = item.FarmerId;
break;
}
}
tblBank tb1 = new tblBank();
using (dbProjectEntities db1 = new dbProjectEntities())
{
tb1.FarmerId = fid;
tb1.AccountNo = httpRequest["AccountNo"];
tb1.IFSC_Code = httpRequest["IFSC_Code"];
tb1.BidderId = null;
db1.tblBanks.Add(tb1);
db1.SaveChanges();
// db.SaveChanges();
}
tblFarmLand tb2 = new tblFarmLand();
using (dbProjectEntities db1 = new dbProjectEntities())
{
tb2.FarmerId = fid;
tb2.FarmerLandArea = httpRequest["FarmerLandArea"];
tb2.FarmerLandAddress = httpRequest["FarmerLandAddress"];
tb2.FarmerLandPincode = httpRequest["FarmerLandPincode"];
db1.tblFarmLands.Add(tb2);
db1.SaveChanges();
}
#endregion
}
catch (Exception)
{
return(Ok("Error"));
}
}
return(Ok("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 (dbProjectEntities db = new dbProjectEntities())
{
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"));
}
