Computer technology: 02/11/08

In the Spider's Web (2007) DVDRip

When a team of backpackers sets out to explore the Indian jungles, one of them is bitten by a poisonous spider and killed. Forced to seek the help of Dr. Lecorpus (Golden Globe nominee Lance Henriksen), an American physician living in a local village, the group quickly discovers that the village has a venomous ritual in which crawling spiders feast on corpses.

Download :

Link1
Link2
Link3
Link4
Link5
Link6
Link7
Link8

Charlie Bartlett (2008) DVDRip

Wealthy teenager Charlie Bartlett is failing miserably at fitting in at a new public high school run by the world-weary Principal Gardner. As he begins to better understand the social hierarchy, Charlie's honest charm and likability positions him as the resident "psychiatrist" dishing out advice, and the occasional prescription with his partner and fellow student, Murphy Bivens, to other students in need. Along the way, he decides to take some of his own advice, find romance, and learn to accept who he is, thus wielding a witty dark comedy about the angst-filled years before college.

Download :

Link1
Link2
Link3
Link4
Link5
Link6
Link7
Link8

Password : areg

Rambo IV (2008) CAM

Vietnam veteran John Rambo has survived many harrowing ordeals in his lifetime and has since withdrawn into a simple and secluded existence in Bangkok, where he spends his time salvaging old PT boats and tanks for scrap metal. Even though he is looking to avoid trouble, trouble has a way of finding him. A group of Christian human rights missionaries, led by Michael Burnett and Sarah Miller, approach Rambo with the desire to rent his boat to travel up the river to Burma. For over fifty years, Burma has been like a war zone. The Karen people of the region, who consist of peasants and farmers, have endured brutally oppressive rule from the murderous Burmese military and have been struggling for survival every single day. This is the time when medical assistance and general support from the Christian missionaries is needed most. After some consideration, and due to insistence from his mentor, former military man Ed Baumgartner, Rambo accepts the offer and takes Michael, Sarah, and the rest of the missionaries up the river. When the missionaries finally arrive at the Karen village, they are ambushed by the sadistic Major Pa Tee Tint and a slew of Burmese army men. A portion of the villagers and missionaries are tortured and viciously murdered, while Tint and his men hold the remainder captive. News soon reaches the minister in charge of the mission and with the help of Ed Baumgartner he employs Rambo to lead a rescue effort. With five young and highly diverse mercenaries at his disposal, Rambo has to travel back up the river and liberate the survivors from the clutches of Major Tint in what may be one of his deadliest missions ever.

Download :

Link1
Link2
Link3
Link4
Link5
Link6
Link7
Link8

Crysis_Bonus_DVD-FLT

This is the DVD Bonus that comes with the game when you buy it, this contains an huge number of interesting extras, grab it here:

http://d01.megashares.com/?d01=8f4ce16

Hellgate London-Vitality

Back in 1996, computer game players everywhere became hooked on Diablo, a simple action role-playing game in which you played as a fantasy warrior and defeated your diabolical enemies by repeatedly clicking your mouse button to attack. One sequel and countless destroyed computer mice later, the creative forces behind the original Diablo games have reunited as Flagship Studios to create the soon-to-be-released Hellgate: London, a futuristic hack-and-slash game in which you'll fight against a demonic invasion in a postapocalyptic version of London, England. Over the course of the game, your character will amass huge piles of randomly generated loot, much of which can be crafted together to assemble powerful weapons and armor. However, you'll also be hacking your way through many areas that will be randomly generated themselves, and populated with random squads of hellish beasts. We sat down with chief visionary officer David Brevik for more details.

You can grab it here:

