using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using eInfoDesigns.dbProvider.MySqlClient;

namespace typesproject
{
	/// <summary>
	/// Summary description for schedule1.
	/// </summary>
	public class schedule1 : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.Button btnSchedule;
		protected System.Web.UI.WebControls.Label lblAverageRankingTitle;
		protected System.Web.UI.WebControls.Label lblJob;
		protected System.Web.UI.WebControls.Label lblTitle;
		protected System.Web.UI.WebControls.Label lblAvgRanking;
		protected System.Web.UI.WebControls.Label lblHelp;
		protected System.Web.UI.WebControls.TextBox txtJob;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			int avg=0;

			string hero = (String) Session["hero"];
			lblTitle.Text = hero;
			string sql = String.Format("select avg(ranking) from herojobs where name='{0}'", hero);
			string cnstr = "server=localhost;uid=;pwd=;database=csharpvqs;";
			MySqlConnection cn = new MySqlConnection(cnstr);
			cn.Open();
			MySqlCommand cmd = new MySqlCommand(sql, cn);
			object result = cmd.ExecuteScalar();
			if (result != null)
				avg = (int) (Double) result;
			lblAvgRanking.Text = avg.ToString();		}

		#region Web Form Designer generated code
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: This call is required by the ASP.NET Web Form Designer.
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// Required method for Designer support - do not modify
		/// the contents of this method with the code editor.
		/// </summary>
		private void InitializeComponent()
		{    
			this.btnSchedule.Click += new System.EventHandler(this.btnSchedule_Click);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void btnSchedule_Click(object sender, System.EventArgs e)
		{
			string hero = (String) Session["hero"];
			string job = this.txtJob.Text;
			string sql = String.Format("insert into herojobs (Name, Job) values('{0}','{1}')", hero, job);
			string cnstr = "server=localhost;uid=;pwd=;database=csharpvqs;";
			
			MySqlConnection cn = new MySqlConnection(cnstr);
			cn.Open();

			MySqlCommand cmd = new MySqlCommand(sql, cn);
			cmd.ExecuteNonQuery();

			Response.Redirect("mainmenu.aspx");
		}
	}
}
