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 <BaseResponse <int> > CreateAsync(CheckDupAddSql model, int createdBy) { //var par = GetParams(model, new string[] { // nameof(model.UpdatedBy), // nameof(model.UpdatedTime), // nameof(model.CreatedTime), // nameof(model.CreatedBy) //}, "Id"); //par.Add("CreatedBy", createdBy); try { using (var con = GetConnection()) { var pars = GetParams(model, new string[] { nameof(model.CreatedTime), nameof(model.UpdatedTime), nameof(model.UpdatedBy), nameof(model.CreatedBy) }, nameof(model.Id)); pars.Add("CreatedBy", createdBy); await con.ExecuteAsync("sp_InsertCustomer_v2", pars, commandType : CommandType.StoredProcedure); return(BaseResponse <int> .Create(pars.Get <int>(nameof(model.Id)))); } } catch (Exception e) { return(BaseResponse <int> .Create(0, GetException(e))); } }