public LoginInfo GetLoginInfo(string id, byte[] passwd) { secdivDataContext db = new secdivDataContext(); var users = db.UserAccounts.Where(ua => ua.UserName.Equals(id) && ua.Password.Equals(passwd)); if (users.Count() > 0) { UserAccount user = users.First(); var userinfo = db.Persons.Where(p => p.PID.Equals(user.PID)); if (userinfo.Count() > 0) { LoginInfo li; Person person = userinfo.First(); if (String.IsNullOrEmpty(person.MiddleName)) { li = new LoginInfo { UserName = user.UserName, Name = string.Format("{0}, {1} {2}", person.LastName, person.FirstName, person.MiddleName), UnitName = person.OFFICE.Unit.UnitName, TypeOfUser = user.TypeOfUser, UAStatus = user.UAStatus }; } else { li = new LoginInfo { UserName = user.UserName, Name = string.Format("{0}, {1}", person.LastName, person.FirstName), UnitName = person.OFFICE.Unit.UnitName, TypeOfUser = user.TypeOfUser, UAStatus = user.UAStatus }; } return li; } } return null; }
/// <summary> /// Scripter : YONGTOK KIM /// Script Date : 20 Oct 2010 /// If success login, close the Login form and set the value. If fail, refresh the form. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void LoginView() { if (!dbExist) { if (userId.Equals(txtCommonID.Text) && password.Equals(txtCommonPassword.Password)) { DialogResult = true; Close(); } else { CheckNumberOfTry(); } } else { UploadLogin login = new UploadLogin(); byte[] passwd = DataHash.GetHashData(txtCommonPassword.Password, "SHA1"); LoginInfo li = login.GetLoginInfo(txtCommonID.Text, passwd); if (li != null) { LoginInfoData = li; if (li.TypeOfUser == "Administrator") DialogResult = true; else { DialogResult = false; MessageBox.Show("You are not authorized person to upload"); } Close(); } else { CheckNumberOfTry(); } } }