public async Task <int> UpdateLocation(RetailerLocation retailerLocation)
{
var cmd = QueriesCreatingHelper.CreateQueryUpdate(retailerLocation);
var rs = await DALHelper.Execute(cmd, dbTransaction : DbTransaction, connection : DbConnection);
return(rs == 0 ? -1 : 0);
}
public async Task <int> AddLocation(RetailerLocation retailerLocation)
{
var cmd = QueriesCreatingHelper.CreateQueryInsert(retailerLocation);
cmd += ";SELECT LAST_INSERT_ID();";
return((await DALHelper.ExecuteQuery <int>(cmd, dbTransaction: DbTransaction, connection: DbConnection)).First());
}
public async Task <int> DeleteLocation(RetailerLocation retailerLocation)
{
var cmd = $@"UPDATE `retailer_location`
SET
`is_deleted` = 1,
`modified_by` = {retailerLocation.ModifiedBy},
`modified_date` = '{retailerLocation.ModifiedDate?.ToString("yyyyMMddHHmmss")}'
WHERE `id` = {retailerLocation.Id}";
var rs = await DALHelper.Execute(cmd, dbTransaction : DbTransaction, connection : DbConnection);
return(rs == 0 ? -1 : 0);
}
