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