public List <StockPeriodical> searchStockByReorderLevel(StockPeriodical stockPeriodical)
{
string connectionString = _connectionRepository.GetConnectionString();
SqlConnection sqlConnection = new SqlConnection(connectionString);
string CommandString = @"SELECT * FROM StockPeriodical WHERE (StartDate >= '" + stockPeriodical.startDate + "' AND EndDate <= '" + stockPeriodical.endDate + "') ORDER BY ReorederLevel ";
// SELECT* FROM Product_sales WHERE From_date >= '03-Jan-2013' AND To_date <= '09-Jan-2013'
SqlCommand sqlCommand = new SqlCommand(CommandString, sqlConnection);
sqlConnection.Open();
List <StockPeriodical> searchPeriodicalStocks = new List <StockPeriodical>();
SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
while (sqlDataReader.Read())
{
StockPeriodical _stockPeriodical = new StockPeriodical();
_stockPeriodical.ProductCode = Convert.ToString(sqlDataReader["Category"]) + Convert.ToString(sqlDataReader["Code"]);
_stockPeriodical.productName = Convert.ToString(sqlDataReader["Name"]);
_stockPeriodical.productCategory = Convert.ToString(sqlDataReader["Category"]);
_stockPeriodical.Reorderlavel = Convert.ToInt32(sqlDataReader["ReorederLevel"]);
_stockPeriodical.ExpiredDate = Convert.ToString(sqlDataReader["Expired Date"]);
_stockPeriodical.OpeningBalance = Convert.ToInt32(sqlDataReader["Openning Balance"]);
_stockPeriodical.In = Convert.ToInt32(sqlDataReader["In"]);
_stockPeriodical.Out = Convert.ToInt32(sqlDataReader["Out"]);
_stockPeriodical.ClosingBalance = Convert.ToInt32(sqlDataReader["Closing Balance"]);
searchPeriodicalStocks.Add(_stockPeriodical);
}
sqlConnection.Close();
// return list.Count >0 ? list : null ;
return(searchPeriodicalStocks);
}
public List <StockPeriodical> searchByLosearchBwerreorderLevelStock(StockPeriodical stockPeriodical)
{
string connectionString = @"Server=FATEMA;DataBase=Project1DB;Integrated Security=true";
SqlConnection sqlConnection = new SqlConnection(connectionString);
string CommandString = @"SELECT * FROM StockPeriodical WHERE StartDate >= '" + stockPeriodical.startDate + "' AND EndDate <= '" + stockPeriodical.endDate + "' ";
// SELECT* FROM Product_sales WHERE From_date >= '03-Jan-2013' AND To_date <= '09-Jan-2013'
SqlCommand sqlCommand = new SqlCommand(CommandString, sqlConnection);
sqlConnection.Open();
List <StockPeriodical> searchPeriodicalStocks = new List <StockPeriodical>();
SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
while (sqlDataReader.Read())
{
StockPeriodical _stockPeriodical = new StockPeriodical();
_stockPeriodical.Code = Convert.ToString(sqlDataReader["Code"]);
_stockPeriodical.productName = Convert.ToString(sqlDataReader["Name"]);
_stockPeriodical.productCategory = Convert.ToString(sqlDataReader["Category"]);
_stockPeriodical.Reorderlavel = Convert.ToInt32(sqlDataReader["ReorederLevel"]);
_stockPeriodical.ExpiredDate = Convert.ToString(sqlDataReader["Expired Date"]);
_stockPeriodical.OpeningBalance = Convert.ToInt32(sqlDataReader["Openning Balance"]);
_stockPeriodical.In = Convert.ToInt32(sqlDataReader["In"]);
_stockPeriodical.Out = Convert.ToInt32(sqlDataReader["Out"]);
_stockPeriodical.ClosingBalance = Convert.ToInt32(sqlDataReader["Closing Balance"]);
searchPeriodicalStocks.Add(_stockPeriodical);
}
sqlConnection.Close();
return(searchPeriodicalStocks);
}
public bool hasProductExist(StockPeriodical stockPeriodical)
{
bool Exist = false;
try
{
string connectionString = _connectionRepository.GetConnectionString();
SqlConnection sqlConnection = new SqlConnection(connectionString);
//Comand establish
string commandString = @"SELECT Name FROM StockPeriodical WHERE Name = '" + stockPeriodical.productName + "' ";
SqlCommand sqlCommand = new SqlCommand(commandString, sqlConnection);
sqlConnection.Open();
//Sql command Execute
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(sqlCommand);
DataTable dataTable = new DataTable();
sqlDataAdapter.Fill(dataTable);
//Ckeck for uniqueness
if (dataTable.Rows.Count > 0)
{
Exist = true;
}
sqlConnection.Close();
}
catch (Exception exception)
{
// MessageBox.Show(exception.Message);
}
return(Exist);
}
public bool hasProductExist(StockPeriodical stockPeriodical)
{
return(_stockPeriodicalRepository.hasProductExist(stockPeriodical));
}
//SEARCH BY LOWER REORDER LEVEL
public List <StockPeriodical> searchStockByReorderLevel(StockPeriodical stockPeriodical)
{
return(_stockPeriodicalRepository.searchStockByReorderLevel(stockPeriodical));
}
public List <StockPeriodical> searchStock(StockPeriodical stockPeriodical)
{
return(_stockPeriodicalRepository.searchStock(stockPeriodical));
}
public List <StockPeriodical> searchStock(StockPeriodical stockPeriodical)
{
return(_stockPeriodicalRepository.searchStock(stockPeriodical));
//return _purchaseRepotingRepository.SearchValue(purchaseRepotingModel);
}
public List <StockPeriodical> searchByLosearchBwerreorderLevelStock(StockPeriodical stockPeriodical)
{
return(_stockPeriodicalRepository.searchByLosearchBwerreorderLevelStock(stockPeriodical));
}
