public bool SaveStockIN(StockIN stockIN, Item item)
{
bool isSave = false;
isSave = _stockINRepository.SaveStockIN(stockIN, item);
return(isSave);
}
public ModifyStockIn(StockIN stockIN)
{
InitializeComponent();
dtToDate.Value = DateTime.Today;
dtFromDate.Value = DateTime.Today.AddDays(-10);
callingForm = stockIN;
}
private void SaveButton_Click(object sender, EventArgs e)
{
bool isSave = false;
StockIN stockIn = new StockIN();
DateTime toDateTime = DateTime.Now;
stockIn.StockInQuantity = Convert.ToDecimal(stockInQuantityTextBox.Text);
stockIn.CompanyID = Convert.ToInt32(companyComboBox.SelectedValue);
stockIn.ItemID = Convert.ToInt32(itemComboBox.SelectedValue);
stockIn.StockINDate = toDateTime;
Item item = new Item();
item.ID = stockIn.ItemID;
item.AvailableQuantity = Convert.ToDecimal(availableQuantityTextBox.Text) + stockIn.StockInQuantity;
isSave = _stockInController.SaveStockIN(stockIn, item);
if (isSave)
{
MessageBox.Show("Stock In Save!!");
Clear();
}
else
{
MessageBox.Show("Stock In Not Save!!");
}
}
public int insertIntoStockIn(StockIN stockIN)
{
sqlConnection = new SqlConnection(connectionString);
commandString = @"INSERT INTO StockIN(DT, ItemID, Amount) VALUES('" + DateTime.Now + "', '" + stockIN.ItemID + "'," + stockIN.Amount + ")";
sqlCommand = new SqlCommand(commandString, sqlConnection);
sqlConnection.Open();
int isExecuted = sqlCommand.ExecuteNonQuery();
sqlConnection.Close();
return(isExecuted);
}
public int updateStockInAmount(StockIN stockIN)
{
commandString = @"UPDATE StockIN SET Amount = " + stockIN.Amount + " WHERE ID=" + stockIN.ID + "";
sqlCommand = new SqlCommand(commandString, sqlConnection);
sqlConnection.Open();
int isExecuted = sqlCommand.ExecuteNonQuery();
sqlConnection.Close();
return(isExecuted);
}
public string findQuantity(StockIN stockIN)
{
commandString = @"SELECT Amount FROM StocksInView WHERE ID =" + stockIN.ID + "";
sqlCommand = new SqlCommand(commandString, sqlConnection);
sqlConnection.Open();
string quantity = sqlCommand.ExecuteScalar().ToString();
sqlConnection.Close();
return(quantity);
}
public bool SaveStockIN(StockIN stockIN, Item item)
{
bool isSave = false;
try
{
string stockInQuery = @"insert into StockIN (CompanyID,ItemID,StockInQuantity,StockINDate) values (" + stockIN.CompanyID + "," + stockIN.ItemID + "," + stockIN.StockInQuantity + ",'" + stockIN.StockINDate + "')";
isSave = _sqlFactory.Add(stockInQuery);
if (isSave)
{
string itemQuery = @"update Item SET AvailableQuantity=" + item.AvailableQuantity + " where ID=" + item.ID + "";
isSave = _sqlFactory.Add(itemQuery);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
return isSave;
}
public int updateStockInAmount(StockIN stockIN)
{
return(_stockInRepository.updateStockInAmount(stockIN));
}
public string findQuantity(StockIN stockIN)
{
return(_stockInRepository.findQuantity(stockIN));
}
public int insertIntoStockIn(StockIN stockIN)
{
return(_stockInRepository.insertIntoStockIn(stockIN));
}
