public JsonResult GetCrops(int categoryid, int cropid)
{
var data = from s in db.SellCrops
join f in db.Farmers on s.FarmerId equals f.Id
where s.CategoryId == categoryid && s.CropId == cropid
select new
{
sid = s.Id,
fname = f.Name,
q = s.Quantity,
p = s.Price
};
List <SellCropView> sell = new List <SellCropView>();
foreach (var d in data)
{
SellCropView st = new SellCropView();
st.Id = d.sid;
st.farmer.Name = d.fname;
st.Quantity = d.q;
st.Price = d.p;
sell.Add(st);
}
return(Json(sell));
}
public ActionResult BuyCrops(int id, string message)
{
ViewBag.Error = message;
var data = from s in db.SellCrops
join f in db.Farmers on s.FarmerId equals f.Id
join c in db.Crops on s.CropId equals c.Id
where s.Id == id
select new
{
crop = c.Name,
sid = s.Id,
fname = f.Name,
phone = f.Phone,
nid = f.Nid,
vil = f.Village,
dis = f.District,
wd = f.WardNo,
q = s.Quantity,
p = s.Price
};
SellCropView st = new SellCropView();
foreach (var d in data)
{
st.Id = d.sid;
st.farmer.Name = d.fname;
st.farmer.Phone = d.phone;
st.farmer.Nid = d.nid;
st.farmer.Village = d.vil;
st.farmer.WardNo = d.wd;
st.farmer.District = d.dis;
st.Quantity = d.q;
st.Price = d.p;
ViewBag.Name = d.crop;
}
ViewBag.Crop = st;
return(View());
}
public ActionResult Profile(string msg)
{
ViewBag.Profile = "active";
ViewBag.Error = msg;
int fid = (int)Session["FarmerId"];
var data = from s in db.SellCrops
join cat in db.Categories on s.CategoryId equals cat.Id
join cr in db.Crops on s.CropId equals cr.Id
where s.FarmerId == fid
select new
{
id = s.Id,
q = s.Quantity,
p = s.Price,
sold = s.SoldCropAmount,
catname = cat.Name,
crname = cr.Name,
};
List <SellCropView> sellCropViews = new List <SellCropView>();
foreach (var d in data)
{
SellCropView s = new SellCropView();
s.Id = d.id;
s.Quantity = d.q;
s.Price = d.p;
s.SellCropAmount = d.sold;
s.Category = d.catname;
s.Crop = d.crname;
sellCropViews.Add(s);
}
ViewBag.Crops = sellCropViews;
ViewBag.Farmer = db.Farmers.First(r => r.Id == fid);
return(View());
}
public JsonResult GetSummary(int id)
{
var data = from s in db.SellCrops
join f in db.Farmers on s.FarmerId equals f.Id
join c in db.Crops on s.CropId equals c.Id
where s.CategoryId == id && s.SoldCropAmount > 0
select new
{
crop = c.Name,
sid = s.Id,
fname = f.Name,
phone = f.Phone,
nid = f.Nid,
vil = f.Village,
dis = f.District,
wd = f.WardNo,
q = s.SoldCropAmount,
p = s.Price
};
AddressData addresses = new AddressData();
//, apikey: "AIzaSyDOYXX8MgKThJttmAixhqVeZgfzlIOi8uA"
List <SellCropView> sv = new List <SellCropView>();
foreach (var d in data)
{
SellCropView st = new SellCropView();
addresses.City = d.dis;
addresses.Country = "Bangladesh";
try
{
var gls = new GoogleLocationService("AIzaSyDOYXX8MgKThJttmAixhqVeZgfzlIOi8uA");
var latlong = gls.GetLatLongFromAddress(addresses);
st.Lat = latlong.Latitude;
st.Long = latlong.Longitude;
}
catch (System.Net.WebException ex)
{
st.Lat = -1;
st.Long = -1;
}
st.Id = d.sid;
st.farmer.Name = d.fname;
st.farmer.Phone = d.phone;
st.farmer.Nid = d.nid;
st.farmer.Village = d.vil;
st.farmer.WardNo = d.wd;
st.farmer.District = d.dis;
st.Crop = d.crop;
st.Quantity = d.q;
st.Price = d.p;
sv.Add(st);
}
return(Json(sv));
}
