// Use this for initialization
 void Awake()
 {
     score = 0;
     scoreEditor = 0;
     scorePanel = GetComponent<Text>();
     server = GameObject.FindGameObjectWithTag("Server").GetComponent<Connect>();
 }

 /// <summary>
 /// This method fetches the list of branches from the database.
 /// </summary>
 /// <returns>It returns a data set containing the list of branches.</returns>
 public static DataSet GetAllBranches()
 {
     sql = "SELECT * FROM Branches";
     Connect.ConnectTT();
     c = new Connect(sql);
     return c.ds;
 }

    public override void erlReceive(Connect connect, ErlKVMessage message)
    {
        if (!MiniConnectManager.IsRobot )
        {
            try
            {

               // Log.debug("===============this is socketReceive! cmd=" + message.Cmd + " jsonString " + message.toJsonString(),true);
            }
            catch (Exception exception)
            {
                //Log.debug(" =================== : " + exception.ToString(),true);
            }
        }
        string cmd = message.Cmd;
        switch (cmd)
        {
            case "r_ok":
            case "r_err":
            {
                int port = message.getPort();
                ErlEntry entry = this.removeReciveFun(port);
                if ((entry == null) || (entry.receiveFun == null))
                {
                    return;
                }
                entry.receiveFun(connect, message);
                break;
            }
            default:
                message.addValue("cmd", new ErlString(cmd));
                this.defaultHandle(connect, message);
                break;
        }
    }

 public Form1()
 {
     InitializeComponent();
     pref = new prefs();
     pref.Owner = this;
     if (File.Exists("prefs"))
     {
         BinaryFormatter formatter = new BinaryFormatter();
         FileStream inputStream = File.OpenRead("prefs");
         try
         {
             Con = (Connect)formatter.Deserialize(inputStream);
         }
         catch (Exception ex)
         {
             System.Windows.Forms.MessageBox.Show("Ошибка:\n" + ex.Message, "",
                             MessageBoxButtons.OK,
                             MessageBoxIcon.Error);
         }
         inputStream.Close();
     }
     else
     {
         BinaryFormatter formatter = new BinaryFormatter();
         FileStream outputStream = File.OpenWrite("prefs");
         formatter.Serialize(outputStream, Con);
         outputStream.Close();
     }
 }

 public User()
 {
     _Updater = new Regulus.Utility.Updater<Regulus.Utility.IUpdatable>();
     _ConnectProvider = new Regulus.Remoting.Ghost.TProvider<TestNativeGameCore.IConnect>();
     _Connecter = new Connect();
     _Complex = new Regulus.Remoting.Ghost.Native.Agent();
 }

 /// <summary>
 /// This method returns all the societies from the database.
 /// </summary>
 /// <returns>It returns a datatable containing all the societies.</returns>
 public static DataTable GetAllSocieties()
 {
     sql = "SELECT * FROM Societies";
     Connect.ConnectEMS();
     c = new Connect(sql);
     return c.ds.Tables[0];
 }

 /// <summary>
 /// This method fetches all the events from the database.
 /// </summary>
 /// <returns>It returns a datatable containing all the events.</returns>
 public static DataTable GetAllEvents()
 {
     sql = "SELECT * FROM Events";
     Connect.ConnectEMS();
     c = new Connect(sql);
     return c.ds.Tables[0];
 }

    //init
    void Start() { 
        //get game objects from scene
        globalObj = GameObject.FindWithTag(TAG_GLOBAL); //global game object
        globalScript = globalObj.GetComponent<Global>(); //global script
        setupObj = GameObject.FindWithTag(TAG_SETUP); //setup game object
        connectScript = setupObj.GetComponent<Connect>(); //connect script
        activateScript = setupObj.GetComponent<Activate>(); //activate script

        //disable scripts to start
        //note: disable/uncheck scripts in the Unity interface
        connectScript.enabled = false;
        activateScript.enabled = false;

        //state manager
        //transition into scene
        //initialize since this is the first scene
        if (StateManager.Instance != null) {
            //set the transition effects for the state manager
            StateManager.Instance.gameObject.GetComponent<TransitionFade>().isFadingIn = true;
            StateManager.Instance.gameObject.GetComponent<TransitionFade>().isHoldFade = false;
        }

        //audio manager
        //initialize since this is the first scene
        if (AudioManager.Instance != null) {
            //set the transition effects for the audio manager
            //bgm
            AudioManager.Instance.switchBgmAfterDelay(AudioManager.Instance.bgmMenu, 0.0f);
            AudioManager.Instance.bgmIsFadingIn = true;
            AudioManager.Instance.bgmIsHoldFade = false;
        }

    } //end function

 public ExpressionHighlighterPlugin(Connect con, DTE2 appObject, AddIn addinInstance)
     : base(con, appObject, addinInstance)
 {
     workerToDos.WorkerReportsProgress = false;
     workerToDos.WorkerSupportsCancellation = true;
     workerToDos.DoWork += new System.ComponentModel.DoWorkEventHandler(workerToDos_DoWork);
 }

 protected void BtnStart_Click(object sender, EventArgs e)
 {
     sql = "SELECT SubjectType FROM Subject WHERE SubjectID=" + int.Parse(DDLSubjects.SelectedValue.ToString()) + "";
     c = new Connect(sql);
     if (c.ds.Tables[0].Rows[0]["SubjectType"].ToString().Equals("Theory"))
     {
         sql = "SELECT StudentNo,RollNo,Name FROM Student WHERE SectionID=" + int.Parse(DDLSectionGroup.SelectedValue.ToString()) + " AND Semester=(SELECT Semester FROM Subject WHERE SubjectID=" + int.Parse(DDLSubjects.SelectedValue.ToString()) + ")";
         c = new Connect(sql);
         GridView1.DataSource = c.ds;
         GridView1.DataBind();
     }
     else
     {
         sql = "SELECT StudentNo,RollNo,Name FROM Student WHERE GroupID=" + int.Parse(DDLSectionGroup.SelectedValue.ToString()) + " AND Semester=(SELECT Semester FROM Subject WHERE SubjectID=" + int.Parse(DDLSubjects.SelectedValue.ToString()) + ")";
         c = new Connect(sql);
         GridView1.DataSource = c.ds;
         GridView1.DataBind();
     }
     BtnSubmit.Visible = true;
     sql = "SELECT * FROM AttendanceType";
     c = new Connect(sql);
     foreach (GridViewRow row in GridView1.Rows)
     {
         DropDownList d = (DropDownList)row.FindControl("DDLAttendanceType");
         d.DataSource = c.ds;
         d.DataTextField = "AttendanceTypeName";
         d.DataValueField = "AttendanceTypeID";
         d.Width = 40;
         d.DataBind();
         d.Items[2].Attributes.CssStyle["Color"] = "red";
     }
 }

 void Test01()
 {
     var gd = new Connect();
     var sample = new Sample
                      {
                          Method = "GET",
                          Uri = "/test",
                          Timestamp = DateTime.Now.TimeOfDay.TotalMilliseconds,
                          ResponseTime = 100,
                          CpuTime = 20,
                          Context =
                              new[]
                                  {
                                      new Context {Name = "/", ResponseTime = 11},
                                      new Context {Name = "/one", ResponseTime = 12},
                                      new Context {Name = "/two", ResponseTime = 13}
                                  }
                      };
     gd.Init("26873", "testing", logger, null);
     for (int i = 0; i < 1000; i++)
     {
         gd.Store(sample, logger, null);
         Thread.Sleep(300);
     }
     gd.Term(logger, null);
     Console.Read();
 }

        public BIDSHelperPluginReference(Type t, DTE2 applicationObject, AddIn addInInstance, Connect addinCore)
        {
            pluginType = t;
            _applicationObject = applicationObject;
            _addInInstance = addInInstance;
            _core = addinCore;

        }

 /// <summary>
 /// This method fetches the details of a particular event.
 /// </summary>
 /// <param name="eventID">An integer parameter containing the ID of the event.</param>
 /// <returns>It returns a data table containing the details of the event.</returns>
 public static DataTable GetEventDetails(int eventID)
 {
     sql = "SELECT * FROM Events WHERE [email protected]";
     string[] s = { "@eventID" };
     Connect.ConnectEMS();
     c = new Connect(sql, s, eventID);
     return c.ds.Tables[0];
 }

 /// <summary>
 /// This method fetches the details of the student from the EMS database based on the student number.
 /// </summary>
 /// <param name="studentNumber">A string containing the student number of the student.</param>
 /// <returns>It returns a data table containing the details of the student.</returns>
 public static DataTable GetStudentDetails(string studentNumber)
 {
     sql = "SELECT * FROM Students WHERE [email protected]";
     Connect.ConnectEMS();
     string[] s = { "@StudentNo" };
     c = new Connect(sql, s, studentNumber);
     return c.ds.Tables[0];
 }

 /// <summary>
 /// This method fetches the details of the organiser based on the username and password.
 /// </summary>
 /// <param name="username">A string containing the username of the organiser.</param>
 /// <param name="password">A string containing the password of the organiser.</param>
 /// <returns>It returns a data table containing the details of the organiser.</returns>
 public static DataTable GetOrganiserDetails(string username,string password)
 {
     sql = "SELECT * FROM Login WHERE [email protected] AND [email protected]";
     Connect.ConnectEMS();
     string[] s = { "@username", "@password" };
     c = new Connect(sql, s, username, password);
     return c.ds.Tables[0];
 }

 // Use this for initialization
 void Awake()
 {
     gameOverScreen.SetActive(false);
     instance = this;
     GameObject serverObj = GameObject.FindGameObjectWithTag("Server");
     server = serverObj.GetComponent<Connect>();
     dead = 0;
 }

 /// <summary>
 /// This method fetches the events of a particular society.
 /// </summary>
 /// <param name="societyID">An integer parameter containing the societyID</param>
 /// <returns>It returns a data table containing the events.</returns>
 public static DataTable GetEvents(int societyID)
 {
     sql = "SELECT * FROM EVENTS WHERE [email protected]";
     Connect.ConnectEMS();
     string[] s = { "@societyID" };
     c = new Connect(sql, s, societyID);
     return c.ds.Tables[0];
 }

    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["StudentNo"] == null)
            Response.Redirect("~/Default.aspx");
        else
        {
            //-----------Get the details of the student-----------------//
            sql = "SELECT * FROM Student WHERE StudentNo='" + Session["StudentNo"].ToString() + "'";
            student = new Connect(sql);
            LblName.Text = " " + student.ds.Tables[0].Rows[0]["Name"].ToString();
            LblStudentNo.Text = student.ds.Tables[0].Rows[0]["StudentNo"].ToString();
            LblRollNo.Text = student.ds.Tables[0].Rows[0]["RollNo"].ToString();
            LblSemester.Text = student.ds.Tables[0].Rows[0]["Semester"].ToString();

            sql = "SELECT * FROM Department WHERE DepartmentID=" + int.Parse(student.ds.Tables[0].Rows[0]["DepartmentID"].ToString()) + "";
            c = new Connect(sql);
            LblDepartment.Text = c.ds.Tables[0].Rows[0]["DepartmentName"].ToString();
            sql = "SELECT * FROM Section WHERE SectionID=" + int.Parse(student.ds.Tables[0].Rows[0]["SectionID"].ToString()) + "";
            c = new Connect(sql);
            LblSection.Text = c.ds.Tables[0].Rows[0]["SectionName"].ToString();
            sql = "SELECT * FROM Groups WHERE GroupID=" + int.Parse(student.ds.Tables[0].Rows[0]["GroupID"].ToString()) + "";
            c = new Connect(sql);
            LblGroup.Text = c.ds.Tables[0].Rows[0]["GroupName"].ToString();

            //Get the subjects which the student is studying-------------//
            sql = "SELECT * FROM Subject WHERE Semester=" + int.Parse(student.ds.Tables[0].Rows[0]["Semester"].ToString()) + " AND DepartmentID=" + int.Parse(student.ds.Tables[0].Rows[0]["DepartmentID"].ToString()) + "";
            c = new Connect(sql);
            GridView1.DataSource = c.ds;
            GridView1.DataBind();

            //Get the attendance for each subject
            foreach (GridViewRow row in GridView1.Rows)
            {
                sql = "SELECT * FROM Attendance WHERE SubjectID=(SELECT SubjectID FROM Subject WHERE SubjectName='" + row.Cells[1].Text + "' AND Semester=" + int.Parse(student.ds.Tables[0].Rows[0]["Semester"].ToString()) + " AND DepartmentID=" + int.Parse(student.ds.Tables[0].Rows[0]["DepartmentID"].ToString()) + ") AND (SectionID=(SELECT SectionID FROM Section WHERE SectionName='" + LblSection.Text + "') OR GroupID=(SELECT GroupID FROM Groups WHERE GroupName='" + LblGroup.Text + "'))";
                subjectAttendance = new Connect(sql);
                DataTable subjectAttendanceTable = subjectAttendance.ds.Tables[0];
                var totalClasses = (from i in subjectAttendanceTable.AsEnumerable() select new { Date = i.Field<DateTime>("Date"), LectureID = i.Field<int>("LectureID") }).Distinct().Count();
                row.Cells[3].Text = totalClasses.ToString();

                int numberOfAbsent = 0;
                for (int k = 0; k < subjectAttendance.ds.Tables[0].Rows.Count; k++)
                {
                    if (subjectAttendance.ds.Tables[0].Rows[k]["StudentNo"].ToString().Equals(LblStudentNo.Text + "   "))
                    {
                        numberOfAbsent = numberOfAbsent + 1;
                    }
                }
                Label totalPresent = (Label)row.FindControl("LblPresent");
                totalPresent.Text = (totalClasses - numberOfAbsent).ToString();
                Label percentageAttendance = (Label)row.FindControl("LblPercentageAttendance");
                percentageAttendance.Text = (float.Parse(totalPresent.Text) * 100 / totalClasses).ToString();
                if (float.Parse(percentageAttendance.Text) < 75)
                {
                    row.BackColor = System.Drawing.ColorTranslator.FromHtml("#FF8D7C");
                }
            }
        }
    }

 /// <summary>
 /// This method inserts the college into the database.
 /// </summary>
 /// <param name="collegeName">A string containing the name of the college</param>
 /// <returns>It returns the generated id of the college.</returns>
 public static int AddNewCollege(string collegeName)
 {
     sql = "INSERT INTO Colleges(CollegeName) VALUES(@collegeName)";
     Connect.ConnectTT();
     string[] s = { "@collegeName" };
     c = new Connect(sql, s, collegeName);
     int collegeID = -1;
     collegeID = c.lastId;
     return collegeID;
 }

 /// <summary>
 /// This method returns the event id the team is regisreted in.
 /// </summary>
 /// <param name="teamID">An integer parameter containing the id of the team.</param>
 /// <returns>It returns an integer parameter containing the event id.</returns>
 public static int GetEventID(int teamID)
 {
     sql = "SELECT * FROM EventRegistrations WHERE [email protected]";
     Connect.ConnectEMS();
     string[] s = { "@teamID" };
     c = new Connect(sql, s, teamID);
     if (c.ds.Tables[0].Rows.Count != 0)
         return int.Parse(c.ds.Tables[0].Rows[0]["EventID"].ToString());
     else
         return -1;
 }