HYTOS

        public static bool SaveRevision(string ProjectCode, int RevNumber, string UserName, string PSNDatabasePath, string PsnByPBSFilter, string PsnByNPDFilter,

            int PidDrawings, int PipeSystems, int PipeLines, int Topologies, int PipeSystemNetworks, int InValidPSNs, int E2E, int E2B, int B2E, int HDE, int HD2, int HDB, int B2B)

        {

            ID2Info id2Info = ID2Info.GetInstance();

            bool result = true;

            using (IAbstractDatabase connection = id2Info.CreateConnection())

            {

                try

                {

                    using (var txn = connection.BeginTransaction())

                    {

                        try

                        {                           

                            var query = $"INSERT INTO ARS_COMMON.dbo.PSNRevision (OID, Project_OID, ProjectCode, RevNumber, UserName, TimeData, PSNDatabasePath, " +

                                $"PsnByPBSFilter, PsnByNPDFilter, PidDrawings, PipeSystems, PipeLines, Topologies, PipeSystemNetworks, InValidPSNs, E2E, E2B, B2E, HDE, " +

                                $"HD2, HDB, B2B) VALUES (NEWID(), NEWID(), @ProjectCode, @RevNumber, @UserName, @TimeData, @PSNDatabasePath" +

                                $", @PsnByPBSFilter, @PsnByNPDFilter, @PidDrawings, @PipeSystems, @PipeLines, @Topologies, @PipeSystemNetworks, @InValidPSNs, " +

                                $"@E2E, @E2B, @B2E, @HDE, @HD2, @HDB, @B2B)";

                            var cmd = connection.GetSqlStringCommand(query);

                            AddWithValue(cmd, "@OID", Guid.NewGuid().ToString());

                            AddWithValue(cmd, "@Project_OID", Guid.NewGuid().ToString());

                            AddWithValue(cmd, "@ProjectCode", ProjectCode);

                            AddWithValue(cmd, "@RevNumber", RevNumber);

                            AddWithValue(cmd, "@UserName", UserName);

                            AddWithValue(cmd, "@TimeData", DateTime.Now.ToLongDateString());

                            AddWithValue(cmd, "@PSNDatabasePath", PSNDatabasePath);

                            AddWithValue(cmd, "@PsnByPBSFilter", PsnByPBSFilter);

                            AddWithValue(cmd, "@PsnByNPDFilter", PsnByNPDFilter);

                            AddWithValue(cmd, "@PidDrawings", PidDrawings);

                            AddWithValue(cmd, "@PipeSystems", PipeSystems);

                            AddWithValue(cmd, "@PipeLines", PipeLines);

                            AddWithValue(cmd, "@Topologies", Topologies);

                            AddWithValue(cmd, "@PipeSystemNetworks", PipeSystemNetworks);

                            AddWithValue(cmd, "@InValidPSNs", InValidPSNs);

                            AddWithValue(cmd, "@E2E", E2E);

                            AddWithValue(cmd, "@E2B", E2B);

                            AddWithValue(cmd, "@B2E", B2E);

                            AddWithValue(cmd, "@HDE", HDE);

                            AddWithValue(cmd, "@HD2", HD2);

                            AddWithValue(cmd, "@HDB", HDB);

                            AddWithValue(cmd, "@B2B", B2B);

                            connection.ExecuteNonQuery(cmd, txn);

                            txn.Commit();

                        }

                        catch (Exception ex)

                        {

                            txn.Rollback();

                            result = false;

                        }

                    }

                }

                catch (Exception ex)

                {

                    System.Windows.Forms.MessageBox.Show(ex.Message);

                    result = false;

                }

            }

            return result;

        }