http://rapidshare.com/files/66830487/Hellgate.London.ViTALiTY.part01.rar
http://rapidshare.com/files/66830708/Hellgate.London.ViTALiTY.part02.rar
http://rapidshare.com/files/66830567/Hellgate.London.ViTALiTY.part03.rar
http://rapidshare.com/files/66830624/Hellgate.London.ViTALiTY.part04.rar
http://rapidshare.com/files/66830667/Hellgate.London.ViTALiTY.part05.rar
http://rapidshare.com/files/66830574/Hellgate.London.ViTALiTY.part06.rar
http://rapidshare.com/files/66830553/Hellgate.London.ViTALiTY.part07.rar
http://rapidshare.com/files/66830692/Hellgate.London.ViTALiTY.part08.rar
http://rapidshare.com/files/66830755/Hellgate.London.ViTALiTY.part09.rar
http://rapidshare.com/files/66830632/Hellgate.London.ViTALiTY.part10.rar
http://rapidshare.com/files/66830554/Hellgate.London.ViTALiTY.part11.rar
http://rapidshare.com/files/66830601/Hellgate.London.ViTALiTY.part12.rar
http://rapidshare.com/files/66830793/Hellgate.London.ViTALiTY.part13.rar
http://rapidshare.com/files/66830739/Hellgate.London.ViTALiTY.part14.rar
http://rapidshare.com/files/66830702/Hellgate.London.ViTALiTY.part15.rar
http://rapidshare.com/files/66830631/Hellgate.London.ViTALiTY.part16.rar
http://rapidshare.com/files/66830525/Hellgate.London.ViTALiTY.part17.rar
http://rapidshare.com/files/66830504/Hellgate.London.ViTALiTY.part18.rar
http://rapidshare.com/files/66830623/Hellgate.London.ViTALiTY.part19.rar
http://rapidshare.com/files/66830798/Hellgate.London.ViTALiTY.part20.rar
http://rapidshare.com/files/66830656/Hellgate.London.ViTALiTY.part21.rar
http://rapidshare.com/files/66830538/Hellgate.London.ViTALiTY.part22.rar
http://rapidshare.com/files/66830642/Hellgate.London.ViTALiTY.part23.rar
http://rapidshare.com/files/66830608/Hellgate.London.ViTALiTY.part24.rar
http://rapidshare.com/files/66830717/Hellgate.London.ViTALiTY.part25.rar
http://rapidshare.com/files/66830583/Hellgate.London.ViTALiTY.part26.rar
http://rapidshare.com/files/66830701/Hellgate.London.ViTALiTY.part27.rar
http://rapidshare.com/files/66830512/Hellgate.London.ViTALiTY.part28.rar
http://rapidshare.com/files/66830556/Hellgate.London.ViTALiTY.part29.rar
http://rapidshare.com/files/66830677/Hellgate.London.ViTALiTY.part30.rar
http://rapidshare.com/files/66830728/Hellgate.London.ViTALiTY.part31.rar
http://rapidshare.com/files/66830799/Hellgate.London.ViTALiTY.part32.rar
http://rapidshare.com/files/66830716/Hellgate.London.ViTALiTY.part33.rar
http://rapidshare.com/files/66830683/Hellgate.London.ViTALiTY.part34.rar
http://rapidshare.com/files/66830820/Hellgate.London.ViTALiTY.part35.rar
http://rapidshare.com/files/66830654/Hellgate.London.ViTALiTY.part36.rar
http://rapidshare.com/files/66830587/Hellgate.London.ViTALiTY.part37.rar
http://rapidshare.com/files/66830622/Hellgate.London.ViTALiTY.part38.rar
http://rapidshare.com/files/66830600/Hellgate.London.ViTALiTY.part39.rar
http://rapidshare.com/files/66830823/Hellgate.London.ViTALiTY.part40.rar
http://rapidshare.com/files/66830616/Hellgate.London.ViTALiTY.part41.rar
http://rapidshare.com/files/66830712/Hellgate.London.ViTALiTY.part42.rar
http://rapidshare.com/files/66830618/Hellgate.London.ViTALiTY.part43.rar
http://rapidshare.com/files/66830800/Hellgate.London.ViTALiTY.part44.rar
http://rapidshare.com/files/66830840/Hellgate.London.ViTALiTY.part45.rar
http://rapidshare.com/files/66830509/Hellgate.London.ViTALiTY.part46.rar
http://rapidshare.com/files/66830657/Hellgate.London.ViTALiTY.part47.rar
http://rapidshare.com/files/66830761/Hellgate.London.ViTALiTY.part48.rar
http://rapidshare.com/files/66830521/Hellgate.London.ViTALiTY.part49.rar
http://rapidshare.com/files/66830718/Hellgate.London.ViTALiTY.part50.rar
http://rapidshare.com/files/66830916/Hellgate.London.ViTALiTY.part51.rar
http://rapidshare.com/files/66830662/Hellgate.London.ViTALiTY.part52.rar
http://rapidshare.com/files/66830663/Hellgate.London.ViTALiTY.part53.rar
http://rapidshare.com/files/66830729/Hellgate.London.ViTALiTY.part54.rar
http://rapidshare.com/files/66830545/Hellgate.London.ViTALiTY.part55.rar
http://rapidshare.com/files/66830780/Hellgate.London.ViTALiTY.part56.rar
http://rapidshare.com/files/66830637/Hellgate.London.ViTALiTY.part57.rar
http://rapidshare.com/files/66830839/Hellgate.London.ViTALiTY.part58.rar
http://rapidshare.com/files/66830659/Hellgate.London.ViTALiTY.part59.rar
http://rapidshare.com/files/66830696/Hellgate.London.ViTALiTY.part60.rar
http://rapidshare.com/files/66830704/Hellgate.London.ViTALiTY.part61.rar
http://rapidshare.com/files/66830691/Hellgate.London.ViTALiTY.part62.rar
http://rapidshare.com/files/66830886/Hellgate.London.ViTALiTY.part63.rar
http://rapidshare.com/files/66830671/Hellgate.London.ViTALiTY.part64.rar
http://rapidshare.com/files/66830754/Hellgate.London.ViTALiTY.part65.rar
http://rapidshare.com/files/66830589/Hellgate.London.ViTALiTY.part66.rar
http://rapidshare.com/files/66830629/Hellgate.London.ViTALiTY.part67.rar
http://rapidshare.com/files/66830750/Hellgate.London.ViTALiTY.part68.rar
http://rapidshare.com/files/66830531/Hellgate.London.ViTALiTY.part69.rar
http://rapidshare.com/files/66830742/Hellgate.London.ViTALiTY.part70.rar
http://rapidshare.com/files/66830757/Hellgate.London.ViTALiTY.part71.rar
http://rapidshare.com/files/66830738/Hellgate.London.ViTALiTY.part72.rar
http://rapidshare.com/files/66830549/Hellgate.London.ViTALiTY.part73.rar

[PC][MULTI]Gears.Of.War-RELOADED

The game's story component puts you in the shoes of Marcus Fenix, who up until the very beginning of the game was serving time in prison for treasonous behavior. But the war effort requires his special brand of badness, so he's quickly set free, dressed up in his old soldier garb, and put back into action with the members of Delta Squad. Your enemy is the menace known as the Locust, which seems to be an amalgamation of different races and creatures, all seemingly devoted to exterminating your kind and taking over your planet. The game's plot points are inconsequential and work in a number of meaningless MacGuffin devices that serve as the only impetus you need to march from point A to point B while gunning down bad guys the whole way. You'll blast even more bad guys in the PC version of the game, which has a new section at the start of the final act that fills in a blank left by the 360 version. It does a better job of explaining how you go from running away from a huge beast with rocket launchers mounted on its head and shoulders to showing up at a train station to take the battle to the enemy general before he ruins everything.

Grab it here:

http://d01.megashares.com/?d01=267b3e5

OR

http://www.filefactory.com/f/088970191eefcea1/

[PC][MULTI]Call_Of_Duty_4-Razor1911

Description:

It took awhile, but Infinity Ward finally got the message that World War II is played out. With modern times and international affairs becoming more and more, shall we say, interesting in recent years, the 1940s just don't carry as much weight as they used to. Perhaps that's why Call of Duty 4 has a new subtitle, Modern Warfare. By bringing things into a fictionalized story that still seems fairly plausible, the developer has made a much heavier game. But COD 4 is more than just an updated setting. It's also an amazing multiplayer first-person shooter and a great but brief single-player campaign with the visual chops to make it a standout shooter in an era filled with seemingly dozens of standout shooters.

garb it here:

http://www.filefactory.com/f/09910fcd265b6222/

OR

http://netfolder.in/be41f1a/cod4

OR

http://d01.megashares.com/?d01=f236d27

OR

http://d01.megashares.com/?d01=7700cfe

Half-Life 2: Orange Box (2007/No-STEAM/ENG/RUS)

This is the kind of games that doesn't need a presentation, but anyways here is a description by gamespot:

Half-Life 2: Orange Box is a new product from Valve Company, which includes not only the long-awaited Episode Two, but at least two interesting and exciting games.

