コード例 #1
0
        public ClientAddressForm(int _id)
        {
            id = _id;
            InitializeComponent();
            BLAddress bLAddress = new BLAddress();

            dataGridClientAddress.DataSource = bLAddress.Address(id);
            BLClient     bLClient = new BLClient();
            ClientModule client   = new ClientModule();

            client = bLClient.GetClientList(id, "", "", "", "", "")[0];

            txtClientName.Text    = client.ClientName;
            txtClientSurname.Text = client.ClientSurname;
            txtClientCode.Text    = client.ClientCode;
            txtEmail.Text         = client.Email;
            txtPhoneNo.Text       = client.PhoneNo;

            dataGridClientAddress.Columns["ClientId"].Visible        = false;
            dataGridClientAddress.Columns["ClientAddressId"].Visible = false;
            dataGridClientAddress.Columns["ClientName"].Visible      = false;
            dataGridClientAddress.Columns["ClientSurname"].Visible   = false;
            dataGridClientAddress.Columns["CityName"].HeaderText     = "Oras";
            dataGridClientAddress.Columns["CountyName"].HeaderText   = "Judet";
            dataGridClientAddress.Columns["StreetName"].HeaderText   = "Nume Strada";
            dataGridClientAddress.Columns["StreetNo"].HeaderText     = "Numar Strada";
            dataGridClientAddress.Columns["status"].Visible          = false;

            dataGridClientAddress.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
        }
