private List <StocksInventoryModel> loadDatagridDetails() { conDB = new ConnectionDB(); List <StocksInventoryModel> lstStocksInventory = new List <StocksInventoryModel>(); StocksInventoryModel stocksInventory = new StocksInventoryModel(); queryString = "SELECT dbfh.tblstocksjuice.ID, datedelivered, dbfh.tblproducts.description as productname, " + "qty, dbfh.tblproducts.ID as prodID FROM (dbfh.tblstocksjuice INNER JOIN dbfh.tblproducts ON dbfh.tblstocksjuice.productID = dbfh.tblproducts.ID)" + "WHERE dbfh.tblstocksjuice.isDeleted = 0 AND dbfh.tblproducts.isDeleted = 0 ORDER BY datedelivered ASC"; MySqlDataReader reader = conDB.getSelectConnection(queryString, null); while (reader.Read()) { stocksInventory.ID = reader["ID"].ToString(); DateTime dte = DateTime.Parse(reader["datedelivered"].ToString()); stocksInventory.DeliveryDate = dte.ToShortDateString(); stocksInventory.ProductID = reader["prodID"].ToString(); stocksInventory.ProductName = reader["productname"].ToString(); stocksInventory.Qty = reader["qty"].ToString(); lstStocksInventory.Add(stocksInventory); stocksInventory = new StocksInventoryModel(); } conDB.closeConnection(); return(lstStocksInventory); }
private List <StocksInventoryModel> loadDatagridDetails() { conDB = new ConnectionDB(); List <StocksInventoryModel> lstStocksInventory = new List <StocksInventoryModel>(); StocksInventoryModel stocksInventory = new StocksInventoryModel(); queryString = "SELECT tblstockstp.ID, datedelivered, dbfh.tblstockstp.description, tbltollpacker.description as tollpackername, " + "qty FROM (dbfh.tblstockstp INNER JOIN dbfh.tbltollpacker ON tblstockstp.tollpackerID = tbltollpacker.ID)" + "WHERE tblstockstp.isDeleted = 0 AND tbltollpacker.isDeleted = 0"; MySqlDataReader reader = conDB.getSelectConnection(queryString, parameters); while (reader.Read()) { stocksInventory.ID = reader["ID"].ToString(); DateTime dte = DateTime.Parse(reader["datedelivered"].ToString()); stocksInventory.DeliveryDate = dte.ToShortDateString(); stocksInventory.StocksDescription = reader["description"].ToString(); stocksInventory.TollpackerName = reader["tollpackername"].ToString(); stocksInventory.Qty = reader["qty"].ToString(); lstStocksInventory.Add(stocksInventory); stocksInventory = new StocksInventoryModel(); } conDB.closeConnection(); return(lstStocksInventory); }
private async void MenuDeleteStocksOut_Click(object sender, RoutedEventArgs e) { StocksInventoryModel sim = dgvStocksOut.SelectedItem as StocksInventoryModel; if (sim != null) { MessageDialogResult result = await window.ShowMessageAsync("Delete Stocks In", "Are you sure you want to delete stocks record?", MessageDialogStyle.AffirmativeAndNegative); if (result.Equals(MessageDialogResult.Affirmative)) { deleteRecordStocksOUt(sim.ID); dgvStocksOut.ItemsSource = loadStocksOut(); List <StocksInventoryModel> TotalInAndOut = loadTotalIn(); List <StocksInventoryModel> TotalOut = loadTotalOut(); foreach (StocksInventoryModel s in TotalInAndOut) { foreach (StocksInventoryModel o in TotalOut) { if (s.ProductID.Equals(o.ProductID)) { s.QtyOut = o.QtyOut; s.QtyNet = (Convert.ToDouble(s.QtyIn) - Convert.ToDouble(o.QtyOut)).ToString(); } } } //dgvStocksInAndOut.ItemsSource = TotalInAndOut; } } }
private void MenuEditStocksOut_Click(object sender, RoutedEventArgs e) { StocksInventoryModel sim = dgvStocksOut.SelectedItem as StocksInventoryModel; if (sim != null) { StocksDetailsOut sdo = new StocksDetailsOut(this, sim); sdo.ShowDialog(); } }
private List <StocksInventoryModel> loadStocksOut() { conDB = new ConnectionDB(); List <StocksInventoryModel> lstStocksInventory = new List <StocksInventoryModel>(); StocksInventoryModel stocksInventory = new StocksInventoryModel(); queryString = "SELECT dbfh.tblstocksjuiceout.ID, datedelivered, dbfh.tblstocksjuiceout.description, dbfh.tblproducts.description as productname, " + "qty, isPaid, drNo, amount, dbfh.tblproducts.ID as prodID, terms, paymentduedate FROM " + "(dbfh.tblstocksjuiceout INNER JOIN dbfh.tblproducts ON dbfh.tblstocksjuiceout.productID = dbfh.tblproducts.ID)" + "WHERE dbfh.tblstocksjuiceout.isDeleted = 0 AND dbfh.tblproducts.isDeleted = 0 ORDER BY datedelivered ASC"; MySqlDataReader reader = conDB.getSelectConnection(queryString, null); while (reader.Read()) { stocksInventory.ID = reader["ID"].ToString(); DateTime dte = DateTime.Parse(reader["datedelivered"].ToString()); stocksInventory.DeliveryDate = dte.ToShortDateString(); if (string.IsNullOrEmpty(reader["paymentduedate"].ToString())) { stocksInventory.PaymentDueDate = ""; } else { dte = DateTime.Parse(reader["paymentduedate"].ToString()); stocksInventory.PaymentDueDate = dte.ToShortDateString(); } stocksInventory.StocksDescription = reader["description"].ToString(); stocksInventory.ProductName = reader["productname"].ToString(); stocksInventory.Qty = reader["qty"].ToString(); stocksInventory.Paid = (reader["isPaid"].ToString().Equals("1") ? "YES" : "NO"); stocksInventory.DRNo = reader["drNo"].ToString(); stocksInventory.ProductID = reader["prodID"].ToString(); stocksInventory.Amount = reader["amount"].ToString(); stocksInventory.Terms = reader["terms"].ToString(); lstStocksInventory.Add(stocksInventory); stocksInventory = new StocksInventoryModel(); } conDB.closeConnection(); return(lstStocksInventory); }
private List <StocksInventoryModel> getOverallStocks() { conDB = new ConnectionDB(); List <StocksInventoryModel> lstStocksInv = new List <StocksInventoryModel>(); StocksInventoryModel stocks = new StocksInventoryModel(); queryString = "SELECT datedelivered, qty FROM dbfh.tblstockstp WHERE isDeleted = 0"; MySqlDataReader reader = conDB.getSelectConnection(queryString, null); while (reader.Read()) { stocks.DeliveryDate = reader["datedelivered"].ToString(); stocks.Qty = reader["qty"].ToString(); lstStocksInv.Add(stocks); stocks = new StocksInventoryModel(); } conDB.closeConnection(); return(lstStocksInv); }
private List <StocksInventoryModel> loadTotalIn() { List <StocksInventoryModel> lstStocksIn = new List <StocksInventoryModel>(); StocksInventoryModel sim = new StocksInventoryModel(); conDB = new ConnectionDB(); queryString = "SELECT dbfh.tblstocksjuice.productID, sum(qty) as qty, tblproducts.description " + "FROM (dbfh.tblstocksjuice INNER JOIN tblproducts ON dbfh.tblstocksjuice.productID = dbfh.tblproducts.ID) " + "WHERE dbfh.tblstocksjuice.isDeleted = 0 GROUP BY dbfh.tblstocksjuice.productID"; MySqlDataReader reader = conDB.getSelectConnection(queryString, null); while (reader.Read()) { sim.ProductID = reader["productID"].ToString(); sim.QtyIn = reader["qty"].ToString(); sim.ProductName = reader["description"].ToString(); lstStocksIn.Add(sim); sim = new StocksInventoryModel(); } conDB.closeConnection(); return(lstStocksIn); }
public StocksDetailsOut(StocksInventoryJuice sij, StocksInventoryModel sim) { stocksJuiceView = sij; stocksInventoryMod = sim; InitializeComponent(); }