/// <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);
}
}
}
