private void CreateCategory()
{
if (NameCategory != string.Empty)
{
try
{
Category_addproducts category_addproducts = new Category_addproducts();
category_addproducts.category = NameCategory;
productDbRepository.InsertCategory(category_addproducts);
OnResume();
ForegroundStatus = "Green";
NameCategory = string.Empty;
Status = CreateCategoryMessage;
}
catch
{
ForegroundStatus = "Red";
NameCategory = string.Empty;
Status = ErrorRepeatabilityMessage;
}
}
else
{
ForegroundStatus = "Red";
Status = ErrorCreateMessage;
}
}
public ProductDbRepository(SQLiteConnection connection) : base(connection)
{
DbConnection.CreateTable <Product>();
DbConnection.CreateTable <DocumentProductcs>();
#region Products
var info = DbConnection.GetTableInfo("Category_addproducts");
if (!info.Any())
{
DbConnection.CreateTable <Category_addproducts>();
Category_addproducts Category_addproducts = new Category_addproducts();
Category_addproducts.category = "Artykuły przemysłowe";
DbConnection.Insert(Category_addproducts);
Category_addproducts.category = "Spożywcze";
DbConnection.Insert(Category_addproducts);
Category_addproducts.category = "Zabawki";
DbConnection.Insert(Category_addproducts);
Category_addproducts.category = "Wyroby mięsne";
DbConnection.Insert(Category_addproducts);
Category_addproducts.category = "Artykuły szklane";
DbConnection.Insert(Category_addproducts);
Category_addproducts.category = "Inne";
DbConnection.Insert(Category_addproducts);
}
info = DbConnection.GetTableInfo("UnitOfMeasure_addproducts");
if (!info.Any())
{
# region CreateUnitOfMeasure_addproducts
DbConnection.CreateTable <UnitOfMeasure_addproducts>();
UnitOfMeasure_addproducts UnitOfMeasure = new UnitOfMeasure_addproducts();
UnitOfMeasure.unitOfMeasure = "[m]";
DbConnection.Insert(UnitOfMeasure);
UnitOfMeasure.unitOfMeasure = "[m3]";
DbConnection.Insert(UnitOfMeasure);
UnitOfMeasure.unitOfMeasure = "['']";
DbConnection.Insert(UnitOfMeasure);
UnitOfMeasure.unitOfMeasure = "[L]";
DbConnection.Insert(UnitOfMeasure);
UnitOfMeasure.unitOfMeasure = "[cm]";
DbConnection.Insert(UnitOfMeasure);
UnitOfMeasure.unitOfMeasure = "[mg]";
DbConnection.Insert(UnitOfMeasure);
UnitOfMeasure.unitOfMeasure = "[g]";
DbConnection.Insert(UnitOfMeasure);
UnitOfMeasure.unitOfMeasure = "[kg]";
DbConnection.Insert(UnitOfMeasure);
UnitOfMeasure.unitOfMeasure = "[t]";
DbConnection.Insert(UnitOfMeasure);
UnitOfMeasure.unitOfMeasure = "[szt.]";
DbConnection.Insert(UnitOfMeasure);
UnitOfMeasure.unitOfMeasure = "[j.]";
DbConnection.Insert(UnitOfMeasure);
#endregion
}
