// GET: storeSalesInSpecificTimes
public ActionResult Index()
{
List <Models.storeSalesInSpecificTime> list1 = new List <storeSalesInSpecificTime>();
String sql = "select sales.ord_num,stores.stor_name,stores.stor_address,sales.ord_date, titles.title from sales"
+ " inner join stores on sales.stor_id = stores.stor_id"
+ " inner join titles on sales.title_id = titles.title_id"
+ " order by ord_date,title asc";
string strCon = "data source=(localdb)\\MSSQLLocalDB;initial catalog=pubs;integrated security=True;MultipleActiveResultSets=True;";
SqlConnection conn = new SqlConnection(strCon);
SqlCommand comm = new SqlCommand(sql, conn);
conn.Open();
SqlDataReader nwReader = comm.ExecuteReader();
while (nwReader.Read())
{
Models.storeSalesInSpecificTime storeSales = new Models.storeSalesInSpecificTime();
storeSales.id = nwReader[0].ToString();
storeSales.store_name = nwReader[1].ToString();
storeSales.store_adress = nwReader[2].ToString();
storeSales.title = nwReader[4].ToString();
storeSales.date = nwReader[3].ToString();
list1.Add(storeSales);
}
nwReader.Close();
conn.Close();
return(View(list1));
}
public ActionResult Index(string searchString, string searchdate1, string searchdate2)
{
List <Models.storeSalesInSpecificTime> list1 = new List <storeSalesInSpecificTime>();
string searchdate = "AND (sales.ord_date BETWEEN '" + searchdate1 + "' AND '" + searchdate2 + "')";
if (searchdate1 == "" || searchdate2 == "")
{
searchdate = "";
}
string stringwhere = "WHERE(stores.stor_name LIKE '%" + searchString + "%')";
String sql = "select sales.ord_num,stores.stor_name,stores.stor_address,sales.ord_date, titles.title from sales"
+ " inner join stores on sales.stor_id = stores.stor_id"
+ " inner join titles on sales.title_id = titles.title_id "
+ stringwhere + searchdate
+ "order by stores.stor_name ASC";
string strCon = "data source=(localdb)\\MSSQLLocalDB;initial catalog=pubs;integrated security=True;MultipleActiveResultSets=True;";
SqlConnection conn = new SqlConnection(strCon);
SqlCommand comm = new SqlCommand(sql, conn);
conn.Open();
SqlDataReader nwReader = comm.ExecuteReader();
while (nwReader.Read())
{
Models.storeSalesInSpecificTime storeSales = new Models.storeSalesInSpecificTime();
storeSales.id = nwReader[0].ToString();
storeSales.store_name = nwReader[1].ToString();
storeSales.store_adress = nwReader[2].ToString();
storeSales.title = nwReader[4].ToString();
storeSales.date = nwReader[3].ToString();
list1.Add(storeSales);
}
nwReader.Close();
conn.Close();
return(View(list1));
}
