public static void Refresh(LicenseEntity db) { var context = ((IObjectContextAdapter)db).ObjectContext; var refreshableObjects = db.ChangeTracker.Entries().Select(c => c.Entity).ToList(); context.Refresh(RefreshMode.StoreWins, refreshableObjects); }
private void Bwfetch_DoWork(object sender, DoWorkEventArgs e) { LicenseEntity licdb = new LicenseEntity(); var IDCheck = licdb.Licenses.Where(c => c.SoftwareID == txtonSoftId.Text).FirstOrDefault(); if (IDCheck != null) { owner = IDCheck.OwnerName; school = IDCheck.SchoolName; email = IDCheck.SchoolEmail; contact = IDCheck.SchoolContact; installdate = IDCheck.IstallationDate; licstarts = IDCheck.LicenseStarts; licend = IDCheck.LicenseEnds; Op = true; } else { Op = false; } }
private void Bwsave_DoWork(object sender, DoWorkEventArgs e) { licdb = new LicenseEntity(); var det = licdb.Licenses.Where(c => c.SoftwareID == txtonSoftId.Text).FirstOrDefault(); det.LicenseStarts = DateTime.Now.ToString("dd/MM/yyyy"); det.IsPayment = true; det.InProcess = false; if (radioButtonDays.Checked) { if (txtOnDays.Text != "") { int days = Convert.ToInt32(txtOnDays.Text); if (days >= 1 && days <= 30) { det.LicenseEnds = DateTime.Now.AddDays(days).ToString("dd/MM/yyyy"); licdb.Entry(det).State = System.Data.Entity.EntityState.Modified; UpgradeOnline(); } else { MessageBox.Show("Please enter days between 1 to 30!", "License Management System", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } } else { MessageBox.Show("Please Enter a days!", "License Management System", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } } if (radioButtonMonths.Checked) { if (txtonMonths.Text != "") { int months = Convert.ToInt32(txtonMonths.Text); if (months >= 1 && months <= 12) { det.LicenseEnds = DateTime.Now.AddMonths(months).ToString("dd/MM/yyyy"); licdb.Entry(det).State = System.Data.Entity.EntityState.Modified; UpgradeOnline(); } else { MessageBox.Show("Please enter months between 1 to 12!", "License Management System", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } } else { MessageBox.Show("Please Enter a months!", "License Management System", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } } if (radioButtonYears.Checked) { if (txtOnyears.Text != "") { int years = Convert.ToInt32(txtOnyears.Text); if (years >= 1 && years <= 5) { det.LicenseEnds = DateTime.Now.AddYears(years).ToString("dd/MM/yyyy"); licdb.Entry(det).State = System.Data.Entity.EntityState.Modified; UpgradeOnline(); } else { MessageBox.Show("Please enter years between 1 to 5!", "License Management System", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } } else { MessageBox.Show("Please Enter a Year(s)!", "License Management System", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } } }