private void comboBoxSelectProduct_SelectedIndexChanged(object sender, EventArgs e)
{
DataTable dt = new DataTable();
dt = retrieve.GetId("usp_GetProductID", comboBoxSelectProduct.Text);
textBoxQuantity.Clear();
textBoxTotalCost.Clear();
textBoxProdCost.Clear();
if (dt.Rows.Count > 0)
{
ProductId = Convert.ToInt32(dt.Rows[0][0].ToString());
DataTable dtPrice = new DataTable();
dtPrice = retrieve.GetProductPrice(ProductId);
if (dtPrice.Rows.Count > 0)
{
textBoxProdCost.Text = dtPrice.Rows[0][0].ToString();
}
foreach (DataGridViewRow row in dataGridViewPOLines.Rows)
{
if (Convert.ToInt32(row.Cells["ProductIdGv"].Value) == ProductId)
{
textBoxQuantity.Text = (row.Cells["ProductQuantityGv"].Value).ToString();
textBoxTotalCost.Text = (row.Cells["ProductTotalPrice"].Value).ToString();
break;
}
}
}
}
private void ImportFileData(DataTable dt)
{
try
{
Updation update = new Updation();
foreach (DataRow row in dt.Rows)
{
DataTable dtProductId = retrieve.GetId("usp_GetProductID", row[0].ToString());
//stocks in
update.UpdateIncreaseAvailableStocks(Convert.ToInt32(dtProductId.Rows[0][0].ToString()), Convert.ToDecimal(row[2]), Convert.ToDateTime(row[1]));
//stocks out
update.UpdateDecreaseAvailableStocks(Convert.ToInt32(dtProductId.Rows[0][0].ToString()), Convert.ToDecimal(row[3]), Convert.ToDateTime(row[1]));
//stock onhold
update.UpdateIncreaseInOnHoldStocks(Convert.ToInt32(dtProductId.Rows[0][0].ToString()), Convert.ToDecimal(row[4]), Convert.ToDateTime(row[1]));
//resolve onhold
update.UpdateResolveInOnHoldStocks(Convert.ToInt32(dtProductId.Rows[0][0].ToString()), Convert.ToDecimal(row[5]), Convert.ToDateTime(row[1]));
//stock rejected
update.UpdateIncreaseRejectedStocks(Convert.ToInt32(dtProductId.Rows[0][0].ToString()), Convert.ToDecimal(row[6]), Convert.ToDateTime(row[1]));
//resolve rejected
update.UpdateIResolveRejectedStocks(Convert.ToInt32(dtProductId.Rows[0][0].ToString()), Convert.ToDecimal(row[7]), Convert.ToDateTime(row[1]));
//stock reworked
update.UpdateIncreaseInReworkedStocks(Convert.ToInt32(dtProductId.Rows[0][0].ToString()), Convert.ToDecimal(row[8]), Convert.ToDateTime(row[1]));
//resolve reworked
update.UpdateResolveInReworkedStocks(Convert.ToInt32(dtProductId.Rows[0][0].ToString()), Convert.ToDecimal(row[9]), Convert.ToDateTime(row[1]));
}
MainClass.ShowMessage("Stocks Updated Successfully. ", "Success", "Success");
}
catch (Exception exp)
{
MainClass.ShowMessage(exp.Message, "Error", "Error");
}
}
private void buttonExport_Click(object sender, EventArgs e)
{
string pathCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + textBoxPath.Text + "; Extended Properties=\"Excel 8.0;HDR=Yes\";";
OleDbConnection conn = new OleDbConnection(pathCon);
OleDbDataAdapter adapter = new OleDbDataAdapter("Select * from [EntrySheet$]", conn);
DataTable dt = new DataTable();
adapter.Fill(dt);
Insertion insert = new Insertion();
foreach (DataRow row in dt.Rows)
{
DataTable dtcategoryId = retrieve.GetId("usp_GetCategoryId", row[5].ToString());
insert.SaveProductDetails(row[0].ToString(), row[1].ToString(), Convert.ToDecimal(row[2]), row[3].ToString(), Convert.ToDecimal(row[4]), Convert.ToInt32(dtcategoryId.Rows[0][0].ToString()), Convert.ToDecimal(row[5]));
}
retrieve.ShowProducts(dataGridViewProduct, ProductIdGv, ProductNameGv, ProductCodeGv, ProductPriceGv, ProductUnitGv, ProductMinValGv, ProductCatNameGv, ProductCatIdGv, SalesPriceGv);
}
private void comboBoxSelectProduct_SelectedIndexChanged(object sender, EventArgs e)
{
DataTable dt = new DataTable();
dt = retrieve.GetId("usp_GetProductID", comboBoxSelectProduct.Text);
textBoxQuantity.Clear();
textBoxTotalCost.Clear();
textBoxProdCost.Clear();
if (dt.Rows.Count > 0)
{
ProductId = Convert.ToInt32(dt.Rows[0][0].ToString());
DataTable dtPrice = new DataTable();
dtPrice = retrieve.GetProductPrice(ProductId);
if (dtPrice.Rows.Count > 0)
{
textBoxProdCost.Text = dtPrice.Rows[0][0].ToString();
textBoxUnit.Text = dtPrice.Rows[0][1].ToString();
}
}
}