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