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 }