Nope C2 is a "structural analysis" beam element program. I assume pipe surge is unsteady fluid flow, hydraulic surge, or most commonly called water hammer. These unsteady time based fluid studies require a unsteady fluids program such as surge 5.
There are lots of transient flow programs, some mentioned above - add to those "Flowmaster" from company of the same name, which I have used extensively and can recommend. Also "Hammer" by Haested systems looks good.
This is inexpensive (certainly not true of the others)and easy to use (the others are very comprehensive and powerful so have lots of pitfalls for beginners). I can help you use it and offer some spreadsheets for data analysis if needed. Linking between flow software and Caesar is not easy with most programs, but I believe that Pipenet can do so directly. However expect to pay thousands of dollars per year to lease these powerful programs, whereas hundreds of dollars buys you HiTrans outright! I have validated HiTrans results against Flowmaster and an confident in its answers. However like all technical problems, you need to understand the subject - no software can prevent you putting in garbage and getting garbage in return!