protected override void OnAppearing() { base.OnAppearing(); _gunDatabase = new GunDatabase(); try { var gun = _gunDatabase.GetCurrentGun(); foreach (var item in gun) { if (item.GunImage != null) { gunImage.Source = ImageSource.FromStream(() => new MemoryStream(item.GunImage)); gunImage.HeightRequest = 300; } else { gunImage.Source = "defaultGun.png"; gunImage.HeightRequest = 300; } gunNameLabel.Text = item.GunName; gunSerialNumberLabel.Text = item.GunSerialNumber; gunDescriptionLabel.Text = item.GunDescription; gunManufacturer.Text = item.GunManufacturer; gunCaliber.Text = item.GunCaliber; gunValue.Text = item.GunValue; } } catch (Exception ex) { Debug.WriteLine(@" GunStock.GunViewPage.OnAppearing ERROR {0}", ex.Message); } }
protected override void OnAppearing() { base.OnAppearing(); _gunDatabase = new GunDatabase(); var guns = _gunDatabase.GetGuns(); listGuns.ItemsSource = guns; }
private void GetGuns() { Gun.CurrentGunType = "All Guns"; _gunDatabase = new GunDatabase(); var guns = _gunDatabase.GetGuns(); listGuns.ItemsSource = guns; }
public async void AddGun(object o, EventArgs e) { _gun = new Gun(); _gunDatabase = new GunDatabase(); try { if (gunSerialNumber.Text != null && gunName.Text != null && gunDescription.Text != null) { _gun.GunType = Gun.CurrentGunType; _gun.GunSerialNumber = gunSerialNumber.Text; _gun.GunName = gunName.Text; _gun.GunDescription = gunDescription.Text; if (gunManufacturer.Text != null) { _gun.GunManufacturer = gunManufacturer.Text; } if (gunValue.Text != null) { _gun.GunValue = gunValue.Text; } if (gunCaliber.Text != null) { _gun.GunCaliber = gunCaliber.Text; } if (_newGunImage != null) { _gun.GunImage = _newGunImage; Debug.WriteLine(_newGunImage); } _gunDatabase.AddGun(_gun); await Navigation.PopAsync(); } else { await DisplayAlert("Error", "Serial Number, Name, and Description is required", "OK"); } } catch (Exception ex) { Debug.WriteLine(@" GunStock.GunEntryPage.AddGun ERROR {0}", ex.Message); } }
public async void RemoveGunTypeClicked(object sender, EventArgs e) { var answer = await DisplayAlert("Remove Gun type", "Deleting the gun type will delete all guns with this type, this action can not be undone?", "Remove", "Cancel"); if (answer) { _gunTypeDatabase = new GunTypeDatabase(); _gunDatabase = new GunDatabase(); try { _gunTypeDatabase.DeleteGunType(GunType.CurrentGunTypeId); _gunDatabase.DeleteGunsWithType(); } catch (Exception ex) { Debug.WriteLine(@" GunStock.GunListPage.RemoveGunTypeClicked ERROR {0}", ex.Message); } Navigation.RemovePage(this); } }
public async void UpdateCurrentGun(object o, EventArgs e) { _gun = new Gun(); _gunDatabase = new GunDatabase(); try { if (gunSerialNumber.Text != null && gunName.Text != null && gunDescription.Text != null) { _gun.GunSerialNumber = gunSerialNumber.Text; _gun.GunName = gunName.Text; _gun.GunDescription = gunDescription.Text; if (gunManufacturer.Text != null) { _gun.GunManufacturer = gunManufacturer.Text; } if (gunValue.Text != null) { _gun.GunValue = gunValue.Text; } if (gunCaliber.Text != null) { _gun.GunCaliber = gunCaliber.Text; } _gun.GunImage = _gunImage; _gunDatabase.EditGun(_gun); Navigation.RemovePage(this); } else { await DisplayAlert("Error", "Serial Number, Name, and Description is required", "OK"); } } catch (Exception ex) { Debug.WriteLine(@" GunStock.GunUpdatePage.UpdateCurrentGun ERROR {0}", ex.Message); } }
public GunUpdatePage() { InitializeComponent(); _gunDatabase = new GunDatabase(); try { var gun = _gunDatabase.GetCurrentGun(); foreach (var item in gun) { if (item.GunImage != null) { _gunImage = item.GunImage; gunImage.Source = ImageSource.FromStream(() => new MemoryStream(_gunImage)); gunImage.HeightRequest = 300; RemovePicBtn.IsVisible = true; changePicBtn.IsVisible = true; addPicBtn.IsVisible = false; } else { gunImage.Source = "defaultGun.png"; gunImage.HeightRequest = 300; } gunName.Text = item.GunName; gunSerialNumber.Text = item.GunSerialNumber; gunDescription.Text = item.GunDescription; gunManufacturer.Text = item.GunManufacturer; gunCaliber.Text = item.GunCaliber; gunValue.Text = item.GunValue; } } catch (Exception ex) { Debug.WriteLine(@" GunStock.GunUpdatePage.GunUpdatePage ERROR {0}", ex.Message); } }
public async void ExportGunList(object obj, EventArgs args) { exportGunBtn.IsEnabled = false; //Create an instance of ExcelEngine. using (ExcelEngine excelEngine = new ExcelEngine()) { //Set the default application version as Excel 2013. excelEngine.Excel.DefaultVersion = ExcelVersion.Excel2013; //Create a workbook with a worksheet IWorkbook workbook = excelEngine.Excel.Workbooks.Create(1); //Access first worksheet from the workbook instance. IWorksheet worksheet = workbook.Worksheets[0]; //Enabling formula calculation. worksheet.EnableSheetCalculations(); worksheet["A1"].Text = "ID"; worksheet["B1"].Text = "Name"; worksheet["C1"].Text = "Type"; worksheet["D1"].Text = "Serial Number"; worksheet["E1"].Text = "Description"; worksheet["F1"].Text = "Value"; worksheet["G1"].Text = "Caliber"; worksheet["H1"].Text = "Manufacturer"; //Set the column width to fit to text. worksheet.Range["A1:H1"].AutofitColumns(); //Set the row to have wrapped text. //worksheet.Range["A1:H1"].WrapText = true; //Set the style for header range. IRange headingRange = worksheet["A1:H1"]; headingRange.CellStyle.Font.Bold = true; headingRange.CellStyle.HorizontalAlignment = ExcelHAlign.HAlignCenter; headingRange.CellStyle.ColorIndex = ExcelKnownColors.Light_green; try { _gunDatabase = new GunDatabase(); var guns = _gunDatabase.GetGuns(); var i = 2; foreach (var item in guns) { worksheet["A" + i].Text = item.ID.ToString(); worksheet["B" + i].Text = item.GunName; worksheet["C" + i].Text = item.GunType; worksheet["D" + i].Text = item.GunSerialNumber; worksheet["E" + i].Text = item.GunDescription; worksheet["F" + i].Text = item.GunValue; worksheet["G" + i].Text = item.GunCaliber; worksheet["H" + i].Text = item.GunManufacturer; i++; } worksheet.SetColumnWidth(5, 40); worksheet.UsedRange.WrapText = true; //Save the workbook to stream in xlsx format. MemoryStream stream = new MemoryStream(); workbook.SaveAs(stream); workbook.Close(); //Save the stream as a file in the device and invoke it for viewing await DependencyService.Get <ISave>().SaveAndView("GunStockList.xlsx", stream); } catch (Exception ex) { Debug.WriteLine(@" GunStock.GunPage.ExportGunList ERROR {0}", ex.Message); } } }