void SetDataOnDFirst()
{
using (session_1_dbDataContext db = new session_1_dbDataContext())
{
TimeOnSystem timeOnSystem = new TimeOnSystem();
timeOnSystem.Date = Constain.dateTimeLogin;
Constain.ID = (from u in db.TimeOnSystems select u).Count() + 1;
timeOnSystem.ID = Constain.ID;
timeOnSystem.Login = Constain.loginTime.ToShortTimeString();
timeOnSystem.Logout = null;
timeOnSystem.SumTime = null;
timeOnSystem.UserID = (from v in db.Users
where (v.Email == Constain.userName)
select v.ID).First();
db.TimeOnSystems.InsertOnSubmit(timeOnSystem);
try
{
db.SubmitChanges();
}
catch
{
}
}
}
private void btnConfirm_Click(object sender, EventArgs e)
{
using (session_1_dbDataContext db = new session_1_dbDataContext())
{
var query = (from u in db.TimeOnSystems where (u.ID == Login.index) select u).First();
if (rbSystem.Checked == true)
{
query.Reason = "Power outage";
}
else
{
query.Reason = "Hanging program";
}
try
{
db.SubmitChanges();
MessageBox.Show("Thanks for your respond!", "", MessageBoxButtons.OK, MessageBoxIcon.None);
}
catch
{
MessageBox.Show("Please try again later!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
this.Close();
}
void SetDataToDB()
{
using (session_1_dbDataContext db = new session_1_dbDataContext())
{
var query = (from u in db.TimeOnSystems
from v in db.Users
where (v.Email == Constain.userName && v.ID == u.UserID && u.ID == Constain.ID)
select u).First();
query.Logout = Constain.logoutTime.ToShortTimeString();
query.SumTime = SpentTime();
try
{
db.SubmitChanges();
}
catch
{
}
}
}
private void btnApply_Click(object sender, EventArgs e)
{
if (txtEmail.Text.ToString() == "" || txtFirstName.Text.ToString() == "" || txtLastName.Text.ToString() == "")
{
MessageBox.Show("You must input all information!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Stop);
}
else
{
using (session_1_dbDataContext db = new session_1_dbDataContext())
{
var query = (from u in db.Users where (u.ID == LoginMain.seletedIndex) select u).First();
query.Email = txtEmail.Text;
query.LastName = txtLastName.Text;
query.FirstName = txtFirstName.Text;
if (rdAdmin.Checked == true)
{
query.RoleID = 1;
}
else
{
query.RoleID = 2;
}
try
{
db.SubmitChanges();
MessageBox.Show("Changed successful!", "Notify", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch
{
MessageBox.Show("Changed unsuccessful! Try again later.", "Notify", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
}
private void btnEDLogin_Click(object sender, EventArgs e)
{
if (rowIndex != -1)
{
var getUN = (from ord in db.Users
where ord.Email == dtgvUser["EmailAddress", rowIndex].Value.ToString()
select ord).First();
if (getUN.Email != Constain.userName)
{
var val = dtgvUser["active", rowIndex].Value;
if (val.ToString() == "True")
{
dtgvUser["active", rowIndex].Value = false;
var query =
from ord in db.Users
where ord.Email == dtgvUser["EmailAddress", rowIndex].Value.ToString()
select ord;
// Execute the query, and change the column values
// you want to change.
//if (query.First().Email == Constain.userName)
foreach (var ord in query)
{
ord.Active = false;
// Insert any additional changes to column values.
}
// Submit the changes to the database.
try
{
db.SubmitChanges();
cbAllOffices_SelectedIndexChanged(sender, e);
dtgvUser.Rows[rowIndex].DefaultCellStyle.BackColor = Color.Red;
dtgvUser["active", rowIndex].Value = "False";
}
catch (Exception ex)
{
MessageBox.Show("Can't disable this account!", "", MessageBoxButtons.OK, MessageBoxIcon.Warning);
// Provide for exceptions.
}
}
else
{
var query =
from ord in db.Users
where ord.Email == dtgvUser["EmailAddress", rowIndex].Value.ToString()
select ord;
// Execute the query, and change the column values
// you want to change.
foreach (var ord in query)
{
ord.Active = true;
// Insert any additional changes to column values.
}
// Submit the changes to the database.
try
{
db.SubmitChanges();
cbAllOffices_SelectedIndexChanged(sender, e);
if (dtgvUser["UserRole", rowIndex].Value.ToString() == "office user")
{
dtgvUser.Rows[rowIndex].DefaultCellStyle.BackColor = Color.White;
}
else
{
dtgvUser.Rows[rowIndex].DefaultCellStyle.BackColor = Color.GreenYellow;
}
dtgvUser["active", rowIndex].Value = "True";
}
catch (Exception ex)
{
MessageBox.Show("Can't enable this account!", "", MessageBoxButtons.OK, MessageBoxIcon.Warning);
// Provide for exceptions.
}
}
}
else
{
MessageBox.Show("You can't change role yourself!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Stop);
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
int a = 0, b = 0, c = 0, d = 0, e1 = 0, f = 0, g = 0, h = 0;
string email = txtEmail.Text;
string firstName = txtFirstName.Text;
string lastName = txtLastName.Text;
string office = cbOffice.SelectedText;
//string date = txtDate.Text;
DateTime date;
DateTime.TryParseExact(txtDate.Text, "dd/MM/yy", null,
System.Globalization.DateTimeStyles.None, out date);
string pass = txtPassword.Text;
int temp = (from u in db.Users where (u.Email == email) select u).Count();
if (email == "")
{
txtEmail.Text = "* What's your email adress?";
txtEmail.ForeColor = Color.Red;
a = 1;
}
if (temp == 1)
{
txtEmail.Text = "* This email have been used!";
txtEmail.ForeColor = Color.Red;
b = 1;
}
if (firstName == "")
{
txtFirstName.Text = "* What's your first name?";
txtFirstName.ForeColor = Color.Red;
c = 1;
}
if (lastName == "")
{
txtLastName.Text = "* What's your last name?";
txtLastName.ForeColor = Color.Red;
d = 1;
}
if (pass == "")
{
txtPassword.UseSystemPasswordChar = false;
txtPassword.Text = "* Input your password!?";
txtPassword.ForeColor = Color.Red;
e1 = 1;
}
if (date == null)
{
txtPassword.Text = "* Input your password!?";
txtPassword.ForeColor = Color.Red;
f = 1;
}
if (cbOffice.Text == "Office name" || cbOffice.Text == "")
{
cbOffice.ForeColor = Color.Red;
cbOffice.Text = "* Choose your office name correctly!";
g = 1;
}
if (txtDate.Text == "[ dd/MM/yy ]" || txtDate.Text == "")
{
txtDate.Text = "* Input your birthday!";
txtDate.ForeColor = Color.Red;
h = 1;
}
if (txtEmail.Text == "* What's your email adress?" ||
txtEmail.Text == "* This email have been used!" ||
txtFirstName.Text == "* What's your first name?" ||
txtLastName.Text == "* What's your last name?" ||
txtPassword.Text == "* Input your password!?" ||
cbOffice.Text == "* Choose your office name correctly!" ||
txtDate.Text == "* Input your birthday!")
{
MessageBox.Show("You must input all information!", "Notify", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
if (a == 0 && b == 0 && c == 0 && d == 0 && e1 == 0 && f == 0 && g == 0 && h == 0)
{
using (session_1_dbDataContext db = new session_1_dbDataContext())
{
User user = new User();
user.Email = email;
user.Birthdate = date;
user.Active = true;
user.FirstName = firstName;
user.LastName = lastName;
int idx = cbOffice.SelectedIndex;
if (idx < 1)
{
idx += 1;
}
else
{
idx += 2;
}
user.OfficeID = idx;
user.Password = GenerateMD5(pass);
user.RoleID = 2;
user.ID = (from u in db.Users select(u)).Count() + 1;
db.Users.InsertOnSubmit(user);
try
{
db.SubmitChanges();
MessageBox.Show("Added successfuly!", "Notify", MessageBoxButtons.OK, MessageBoxIcon.Information);
LoadData();
LoginMain loginMain = new LoginMain();
loginMain.LoadData();
}
catch (Exception ex)
{
MessageBox.Show("Can't add this account!\n" + ex.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
else
{
return;
}
}