private void cmbPCat_SelectedIndexChanged(object sender, EventArgs e)
{
try{
if (checkSelectedIndexChange)
{
Category_BS cat = new Category_BS();
cat = (Category_BS)cmbPCat.SelectedItem;
// MessageBox.Show(cat.ID.ToString());
List <GetProductStock> ListItem = new List <GetProductStock>();
GetProductStock lObj = new GetProductStock();
ListItem = lObj.getProdAlongWithStockQuantity_ByCatID(con, cat.ID);
loadGrid(ListItem);
checkSelectedIndexChange = false;
}
else
{
checkSelectedIndexChange = false;
}
}
catch (Exception ex)
{
MetroMessageBox.Show(this, "System Error " + ex.Message, "System Error !", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void lnkOK_Click(object sender, EventArgs e)
{
try
{
if (string.IsNullOrEmpty(txtCategory.Text))
{
MetroMessageBox.Show(this, "Please enter valid data to the text fields", "MetroMessageBox", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
Category_BS CBS = new Category_BS();
string name = txtCategory.Text;
CBS.name = name;
if (CBS.Add(con))
{
MetroMessageBox.Show(this, "Successfully Saved", "MetroMessageBox", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
else
{
MetroMessageBox.Show(this, "System error", "MetroMessageBox", MessageBoxButtons.RetryCancel, MessageBoxIcon.Error);
}
}
catch (Exception ex)
{
MetroMessageBox.Show(this, "System error " + ex.Message, "MetroMessageBox", MessageBoxButtons.RetryCancel, MessageBoxIcon.Error);
}
}
private void cmbECategory_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
if (checkSelectedIndexChange)
{
Category_BS cat = (Category_BS)cmbECategory.SelectedItem;
Sales_BM sale = new Sales_BM();
List <Sales_BM> saleList = new List <Sales_BM>();
saleList = sale.getSalesByCatID(con, cat.ID);
loadGrid(saleList);
checkSelectedIndexChange = false;
}
else
{
checkSelectedIndexChange = false;
}
}
catch (Exception ex)
{
MetroMessageBox.Show(this, "System Error " + ex.Message, "System Error !", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void InitialloadGrid()
{
try
{
List <GetProductStock> GridList = new List <GetProductStock>();
BusinessObjects.GetProductStock spObj = new GetProductStock();
GridList = spObj.getProdAlongWithStockQuantity_All(con);
List <M_Product_BS> cObjList = new List <M_Product_BS>();
BusinessObjects.M_Product_BS cObj = new M_Product_BS();
cObjList = cObj.GetProducts(con);
//MessageBox.Show(cObjList.Count.ToString());
//this is to set the category name
List <Category_BS> catList = new List <Category_BS>();
Category_BS catObj = new Category_BS();
catList = catObj.GetCategory(con);
foreach (Category_BS itemCat in catList)
{
foreach (GetProductStock itemProd in GridList)
{
if (itemProd.category == itemCat.ID)
{
itemProd.catObj = itemCat;
}
}
}
int i = 0;
tblProduct.Rows.Clear();
foreach (GetProductStock item in GridList)
{
if (item.TotalQuantity > 3)
{
continue;
}
tblProduct.Rows.Add();
tblProduct.Rows[i].Cells[0].Value = item.ID;
tblProduct.Rows[i].Cells[1].Value = item.name;
tblProduct.Rows[i].Cells[2].Value = item.catObj.name;
tblProduct.Rows[i].Cells[3].Value = item.cost;
tblProduct.Rows[i].Cells[4].Value = item.unitPrice;
tblProduct.Rows[i].Cells[5].Value = item.warranty;
tblProduct.Rows[i].Cells[6].Value = item.TotalQuantity;
i++;
}
}
catch (Exception ex)
{
MetroMessageBox.Show(this, "System Error " + ex.Message, "MetroMessageBox", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void cmbECategory_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
if (checkSelectedIndexChange)
{
Category_BS cat = (Category_BS)cmbECategory.SelectedItem;
Stock stock = new Stock();
List <Stock> stockList2 = new List <Stock>();
stockList2 = stock.GetOneStockByCatID(con, cat.ID);
int i = 0;
tblProduct.Rows.Clear();
foreach (Stock item in stockList2)
{
tblProduct.Rows.Add();
tblProduct.Rows[i].Cells[0].Value = item.stock_id;
tblProduct.Rows[i].Cells[1].Value = item.invoice_no;
tblProduct.Rows[i].Cells[2].Value = item.sup_name;
tblProduct.Rows[i].Cells[3].Value = item.s_date.ToString();
foreach (Stock stock2 in StockList)
{
if (item.stock_id == stock2.stock_id)
{
tblProduct.Rows[i].Cells[4].Value = stock2.StockProductList.Count;
}
}
tblProduct.Rows[i].Cells[5].Value = "Edit";
tblProduct.Rows[i].Cells[6].Value = "View";
i++;
}
checkSelectedIndexChange = false;
}
else
{
checkSelectedIndexChange = false;
}
}
catch (Exception ex)
{
MetroMessageBox.Show(this, "System Error " + ex.Message, "System Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void Init()
{
// In danh sach category
this.category_bs = new Category_BS();
List <string> category_list = this.category_bs.get_category();
this.CategoryList.DataSource = category_list;
//In toan bo sach
this.book_bs = new Book_BS();
DataTable book_data = this.book_bs.get_all_book();
this.BookTable.DataSource = book_data;
} // Khoi tao du lieu
private void InitialloadGrid()
{
try
{
BusinessObjects.GetProductStock spObj = new GetProductStock();
BusinessObjects.M_Product_BS cObj = new M_Product_BS();
cObjList = cObj.GetProducts(con);
Category_BS catObj = new Category_BS();
catList = catObj.GetCategory(con);
}
catch (Exception ex)
{
MetroMessageBox.Show(this, "System Error " + ex.Message, "MetroMessageBox", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void loadGrid()
{
try
{
BusinessObjects.M_Product_BS cObj = new M_Product_BS();
cObjList = cObj.GetProducts(con);
//MessageBox.Show(cObjList.Count.ToString());
Category_BS catObj = new Category_BS();
catList = catObj.GetCategory(con);
foreach (Category_BS itemCat in catList)
{
foreach (M_Product_BS itemProd in cObjList)
{
if (itemProd.category == itemCat.ID)
{
itemProd.catObj = itemCat;
}
}
}
int i = 0;
tblProduct.Rows.Clear();
//MessageBox.Show(cObjList.Count.ToString());
foreach (M_Product_BS item in cObjList)
{
tblProduct.Rows.Add();
tblProduct.Rows[i].Cells[0].Value = item.ID;
tblProduct.Rows[i].Cells[1].Value = item.name;
tblProduct.Rows[i].Cells[2].Value = item.catObj.name;
tblProduct.Rows[i].Cells[3].Value = item.cost;
tblProduct.Rows[i].Cells[4].Value = item.unitPrice;
tblProduct.Rows[i].Cells[5].Value = item.warranty;
tblProduct.Rows[i].Cells[6].Value = "Edit";
i++;
}
autoComplete();
}
catch (Exception ex)
{
MetroMessageBox.Show(this, "System Error " + ex.Message, "MetroMessageBox", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void cmbECategory_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
if (checkSelectedIndexChange)
{
Category_BS cat = (Category_BS)cmbECategory.SelectedItem;
Purchase stock = new Purchase();
List <Purchase> stockList2 = new List <Purchase>();
stockList2 = stock.GetPurchaseByCatID(con, cat.ID);
int i = 0;
tblProduct.Rows.Clear();
foreach (Purchase item in stockList2)
{
tblProduct.Rows.Add();
tblProduct.Rows[i].Cells[0].Value = item.stock_id;
tblProduct.Rows[i].Cells[1].Value = item.invoice_no;
tblProduct.Rows[i].Cells[2].Value = item.sup_name;
tblProduct.Rows[i].Cells[3].Value = item.s_date.ToString();
tblProduct.Rows[i].Cells[4].Value = item.grandTotal;
tblProduct.Rows[i].Cells[5].Value = "View";
i++;
}
checkSelectedIndexChange = false;
}
else
{
checkSelectedIndexChange = false;
}
}
catch (Exception ex)
{
MetroMessageBox.Show(this, "System Error " + ex.Message, "System Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void cmbPCat_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
//DateTime sDate = DateTime.ParseExact(dateStart.ToString(), "yyyy/MM/dd", null);
//DateTime eDate = DateTime.ParseExact(dateEnd.ToString(), "yyyy/MM/dd", null);
if (checkSelectedIndexChange)
{
//DateTime sDate = Convert.ToDateTime(dateStart.Text);
//DateTime eDate = Convert.ToDateTime(dateEnd.Text);
DateTime sDate = DateTime.ParseExact(dateStart.Text, "MM/dd/yyyy", CultureInfo.InvariantCulture);
DateTime eDate = DateTime.ParseExact(dateEnd.Text, "MM/dd/yyyy", CultureInfo.InvariantCulture);
Category_BS cat = new Category_BS();
cat = (Category_BS)cmbPCat.SelectedItem;
List <GetProductStock> ListItem = new List <GetProductStock>();
GetProductStock lObj = new GetProductStock();
//MessageBox.Show(cat.ID.ToString());
ListItem = lObj.getProdAlongWithSalesQuantity_ByCatID(con, cat.ID, sDate, eDate);
checkSelectedIndexChange = false;
loadGrid(ListItem);
}
else
{
checkSelectedIndexChange = false;
}
}
catch (Exception ex)
{
MetroMessageBox.Show(this, "System Error " + ex.Message, "MetroMessageBox", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void cmbPCat_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
if (checkSelectedIndexChange)
{
Category_BS cat = (Category_BS)cmbPCat.SelectedItem;
int i = 0;
tblProduct.Rows.Clear();
foreach (M_Product_BS item in cObjList)
{
if (item.catObj == cat)
{
tblProduct.Rows.Add();
tblProduct.Rows[i].Cells[0].Value = item.ID;
tblProduct.Rows[i].Cells[1].Value = item.name;
tblProduct.Rows[i].Cells[2].Value = item.catObj.name;
tblProduct.Rows[i].Cells[3].Value = item.cost;
tblProduct.Rows[i].Cells[4].Value = item.unitPrice;
tblProduct.Rows[i].Cells[5].Value = item.warranty;
tblProduct.Rows[i].Cells[6].Value = "Edit";
i++;
}
}
checkSelectedIndexChange = false;
}
else
{
checkSelectedIndexChange = false;
}
}
catch (Exception ex)
{
MetroMessageBox.Show(this, "System Error " + ex.Message, "System Error !", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void loadGrid()
{
try
{
BusinessObjects.Category_BS cObj = new Category_BS();
List <BusinessObjects.Category_BS> cObjList = new List <Category_BS>();
cObjList = cObj.GetCategory(con);
int i = 0;
grdCategory.Rows.Clear();
foreach (Category_BS item in cObjList)
{
grdCategory.Rows.Add();
grdCategory.Rows[i].Cells[0].Value = item.ID;
grdCategory.Rows[i].Cells[1].Value = item.name;
i++;
}
}
catch (Exception ex)
{
MetroMessageBox.Show(this, "System Error " + ex.Message, "MetroMessageBox", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void autoComplete()
{
try
{
txtPID.AutoCompleteMode = AutoCompleteMode.Suggest;
txtPID.AutoCompleteSource = AutoCompleteSource.CustomSource;
txtPName.AutoCompleteMode = AutoCompleteMode.Suggest;
txtPName.AutoCompleteSource = AutoCompleteSource.CustomSource;
AutoCompleteStringCollection stringColl = new AutoCompleteStringCollection();
AutoCompleteStringCollection stringColl2 = new AutoCompleteStringCollection();
BusinessObjects.M_Product_BS cObj = new M_Product_BS();
cObjList = cObj.GetProducts(con);
Category_BS catObj = new Category_BS();
catList = catObj.GetCategory(con);
foreach (M_Product_BS item in cObjList)
{
stringColl.Add(item.ID.ToString());
stringColl2.Add(item.name);
}
txtPID.AutoCompleteCustomSource = stringColl;
txtPName.AutoCompleteCustomSource = stringColl2;
cmbPCat.DataSource = null;
cmbPCat.DataSource = catList;
cmbPCat.DisplayMember = "name";
cmbPCat.ValueMember = "ID";
}
catch (Exception ex)
{
MetroMessageBox.Show(this, "System Error " + ex.Message, "MetroMessageBox", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
