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 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 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");
}
}
