public IActionResult List(long id)
{
var si = new SqlIntegrate();
si.AddParameter("@p1", SqlIntegrate.DataType.BigInt, id);
var result = si.AdapterJson("SELECT [User].[username], [Comment].[content], [Comment].[datetime] " +
"FROM [User], [Comment] " +
"WHERE [Comment].[UID]=[User].[ID] AND [Comment].[RID]=@p1");
return(new ObjectResult(result));
}
public IActionResult List()
{
var si = new SqlIntegrate();
var result = si.AdapterJson(
"SELECT [ID], [name], [description], [type] FROM [Restaurant] " +
"WHERE [type] IS NOT NULL AND [description] IS NOT NULL " +
"ORDER BY [name]"
);
return(new ObjectResult(result));
}
public IActionResult Content(long id)
{
var si = new SqlIntegrate();
si.AddParameter("@p1", SqlIntegrate.DataType.BigInt, id);
var result = si.AdapterJson("SELECT [Menu].[name], [Menu].[price], [OrderContent].[quantity] " +
"FROM [Menu], [OrderContent] " +
"WHERE [Menu].[ID]=[OrderContent].[MID] " +
"AND [OrderContent].[OID]=@p1");
return(new ObjectResult(result));
}
public IActionResult Menu(long id)
{
var si = new SqlIntegrate();
si.AddParameter("@p1", SqlIntegrate.DataType.BigInt, id);
var result = si.AdapterJson(
"SELECT [ID], [name], [description], [price] " +
"FROM [Menu] " +
"WHERE [order] IS NOT NULL AND [RID]=@p1 " +
"ORDER BY [order]");
return(new ObjectResult(result));
}
public IActionResult Menu()
{
var si = new SqlIntegrate();
si.AddParameter("@p1", SqlIntegrate.DataType.VarChar, HttpContext.Session.GetString("vendor"));
var result = si.AdapterJson(
"SELECT [name], [description], [price] " +
"FROM [Menu] " +
"WHERE [order] IS NOT NULL AND [RID]=(SELECT [ID] FROM [Restaurant] WHERE [username]=@p1) " +
"ORDER BY [order]");
return(new ObjectResult(result));
}
public IActionResult List()
{
var si = new SqlIntegrate();
si.AddParameter("@p1", SqlIntegrate.DataType.VarChar, HttpContext.Session.GetString("user"));
var result =
si.AdapterJson("SELECT [Order].[ID], [Restaurant].[name], [Order].[amount], [Order].[datetime] " +
"FROM [Order], [Restaurant] " +
"WHERE [Order].[RID]=[Restaurant].[ID] AND [Order].[UID]=(" +
"SELECT [ID] FROM [User] WHERE [username]=@p1" +
") " +
"ORDER BY datetime DESC");
return(new ObjectResult(result));
}
