private void btnAddNewStock_Click(object sender, EventArgs e)
{
if (cboProductName.SelectedIndex == 0)
{
MessageBox.Show("Please Select Product Name!!!", "", MessageBoxButtons.OK, MessageBoxIcon.Error);
cboProductName.Focus();
return;
}
if (cboSupplierName.SelectedIndex == 0)
{
MessageBox.Show("Please Select Supplier Name!!!", "", MessageBoxButtons.OK, MessageBoxIcon.Error);
cboSupplierName.Focus();
return;
}
if (txtQuantity.Text == "")
{
MessageBox.Show("Please Enter Product Quantity!!!", "", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtQuantity.Focus();
return;
}
StockDetails sd = new StockDetails();
sd.StockNo = txtStockNo.Text;
sd.ProductID = Convert.ToInt32(cboProductName.SelectedValue);
sd.SupplierID = Convert.ToInt32(cboSupplierName.SelectedValue);
sd.Quantity = Convert.ToInt32(txtQuantity.Text);
sd.Date = dateTimePicker1.MinDate;
bool isexists = bts.CheckExistingProductStockById(Convert.ToInt32(cboProductName.SelectedValue.ToString()));
if (isexists)
{
TempStockDetails tsd = new TempStockDetails();
tsd.ProductID = Convert.ToInt32(cboProductName.SelectedValue.ToString());
tsd.Quantity = tsd.Quantity + Convert.ToInt32(txtQuantity.Text);
int j = bts.UpdateExistingTempStock(tsd);
}
else
{
TempStockDetails tsd = new TempStockDetails();
tsd.ProductID = Convert.ToInt32(cboProductName.SelectedValue.ToString());
tsd.Quantity = Convert.ToInt32(txtQuantity.Text);
int k = bts.AddNewTempStock(tsd);
}
int i = blst.AddNewStock(sd);
if (i > 0)
{
MessageBox.Show("Stock Added Successfully", "Record", MessageBoxButtons.OK, MessageBoxIcon.Information);
Clear();
LoadStockID();
}
}
public int UpdateExistingTempStock(TempStockDetails tsd)
{
tblTemp_Stock tts = _db.tblTemp_Stock.Where(s => s.ProductID == tsd.ProductID).FirstOrDefault();
tts.ProductID = tsd.ProductID;
//tblTemp_Stock ttq = _db.tblTemp_Stock.Where(s => s.Quantity == tsd.Quantity).FirstOrDefault();
//ttq.Quantity = tsd.Quantity;
tts.Quantity = (tsd.Quantity + tts.Quantity);
return(_db.SaveChanges());
}
public int AddNewTempStock(TempStockDetails tsd)
{
tblTemp_Stock tts = new tblTemp_Stock();
//tblProduct tp = new tblProduct();
tblStock ts = new tblStock();
tts.ProductID = tsd.ProductID;
tts.Quantity = tsd.Quantity;
_db.tblTemp_Stock.Add(tts);
return(_db.SaveChanges());
}
private void btnUpdateStock_Click(object sender, EventArgs e)
{
if (cboProductName.SelectedIndex == 0)
{
MessageBox.Show("Please Select Product Name!!!", "", MessageBoxButtons.OK, MessageBoxIcon.Error);
cboProductName.Focus();
return;
}
if (cboSupplierName.SelectedIndex == 0)
{
MessageBox.Show("Please Select Supplier Name!!!", "", MessageBoxButtons.OK, MessageBoxIcon.Error);
cboSupplierName.Focus();
return;
}
if (txtQuantity.Text == "")
{
MessageBox.Show("Please Enter Product Quantity!!!", "", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtQuantity.Focus();
return;
}
//For Updating temp_stock
TempStockDetails tsd = new TempStockDetails();
tsd.ProductID = Convert.ToInt32(cboProductName.SelectedValue.ToString());
tsd.Quantity = ((tsd.Quantity + Convert.ToInt32(txtQuantity.Text)) - Convert.ToInt32(txtQuantityInitial.Text));
int j = bts.UpdateExistingTempStock(tsd);
//For Updating Stock Record or List
StockDetails sd = new StockDetails();
sd.StockID = Convert.ToInt32(txtStockID.Text);
sd.StockNo = txtStockNo.Text;
sd.ProductID = Convert.ToInt32(cboProductName.SelectedValue);
sd.SupplierID = Convert.ToInt32(cboSupplierName.SelectedValue);
sd.Quantity = Convert.ToInt32(txtQuantity.Text);
sd.Date = dateTimePicker1.MinDate;
int i = blst.UpdateStock(sd);
if (i > 0)
{
MessageBox.Show("Stock Updated Successfully", "Record", MessageBoxButtons.OK, MessageBoxIcon.Information);
Clear();
LoadStockID();
btnAddNewStock.Enabled = true;
btnUpdateStock.Enabled = false;
btnDeleteStock.Enabled = false;
}
}
private void btnDeleteStock_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Are You Sure Want To Delete Stock Record?", "Confirmation", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
//For Updating temp_stock
TempStockDetails tsd = new TempStockDetails();
tsd.ProductID = Convert.ToInt32(cboProductName.SelectedValue.ToString());
tsd.Quantity = tsd.Quantity - Convert.ToInt32(txtQuantity.Text);
int j = bts.UpdateExistingTempStock(tsd);
//For Deleting Stock Record
int i = blst.DeleteStock(Convert.ToInt32(txtStockID.Text));
if (i > 0)
{
Clear();
MessageBox.Show("Stock Record Deleted Successfully");
LoadStockID();
btnAddNewStock.Enabled = true;
btnUpdateStock.Enabled = false;
btnDeleteStock.Enabled = false;
}
}
}
