public async Task <BaseResponse <int> > CreateAsync(CompanySql model, int createBy) { try { using (var con = GetConnection()) { var p = AddOutputParam("id"); p.Add("fullname", model.FullName); p.Add("checkdate", model.CheckDate); p.Add("note", model.LastNote); p.Add("createdtime", DateTime.Now); p.Add("createdby", createBy); p.Add("TaxNumber", model.TaxNumber); p.Add("PartnerId", model.PartnerId); p.Add("CatType", model.CatType); await con.ExecuteAsync("sp_InsertCompany", p, commandType : CommandType.StoredProcedure); return(BaseResponse <int> .Create(p.Get <int>("id"))); } } catch (Exception e) { return(BaseResponse <int> .Create(0, GetException(e))); } }
public async Task <BaseResponse <bool> > UpdateAsync(CompanySql model, int updateBy) { var p = new DynamicParameters(); p.Add("id", model.Id); p.Add("fullname", model.FullName); p.Add("checkdate", model.CheckDate); p.Add("status", model.Status); p.Add("note", string.IsNullOrWhiteSpace(model.LastNote) ? null : model.LastNote); p.Add("TaxNumber", model.TaxNumber); p.Add("CatType", model.CatType); p.Add("updatedtime", DateTime.Now); p.Add("updatedby", updateBy); try { using (var con = GetConnection()) { await con.ExecuteAsync("sp_UpdateCompany", p, commandType : CommandType.StoredProcedure); return(BaseResponse <bool> .Create(true)); } } catch (Exception e) { return(BaseResponse <bool> .Create(false, GetException(e))); } }