private List <BusinessObjects.Stock> Get0StockList(string connString)
{
try
{
List <BusinessObjects.Stock> ProductList = new List <BusinessObjects.Stock>();
string query = "select stock_id,sup_name, s_date,invoice_no from _Stokc";
SqlConnection conn = DBHelper.GetConnection(connString);
conn.Open();
SqlDataReader reader = DBHelper.ReadData(query, conn);
while (reader.Read())
{
BusinessObjects.Stock pObj = new BusinessObjects.Stock();
pObj.stock_id = Convert.ToInt32(reader[0].ToString());
pObj.sup_name = reader[1].ToString();
pObj.s_date = Convert.ToDateTime(reader[2].ToString());
pObj.invoice_no = reader[3].ToString();
//retreiving relevant stock_product detail based on stock id
BusinessObjects.stock_product sp = new stock_product();
sp.stock_id = pObj.stock_id;
pObj.StockProductList = sp.Get_stock_by_sid(connString);
ProductList.Add(pObj);
}
conn.Close();
return(ProductList);
}
catch (Exception ex)
{
throw ex;
}
}
private void btnAddStockItem_Click(object sender, EventArgs e)
{
//try
//{
int checkloop = 0;
int prodID = 0;
int quntyToAddList = 0;
string prName = "";
string col1 = "";
foreach (DataGridViewRow dr in tblProduct.Rows)
{
//if (dr.Cells[4].Value != null || dr.Cells[4].Value!=string.Empty && dr.Cells[3].Value != null || dr.Cells[3].Value != string.Empty)
if (dr.Cells[4].Value != null && dr.Cells[3].Value != null)
{
checkloop++;
decimal priceTyped = 0;
col1 = dr.Cells[4].Value.ToString();
prodID = Convert.ToInt32(dr.Cells[0].Value.ToString());
priceTyped = Convert.ToDecimal(dr.Cells[3].Value.ToString());//getting teh price
quntyToAddList = Convert.ToInt32(dr.Cells[4].Value.ToString());
prName = dr.Cells[1].Value.ToString();
int check = 0;
bool result = stock_product_list.Any();
if (result)
{
foreach (stock_product item in stock_product_list)
{
if (item.pid == prodID)
{
item.quantity = item.quantity + quntyToAddList;
item.price = priceTyped;
check = 1;
}
}
}
if (check == 0)
{
stock_product Stock_product = new BusinessObjects.stock_product();
Stock_product.pid = prodID;
Stock_product.p_name = prName;
Stock_product.price = priceTyped;//adding the price
Stock_product.quantity = quntyToAddList;
Stock_product.stock_id = Convert.ToInt32(txtStockID.Text.ToString());
stock_product_list.Add(Stock_product);
// }
//}
}
else
{
check = 0;
}
}
}
if (checkloop > 0)
{
foreach (DataGridViewRow dr in tblProduct.Rows)
{
// dr.Cells[4].Value = string.Empty;
dr.Cells[4].Value = null;
}
//MessageBox.Show("Products were added");
PopupNotifier pop = new PopupNotifier();
pop.ContentText = "Products were added";
pop.TitleText = "Notification";
// pop.Image = Resources.Button_Icon_Orange_svg; // or Image.FromFile(--Path--)
pop.IsRightToLeft = false;
pop.ContentHoverColor = Color.Blue;
pop.Popup();
}
else
{
foreach (DataGridViewRow dr in tblProduct.Rows)
{
//dr.Cells[4].Value = string.Empty;
dr.Cells[4].Value = null;
}
//MessageBox.Show("No Products were added");
PopupNotifier pop = new PopupNotifier();
pop.ContentText = "No products were added";
pop.TitleText = "Notification";
// pop.Image = Resources.Button_Icon_Orange_svg; // or Image.FromFile(--Path--)
pop.IsRightToLeft = false;
pop.ContentHoverColor = Color.Blue;
pop.Popup();
}
//}
//catch (Exception ex)
//{
// MetroMessageBox.Show(this, ex.Message, "System Error!", MessageBoxButtons.OKCancel, MessageBoxIcon.Error);
//}
}
private void tblProduct_CellClick(object sender, DataGridViewCellEventArgs e)
{
try
{
int rw = e.RowIndex;
int cl = e.ColumnIndex;
int pid = 0;
if (cl == 5)
{
foreach (Form form in Application.OpenForms)
{
if (form.GetType().Name == "View_Dercription")
{
MetroMessageBox.Show(this, "Form is already opened", "System Message!", MessageBoxButtons.OKCancel, MessageBoxIcon.Error);
return;
}
}
pid = Convert.ToInt32(tblProduct.Rows[rw].Cells[0].Value.ToString());
string desc = "";
foreach (M_Product_BS item in cObjList)
{
if (item.ID == pid)
{
desc = item.description;
}
}
using (View_Dercription m = new View_Dercription(desc))
{
m.Show(this);
}
return;
}
else if (cl == 6)
{
pid = Convert.ToInt32(tblProduct.Rows[rw].Cells[0].Value.ToString());
if (tblProduct.Rows[rw].Cells[4].Value == null)
{
MessageBox.Show("Please enter quanity");
return;
}
if (tblProduct.Rows[rw].Cells[3].Value == null)
{
MessageBox.Show("Cost should not be null");
return;
}
int check = 0;
bool result = stock_product_list.Any();
if (result)
{
foreach (stock_product item in stock_product_list)
{
if (item.pid == pid)
{
item.price = Convert.ToDecimal(tblProduct.Rows[rw].Cells[3].Value.ToString());
item.quantity = item.quantity + Convert.ToInt32(tblProduct.Rows[rw].Cells[4].Value.ToString());
check = 1;
}
}
}
if (check == 0)
{
foreach (M_Product_BS item in cObjList)
{
if (item.ID == pid)
{
stock_product Stock_product = new BusinessObjects.stock_product();
Stock_product.pid = item.ID;
Stock_product.p_name = item.name;
Stock_product.price = Convert.ToDecimal(tblProduct.Rows[rw].Cells[3].Value.ToString());
Stock_product.quantity = Convert.ToInt32(tblProduct.Rows[rw].Cells[4].Value.ToString());
Stock_product.stock_id = Convert.ToInt32(txtStockID.Text.ToString());
stock_product_list.Add(Stock_product);
MessageBox.Show("Product Added");
}
}
}
else
{
check = 0;
}
////this is to testing purpose
//foreach (stock_product item in stock_product_list)
// {
// MessageBox.Show(item.p_name + " "+ item.quantity.ToString());
// }
}
else
{
return;
}
}
catch (Exception ex)
{
MetroMessageBox.Show(this, ex.Message, "System Error!", MessageBoxButtons.OKCancel, MessageBoxIcon.Error);
}
}