Half-Life 2: Episode Two-awaited part of the cult continued "Half-Life 2", won over 35 awards "Game of the Year" multitude of publications around the world. Episode Two is a continuation of the famous saga, Lord of the further adventures of Dr. Freeman and his charming naparnitsy Alix.
In addition, complete with games, you also will find continued Bollywood command shutera-Team Fortress 2, as well as a unique logical arcades Portal.

Game features:
-- Half-Life 2: Episode Two-continuation of actions of one of the best of all time!
During a game in the Half-Life 2: Episode Two will not leave you feeling that you currently see a movie, it is fun game reworked towards greater kinematografichnosti-you will find a real war on open spaces.
-- Unmatched graphical part: the newly updated engine Source pleased you support shaders 3.0 and HDR technology improved.
-- An unprecedented mastery of digital actors: improved artificial intelligence even more "heroes" ochelovechil game.
-- The product does not require the original version of Half-Life 2 and includes three games: "Half-Life 2: Episode Two," "Team Fortress 2" and "Portal".

Publication Type: piratka
Interface Language: English Russian +
Fix: Not required

Half-Life 2: Orange Box (2007/No-STEAM/ENG/RUS / Book)

System requirements:
Pentium or Athlon processor 1.7 GHz (Pentium or Athlon encouraged to 3 GHz)
Operational memory of 512 MB
Video Video Card compatible with DirectX 8 ® (recommended compatible with DirectX ® 9)
Sound DirectX- compatible sound card
H-skorostnoy DVD-ROM CD-ROM 4
Add-on DirectX 7.0
Office Keyboard, Mouse

FAQ:
Q: How many games in this assembly?
Three: "Half-Life 2: Episode Two," "Team Fortress 2" and "Portal".
Q: I need only EP2 whether that is not Download?
No, Download need all parts, except nesmozhete place ... perhaps then make a separate assembly.
Q: This version of Buki or VALVe?
And indeed there is no difference ... GCF have the same.
Q: Russian language there?
Ah ... those games where it is / / Russkuyu ozvuchku to EP2 downloading separately.
Q: And where else the game 2 (HL2 & HL2: E1)?
Their boxing in Orange NETU simply buy Orange boxing, you should be able to download these games STEAM servers at no extra cost for them (At No-STEAM version does not apply)

So now is time to grab this game while it lasts online:

http://rapidshare.com/files/61967638/OBXCPR.part01.rar
http://rapidshare.com/files/61967607/OBXCPR.part02.rar
http://rapidshare.com/files/61967595/OBXCPR.part03.rar
http://rapidshare.com/files/61967643/OBXCPR.part04.rar
http://rapidshare.com/files/61967561/OBXCPR.part05.rar
http://rapidshare.com/files/61967664/OBXCPR.part06.rar
http://rapidshare.com/files/61967590/OBXCPR.part07.rar
http://rapidshare.com/files/61967578/OBXCPR.part08.rar
http://rapidshare.com/files/61967717/OBXCPR.part09.rar
http://rapidshare.com/files/61967601/OBXCPR.part10.rar
http://rapidshare.com/files/61967577/OBXCPR.part11.rar
http://rapidshare.com/files/61967687/OBXCPR.part12.rar
http://rapidshare.com/files/61967667/OBXCPR.part13.rar
http://rapidshare.com/files/61967559/OBXCPR.part14.rar
http://rapidshare.com/files/61967571/OBXCPR.part15.rar
http://rapidshare.com/files/61967609/OBXCPR.part16.rar
http://rapidshare.com/files/61967656/OBXCPR.part17.rar
http://rapidshare.com/files/61967506/OBXCPR.part18.rar
http://rapidshare.com/files/61967701/OBXCPR.part19.rar
http://rapidshare.com/files/61967619/OBXCPR.part20.rar
http://rapidshare.com/files/61967624/OBXCPR.part21.rar
http://rapidshare.com/files/61967605/OBXCPR.part22.rar
http://rapidshare.com/files/61967700/OBXCPR.part23.rar
http://rapidshare.com/files/61967517/OBXCPR.part24.rar
http://rapidshare.com/files/61967589/OBXCPR.part25.rar
http://rapidshare.com/files/61967678/OBXCPR.part26.rar
http://rapidshare.com/files/61967626/OBXCPR.part27.rar
http://rapidshare.com/files/61967648/OBXCPR.part28.rar
http://rapidshare.com/files/61967620/OBXCPR.part29.rar
http://rapidshare.com/files/61967652/OBXCPR.part30.rar
http://rapidshare.com/files/61967715/OBXCPR.part31.rar
http://rapidshare.com/files/61967622/OBXCPR.part32.rar
http://rapidshare.com/files/61967535/OBXCPR.part33.rar
http://rapidshare.com/files/61967660/OBXCPR.part34.rar
http://rapidshare.com/files/61967568/OBXCPR.part35.rar
http://rapidshare.com/files/61967645/OBXCPR.part36.rar
http://rapidshare.com/files/61967655/OBXCPR.part37.rar
http://rapidshare.com/files/61967635/OBXCPR.part38.rar
http://rapidshare.com/files/61967612/OBXCPR.part39.rar
http://rapidshare.com/files/61967654/OBXCPR.part40.rar
http://rapidshare.com/files/61967644/OBXCPR.part41.rar
http://rapidshare.com/files/61967523/OBXCPR.part42.rar
http://rapidshare.com/files/61967653/OBXCPR.part43.rar
http://rapidshare.com/files/61967573/OBXCPR.part44.rar
http://rapidshare.com/files/61967575/OBXCPR.part45.rar
http://rapidshare.com/files/61967596/OBXCPR.part46.rar
http://rapidshare.com/files/61967691/OBXCPR.part47.rar
http://rapidshare.com/files/61967681/OBXCPR.part48.rar
http://rapidshare.com/files/61967599/OBXCPR.part49.rar
http://rapidshare.com/files/61967675/OBXCPR.part50.rar
http://rapidshare.com/files/61967711/OBXCPR.part51.rar
http://rapidshare.com/files/61967683/OBXCPR.part52.rar
http://rapidshare.com/files/61967649/OBXCPR.part53.rar

Password: CPR

Grand Theft Auto Underground 2 Vice City + Xtreme Tuning

this game contains the following mods:

1) Starman Mod.
2) Fast & Furious Mod.
3) Xtreme Speed Mod.
4) All Vehicles And Data
5) Stunts Mod (Ramps and loops)
6) Maps Mod (Statue of Liberty, etc)

