public bool Update(StockInClass stockIn)
{
bool isUpdated;
SqlCommand command = new SqlCommand(@"SELECT * FROM Transanction
INNER JOIN Item On Item.ItemId=Transanction.ItemId
WHERE Item.ItemName='" + stockIn.ItemName + "'", connection);
connection.Open();
// SqlDataAdapter da = new SqlDataAdapter(command);
SqlDataReader dr = command.ExecuteReader();
if (dr.HasRows)
{
connection.Close();
connection.Open();
SqlCommand command2 = new SqlCommand(@"Update Transanction Set AvailableQuantity='" + stockIn.AvailableQuantity + "'Where ItemId='" + stockIn.ItemId + "'", connection);
isUpdated = command2.ExecuteNonQuery() > 0;
}
else
{
connection.Close();
connection.Open();
SqlCommand command2 = new SqlCommand(@"INSERT INTO Transanction(ItemId,AvailableQuantity) values('" + stockIn.ItemId + "','" + stockIn.AvailableQuantity + "')", connection);
isUpdated = command2.ExecuteNonQuery() > 0;
}
connection.Close();
return(isUpdated);
}
//*****************************************************************//
private void SaveButton_Click(object sender, EventArgs e)
{
StockInClass stockIn = new StockInClass();
if (itemComboBox.SelectedItem == null)
{
MessageBox.Show("Plaease select an Item");
return;
}
if (categoryComboBox.SelectedItem == null)
{
MessageBox.Show("Plaease select an Category");
return;
}
if (companyComboBox.SelectedItem == null)
{
MessageBox.Show("Plaease select an Company");
return;
}
stockIn.ItemName = itemComboBox.Text;
stockIn.ItemId = stockInManager.GetItemId(stockIn);
stockIn.AvailableQuantity = Convert.ToInt32(availableQuantityLabel.Text);
bool isTrue = stockInManager.Validation(quantityTextBox.Text);
if (!isTrue)
{
MessageBox.Show("Please Enter a Valid Number!");
return;
}
stockIn.StockInQuantity = Convert.ToInt32(quantityTextBox.Text);
stockIn.AvailableQuantity += stockIn.StockInQuantity;
bool isAdded = stockInManager.Update(stockIn);
if (isAdded)
{
MessageBox.Show("Stock In Succesful!");
quantityTextBox.Text = String.Empty;
}
else
{
MessageBox.Show("Stock In Failed!");
}
categoryComboBox.Text = "------Select--------";
companyComboBox.Text = "------Select--------";
itemComboBox.Text = "------Select--------";
reorderLevelLabel.Text = String.Empty;
availableQuantityLabel.Text = String.Empty;
}
public int GetItemId(StockInClass stockIn)
{
int itemId = 0;
SqlCommand command = new SqlCommand(@"Select ItemId From Item WHERE ItemName='" + stockIn.ItemName + "'", connection);
connection.Open();
SqlDataReader dr = command.ExecuteReader();
if (dr.Read())
{
itemId = (int)dr["ItemId"];
}
connection.Close();
return(itemId);
}
public int GetItemId(StockInClass stockIn)
{
int itemId = stockInRepository.GetItemId(stockIn);
return(itemId);
}
public bool Update(StockInClass stockIn)
{
bool isAdded = stockInRepository.Update(stockIn);
return(isAdded);
}
