// // GET: /Api/ public ActionResult Index() { ArrayList al = new ArrayList(); Dictionary<int, string> connectionString = (Dictionary<int, string>)Session["ConnectionString"]; string storeNameConnectionString = ""; if (connectionString.ContainsKey(1)) { storeNameConnectionString = connectionString[1]; } SqlConnection con = new SqlConnection(storeNameConnectionString); StoreRemoteDataBaseUitility db = new StoreRemoteDataBaseUitility(storeNameConnectionString); try { string query = " SELECT sc.name +'.'+ ta.name TableName ,SUM(pa.rows) RowCnt FROM sys.tables ta INNER JOIN sys.partitions pa ON pa.OBJECT_ID = ta.OBJECT_ID INNER JOIN " + " sys.schemas sc ON ta.schema_id = sc.schema_id WHERE ta.is_ms_shipped = 0 AND pa.index_id IN (1,0) GROUP BY sc.name,ta.name ORDER BY sc.name,ta.name "; DataTable tableName = db.FetchData(query); // String query = "select count(*) from "; foreach (DataRow rd in tableName.Rows) { string tName = (string)rd[0]; int tCt = Convert.ToInt32(rd[1].ToString()); if (tCt > 0) { al.Add(tName); } } } catch (Exception ex) { } finally { db.CloseConnection(con); } if (al != null && al.Count > 0) { return View(al); } else { ViewBag.Message = " Exception occured in fetching data "; return View(); } }
public ActionResult Data(string id) { string tName = id.Replace("-", "."); //String id = "dbo.OrderPayments"; DataTable tableName=null; Dictionary<int, string> connectionString = (Dictionary<int, string>)Session["ConnectionString"]; string storeNameConnectionString = ""; if (connectionString.ContainsKey(1)) { storeNameConnectionString = connectionString[1]; } SqlConnection con = new SqlConnection(storeNameConnectionString); StoreRemoteDataBaseUitility db = new StoreRemoteDataBaseUitility(storeNameConnectionString); try { string query = "SELECT * from " + tName; tableName = db.FetchData(query); } catch (Exception ex) { } finally { db.CloseConnection(con); } return View(tableName); }
// Get All Previous Sales of Day public DataTable GetPreviousSales(string connectionString, int opId) { StoreRemoteDataBaseUitility remoteDataBase = new StoreRemoteDataBaseUitility(connectionString); string query = " select (ClosingGrandTotal - OpeningGrandTotal) as PerDaySale , BusinessDate ,OpeningInformationId ,datename(dw,BusinessDate) as WeekOfDay from OpeningInformation where OpeningInformationId = " + SQLUtility.getInteger(opId) + " "; DataTable dt = remoteDataBase.FetchData(query); return dt; }