public virtual async Task <IEnumerable <PRODUCT> > SelectPaging(int start = 0, int end = 10, string query = "", string listcolumn = "")
{
var sql = "SELECT * FROM(SELECT ROW_NUMBER() OVER (order by id) AS ROWNUM, * FROM PRODUCT WHERE 1=1 " + query + ") as u WHERE RowNum BETWEEN @start AND @end ORDER BY RowNum;";
if (!string.IsNullOrEmpty(listcolumn))
{
sql = sql.Replace("*", listcolumn);
}
var result = await DBManager <PRODUCT> .ExecuteReader(sql, new { start = start, end = end });
return(result);
}
public virtual async Task <IEnumerable <BULKCOPY> > SelectByName(string Name, string listcolumn = "")
{
var sql = "SELECT TOP 1 * FROM BULKCOPY WHERE NAME LIKE @NAME+'%';";
if (!string.IsNullOrEmpty(listcolumn))
{
sql = sql.Replace("*", listcolumn);
}
var result = await DBManager <BULKCOPY> .ExecuteReader(sql, new { NAME = Name });
return(result);
}
public virtual async Task <IEnumerable <PRODUCT> > Select(int ID = 0, string listcolumn = "")
{
var sql = "SELECT * FROM PRODUCT ";
if (!string.IsNullOrEmpty(listcolumn))
{
sql = sql.Replace("*", listcolumn);
}
if (ID == 0)
{
var row = await DBManager <PRODUCT> .ExecuteReader(sql);
return(row);
}
sql += " WHERE ID=@ID";
var result = await DBManager <PRODUCT> .ExecuteReader(sql, new { ID = ID });
return(result);
}
