public UISlider AddSlider(float x, float y, float width, float height, int minValue = 0, int maxValue = 100, int currentValue = 0)
{
var control = new UISlider(x, y, width, height, minValue, maxValue, currentValue);
UIControls.Add(control);
return(control);
}
public UIButton AddButton(float x, float y, float width, float height, string text)
{
var button = new UIButton(x, y, width, height, text);
UIControls.Add(button);
return(button);
}
private void LangCmbBx_DragDrop(object sender, DragEventArgs e)
{
if (e.Effect != DragDropEffects.Copy)
{
return;
}
string ourFile = ((string[])e.Data.GetData(DataFormats.FileDrop))[0];
try
{
UIControls UI = new UIControls();
UI = UI.LoadFromFile(ourFile);
DialogResult DR = MessageBox.Show("Are you sure you want to load the UI from this file?", "Notice", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (DR == DialogResult.Yes)
{
UpdateUI(UI);
}
else
{
return;
}
}
catch (Exception error)
{
MessageBox.Show(error.ToString());
MessageBox.Show("Error Loading the UI File", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public Panel AddPanel(float x, float y, float width, float height)
{
var panel = new Panel(x, y, width, height);
UIControls.Add(panel);
return(panel);
}
public QSections(DCAnalytics.ObjectType objectType, Questionaire _questionaire, QuestionairePageState questionairePageState = null, Certification _certification = null, FieldInspection _fieldInspection = null)
{
InitializeComponent();
controls = new UIControls(this);
ObjectType = objectType;
selectPageState = this;
promptPageState = this;
picturePageState = this;
locationPageState = this;
questionaire = null;
questionaire = _questionaire;
FieldInspection = _fieldInspection;
certification = _certification;
Title = questionaire.Name;
this.questionairePageState = questionairePageState;
sectionViews = new List <SectionView>();
_questionaireStatus = string.IsNullOrEmpty(questionaire.Key) ? QuestionaireStatus.Create : QuestionaireStatus.Modify;
_dbManager = new DatabaseManager();
user = AiDataStore.GetUser();
configuration = AiDataStore.GetConfiguration();
isValid = true;
Sections.Clear();
Sections = (FieldInspection != null) ?
FieldInspection.Sections:
(certification != null) ?
certification.Sections:
questionaire.Sections;
dependencies.Clear();
navigatedTargetSections.Clear();
controls.targets.Clear();
Init();
}
public UIToggle AddToggle(float x, float y, float width, float height, Sprite activeImage, Sprite inactiveImage)
{
var control = new UIToggle(x, y, width, height, activeImage, inactiveImage);
UIControls.Add(control);
return(control);
}
static void Main(string[] args)
{
var app = new Program();
try
{
var option = new InitializationOptions(app)
{
//Using DP without device scaling mode
DisplayResolutionUnit = DisplayResolutionUnit.DP(),
UseSkiaSharp = true
};
Forms.Init(option);
if (Device.Idiom == TargetIdiom.TV)
{
// UIControls.Init() should be called after Forms.Init()
UIControls.Init(new InitOptions(app));
CommonUI.Init(app);
}
else
{
CommonUI.Init(app);
CommonUI.AddCommonThemeOverlay();
}
app.Run(args);
}
catch (Exception e)
{
Console.WriteLine($"Exception : {e.Message}");
}
}
public UIPlusMinus AddPlusMinus(float x, float y, float width, float height, float buttonSize = 10f, int minValue = 0, int maxValue = 100, int currentValue = 50, int valueStep = 1, int fontSize = 20)
{
var control = new UIPlusMinus(x, y, width, height, buttonSize, minValue, maxValue, currentValue, valueStep, fontSize);
UIControls.Add(control);
return(control);
}
public WindowExportGGZSettings(UIControls.ActionBuilder.ActionExportGGZ.ExportGPXSettings gpxSettings)
{
GPXSettings = gpxSettings;
InitializeComponent();
GPXVersion.Items.Add(Utils.GPXGenerator.V100);
GPXVersion.Items.Add(Utils.GPXGenerator.V101);
DataContext = GPXSettings;
}
/// <summary>
/// Performs initial setup for the panel; we don't use Start() as that's not sufficiently reliable (race conditions), and is not needed with the dynamic create/destroy process.
/// </summary>
internal void Setup(float width, float height)
{
// Size and placement.
this.autoSize = false;
this.autoLayout = false;
this.width = width - (Margin * 2f);
this.height = height - (Margin * 2f);
// Add title
float currentY = TitleLabel(this, "EYM_NAM");
// Add sliders.
UISlider intensitySlider = UIControls.AddSliderWithValue(this, Translations.Translate("EYM_OPT_INT"), 1f, 3f, 0.1f, MouseLight.intensityMultiplier, (value) => MouseLight.intensityMultiplier = value);
UISlider rangeSlider = UIControls.AddSliderWithValue(this, Translations.Translate("EYM_OPT_RNG"), 1f, 16f, 0.5f, MouseLight.rangeMultiplier, (value) => MouseLight.rangeMultiplier = value);
UISlider redSlider = UIControls.AddSliderWithValue(this, Translations.Translate("EYM_OPT_RED"), 0f, 1f, 0.01f, MouseLight.Red, (value) => MouseLight.Red = value);
UISlider greenSlider = UIControls.AddSliderWithValue(this, Translations.Translate("EYM_OPT_GRN"), 0f, 1f, 0.01f, MouseLight.Green, (value) => MouseLight.Green = value);
UISlider blueSlider = UIControls.AddSliderWithValue(this, Translations.Translate("EYM_OPT_BLU"), 0f, 1f, 0.01f, MouseLight.Blue, (value) => MouseLight.Blue = value);
// Set slider positions.
currentY = SliderPosition(rangeSlider, currentY);
currentY = SliderPosition(intensitySlider, currentY);
UILabel colorLabel = UIControls.AddLabel(this, Margin, currentY, Translations.Translate("EYM_OPT_COL"), textScale: 1.3f);
colorLabel.font = Resources.FindObjectsOfTypeAll <UIFont>().FirstOrDefault((UIFont f) => f.name == "OpenSans-Semibold");
currentY += colorLabel.height + Margin;
currentY = SliderPosition(redSlider, currentY);
currentY = SliderPosition(greenSlider, currentY);
currentY = SliderPosition(blueSlider, currentY);
// Revert to defaults button.
UIButton defaultsButton = UIControls.AddButton(this, Margin, currentY, Translations.Translate("EYM_OPT_DEF"), width = 300f);
defaultsButton.eventClicked += (control, clickEvent) =>
{
intensitySlider.value = MouseLight.DefaultIntensity;
rangeSlider.value = MouseLight.DefaultRange;
redSlider.value = MouseLight.DefaultRed;
greenSlider.value = MouseLight.DefaultGreen;
blueSlider.value = MouseLight.DefaultBlue;
};
// Language dropdown.
currentY += defaultsButton.height + (Margin * 2f);
UIControls.OptionsSpacer(this, Margin, currentY, this.width - (Margin * 2f));
currentY += 15f;
UIDropDown translationDropDown = UIControls.AddPlainDropDown(this, Translations.Translate("TRN_CHOICE"), Translations.LanguageList, Translations.Index);
translationDropDown.parent.relativePosition = new Vector2(Margin, currentY);
// Event handler.
translationDropDown.eventSelectedIndexChanged += (control, index) =>
{
Translations.Index = index;
OptionsPanel.LocaleChanged();
};
}
static void Main(string[] args)
{
var app = new Program();
FFImageLoading.Forms.Platform.CachedImageRenderer.Init(app);
UIControls.Init();
Forms.Init(app);
app.Run(args);
}
// Singleton initialization
private void Awake()
{
if (!Instance)
{
uiControls = this;
}
else if (this != Instance)
{
Destroy(this.gameObject);
}
}
public GameObject createUIImage(GameObject parent, Sprite BgSprite)
{
UIControls.Resources uiResources = new UIControls.Resources();
uiResources.background = BgSprite;
log.LogMessage(" Creating UI Image");
GameObject uiImage = UIControls.CreateImage(uiResources);
uiImage.transform.SetParent(parent.transform, false);
return(uiImage);
}
/// <summary>
/// Adds a title label across the top of the specified UIComponent.
/// </summary>
/// <param name="parent">Parent component</param>
/// <param name="titleKey">Title translation key</param>
/// <returns>Y position below title</returns>
private float TitleLabel(UIComponent parent, string titleKey)
{
// Add title.
UILabel titleLabel = UIControls.AddLabel(parent, 0f, Margin, Translations.Translate(titleKey), parent.width, 1.5f);
titleLabel.textAlignment = UIHorizontalAlignment.Center;
titleLabel.font = Resources.FindObjectsOfTypeAll <UIFont>().FirstOrDefault((UIFont f) => f.name == "OpenSans-Semibold");
UIControls.OptionsSpacer(parent, Margin, titleLabel.height + (Margin * 2f), parent.width - (Margin * 2f));
return(Margin + titleLabel.height + Margin + 5f + Margin);
}
// Use this for initialization
void Start()
{
roomImage.sprite = roomIcon[imageNumber];
roomName.text = roomPrefab[imageNumber].name;
description.text = showDescriptiontext();
ui = GameObject.FindGameObjectWithTag("GameController").GetComponent <UIControls>();
source = GetComponent <AudioSource>();
source.PlayOneShot(clips[imageNumber]);
}
public GameObject createUIButton(GameObject parent, Sprite NewSprite)
{
UIControls.Resources uiResources = new UIControls.Resources();
uiResources.standard = NewSprite;
log.LogMessage(" Creating UI Button");
GameObject uiButton = UIControls.CreateButton(uiResources);
uiButton.transform.SetParent(parent.transform, false);
return(uiButton);
}
public GameObject createUIScrollbar(GameObject parent, Sprite ScrollbarSprite)
{
UIControls.Resources uiResources = new UIControls.Resources();
uiResources.background = ScrollbarSprite;
log.LogMessage(" Creating UI Scrollbar");
GameObject uiScrollbar = UIControls.CreateScrollbar(uiResources);
uiScrollbar.transform.SetParent(parent.transform, false);
return(uiScrollbar);
}
static void Main(string[] args)
{
var app = new Program();
var option = new InitializationOptions(app)
{
DisplayResolutionUnit = DisplayResolutionUnit.Pixel()
};
Forms.Init(option);
// UIControls.Init() should be called after Forms.Init()
UIControls.Init(new InitOptions(app));
FFImageLoading.Forms.Platform.CachedImageRenderer.Init(app);
app.Run(args);
}
public GameObject createUIToggle(GameObject parent, Sprite BgSprite, Sprite customCheckmarkSprite)
{
UIControls.Resources uiResources = new UIControls.Resources();
uiResources.standard = BgSprite;
uiResources.checkmark = customCheckmarkSprite;
log.LogMessage(" Creating UI Toggle");
GameObject uiToggle = UIControls.CreateToggle(uiResources);
uiToggle.transform.SetParent(parent.transform, false);
return(uiToggle);
}
public GameObject createUISlider(GameObject parent, Sprite BgSprite, Sprite FillSprite, Sprite KnobSprite)
{
UIControls.Resources uiResources = new UIControls.Resources();
uiResources.background = BgSprite;
uiResources.standard = FillSprite;
uiResources.knob = KnobSprite;
log.LogMessage(" Creating UI Slider");
GameObject uiSlider = UIControls.CreateSlider(uiResources);
uiSlider.transform.SetParent(parent.transform, false);
return(uiSlider);
}
public RoutesInfoHandler(List <PlanetInfo> planetInfoCSList, pgMissionCalculator parent, CheckBox chkReturn)
{
this.planetInfoCSList = planetInfoCSList;
this.parent = parent;
this.chkReturn = chkReturn;
dblDVBudget = 0;
dblTravelTime = 0;
grdRouteInfo = UIControls.grdPInit(1);
viewer = UIControls.viewerInit();
//viewer.MaxWidth = 500;
viewer.Content = grdRouteInfo;
viewer.SetValue(Grid.RowProperty, 3);
viewer.SetValue(Grid.ColumnProperty, 1);
parent.grdMain.Children.Add(viewer);
}
// Use this for initialization
void Start()
{
uiControls = GameObject.FindGameObjectWithTag("GameController").GetComponent <UIControls>();
icon.sprite = flippyObject.aSprite;
startPosition = GameObject.FindGameObjectWithTag("StartPoint").transform;
if (PlayerPrefs.GetInt(flippyObject.objectName) == 1)
{
objectIsUnlock = true;
}
if (objectIsUnlock)
{
lockIcon.gameObject.SetActive(false);
}
}
static void Main(string[] args)
{
var app = new Program();
try
{
UIControls.Init();
UIControls.MainWindowProvider = () => app.MainWindow;
Forms.Init(app);
app.Run(args);
}
catch (Exception e)
{
System.Console.WriteLine($"Exception : {e.Message}");
}
}
private void Reset()
{
try
{
dblDVBudget = 0;
dblTravelTime = 0;
parent.txtDVBudget.Text = "";
parent.txtTotaTime.Text = "";
viewer.Content = null;
grdRouteInfo = UIControls.grdPInit(1);
viewer.Content = grdRouteInfo;
}
catch (Exception)
{
throw;
}
}
private DropDownList GetZoneList(System.Web.UI.Page page)
{
if (page == null)
{
throw new ArgumentNullException("page");
}
var wpm = WebPartManager.GetCurrentWebPartManager(page) as WebPartManager;
var zoneList = UIControls.CreateZoneList();
foreach (WebPartZone wpZone in wpm.Zones)
{
zoneList.Items.Add(new ListItem(wpZone.ID));
}
return(zoneList);
}
public PlaneInfoHandler(pgMissionCalculator parent, List <Brush> foregroundList)
{
this.foregroundList = foregroundList;
this.parent = parent;
this.currentPlanetList = IO.objList;
planetInfoCSList.Clear();
grdPlanetInfo = UIControls.grdPInit(1);
vrPI = UIControls.viewerInit();
vrPI.Name = "vrPI";
vrPI.MaxHeight = 570;
vrPI.Content = grdPlanetInfo;
vrPI.ScrollChanged += ScrollChanged;
vrPI.SetValue(Grid.RowProperty, 1);
vrPI.SetValue(Grid.ColumnProperty, 3);
parent.pnlDown.Children.Add(vrPI);
StackPanel pnlMainControls = UIControls.pnlInit(Orientation.Vertical);
grdPlanetSelection = UIControls.grdPInit(1);
vrPS = UIControls.viewerInit();
vrPS.Content = grdPlanetSelection;
vrPS.Name = "vrPS";
vrPS.MaxHeight = 570;
vrPS.ScrollChanged += ScrollChanged;
btnAddPI = btnAddInit();
btnRemovePI = btnRemovedInit();
StackPanel pnlBtns = UIControls.pnlInit(Orientation.Horizontal);
pnlBtns.HorizontalAlignment = HorizontalAlignment.Right;
pnlBtns.VerticalAlignment = VerticalAlignment.Top;
pnlBtns.Margin = new Thickness(0, 5, 0, 0);
pnlBtns.Background = new SolidColorBrush {
Color = Color.FromRgb(5, 47, 60), Opacity = 0.5
};
pnlBtns.Children.Add(btnAddPI);
pnlBtns.Children.Add(btnRemovePI);
pnlBtns.SetValue(Grid.RowProperty, 0);
pnlBtns.SetValue(Grid.ColumnProperty, 0);
pnlMainControls.Children.Add(vrPS);
parent.grdTop.Children.Add(pnlBtns);
parent.pnlDownLeft.Children.Add(pnlMainControls);
planetInfoCSList.Add(new PlanetInfo(RowCounter + 1, grdPlanetInfo, grdPlanetSelection, foregroundList[RowCounter], this));
routesInfo = new RoutesInfoHandler(planetInfoCSList, parent, planetInfoCSList[0].chkReturn);
}
// Internals //////////////////////////////////////////////////////
private DropDownList GetPortletList(System.Web.UI.Page page)
{
if (page == null)
{
throw new ArgumentNullException("page");
}
var wpm = WebPartManager.GetCurrentWebPartManager(page) as WebPartManager;
var portletList = UIControls.CreatePortletList();
foreach (WebPart wp in wpm.WebParts)
{
portletList.Items.Add(new ListItem(wp.ID));
}
return(portletList);
}
public GameObject createUIScrollView(GameObject parent, Sprite BgSprite, Sprite customMaskSprite, Sprite customScrollbarSprite)
{
UIControls.Resources uiResources = new UIControls.Resources();
// These 2 all need to be the same for some reason, I think due to scrollview automation.
uiResources.background = BgSprite;
uiResources.knob = BgSprite;
uiResources.standard = customScrollbarSprite;
uiResources.mask = customMaskSprite;
log.LogMessage(" Creating UI ScrollView");
GameObject uiScrollView = UIControls.CreateScrollView(uiResources);
uiScrollView.transform.SetParent(parent.transform, false);
return(uiScrollView);
}
public GameObject createUIText(GameObject parent, Sprite BgSprite, Il2CppSystem.String textColor)
{
UIControls.Resources uiResources = new UIControls.Resources();
uiResources.background = BgSprite;
log.LogMessage(" Creating UI Text");
GameObject uiText = UIControls.CreateText(uiResources);
uiText.transform.SetParent(parent.transform, false);
Text text = uiText.GetComponent <Text>();
//uiText.transform.GetChild(0).GetComponent<Text>().font = (Font)Resources.GetBuiltinResource(Font.Il2CppType, "Arial.ttf"); // Invalid Cast
text.color = HTMLString2Color(textColor).Unbox <Color32>();
return(uiText);
}
public void UpdateUI(UIControls UI)
{
try
{
this.Text = UI.FormTile;
this.HeadersTb.Text = UI.HeadersTab;
this.HelpTb.Text = UI.HelpTab;
this.OptionsTb.Text = UI.OptionsTab;
this.LanguageTb.Text = UI.LanguageTab;
this.SetHeadersBtn.Text = UI.SetHeadersBtn;
this.ResetHeadersBtn.Text = UI.ResetHeadersBtn;
this.LHFFBtn.Text = UI.LoadHeadersFromFileBtn;
this.EHTFBtn.Text = UI.ExportHeadersToFileBtn;
this.EHTFBtn.Text = UI.ExportHeadersToFileBtn;
this.ClearBtn.Text = UI.ClearPlayersBtn;
this.OMBtn.Text = UI.MimicBtn;
this.SetLangBtn.Text = UI.SetLangBtn;
this.LLFF.Text = UI.LoadLangFrmFileBtn;
this.AddBlckLstBtn.Text = UI.AddBlckLstBtn;
this.RemoveBlckLstBtn.Text = UI.RemoveBlckLstBtn;
this.ResetBtn.Text = UI.ResetBlckLstBtn;
this.InfoLbl.Text = UI.TMInfoLbl;
//Players label is a format you also need some sht here u fgt btch ngga
this.MOPLbl.Text = UI.MimicOtherPlayerLbl;
this.BLLbl.Text = UI.BlckLstingLbl;
this.ProgramingLbl.Text = UI.ProgrammingLbl;
this.DesignerLbl.Text = UI.DesignerLbl;
this.MPmChckBx.Text = UI.Message;
this.MSignChckbx.Text = UI.Sign;
this.MMottoChckbx.Text = UI.Motto;
this.MClothesChckbx.Text = UI.Clothes;
this.MSpeechChckbx.Text = UI.Speech;
this.MGesturesChckbx.Text = UI.Gestures;
this.MStanceChckbx.Text = UI.Stance;
this.MDancingChckbx.Text = UI.Dance;
}
catch (Exception error)
{
MessageBox.Show(error.ToString());
}
}
private void LLFF_Click(object sender, EventArgs e)
{
DialogResult DR = LoadUIFromFile.ShowDialog();
if (DR == DialogResult.OK)
{
try
{
UIControls UI = new UIControls();
UI = UI.LoadFromFile(LoadUIFromFile.FileName);
UpdateUI(UI);
}
catch (Exception error)
{
MessageBox.Show(error.ToString());
//MessageBox.Show("Error Loading UI/Language from the specified File", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
public void UpdateTrackableTravels(UIControls.Trackables.TrackableItem trackable, List<UIControls.Trackables.TravelItem> travels)
{
_settingsStorage.UpdateTrackableTravels(trackable, travels);
}
public List<UIControls.Trackables.LogItem> GetTrackableLogs(UIControls.Trackables.TrackableItem trackable)
{
return _settingsStorage.GetTrackableLogs(trackable);
}
public void UpdateTrackableLogs(UIControls.Trackables.TrackableItem trackable, List<UIControls.Trackables.LogItem> logs)
{
_settingsStorage.UpdateTrackableLogs(trackable, logs);
}
public List<UIControls.Trackables.TravelItem> GetTrackableTravels(UIControls.Trackables.TrackableItem trackable)
{
List<UIControls.Trackables.TravelItem> result = new List<UIControls.Trackables.TravelItem>();
lock (this)
{
if (_dbcon != null)
{
DbDataReader dr = _dbcon.ExecuteReader(string.Format("select GeocacheCode, lat, lon, DateLogged from trktravels where TrackableCode='{0}' order by pos", trackable.Code));
while (dr.Read())
{
UIControls.Trackables.TravelItem ti = new UIControls.Trackables.TravelItem();
ti.DateLogged = DateTime.Parse((string)dr["DateLogged"]);
ti.GeocacheCode = (string)dr["GeocacheCode"];
ti.Lat = (double)dr["lat"];
ti.Lon = (double)dr["lon"];
result.Add(ti);
}
}
}
return result;
}
// The only reason this doesn't directly do the switch is to keep the uniformity of foreign events
void button_Button_MouseDown(UIControls.ButtonType ButtonType)
{
ButtonEvent_MouseDown(ButtonType);
}
public List<UIControls.Trackables.TrackableItem> GetTrackables(UIControls.Trackables.TrackableGroup grp)
{
return _settingsStorage.GetTrackables(grp);
}
private void ButtonSelect_MouseDown(UIControls.ButtonType buttonType)
{
switch (buttonType)
{
case UIControls.ButtonType.SelectAll:
PicturePanelMain.SetSelection(true);
break;
case UIControls.ButtonType.SelectNone:
PicturePanelMain.SetSelection(false);
break;
}
}
public void AddUpdateTrackable(UIControls.Trackables.TrackableGroup grp, UIControls.Trackables.TrackableItem trackable)
{
lock (this)
{
if (_dbcon != null)
{
try
{
UIControls.Trackables.TrackableItem t = trackable;
DbParameter par;
if (!string.IsNullOrEmpty(trackable.IconUrl) && trackable.IconData != null)
{
long cnt = (long)_dbcon.ExecuteScalar(string.Format("select count(1) from trkimages where url='{0}'", t.IconUrl));
if (cnt == 0)
{
_dbcon.Command.Parameters.Clear();
par = _dbcon.Command.CreateParameter();
par.ParameterName = "@data";
par.DbType = DbType.Binary;
par.Value = trackable.IconData;
_dbcon.Command.Parameters.Add(par);
_dbcon.ExecuteNonQuery(string.Format("insert into trkimages (url, imagedata) values ('{0}', @data)", t.IconUrl));
_dbcon.Command.Parameters.Clear();
}
}
_dbcon.Command.Parameters.Clear();
par = _dbcon.Command.CreateParameter();
par.ParameterName = "@groupid";
par.DbType = DbType.Int32;
par.Value = grp.ID;
_dbcon.Command.Parameters.Add(par);
par = _dbcon.Command.CreateParameter();
par.ParameterName = "@AllowedToBeCollected";
par.DbType = DbType.Int32;
if (t.AllowedToBeCollected == null)
{
par.Value = DBNull.Value;
}
else
{
par.Value = t.AllowedToBeCollected == true ? 1 : 0;
}
_dbcon.Command.Parameters.Add(par);
par = _dbcon.Command.CreateParameter();
par.ParameterName = "@Archived";
par.DbType = DbType.Int32;
par.Value = t.Archived ? 1 : 0;
_dbcon.Command.Parameters.Add(par);
par = _dbcon.Command.CreateParameter();
par.ParameterName = "@BugTypeID";
par.DbType = DbType.Int32;
par.Value = t.BugTypeID;
_dbcon.Command.Parameters.Add(par);
par = _dbcon.Command.CreateParameter();
par.ParameterName = "@Code";
par.DbType = DbType.String;
par.Value = t.Code;
_dbcon.Command.Parameters.Add(par);
par = _dbcon.Command.CreateParameter();
par.ParameterName = "@CurrentGeocacheCode";
par.DbType = DbType.String;
par.Value = t.CurrentGeocacheCode ?? "";
_dbcon.Command.Parameters.Add(par);
par = _dbcon.Command.CreateParameter();
par.ParameterName = "@CurrentGoal";
par.DbType = DbType.String;
par.Value = t.CurrentGoal ?? "";
_dbcon.Command.Parameters.Add(par);
par = _dbcon.Command.CreateParameter();
par.ParameterName = "@DateCreated";
par.DbType = DbType.String;
par.Value = t.DateCreated.ToString("u");
_dbcon.Command.Parameters.Add(par);
par = _dbcon.Command.CreateParameter();
par.ParameterName = "@Description";
par.DbType = DbType.String;
par.Value = t.Description ?? "";
_dbcon.Command.Parameters.Add(par);
par = _dbcon.Command.CreateParameter();
par.ParameterName = "@IconUrl";
par.DbType = DbType.String;
par.Value = t.IconUrl ?? "";
_dbcon.Command.Parameters.Add(par);
par = _dbcon.Command.CreateParameter();
par.ParameterName = "@Id";
par.DbType = DbType.Int32;
par.Value = t.Id;
_dbcon.Command.Parameters.Add(par);
par = _dbcon.Command.CreateParameter();
par.ParameterName = "@InCollection";
par.DbType = DbType.Int32;
par.Value = t.InCollection ? 1 : 0;
_dbcon.Command.Parameters.Add(par);
par = _dbcon.Command.CreateParameter();
par.ParameterName = "@Name";
par.DbType = DbType.String;
par.Value = t.Name ?? "";
_dbcon.Command.Parameters.Add(par);
par = _dbcon.Command.CreateParameter();
par.ParameterName = "@TBTypeName";
par.DbType = DbType.String;
par.Value = t.TBTypeName ?? "";
_dbcon.Command.Parameters.Add(par);
par = _dbcon.Command.CreateParameter();
par.ParameterName = "@Url";
par.DbType = DbType.String;
par.Value = t.Url ?? "";
_dbcon.Command.Parameters.Add(par);
par = _dbcon.Command.CreateParameter();
par.ParameterName = "@WptTypeID";
par.DbType = DbType.Int32;
par.Value = t.WptTypeID;
_dbcon.Command.Parameters.Add(par);
par = _dbcon.Command.CreateParameter();
par.ParameterName = "@Owner";
par.DbType = DbType.String;
par.Value = t.Owner ?? "";
_dbcon.Command.Parameters.Add(par);
if (_dbcon.ExecuteNonQuery("update trktrackables set AllowedToBeCollected=@AllowedToBeCollected, Archived=@Archived, BugTypeID=@BugTypeID, CurrentGeocacheCode=@CurrentGeocacheCode, CurrentGoal=@CurrentGoal, DateCreated=@DateCreated, Description=@Description, IconUrl=@IconUrl, Id=@Id, InCollection=@InCollection, Name=@Name, TBTypeName=@TBTypeName, Url=@Url, WptTypeID=@WptTypeID, Owner=@Owner where groupid=@groupid and Code=@Code") == 0)
{
_dbcon.ExecuteNonQuery("insert into trktrackables (groupid, AllowedToBeCollected, Archived, BugTypeID, Code, CurrentGeocacheCode, CurrentGoal, DateCreated, Description, IconUrl, Id, InCollection, Name, TBTypeName, Url, WptTypeID, Owner) values (@groupid, @AllowedToBeCollected, @Archived, @BugTypeID, @Code, @CurrentGeocacheCode, @CurrentGoal, @DateCreated, @Description, @IconUrl, @Id, @InCollection, @Name, @TBTypeName, @Url, @WptTypeID, @Owner)");
}
_dbcon.Command.Parameters.Clear();
}
finally
{
_dbcon.Command.Parameters.Clear();
}
}
}
}
public void DeleteTrackable(UIControls.Trackables.TrackableGroup grp, UIControls.Trackables.TrackableItem trackable)
{
lock (this)
{
if (_dbcon != null)
{
_dbcon.ExecuteNonQuery(string.Format("delete from trktrackables where groupid={0} and Code='{1}'", grp.ID, trackable.Code));
if ((long)_dbcon.ExecuteScalar(string.Format("select count(1) from trktrackables", trackable.Code)) == 0)
{
_dbcon.ExecuteNonQuery(string.Format("delete from trktravels where TrackableCode='{0}'", trackable.Code));
_dbcon.ExecuteNonQuery(string.Format("delete from trklogs where TrackableCode='{0}'", trackable.Code));
}
}
}
}
public void DeleteTrackable(UIControls.Trackables.TrackableGroup grp, UIControls.Trackables.TrackableItem trackable)
{
_settingsStorage.DeleteTrackable(grp, trackable);
}
public List<UIControls.Trackables.LogItem> GetTrackableLogs(UIControls.Trackables.TrackableItem trackable)
{
List<UIControls.Trackables.LogItem> result = new List<UIControls.Trackables.LogItem>();
lock (this)
{
if (_dbcon != null)
{
Core.ApplicationData.Instance.Logger.AddLog(this, Logger.Level.Error, "GetTrackableLogs not implemented!");
}
}
return result;
}
public void UpdateTrackableLogs(UIControls.Trackables.TrackableItem trackable, List<UIControls.Trackables.LogItem> logs)
{
lock (this)
{
if (_dbcon != null)
{
try
{
List<int> logsIndb = new List<int>();
DbDataReader dr = _dbcon.ExecuteReader(string.Format("select ID from trklogs where TrackableCode='{0}'", trackable.Code));
while (dr.Read())
{
logsIndb.Add((int)dr["ID"]);
}
DbParameter par;
_dbcon.Command.Parameters.Clear();
par = _dbcon.Command.CreateParameter();
par.ParameterName = "@TrackableCode";
par.DbType = DbType.String;
_dbcon.Command.Parameters.Add(par);
par = _dbcon.Command.CreateParameter();
par.ParameterName = "@ID";
par.DbType = DbType.Int32;
_dbcon.Command.Parameters.Add(par);
par = _dbcon.Command.CreateParameter();
par.ParameterName = "@LogCode";
par.DbType = DbType.String;
_dbcon.Command.Parameters.Add(par);
par = _dbcon.Command.CreateParameter();
par.ParameterName = "@GeocacheCode";
par.DbType = DbType.String;
_dbcon.Command.Parameters.Add(par);
par = _dbcon.Command.CreateParameter();
par.ParameterName = "@IsArchived";
par.DbType = DbType.Int32;
_dbcon.Command.Parameters.Add(par);
par = _dbcon.Command.CreateParameter();
par.ParameterName = "@LoggedBy";
par.DbType = DbType.String;
_dbcon.Command.Parameters.Add(par);
par = _dbcon.Command.CreateParameter();
par.ParameterName = "@LogGuid";
par.DbType = DbType.String;
_dbcon.Command.Parameters.Add(par);
par = _dbcon.Command.CreateParameter();
par.ParameterName = "@LogText";
par.DbType = DbType.String;
_dbcon.Command.Parameters.Add(par);
par = _dbcon.Command.CreateParameter();
par.ParameterName = "@LogIsEncoded";
par.DbType = DbType.Int32;
_dbcon.Command.Parameters.Add(par);
par = _dbcon.Command.CreateParameter();
par.ParameterName = "@WptLogTypeId";
par.DbType = DbType.Int32;
_dbcon.Command.Parameters.Add(par);
par = _dbcon.Command.CreateParameter();
par.ParameterName = "@Url";
par.DbType = DbType.String;
_dbcon.Command.Parameters.Add(par);
par = _dbcon.Command.CreateParameter();
par.ParameterName = "@UTCCreateDate";
par.DbType = DbType.String;
_dbcon.Command.Parameters.Add(par);
par = _dbcon.Command.CreateParameter();
par.ParameterName = "@VisitDate";
par.DbType = DbType.String;
_dbcon.Command.Parameters.Add(par);
int HopCount = 0;
int DiscoverCount = 0;
int InCacheCount = 0;
for (int i = 0; i < logs.Count; i++)
{
_dbcon.Command.Parameters["@TrackableCode"].Value = logs[i].TrackableCode;
_dbcon.Command.Parameters["@ID"].Value = logs[i].ID;
_dbcon.Command.Parameters["@LogCode"].Value = logs[i].LogCode;
_dbcon.Command.Parameters["@GeocacheCode"].Value = logs[i].GeocacheCode ?? "";
_dbcon.Command.Parameters["@LogIsEncoded"].Value = logs[i].LogIsEncoded ? 1 : 0;
_dbcon.Command.Parameters["@IsArchived"].Value = logs[i].IsArchived ? 1 : 0;
_dbcon.Command.Parameters["@LoggedBy"].Value = logs[i].LoggedBy ?? "";
_dbcon.Command.Parameters["@LogGuid"].Value = logs[i].LogGuid ?? "";
_dbcon.Command.Parameters["@LogText"].Value = logs[i].LogText ?? "";
_dbcon.Command.Parameters["@WptLogTypeId"].Value = logs[i].WptLogTypeId;
_dbcon.Command.Parameters["@Url"].Value = logs[i].Url ?? "";
_dbcon.Command.Parameters["@UTCCreateDate"].Value = logs[i].UTCCreateDate.ToString("u");
_dbcon.Command.Parameters["@VisitDate"].Value = logs[i].VisitDate.ToString("u");
if (logsIndb.Contains(logs[i].ID))
{
//for performance reasons, do not update. Assume nothing changed
//_dbcon.ExecuteNonQuery("update logs....");
logsIndb.Remove(logs[i].ID);
}
else
{
_dbcon.ExecuteNonQuery("insert into trklogs (TrackableCode, ID, LogCode, GeocacheCode, IsArchived, LoggedBy, LogGuid, LogIsEncoded, LogText, WptLogTypeId, Url, UTCCreateDate, VisitDate) values (@TrackableCode, @ID, @LogCode, @GeocacheCode, @IsArchived, @LoggedBy, @LogGuid, @LogIsEncoded, @LogText, @WptLogTypeId, @Url, @UTCCreateDate, @VisitDate)");
}
switch (logs[i].WptLogTypeId)
{
case 75: //visit
HopCount++;
break;
case 14: //dropped
HopCount++;
InCacheCount++;
break;
case 48: //disc
DiscoverCount++;
break;
}
}
_dbcon.ExecuteNonQuery(string.Format("update trktrackables set HopCount={0}, InCacheCount={1}, DiscoverCount={2} where Code='{3}'", HopCount, InCacheCount, DiscoverCount, trackable.Code));
foreach (int id in logsIndb)
{
_dbcon.ExecuteNonQuery(string.Format("delete from trklogs where ID={0}", id));
}
_dbcon.Command.Parameters.Clear();
}
finally
{
_dbcon.Command.Parameters.Clear();
}
}
}
}
public void AddTrackableGroup(UIControls.Trackables.TrackableGroup grp)
{
lock (this)
{
if (_dbcon != null)
{
if ((long)_dbcon.ExecuteScalar(string.Format("select count(1) from trkgroups where id={0}", grp.ID)) == 0)
{
_dbcon.ExecuteNonQuery(string.Format("insert into trkgroups (id, name) values ({0}, '{1}')", grp.ID, grp.Name.Replace("'", "''")));
}
}
}
}
private void ButtonEvent_MouseDown(UIControls.ButtonType buttonType)
{
switch (buttonType)
{
case UIControls.ButtonType.Import:
ButtonImport_MouseDown();
break;
case UIControls.ButtonType.Save:
ButtonSave_MouseDown();
break;
case UIControls.ButtonType.Discard:
ButtonDiscard_MouseDown();
break;
case UIControls.ButtonType.SelectAll:
case UIControls.ButtonType.SelectNone:
ButtonSelect_MouseDown(buttonType);
break;
case UIControls.ButtonType.Posted:
case UIControls.ButtonType.NotPosted:
ButtonUpdateGalleryStatus_MouseDown(buttonType);
break;
case UIControls.ButtonType.Dropbox:
ButtonDropbox_MouseDown();
break;
}
}
public void DeleteTrackableGroup(UIControls.Trackables.TrackableGroup grp)
{
_settingsStorage.DeleteTrackableGroup(grp);
}
private void ButtonUpdateGalleryStatus_MouseDown(UIControls.ButtonType buttonType)
{
_processor.SetGalleryStatus(_selectedGallery, buttonType == UIControls.ButtonType.Posted);
_processor.RefreshGallery(_selectedGallery);
PicturePanelMain.SetGalleryStatus(buttonType == UIControls.ButtonType.Posted);
}
public void SetFeatureControl(UIControls.UIControlContainer container, string setting, string defaultFeature)
{
if (setting == null)
{
setting = defaultFeature;
}
if (!string.IsNullOrEmpty(setting))
{
Type t = Type.GetType(setting);
if (t != null)
{
ConstructorInfo constructor = t.GetConstructor(Type.EmptyTypes);
UserControl uc = (UserControl)constructor.Invoke(Type.EmptyTypes);
container.FeatureControl = uc;
}
}
}
public void DeleteTrackableGroup(UIControls.Trackables.TrackableGroup grp)
{
lock(this)
{
if (_dbcon != null)
{
List<UIControls.Trackables.TrackableItem> trbls = GetTrackables(grp);
foreach(var t in trbls)
{
DeleteTrackable(grp, t);
}
_dbcon.ExecuteNonQuery(string.Format("delete from trkgroups where id={0}", grp.ID));
}
}
}
public void UpdateTrackableTravels(UIControls.Trackables.TrackableItem trackable, List<UIControls.Trackables.TravelItem> travels)
{
lock (this)
{
if (_dbcon != null)
{
try
{
_dbcon.ExecuteNonQuery(string.Format("delete from trktravels where TrackableCode='{0}'", trackable.Code));
DbParameter par;
_dbcon.Command.Parameters.Clear();
par = _dbcon.Command.CreateParameter();
par.ParameterName = "@pos";
par.DbType = DbType.Int32;
_dbcon.Command.Parameters.Add(par);
par = _dbcon.Command.CreateParameter();
par.ParameterName = "@TrackableCode";
par.DbType = DbType.String;
_dbcon.Command.Parameters.Add(par);
par = _dbcon.Command.CreateParameter();
par.ParameterName = "@GeocacheCode";
par.DbType = DbType.String;
_dbcon.Command.Parameters.Add(par);
par = _dbcon.Command.CreateParameter();
par.ParameterName = "@lat";
par.DbType = DbType.Double;
_dbcon.Command.Parameters.Add(par);
par = _dbcon.Command.CreateParameter();
par.ParameterName = "@lon";
par.DbType = DbType.Double;
_dbcon.Command.Parameters.Add(par);
par = _dbcon.Command.CreateParameter();
par.ParameterName = "@DateLogged";
par.DbType = DbType.String;
_dbcon.Command.Parameters.Add(par);
double DistanceKm = 0.0;
double? LastLat = null;
double? LastLon = null;
for (int i = 0; i < travels.Count; i++)
{
_dbcon.Command.Parameters["@pos"].Value = i;
_dbcon.Command.Parameters["@TrackableCode"].Value = travels[i].TrackableCode;
_dbcon.Command.Parameters["@GeocacheCode"].Value = travels[i].GeocacheCode ?? "";
_dbcon.Command.Parameters["@lat"].Value = travels[i].Lat;
_dbcon.Command.Parameters["@lon"].Value = travels[i].Lon;
_dbcon.Command.Parameters["@DateLogged"].Value = travels[i].DateLogged.ToString("u");
_dbcon.ExecuteNonQuery("insert into trktravels (pos, TrackableCode, GeocacheCode, lat, lon, DateLogged) values (@pos, @TrackableCode, @GeocacheCode, @lat, @lon, @DateLogged)");
LastLat = travels[i].Lat;
LastLon = travels[i].Lon;
if (i > 0)
{
DistanceKm += (double)Utils.Calculus.CalculateDistance(travels[i - 1].Lat, travels[i - 1].Lon, travels[i].Lat, travels[i].Lon).EllipsoidalDistance / 1000.0;
}
}
_dbcon.Command.Parameters.Clear();
if (LastLat != null && LastLon != null)
{
_dbcon.ExecuteNonQuery(string.Format("update trktrackables set DistanceKm={0}, Lat={2}, Lon={3} where Code='{1}'", DistanceKm.ToString().Replace(',', '.'), trackable.Code, LastLat.ToString().Replace(',', '.'), LastLon.ToString().Replace(',', '.')));
}
}
finally
{
_dbcon.Command.Parameters.Clear();
}
}
}
}
public List<UIControls.Trackables.TrackableItem> GetTrackables(UIControls.Trackables.TrackableGroup grp)
{
List<UIControls.Trackables.TrackableItem> result = new List<UIControls.Trackables.TrackableItem>();
lock (this)
{
if (_dbcon != null)
{
DbDataReader dr = _dbcon.ExecuteReader(string.Format("select * from trktrackables where groupid={0}", grp.ID));
while (dr.Read())
{
UIControls.Trackables.TrackableItem trk = new UIControls.Trackables.TrackableItem();
trk.Code = (string)dr["Code"];
if (dr["AllowedToBeCollected"] != null && dr["AllowedToBeCollected"].GetType() != typeof(DBNull))
{
trk.AllowedToBeCollected = (int)dr["AllowedToBeCollected"] != 0;
}
else
{
trk.AllowedToBeCollected = null;
}
trk.Archived = (int)dr["Archived"] != 0;
trk.BugTypeID = (int)dr["BugTypeID"];
trk.CurrentGeocacheCode = (string)dr["CurrentGeocacheCode"];
trk.CurrentGoal = (string)dr["CurrentGoal"];
trk.DateCreated = DateTime.Parse((string)dr["DateCreated"]);
trk.Description = (string)dr["Description"];
trk.IconUrl = (string)dr["IconUrl"];
trk.Id = (int)dr["Id"];
trk.InCollection = (int)dr["InCollection"] != 0;
trk.Name = (string)dr["Name"];
trk.TBTypeName = (string)dr["TBTypeName"];
trk.Url = (string)dr["Url"];
trk.WptTypeID = (int)dr["WptTypeID"];
trk.Owner = (string)dr["Owner"];
if (dr["HopCount"] != null && dr["HopCount"].GetType() != typeof(DBNull))
{
trk.HopCount = (int)dr["HopCount"];
}
else
{
trk.HopCount = 0;
}
if (dr["DiscoverCount"] != null && dr["DiscoverCount"].GetType() != typeof(DBNull))
{
trk.DiscoverCount = (int)dr["DiscoverCount"];
}
else
{
trk.DiscoverCount = 0;
}
if (dr["InCacheCount"] != null && dr["InCacheCount"].GetType() != typeof(DBNull))
{
trk.InCacheCount = (int)dr["InCacheCount"];
}
else
{
trk.InCacheCount = 0;
}
if (dr["DistanceKm"] != null && dr["DistanceKm"].GetType() != typeof(DBNull))
{
trk.DistanceKm = (double)dr["DistanceKm"];
}
else
{
trk.DistanceKm = 0.0;
}
if (dr["Lat"] != null && dr["Lat"].GetType() != typeof(DBNull))
{
trk.Lat = (double)dr["Lat"];
}
else
{
trk.Lat = null;
}
if (dr["Lon"] != null && dr["Lon"].GetType() != typeof(DBNull))
{
trk.Lon = (double)dr["Lon"];
}
else
{
trk.Lon = null;
}
result.Add(trk);
}
foreach(var t in result)
{
t.IconData = _dbcon.ExecuteScalar(string.Format("select imagedata from trkimages where url='{0}'", t.IconUrl ?? "")) as byte[];
}
}
}
return result;
}
public void AddTrackableGroup(UIControls.Trackables.TrackableGroup grp)
{
_settingsStorage.AddTrackableGroup(grp);
}
