public override void PopulateData() { try { string FromPostCode = null; string ToPostCode = null; int FromLocId = 0; int ToLocId = 0; int FromZoneId = 0; int ToZoneId = 0; if (rbtnPostCode.IsChecked == true) { string PostCode = txtPostCode.Text.Trim(); if (string.IsNullOrEmpty(PostCode)) { ENUtils.ShowMessage("Requierd : Post Code"); return; } if (rbtnPickup.IsChecked == true) { FromPostCode = PostCode; } else if (rbtnDestination.IsChecked == true) { ToPostCode = PostCode; } else { FromPostCode = PostCode; ToPostCode = PostCode; } } else if (rbtnLocation.IsChecked == true) { int LocationId = ddlLocation.SelectedValue.ToInt(); if (LocationId == 0) { ENUtils.ShowMessage("Requierd : Loaction Code"); return; } if (rbtnPickup.IsChecked == true) { FromLocId = LocationId; } else if (rbtnDestination.IsChecked == true) { ToLocId = LocationId; } else { ToLocId = LocationId; FromLocId = LocationId; } } else { int ZoneId = ddlArea.SelectedValue.ToInt(); if (ZoneId == 0) { ENUtils.ShowMessage("Requierd : Area Code"); return; } if (rbtnPickup.IsChecked == true) { FromZoneId = ZoneId; } else if (rbtnDestination.IsChecked == true) { ToZoneId = ZoneId; } else { FromZoneId = ZoneId; ToZoneId = ZoneId; } } using (TaxiDataContext db = new TaxiDataContext()) { var list = db.stp_JobStatistics(FromPostCode, ToPostCode, FromLocId, ToLocId, FromZoneId, ToZoneId, fromDate.Value.ToDate(), tillDate.Value.ToDate()).ToList(); if (list.Count() > 0) { grdJobsStatistics.Columns.Clear(); grdJobsStatistics.DataSource = list; grdJobsStatistics.Columns["BookingNo"].Width = 150; grdJobsStatistics.Columns["PickupDateTime"].Width = 145; grdJobsStatistics.Columns["VehicleType"].Width = 130; grdJobsStatistics.Columns["FromAddress"].Width = 280; grdJobsStatistics.Columns["ToAddress"].Width = 280; grdJobsStatistics.Columns["DriverName"].Width = 130; grdJobsStatistics.Columns["StatusName"].Width = 130; grdJobsStatistics.Columns["BookingNo"].HeaderText = "Booking No"; grdJobsStatistics.Columns["PickupDateTime"].HeaderText = "Pickup Date Time"; grdJobsStatistics.Columns["VehicleType"].HeaderText = "Vehicle Type"; grdJobsStatistics.Columns["FromAddress"].HeaderText = "From Address"; grdJobsStatistics.Columns["ToAddress"].HeaderText = "To Address"; grdJobsStatistics.Columns["DriverName"].HeaderText = "Driver Name"; grdJobsStatistics.Columns["StatusName"].HeaderText = "Status"; } else { grdJobsStatistics.Columns.Clear(); grdJobsStatistics.Rows.Clear(); FormatGrid(); } lblTotalJobs.Text = "Total Jobs : " + grdJobsStatistics.Rows.Count(); } } catch (Exception ex) { ENUtils.ShowMessage(ex.Message); } }