public virtual async Task <int> Insert(string NAME, int PRICE)
{
var sql = "INSERT INTO PRODUCT(NAME,PRICE) VALUES(@NAME,@PRICE)";
var result = await DBManager <PRODUCT> .Execute(sql, new { NAME = NAME, PRICE = PRICE });
return(result);
}
public virtual async Task <int> UpdateByName(string NAME, int PRICE)
{
var sql = "UPDATE BULKCOPY SET PRICE=@PRICE WHERE NAME=@NAME";
var result = await DBManager <BULKCOPY> .Execute(sql, new { NAME = NAME, PRICE = PRICE });
return(result);
}
public virtual async Task <int> Update1Column(int ID, string COLUMN, string VALUE)
{
var sql = string.Format(@"UPDATE PRODUCT SET {0}=@VALUE WHERE ID=@ID", COLUMN);
var result = await DBManager <PRODUCT> .Execute(sql, new { ID = ID, VALUE = VALUE });
return(result);
}
public virtual async Task <int> Update(string NAME, int PRICE)
{
var sql = "UPDATE PRODUCT SET NAME=@NAME,PRICE=@PRICE WHERE ID=@ID";
var result = await DBManager <PRODUCT> .Execute(sql, new { NAME = NAME, PRICE = PRICE });
return(result);
}
public virtual async Task <int> DeleteByName(string NAME)
{
var sql = "DELETE FROM BULKCOPY WHERE NAME=@NAME";
var result = await DBManager <BULKCOPY> .Execute(sql, new { NAME = NAME });
return(result);
}
public virtual async Task <int> Delete(int ID = 0)
{
var sql = "DELETE FROM PRODUCT ";
if (ID == 0)
{
var row = await DBManager <PRODUCT> .Execute(sql);
return(row);
}
sql += " WHERE ID=@ID ";
var result = await DBManager <PRODUCT> .Execute(sql, new { ID = ID });
return(result);
}
public async void DeleteAll()
{
await DBManager <PRODUCT> .Execute("TRUNCATE TABLE PRODUCT");
}
public async Task DeleteAll()
{
await DBManager <BULKCOPY> .Execute("TRUNCATE TABLE BULKCOPY");
}
