public int IsLogInValid(string id, string password)
        {
            this.sql = "select * from Login where userid ='" + id + "'and password ='******';";
            this.Ds  = DBcon.GetDataSet(sql);

            if (this.Ds.Tables[0].Rows.Count == 1)
            {
                if (IsAdminValid(id, password) == true)
                {
                    return(1);
                }
                else if (IsEmployeeValid(id, password) == true)
                {
                    return(2);
                }
                else
                {
                    return(0);
                }
            }
            else
            {
                return(0);
            }
        }
 public bool IsEmployeeValid(string id, string password)
 {
     this.sql = "select * from Login where userid ='" + id + "'and password ='******'and usertype ='Employee';";
     this.Ds  = DBcon.GetDataSet(sql);
     if (this.Ds.Tables[0].Rows.Count == 1)
     {
         return(true);
     }
     else
     {
         return(false);
     }
 }