//
// 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;
}
