예제 #1
0
        private void BDeleteRecords_Click(object sender, EventArgs e)
        {
            tBExtId.Clear();
            tBEditExt.Clear();

            using (var db = new ExtensionContext())
            {
                var query = from c in db.ExtensionDB

                            select new { c.ListId };

                if (query.ToList().Count >= 1)
                {
                    foreach (var item in query)
                    {
                        using (var dbx = new ExtensionContext())
                        {
                            int x      = Convert.ToInt32(item.ListId.ToString());
                            var delete = new ListExtension.List {
                                ListId = x
                            };
                            dbx.ExtensionDB.Attach(delete);
                            dbx.ExtensionDB.Remove(delete);
                            dbx.SaveChanges();
                        }
                    }
                }
                RefleshDataGrid();
            }
        }
예제 #2
0
 private void BAddExt_Click(object sender, EventArgs e)
 {
     using (var db = new ExtensionContext())
     {
         var Record = new ListExtension.List {
             Extension = tBAddExt.Text.Trim()
         };
         db.ExtensionDB.Add(Record);
         db.SaveChanges();
     }
     RefleshDataGrid();
 }