private void btn_login_Click(object sender, EventArgs e)
{
if (Username.Text.Trim(' ').Length == 0)
{
MessageBox.Show("Please enter user id", "", MessageBoxButtons.OK, MessageBoxIcon.Warning);
Username.Focus();
return;
}
if (Username.Text.Trim(' ').Length == 0)
{
MessageBox.Show("Please enter password", "", MessageBoxButtons.OK, MessageBoxIcon.Warning);
Password.Focus();
return;
}
try
{
ModCommonClasses.con = new SqlConnection(ModCS.cs);
ModCommonClasses.con.Open();
ModCommonClasses.cmd = ModCommonClasses.con.CreateCommand();
ModCommonClasses.cmd.CommandText = "SELECT RTRIM(UserID),RTRIM(Password) FROM tbl_login where UserType = @d1 and Name = @d2 and Password=@d3 and Active='Yes'";
ModCommonClasses.cmd.Parameters.AddWithValue("@d1", combo_type.Text);
ModCommonClasses.cmd.Parameters.AddWithValue("@d2", Username.Text);
ModCommonClasses.cmd.Parameters.AddWithValue("@d3", ModFunc.Encrypt(Password.Text));
ModCommonClasses.rdr = ModCommonClasses.cmd.ExecuteReader();
if (ModCommonClasses.rdr.Read())
{
ModCommonClasses.con = new SqlConnection(ModCS.cs);
ModCommonClasses.con.Open();
ModCommonClasses.cmd = ModCommonClasses.con.CreateCommand();
ModCommonClasses.cmd.CommandText = "SELECT usertype FROM tbl_login where UserType=@d4 and Name=@d5 and Password=@d6";
ModCommonClasses.cmd.Parameters.AddWithValue("@d4", combo_type.Text);
ModCommonClasses.cmd.Parameters.AddWithValue("@d5", Username.Text);
ModCommonClasses.cmd.Parameters.AddWithValue("@d6", ModFunc.Encrypt(Password.Text));
ModCommonClasses.rdr = ModCommonClasses.cmd.ExecuteReader();
if (ModCommonClasses.rdr.Read())
{
}
if (ModCommonClasses.rdr != null)
{
ModCommonClasses.rdr.Close();
}
if (ModCommonClasses.con.State == ConnectionState.Open)
{
ModCommonClasses.con.Close();
}
string st = "Successfully logged in";
ModFunc.LogFunc(Username.Text, st);
this.Hide();
Dashboard ss = new Dashboard();
ss.Show();
ss.lblUser.Text = Username.Text;
ss.lblUserType.Text = combo_type.Text;
}
else
{
Interaction.MsgBox("Login is Failed...Try again !", MsgBoxStyle.Critical, "Login Denied");
Username.Text = "";
Password.Text = "";
Username.Focus();
}
ModCommonClasses.cmd.Dispose();
ModCommonClasses.con.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (txtName.Text == "")
{
MessageBox.Show("Please Enter Username", "", MessageBoxButtons.OK, MessageBoxIcon.Warning);
txtName.Focus();
return;
}
try
{
ModCommonClasses.con = new SqlConnection(ModCS.cs);
ModCommonClasses.con.Open();
string ct = "select userid from tbl_login where UserID=@d1";
ModCommonClasses.cmd = new SqlCommand(ct);
ModCommonClasses.cmd.Parameters.AddWithValue("@d1", txtUserID.Text);
ModCommonClasses.cmd.Connection = ModCommonClasses.con;
ModCommonClasses.rdr = ModCommonClasses.cmd.ExecuteReader();
if (ModCommonClasses.rdr.Read())
{
MessageBox.Show("User ID Already Exists", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtUserID.Text = "";
txtUserID.Focus();
if (ModCommonClasses.rdr != null)
{
ModCommonClasses.rdr.Close();
}
return;
}
if (chkActive.Checked == true)
{
st1 = "Yes";
}
else
{
st1 = "No";
}
ModCommonClasses.con = new SqlConnection(ModCS.cs);
ModCommonClasses.con.Open();
string cb = "insert into tbl_login(UserID, UserType, Name, Password, Address, Email, Mobile, JoiningDate, Active) VALUES (@d1,@d2,@d3,@d4,@d5,@d6,@d7,@d8,@d9)";
ModCommonClasses.cmd = new SqlCommand(cb);
ModFunc ep = new ModFunc();
ModCommonClasses.cmd.Connection = ModCommonClasses.con;
ModCommonClasses.cmd.Parameters.AddWithValue("@d1", txtUserID.Text);
ModCommonClasses.cmd.Parameters.AddWithValue("@d2", cmbUserType.Text);
ModCommonClasses.cmd.Parameters.AddWithValue("@d3", txtName.Text);
ModCommonClasses.cmd.Parameters.AddWithValue("@d4", ModFunc.Encrypt(txtPassword.Text.Trim()));
ModCommonClasses.cmd.Parameters.AddWithValue("@d5", txtAddress.Text);
ModCommonClasses.cmd.Parameters.AddWithValue("@d6", txtemail.Text);
ModCommonClasses.cmd.Parameters.AddWithValue("@d7", txtmobile.Text);
ModCommonClasses.cmd.Parameters.AddWithValue("@d8", DateTime.Now);
ModCommonClasses.cmd.Parameters.AddWithValue("@d9", st1);
ModCommonClasses.cmd.ExecuteReader();
ModCommonClasses.con.Close();
string st = "added the new user '" + txtUserID.Text + "'";
MessageBox.Show("Successfully Registered", "User", MessageBoxButtons.OK, MessageBoxIcon.Information);
ModFunc.LogFunc(lblUser.Text, "Add New User '" + txtName.Text + "' Having UserID '" + txtUserID.Text + "'");
autonumber();
this.ActiveControl = cmbUserType;
cmbUserType.Focus();
DisplayData();
ClearData();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
