public int GetDataByUserNamenPassword(string username, string password)
        {
            tbluserTableAdapter adapter = new tbluserTableAdapter();
            pyatLevelDS.tbluserDataTable tbl = new pyatLevelDS.tbluserDataTable();
            tbl = adapter.GetDataByUserNamenPassword(username, password);
            if (tbl == null || tbl.Rows.Count == 0)
                return 0;
            if (tbl.Rows.Count > 1)
                return -1;
            else
            {
                System.Data.DataColumn column = tbl.Columns[0];
                int value = Convert.ToInt32(tbl.Rows[0][0]);
                return value;

            }
        }
        public int LogIn(string username, string Password, string Emailid)
        {
            tbluserTableAdapter adapter = new tbluserTableAdapter();
            pyatLevelDS.tbluserDataTable tbl = new pyatLevelDS.tbluserDataTable();

            tbl = adapter.GetDataByCredentials(username,Password , Emailid);
            if (tbl == null || tbl.Rows.Count == 0)
                return 0;
            if (tbl.Rows.Count > 1)
                return -1;
            else
            {
                System.Data.DataColumn column = tbl.Columns[0];
                int value = Convert.ToInt32(tbl.Rows[0][0]);
                return value;

            }
        }