public virtual string GetCharityIdForLogin(string webLogin)
 {
     LookupCharityId procedure = new LookupCharityId();
     return procedure.Execute(webLogin).CharityId;
 }
        public virtual string ValidateLogin(string username, string password)
        {
            LookupCharityId procedure = new LookupCharityId();
            var charityId = procedure.Execute(username).CharityId;

            using (var context = new SqlDataContext())
            {
                var matchingPassword = context.Charities.FirstOrDefault(x => x.CharityId == charityId && x.Password.ToLower() == password.ToLower());

                if (matchingPassword != null)
                    return charityId;

                return null;
            }

        }