// delete/fired
private void button5_Click(object sender, EventArgs e)
{
try
{
int empId = Int32.Parse(textBox10.Text);
if (empId != uID)
{
DataClasses1DataContext db = new DataClasses1DataContext();
UserLogIN q = (from UserLogIN in db.UserLogINs
where UserLogIN.Id == empId
select UserLogIN).Single();
q.Status = "invalid";
db.SubmitChanges();
MessageBox.Show("Succesfully Fired! \n");
init();
}
else
{
MessageBox.Show("You are currently logged in! \n");
}
}
catch
{
MessageBox.Show("Invalid Input");
}
}
private void button4_Click(object sender, EventArgs e)
{
if (textBox4.Text != textBox6.Text)
{
MessageBox.Show("Check Password Please!");
}
else
{
try
{
DataClasses1DataContext db = new DataClasses1DataContext();
int empId = Int32.Parse(textBox10.Text);
UserLogIN q22 = (from UserLogIN in db.UserLogINs
where UserLogIN.Id == empId
select UserLogIN).Single();
q22.password = textBox4.Text;
q22.Address = textBox8.Text;
q22.Phone = textBox9.Text;
q22.PicLink = picLoc;
q22.FullName = textBox2.Text;
db.SubmitChanges();
MessageBox.Show("Succesfully updated!\n");
}
catch
{
MessageBox.Show("Invalid Input");
}
}
}
// update
private void button4_Click(object sender, EventArgs e)
{
if (textBox3.Text != "" && textBox4.Text != "")
{
DataClasses1DataContext db = new DataClasses1DataContext();
UserLogIN ut = new UserLogIN();
try
{
int empId = Int32.Parse(textBox10.Text);
UserLogIN q22 = (from UserLogIN in db.UserLogINs
where UserLogIN.Id == empId
select UserLogIN).Single();
q22.userName = textBox3.Text;
q22.password = textBox4.Text;
//ut.role = textBox5.Text;
if (radioButton1.Checked)
{
q22.role = "admin";
}
else if (radioButton2.Checked)
{
q22.role = "staff";
}
q22.DateEmployed = DateTime.Parse(dateTimePicker1.Text);
if (textBox7.Text != "")
{
q22.Salary = Int32.Parse(textBox7.Text);
}
q22.Address = textBox8.Text;
q22.Phone = textBox9.Text;
q22.PicLink = picLoc;
q22.FullName = textBox2.Text;
q22.Status = comboBox2.Text;
db.SubmitChanges();
MessageBox.Show("Succesfully updated!\n");
init();
}
catch
{
MessageBox.Show("Invalid Input");
}
}
else
{
MessageBox.Show("Must Give name and password");
}
}
// search
private void button1_Click(object sender, EventArgs e)
{
if (comboBox1.Text != "")
{
DataClasses1DataContext db = new DataClasses1DataContext();
UserLogIN ut = new UserLogIN();
try
{
if (comboBox1.Text == "ID")
{
if (textBox1.Text != "")
{
var q = from UserLogIN in db.UserLogINs
where UserLogIN.Id == Int32.Parse(textBox1.Text)
select UserLogIN;
dataGridView1.DataSource = q;
}
else
{
var q = from UserLogIN in db.UserLogINs
select UserLogIN;
dataGridView1.DataSource = q;
}
}
else
{
if (textBox1.Text != "")
{
var q = from UserLogIN in db.UserLogINs
where UserLogIN.userName.Contains(textBox1.Text)
select UserLogIN;
dataGridView1.DataSource = q;
}
else
{
var q = from UserLogIN in db.UserLogINs
select UserLogIN;
dataGridView1.DataSource = q;
}
}
}
catch
{
MessageBox.Show("Invalid Input");
}
}
else
{
MessageBox.Show("Please mention search by");
}
}
// fetchData
private void button6_Click(object sender, EventArgs e)
{
DataClasses1DataContext db = new DataClasses1DataContext();
UserLogIN ut = new UserLogIN();
try
{
int empId = Int32.Parse(textBox10.Text);
var q = from UserLogIN in db.UserLogINs
where UserLogIN.Id == empId
select UserLogIN;
foreach (var UserLogIN in q)
{
textBox3.Text = UserLogIN.userName;
textBox4.Text = UserLogIN.password;
//textBox5.Text = UserLogIN.role;
if (UserLogIN.role == "admin")
{
radioButton1.Checked = true;
}
else if (UserLogIN.role == "staff")
{
radioButton2.Checked = true;
}
dateTimePicker1.Text = UserLogIN.DateEmployed.ToString();
textBox7.Text = UserLogIN.Salary.ToString();
textBox8.Text = UserLogIN.Address;
textBox9.Text = UserLogIN.Phone;
textBox2.Text = UserLogIN.FullName;
comboBox2.SelectedItem = UserLogIN.Status;
try
{
pictureBox1.Image = new Bitmap(UserLogIN.PicLink);
}
catch
{
pictureBox1.Image = null;
}
break;
}
}
catch
{
MessageBox.Show("Invalid Input");
}
}
// when close button is pressed!
private void Form1_FormClosing(object sender, FormClosingEventArgs e)
{
try
{
if (e.CloseReason == CloseReason.UserClosing)
{
DialogResult result = MessageBox.Show("Do you really want to LogOut?", "Warning!", MessageBoxButtons.YesNo);
if (result == DialogResult.Yes)
{
DataClasses1DataContext db = new DataClasses1DataContext();
UserLogIN q22 = (from UserLogIN in db.UserLogINs
where UserLogIN.Id == uID
select UserLogIN).Single();
q22.LastLogoutTime = DateTime.Now;
db.SubmitChanges();
MessageBox.Show("You are Logged out\nLast LoginTime : " + q22.LastLoginTime.ToString() + "\nLast LogOut Time : " + q22.LastLogoutTime.ToString());
SessionTable dt = new SessionTable();
dt.UserID = uID;
dt.LogInTime = (DateTime)q22.LastLoginTime;
dt.LogOutTime = DateTime.Now;
db.SessionTables.InsertOnSubmit(dt);
db.SubmitChanges();
parent.Visible = true;
for (int i = 0; i < arrTrackIndex; i++)
{
arrTrackOfOpenedForm[i].Dispose();
}
//this.Dispose();
//Application.Exit();
}
else
{
e.Cancel = true;
}
}
else
{
e.Cancel = true;
}
}
catch
{
MessageBox.Show("Invalid Input!");
}
}
private void button3_Click(object sender, EventArgs e)
{
try
{
if (textBox3.Text != "" && textBox4.Text != "" && textBox1.Text == textBox4.Text)
{
DataClasses1DataContext db = new DataClasses1DataContext();
UserLogIN ut = new UserLogIN();
var qTemp = from UserLogIN in db.UserLogINs
where UserLogIN.userName == textBox3.Text
select UserLogIN;
bool duplicate = false;
foreach (var UserLogIN in qTemp)
{
duplicate = true;
break;
}
if (!duplicate)
{
ut.userName = textBox3.Text;
ut.password = textBox4.Text;
//ut.role = textBox5.Text;
if (radioButton1.Checked)
{
ut.role = "admin";
}
else if (radioButton2.Checked)
{
ut.role = "staff";
}
else
{
MessageBox.Show("Role in not Selected!");
}
ut.DateEmployed = DateTime.Now;
ut.Salary = 0;
ut.Address = textBox8.Text;
ut.Phone = textBox9.Text;
ut.PicLink = picLoc;
ut.FullName = textBox2.Text;
ut.Status = "unapproved";
db.UserLogINs.InsertOnSubmit(ut);
db.SubmitChanges();
MessageBox.Show("Successfully Registed! \nWait For Admin Approval!");
}
else
{
MessageBox.Show("Username already exists!!");
}
}
else if (textBox3.Text == "" || textBox4.Text == "")
{
MessageBox.Show("Must Give A Name and Password!");
}
else if (textBox1.Text != textBox4.Text)
{
MessageBox.Show("Password Do not match!");
}
}
catch
{
MessageBox.Show("Invalid Input!");
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
DataClasses1DataContext db = new DataClasses1DataContext();
UserLogIN ut = new UserLogIN();
string uN = textBox1.Text;
string pass = textBox2.Text;
var q = from UserLogIN in db.UserLogINs
where UserLogIN.userName == uN && UserLogIN.password == pass && UserLogIN.Status == "valid"
select UserLogIN;
bool logIn = false;
foreach (var UserLogIN in q)
{
string qN = UserLogIN.userName;
string qP = UserLogIN.password;
if (qN == uN && pass == qP)
{
if (UserLogIN.role == "admin")
{
MessageBox.Show("Successfully Loggedin as Admin");
AdminPage fm = new AdminPage(UserLogIN.Id, this);
this.Visible = false;
fm.Show();
UserLogIN q22 = (from UserLogINn in db.UserLogINs
where UserLogINn.Id == UserLogIN.Id
select UserLogINn).Single();
q22.LastLoginTime = DateTime.Now;
db.SubmitChanges();
label3.Text = "You have been logged out!";
textBox1.Text = "";
textBox2.Text = "";
logIn = true;
break;
}
else if (UserLogIN.role == "staff")
{
MessageBox.Show("Successfully Loggedin as Staff");
SalesInfo fm = new SalesInfo(UserLogIN.Id, UserLogIN.userName, this);
this.Visible = false;
fm.Show();
UserLogIN q22 = (from UserLogINn in db.UserLogINs
where UserLogINn.Id == UserLogIN.Id
select UserLogINn).Single();
q22.LastLoginTime = DateTime.Now;
db.SubmitChanges();
label3.Text = "You have been logged out!";
logIn = true;
break;
}
}
}
if (!logIn)
{
label3.Text = "Username and password do not match";
}
}
catch
{
MessageBox.Show("Invalid Input!");
}
}