You can expect a very different experience from what you had until now....You will probably be amazed with the possibilities of this mods.

Just grab it and enjoy my friends:

Parte1: http://lix.in/f62db9
Parte2: http://lix.in/35b8ca
Parte3: http://lix.in/bbada3
Parte4: http://lix.in/b30ba8
Parte5: http://lix.in/2c83a9
Parte6: http://lix.in/3d5b96
Parte7: http://lix.in/0fb64d
Parte8: http://lix.in/cb0bd4
Parte9: http://lix.in/9c450f

[PC][MULTI] Gears Of War

Read this description:

A third-person tactical shooter from Epic, running on the Unreal Engine 3. Gears of War thrusts gamers into a deep and harrowing story of humankind’s epic battle for survival against the Locust Horde, a nightmarish race of creatures that surface from the bowels of the planet.

Unlike other shooters, Gears of War is all about teamwork in a big way. All game modes, levels and scenarios are designed specifically to encourage co-operative play, whether it be with A.I. partners or human players (with A.I. teammates designed with specific strengths, weaknesses and personalities.)

You can grab this amazing game here:

Rapidshare:

FEAR.Perseus.Mandate-HATRED

Read this description by IGN:

F.E.A.R. (First Encounter Assault and Recon) is a first-person close-quarters combat game for the PC. The story begins when a paramilitary force infiltrates a multi-billion dollar aerospace compound, and the government responds by sending in Special Forces. The group loses contact with the government when an eerie signal interrupts radio communications--and when that interference subsides moments later, the team has been destroyed. That's where you come in. As part of a classified strike team created to deal with threats no one else can handle, your mission is simple: eliminate the intruders at any cost, determine the origin of the signal, and contain the potential crisis before it gets out of control.

You can grab this new game here:

http://filesurf.ru/19430 FPM.part1.rar [1,024 MB]
http://filesurf.ru/19429 FPM.part2.rar [1,024 MB]
http://filesurf.ru/19428 FPM.part3.rar [1,024 MB]
http://filesurf.ru/19427 FPM.part4.rar [1,024 MB]
http://filesurf.ru/19426 FPM.part5.rar [99 MB]

Russian links, English game...

[PC][MULTI]Airport Tycoon 3

Small description of this game by ign:

Design, build and maintain your very own international airport in this amazingly in-depth management simulation. Get started by buying land in over 40 diverse locations and building runways, and then secure both cargo and passenger airline contracts. Watch your creation come to life as your airport bustles with the activities of planes, cars and passengers in detailed 3D-rendered graphics. But be careful! Bad weather, overbooked flights, bottlenecks on the runway, and aircraft collisions are all part of the job. Do you think you can keep your customers safe and happy on the way to becoming the ultimate airport manager?

So grab it now here:

http://4hr4inv7rn.rapidsafe.de/

[PC][MULTI] Crysis

10 Benefits of Using Coding Standards to Software Development Team

Having coding standards in a software development organization has the following advantages.

For the developers:

1. The source code will be more comprehensive and will become easy-to-maintain. As the programmers became more and more familiar with the coding style as they implements the coding standards on project after project.

2. The uniform approach for solving problems will be handy because the code standards documents reveal the recommended methods that were tried and tested on the earlier projects.

3. Less communication between developers and managers will be needed because the programmers will not asked anymore on the details of the specification document because the defaults are all stated in coding standards.

4. Is common to the less experience programmer to re-invent the wheel. When there are coding standards, there is a big chance that particular problem is not really a new problem, but in fact, a solution may be documented before.

For the quality assurance team:

5. Well documented coding standards will aid the creation of “Test Scripts”. Having reviewed the source code and tested an application based on compliance to coding standards, it added strong direction to ensure quality of the software product.

6. Because code standards implements traceability, the item ids can be used to describe a violation in the “Test Results” document that both developers and testers are familiar with.

For the project managers:

7. It is important for the project managers to maintain and secure source code quality on their projects. Implementing coding standards could jumpstart this goal halfway to its realization.

8. Repeated performance pitfalls could be avoided. It is a common case that a released software product could be less impressive when it comes to performance when the real data has been loaded in the new developed database application.

9. Lesser man-hour consumption as the sum of all efforts implementing coding standards.

10. It is also beneficial for the organization who are applying for ISO 9001 license because coding standards is a complement from organization’s execution plan requirements.

Databases and Sql as a Middle Tier Storage Medium

DOTNUTSHELL Technologies are an experienced database designing company, with Oracle accredicated qualification providing services both in the OpenSource and Enterprise field.

Microsoft SQL Server is a relational database management system. Its primary query language is Transact-SQL, an implementation of the ANSI/ISO standard Structured Query Language (SQL) used by both Microsoft and Sybase.

Microsoft SQL Server uses a variant of SQL called T-SQL, or Transact-SQL, an implementation of SQL-92. T-SQL mainly adds additional syntax for use in stored procedures, and affects the syntax of transaction support.

SQL Server includes support for database mirroring and clustering. A SQL server cluster is a collection of identically configured servers, which help distribute the workload among multiple servers. All the servers share an identical virtual server name, and it is resolved into the IP address of any of the identically configured machines by the clustering runtime. Automatic failover clustering is also available, in which the workload of a server is transferred to another system in the event of a system failure.SQL server also supports data partitioning for distributed databases. Database mirroring, introduced in SQL Server 2005, allows creation of mirrors (or replicas) of database contents, along with transaction logs, on another instance of SQL Server, based on certain predefined triggers.

Microsoft and other vendors provide a number of software development tools designed to allow business applications to be developed using the data stored by Microsoft SQL Server. Microsoft SQL Server 2005 now includes the common language runtime (CLR) component for Microsoft .NET. Applications developed with .NET languages such as VB.NET or C# can implement stored procedures and other functions. Older versions of Microsoft development tools typically use APIs to access Microsoft SQL Server functionality.

We can design and engineer databases based on your business model and provide tools and interfaces that can be used to mine your business data. We also have experience in database persistence and create custom persistence frameworks and algorythms which can be used to predict patterns and trends from your data.

Oracle Database is a relational database management system released by Oracle Corporation. Oracle Database has become a major feature of database computing.

An Oracle database system comprises at least one instance of the application, along with data storage. An instance comprises a set of operating-system processes and memory-structures that interact with the storage. Typical processes include PMON (the process monitor) and SMON (the system monitor).

