public static string CheckValidPassword(string username, string password)
        {
            string error = string.Empty;
            TUsers user  = null;

            try
            {
                using (SQLDatabaseDataContext db = new SQLDatabaseDataContext(Program.Connectionstring))
                {
                    if (string.IsNullOrEmpty(username))
                    {
                        return("Моля въведете правилно потребителско име");
                    }
                    if (string.IsNullOrEmpty(password))
                    {
                        return("Моля въведете правилна парола");
                    }

                    var use = (from us in db.Users where us.Username.Equals(username) && us.Password.Equals(password) select us).FirstOrDefault();
                    if (use == null)
                    {
                        return(" Невалидно потребителско име");
                    }

                    user = new TUsers(use);
                }

                Program.CurrentUser = user;
            }
            catch (Exception ex)
            {
                error = ex.Message;
            }
            return(error);
        }
        public TUsers LoadUser(int ID)
        {
            string error = "";
            var    user  = new TUsers();

            //TUsers user = new TUsers();
            try
            {
                using (SQLDatabaseDataContext db = new SQLDatabaseDataContext(Program.Connectionstring))
                {
                    if (this.ID > 0)
                    {
                        user = (from us in db.Users where us.ID == this.ID select new TUsers(us)).FirstOrDefault();
                    }
                }
            }
            catch (Exception ex)
            {
                error = ex.Message;
            }
            return(user);
        }