Example #1
0
        public List<InvAlmacenDTO> Listar()
        {
            List<InvAlmacenDTO> Lista = new List<InvAlmacenDTO>();
              Database db = DatabaseFactory.CreateDatabase("ApplicationConnectionString");
              DbCommand dbCommand = db.GetStoredProcCommand(C_LISTAR);
              using (IDataReader dr = db.ExecuteReader(dbCommand))
              {
              while (dr.Read())
              {
                  InvAlmacenDTO obj = new InvAlmacenDTO();
                  if (dr["id_almacen"] != System.DBNull.Value)
                      obj.IdAlmacen = (int)dr["id_almacen"];
                  if (dr["cod_almacen"] != System.DBNull.Value)
                      obj.CodAlmacen = (string)dr["cod_almacen"];
                  if (dr["nombre_almacen"] != System.DBNull.Value)
                      obj.NombreAlmacen = (string)dr["nombre_almacen"];
                  if (dr["direccion"] != System.DBNull.Value)
                      obj.Direccion = (string)dr["direccion"];
                  if (dr["estado"] != System.DBNull.Value)
                      obj.Estado = (string)dr["estado"];

                  Lista.Add(obj);
              }
              }
              return Lista;
        }
Example #2
0
 public void Actualizar(InvAlmacenDTO obj)
 {
     Database db = DatabaseFactory.CreateDatabase("ApplicationConnectionString");
       DbCommand dbCommand = db.GetStoredProcCommand(C_ACTUALIZAR);
       db.AddInParameter(dbCommand, "@id_almacen", DbType.Int32, obj.IdAlmacen);
       db.AddInParameter(dbCommand, "@cod_almacen", DbType.String, obj.CodAlmacen);
       db.AddInParameter(dbCommand, "@nombre_almacen", DbType.String, obj.NombreAlmacen);
       db.AddInParameter(dbCommand, "@direccion", DbType.String, obj.Direccion);
       db.AddInParameter(dbCommand, "@estado", DbType.String, obj.Estado);
       db.ExecuteNonQuery(dbCommand);
 }
Example #3
0
        public InvAlmacenDTO ListarPorClave(int idAlmacen)
        {
            List<InvAlmacenDTO> Lista = new List<InvAlmacenDTO>();
              InvAlmacenDTO obj = null;
              Database db = DatabaseFactory.CreateDatabase("ApplicationConnectionString");
              DbCommand dbCommand = db.GetStoredProcCommand(C_LISTAR_POR_CLAVE);
              db.AddInParameter(dbCommand, "@id_almacen", DbType.Int32, idAlmacen);
              using (IDataReader dr = db.ExecuteReader(dbCommand))
              {
              while (dr.Read())
              {
                  obj = new InvAlmacenDTO();
                  if (dr["id_almacen"] != System.DBNull.Value)
                      obj.IdAlmacen = (int)dr["id_almacen"];
                  if (dr["cod_almacen"] != System.DBNull.Value)
                      obj.CodAlmacen = (string)dr["cod_almacen"];
                  if (dr["nombre_almacen"] != System.DBNull.Value)
                      obj.NombreAlmacen = (string)dr["nombre_almacen"];
                  if (dr["direccion"] != System.DBNull.Value)
                      obj.Direccion = (string)dr["direccion"];
                  if (dr["estado"] != System.DBNull.Value)
                      obj.Estado = (string)dr["estado"];

              }
              }
              return obj;
        }