Users of Oracle databases refer to the server-side memory-structure as the SGA (System Global Area). The SGA typically holds cache information such as data-buffers, SQL commands and user information. In addition to storage, the database consists of online redo logs (which hold transactional history). Processes can in turn archive the online redo logs into archive logs (offline redo logs), which provide the basis (if necessary) for data recovery and for some forms of data replication.

The Oracle RDBMS stores data logically in the form of tablespaces and physically in the form of data files. Tablespaces can contain various types of memory segments; for example, Data Segments, Index Segments etc. Segments in turn comprise one or more extents. Extents comprise groups of contiguous data blocks. Data blocks form the basic units of data storage. At the physical level, data-files comprise one or more data blocks, where the block size can vary between data-files.

Oracle databases can be used to create distributed database running over contiguous or disparate logistical locations. It can be used to store data and information and provides high availably and performance and is used extensively as a practial and reliable database.

We can design and engineer databases based on your business model and provide tools and interfaces that can be used to mine your business data. We also have experience in database persistence and create custom persistence frameworks and algorythms which can be used to predict patterns and trends from your data.

MySQL is a multithreaded, multi-user SQL database management system which has, according to MySQL AB, more than 10 million installations. The basic program runs as a server providing multiuser access to a number of databases.

Libraries for accessing MySQL databases are available in all major programming languages with language-specific APIs. In addition, an ODBC interface called MyODBC allows additional programming languages that support the ODBC interface to communicate with a MySQL database, such as ASP or ColdFusion. The MySQL server and official libraries are mostly implemented in ANSI C/ANSI C++.

MySQL is popular for web applications and acts as the database component of the

LAMP (Linux-Apache-MySQL-PHP/Perl/Python)

MAMP (Mac-Apache-MySQL-PHP/Perl/Python)

WAMP (Windows-Apache-MySQL-PHP/Perl/Python)

Its popularity for use with web application is closely tied to the popularity of PHP, which is often combined with MySQL. PHP and MySQL are essential components for running popular content management systems such as WordPress and Drupal blogging platforms. Wikipedia runs on MediaWiki software, which can also use PHP and a MySQL database.

MySQL is the most widely used OpenSource SQL database in the world. It provides features and services which make it ideal for small to medium enterprises to effectively manage small to reasonably large business data. It is also fulyl compliant with the SQL standard and provides support for stored procedures and object abstraction when coupled with object persistence frameworks.

We can design and engineer databases based on your business model and provide tools and interfaces that can be used to mine your business data. We also have experience in database persistence and create custom persistence frameworks and algorythms which can be used to predict patterns and trends from your data

Sap - Performance Tuning Using Parallel Cursor

Nested Loops – This is one of the fear factors for all the ABAP developers as this consumes lot of program execution time. If the number of entries in the internal tables is huge, then the situation would be too worse. The solution for this is to use parallel cursor method whenever there is a need for Nested Loop.

Program using Normal Nested Loop:

REPORT ZNORMAL_NESTEDLOOP.

TABLES:
likp,
lips.

Data:
t_likp type table of likp,
t_lips type TABLE OF lips.

data:
W_RUNTIME1 TYPE I,
W_RUNTIME2 TYPE I.

START-OF-SELECTION.
select *
from likp
into table t_likp.

select *
from lips
into table t_lips.

get RUN TIME FIELD w_runtime1.

loop at t_likp into likp.
loop at t_lips into lips where vbeln eq likp-vbeln.
endloop.
endloop.

get RUN TIME FIELD w_runtime2.

w_runtime2 = w_runtime2 - w_runtime1.

write w_runtime2.

Nested Loop using Parallel Cursor:

REPORT zparallel_cursor2.

TABLES:
likp,
lips.

DATA:
t_likp TYPE TABLE OF likp,
t_lips TYPE TABLE OF lips.

DATA:
w_runtime1 TYPE i,
w_runtime2 TYPE i,
w_index LIKE sy-index.

START-OF-SELECTION.
SELECT *
FROM likp
INTO TABLE t_likp.

SELECT *
FROM lips
INTO TABLE t_lips.

GET RUN TIME FIELD w_runtime1.
SORT t_likp BY vbeln.
SORT t_lips BY vbeln.

LOOP AT t_likp INTO likp.

LOOP AT t_lips INTO lips FROM w_index.
IF likp-vbeln NE lips-vbeln.
w_index = sy-tabix.
EXIT.
ENDIF.
ENDLOOP.
ENDLOOP.

GET RUN TIME FIELD w_runtime2.

w_runtime2 = w_runtime2 - w_runtime1.

WRITE w_runtime2.

Analysis report: Runtime in microseconds:
Iteration 1:
Normal Nested Loop: 34,796,147
Using Parallel Cursor: 63,829

Iteration 2:
Normal Nested Loop: 38,534,583
Using Parallel Cursor: 56,894

Iteration 3:
Normal Nested Loop: 34,103,426
Using Parallel Cursor: 50,510

Microsoft CRM as Time Logs for Consulting Business: Integration With Great Plains

This article is targeted to programmers, we are providing C# source code for CRM->GP integration. The code provided is not packaged product, but rather “solution”, which needs to be tailored and installed by GP eConnect C# programmers. What integration does:

1. If you log your timesheets as tasks in Microsoft CRM against contract line cases – these tasks will be integrated as GP Sales Order Processing Invoice lines with description cut to one hundred symbols – this is restriction of GP SOP line description

2. In GP sales invoices are created automatically by overnight integration when you close the case in CRM. If you close several cases for the same customer, let’s say QA, development, onsite consulting, all the cases and corresponding tasks will be combined in one invoice per customer

3. Additional possibilities in MS Dynamics CRM. If you log time against the cases, linked to contract lines, you can create very powerful consultant time tracking report and project status report.

4. Additional Comments. Microsoft Dynamics GP eConnect 10.0 SDK doesn’t have source code for Sales Invoice integration C# demo project. We worked out this project and its code is incorporated in the provided demo C# code, please look at the procedure: SerializeSalesOrderObject

Below you see the code listing:

using System;
using System.IO;
using System.Collections;
using System.Data;
using System.Diagnostics;
using System.Data.SqlClient;
using System.Xml;
using System.Text;
using System.Xml.Serialization;
using Microsoft.Dynamics.GP.eConnect;
using Microsoft.Dynamics.GP.eConnect.Serialization;
using Microsoft.Dynamics.GP.eConnect.MiscRoutines;

