private List <ConsumableModel> loadDatagridDetails(string consumableID)
{
List <ConsumableModel> lstConsumableOnStocks = new List <ConsumableModel>();
ConsumableModel consumableStock = new ConsumableModel();
queryString = "SELECT dbspa.tblconsumableleft.ID, dbspa.tblconsumableleft.date, dbspa.tblconsumables.description, qty, used FROM " +
"(dbspa.tblconsumableleft INNER JOIN dbspa.tblconsumables ON dbspa.tblconsumableleft.consumableID = " +
"dbspa.tblconsumables.ID) WHERE dbspa.tblconsumableleft.isDeleted = 0 AND dbspa.tblconsumableleft.consumableID = ?;";
parameters = new List <string>();
parameters.Add(consumableID);
MySqlDataReader reader = conDB.getSelectConnection(queryString, parameters);
while (reader.Read())
{
consumableStock.ID = reader["ID"].ToString();
consumableStock.Date = reader["date"].ToString();
consumableStock.Description = reader["description"].ToString();
consumableStock.Quantity = reader["qty"].ToString();
consumableStock.Used = reader["used"].ToString();
double dblQty = Convert.ToDouble(consumableStock.Quantity);
double dblUsed = Convert.ToDouble(consumableStock.Used);
consumableStock.Left = (dblQty - dblUsed).ToString();
lstConsumableOnStocks.Add(consumableStock);
consumableStock = new ConsumableModel();
}
conDB.closeConnection();
return(lstConsumableOnStocks);
}
public ConsumableUpdates(ConsumableStocksDetails csd, ConsumableModel cm, string consumeID, string recID)
{
consumableStockDetWindow = csd;
consumeStockModel = cm;
consumableID = consumeID;
recordID = recID;
InitializeComponent();
}
private void btnEdit_Click(object sender, RoutedEventArgs e)
{
ConsumableModel consumableModel = dgvConsumables.SelectedItem as ConsumableModel;
if (consumableModel != null)
{
ConsumableDetails consumDet = new ConsumableDetails(this, consumableModel);
consumDet.ShowDialog();
}
}
private void btnEdit_Click(object sender, RoutedEventArgs e)
{
ConsumableModel consumMod = dgvConsumableOnStocks.SelectedItem as ConsumableModel;
if (consumMod != null)
{
ConsumableUpdates consumableUpdate = new ConsumableUpdates(this, consumMod, consumableStockModel.ID, consumMod.ID);
consumableUpdate.ShowDialog();
}
}
private void btnViewConsumableDetails_Click(object sender, RoutedEventArgs e)
{
ConsumableModel consumableModel = dgvConsumableStocks.SelectedItem as ConsumableModel;
if (consumableModel != null)
{
ConsumableStocksDetails csd = new ConsumableStocksDetails(this, consumableModel);
csd.ShowDialog();
}
else
{
MessageBox.Show("No record selected!");
}
}
private void loadConsumableList()
{
ConsumableModel consumables = new ConsumableModel();
queryString = "SELECT ID, name, description FROM dbspa.tblconsumables WHERE isDeleted = 0";
MySqlDataReader reader = conDB.getSelectConnection(queryString, null);
while (reader.Read())
{
consumables.ID = reader["ID"].ToString();
consumables.Name = reader["name"].ToString();
consumables.Description = reader["description"].ToString();
cmbConsumables.Items.Add(consumables);
if (!string.IsNullOrEmpty(consumableID))
{
if (consumableID.Equals(consumables.ID))
{
cmbConsumables.SelectedItem = consumables;
cmbConsumables.IsEnabled = false;
}
}
else
{
if (consumeStockModel != null)
{
if (consumeStockModel.ID.Equals(consumables.ID))
{
cmbConsumables.SelectedItem = consumables;
cmbConsumables.IsEnabled = false;
}
}
}
consumables = new ConsumableModel();
}
conDB.closeConnection();
}
private List <ConsumableModel> loadConsumablesOnStocks()
{
List <ConsumableModel> lstConsumablesStocks = new List <ConsumableModel>();
ConsumableModel consumeStock = new ConsumableModel();
queryString = "Select dbspa.tblconsumableleft.consumableID, dbspa.tblconsumables.description, COUNT(*) as cnt FROM " +
"(dbspa.tblconsumableleft INNER JOIN dbspa.tblconsumables ON dbspa.tblconsumableleft.consumableID = dbspa.tblconsumables.ID) " +
"WHERE dbspa.tblconsumableleft.isDeleted = 0 GROUP BY dbspa.tblconsumableleft.consumableID";
MySqlDataReader reader = conDB.getSelectConnection(queryString, null);
while (reader.Read())
{
consumeStock.ID = reader["consumableID"].ToString();
consumeStock.Description = reader["description"].ToString();
consumeStock.Count = reader["cnt"].ToString();
lstConsumablesStocks.Add(consumeStock);
consumeStock = new ConsumableModel();
}
conDB.closeConnection();
return(lstConsumablesStocks);
}
private List <ConsumableModel> loadConsumables()
{
List <ConsumableModel> lstConsumables = new List <ConsumableModel>();
ConsumableModel consumables = new ConsumableModel();
queryString = "SELECT ID, name, description FROM dbspa.tblconsumables WHERE isDeleted = 0";
MySqlDataReader reader = conDB.getSelectConnection(queryString, null);
while (reader.Read())
{
consumables.ID = reader["ID"].ToString();
consumables.Name = reader["name"].ToString();
consumables.Description = reader["description"].ToString();
lstConsumables.Add(consumables);
consumables = new ConsumableModel();
}
conDB.closeConnection();
return(lstConsumables);
}
public ConsumableStocksDetails(ConsumableWindow consWin, ConsumableModel cnsMod)
{
consumableStockModel = cnsMod;
consumableWindow = consWin;
InitializeComponent();
}
public ConsumableUpdates(ConsumableStocksDetails csd, ConsumableModel cm)
{
consumableStockDetWindow = csd;
consumeStockModel = cm;
InitializeComponent();
}
public ConsumableDetails(ConsumableWindow consumWin, ConsumableModel consumMod)
{
consumableWin = consumWin;
consumableMod = consumMod;
InitializeComponent();
}
