/// <summary> /// /// </summary> /// <returns></returns> private SqlConnection getSqlConnection() { FileStream aFile = new FileStream("C:\\ProgramData\\RSData\\RSDataConfig\\Server.txt", FileMode.Open); StreamReader sr = new StreamReader(aFile); string strLine = sr.ReadLine(); string ServerName = DEncrypt.Decrypt(strLine); sr.Close(); string connString = string.Format("Data Source={0};Initial Catalog=RSData;Integrated Security=True;MultipleActiveResultSets=True", ServerName); SqlConnection sqlConn = new SqlConnection(connString); return(sqlConn); }
/// <summary> /// /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void button1_Click(object sender, EventArgs e) { string formUserID = this.textBox1.Text; string formPassword = this.textBox2.Text; using (RSFinanceToolsEntities db = new RSFinanceToolsEntities()) { try { var wUserID = (from FT_user in db where FT_user.FormUserID == formUserID & FT_user.FormUserPassword == formPassword select FT_user.ft_id).First(); var SunIP = (from FT_user in db.FinTools_Users where FT_user.FormUserID == formUserID & FT_user.FormUserPassword == formPassword select FT_user.SUNUserIP).First(); var SunUID = (from FT_user in db.FinTools_Users where FT_user.FormUserID == formUserID & FT_user.FormUserPassword == formPassword select FT_user.SUNUserID).First(); var SunUpass = (from FT_user in db.FinTools_Users where FT_user.FormUserID == formUserID & FT_user.FormUserPassword == formPassword select FT_user.SUNUserPass).First(); if (SessionInfo.UserInfo == null) { SessionInfo.UserInfo = new UserInfo(); } SessionInfo.UserInfo.ID = wUserID.ToString(); SessionInfo.UserInfo.SunUserIP = SunIP; SessionInfo.UserInfo.SunUserID = DEncrypt.Decrypt(SunUID); SessionInfo.UserInfo.SunUserPass = DEncrypt.Decrypt(SunUpass); if (pSender != null) { ((Ribbon2)pSender).addfolders(); } this.Close(); this.Dispose(); } catch { MessageBox.Show("The user id or the password is invalid.", "Message - RSystems FinanceTools", MessageBoxButtons.OK, MessageBoxIcon.Information); } } }