private void InsertOrUpdateUser(user user)
{
var id = user.userId;
using (var db = new TimetableContext())
{
if (db.users.Any(u => u.userId == id))
{
db.users.Attach(user);
db.Entry(user).State = System.Data.Entity.EntityState.Modified;
}
else
{
if (db.users.Where(u => u.username == user.username).FirstOrDefault() == null)
{
db.users.Add(user);
}
else
{
MessageBox.Show("Vartotojas vardu \"" + user.username + "\" jau yra");
}
}
db.SaveChanges();
}
}
private void saveInPercentage()
{
var obj = new object[dataGridView2.Rows.Count, dataGridView2.Rows[0].Cells.Count];
for (int i = 0; i < dataGridView2.Rows.Count; i++)
{
for (int j = 0; j < dataGridView2.Rows[i].Cells.Count; j++)
{
obj[i, j] = dataGridView2.Rows[i].Cells[j].Value;
}
}
using (var db = new TimetableContext())
{
for (int i = 0; i < obj.Length / obj.GetLength(0) && obj[i, 0] != null; i++)
{
var username = (string)obj[i, 0];
if (i < branchUsers.Count)
{
InsertOrUpdateUser(new user {
username = (string)obj[i, 0], password = (string)obj[i, 0], userType = 0, branchId = currBranchId, userId = branchUsers[i].userId
});
}
else
{
maxUserId += 1;
InsertOrUpdateUser(new user {
username = (string)obj[i, 0], password = (string)obj[i, 0], userType = 0, branchId = currBranchId, userId = maxUserId
});
}
for (int j = 0; j < 6; j++)
{
var branch = branches[j].branchId;
var user = db.users.Where(u => u.username == username).FirstOrDefault();
var temp = (String)obj[i, j + 1];
temp = temp.Substring(0, temp.Length - 1);
var time = System.Convert.ToInt32(temp);
time = (int)Math.Round((double)time * 1.68);
if (db.timetables.Any(t => t.branchId == branch && t.userId == user.userId))
{
var any = db.timetables.Where(t => t.branchId == branch && t.userId == user.userId).FirstOrDefault().timetableId;
InsertOrUpdateTimetable((string)obj[i, 0], currBranchId, new timetable {
branchId = branch, userId = user.userId, time = time, timetableId = any
});
}
else
{
maxTimeId += 1;
InsertOrUpdateTimetable((string)obj[i, 0], currBranchId, new timetable {
branchId = branch, userId = user.userId, time = time, timetableId = maxTimeId
});
}
}
}
}
DrawInPercentage();
}
private void UserHome_Load(object sender, EventArgs e)
{
dataGridView2.ReadOnly = true;
using (var db = new TimetableContext())
{
var branches = db.branches.ToList();
for (int i = 0; i < branches.Count; i++)
{
dataGridView2.Columns[i + 1].HeaderText = branches[i].branchname;
}
var user = db.users.Where(u => u.userId == Login.userId).FirstOrDefault();
int totalTime = 0;
DataGridViewRow row = (DataGridViewRow)dataGridView2.Rows[0].Clone();
row.Cells[0].Value = user.username;
for (int j = 0; j < branches.Count; j++)
{
var currBranchId = branches[j].branchId;
var currUserId = user.userId;
var time = db.timetables.Where(t => t.userId == currUserId && t.branchId == currBranchId).FirstOrDefault();
row.Cells[j + 1].Value = time != null ? time.time + "h": 0 + "h";
totalTime += time != null ? time.time : 0;
}
row.Cells[7].Value = totalTime + "h";
dataGridView2.Rows.Add(row);
}
}
private void InsertOrUpdateTimetable(string username, int branchId, timetable time)
{
using (var db = new TimetableContext())
{
var id = time.timetableId;
if (db.timetables.Any(t => t.timetableId == id))
{
db.timetables.Attach(time);
db.Entry(time).State = System.Data.Entity.EntityState.Modified;
}
else
{
db.timetables.Add(time);
}
db.SaveChanges();
}
}
private void DrawInPercentage()
{
dataGridView2.Rows.Clear();
dataGridView2.Refresh();
using (var db = new TimetableContext())
{
maxTimeId = db.timetables.Max(t => t.timetableId);
maxUserId = db.users.Max(u => u.userId);
branches = db.branches.ToList();
for (int i = 0; i < branches.Count; i++)
{
dataGridView2.Columns[i + 1].HeaderText = branches[i].branchname;
}
var currentBranch = db.users.Where(u => u.userId == Login.userId).FirstOrDefault().branchId;
currBranchId = currentBranch;
var users = db.users.Where(u => u.branchId == currentBranch &&
u.userType != db.users.Where(us => us.userId == Login.userId).FirstOrDefault().userType
).ToList();
branchUsers = users;
for (int i = 0; i < users.Count; i++)
{
int totalTime = 0;
DataGridViewRow row = (DataGridViewRow)dataGridView2.Rows[0].Clone();
row.Cells[0].Value = users[i].username;
for (int j = 0; j < branches.Count; j++)
{
var currBranchId = branches[j].branchId;
var currUserId = users[i].userId;
var time = db.timetables.Where(t => t.userId == currUserId && t.branchId == currBranchId).FirstOrDefault();
row.Cells[j + 1].Value = time != null?Math.Round((double)time.time / 168 * 100) + "%" : 0 + "%";
totalTime += time != null ? time.time : 0;
}
row.Cells[7].Value = Math.Round((double)totalTime / 168 * 100) + "%";
dataGridView2.Rows.Add(row);
}
//var userTimes = db.
// row.Cells[ 1].Value = branches[0].branchname;
//dataGridView2.Rows.Add(row);
grid = dataGridView2;
}
}
private void button1_Click(object sender, EventArgs e)
{
if (txt_Username.Text == "" || txt_Password.Text == "")
{
MessageBox.Show("Please enter username and password.");
return;
}
using (var db = new TimetableContext())
{
var contains = db.users.Where(u => u.username == txt_Username.Text).FirstOrDefault();
if (contains == null)
{
MessageBox.Show("No user with this name");
}
else
{
if (contains.password == txt_Password.Text)
{
MessageBox.Show("Logged in successfully.");
this.Hide();
if (contains.userType == 1)
{
this.Hide();
userId = contains.userId;
ManagerHome home = new ManagerHome();
home.Show();
}
else
{
this.Hide();
userId = contains.userId;
UserHome home = new UserHome();
home.Show();
}
}
else
{
MessageBox.Show("Wrong password.");
return;
}
}
}
}
