private void txtUserID_TextChanged(object sender, EventArgs e)
{
User USR = new User();
DataSet ds = USR.getUserList(txtUserID.Text);
gridUsers.DataSource = ds.Tables["Users"].DefaultView;
}
private void UserSummary_Load(object sender, EventArgs e)
{
User USR = new User();
DataSet DS = USR.getLogTrack();
string userID;
int count;
//generate chart
chart1.Series.Add("Login_Rate");
chart1.Series["Login_Rate"].ChartType = SeriesChartType.Column;
chart1.Series["Login_Rate"].ChartArea = "ChartArea1";
chart1.Series["Login_Rate"].BackSecondaryColor = Color.White;
chart1.Series["Login_Rate"].BackGradientStyle = GradientStyle.TopBottom;
int rowCount = 0;
foreach (DataRow row in DS.Tables[0].Rows)
{
userID = row[0].ToString().Trim();
count = Convert.ToInt32(row[1]);
chart1.Series["Login_Rate"].Points.AddXY(userID, count);
rowCount++;
}
//fill the grid
DataSet ds = USR.getLogInfo();
gridUsers.DataSource = ds.Tables["Info"].DefaultView;
}
private void btnReset_Click(object sender, EventArgs e)
{
User usr = new User();
if (usr.ResetUser(lblUserID.Text,lblUsername.Text,UTL.NewPassWordGen()))
{
MessageBox.Show("User Reset successfully!", "Successfully", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Reset incompleted!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnRemove_Click(object sender, EventArgs e)
{
User usr = new User();
if (usr.DeleteUser(lblUserID.Text))
{
MessageBox.Show("User Removed successfully!", "Successfully", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Deletion incompleted!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void radButton2_Click(object sender, EventArgs e)
{
byte[] userPhoto = UTL.ConvertImageToBytes(picUser.Image);
User newUser = new User(lblUserID.Text, txtFirstName.Text, txtLastName.Text, lstTitle.SelectedText, lstUserLevels.SelectedText, txtUsername.Text, txtPassword.Text, txtEmail.Text, Convert.ToDateTime(lblCreatedDate.Value.ToShortDateString()), lblCreatedTime.Text,userPhoto);
if(newUser.InsertUser(newUser))
{
MessageBox.Show("New user crated successfuly!", "Successfully", MessageBoxButtons.OK, MessageBoxIcon.Information);
clear_Txt();
}
else
{
MessageBox.Show("Insert incompleted!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
Utility utl = new Utility();
byte[] photo = utl.ConvertImageToBytes(picUser.Image);
User usr = new User(lblUserID.Text, txtFirstName.Text, txtLastName.Text, lblTitle.Text, lblUserLevel.Text, txtUserName.Text, txtPassword.Text, txtEmailAdd.Text, Convert.ToDateTime(lblDate.Text), lblTime.Text,photo);
if (txtPassword.Text != "")
{
if (usr.UpdateUser(usr))
{
MessageBox.Show("User Modification is successful!", "Successfully", MessageBoxButtons.OK, MessageBoxIcon.Information);
clear_Txt();
}
else
{
MessageBox.Show("Modification Rejected!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show("Empty password not allowed", "Successfully", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnSendMail_Click(object sender, EventArgs e)
{
User usr = new User();
bool x = usr.sendMail("*****@*****.**", "Working", "ABC", "123");
}
private void btnLogout_Click(object sender, EventArgs e)
{
User USR = new User();
DateTime GloblogoutTime = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-ddThh:mm:sszzz"));
if (USR.UpdateLogRecord(GlobUser_id, GlobLoggedTime, GloblogoutTime))
{
alertLogTracker.CaptionText = "Logout Tracker";
alertLogTracker.ContentText = "Logout Tracked : " + GloblogoutTime.ToString();
alertLogTracker.Show();
MessageBox.Show("System usage tracked successfully..!","Thank you");
}
else
{
alertLogTracker.ContentText = "Failure Occured ..!";
alertLogTracker.Show();
}
Login lgout = new Login();
Login log = new Login();
this.Dispose();
log.Show();
}
//update User
public bool UpdateUser(User editedUser)
{
try
{
this.connection = DBHandler.getConnection();
}
catch (Exception e)
{
MessageBox.Show(e.Message.ToString());
}
bool status = false;
if (connection.State.ToString() == "Closed")
{
connection.Open();
}
SqlCommand newCmd = connection.CreateCommand();
newCmd.Connection = connection;
newCmd.CommandType = CommandType.Text;
newCmd.CommandText = "UPDATE Users SET user_id='" + editedUser.userId + "',first_name='" + editedUser.firstName + "',last_name='" + editedUser.lastName + "',title='" + editedUser.title + "',user_level='" + editedUser.userLevel + "',user_name='" + editedUser.username + "',password='******',email='" + editedUser.email + "',photograph='" + editedUser.photo + "' where user_id='" + editedUser.userId + "';";
try
{
newCmd.ExecuteNonQuery();
status = true;
}
catch (Exception ex)
{
MessageBox.Show("Error" + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
connection.Close();
return status;
}
//Inset new User
public bool InsertUser(User newUser)
{
try
{
this.connection = DBHandler.getConnection();
}
catch (Exception e)
{
MessageBox.Show(e.Message.ToString());
}
bool status = false;
if (connection.State.ToString() == "Closed")
{
connection.Open();
}
SqlCommand newCmd = connection.CreateCommand();
newCmd.Connection = connection;
newCmd.CommandType = CommandType.Text;
newCmd.CommandText = "insert into Users values('" + newUser.userId + "','" + newUser.firstName + "','" + newUser.lastName + "','" + newUser.title + "','" + newUser.userLevel + "','" + newUser.username + "','" + newUser.password + "','" + newUser.email + "','" + newUser.createdDate + "','" + newUser.createdTime + "','" + newUser.photo + "')";
try
{
newCmd.ExecuteNonQuery();
status = true;
}
catch (Exception ex)
{
MessageBox.Show("Error" + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
connection.Close();
return status;
}
