public Basecamp Edit(Basecamp basecamp) { try { connection.Open(); var cmd = connection.CreateCommand() as SqlCommand; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "Basecamp_Edit"; cmd.Parameters.Add(new SqlParameter("@longitude", basecamp.Longitude)); cmd.Parameters.Add(new SqlParameter("@latitude", basecamp.Latitude)); cmd.Parameters.Add(new SqlParameter("@hpLongitude", basecamp.HotPointLong)); cmd.Parameters.Add(new SqlParameter("@hpLatitude", basecamp.HotPointLat)); cmd.Parameters.Add(new SqlParameter("@probability", basecamp.Probability)); cmd.Parameters.Add(new SqlParameter("@name", basecamp.DetailName)); cmd.Parameters.Add(new SqlParameter("@shortText", basecamp.ShortText)); cmd.Parameters.Add(new SqlParameter("@region", basecamp.RegionId)); cmd.Parameters.Add(new SqlParameter("@show", basecamp.Show)); cmd.Parameters.Add(new SqlParameter("@id", basecamp.IdDb)); cmd.ExecuteNonQuery(); connection.Close(); return(basecamp); } catch (Exception ex) { throw ex; } }
public Basecamp Insert(Basecamp basecamp) { try { connection.Open(); var cmd = connection.CreateCommand() as SqlCommand; //cmd.CommandText = "INSERT INTO BasecampDetails (BasecampId, Location, Probability, Name) values(@basecampid, geography::STPointFromText('POINT(' + CAST(@longitude AS VARCHAR(20)) + ' ' + CAST(@latitude AS VARCHAR(20)) + ')', 4326), @probability, @name) SET @ID = SCOPE_IDENTITY()"; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "Basecamp_Insert"; cmd.Parameters.Add(new SqlParameter("@basecampid", basecamp.Id)); cmd.Parameters.Add(new SqlParameter("@longitude", basecamp.Longitude)); cmd.Parameters.Add(new SqlParameter("@latitude", basecamp.Latitude)); cmd.Parameters.Add(new SqlParameter("@probability", basecamp.Probability)); cmd.Parameters.Add(new SqlParameter("@name", basecamp.DetailName)); cmd.Parameters.Add(new SqlParameter("@shortText", basecamp.ShortText)); var idParameter = new SqlParameter("@ID", SqlDbType.Int) { Direction = ParameterDirection.Output }; cmd.Parameters.Add(idParameter); cmd.ExecuteNonQuery(); //var id = (int)idParameter.Value; //basecamp.Id = id; connection.Close(); return(basecamp); } catch (Exception ex) { throw ex; } }
/// <summary> /// Constructor. /// </summary> /// <param name="camp"></param> /// <param name="node"></param> public MessageCategory(Basecamp camp, XmlNode node) : base(camp) { if (node != null) { id = node["id"].InnerText.Trim(); name = node["name"].InnerText.Trim(); } }
// Update is called once per frame void Update() { if (Input.GetMouseButtonUp(0)) { var position = Cameraer.Instance.GetMousePosition() + new Vector3(0f, 1f, 0f); var amount = Random.Range(10, 100); Basecamp.SpawnMana(position, amount); } }
/// <summary> /// /// </summary> /// <param name="camp"></param> /// <param name="node"></param> public Person(Basecamp camp, XmlNode node) : base(camp) { if (node != null) { name = string.Format("{0}, {1}", node["last-name"].InnerText.Trim(), node["first-name"].InnerText); id = node["id"].InnerText.Trim(); if (node.InnerXml.Contains("user-name")) username = node["user-name"].InnerText.Trim(); } }
/// <summary> /// /// </summary> /// <param name="camp"></param> /// <param name="node"></param> public Milestone(Basecamp camp, XmlNode node) : base(camp) { if (node != null) { title = node["title"].InnerText.Trim(); completed = (node["completed"].InnerText.Trim() == "true"); string dt = node["deadline"].InnerText.Trim(); deadline = DateTime.Parse(dt); id = node["id"].InnerText.Trim(); personID = node["responsible-party-id"].InnerText.Trim(); } }
public override void Execute(AttackArgs args, bool isEcho) { base.Execute(args, isEcho); var melee = Instantiate(args.IsPerfect ? Perfect : Regular, args.Position, args.Rotation); if (isEcho) { melee.GetComponent <AudioSource>().volume *= 0.25f; } Basecamp.Hit(); }
/// <summary> /// /// </summary> /// <param name="camp"></param> /// <param name="node"></param> public ToDoList(Basecamp camp, XmlNode node) : base(camp) { if (node != null) { name = node["name"].InnerText.Trim(); id = node["id"].InnerText.Trim(); if (node.InnerXml.Contains("<description>")) { description = node["description"].InnerText.Trim(); description = description.Replace("\n", Environment.NewLine); } } }
public override void Execute(AttackArgs args, bool isEcho) { base.Execute(args, isEcho); var projectile = Instantiate(args.IsPerfect ? Perfect : Regular, args.Position, args.Rotation); if (isEcho) { projectile.GetComponent <AudioSource>().volume *= 0.25f; } projectile.Speed *= args.Multiplier; Basecamp.Shoot(); }
public HttpResponseMessage <Basecamp> Post(Basecamp basecamp, HttpRequestMessage <Basecamp> request) { if (basecamp != null) { var basecampDb = basecampRepository.Insert(basecamp); var response = new HttpResponseMessage <Basecamp>(basecampDb) { StatusCode = HttpStatusCode.Created }; return(response); } return(new HttpResponseMessage <Basecamp>(null) { StatusCode = HttpStatusCode.NotFound, }); }
public HttpResponseMessage Recalculate(Basecamp basecamp, HttpRequestMessage <Basecamp> request) { try { if (basecamp.Id != 0) { basecampRepository.RecalculateDistance(basecamp.Id, false); } else { basecampRepository.RecalculateDistance(basecamp.RegionId, true); } return(new HttpResponseMessage { StatusCode = HttpStatusCode.OK }); } catch { return(new HttpResponseMessage { StatusCode = HttpStatusCode.InternalServerError }); } }
private void ShowLogin() { LoginForm form = new LoginForm(); Hide(); if (form.ShowDialog(this) == DialogResult.OK) { ListenForWebEvents(false); Show(); tabs.Visible = true; projects.Visible = true; Basecamp = form.BasecampObject; ListenForWebEvents(true); List<Project> p = new List<Project>(Basecamp.Projects.Values); projects.Items.AddRange(p.ToArray()); if (projects.Items.Count > 0) projects.SelectedIndex = 0; toDoListControl1.ItemEdit += new EventHandler<ToDoListEventArgs>(toDoListControl1_ItemEdit); } else { this.Close(); } }
/// <summary> /// /// </summary> /// <param name="camp"></param> public Person(Basecamp camp) : this(camp, null) { }