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