private void gridView2_CustomUnboundColumnData(object sender, DevExpress.XtraGrid.Views.Base.CustomColumnDataEventArgs e) { if (e.Column.FieldName == "Over" && e.IsGetData) { CARRATES val = (CARRATES)e.Row; if (!string.IsNullOrWhiteSpace(val.CODE) && !string.IsNullOrWhiteSpace(val.AGENCY) && !string.IsNullOrWhiteSpace(val.CAT) && val.START_DATE != null && val.END_DATE != null && val.ID != 0) { var load = from c in context.CARRATES where c.CODE == val.CODE && c.AGENCY == val.AGENCY && c.CAT == val.CAT select new { c.START_DATE, c.END_DATE }; // foreach (var rec in load) { DateTime start = (DateTime)val.START_DATE; DateTime end = (DateTime)val.END_DATE; DateTime existStart = (DateTime)rec.START_DATE; DateTime existEnd = (DateTime)rec.END_DATE; if (!checkOverlap(start, end, existStart, existEnd)) { e.Value = true; } else { e.Value = false; } } } } }
private void PurgeButton_Click(object sender, EventArgs e) { if (gridView1.SelectedRowsCount == 0) { MessageBox.Show("Please select at least one row before attempting to purge records."); return; } List <int> values = new List <int>(); foreach (int val in gridView1.GetSelectedRows()) { values.Add((int)gridView1.GetRowCellValue(val, "ID")); } foreach (int ID in values) { CARRATES rec = (from hratRec in context.CARRATES where hratRec.ID == ID select hratRec).FirstOrDefault(); context.CARRATES.DeleteObject(rec); context.SaveChanges(); } }