public LoginDetails Login(string NationalCode, string Password)
        {
            var User = dc.PeopleSelectCommand().Where(x => x.NationalCode == NationalCode && x.Password == Password).FirstOrDefault();

            if (User != null)
            {
                if (dc.Update1_IsActive(NationalCode).FirstOrDefault().IsActive)
                {
                    dc.LogSet_Insert("• Successful Login", NationalCode);
                    return(new LoginDetails {
                        Role = User.Role, Success = true
                    });
                }
                else
                {
                    dc.LogSet_Insert("• Successful Login • Closed Account", NationalCode);
                    return(new LoginDetails {
                        Role = User.Role, Success = false
                    });
                }
            }
            else
            {
                dc.LogSet_Insert("• Failed Login", NationalCode);
                return(new LoginDetails {
                    Success = false, Role = null
                });
            }
        }