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(); } }