//when check name and password, get the user's information public PropertyClass CheckNameAndPasswd(string name,string password) { PropertyClass accountClass=null; string strSql="select * from account where accountName='"+name.Trim()+"' and accountPassword='******'"; try{ sdr=db.GetDataReader(strSql); sdr.Read(); if(sdr.HasRows) { accountClass=new PropertyClass(); accountClass.UserId=sdr.GetInt32("id"); accountClass.AccountName=name.Trim(); accountClass.AccountPassword=password.Trim(); accountClass.Email=sdr["email"].ToString(); accountClass.Job=sdr.GetInt32("job");; accountClass.Superviser=sdr.GetInt32("superviser"); } } catch(Exception ex) { } finally { sdr.Close(); } return accountClass; }
//when check name and password, get the user's information public static PropertyClass CheckNameAndPasswd(string name, string password) { PropertyClass accountClass = null; string strSql = "select * from account where accountName='" + name.Trim() + "' and accountPassword='******'"; try{ sdr = db.GetDataReader(strSql); sdr.Read(); if (sdr.HasRows) { accountClass = new PropertyClass(); accountClass.UserId = sdr.GetInt32("id"); accountClass.AccountName = name.Trim(); accountClass.AccountPassword = password.Trim(); accountClass.Email = sdr["email"].ToString(); accountClass.Job = sdr.GetInt32("job");; accountClass.Superviser = sdr.GetInt32("superviser"); } } catch (Exception ex) { Logger.Error(ex.Message); Logger.Error(ex.StackTrace); } finally { sdr.Close(); } return(accountClass); }
private void BtnLogin_Click(object sender, EventArgs e) { try { accountProperty =accountMgr.CheckNameAndPasswd(textBox1.Text.Trim(), maskedTextBox1.Text.Trim()); Logger.Info(accountProperty.UserId + "," + accountProperty.Job + " logged in"); } catch (Exception ex) { MessageBox.Show("Can not connect to the server.Please contact the admin"); Logger.Error(ex.Message); Logger.Error(ex.StackTrace); return; } if (accountProperty== null) { MessageBox.Show("Invalid Name or Password"); } else { UserInfo.UserId = accountProperty.UserId; UserInfo.UserName = accountProperty.AccountName; UserInfo.Job = (JobDescription)accountProperty.Job; MainFrame mainFrame = new MainFrame(); this.Hide(); mainFrame.WindowState = FormWindowState.Maximized; mainFrame.Show(); } }