private void SearchPeople_Click(object sender, RoutedEventArgs e)
{
DGR.ItemsSource = null;
using (var db = new ResourceModel())
{
DGR.ItemsSource = db.SeacrhPeople(TB_FirstName.Text, TB_LastName.Text, TB_MiddleName.Text, TB_PhoneVoIP.Text,
db.ConvertorObjectInInt(CB_Department.SelectedValue),
db.ConvertorObjectInInt(CB_Organization.SelectedValue),
db.ConvertorObjectInInt(CB_Position.SelectedValue));
}
}
private void SeacrhComputer_Click(object sender, RoutedEventArgs e)
{
DGR.ItemsSource = null;
using (var db = new ResourceModel())
{
DGR.ItemsSource = db.SeacrhComputer(TB_Indificator.Text,
TB_IP.Text, TB_Name.Text,
TB_Domen.Text,
db.ConvertorObjectInInt(CB_WorkingGroup.SelectedValue),
db.ConvertorObjectInInt(CB_People.SelectedValue));
}
}
private void EditResource_Click(object sender, RoutedEventArgs e)
{
using (var db = new ResourceModel())
{
MessageBox.Show(db.EditResource(db.ConvertorObjectInInt(DGR.SelectedValue),
TB_Title.Text,
Convert.ToDateTime(DT_DateStart.SelectedDate),
Convert.ToDateTime(DT_DateEnd.SelectedDate),
db.ConvertorObjectInInt(CB_People.SelectedValue)));
}
Update();
}
private void EditComputer_Click(object sender, RoutedEventArgs e)
{
using (var db = new ResourceModel())
{
MessageBox.Show(db.EditComputer(db.ConvertorObjectInInt(DGR.SelectedValue), TB_Indificator.Text,
TB_IP.Text,
TB_Description.Text,
TB_Name.Text, TB_Domen.Text,
db.ConvertorObjectInInt(CB_WorkingGroup.SelectedValue),
db.ConvertorObjectInInt(CB_People.SelectedValue)));
Update();
}
}
private void AddPeople_Click(object sender, RoutedEventArgs e)
{
using (var db = new ResourceModel())
{
MessageBox.Show(db.AddPeople(TB_FirstName.Text,
TB_LastName.Text,
TB_MiddleName.Text,
TB_Phone.Text,
TB_PhoneVoIP.Text,
db.ConvertorObjectInInt(CB_Department.SelectedValue),
db.ConvertorObjectInInt(CB_Organization.SelectedValue),
db.ConvertorObjectInInt(CB_Position.SelectedValue)));
}
Update();
}
private void ReportResourceInPeople_Click(object sender, RoutedEventArgs e)
{
using (var db = new ResourceModel())
{
MessageBox.Show(db.ReportResourceInPeople(db.ConvertorObjectInInt(CB_ReportPeople.SelectedValue)));
}
}
private void EditPosition_Click(object sender, RoutedEventArgs e)
{
using (var db = new ResourceModel())
{
MessageBox.Show(db.EditPosition(db.ConvertorObjectInInt(DGR.SelectedValue), TB_Title.Text));
}
Update();
}
private void RemoveComputer_Click(object sender, RoutedEventArgs e)
{
using (var db = new ResourceModel())
{
MessageBox.Show(db.RemoveComputer(db.ConvertorObjectInInt(DGR.SelectedValue)));
Update();
}
}
private void EditOrganization_Click(object sender, RoutedEventArgs e)
{
using (var Db = new ResourceModel())
{
MessageBox.Show(Db.EditDepartmentOrOrganization(Db.ConvertorObjectInInt(DGR.SelectedValue), TB_Title.Text, "Organization"));
Update();
}
}
private void RemoveOrganization_Click(object sender, RoutedEventArgs e)
{
using (var db = new ResourceModel())
{
MessageBox.Show(db.RemoveDepartmentOrOrganization(db.ConvertorObjectInInt(DGR.SelectedValue), "Organization"));
Update();
}
}
private void AddOperator_Click(object sender, RoutedEventArgs e)
{
using (var db = new ResourceModel())
{
MessageBox.Show(db.AddOperator(TB_Login.Text,
TB_Password.Text,
db.ConvertorObjectInInt(CB_People.SelectedValue),
Convert.ToString(CB_Status.SelectedItem)));
}
Update();
}
private void SeacrhResource_Click(object sender, RoutedEventArgs e)
{
DGR.ItemsSource = null;
using (var db = new ResourceModel())
{
DGR.ItemsSource = db.SearchResource(TB_Title.Text,
Convert.ToDateTime(DT_DateStart.SelectedDate),
Convert.ToDateTime(DT_DateEnd.SelectedDate),
db.ConvertorObjectInInt(CB_People.SelectedValue));
}
}
private void Decrypt_Click(object sender, RoutedEventArgs e)
{
List <AccountModel> accounts = new List <AccountModel>();
using (var db = new ResourceModel())
{
var acc = db.GetAccountInId(db.ConvertorObjectInInt(DGR_Accounts.SelectedValue));
foreach (var a in acc)
{
accounts.Add(new AccountModel()
{
AccountID = a.AccountID,
Login = a.Login,
Type_Account = a.Type_Account,
LastNamePeople = a.LastNamePeople,
Passwords = db.GetPasswordD(ID, a.Login)
});
}
}
DGR_Accounts.ItemsSource = null;
DGR_Accounts.ItemsSource = accounts;
}