namespace Integration
{
sealed public class OrderApp
{
public static string outerSelectString;// = "SELECT DISTINCT SQLSERVER, DATABASENAME FROM ALBANEWTIMELOG";
public static string innerSelectString;// = "SELECT AccountNumber,BillableTime,UnitPrice,LineTotalPrice,[Description],ItemNumber,SQLSERVER,DATABASENAME, IncidentId FROM ALBANEWTIMELOG WHERE DATABASENAME=";
public static string connectionString ;//= "Integrated Security = true;Data Source = CRMSERVER; Initial Catalog = CRMCUSTOMIZATION;";
public static DataTable TableLines; // the datasource of the datagrid called DataLines.

// Error handling variables
public static string sErrMsg;
public static int lErrCode;
public static int lRetCode;

static string sDatabaseName, sServerName, sUserName, sPassword;
static string description, itemnumber, accountNumber, sCustomerPO;
static char char39=(char)39; //to immitate ' symbol
static System.Data.SqlTypes.SqlGuid incidentId;

// ****************************************************************************
// This is the application entry point
// ****************************************************************************
public static void Main()
{

string sCustomerDocument;
string sSalesOrder;
string sXsdSchema;
string sConnectionString;

string NAME="";
string CONTACT="";
string ADDRESS1="";
string ADDRESS2="";
string CITY="";
string STATE="";
string ZIP="";

string currentCustomer = "";

sConnectionString = @"data source=ALBASERVER;initial catalog=ALBA;integrated security=SSPI;persist security info=False;packet size=4096";

StreamReader re = File.OpenText("C:\_IntegrationGP\Integration\Settings.txt");
connectionString = re.ReadLine();
outerSelectString=re.ReadLine();
innerSelectString=re.ReadLine();
sUserName = re.ReadLine();
sPassword = re.ReadLine();
String crmConnectionString = re.ReadLine();
String customerSelectString = re.ReadLine();
String timeLogSelectString = re.ReadLine();
re.Close();

SqlConnection outerConnection = new SqlConnection();
outerConnection.ConnectionString = connectionString;
outerConnection.Open();

SqlCommand outerCommand = new SqlCommand();
outerCommand.CommandType = System.Data.CommandType.Text;
outerCommand.CommandText = outerSelectString;
outerCommand.Connection = outerConnection;
SqlDataReader outerReader = outerCommand.ExecuteReader();

while(outerReader.Read())
{
sServerName="";
sDatabaseName="";
//reading databases-companie and their server names in timelog
sServerName=outerReader.GetSqlString(0).ToString();
sDatabaseName=outerReader.GetSqlString(1).ToString();

sServerName=sServerName.Trim();
sDatabaseName=sDatabaseName.Trim();

SqlConnection connection = new SqlConnection();
connection.ConnectionString = connectionString;
connection.Open();

SqlCommand command = new SqlCommand();
command.CommandType = System.Data.CommandType.Text;
command.CommandText = innerSelectString+char39+sDatabaseName+char39+" order by AccountNumber";
command.Connection = connection;
SqlDataReader reader = command.ExecuteReader();

while(reader.Read())
{
decimal billableTime, unitPrice, lineTotal;
double bTime, uPrice;

description="";
itemnumber="";
accountNumber="";

sCustomerPO="";

Console.WriteLine("Record:");
//reading from timelog
accountNumber=reader.GetSqlString(0).ToString();

billableTime=reader.GetSqlDecimal(1).Value;
unitPrice=reader.GetSqlDecimal(2).Value;
lineTotal=reader.GetSqlDecimal(3).Value;
description=reader.GetSqlString(4).ToString();
itemnumber=reader.GetSqlString(5).ToString();
incidentId=reader.GetSqlGuid(8);
sCustomerPO=reader.GetSqlString(9).ToString();
//add fields

bTime=(double)billableTime;
uPrice=(double)unitPrice;

Console.WriteLine(billableTime);
Console.WriteLine(billableTime.ToString());
Console.WriteLine(unitPrice.ToString());
Console.WriteLine(lineTotal.ToString());
Console.WriteLine(description.ToString());
Console.WriteLine(itemnumber.ToString ());
Console.WriteLine(sCustomerPO.ToString ());
Console.WriteLine();

try
{
if (String.Compare(currentCustomer, accountNumber) != 0)
{
using (eConnectMethods e = new eConnectMethods())
{
//-Update-Create Customer-------------------------------------------------------
//--------------------------------------------------------------------------------
try
{
//Read Customer info from CRM

SqlConnection crmConnection = new SqlConnection();
crmConnection.ConnectionString = crmConnectionString;
crmConnection.Open();

SqlCommand commandCustomer = new SqlCommand();
commandCustomer.CommandType = System.Data.CommandType.Text;
commandCustomer.CommandText = customerSelectString + char39 + accountNumber + char39 + " order by a.AccountNumber";
commandCustomer.Connection = crmConnection;
SqlDataReader readerCustomer = commandCustomer.ExecuteReader();
if (!readerCustomer.Read()) return;
readerCustomer.GetSqlString(0).ToString();
string sName = readerCustomer.GetSqlString(1).ToString();
if (String.Compare(sName, "Null") == 0) sName = "";
NAME = sName;
string sContact = readerCustomer.GetSqlString(4).ToString();
if (String.Compare(sContact, "Null") == 0) sContact = "";
CONTACT = sContact;
string sLine1 = readerCustomer.GetSqlString(5).ToString();
if (String.Compare(sLine1, "Null") == 0) sLine1 = "";
ADDRESS1 = sLine1;
string sLine2 = readerCustomer.GetSqlString(6).ToString();
if (String.Compare(sLine2, "Null") == 0) sLine2 = "";
ADDRESS2 = sLine2;
string sCity = readerCustomer.GetSqlString(7).ToString();
if (String.Compare(sCity, "Null") == 0) sCity = "";
CITY = sCity;
string sState = readerCustomer.GetSqlString(8).ToString();
if (String.Compare(sState, "Null") == 0) sState = "";
STATE = sState;
string sZip = readerCustomer.GetSqlString(9).ToString();
ZIP = sZip;
if (String.Compare(sZip, "Null") == 0) sZip = "";
string sCountry = readerCustomer.GetSqlString(10).ToString();
if (String.Compare(sCountry, "Null") == 0) sCountry = "";

readerCustomer.Close();
commandCustomer.Dispose();
crmConnection.Close();
crmConnection.Dispose();

// Create the customer data file
SerializeCustomerObject("Customer.xml", accountNumber, sName, sContact, sLine1, sLine2, "MAIN", sCity, sState, sZip, sCountry);

// Use an XML document to create a string representation of the customer
XmlDocument xmldoc = new XmlDocument();
xmldoc.Load("Customer.xml");
sCustomerDocument = xmldoc.OuterXml;

// Create an XML Document object for the schema
XmlDocument XsdDoc = new XmlDocument();

// Create a string representing the eConnect schema
sXsdSchema = XsdDoc.OuterXml;

// Pass in xsdSchema to validate against.
e.eConnect_EntryPoint(sConnectionString, EnumTypes.ConnectionStringType.SqlClient, sCustomerDocument, EnumTypes.SchemaValidationType.None, sXsdSchema);

}
// The eConnectException class will catch eConnect business logic errors.
// display the error message on the console
catch (eConnectException exc)
{
Console.Write(exc.ToString());
}

} // end of using statement
//End Update-Create Customer
//-----------------------------------------------------------
//Sales Invoice begins-----------------------
//--------------------------------------------

using (eConnectMethods e = new eConnectMethods())
{
try
{
GetSopNumber mySopNumber = new GetSopNumber();
string SOPNUMBE = mySopNumber.GetNextSopNumber(3, "INV", sConnectionString);

eConnectType eConnect = new eConnectType();

//Read Customer info from CRM

SqlConnection crmConnection = new SqlConnection();
crmConnection.ConnectionString = crmConnectionString;
crmConnection.Open();

SqlCommand commandSalesOrder = new SqlCommand();
commandSalesOrder.CommandType = System.Data.CommandType.Text;
commandSalesOrder.CommandText = timeLogSelectString + char39 + accountNumber + char39 + " order by a.AccountNumber";
commandSalesOrder.Connection = crmConnection;
SqlDataReader readerSalesOrder = commandSalesOrder.ExecuteReader();

taSopLineIvcInsert_ItemsTaSopLineIvcInsert[] items = new taSopLineIvcInsert_ItemsTaSopLineIvcInsert[0];
decimal SUBTOTAL = 0;
int iSO = 0;
while (readerSalesOrder.Read())
{
decimal hours = readerSalesOrder.GetSqlDecimal(0).Value;
string sDescription = readerSalesOrder.GetSqlString(1).ToString();
if (String.Compare(sDescription, "Null") == 0) sDescription = "miscellaneous";
decimal rate = readerSalesOrder.GetSqlDecimal(2).Value;

taSopLineIvcInsert_ItemsTaSopLineIvcInsert item = new taSopLineIvcInsert_ItemsTaSopLineIvcInsert();

hours = Decimal.Round(hours, 2);
rate = Decimal.Round(rate, 2);
if (rate < (decimal)0.01)
rate = (decimal)0.60;

item.SOPNUMBE = SOPNUMBE;
item.SOPTYPE = 3;
item.CUSTNMBR = accountNumber;
item.DOCID = "INV";
item.QUANTITY = hours;
item.ITEMNMBR = "SERVICE";
item.ITEMDESC = sDescription;
item.UNITPRCE = rate;
item.XTNDPRCE = hours * rate;
item.DOCDATE = System.DateTime.Today.Date.ToString();
item.NONINVEN = 1;

//items[iSO] = item;
SUBTOTAL += hours * rate;
iSO++;
if (items.Length < iSO) items = (taSopLineIvcInsert_ItemsTaSopLineIvcInsert[])ExpandArray((Array)items, item);
}
readerSalesOrder.Close();
commandSalesOrder.Dispose();
crmConnection.Close();
crmConnection.Dispose();

SOPTransactionType SopOrder = new SOPTransactionType();
XmlSerializer serializer = new XmlSerializer(eConnect.GetType());

SopOrder.taSopLineIvcInsert_Items = items;

taSopHdrIvcInsert header = new taSopHdrIvcInsert();

header.SOPTYPE = 3;
header.SOPNUMBE = SOPNUMBE;
header.DOCID = "INV";
header.BACHNUMB = "ECONNECT";
header.CUSTNMBR = accountNumber;
header.CUSTNAME = NAME;
//header.ShipToName = "WAREHOUSE";
header.ADDRESS1 = ADDRESS1;
header.CNTCPRSN = CONTACT;
// header.FAXNUMBR = "13125550150";
header.CITY = CITY;
header.STATE = STATE;
header.ZIPCODE = ZIP;
// header.COUNTRY = "USA";
header.SUBTOTAL = SUBTOTAL;
header.DOCAMNT = SUBTOTAL;
// header.USINGHEADERLEVELTAXES = 0;
// header.PYMTRMID = "Net 30";
header.DOCDATE = System.DateTime.Today.Date.ToString();

SopOrder.taSopHdrIvcInsert = header;

SOPTransactionType[] mySOPOrder = { SopOrder };
eConnect.SOPTransactionType = mySOPOrder;

FileStream fs = new FileStream("SalesOrder.xml", FileMode.Create);
XmlTextWriter writer = new XmlTextWriter(fs, new UTF8Encoding());
serializer.Serialize(writer, eConnect);
writer.Close();

XmlDocument xmldoc = new XmlDocument();
xmldoc.Load("SalesOrder.xml");
sSalesOrder = xmldoc.OuterXml;
XmlDocument XsdDoc = new XmlDocument();
sXsdSchema = XsdDoc.OuterXml;
e.eConnect_EntryPoint(sConnectionString, EnumTypes.ConnectionStringType.SqlClient, sSalesOrder, EnumTypes.SchemaValidationType.None, sXsdSchema);

}

catch (eConnectException exc)
{
Console.Write(exc.ToString());
}

}

//Sales Invoice ends-----------------------
//--------------------------------------------
}

{ //Marking case as imported
SqlConnection updateConnection = new SqlConnection();
updateConnection.ConnectionString = connectionString;
updateConnection.Open();

SqlCommand commandUpdate = new SqlCommand();
commandUpdate.CommandType = System.Data.CommandType.StoredProcedure;
commandUpdate.CommandText = "sp_UpdateImportedCase";
commandUpdate.Parameters.Add("@incidentId", SqlDbType.UniqueIdentifier);
commandUpdate.Parameters["@incidentId"].Value = incidentId;
commandUpdate.Connection = updateConnection;
commandUpdate.ExecuteNonQuery();
commandUpdate.Dispose();
updateConnection.Close();
updateConnection.Dispose();
}

}
catch { }
currentCustomer = accountNumber;
}
reader.Close();
command.Dispose();
connection.Close();
connection.Dispose();
}
}

public static void SerializeCustomerObject(string filename, string custnumbr, string name, string cntcprsn,string address1, string address2, string adrscode, string city, string state, string zip, string country)
{
try
{
// Instantiate an eConnectType schema object
eConnectType eConnect = new eConnectType();

// Instantiate a RMCustomerMasterType schema object
RMCustomerMasterType customertype = new RMCustomerMasterType();

// Instantiate a taUpdateCreateCustomerRcd XML node object
taUpdateCreateCustomerRcd customer = new taUpdateCreateCustomerRcd();

// Create an XML serializer object
XmlSerializer serializer = new XmlSerializer(eConnect.GetType());

// Populate elements of the taUpdateCreateCustomerRcd XML node object
customer.CUSTNMBR = custnumbr;
customer.CUSTNAME = name;
customer.CNTCPRSN = cntcprsn;
customer.ADDRESS1 = address1;
customer.ADDRESS2 = address2;
customer.ADRSCODE = adrscode;
customer.CITY = city;
customer.STATE = state;
customer.ZIPCODE = zip;
customer.COUNTRY = country;
customer.CUSTPRIORITY = 1;
customer.CUSTPRIORITYSpecified = true;

// Populate the RMCustomerMasterType schema with the taUpdateCreateCustomerRcd XML node
customertype.taUpdateCreateCustomerRcd = customer;
RMCustomerMasterType[] mySMCustomerMaster = { customertype };

// Populate the eConnectType object with the RMCustomerMasterType schema object
eConnect.RMCustomerMasterType = mySMCustomerMaster;

// Create objects to create file and write the customer XML to the file
FileStream fs = new FileStream(filename, FileMode.Create);
XmlTextWriter writer = new XmlTextWriter(fs, new UTF8Encoding());

// Serialize the eConnectType object to a file using the XmlTextWriter.
serializer.Serialize(writer, eConnect);
writer.Close();
}
// catch any errors that occur and display them to the console
catch (System.Exception ex)
{
Console.Write(ex.ToString());
}
}

//the following function is for demo only, not in use
public static void SerializeSalesOrderObject(string filename)
{
try
{
// Instantiate an eConnectType schema object
eConnectType eConnect = new eConnectType();

taSopLineIvcInsert_ItemsTaSopLineIvcInsert[] items = new taSopLineIvcInsert_ItemsTaSopLineIvcInsert[1];

taSopLineIvcInsert_ItemsTaSopLineIvcInsert item = new taSopLineIvcInsert_ItemsTaSopLineIvcInsert();

item.ADDRESS1 = "2345 Main St.";
item.CUSTNMBR = "CONTOSOL0001";
item.SOPNUMBE = "000001";
item.CITY = "Aurora";
item.SOPTYPE = 3;
item.DOCID = "STDINV";
item.QUANTITY = 2;
item.ITEMNMBR = "ACCS-CRD-12WH";
item.ITEMDESC = "Phone Cord - 12' White";
item.UNITPRCE = (decimal)10.95;
item.XTNDPRCE = (decimal)21.9;
item.LOCNCODE = "WAREHOUSE";
item.DOCDATE = "04/12/2017";// 'Today

items[0] = item;

SOPTransactionType SopOrder = new SOPTransactionType();
XmlSerializer serializer = new XmlSerializer(eConnect.GetType());

SopOrder.taSopLineIvcInsert_Items = items;

taSopHdrIvcInsert header = new taSopHdrIvcInsert();

header.SOPTYPE = 3;
header.SOPNUMBE = "000001";
header.DOCID = "STDINV";
header.BACHNUMB = "ECONNECT ";
header.TAXSCHID = "USASTCITY-6*";
header.FRTSCHID = "USASTCITY-6*";
header.MSCSCHID = "USASTCITY-6*";
header.LOCNCODE = "WAREHOUSE";
header.DOCDATE = "04/12/2017";
header.CUSTNMBR = "CONTOSOL0001";
header.CUSTNAME = "Contoso, Ltd.";
header.ShipToName = "WAREHOUSE";
header.ADDRESS1 = "2345 Main St.";
header.CNTCPRSN = "Joe Healy";
header.FAXNUMBR = "13125550150";
header.CITY = "Aurora";
header.STATE = "IL";
header.ZIPCODE = "65700";
header.COUNTRY = "USA";
header.SUBTOTAL = (decimal)21.9;
header.DOCAMNT = (decimal)21.9;
header.USINGHEADERLEVELTAXES = 0;
header.PYMTRMID = "Net 30";

SopOrder.taSopHdrIvcInsert = header;

// Populate the RMCustomerMasterType schema with the taUpdateCreateCustomerRcd XML node
//customertype.taUpdateCreateCustomerRcd = customer;
//RMCustomerMasterType[] mySMCustomerMaster = { customertype };

SOPTransactionType[] mySOPOrder = { SopOrder };
eConnect.SOPTransactionType = mySOPOrder;

// Populate the eConnectType object with the RMCustomerMasterType schema object
//eConnect.RMCustomerMasterType = mySMCustomerMaster;

// Create objects to create file and write the customer XML to the file
FileStream fs = new FileStream(filename, FileMode.Create);
XmlTextWriter writer = new XmlTextWriter(fs, new UTF8Encoding());

// Serialize the eConnectType object to a file using the XmlTextWriter.
serializer.Serialize(writer, eConnect);
writer.Close();

}
// catch any errors that occur and display them to the console
catch (System.Exception ex)
{
Console.Write(ex.ToString());
}
}
//this function allows us to increase Array length on the fly - we use it when we reading n=lines for Sales Invoice
public static Array ExpandArray(Array arr, object newElement)
{
int length = 1;
System.Type type = newElement.GetType();
if (arr != null)
{
length += arr.Length;
type = arr.GetType().GetElementType();
}
Array result = Array.CreateInstance(type, length);
if (arr != null)
{
arr.CopyTo(result, 0);
}
result.SetValue(newElement, result.Length - 1);
return result;
}
}
}

Blog Archive

Powered By