public PalletViewModel(IPallet pallet)
{
Id = pallet.Id;
Width = pallet.Width;
Height = pallet.Height;
Depth = pallet.Depth;
Weight = pallet.Weight;
GrossWeight = pallet.GrossWeight;
Description = pallet.Description;
EnglishDescription = pallet.EnglishDescription;
}
public bool CreatePallet(IPallet pallet)
{
const string query = "Insert into Pallets (Width, Height, Depth, Description, DescriptionEng, Weight, GrossWeight) values " +
"(@Width,@Height,@Depth,@Description,@DescriptionEng,@Weight,@GrossWeight);" +
"select last_insert_rowid();";
_sqliteDataProvider.AddParameter("@Width", pallet.Width);
_sqliteDataProvider.AddParameter("@Height", pallet.Height);
_sqliteDataProvider.AddParameter("@Depth", pallet.Depth);
_sqliteDataProvider.AddParameter("@Description", pallet.Description);
_sqliteDataProvider.AddParameter("@DescriptionEng", pallet.EnglishDescription);
_sqliteDataProvider.AddParameter("@Weight", pallet.Weight);
_sqliteDataProvider.AddParameter("@GrossWeight", pallet.GrossWeight);
var queryResult = _sqliteDataProvider.ExecuteScalar(query);
return(queryResult != null);
}
public bool UpdatePallet(IPallet pallet)
{
const string query = "Update Pallets " +
"Set Width = @Width, Height = @Height," +
"Depth= @Depth, Description = @Description," +
"DescriptionEng = @DescriptionEng, Weight = @Weight, GrossWeight = @GrossWeight" +
" Where Id = @Id";
_sqliteDataProvider.AddParameter("@Id", pallet.Id);
_sqliteDataProvider.AddParameter("@Width", pallet.Width);
_sqliteDataProvider.AddParameter("@Height", pallet.Height);
_sqliteDataProvider.AddParameter("@Depth", pallet.Depth);
_sqliteDataProvider.AddParameter("@Description", pallet.Description);
_sqliteDataProvider.AddParameter("@DescriptionEng", pallet.EnglishDescription);
_sqliteDataProvider.AddParameter("@Weight", pallet.Weight);
_sqliteDataProvider.AddParameter("@GrossWeight", pallet.GrossWeight);
return(_sqliteDataProvider.ExecuteNonQuery(query) > 0);
}
