public async Task <RepoResponse <bool> > UpdateAsync(CheckDupAddSql model, int updateBy) { var pars = GetParams(model, ignoreKey: new string[] { nameof(model.CreatedBy), nameof(model.CreatedTime), nameof(model.UpdatedTime), nameof(model.UpdatedBy), }); pars.Add(nameof(model.UpdatedBy), updateBy); try { using (var con = GetConnection()) { await con.ExecuteAsync("sp_UpdateCustomer_v2", pars, commandType : CommandType.StoredProcedure); return(RepoResponse <bool> .Create(true)); } } catch (Exception e) { return(RepoResponse <bool> .Create(false, GetException(e))); } }
public async Task <RepoResponse <int> > CreateAsync(CheckDupAddSql model, int createdBy) { try { using (var con = GetConnection()) { var pars = GetParams(model, nameof(model.Id), ignoreKey: new string[] { nameof(model.CreatedTime), nameof(model.UpdatedTime), nameof(model.UpdatedBy), nameof(model.CreatedBy) }); pars.Add("CreatedBy", createdBy); await con.ExecuteAsync("sp_InsertCustomer_v2", pars, commandType : CommandType.StoredProcedure); return(RepoResponse <int> .Create(pars.Get <int>(nameof(model.Id)))); } } catch (Exception e) { return(RepoResponse <int> .Create(0, GetException(e))); } }