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)
{
}
}
