public IActionResult RestaurantInfo(long id) { var si = new SqlIntegrate(); si.AddParameter("@p1", SqlIntegrate.DataType.BigInt, id); var result = si.QueryJson("SELECT [name], [description] FROM [Restaurant] WHERE [ID]=@p1"); return(new ObjectResult(result)); }
public IActionResult Info() { var si = new SqlIntegrate(); si.AddParameter("@p1", SqlIntegrate.DataType.VarChar, HttpContext.Session.GetString("vendor")); var result = si.QueryJson( "SELECT [name], [username], [password], ISNULL([description], '') AS [d], ISNULL([type], '') AS [t] " + "FROM [Restaurant] " + "WHERE [username]=@p1"); return(new ObjectResult(result)); }
public IActionResult Info() { var si = new SqlIntegrate(); si.AddParameter("@p1", SqlIntegrate.DataType.VarChar, HttpContext.Session.GetString("user")); var result = si.QueryJson( "SELECT [username], [password], " + "ISNULL([phone], '') AS phone, " + "ISNULL([deliverAddress], '') as deliverAddress " + "FROM [User] " + "WHERE [username]=@p1"); return(new ObjectResult(result)); }