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