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