コード例 #2
0
        private void BtnFilterPartner_Click(object sender, EventArgs e)
        {
            lblMessage.Text = "Selectati un client pentru a modifica sau sterge.\n" +
                              "Pentru a vedea, modifica sau sterge adresa, dublu click perandul clientului ";
            string clientName    = txtClientName.Text;
            string clientSurname = txtClientSurname.Text;
            string clientCode    = txtClientCode.Text;
            string phoneNo       = txtPhoneNo.Text;
            string email         = txtEmail.Text;
            //int id = null;
            BLClient            bLGetClient = new BLClient();
            List <ClientModule> list        = bLGetClient.GetClientList(-1, clientName, clientSurname, clientCode, phoneNo, email);

            if (list.Count == 0)
            {
                MessageBox.Show("Nu sunt inregistrari cu parametrii introdusi!!!", "Eroare", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }

            dataGridClient.DataSource = list;

            dataGridClient.Columns["ClientId"].Visible         = false;
            dataGridClient.Columns["ClientName"].HeaderText    = "Nume Client";
            dataGridClient.Columns["ClientSurname"].HeaderText = "Prenume Client";
            dataGridClient.Columns["PhoneNo"].HeaderText       = "Numar de telefon";
            dataGridClient.Columns["Email"].HeaderText         = "Email";

            dataGridClient.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;

            dataGridClient.RowHeaderMouseDoubleClick += DataGridClient_RowHeaderMouseDoubleClick;
            //dataGridClient.RowHeaderMouseClick += DataGridClient_RowHeaderMouseClick;
            //dataGridClient.SelectedRows[0].Cells[0].Value;
            //dataGridClient.Columns.GetFirstColumn.Hide();
        }
コード例 #3
0
        //private void BtnModify_Click(object sender, EventArgs e)
        //{
        //    if (dataGridClient.SelectedRows.Count == 0)
        //    {
        //        MessageBox.Show("Trebuie sa selectati un client.");
        //        return;
        //    }

        //    else
        //    {
        //        ClientModule client = (ClientModule)dataGridClient.SelectedRows[0].DataBoundItem;
        //        UpdateClientForm updateClientForm = new UpdateClientForm(client.ClientId);
        //        updateClientForm.Show();
        //        this.Hide();
        //        updateClientForm.FormClosed += UpdateClientForm_FormClosed;

        //    }


        //}

        //private void UpdateClientForm_FormClosed(object sender, FormClosedEventArgs e)
        //{
        //    this.Close();
        //}

        private void BtnDelete_Click(object sender, EventArgs e)
        {
            if (dataGridClient.SelectedRows.Count == 0)
            {
                MessageBox.Show("Trebuie sa selectati un client.");
                return;
            }
            BLClient     bLClient = new BLClient();
            ClientModule client   = (ClientModule)dataGridClient.SelectedRows[0].DataBoundItem;

            //UpdateClientForm updateClientForm = new UpdateClientForm(client.ClientId);
            if (MessageBox.Show("Sunteti sigur ca vreiti sa stergeti clientul " + client.ClientName + " " + client.ClientSurname + "?", "Mesaj de avertizare!", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
            {
                bLClient.DeleteClient(client.ClientId);
                MessageBox.Show(client.ClientName + " " + client.ClientSurname + " a fost sters cu succes.");
                List <ClientModule> list = bLClient.GetClientList(-1, "", "", "", "", "");
                dataGridClient.DataSource = list;
            }
            else
            {
                return;
            }
        }
コード例 #4
0
        public void Save(int id)
        {
            BLClient bl = new BLClient();

            if (id != 0)
            {
                List <ClientModule> listUpdate = bl.GetClientList(id, "", "", "", "", "");
                ClientModule        client     = listUpdate[0];
                string clientName    = txtClientName.Text;
                string clientSurname = txtClientSurname.Text;
                string clientCode    = txtClientCode.Text;
                string email         = txtEmail.Text;
                string phoneNo       = txtPhoneNo.Text;

                if (!(clientName == client.ClientName & clientSurname == client.ClientSurname & clientCode == client.ClientCode & email == client.Email & phoneNo == client.PhoneNo))
                {
                    foreach (char c in txtPhoneNo.Text.ToCharArray())
                    {
                        if (!(c == '0' || c == '1' || c == '2' || c == '3' || c == '4' || c == '5' || c == '6' || c == '7' || c == '8' || c == '9'))
                        {
                            MessageBox.Show("Tnumarul de telefon trebuie sa contina doar cife.", "Eroare", MessageBoxButtons.OK, MessageBoxIcon.Error);
                            return;
                        }
                    }
                    if (!(new EmailAddressAttribute().IsValid(txtEmail.Text)) & !String.IsNullOrWhiteSpace(txtEmail.Text))
                    {
                        MessageBox.Show("Emailul trebuie sa fie valid!", "Eroare", MessageBoxButtons.OK, MessageBoxIcon.Error);
                        return;
                    }


                    //txtClientCode.TextChanged
                    bool status = false;
                    if (clientCode == client.ClientCode)
                    {
                        bl.UpdateClient(id, clientName, clientSurname, "", phoneNo, email, out status);
                    }
                    else
                    {
                        bl.UpdateClient(id, clientName, clientSurname, clientCode, phoneNo, email, out status);
                    }
                    //BLClient bl = new BLClient();

                    if (status)
                    {
                        MessageBox.Show("Modificare reusita.");
                    }
                    else
                    {
                        MessageBox.Show("Codul de client exista deja!");
                        return;
                    }
                }



                BLAddress bLAddress = new BLAddress();
                //List<AddressModel> list= new List<AddressModel>();
                //list = bLAddress.Address(id);
                for (int i = 0; i < dataGridClientAddress.Rows.Count; i++)
                {
                    AddressModel addressModel = new AddressModel();
                    addressModel = (AddressModel)dataGridClientAddress.Rows[i].DataBoundItem;
                    if (addressModel.status == 1)
                    {
                        bLAddress.AddAddress(id, addressModel.CityName, addressModel.CountyName, addressModel.StreetName, addressModel.StreetNo);
                    }
                    //INSERT
                    if (addressModel.status == 2)
                    {
                        bLAddress.UpdateAddress(id, addressModel.ClientAddressId, addressModel.CityName, addressModel.CountyName, addressModel.StreetName, addressModel.StreetNo);
                    }



                    //UPDATE
                    if (addressModel.status == 3)
                    {
                        bLAddress.DeleteAddress(addressModel.ClientId, addressModel.ClientAddressId);
                    }
                }
            }
            else
            {
                if (String.IsNullOrWhiteSpace(txtClientName.Text))
                {
                    MessageBox.Show("Numele clientului este obligatoriu", "Eroare", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    return;
                }
                if (String.IsNullOrWhiteSpace(txtClientSurname.Text))
                {
                    MessageBox.Show("Prenumele utilizatorului eate obligatoriu", "Eroare", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    return;
                }
                if (String.IsNullOrWhiteSpace(txtClientCode.Text))
                {
                    MessageBox.Show("codul de client este obligatoriu", "Eroare", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    return;
                }

                foreach (char c in txtPhoneNo.Text.ToCharArray())
                {
                    if (!(c == '0' || c == '1' || c == '2' || c == '3' || c == '4' || c == '5' || c == '6' || c == '7' || c == '8' || c == '9'))
                    {
                        MessageBox.Show("Numarul de telefon trebuie sa contina doar cife.", "Eroare", MessageBoxButtons.OK, MessageBoxIcon.Error);
                        return;
                    }
                }
                if (!(new EmailAddressAttribute().IsValid(txtEmail.Text)) & !String.IsNullOrWhiteSpace(txtEmail.Text))
                {
                    MessageBox.Show("Emailul trebuie sa fie valid!", "Eroare", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    return;
                }

                string clientName    = txtClientName.Text;
                string clientSurname = txtClientSurname.Text;
                string clientCode    = txtClientCode.Text;
                string phoneNo       = String.IsNullOrWhiteSpace(txtPhoneNo.Text) ? null : txtPhoneNo.Text;
                string email         = String.IsNullOrWhiteSpace(txtEmail.Text) ? null : txtEmail.Text;;
                bool   status        = true;

                bl.AddClient(clientName, clientSurname, clientCode, phoneNo, email, out status);
                if (status)
                {
                    MessageBox.Show("Clientul " + clientName + " " + clientSurname + " a fost adaugat cu succes");
                    List <ClientModule> list = bl.GetClientList(-1, "", "", clientCode, "", "");
                    Save(list[0].ClientId);//RECURSIVITATE
                }
                //MessageBox.Show("Clientul " + clientName + " " + clientSurname + " a fost adaugat cu succes");
                else
                {
                    MessageBox.Show("Codul de client exista deja!");
                }
            }
        }