private void showInfo()
{
listBox.Items.Clear();
using (CompAndUsersEntities context = new CompAndUsersEntities())
{
foreach (Companies company in context.Companies)
{
listBox.Items.Add(company.Name);
}
}
}
private void button3_Click(object sender, RoutedEventArgs e)
{
if (textBox6.Text != null && comboBox.SelectedItem != null)
{
using (CompAndUsersEntities context = new CompAndUsersEntities())
{
Companies company = new Companies();
company.Name = textBox6.Text;
company.ContractStatus = comboBox.SelectedIndex;
context.Companies.Add(company);
context.SaveChanges();
}
}
}
private void button2_Click(object sender, RoutedEventArgs e)
{
if (textBox1.Text != null)
{
using (CompAndUsersEntities context = new CompAndUsersEntities())
{
int deleteId = Convert.ToInt32(textBox1.Text);
Users removeUser = context.Users.FirstOrDefault(r => r.Id == deleteId);
if (removeUser != null)
{
context.Users.Remove(removeUser);
context.SaveChanges();
}
}
}
}
private void button_Click(object sender, RoutedEventArgs e)
{
if (textBox.Text != null && textBox2.Text != null && textBox3.Text != null && textBox4.Text != null)
{
using (CompAndUsersEntities context = new CompAndUsersEntities())
{
Users user = new Users();
user.Name = textBox.Text;
user.Login = textBox2.Text;
user.Password = textBox3.Text;
user.CompanyID = Convert.ToInt32(textBox4.Text);
context.Users.Add(user);
context.SaveChanges();
}
}
}
private void button4_Click(object sender, RoutedEventArgs e)
{
if (textBox6.Text != null && textBox5.Text != null && comboBox.SelectedItem != null)
{
using (CompAndUsersEntities context = new CompAndUsersEntities())
{
Companies company = new Companies();
company.Name = textBox6.Text;
company.ContractStatus = (int)comboBox.SelectedIndex;
company.Id = Convert.ToInt32(textBox5.Text);
context.Companies.AddOrUpdate(company);
context.SaveChanges();
}
}
showInfo();
}
private void button7_Click(object sender, RoutedEventArgs e)
{
string index = listBox.SelectedItem.ToString();
listBox1.Items.Clear();
using (CompAndUsersEntities context = new CompAndUsersEntities())
{
Companies company = context.Companies.FirstOrDefault(c => c.Name == index);
label.Content = "Company ID " + company.Id;
ContractStatus cs = (ContractStatus)company.ContractStatus;
label2.Content = "Contract " + cs.ToString();
var users = context.Users.Where(u => u.CompanyID == company.Id);
foreach (Users user in users)
{
listBox1.Items.Add(user.Id + " " + user.Name + " " + user.Login + " " + user.Password);
}
}
}
private void button1_Click(object sender, RoutedEventArgs e)
{
using (CompAndUsersEntities context = new CompAndUsersEntities())
{
int id = Convert.ToInt32(textBox4.Text);
if (textBox.Text != null && textBox2.Text != null && textBox3.Text != null && textBox4.Text != null &&
textBox4.Text != null && context.Companies.FirstOrDefault(c => c.Id == id) != null)
{
Users user = new Users();
user.Name = textBox.Text;
user.Login = textBox2.Text;
user.Password = textBox3.Text;
user.CompanyID = id;
user.Id = Convert.ToInt32(textBox1.Text);
context.Users.AddOrUpdate(user);
context.SaveChanges();
}
}
}
private void button5_Click(object sender, RoutedEventArgs e)
{
if (textBox5.Text != null)
{
using (CompAndUsersEntities context = new CompAndUsersEntities())
{
int deleteId = Convert.ToInt32(textBox5.Text);
Companies removeCompany = context.Companies.FirstOrDefault(r => r.Id == deleteId);
if (removeCompany != null)
{
context.Companies.Remove(removeCompany);
var removeUsers = context.Users.Where(u => u.CompanyID == deleteId);
foreach (Users removeUser in removeUsers)
{
context.Users.Remove(removeUser);
}
context.SaveChanges();
}
}
showInfo();
}
}
