using System;
using System.Data;
using System.Data.SqlClient ;

namespace Final_Project_Alpha
{
	/// <summary>
	/// Summary description for Bind_datagrid.
	/// </summary>
	public class Bind_datagrid
	{
		connect objconn = new connect();
		DataSet ds = new DataSet();
		DataSet ds2 = new DataSet();
		DataSet ds3 = new DataSet();
		DataSet ds_up = new DataSet();
		DataSet ds_rules = new DataSet();
		string ta = "admin_ticket";
		string ta2 = "News";
		string ta3 = "assetsV";

		
		public SqlDataAdapter myCommand,adapt,guest,actions,news,asset;

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

		public DataTable getDataSet(String tickets) 
		{
			
			objconn.openDb();
			myCommand = objconn.adapt_all(tickets);
			myCommand.Fill(ds,ta);
			return ds.Tables[ta];
			
		}

		public DataTable getDataSet_news(String News) 
		{
			
			objconn.openDb();
			news = objconn.adapt_news(News);
			news.Fill(ds2,ta2);
			return ds2.Tables[ta2];
			
		}

		public DataTable getDataSet_asset(String assetV) 
		{
			
			objconn.openDb();
			asset = objconn.adapt_asset(assetV);
			asset.Fill(ds3,ta3);
			return ds3.Tables[ta3];
			
		}


		public DataSet getDataSet_rules() 
		{
			objconn.openDb();
			actions = objconn.adapt_actions();
			actions.Fill(ds_rules);
			return ds_rules;
			
		}
		
		

		public void updater(string id, string status , String login)
		{

//			string login_name = login+"_ticket";
//			string tg = login_name;
//			objconn.openDb();
//
//			adapt = objconn.adapt_a();
//			guest = objconn.adapt(login);
//
//			adapt.Fill(ds,ta);
//			guest.Fill(ds,tg);
//
//			DataTable t1 = ds.Tables[ta];
//			DataTable t2 = ds.Tables[tg];
//
//			t1.PrimaryKey = new DataColumn[] {t1.Columns["ticket_id"]};
//			t2.PrimaryKey = new DataColumn[] {t2.Columns["ticket_id"]};
//
//			DataRow row = t1.Rows.Find(id);
//			DataRow row1 = t2.Rows.Find(id);
//
//			row["status"] = status;
//			row1["status"] = status;
//
//			SqlCommandBuilder cb = new SqlCommandBuilder(adapt);
//			SqlCommandBuilder cb1 = new SqlCommandBuilder(guest);
//
//			adapt.Update(ds,ta);
//			guest.Update(ds,tg);
//			

		}


		public void updater_rep(String id , String rep_id , String status)
		{

			
			objconn.openDb();

			string select = "SELECT * FROM admin_ticket where assigned_to = '" + rep_id +"'";
			adapt = objconn.adapt_all(select);
			//adapt = objconn.adapt_a();
			//guest = objconn.adapt(login);

			adapt.Fill(ds,ta);
			//guest.Fill(ds,tg);

			DataTable t1 = ds.Tables[ta];
			//DataTable t2 = ds.Tables[tg];

			t1.PrimaryKey = new DataColumn[] {t1.Columns["ticket_id"]};
			//t2.PrimaryKey = new DataColumn[] {t2.Columns["ticket_id"]};

			DataRow row = t1.Rows.Find(id);
			//DataRow row1 = t2.Rows.Find(id);

			row["status"] = status;
			//row1["status"] = status;

			SqlCommandBuilder cb = new SqlCommandBuilder(adapt);
			//SqlCommandBuilder cb1 = new SqlCommandBuilder(guest);

			adapt.Update(ds,ta);
			//guest.Update(ds,tg);

			ds.AcceptChanges();
            	

			

		}


		public void updaterz(string id , String pri ,String assg , String status)
		{
			try
			{

				//string login_name = login+"_ticket";
				//string tg = login_name;
				objconn.openDb();

				adapt = objconn.adapt_a();
				//guest = objconn.adapt(login);

				adapt.Fill(ds_up,ta);
				//guest.Fill(ds_up,tg);

				DataTable t1 = ds_up.Tables[ta];
				//DataTable t2 = ds_up.Tables[tg];

				t1.PrimaryKey = new DataColumn[] {t1.Columns["ticket_id"]};
				//t2.PrimaryKey = new DataColumn[] {t2.Columns["ticket_id"]};

				DataRow row = t1.Rows.Find(id);
				//DataRow row1 = t2.Rows.Find(id);

				row["priority"] = pri;
				row["assigned_to"] = assg;
				row["status"] = status;
//
//				row1["priority"] = pri;
//				row1["assigned_to"] = assg;
//				row1["status"] = status;

				SqlCommandBuilder cb = new SqlCommandBuilder(adapt);
				//SqlCommandBuilder cb1 = new SqlCommandBuilder(guest);

				adapt.Update(ds_up,ta);
				//guest.Update(ds_up,tg);

				ds_up.AcceptChanges();
			}


			catch(Exception ex)
			{
				Console.Write("Data Set Error: " + ex.Message ) ;
				
			}

		}

	}
}