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()); }