private void btnRemoveProject_Click(object sender, RoutedEventArgs e)
{
try
{
string project = projectTest[3].TrimStart(' ');
MessageBoxResult result = MessageBox.Show($"Вы точно уверены, что хотите удалить проект {projectTest[3].TrimStart(' ')}?", "Delete", MessageBoxButton.YesNo);
if (result == MessageBoxResult.Yes)
{
using (llblanca_lara1Entities db = new llblanca_lara1Entities())
{
projects proj = db.projects.Where(p => p.name == project).FirstOrDefault();
var tas = (from t in db.tasks
where t.project_id == proj.id
select t).ToList();
if (tas != null)
{
db.tasks.RemoveRange(tas);
db.SaveChanges();
}
db.projects.Remove(proj);
db.SaveChanges();
MessageBox.Show($"Project {projectTest[3].TrimStart(' ')} is delete");
FillingFromDBProjects(db);
}
}
else
{
return;
}
}
catch (Exception ex)
{
}
}
private void GV_MouseLeftButtonUp(object sender, MouseButtonEventArgs e)
{
DataGrid dg = sender as DataGrid;
_dr = dg.SelectedItem.ToString();
test = _dr.Split(new char[4] {
'=', ',', '{', '}'
}, StringSplitOptions.RemoveEmptyEntries);
nameBeChange = test[3].TrimStart(' ');
txtName.Text = test[3].TrimStart(' ');
txtEmail.Text = test[5].TrimStart(' ');
using (llblanca_lara1Entities db = new llblanca_lara1Entities())
{
users user = db.users.Where(u => u.name == nameBeChange).FirstOrDefault();
role_user r_u = db.role_user.Where(u => u.user_id == user.id).FirstOrDefault();
roles role = db.roles.Where(r => r.id == r_u.role_id).FirstOrDefault();
var contacts = db.contacts.Join(db.contact_types, t => t.type_id, c => c.id, (t, c) => new {
value = t.value,
type = c.contact_type,
t.user_id
}).Where(r => r.user_id == user.id).Select(p => p.type + ": " + p.value);
cmbRoles.ItemsSource = db.roles.Select(r => r.display_name).ToList();
cmbRoles.SelectedItem = db.roles.Where(u => u.display_name == role.display_name).FirstOrDefault().display_name;
role_in_dataGrid = db.roles.Where(u => u.display_name == role.display_name).FirstOrDefault().display_name;
lstContacts.ItemsSource = contacts.ToList();
FillingFromDBProjects(db);
}
}
private void FillingFromDB()
{
using (llblanca_lara1Entities db = new llblanca_lara1Entities())
{
var users = from u in db.users
select new
{
Id = u.id,
Name = u.name,
Email = u.email,
Status = u.status,
Created = u.created_at,
Updated = u.updated_at,
Password = u.password
};
var roles = from u in db.roles
select new
{
Id = u.id,
Name = u.name,
DisplayName = u.display_name,
Description = u.description,
Created = u.created_at,
Updated = u.updated_at
};
gv_users.ItemsSource = users.ToList();
gv_roles.ItemsSource = roles.ToList();
}
}
private void btnRemoveTask_Click(object sender, RoutedEventArgs e)
{
try
{
int taskId = Convert.ToInt32(taskTest[1].TrimStart(' '));
MessageBoxResult result = MessageBox.Show($"Вы точно уверены, что хотите удалить проект {taskTest[3].TrimStart(' ')}?", "Delete", MessageBoxButton.YesNo);
if (result == MessageBoxResult.Yes)
{
using (llblanca_lara1Entities db = new llblanca_lara1Entities())
{
tasks t = db.tasks.Where(p => p.id == taskId).FirstOrDefault();
task_user tas = db.task_user.Where(ts => ts.id_task == t.id).FirstOrDefault();
if (tas != null)
{
db.task_user.Remove(tas);
db.SaveChanges();
}
db.tasks.Remove(t);
db.SaveChanges();
MessageBox.Show($"Task {taskTest[3].TrimStart(' ')} is delete");
}
}
else
{
return;
}
}
catch (Exception ex)
{
MessageBox.Show("Task is not selected");
}
}
private void btnStart_Click(object sender, RoutedEventArgs e)
{
using (llblanca_lara1Entities db = new llblanca_lara1Entities())
{
tasks task = new tasks
{
project_id = _projectId,
name = txtName.Text,
description = txtDescription.Text,
created_at = DateTime.Now,
status = txtStatus.Text,
start = Convert.ToDateTime(txtStart.Text),
end = Convert.ToDateTime(txtEnd.Text)
};
try
{
db.tasks.Add(task);
db.SaveChanges();
task_user taskUser = new task_user()
{
created_at = DateTime.Now,
id_task = task.id,
id_user = _userId
};
db.task_user.Add(taskUser);
db.SaveChanges();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
this.Close();
}
private void btnStart_Click(object sender, RoutedEventArgs e)
{
using (llblanca_lara1Entities db = new llblanca_lara1Entities())
{
projects project = new projects
{
client_id = _id,
name = txtName.Text,
description = txtDescription.Text,
created_at = DateTime.Now,
status = txtStatus.Text,
//project_manager_id = cmbManagers.SelectedIndex + 1
project_manager_id = 9
};
try
{
db.projects.Add(project);
db.SaveChanges();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
this.Close();
}
private void btnStart_Click(object sender, RoutedEventArgs e)
{
using (llblanca_lara1Entities db = new llblanca_lara1Entities())
{
int id = Convert.ToInt32(_roleTest[1].TrimStart(' '));
roles role = db.roles.Where(u => u.id == id).FirstOrDefault();
db.roles.Attach(role);
db.Entry(role).State = EntityState.Modified;
db.SaveChanges();
role.name = txtName.Text;
role.display_name = txtDisplayName.Text;
role.description = txtDescription.Text;
role.updated_at = DateTime.Now;
try
{
db.roles.Add(role);
MessageBox.Show($"Role {role.name} is update");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
this.Close();
}
public Add()
{
InitializeComponent();
using (llblanca_lara1Entities db = new llblanca_lara1Entities())
{
cmbRoles.ItemsSource = db.roles.Select(role => role.display_name).ToList();
}
}
public AddContact(int id)
{
InitializeComponent();
_id = id;
using (llblanca_lara1Entities db = new llblanca_lara1Entities())
{
var type = from u in db.contact_types
select new
{
Id = u.id,
Type = u.contact_type
};
cmbType.ItemsSource = type.Select(role => role.Type).ToList();
}
}
private void btnUsers_Delete_Click(object sender, RoutedEventArgs e)
{
string temp = test[3].TrimStart(' ');
MessageBoxResult result = MessageBox.Show($"Вы точно уверены, что хотите удалить user {temp}?", "Delete", MessageBoxButton.YesNo);
if (result == MessageBoxResult.Yes)
{
using (llblanca_lara1Entities db = new llblanca_lara1Entities())
{
users user = db.users.Where(u => u.name == temp).FirstOrDefault();
var project = (from phone in db.projects
where phone.client_id == user.id
select phone).ToList();
if (project != null)
{
foreach (projects p in project)
{
var tas = (from t in db.tasks
where t.project_id == p.id
select t).ToList();
if (tas != null)
{
db.tasks.RemoveRange(tas);
db.SaveChanges();
}
}
db.projects.RemoveRange(project);
db.SaveChanges();
}
var contact = (from c in db.contacts
where c.user_id == user.id
select c).ToList();
if (contact != null)
{
db.contacts.RemoveRange(contact);
db.SaveChanges();
}
db.users.Remove(user);
db.SaveChanges();
MessageBox.Show($"User {temp} is delete");
FillingFromDB();
}
}
else
{
return;
}
}
private void roles_Delete_Click(object sender, RoutedEventArgs e)
{
string temp = roleTest[3].TrimStart(' ');
MessageBoxResult result = MessageBox.Show($"Вы точно уверены, что хотите удалить role {temp}?", "Delete", MessageBoxButton.YesNo);
if (result == MessageBoxResult.Yes)
{
using (llblanca_lara1Entities db = new llblanca_lara1Entities())
{
roles role = db.roles.Where(u => u.name == temp).FirstOrDefault();
db.roles.Remove(role);
db.SaveChanges();
MessageBox.Show($"Role {temp} is delete");
FillingFromDB();
}
}
}
public Add(int id)
{
InitializeComponent();
_id = id;
using (llblanca_lara1Entities db = new llblanca_lara1Entities())
{
var users = from u in db.users
join u_r in db.role_user on u.id equals u_r.user_id
join r in db.roles on u_r.role_id equals r.id
where r.display_name == "ProjectMan Role"
select new
{
Manager = u.name
};
cmbManagers.ItemsSource = users.Select(role => role.Manager).ToList();
}
}
private void FillingFromDBProjects(llblanca_lara1Entities db)
{
var projects = from project in db.projects
join users in db.users on project.client_id equals users.id
join managers in db.users on project.project_manager_id equals managers.id
where users.name == txtName.Text
select new
{
Id = project.id,
Project = project.name,
Status = project.status,
Description = project.description,
Manager = managers.name
};
dg_UsersProjects.ItemsSource = projects.ToList();
}
private void btnAddProject_Click(object sender, RoutedEventArgs e)
{
try
{
int Id = Convert.ToInt32(test[1].TrimStart(' '));
Admin.Windows.Projects.Add form = new Admin.Windows.Projects.Add(Id);
form.ShowDialog();
using (llblanca_lara1Entities db = new llblanca_lara1Entities())
{
FillingFromDBProjects(db);
}
}
catch (Exception msg)
{
MessageBox.Show("User is not selected");
}
}
private void fillingFromDBTasks(llblanca_lara1Entities db, projects project)
{
var tasks = from task in db.tasks
where task.project_id == project.id
select new
{
Id = task.id,
Name = task.name,
Description = task.description,
Project_id = task.project_id,
Start = task.start,
End = task.end,
Status = task.status,
Created = task.created_at,
Updated = task.updated_at
};
dg_UsersTasks.ItemsSource = tasks.ToList();
}
private void GV_ProjectMouseLeftButtonUp(object sender, MouseButtonEventArgs e)
{
DataGrid dg = sender as DataGrid;
if (dg.SelectedItem == null)
{
return;
}
_dr = dg.SelectedItem.ToString();
projectTest = _dr.Split(new char[4] {
'=', ',', '{', '}'
}, StringSplitOptions.RemoveEmptyEntries);
string proj = projectTest[3].TrimStart(' ');
using (llblanca_lara1Entities db = new llblanca_lara1Entities())
{
projects project = db.projects.Where(u => u.name == proj).FirstOrDefault();
fillingFromDBTasks(db, project);
}
}
private void btnStart_Click(object sender, RoutedEventArgs e)
{
using (llblanca_lara1Entities db = new llblanca_lara1Entities())
{
contacts contact = new contacts
{
value = txtContact.Text,
user_id = _id,
type_id = cmbType.SelectedIndex + 1
};
try
{
db.contacts.Add(contact);
db.SaveChanges();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
this.Close();
}
private void btnStart_Click(object sender, RoutedEventArgs e)
{
using (llblanca_lara1Entities db = new llblanca_lara1Entities())
{
if (txtPassword.Password != txtCPassword.Password)
{
MessageBox.Show("Passwords do not match!");
return;
}
users user = new users
{
name = txtName.Text,
email = txtEmail.Text,
password = txtPassword.Password,
status = "active",
remember_token = "",
created_at = DateTime.Now
};
try
{
db.users.Add(user);
db.SaveChanges();
int id = user.id;
role_user r_u = new role_user()
{
role_id = cmbRoles.SelectedIndex + 1,
user_id = id
};
db.role_user.Add(r_u);
db.SaveChanges();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
this.Close();
}
private void btnStart_Click(object sender, RoutedEventArgs e)
{
using (llblanca_lara1Entities db = new llblanca_lara1Entities())
{
roles role = new roles
{
name = txtName.Text,
display_name = txtDisplayName.Text,
description = txtDescription.Text,
created_at = DateTime.Now
};
try
{
db.roles.Add(role);
db.SaveChanges();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
this.Close();
}
private void btnRemoveContact_Click(object sender, RoutedEventArgs e)
{
try
{
string value = lstContacts.SelectedValue.ToString().Split(':')[1].TrimStart(' ');
MessageBoxResult result = MessageBox.Show($"Вы точно уверены, что хотите удалить Contact {value}?", "Delete", MessageBoxButton.YesNo);
if (result == MessageBoxResult.Yes)
{
using (llblanca_lara1Entities db = new llblanca_lara1Entities())
{
contacts contact = db.contacts.Where(c => c.value == value).FirstOrDefault();
db.contacts.Remove(contact);
db.SaveChanges();
MessageBox.Show($"Contact {contact} is delete");
FillingFromDB();
}
}
}
catch (Exception ex)
{
MessageBox.Show("Contact is not selected");
}
}
private void btnEdit_Click(object sender, RoutedEventArgs e)
{
string name = String.Empty;
try
{
using (llblanca_lara1Entities db = new llblanca_lara1Entities())
{
users user = db.users.Where(u => u.name == nameBeChange).FirstOrDefault();
db.users.Attach(user);
db.Entry(user).State = EntityState.Modified;
db.SaveChanges();
name = user.name;
user.name = txtName.Text;
user.email = txtEmail.Text;
user.updated_at = DateTime.Now;
user.password = txtPassword.Password;
roles role = db.roles.Where(r => r.display_name == role_in_dataGrid).FirstOrDefault();
role_user r_u = db.role_user.Where(u => u.user_id == user.id).Where(r => r.role_id == role.id).FirstOrDefault();
db.role_user.Attach(r_u);
db.Entry(r_u).State = EntityState.Modified;
db.SaveChanges();
r_u.user_id = user.id;
r_u.role_id = cmbRoles.SelectedIndex + 1;
db.users.Add(user);
db.role_user.Add(r_u);
}
MessageBox.Show($"User {name} is update");
FillingFromDB();
}
catch (Exception ex)
{
MessageBox.Show("User is not selected");
}
}
