Автоматизація надання послуг автосалоном

                        Environment.Exit(0);

                        break;

 

                        default:

                        MessageBox.Show("ОшибкаN:" + e.Number);

                        break;

                }

                       

            }

        return list;

    }

 

    public List<List<string>> SelectBySQL(string SQL)

    {

        string query = SQL;

 

        //Create a list to store the result

        List<List<string>> list = new List<List<string>>();

 

        //Open connection

        try

        {

            if (this.OpenConnection() == true)

            {

                //Create Command

                MySqlCommand cmd = new MySqlCommand(query, connection);

                //Create a data reader and Execute the command

                MySqlDataReader dataReader = cmd.ExecuteReader();

 

                for (int i = 0; i < dataReader.FieldCount; i++) list.Add(new List<string>());

 

                //Read the data and store them in the list

                while (dataReader.Read())

                {

                    for (int i = 0; i < dataReader.FieldCount; i++)

                    {

                        list[i].Add(dataReader[i] + "");

                    }

                }

 

                //close Data Reader

                dataReader.Close();

 

                //close Connection

                this.CloseConnection();

 

                //return list to be displayed

                return list;

            }

        }

        catch (MySqlException e)

        {

            switch (e.Number)

            {

 

                case 1146:

                    MessageBox.Show("Не существует таблицы");

                    Environment.Exit(0);

                    break;

 

                default:

                    MessageBox.Show("ОшибкаN:" + e.Number);

                    break;

            }

 

        }

        return list;

    }

 

    public List<string> SelectByID(int id)

    {

       

        string query = "SELECT * FROM autoinfo WHERE id="+id;

 

        //Create a list to store the result

        List<string> list = new List<string>();

 

        //Open connection

        if (this.OpenConnection() == true)

        {

            //Create Command

            MySqlCommand cmd = new MySqlCommand(query, connection);

            //Create a data reader and Execute the command

            MySqlDataReader dataReader = cmd.ExecuteReader();

 

            //Read the data and store them in the list

            while (dataReader.Read())

            {

                for (int i = 0; i < dataReader.FieldCount; i++)

                {

                    list.Add(dataReader[i] + "");

                }

            }

 

            //close Data Reader

            dataReader.Close();

 

            //close Connection

            this.CloseConnection();

 

            //return list to be displayed

            return list;

        }

        else

        {

            return list;

        }

    }

}

 

    static class keeper

    {

        public static string login="";

        public static string name = "";

        public static List<List<string>> autoinfo = new List<List<string>>();

        public static List<List<string>> listTXT = new List<List<string>>();

    }

}

 

 

C++

LoginForm.cpp

// LoginForm.cpp : implementation file

//

#include "stdafx.h"

#include "Program.h"

#include "LoginForm.h"

#include "afxdialogex.h"

#include "connector.h"

#include "Helper.h"

// CLoginForm dialog

 

IMPLEMENT_DYNAMIC(CLoginForm, CDialog)

 

CLoginForm::CLoginForm(CWnd* pParent /*=NULL*/) : CDialog(CLoginForm::IDD, pParent)

{

con = new Cconnector();

}

 

CLoginForm::~CLoginForm()

{

}

 

void CLoginForm::DoDataExchange(CDataExchange* pDX)

{

CDialog::DoDataExchange(pDX);

}

 

 

BEGIN_MESSAGE_MAP(CLoginForm, CDialog)

ON_BN_CLICKED(IDC_LOG_OK, &CLoginForm::OnLogOk)

 

END_MESSAGE_MAP()

 

 

// CLoginForm message handlers

 

 

BOOL CLoginForm::OnCommand(WPARAM wParam, LPARAM lParam)

{

int id_menu = LOWORD(wParam);

 

if (id_menu == 2) exit(0);

return CDialog::OnCommand(wParam, lParam);

}

 

 

void CLoginForm::OnLogOk()

{

_RecordsetPtr rset("ADODB.Recordset");

 

CString login, pass;

GetDlgItemText(ID_LOGIN_EDIT, login);

GetDlgItemText(ID_PASS_EDIT, pass);

 

rset = con->connection->Execute((_bstr_t)("select * from admins where login = '" + login + "' and pass = '" + pass + "'"), 0, 1);

 

if (rset->RecordCount == 0) AfxMessageBox("error");

else if (rset->RecordCount > 0)

{

Helper::globus = rset->GetFields()->GetItem(3L)->GetValue();

CDialog::OnOK();

}

}

