protected void LoadROGraph(string selectedDepartment, DateTime From, DateTime To) { List <string> departmentcode = new List <string>(); var context = new LogicUniversityEntities(); var result = context.requisition_order.Where(x => (x.requisition_status == "Approved") && (x.requisition_date >= From) && (x.requisition_date <= To)).ToList(); foreach (requisition_order dept in result) { departmentcode.Add(dept.requisition_id.Substring(0, 4)); } var query = departmentcode.GroupBy(s => s).Select(g => new { Dept = g.Key, Count = g.Count() }); Series series = getROBasedDepartmentAndTime.Series["Series1"]; Departments.ClearSelection(); foreach (var r in query) { if ((r.Count != 0) && (selectedDepartment.Contains(r.Dept))) { Departments.Items.FindByValue(r.Dept).Selected = true; series.Points.AddXY(r.Dept, r.Count); } } if (getROBasedDepartmentAndTime != null) { ErrorMSg.Visible = false; } else { ErrorMSg.Text = "Please make other selection"; } }