public CreateUserEnum AddUpdateRoute(Route polObject) { try { if (string.IsNullOrEmpty(polObject.RouteGuid)) // //Add new polygon { Route Record = RoutesDB.GetRouteByName(polObject.RouteName); if (Record != null) { return(CreateUserEnum.UserAlreadyExists); } polObject.RouteGuid = Util.CretaeGuid().ToString(); } CreateUserEnum result = RoutesDB.SaveRoute(polObject); if (result == DAL.CreateUserEnum.CreationSuccess) { return(CreateUserEnum.CreationSuccess); } else { return(CreateUserEnum.CreationFailed); } } catch (Exception ex) { return(CreateUserEnum.CreationFailed); } }
public static void SaveActivityOLD(GeneralActivityDTO ActivityDTO) { try { int Actid = ActivityDTO.ActivityId; object ob = null; string sql; using (NpgsqlConnection connection = new NpgsqlConnection(strPostGISConnection)) { connection.Open(); NpgsqlTransaction sqlTran = connection.BeginTransaction(); try { // ****** Atom ******* if (string.IsNullOrEmpty(ActivityDTO.Atom.UnitGuid)) //new Atom { ActivityDTO.Atom.UnitGuid = Util.CretaeGuid().ToString(); sql = "insert into AtomObjects (atom_guid,atom_name,CountryId,pointX,pointY)" + "values ('" + ActivityDTO.Atom.UnitGuid + "','" + ActivityDTO.Atom.UnitName + "'," + 0 + "," + ActivityDTO.Atom.Location.x + "," + ActivityDTO.Atom.Location.y + " ) "; using (NpgsqlCommand command = new NpgsqlCommand(sql, connection)) { command.Transaction = sqlTran; command.ExecuteNonQuery(); } } else { sql = "update AtomObjects set atom_guid='" + ActivityDTO.Atom.UnitGuid + "'" + " ,atom_name='" + ActivityDTO.Atom.UnitName + "'" + " ,CountryId=" + 0 + " ,pointX=" + ActivityDTO.Atom.Location.x + " ,pointY=" + ActivityDTO.Atom.Location.y + " where atom_guid='" + ActivityDTO.Atom.UnitGuid + "'"; using (NpgsqlCommand command = new NpgsqlCommand(sql, connection)) { command.Transaction = sqlTran; command.ExecuteNonQuery(); } } // ****** Route ****** if (string.IsNullOrEmpty(ActivityDTO.RouteActivity.RouteGuid)) { ActivityDTO.RouteActivity.RouteGuid = Util.CretaeGuid().ToString(); } RoutesDB.SaveRoute(ActivityDTO.RouteActivity, connection, sqlTran); // ****** Activity ******* if (ActivityDTO.ActivityId == 0) //new Activity { sql = "insert into ActivityMovement (atom_guid,StartActivityOffset,DurationActivity,Speed,route_guid)" + "values ('" + ActivityDTO.Atom.UnitGuid + "','" + ActivityDTO.StartActivityOffset.ToString() + "','" + ActivityDTO.DurationActivity.ToString() + "'," + ActivityDTO.Speed + ",'" + ActivityDTO.RouteActivity.RouteGuid + "'" + " ) RETURNING ActivityId"; using (NpgsqlCommand command = new NpgsqlCommand(sql, connection)) { command.Transaction = sqlTran; Actid = (int)command.ExecuteScalar(); ActivityDTO.ActivityId = Actid; } } else { sql = "update ActivityMovement set atom_guid='" + ActivityDTO.Atom.UnitGuid + "'" + " ,StartActivityOffset='" + ActivityDTO.StartActivityOffset.ToString() + "'" + " ,DurationActivity='" + ActivityDTO.DurationActivity.ToString() + "'" + " ,Speed=" + ActivityDTO.Speed + " ,route_guid='" + ActivityDTO.RouteActivity.RouteGuid + "'" + " where ActivityId=" + ActivityDTO.ActivityId; using (NpgsqlCommand command = new NpgsqlCommand(sql, connection)) { command.Transaction = sqlTran; command.ExecuteNonQuery(); } } //********************************************************** sqlTran.Commit(); } catch (Exception ex) { try { sqlTran.Rollback(); } catch (Exception exRollback) { } } } } catch (Exception ex) { } }