private void SaveButton_Click(object sender, EventArgs e)
{
int er = 0;
ep.Clear();
if (categoryComboBox.Text == "")
{
er++;
ep.SetError(categoryComboBox, "Required");
}
if (companyComboBox.Text == "")
{
er++;
ep.SetError(companyComboBox, "Required");
}
if (itemComboBox.Text == "")
{
er++;
ep.SetError(itemComboBox, "Required");
}
if (stokInTextBox.Text == "")
{
er++;
ep.SetError(stokInTextBox, "Required");
}
if (er > 0)
{
return;
}
Model.StockIn stockIn = new Model.StockIn();
stockIn.CompanyId = Convert.ToInt64(companyComboBox.SelectedValue);
stockIn.CategoryId = Convert.ToInt64(categoryComboBox.SelectedValue);
stockIn.ItemId = Convert.ToInt64(itemComboBox.SelectedValue);
stockIn.AvailableQuantity = Convert.ToInt32(stokInTextBox.Text);
bool isAdded = _stockInManager.Add(stockIn);
if (isAdded)
{
MessageBox.Show("Successfully Added. ");
stokInTextBox.Clear();
}
else
{
MessageBox.Show("Sry! Added Failed.");
}
stockInItemDataGridView.DataSource = _stockInManager.StockInLoad(); // Load new StockIn Item
}
private void SaveButton_Click(object sender, EventArgs e)
{
Model.StockIn stockIn = new Model.StockIn();
stockIn.CampanyId = Convert.ToInt64(companyComboBox.SelectedValue);
stockIn.CategoryId = Convert.ToInt64(categoryComboBox.SelectedValue);
stockIn.ItemId = Convert.ToInt64(itemComboBox.SelectedValue);
stockIn.AvailableQuantity = Convert.ToInt32(stokInTextBox.Text);
bool isAdded = _stockInManager.Add(stockIn);
if (isAdded)
{
MessageBox.Show("Successfully Added. ");
stokInTextBox.Clear();
}
else
{
MessageBox.Show("Sry! Added Failed.");
}
}
public bool Add(Model.StockIn stockIn)
{
string query = @"INSERT INTO StockIn VALUES('" + stockIn.CampanyId + "','"
+ stockIn.CategoryId + "','" + stockIn.ItemId + "','"
+ stockIn.AvailableQuantity + "')";
SqlCommand command = new SqlCommand(query, _con);
_con.Open();
bool isRowAffectred = command.ExecuteNonQuery() > 0;
_con.Close();
/// *************************** //
string query_check_item = @"SELECT COUNT(*) FROM StockIn WHERE ItemId='" + stockIn.ItemId + "' ";
SqlCommand command_check_item = new SqlCommand(query_check_item, _con);
_con.Open();
SqlDataAdapter dr = new SqlDataAdapter(command_check_item);
DataTable dt = new DataTable();
dr.Fill(dt);
if (Convert.ToInt32(dt.Rows[0][0]) > 1)
{
// ************************
_con.Close();
// Show Item Available Quantity
string queryItemAvailable = "SELECT * FROM ItemAvailableQuantity WHERE ItemId='" + stockIn.ItemId + "'";
SqlCommand command_available = new SqlCommand(queryItemAvailable, _con);
_con.Open();
SqlDataReader drAvailable = command_available.ExecuteReader();
if (drAvailable.Read())
{
// student.Name = dr.GetValue(2).ToString();
int stockInUpdate = Convert.ToInt32(drAvailable["AvailableQuantity"]);
stockIn.AvailableQuantity = stockInUpdate + stockIn.AvailableQuantity;
}
_con.Close();
// ******************
string query_update = @"UPDATE ItemAvailableQuantity SET AvailableQuantity='" + stockIn.AvailableQuantity + "' WHERE ItemId='" + stockIn.ItemId + "' ";
SqlCommand command_update = new SqlCommand(query_update, _con);
_con.Open();
bool isRowAffectred1 = command_update.ExecuteNonQuery() > 0;
_con.Close();
// ************************ //
}
else
{
// ************************
_con.Close();
string query1 = @"INSERT INTO ItemAvailableQuantity VALUES('" + stockIn.ItemId + "','"
+ stockIn.AvailableQuantity + "')";
SqlCommand command1 = new SqlCommand(query1, _con);
_con.Open();
bool isRowAffectred1 = command1.ExecuteNonQuery() > 0;
_con.Close();
// ************************ //
}
return(isRowAffectred);
}
public bool Add(Model.StockIn stockIn)
{
bool isAdded = _stockInRepository.Add(stockIn);
return(isAdded);
}
