private void SaveSize() { var size = new ProductSizesModel { ProductSizeName = mEtCategory.Text.Trim(), SizeRank = mSizesDataAccess.GetMaxSizeRank() + 1 }; mSizesDataAccess.InsertIntoTable(size); }
private void UpdateSize() { var size = new ProductSizesModel { ProductSizeName = mEtCategory.Text.Trim(), Id = selectedSize.Id }; mSizesDataAccess.UpdateTable(size); }
public bool InsertIntoTable(ProductSizesModel row) { try { using (var connection = new SQLiteConnection(connectionString)) { connection.Insert(row); return(true); } } catch (SQLiteException ex) { Log.Info("SQLiteEx", ex.Message); return(false); } }
public bool UpdateTable(ProductSizesModel ProductSizesModel) { try { using (var connection = new SQLiteConnection(connectionString)) { connection.Query <ProductSizesModel>("UPDATE ProductSizesModel set ProductSizeName=? Where Id=?", ProductSizesModel.ProductSizeName, ProductSizesModel.Id); return(true); } } catch (SQLiteException ex) { Log.Info("SQLiteEx", ex.Message); return(false); } }
private void FnGetData() { isSize = Intent.GetBooleanExtra("isSize", false); isEdit = Intent.GetBooleanExtra("isEdit", false); selectedRecordId = Intent.GetIntExtra("selectedRecordId", 0); mSizesDataAccess = new SizesDataAccess(); mCategoriesDataAccess = new CategoriesDataAccess(); if (isEdit) { if (isSize) { selectedSize = mSizesDataAccess.SelectRecord(selectedRecordId)[0]; } else { selectedCategory = mCategoriesDataAccess.SelectRecord(selectedRecordId)[0]; } } }