public List<FormaPagoDTO> Listar() { List<FormaPagoDTO> Lista = new List<FormaPagoDTO>(); Database db = DatabaseFactory.CreateDatabase("ApplicationConnectionString"); DbCommand dbCommand = db.GetStoredProcCommand(C_LISTAR); using (IDataReader dr = db.ExecuteReader(dbCommand)) { while (dr.Read()) { FormaPagoDTO obj = new FormaPagoDTO(); if (dr["id_forma_pago"] != System.DBNull.Value) obj.IdFormaPago = (int)dr["id_forma_pago"]; if (dr["nombre_forma_pago"] != System.DBNull.Value) obj.NombreFormaPago = (string)dr["nombre_forma_pago"]; if (dr["dias"] != System.DBNull.Value) obj.Dias = (int)dr["dias"]; Lista.Add(obj); } } return Lista; }
public void Actualizar(FormaPagoDTO obj) { Database db = DatabaseFactory.CreateDatabase("ApplicationConnectionString"); DbCommand dbCommand = db.GetStoredProcCommand(C_ACTUALIZAR); db.AddInParameter(dbCommand, "@id_forma_pago", DbType.Int32, obj.IdFormaPago); db.AddInParameter(dbCommand, "@nombre_forma_pago", DbType.String, obj.NombreFormaPago); db.AddInParameter(dbCommand, "@dias", DbType.Int32, obj.Dias); db.ExecuteNonQuery(dbCommand); }
public int Agregar(FormaPagoDTO obj) { Database db = DatabaseFactory.CreateDatabase("ApplicationConnectionString"); DbCommand dbCommand = db.GetStoredProcCommand(C_AGREGAR); db.AddInParameter(dbCommand, "@id_forma_pago", DbType.Int32, obj.IdFormaPago); db.AddInParameter(dbCommand, "@nombre_forma_pago", DbType.String, obj.NombreFormaPago); db.AddInParameter(dbCommand, "@dias", DbType.Int32, obj.Dias); int id = Convert.ToInt32(db.ExecuteScalar(dbCommand)); return id; }
public FormaPagoDTO ListarPorClave(int IdFormaPago) { FormaPagoDTO obj = null; Database db = DatabaseFactory.CreateDatabase("ApplicationConnectionString"); DbCommand dbCommand = db.GetStoredProcCommand(C_LISTAR_POR_CLAVE); db.AddInParameter(dbCommand, "@id_forma_pago", DbType.Int32, IdFormaPago); using (IDataReader dr = db.ExecuteReader(dbCommand)) { if (dr.Read()) { obj = new FormaPagoDTO(); if (dr["id_forma_pago"] != System.DBNull.Value) obj.IdFormaPago = (int)dr["id_forma_pago"]; if (dr["nombre_forma_pago"] != System.DBNull.Value) obj.NombreFormaPago = (string)dr["nombre_forma_pago"]; if (dr["dias"] != System.DBNull.Value) obj.Dias = (int)dr["dias"]; } } return obj; }