private void gridView2_CustomUnboundColumnData(object sender, CustomColumnDataEventArgs e) { if (e.Column.FieldName == "Over" && e.IsGetData) { CPRATES val = (CPRATES)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.CPRATES where c.CODE == val.CODE && c.AGENCY == val.AGENCY && c.CAT == val.CAT && c.Inactive == val.Inactive select new { c.START_DATE, c.END_DATE, c.ResDate_Start, c.ResDate_End }; // 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)) { DateTime resStart = new DateTime(); DateTime resEnd = new DateTime(); DateTime resStartExist = new DateTime(); DateTime resEndExist = new DateTime(); if (val.ResDate_Start != null) { resStart = (DateTime)val.ResDate_Start; } if (val.ResDate_End != null) { resEnd = (DateTime)val.ResDate_End; } if (rec.ResDate_Start != null) { resStartExist = (DateTime)rec.ResDate_Start; } if (rec.ResDate_End != null) { resEndExist = (DateTime)rec.ResDate_End; } if (!checkOverlap(resStart, resEnd, resStartExist, resEndExist)) { e.Value = true; } else { e.Value = false; } } } } } }
private void PurgeButton_Click(object sender, EventArgs e) { if (GridViewLoad.SelectedRowsCount == 0) { MessageBox.Show("Please select at least one row before attempting to purge records."); return; } if (MessageBox.Show("Are you sure you want to purge the selected ratesheets ?", "CONFIRM", MessageBoxButtons.YesNo) == DialogResult.Yes) { List <int> values = new List <int>(); foreach (int val in GridViewLoad.GetSelectedRows()) { values.Add((int)GridViewLoad.GetRowCellValue(val, "ID")); } foreach (int ID in values) { CPRATES rec = (from hratRec in context.CPRATES where hratRec.ID == ID select hratRec).FirstOrDefault(); context.CPRATES.DeleteObject(rec); context.SaveChanges(); } } }