public int Save(StockIn stockIn)
{
availble = GetAvailable(stockIn.ItemName, stockIn.CompanyId);
string query = "UPDATE ItemSetup SET AvailableQuantity ='" + (availble + stockIn.StockInQuantity) + "' WHERE ItemName= '" + stockIn.ItemName + "' AND CompanyId= '" + stockIn.CompanyId + "'";
command = new SqlCommand(query, connection);
connection.Open();
int rowAffect = command.ExecuteNonQuery();
connection.Close();
return(rowAffect);
}
public int GetReorderLevel(string item, int companyId)
{
string query = "SELECT ReorderLevel FROM ItemSetup WHERE ItemName= '" + item + "' AND CompanyId ='" + companyId + "'";
command = new SqlCommand(query, connection);
connection.Open();
reader = command.ExecuteReader();
StockIn stockIn = new StockIn();
reader.Read();
if (reader.HasRows)
{
stockIn = new StockIn();
stockIn.ReorderLevel = Convert.ToInt32(reader["ReorderLevel"]);
}
reader.Close();
connection.Close();
return(stockIn.ReorderLevel);;
}
public int GetAvailable(string itemName, int companyId)
{
string query = "SELECT AvailableQuantity FROM ItemSetup WHERE ItemName= '" + itemName + "' AND CompanyId ='" + companyId + "'";
command = new SqlCommand(query, connection);
connection.Open();
reader = command.ExecuteReader();
StockIn stockIn = new StockIn();
reader.Read();
if (reader.HasRows)
{
stockIn = new StockIn();
stockIn.AvailableQuantity = Convert.ToInt32(reader["AvailableQuantity"]);
availble = stockIn.AvailableQuantity;
}
reader.Close();
connection.Close();
return(stockIn.AvailableQuantity);;
}
