Exemplo n.º 1
0
        private void EditContact(object sender, EventArgs e)
        {
            Models.DatabaseContext oDatabaseContext = null;
            try
            {
                oDatabaseContext = new Models.DatabaseContext();

                //Find Row of Selected Cell and Find Guid Of This Row (Guid Column is Number 4 Column. That is Hidden)
                //By These info We Can Find Record in Database And Call its Info into Our Fields
                //Then After Edit Info Refresh Grid And Empty Fields
                //***********************************************************************************
                int           row       = dataGridView.CurrentCell.RowIndex;
                string        cellIndex = dataGridView.Rows[row].Cells[4].Value.ToString();
                Guid          guid      = new Guid(cellIndex);
                Models.Person p1        = oDatabaseContext.People.Where(current => current.Id == guid).FirstOrDefault();
                p1.Name   = NameTextbox.Text;
                p1.Family = FamilyTextbox.Text;
                p1.Email  = EmailTextbox.Text;
                p1.Phone  = PhoneTextbox.Text;
                if (p1.Name == string.Empty)
                {
                    MessageBox.Show("Name Can not Be Empty");
                }
                else
                {
                    oDatabaseContext.SaveChanges();

                    //Clear Grid For Call New Info
                    dataGridView.Rows.Clear();
                    dataGridView.Refresh();
                    NameTextbox.Text   = string.Empty;
                    FamilyTextbox.Text = string.Empty;
                    PhoneTextbox.Text  = string.Empty;
                    EmailTextbox.Text  = string.Empty;
                    var contacts = oDatabaseContext.People.Where(current => current.Id != null).OrderBy(c => c.Name).ToList();
                    for (int i = 0; i < contacts.Count(); i++)
                    {
                        //Add Row In Grid
                        this.dataGridView.Rows.Add(contacts[i].Name, contacts[i].Family, contacts[i].Phone, contacts[i].Email, contacts[i].Id);
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            finally
            {
                if (oDatabaseContext != null)
                {
                    oDatabaseContext.Dispose();
                    oDatabaseContext = null;
                }
            }
        }
Exemplo n.º 2
0
        private void AddContact(object sender, EventArgs e)
        {
            Models.DatabaseContext oDatabaseContext = null;
            try
            {
                oDatabaseContext = new Models.DatabaseContext();

                //Get Info Of Fields And Add These Into Database And Empty Fields
                //Then Clear And Refresh Grid For Call New Info
                //***********************************************************************************
                Models.Person p1 = new Models.Person();
                p1.Id     = Guid.NewGuid();
                p1.Name   = NameTextbox.Text;
                p1.Family = FamilyTextbox.Text;
                p1.Email  = EmailTextbox.Text;
                p1.Phone  = PhoneTextbox.Text;
                if (p1.Name == string.Empty)
                {
                    MessageBox.Show("Name Can not Be Empty");
                }
                else
                {
                    oDatabaseContext.People.Add(p1);
                    oDatabaseContext.SaveChanges();

                    //Clear Grid For Call New Info
                    dataGridView.Rows.Clear();
                    dataGridView.Refresh();
                    NameTextbox.Text   = string.Empty;
                    FamilyTextbox.Text = string.Empty;
                    PhoneTextbox.Text  = string.Empty;
                    EmailTextbox.Text  = string.Empty;
                    var contacts = oDatabaseContext.People.Where(current => current.Id != null).OrderBy(c => c.Name).ToList();
                    for (int i = 0; i < contacts.Count(); i++)
                    {
                        //Add Row In Grid
                        this.dataGridView.Rows.Add(contacts[i].Name, contacts[i].Family, contacts[i].Phone, contacts[i].Email, contacts[i].Id);
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            finally
            {
                if (oDatabaseContext != null)
                {
                    oDatabaseContext.Dispose();
                    oDatabaseContext = null;
                }
            }
        }