public ShortcutFormPage(int id = -1)
{
InitializeComponent();
Id = id;
if (Id != -1) //Gdy formularz ma być wykorzystany do edycji skrótu
{
ShortcutCell = DatabaseClass.GetShortcutFromDatabase(Id);
TextEntry.Text = ShortcutCell.Text;
WWWAddressEntry.Text = ShortcutCell.WWWAddress;
Button DeleteButton = new Button()
{
Text = AppResources.DeleteShortcutFormPage,
BackgroundColor = Color.Red,
TextColor = Color.White,
Margin = new Thickness(50, 100),
};
DeleteButton.Clicked += DeleteButton_Clicked;
FormStackLayout.Children.Add(DeleteButton);
AcceptButton.Text = AppResources.ChangeShortcutFormPage;
}
}
public static ShortcutCell GetShortcutFromDatabase(int id) //Odczyt rekordu ze skrótem o zadanym numerze Id
{
if (id < 1)
{
return(new ShortcutCell());
}
try
{
OpenDB();
if (DatabaseState == DatabaseState.DATABASE_OPENED)
{
var existingItem = db.Get <ShortcutsTable>(id);
db.Close();
ShortcutCell shortcutCell = new ShortcutCell()
{
Id = existingItem.Id,
Text = existingItem.Text,
WWWAddress = existingItem.WWWAddress,
Image = existingItem.Image,
ButtonVisible = true,
};
DatabaseState = DatabaseState.DATABASE_OK;
return(shortcutCell);
}
else
{
DatabaseState = DatabaseState.DATABASE_ERROR;
return(new ShortcutCell());
}
}
catch (Exception ex)
{
exceptionText = ex.ToString();
DatabaseState = DatabaseState.DATABASE_ERROR;
return(new ShortcutCell());
}
}
public static void DeleteShortcut(ShortcutCell shortcutCell) //Usunięcie skrótu z bazy danych
{
try
{
OpenDB();
if (DatabaseState == DatabaseState.DATABASE_OPENED)
{
db.Execute("DELETE FROM ShortcutsTable WHERE Id = ?", shortcutCell.Id);
db.Close();
DatabaseState = DatabaseState.DATABASE_OK;
}
else
{
DatabaseState = DatabaseState.DATABASE_ERROR;
}
}
catch (Exception ex)
{
exceptionText = ex.ToString();
DatabaseState = DatabaseState.DATABASE_ERROR;
}
}
public static void EditShortcut(ShortcutCell shortcutCell) //Modyfikacja skrótu znaajdującego się bazie danych
{
try
{
OpenDB();
if (DatabaseState == DatabaseState.DATABASE_OPENED)
{
db.Execute("UPDATE ShortcutsTable SET Text = ?, WWWAddress = ?, Image = ? WHERE Id = ?", shortcutCell.Text, shortcutCell.WWWAddress, shortcutCell.Image, shortcutCell.Id);
db.Close();
DatabaseState = DatabaseState.DATABASE_OK;
}
else
{
DatabaseState = DatabaseState.DATABASE_ERROR;
}
}
catch (Exception ex)
{
exceptionText = ex.ToString();
DatabaseState = DatabaseState.DATABASE_ERROR;
}
}
public static void AddNewShortcut(ShortcutCell shortcutCell) //Dodanie nowego skrótu do bazy danych
{
try
{
OpenDB();
if (DatabaseState == DatabaseState.DATABASE_OPENED)
{
var Shortcut = new ShortcutsTable()
{
Image = shortcutCell.Image,
Text = shortcutCell.Text,
WWWAddress = shortcutCell.WWWAddress,
};
if (db.Insert(Shortcut) != 1)
{
DatabaseState = DatabaseState.DATABASE_ERROR;
db.Close();
return;
}
db.Close();
DatabaseState = DatabaseState.DATABASE_OK;
return;
}
else
{
DatabaseState = DatabaseState.DATABASE_ERROR;
return;
}
}
catch (Exception ex)
{
exceptionText = ex.ToString();
DatabaseState = DatabaseState.DATABASE_ERROR;
}
}
