public static int InsertServiceDirection(ServiceDirectionModel serviceDirection)
{
string sql = "INSERT OR IGNORE INTO ServiceDirections (ServiceDirectionName, ServiceDirectionAbbreviation, RouteId, IsDescending) " +
"VALUES(@ServiceDirectionName, @ServiceDirectionAbbreviation, @RouteId, @IsDescending);" +
"SELECT last_insert_rowid();";
return(SQLiteData.SaveData <dynamic>(sql, new { serviceDirection.ServiceDirectionName, serviceDirection.ServiceDirectionAbbreviation, serviceDirection.RouteId, serviceDirection.IsDescending }, SQLiteData.GetConnectionString()));
}
private void ImportServiceDirection(string[] fields)
{
var serviceDirection = new ServiceDirectionModel();
serviceDirection.Id = int.Parse(fields[1]);
serviceDirection.ServiceDirectionName = fields[2];
serviceDirection.ServiceDirectionAbbreviation = fields[3];
serviceDirection.IsDescending = bool.Parse(fields[5]);
serviceDirection.RouteId = newRouteId;
var newServiceDirectionId = ServiceDirectionDataAccess.InsertServiceDirection(serviceDirection);
ServiceDirectionKeys.Add(serviceDirection.Id, newServiceDirectionId);
}
public void SaveServiceDirection()
{
ServiceDirectionModel newServicesDirection = new ServiceDirectionModel();
newServicesDirection.ServiceDirectionName = ServiceDirectionName;
newServicesDirection.ServiceDirectionAbbreviation = ServiceDirectionAbbreviation;
newServicesDirection.RouteId = RouteId;
newServicesDirection.IsDescending = IsDescending;
if (ServiceDirectionId > 0)
{
newServicesDirection.Id = ServiceDirectionId;
ServiceDirectionDataAccess.UpdateServiceDirectionForRoute(newServicesDirection);
}
else
{
ServiceDirectionDataAccess.InsertServiceDirection(newServicesDirection);
}
ClearServiceDirection();
ServiceDirectionsList = new BindableCollection <ServiceDirectionModel>(ServiceDirectionDataAccess.GetAllServiceDirectionsPerRoute(RouteId));
NotifyOfPropertyChange(() => ServiceDirectionsList);
}
public static void UpdateServiceDirectionForRoute(ServiceDirectionModel serviceDirection)
{
string sql = "UPDATE OR IGNORE ServiceDirections SET ServiceDirectionName=@ServiceDirectionName, serviceDirectionAbbreviation=@ServiceDirectionAbbreviation, RouteId=@RouteId, IsDescending=@IsDescending WHERE Id=@Id";
SQLiteData.SaveData <dynamic>(sql, new { serviceDirection.Id, serviceDirection.ServiceDirectionName, serviceDirection.ServiceDirectionAbbreviation, serviceDirection.RouteId, serviceDirection.IsDescending }, SQLiteData.GetConnectionString());
}
