private IList <FarmerModel> ExecuteQuery(bool needsSyncOnly = false)
{
var farmers = new List <FarmerModel>();
var queryText = "SELECT * FROM Farmer";
if (needsSyncOnly)
{
queryText = string.Concat(queryText, " WHERE NeedsSync = 1");
}
using (var queryCmd = Connection.Prepare(queryText))
{
while (queryCmd.Step() == SQLiteResult.ROW)
{
var farmer = new FarmerModel()
{
Id = (int)queryCmd.GetInteger("Id"),
Firstname = queryCmd.GetText("Firstname"),
Lastname = queryCmd.GetText("Lastname"),
Country = queryCmd.GetText("Country"),
Speciality = queryCmd.GetText("Speciality"),
HasAnimals = ((int)queryCmd.GetInteger("HasAnimals") == 1),
HasWholeGrainFields = ((int)queryCmd.GetInteger("HasWholeGrainFields") == 1),
HasWineyards = ((int)queryCmd.GetInteger("HasWineyards") == 1)
};
farmers.Add(farmer);
}
}
return(farmers);
}
public ActionResult Create([Bind(Include = "Id,PhoneNumber,ImagePath,FirstName,LastName,Password,ConfirmPassword,Address,IsActive,IsApproved")] FarmerModel farmerModel, HttpPostedFileBase file)
{
UserModel user = new UserModel();
if (ModelState.IsValid)
{
if (file != null)
{
string filename = Guid.NewGuid().ToString("N") + file.FileName;
file.SaveAs(HttpContext.Server.MapPath("~/Images/")
+ filename);
farmerModel.ImagePath = filename;
}
user.PhoneNumber = farmerModel.PhoneNumber;
user.FirstName = farmerModel.FirstName;
user.LastName = farmerModel.LastName;
user.Type = "Farmer";
user.Password = farmerModel.Password;
user.ConfirmPassword = farmerModel.ConfirmPassword;
user.StoreName = "";
user.Address = farmerModel.Address;
user.ImagePath = farmerModel.ImagePath;
db.UserModels.Add(user);
//db.FarmerModels.Add(farmerModel);
db.SaveChanges();
//return RedirectToAction("Index");
}
Session["UserModel"] = user;
return(RedirectToAction("Login"));
//return View(farmerModel);
}
public FarmerViewModel GetFarmerByFsc(string FscId, int Mode = 0)
{
DataSet ds = _Apdal.GetFarmerByFsc(FscId, Mode);
FarmerViewModel a = new FarmerViewModel();
if (ds != null && ds.Tables[0] != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
List <FarmerModel> p = new List <FarmerModel>();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
FarmerModel Reason = new FarmerModel();
Reason.FarmerId = ds.Tables[0].Rows[i]["FarmerId"].ToString();
Reason.FarmerName = ds.Tables[0].Rows[i]["FarmerName"].ToString();
Reason.MobileNo = ds.Tables[0].Rows[i]["MobileNo"].ToString();
Reason.District = ds.Tables[0].Rows[i]["DistrictName"].ToString();
Reason.DistrictId = ds.Tables[0].Rows[i]["DistrictID"].ToString();
Reason.StateId = ds.Tables[0].Rows[i]["StateID"].ToString();
Reason.StatusID = Convert.ToInt32(ds.Tables[0].Rows[i]["BlackListStatus"].ToString());
Reason.CallStatus = ds.Tables[0].Rows[i]["AgentStatus"].ToString();
p.Add(Reason);
}
a.FarmerList = p;
}
}
return(a);
}
// POST: Farmer
public System.Web.Http.IHttpActionResult Post(FarmerModel Farmer)
{
DataSet DS = new DataSet();
DS = BusinessLogicLayer.FARMER_DETAILS_INSERT_UPDATE(Farmer.farmerID, Farmer.name, Farmer.location, Farmer.contactNo, Farmer.panNo, Farmer.bankAccountNo);
return(Ok());
}
void FarmerSelected(object sender, SelectedItemChangedEventArgs args)
{
var item = args.SelectedItem as FarmerModel;
if (item == null)
{
return;
}
OrderPage a = (OrderPage)Navigation.NavigationStack.Where(k => k.Title == "Order").FirstOrDefault();
FarmerModel farmer = item;
FieldModel field = null;
a.GetViewModel.SelectedFarmer = farmer is null ? new FarmerModel {
FirstName = "Select Farmer"
} : farmer;
a.GetViewModel.BtnFarmerSelection = farmer != null ? "Change Farmer" : "Select Farmer";
a.GetViewModel.SelectedField = field ?? field;
a.GetViewModel.BtnFieldSelection = field != null ? "Change Field" : "Select Field";
Navigation.NavigationStack.LastOrDefault().SendBackButtonPressed();
//Detail Page is not ready to show
//await Navigation.PushAsync(new OrderPage(item));
}
public TemplateFieldListView(FarmerModel farmer = null, AddressFarmerModel address = null)
{
InitializeComponent();
GetViewModel.SelectedFarmer = farmer;
GetViewModel.SelectedAddress = address;
}
public ActionResult DeleteConfirmed(int id)
{
FarmerModel farmerModel = db.FarmerModels.Find(id);
db.FarmerModels.Remove(farmerModel);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public FarmerAbstractPage(FarmerModel farmer, AddressFarmerModel address)
{
InitializeComponent();
GetViewModel.Farmer = farmer;
GetViewModel.FarmerAddress = address;
GetViewModel.Navigation = Navigation;
}
public FieldPage(FarmerModel farmer, AddressFarmerModel address)
{
InitializeComponent();
GetViewModel.Farmer = farmer;
GetViewModel.FarmerGuid = farmer.GuidId;
GetViewModel.address = address;
GetViewModel.Navigation = Navigation;
GetViewModel.ButtonName = "Done";
}
//protected override bool OnBackButtonPressed()
//{
// FarmerModel farmer = GetViewModel.farmerModel;
// AddressFarmerModel address = GetViewModel.addressModel;
// Navigation.PushAsync(new FarmerAbstractPage(farmer, address));
// return false;
//}
protected override void OnDisappearing()
{
FarmerModel farmer = GetViewModel.farmerModel;
AddressFarmerModel address = GetViewModel.addressModel;
if (farmer != null && farmer.FarmerId > 0)
{
FarmerAbstractPage a = (FarmerAbstractPage)Navigation.NavigationStack.Where(k => k.Title == "FarmerDetail").FirstOrDefault();
a.GetViewModel.Farmer = farmer;
a.GetViewModel.FarmerAddress = address;
}
}
// GET: FarmerModels/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
FarmerModel farmerModel = db.FarmerModels.Find(id);
if (farmerModel == null)
{
return(HttpNotFound());
}
return(View(farmerModel));
}
protected override void OnDisappearing()
{
// If you want to continue going back
FarmerModel selectedFarmer = GetViewModel.Farmer;
AddressFarmerModel address = GetViewModel.address;
FarmerAbstractPage a = (FarmerAbstractPage)Navigation.NavigationStack.Where(k => k.Title == "FarmerDetail").FirstOrDefault();
a.GetViewModel.Farmer = selectedFarmer;
a.GetViewModel.FarmerAddress = address;
//// If you want to stop the back button
//return true;
}
public static void OnEventFired(BindableObject obj, object old, object newitem)
{
string item = (obj as OrderSelectionsPage).SelectedItem;
FarmerModel farmer = (obj as OrderSelectionsPage).SelectedFarmer;
if (item == "SelectFarmer")
{
//https://forums.xamarin.com/discussion/87415/how-to-display-content-from-one-xaml-inside-another
(obj as OrderSelectionsPage).FindByName <ContentPage>("OrderSelection").Content = new OrderFarmerContent();
}
else if (item == "SelectField")
{
(obj as OrderSelectionsPage).FindByName <ContentPage>("OrderSelection").Content = new OrderFieldContent(farmer);
}
}
public static void OnEventFired(BindableObject obj, object old, object newitem)
{
string item = (obj as FieldListView).ContentExist;
View content = (obj as FieldListView).Content;
FarmerModel a = (obj as FieldListView).SelectedFarmer;
AddressFarmerModel b = (obj as FieldListView).SelectedFarmerAddress;
if (item == "MapView")
{
//https://forums.xamarin.com/discussion/87415/how-to-display-content-from-one-xaml-inside-another
(obj as FieldListView).FindByName <ContentView>("farmerDetailView").Content = new MapView();
}
else if (item == "FieldList")
{
(obj as FieldListView).FindByName <ContentView>("farmerDetailView").Content = new TemplateFieldListView(a, b);
}
}
public ActionResult Edit([Bind(Include = "Id,PhoneNumber,FirstName,LastName,Password,ConfirmPassword,Address,IsActive,IsApproved")] FarmerModel farmerModel, HttpPostedFileBase file)
{
if (ModelState.IsValid)
{
if (file != null)
{
string filename = Guid.NewGuid().ToString("N") + file.FileName;
file.SaveAs(HttpContext.Server.MapPath("~/Images/")
+ filename);
farmerModel.ImagePath = filename;
}
db.Entry(farmerModel).State = EntityState.Modified;
db.SaveChanges();
//return RedirectToAction("Index");
return(RedirectToAction("Index", "Home"));
}
return(View(farmerModel));
}
public FarmerModel GetRecord(int id)
{
try
{
using (var uow = new UnitOfWork(new DataContext()))
{
var model = new FarmerModel();
var obj = uow.Farmers.Get(id);
model.Address = obj.Address;
model.FullName = obj.FullName;
model.PhoneNumber = obj.PhoneNumber;
return(model);
}
}
catch (Exception)
{
throw;
}
}
public FarmerPage(FarmerModel farmer = null, AddressFarmerModel address = null)
{
InitializeComponent();
GetViewModel.farmerModel = farmer;
GetViewModel.addressModel = address;
GetViewModel.BtnName = farmer.FarmerId > 0 ? "Update" : "Save";
GetViewModel.OperationType = farmer.FarmerId > 0 ? true : false;
GetViewModel.FarmerID = farmer.FarmerId;
GetViewModel.FirstName = farmer.FirstName;
GetViewModel.LastName = farmer.LastName;
GetViewModel.GuidId = farmer.GuidId;
GetViewModel.Email = farmer.Email;
GetViewModel.Phone = farmer.Phone;
GetViewModel.RowHash = farmer.RowHash;
GetViewModel.GetCountryList();
if (address != null)
{
UpdateCountryCity(farmer.FarmerId, address);
}
string format = "yyyy-MM-dd'T'hh:mm:ss";
//string format = string.Empty;
//if (Device.RuntimePlatform == Device.Android)
// format = "M/d/yyyy hh:mm:ss tt";
//else
// format = "M/d/yyyy hh:mm:ss";
GetViewModel.BirthDate = string.IsNullOrEmpty(farmer.BirthDate) ? DateTime.Now :
DateTime.ParseExact(farmer.BirthDate, format, CultureInfo.InvariantCulture);
GetViewModel.Navigation = Navigation;
GetViewModel.IsCountry = false;
}
public FieldPage(FieldModel item, FarmerModel farmer, AddressFarmerModel address)
{
InitializeComponent();
GetViewModel.Farmer = farmer;
GetViewModel.FarmerGuid = farmer.GuidId;
GetViewModel.address = address;
GetViewModel.Navigation = Navigation;
GetViewModel.ButtonName = "Update";
GetViewModel.FieldID = item.FieldId;
GetViewModel.FieldGuid = item.FieldGuid;
GetViewModel.FieldName = item.FieldName;
GetViewModel.GpsPosition = item.FieldGps;
GetViewModel.SampleAreaSize = item.FieldAreaSize.ToString();
Array abc = Enum.GetValues(typeof(FieldViewModel.SampleAreaSizeUnit));
foreach (FieldViewModel.SampleAreaSizeUnit i in abc)
{
if (i.ToString() == item.FieldUnit)
{
GetViewModel.AreaUnit = i;
}
}
}
async void TakePhotoButtonTapped(object sender, EventArgs e)
{
camera.StopPreview();
var image = textureView.Bitmap;
try
{
var absolutePath = Android.OS.Environment.GetExternalStoragePublicDirectory(Android.OS.Environment.DirectoryDcim).AbsolutePath;
var folderPath = absolutePath + "/Camera";
//The Folllowing is an answer to quesition that how to Get the selected Crop and Image Name
Models.CropModel SelectedCrop = null;
string selectedImageName = (MainPage as CameraPage).GetViewModel.Parent.SelectedImagePath;
FarmerModel selectedFarmer = (MainPage as CameraPage).GetViewModel.Parent.SelectedFarmer;
FieldModel selectedField = (MainPage as CameraPage).GetViewModel.Parent.SelectedField;
var filePath = string.Empty;
if (!string.IsNullOrEmpty(selectedImageName))
{
filePath = System.IO.Path.Combine(folderPath, string.Format("{0}.jpg", selectedImageName));
File.Delete(filePath);
}
if ((MainPage as CameraPage).GetViewModel.SelectedCrop != null)
{
SelectedCrop = (MainPage as CameraPage).GetViewModel.SelectedCrop;
}
filePath = System.IO.Path.Combine(folderPath, string.Format("NEW_{0}_{1}_{2}.jpg", SelectedCrop.Crop_Name, selectedField.FieldGuid, SelectedCrop.Crop_ID.ToString()));
//End of
var fileStream = new FileStream(filePath, FileMode.Create);
await image.CompressAsync(Bitmap.CompressFormat.Jpeg, 80, fileStream);
fileStream.Close();
image.Recycle();
AndHUD.Shared.ShowToast(activity, "Photo saved!!!", MaskType.Clear, TimeSpan.FromMilliseconds(1500));
var intent = new Android.Content.Intent(Android.Content.Intent.ActionMediaScannerScanFile);
var file = new Java.IO.File(filePath);
var uri = Android.Net.Uri.FromFile(file);
intent.SetData(uri);
//Forms.Context.SendBroadcast(intent);
Context.SendBroadcast(intent);
await MainPage.Navigation.PopModalAsync();
}
catch (Exception ex)
{
AndHUD.Shared.ShowToast(activity, "Photo can not taken!!!", MaskType.Clear, TimeSpan.FromMilliseconds(1500));
System.Diagnostics.Debug.WriteLine(@" ", ex.Message);
}
//camera.StartPreview();
}
public Task <int> DeleteItemAsync(FarmerModel item)
{
return(database.DeleteAsync(item));
}
public Task <List <FieldModel> > GetItemsAsync(FarmerModel farmer)
{
return(database.Table <FieldModel>().Where(k => k.FieldFarmerGuid == farmer.GuidId || k.FieldFarmerId == farmer.FarmerId)
.OrderByDescending(k => k.FieldId).ToListAsync());
}
//http://www.fabiocozzolino.eu/a-little-and-simple-bindable-horizontal-scroll-view/
public OrderPage(FarmerModel farmer = null, FieldModel field = null)
{
InitializeComponent();
GetViewModel.Navigation = Navigation;
GetViewModel.ParentPage = this;
}
//protected override void OnDisappearing()
//{
// OrderSelectionsPage a = (OrderSelectionsPage)Navigation.NavigationStack.Where(k => k.Title == "Choose").FirstOrDefault();
// Navigation.RemovePage(a);
//}
public OrderSelectionsPage(string style = "SelectFarmer", FarmerModel farmer = null)
{
InitializeComponent();
SelectedFarmer = farmer;
SelectedItem = style;
}
void Start()
{
model = new FarmerModel();
anim = GetComponent <Animator>();
hasArrived = false;
}
public static void OnFarmerChanged(BindableObject obj, object old, object newitem)
{
thisFarmer = (obj as FieldListView).SelectedFarmer;
}
public FarmersViewModel(IFarmerRepository farmerRepository, IAppInsightsService appInsights)
{
_farmerRepo = farmerRepository;
_appInsightsService = appInsights;
CurrentFarmer = null;
}
public OrderFieldContent(FarmerModel farmer = null)
{
InitializeComponent();
GetViewModel.SelectedFarmer = farmer;
}
public Task <int> SaveItemAsync(FarmerModel item)
{
return(database.InsertAsync(item));
}
