public virtual IEnumerable <T> Listagem(int id) { var parametros = new SqlParameter[] { new SqlParameter("id", id), new SqlParameter("chave", this.Chave), new SqlParameter("tabela", this.Tabela) }; var dt = HelperDAO.ExecutaProcSelect("spConsulta", parametros); if (dt.Rows.Count == 0) { return(null); } List <T> itens = new List <T>(); foreach (DataRow registro in dt.Rows) { itens.Add(this.MontaModel(registro)); } return(itens); }
public virtual IEnumerable <T> Listagem() { if (string.IsNullOrEmpty(this.OrderBy)) { this.OrderBy = "Id"; } var parametros = new SqlParameter[] { new SqlParameter("tabela", this.Tabela), new SqlParameter("ordem", this.OrderBy) }; var dt = HelperDAO.ExecutaProcSelect("spListagem", parametros); if (dt.Rows.Count == 0) { return(null); } List <T> itens = new List <T>(); foreach (DataRow registro in dt.Rows) { itens.Add(this.MontaModel(registro)); } return(itens); }
public virtual void Delete(int id, SqlConnection conexao, SqlTransaction transacao) { var parametros = new SqlParameter[] { new SqlParameter("id", id), new SqlParameter("tabela", this.Tabela) }; HelperDAO.ExecutaProc("spDelete", conexao, transacao, parametros); }
public virtual void Delete(T model) { var parametros = new SqlParameter[] { new SqlParameter("id", model.Id), new SqlParameter("tabela", this.Tabela) }; HelperDAO.ExecutaProc("spDelete", parametros); }
public virtual void Delete(int id) { var parametros = new SqlParameter[] { new SqlParameter("id", id), new SqlParameter("chave", this.Chave), new SqlParameter("tabela", this.Tabela) }; HelperDAO.ExecutaProc("spDelete", parametros); }
public virtual int Insert(T model) { var dt = HelperDAO.ExecutaProcSelect("spInsert_" + this.Tabela, this.CriaParametros(model)); if (dt.Rows.Count > 0) { return(Convert.ToInt32(dt.Rows[0][0])); } return(0); }
public virtual int ProximoId() { var parametros = new SqlParameter[] { new SqlParameter("tabela", this.Tabela) }; var dt = HelperDAO.ExecutaProcSelect("spProximoId", parametros); return(Convert.ToInt32(dt.Rows[0][0])); }
public virtual T Consulta(int id) { var parametros = new SqlParameter[] { new SqlParameter("id", id), new SqlParameter("chave", this.Chave), new SqlParameter("tabela", this.Tabela) }; var dt = HelperDAO.ExecutaProcSelect("spConsulta", parametros); if (dt.Rows.Count == 0) { return(null); } return(this.MontaModel(dt.Rows[0])); }
public virtual void Update(T model) { HelperDAO.ExecutaProc("spUpdate_" + this.Tabela, this.CriaParametros(model)); }