private void ReportsUI_FormClosed(object sender, FormClosedEventArgs e)
{
this.Hide();
frmMainUI frm = new frmMainUI();
frm.Show();
}
private void CloseButton_Click(object sender, EventArgs e)
{
this.Hide();
frmMainUI frm = new frmMainUI();
frm.Show();
}
private void btnSignIn_Click(object sender, EventArgs e)
{
if (txtUserName.Text == "")
{
MessageBox.Show("Please enter user name", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtUserName.Focus();
return;
}
if (txtPassword.Text == "")
{
MessageBox.Show("Please enter password", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtPassword.Focus();
return;
}
try
{
string clearText = txtPassword.Text.Trim();
string password = clearText;
byte[] bytes = Encoding.Unicode.GetBytes(password);
byte[] inArray = HashAlgorithm.Create("SHA1").ComputeHash(bytes);
string readyPassword1 = Convert.ToBase64String(inArray);
readyPassword = readyPassword1;
con = new SqlConnection(cs.DBConn);
con.Open();
string qry = "SELECT UserName,Password FROM Registration WHERE UserName = '******' AND Password = '******'";
cmd = new SqlCommand(qry, con);
rdr1 = cmd.ExecuteReader();
if (rdr1.Read() == true)
{
dbUserName = (rdr1.GetString(0));
dbPassword = (rdr1.GetString(1));
con = new SqlConnection(cs.DBConn);
con.Open();
string ct = "select UserType,UserId from Registration where UserName='******' and Password='******'";
cmd = new SqlCommand(ct);
cmd.Connection = con;
rdr = cmd.ExecuteReader();
if (rdr.Read())
{
userType = (rdr.GetString(0));
uId2 = (rdr.GetInt32(1));
}
if ((rdr != null))
{
rdr.Close();
}
//if (dbUserName == txtUserName.Text && dbPassword == readyPassword && userType.Trim() == "SuperAdmin")
//{
//}
if (dbUserName == txtUserName.Text && dbPassword == readyPassword && userType.Trim() == "Admin")
{
this.Hide();
frmMainUI frm = new frmMainUI();
frm.Show();
frm.lblUser.Text = txtUserName.Text;
txtPassword.Clear();
txtUserName.Clear();
}
//if (dbUserName == txtUserName.Text && dbPassword == readyPassword && userType.Trim() == "User")
//{
// this.Hide();
// FiscalYear frm = new FiscalYear();
// frm.Show();
//}
}
else
{
MessageBox.Show("Login is Failed...Try again !", "Login Denied", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtUserName.Clear();
txtPassword.Clear();
txtUserName.Focus();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
//if (txtUserName.Text == "")
//{
// MessageBox.Show("Please enter user name", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
// txtUserName.Focus();
// return;
//}
//if (txtPassword.Text == "")
//{
// MessageBox.Show("Please enter password", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
// txtPassword.Focus();
// return;
//}
//try
//{
// SqlConnection myConnection = default(SqlConnection);
// myConnection = new SqlConnection(cs.DBConn);
// SqlCommand myCommand = default(SqlCommand);
// myCommand = new SqlCommand("SELECT Username,password FROM Registration WHERE Username = @username AND Password = @UserPassword", myConnection);
// SqlParameter uName = new SqlParameter("@username", SqlDbType.VarChar);
// SqlParameter uPassword = new SqlParameter("@UserPassword", SqlDbType.VarChar);
// uName.Value = txtUserName.Text;
// uPassword.Value = txtPassword.Text;
// myCommand.Parameters.Add(uName);
// myCommand.Parameters.Add(uPassword);
// myCommand.Connection.Open();
// SqlDataReader myReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
// if (myReader.Read() == true)
// {
// int i;
// ProgressBar1.Visible = true;
// ProgressBar1.Maximum = 5000;
// ProgressBar1.Minimum = 0;
// ProgressBar1.Value = 4;
// ProgressBar1.Step = 1;
// for (i = 0; i <= 5000; i++)
// {
// ProgressBar1.PerformStep();
// }
// con = new SqlConnection(cs.DBConn);
// con.Open();
// string ct = "select usertype,UserId from Registration where Username='******'and Password='******'";
// cmd = new SqlCommand(ct);
// cmd.Connection = con;
// rdr = cmd.ExecuteReader();
// if (rdr.Read())
// {
// txtUserType.Text = (rdr.GetString(0));
// uId2 = (rdr.GetInt32(1));
// }
// if ((rdr != null))
// {
// rdr.Close();
// }
// if (txtUserType.Text.Trim() == "Admin")
// {
// this.Hide();
// frmMainUI frm = new frmMainUI();
// frm.Show();
// //this.Visible = false;
// //frm.ShowDialog();
// frm.lblUser.Text = txtUserName.Text;
// //this.Visible = true;
// txtPassword.Clear();
// txtUserName.Clear();
// }
// //if (txtUserType.Text.Trim() == "User")
// //{
// // MasterPagesForUser frm = new MasterPagesForUser();
// // this.Visible = false;
// // frm.ShowDialog();
// // this.Visible = true;
// //}
// }
// else
// {
// MessageBox.Show("Login is Failed...Try again !", "Login Denied", MessageBoxButtons.OK, MessageBoxIcon.Error);
// txtUserName.Clear();
// txtPassword.Clear();
// txtUserName.Focus();
// }
// if (myConnection.State == ConnectionState.Open)
// {
// myConnection.Dispose();
// }
//}
//catch (Exception ex)
//{
// MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
//}
}