UserListDialog.cpp

 

 

// userlistDialog.cpp : implementation file

//

 

#include "stdafx.h"

#include "Program.h"

#include "userlistDialog.h"

#include "afxdialogex.h"

#include "Helper.h"

 

// userlistDialog dialog

 

IMPLEMENT_DYNAMIC(userlistDialog, CDialog)

 

userlistDialog::userlistDialog(CWnd* pParent /*=NULL*/)

: CDialog(userlistDialog::IDD, pParent)

{

con = new Cconnector();

check = 0;

 

}

 

void userlistDialog::DoDataExchange(CDataExchange* pDX)

{

CDialog::DoDataExchange(pDX);

DDX_Control(pDX, IDC_DATAGRID1, dataUser);

DDX_Control(pDX, ID_DELETE, deleteButton);

DDX_Control(pDX, ID_ADD, addButton);

DDX_Control(pDX, IDC_EDIT1, loginEditBox);

DDX_Control(pDX, IDC_EDIT2, passEditBox);

DDX_Control(pDX, IDC_EDIT3, nameEditBox);

DDX_Control(pDX, IDC_LOGIN, loginStatic);

DDX_Control(pDX, IDC_PASS, passStatic);

DDX_Control(pDX, IDC_NAME, nameStatic);

}

 

 

BEGIN_MESSAGE_MAP(userlistDialog, CDialog)

ON_BN_CLICKED(ID_ADD, &userlistDialog::OnBnClickedAdd)

ON_BN_CLICKED(ID_DELETE, &userlistDialog::OnBnClickedDelete)

END_MESSAGE_MAP()

 

 

// userlistDialog message handlers

 

 

BOOL userlistDialog::OnInitDialog()

{

CDialog::OnInitDialog();

 

if(Helper::users) rset = con->connection->Execute("SELECT * FROM admins", 0, 1);

else{rset = con->connection->Execute("SELECT * FROM users", 0, 1);}

dataUser.SetRefDataSource(rset);

 

visible_check(check);

 

return TRUE;  // return TRUE unless you set the focus to a control

// EXCEPTION: OCX Property Pages should return FALSE

}

 

 

void userlistDialog::OnBnClickedAdd()

{

CString str1, str2, str3;

 

GetDlgItemText(IDC_EDIT1, str1);

GetDlgItemText(IDC_EDIT2, str2);

GetDlgItemText(IDC_EDIT3, str3);

 

if(check==1)

{

 

try

{

if(Helper::users)

con->connection->Execute((_bstr_t)("INSERT INTO admins values(NULL,'"+str1+"', '"+str2+"', '"+str3+"')") , 0, 1);

else{con->connection->Execute((_bstr_t)("INSERT INTO users values(NULL,'"+str1+"', '"+str2+"', '"+str3+"')") , 0, 1);}

}

catch(_com_error err)

{

con->ErrMessage(err);

return;

}

AfxMessageBox("Запись  успешно добавлена");

check=0;

}

else{check=1;}

 

this->OnInitDialog();

}

 

void userlistDialog::visible_check(bool check)

{

(CButton*)GetDlgItem(IDC_EDIT1)->ShowWindow(check);

(CButton*)GetDlgItem(IDC_EDIT2)->ShowWindow(check);

(CButton*)GetDlgItem(IDC_EDIT3)->ShowWindow(check);

 

(CStatic*)GetDlgItem(IDC_LOGIN)->ShowWindow(check);

(CStatic*)GetDlgItem(IDC_PASS)->ShowWindow(check);

(CStatic*)GetDlgItem(IDC_NAME)->ShowWindow(check);

 

}

void userlistDialog::OnBnClickedDelete()

{

CString str;

try

{

str = rset->GetFields()->GetItem(0L)->GetValue();

if(Helper::users) con->connection->Execute((_bstr_t)("DELETE FROM admins WHERE id='"+str+"'") , 0, 1);

else{con->connection->Execute((_bstr_t)("DELETE FROM users WHERE id='"+str+"'") , 0, 1);}

this->OnInitDialog();

}

catch(_com_error err)

{

con->ErrMessage(err);

return;

}

AfxMessageBox("Запись успешно удалена");

}