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