private int Company_From_DB(OleDbConnection CRM_DB_Conn, string sLogin) { int iReturn = 0; try { CRM_DB_Conn.Open(); //MessageBox.Show("Успешно подключено к базе данных:\n" + connectionString); string queryString = ""; queryString = "SELECT Company_Protected.Comp_ID, Company_Protected.Comp_Name, City.City_Name, Company_Protected.Comp_Adress, Company_Protected.Comp_Website, Company_Protected.Comp_Email, Company_Protected.Comp_Contact_Telephone, Company_Protected.Comp_Additional_Info, " + "Company_Protected.Comp_ID_City FROM City INNER JOIN Company_Protected ON City.City_ID = Company_Protected.Comp_ID_City"; //" '" + sLogin + "'"; OleDbCommand Cmd = new OleDbCommand(queryString, CRM_DB_Conn); //MessageBox.Show(Cmd.CommandText); OleDbDataReader Dr = Cmd.ExecuteReader(); //MessageBox.Show("Получено Fields = " + Dr.FieldCount + "; Rows = " + Dr.HasRows); while (Dr.Read()) { Company_Protected Comp = new Company_Protected(); //= MainWindow.MyUser.User_CompanyList.Last(); Comp.Comp_Name = Dr["Comp_Name"].ToString(); Comp.Comp_Website = Dr["Comp_Website"].ToString(); Comp.Comp_Adress = Dr["Comp_Adress"].ToString(); Comp.Comp_Contact_Telephone = Dr["Comp_Contact_Telephone"].ToString(); Comp.City_Name = Dr["City_Name"].ToString(); Comp.Comp_Email = Dr["Comp_Email"].ToString(); Comp.Comp_Additional_Info = Dr["Comp_Additional_Info"].ToString(); Comp.Comp_ID_City = Dr["Comp_ID_City"].ToString(); Comp.Comp_ID = Dr["Comp_ID"].ToString(); Comp.Company_PersonList = new List <Person>(); Comp.Company_ContactList = new List <Contact>(); Comp.Company_EquipmentList = new List <Equipment>(); MainWindow.MyUser.User_CompanyList.Add(Comp); int iRes = Person_From_DB(CRM_DB_Conn, Comp); if (iRes == 0) { MessageBox.Show("У компании\n" + Comp.Comp_Name + "\n не найдены контактные лица"); } iReturn++; } Dr.Close(); } catch (Exception ex) { MessageBox.Show("Нет подключения к базе данных:\n\n\n" + ex.ToString(), "Application Error"); } finally { CRM_DB_Conn.Close(); } return(iReturn); }
private void Button_Delete_Click(object sender, RoutedEventArgs e) { Company_Protected CurComp = (Company_Protected)Company_listView.SelectedItem; if (MessageBox.Show("Будет удалена компания: " + CurComp.Comp_Name + "\nВы уверены?", "Удаление компании", MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.Yes) { MainWindow.MyUser.User_CompanyList.Remove(CurComp); ClearControls(); } }
private void Company_listView_SelectionChanged(object sender, SelectionChangedEventArgs e) { if (Company_listView.SelectedItem != null) { Company_Protected CurComp = (Company_Protected)Company_listView.SelectedItem; Comp_ID.Text = CurComp.Comp_ID; // Код компании-клиента Comp_Name.Text = CurComp.Comp_Name; // Наименование компании-клиента Comp_Website.Text = CurComp.Comp_Website; // Website компании-клиента Comp_Email.Text = CurComp.Comp_Email; //Comp_ID_City.Text = Comp_ID_City.Comp_Email; // код города City_Name.Text = CurComp.City_Name; //наименование города Comp_Adress.Text = CurComp.Comp_Adress; // адрес компании Comp_Contact_Telephone.Text = CurComp.Comp_Contact_Telephone; //контактный телефон Comp_Additional_Info.Text = CurComp.Comp_Additional_Info; // краткое описание this.isChanged = false; } //else MessageBox.Show("No item selected !"); }
private void Button_Save_Click(object sender, RoutedEventArgs e) { Company_Protected CurComp = (Company_Protected)Company_listView.SelectedItem; if (this.isChanged) { if (MessageBox.Show("В запись о компании: " + CurComp.Comp_Name + "\nвнесены изменения. Вы хотите их сохранить?", "Запись изменена", MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.Yes) { CurComp.Comp_ID = Comp_ID.Text; CurComp.Comp_Name = Comp_Name.Text; CurComp.City_Name = City_Name.Text; //наименование города CurComp.Comp_Adress = Comp_Adress.Text; // адрес компании CurComp.Comp_Contact_Telephone = Comp_Contact_Telephone.Text; //контактный телефон CurComp.Comp_Email = Comp_Email.Text; CurComp.Comp_Additional_Info = Comp_Additional_Info.Text; // краткое описание ClearControls(); } } }
private int Person_From_DB(OleDbConnection CRM_DB_Conn, Company_Protected Comp) { int iReturn = 0; try { //CRM_DB_Conn.Open(); //MessageBox.Show("Успешно подключено к базе данных:\n" + connectionString); string queryString = ""; queryString = "SELECT Person.Person_ID, Person.Person_FIO, Person.Person_Position, Person.Person_Company_ID " + " FROM Person WHERE Person_Company_ID = " + Comp.Comp_ID.ToString(); OleDbCommand Cmd = new OleDbCommand(queryString, CRM_DB_Conn); //MessageBox.Show(Cmd.CommandText); OleDbDataReader Dr = Cmd.ExecuteReader(); //MessageBox.Show("Получено Fields = " + Dr.FieldCount + "; Rows = " + Dr.HasRows); while (Dr.Read()) { Comp.Company_PersonList.Add(new Person() { Person_ID = Dr["Person_ID"].ToString(), Person_FIO = Dr["Person_FIO"].ToString(), Person_Position = Dr["Person_Position"].ToString(), Comp_ID = Dr["Person_Company_ID"].ToString() }); //MessageBox.Show("Получено Person_ID = " + Dr["Person_ID"].ToString() + "; Person_FIO = " + Dr["Person_FIO"].ToString()); iReturn++; } Dr.Close(); } catch (Exception ex) { MessageBox.Show("Нет подключения к базе данных:\n\n\n" + ex.ToString(), "Application Error"); } finally { //CRM_DB_Conn.Close(); } return(iReturn); }