예제 #1
0
파일: Form1.cs 프로젝트: r-a-j/Dotnet
 void PopulateDataGridView()
 {
     using (MYDATAEntities db = new MYDATAEntities())
     {
         dgvCustomer.DataSource = db.Customers.ToList <Customer>();
     }
 }
예제 #2
0
파일: Form1.cs 프로젝트: r-a-j/Dotnet
        private void dgvCustomer_DoubleClick(object sender, EventArgs e)
        {
            if (dgvCustomer.CurrentRow.Index != -1)
            {
                model.CustomerID = Convert.ToInt32(dgvCustomer.CurrentRow.Cells["CustomerID"].Value);

                using (MYDATAEntities db = new MYDATAEntities())
                {
                    model             = db.Customers.Where(x => x.CustomerID == model.CustomerID).FirstOrDefault();
                    txtFirstName.Text = model.FirstName;
                    txtLastName.Text  = model.LastName;
                    txtCity.Text      = model.City;
                    txtAddress.Text   = model.Address;
                }
                btnSave.Text      = "Update";
                btnDelete.Enabled = true;
            }
        }
예제 #3
0
파일: Form1.cs 프로젝트: r-a-j/Dotnet
        private void btnDelete_Click(object sender, EventArgs e)
        {
            if (MessageBox.Show("Are You Shure ?", "EF CURD Operation", MessageBoxButtons.YesNo) == DialogResult.Yes)
            {
                using (MYDATAEntities db = new MYDATAEntities())
                {
                    var entry = db.Entry(model);

                    if (entry.State == EntityState.Detached)
                    {
                        db.Customers.Attach(model);
                    }
                    db.Customers.Remove(model);
                    db.SaveChanges();
                    PopulateDataGridView();
                    Clear();
                    MessageBox.Show("Deleted SuccessFully..!");
                }
            }
        }
예제 #4
0
파일: Form1.cs 프로젝트: r-a-j/Dotnet
        private void btnSave_Click(object sender, EventArgs e)
        {
            model.FirstName = txtFirstName.Text.Trim();
            model.LastName  = txtLastName.Text.Trim();
            model.City      = txtCity.Text.Trim();
            model.Address   = txtAddress.Text.Trim();

            using (MYDATAEntities db = new MYDATAEntities())
            {
                if (model.CustomerID == 0)
                {
                    db.Customers.Add(model);
                }
                else
                {
                    db.Entry(model).State = System.Data.Entity.EntityState.Modified;
                }
                db.SaveChanges();
            }
            Clear();
            PopulateDataGridView();
            MessageBox.Show("Saved Successfully...");
        }