using System;
using System.Data;
using System.Data.SqlClient ;
using System.Web.Mail;

namespace Final_Project_Alpha
{
	/// <summary>
	/// Summary description for escalation.
	/// </summary>
	public class escalation
	{

		sends_mail objmail = new sends_mail();
		connect objconn = new connect();
		DataSet ds_email = new DataSet();

		public escalation()
		{
			//
			// TODO: Add constructor logic here
			//
		}

//
		public void escalate()
		{


			objconn.openDb();			
			string email_select = "select ticket_id,status,groups.group_name,groups.email"+
									" from admin_ticket,groups"+
									" where status = 'un-resolved' AND admin_ticket.gname = groups.group_name";

			SqlDataAdapter email = objconn.adapt_all(email_select);
			SqlCommandBuilder cb_email = new SqlCommandBuilder(email);
			email.Fill(ds_email);
			DataRow r = ds_email.Tables[0].Rows[0];

			string str_email = r["email"].ToString();


		}
	}
}