void GetBuys()
{
dotNETConnection con = new dotNETConnection();
viewBuys = dotNETConnection.ConvertSqlToList <PharmacyHajiawa.Models.View.ViewBuy>(@"
SELECT Buy.BuyId, ItemType.TypeName, Item.CommericalName,Item.Barcode, Buy.BuyPrice, Buy.SellPrice, Buy.Quantity, Buy.Expire
FROM Buy INNER JOIN
Item ON Buy.ItemId = Item.ItemId INNER JOIN
ItemType ON Buy.ItemTypeId = ItemType.ItemTypeId");
mainDatagrid.ItemsSource = viewBuys;
mainDatagrid.Columns[0].Visibility = Visibility.Hidden;
mainDatagrid.Columns[1].Header = "جۆری کاڵا";
mainDatagrid.Columns[2].Header = "ناوی بازرگانی";
mainDatagrid.Columns[3].Header = "بارکۆد";
mainDatagrid.Columns[4].Header = "نرخی کڕین";
mainDatagrid.Columns[5].Header = "نرخی فرۆشتن";
mainDatagrid.Columns[6].Header = "دانە";
mainDatagrid.Columns[7].Header = "بەسەرچوون";
}
private async void GetItems(bool isDeleted)
{
//1 is deleted
if (isDeleted)
{
dotNETConnection dot = new dotNETConnection();
itemType = dotNETConnection.ConvertSqlToList <Models.ItemType>("select * from ItemType where Status=1");
mainDatagrid.ItemsSource = itemType;
mainDatagrid.Columns[0].Visibility = Visibility.Hidden;
mainDatagrid.Columns[1].Header = "جۆری کاڵا";
mainDatagrid.Columns[2].Visibility = Visibility.Hidden;
mainDatagrid.UnselectAllCells();
}
else
{
itemType = dotNETConnection.ConvertSqlToList <Models.ItemType>("select * from ItemType where Status=0");
mainDatagrid.ItemsSource = itemType;
mainDatagrid.Columns[0].Visibility = Visibility.Hidden;
mainDatagrid.Columns[1].Header = "جۆری کاڵا";
mainDatagrid.Columns[2].Visibility = Visibility.Hidden;
mainDatagrid.UnselectAllCells();
}
}
