/// <summary>
///
/// it setup connection, also reads data from database tables and stores them in List of Item
/// and returns that list
/// </summary>
private List <Item> RetrievingDataFromDataBase()
{
List <Item> ItemsList = new List <Item>();
string viewString = stockInstance.DisplayValues();
SqlConnection con = dbmsInstance.SettingUPConnectionWithDataBase();
con.Open();
SqlCommand cmd = new SqlCommand(viewString, con);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
ItemsList.Add(ItemWithValues(reader));
}
reader.Close();
con.Close();
return(ItemsList);
}
/// <summary>
///
/// it setup connection, also reads data from database tables and stores them in List of Item
/// and returns that list
/// </summary>
private List <Item> RetrievingDataFromDataBase()
{
List <Item> ItemsList = new List <Item>();
string startDate = Convert.ToDateTime(dateTimePicker3.Value).ToString("MM/dd/yyyy");
string endDate = Convert.ToDateTime(dateTimePicker1.Value).ToString("MM/dd/yyyy");
string viewString = predictionInstance.DisplayValues(startDate, endDate);
SqlConnection con = dbmsInstance.SettingUPConnectionWithDataBase();
con.Open();
SqlCommand cmd = new SqlCommand(viewString, con);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
ItemsList.Add(utitility.ItemWithAllValues(reader));
}
reader.Close();
con.Close();
return(ItemsList);
}
/// <summary>
/// executes passed query
/// </summary>
/// <returns></returns>
public SqlConnection GetSqlConnection()
{
SqlConnection con = dbmsInstance.SettingUPConnectionWithDataBase();
return(con);
}