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