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();
}
}
