public static List<OrdersListing> GetAllOrders() { //DB Connection goes here List<OrdersListing> _article = new List<OrdersListing>(); // Create the Database object, using the default database service. The // default database service is determined through configuration. Database db = DatabaseFactory.CreateDatabase(); string sqlCommand = "GetAllOrders"; DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand); // DataSet that will hold the returned results DataSet commentaryDataSet = null; commentaryDataSet = db.ExecuteDataSet(dbCommand); // Note: connection was closed by ExecuteDataSet method call foreach (DataRow dr in commentaryDataSet.Tables[0].Rows) { OrdersListing _portfoliolisting = new OrdersListing(); _portfoliolisting.OrderId = Int32.Parse(dr["OrderId"].ToString()); _portfoliolisting.UserId = dr["UserId"].ToString(); _portfoliolisting.MonthsOfSubscription = dr["NoOfMonthsSubscriptionDesc"].ToString(); _portfoliolisting.SubscriptionStartDate = DateTime.Parse(dr["SubscriptionStartDate"].ToString()); _portfoliolisting.SubscriptionEndDate = DateTime.Parse(dr["SubscriptionEndDate"].ToString()); _article.Add(_portfoliolisting); } return _article; }
/// <summary> /// /// </summary> /// <param name="filterData"></param> /// <returns></returns> public static List<OrdersListing> GetOrderFilterData(string filterData) { //DB Connection goes here List<OrdersListing> _article = new List<OrdersListing>(); // Create the Database object, using the default database service. The // default database service is determined through configuration. Database db = DatabaseFactory.CreateDatabase(); string sqlCommand = "GetAllOrders"; DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand); // Retrieve products from the specified category. //db.AddInParameter(dbCommand, "CategoryID", DbType.Int32, Category); // DataSet that will hold the returned results DataSet commentaryDataSet = null; commentaryDataSet = db.ExecuteDataSet(dbCommand); DataRow[] dataRow; dataRow = commentaryDataSet.Tables[0].Select("UserId LIKE '%" + filterData + "%'"); // Note: connection was closed by ExecuteDataSet method call foreach (DataRow dr in dataRow) { OrdersListing _portfoliolisting = new OrdersListing(); _portfoliolisting.OrderId = Int32.Parse(dr["OrderId"].ToString()); _portfoliolisting.UserId = dr["UserId"].ToString(); _portfoliolisting.MonthsOfSubscription = dr["MonthsOfSubscription"].ToString(); _portfoliolisting.SubscriptionStartDate = DateTime.Parse(dr["SubscriptionStartDate"].ToString()); _portfoliolisting.SubscriptionEndDate = DateTime.Parse(dr["SubscriptionEndDate"].ToString()); _article.Add(_portfoliolisting); } return _article; }