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

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

		connect objconn = new connect();

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


		public void create_user_db(String name)
		{
			try
			{
				string dbname = name;
				dbname +="_ticket";
				objconn.openDb();

				string query  = "CREATE TABLE " + dbname + " (	[ticket_id] [varchar](35)PRIMARY KEY CLUSTERED ,"+
															"[post_date] [varchar](15),[post_time] [varchar](15),"+
															"[description] [varchar](100),"+
															"[dept] [varchar] (15) REFERENCES department(department_name),"+
															"[category] [varchar] (15) REFERENCES category(category_name),"+
															"[sub_category] [varchar] (30) REFERENCES sub_category(sub_category_name),"+
															"[priority] [varchar](10),[assigned_to] [varchar](15),"+
															"[status] [varchar] (15),"+
															"[gname] [varchar](15) REFERENCES groups(group_name),"+
					                                        "[action_id] [varchar] (20)REFERENCES actions(action_id))";
				SqlConnection cr_conn = objconn.conn();
				cr_conn.Open();
				
				SqlCommand dbcomm = new SqlCommand(query,cr_conn);
				dbcomm.ExecuteNonQuery();
				cr_conn.Close();
	
			}

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


	}
}