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