private void FillgirdViewExamDetail(int uid) { _datatable = new DataTable(); _datatable = _baexmmng.SelectExamDetail("GetExWithUid", txtSearch.Text, uid); gvExamDetail.DataSource = _datatable; gvExamDetail.DataBind(); }
private void FillchkboxListExamgGroup(int catid, int mid) { selectedGroup = chkExamCodeListGroup.Items.Cast <ListItem>().Where(li => li.Selected).ToList(); unselectedGroup = chkExamCodeListGroup.Items.Cast <ListItem>().Where(li => !li.Selected).ToList(); if (selectedGroup.Count > 0) { if (setcurrentitemGroup != null) { foreach (ListItem listItem in selectedGroup) { if (!setcurrentitemGroup.Contains(listItem.Value)) { setcurrentitemGroup.Add(listItem.Value); } } foreach (ListItem listItem in unselectedGroup) { if (setcurrentitemGroup.Contains(listItem.Value)) { setcurrentitemGroup.Remove(listItem.Value); } } } } BAExamManage _baexmmng = new BAExamManage(); DataTable _datatable1 = new DataTable(); _datatable1 = _baexmmng.SelectExamDetail("GetExamWithMId", mid, ""); _datatable1.Columns.Add("FullName", typeof(string), "ExamCode + ' (' + SecondCategoryName +')'"); if (catid > 0) { var rows = _datatable1.AsEnumerable().Where(row => row.Field <int>("SecondCategoryId") == catid).ToList(); if (rows.Any()) { _datatable1 = rows.CopyToDataTable(); } else { _datatable1 = _datatable1.Clone(); } } chkExamCodeListGroup.DataValueField = "ExamCodeId"; chkExamCodeListGroup.DataTextField = "FullName"; chkExamCodeListGroup.DataSource = _datatable1; chkExamCodeListGroup.DataBind(); if (setcurrentitemGroup != null) { for (int i = 0; i < chkExamCodeListGroup.Items.Count; i++) { chkExamCodeListGroup.Items[i].Selected = false; for (int x = 0; x < setcurrentitemGroup.Count; x++) { if (chkExamCodeListGroup.Items[i].Value == setcurrentitemGroup[x]) { chkExamCodeListGroup.Items[i].Selected = true; } } } } }
private void FillgridViewExamDetail(string eventtext, int Merchantid) { _datatable = new DataTable(); _datatable = _baexmmng.SelectExamDetail(eventtext, Merchantid, ""); gvExamDetail.DataSource = _datatable; gvExamDetail.DataBind(); }
private void FillgridViewExamDetail(string eventtext, int Merchantid, string searchtext) { BAExamManage _baexmmng = new BAExamManage(); DataTable _datatable = new DataTable(); _datatable = _baexmmng.SelectExamDetail(eventtext, Merchantid, searchtext); //BASalesReports _baslsrpt = new BASalesReports(); //DataTable _datatable = new DataTable(); //_datatable = _baslsrpt.SelectSalesReprotsWithMrid(eventtext, Merchantid); gvExamDetail.DataSource = _datatable; gvExamDetail.DataBind(); }
private void FillgridViewExamDetail(int merid) { try { DataTable _datatable = new DataTable(); _datatable = _baexmmng.SelectExamDetail("GetExamWithMId", merid, ""); gvExamDetail.DataSource = _datatable; gvExamDetail.DataBind(); } catch (Exception ex) { Common.LogError(ex); ShowMessage("Some technical error", MessageType.Warning); } }
private void BindFileListBox() { List <TodoItem> _exsitingExamlist = new List <TodoItem>(); String[] files = null; if (Directory.Exists(Common.UserDataFolder)) { // var allowedExtensions = new[] { ".doc", ".docx" }; var allowedExtensions = new[] { ".vcee" }; var filesss = Directory .GetFiles(Common.UserDataFolder) .Where(file => allowedExtensions.Any(file.ToLower().EndsWith)) .ToList(); files = filesss.ToArray(); } if (files != null) { foreach (var item in files) { _exsitingExamlist.Add(new TodoItem() { Title = System.IO.Path.GetFileNameWithoutExtension(item), Path = item }); } } List <BOExamManage> _boexammng = new List <BOExamManage>(); _boexammng = _baexmmng.SelectExamDetail("GetExWithUid", _bouser.UserId); // _boexammng = _baexmmng.SelectExamDetail("GetExWithUid", 3); List <UserExamList> _userExamlist = new List <UserExamList>(); for (int i = 0; i < _boexammng.Count; i++) { var data = _exsitingExamlist.Where(x => x.Title.Contains(_boexammng[i].SecondCategory + " " + _boexammng[i].ExamCode)); if (data.Any()) { _userExamlist.Add(new UserExamList { CategoryName = _boexammng[i].SecondCategory, ExamCodeList = new List <ExamCodelist>() { new ExamCodelist { ExamCodeId = _boexammng[i].ExamCodeId, ExamCode = _boexammng[i].ExamCode, Title = data.FirstOrDefault().Title, Path = data.FirstOrDefault().Path, IsActive = true, Examtime = _boexammng[i].TestTime } } }); } else { _userExamlist.Add(new UserExamList { CategoryName = _boexammng[i].SecondCategory, ExamCodeList = new List <ExamCodelist>() { new ExamCodelist { ExamCodeId = _boexammng[i].ExamCodeId, ExamCode = _boexammng[i].ExamCode, Title = "", Path = "", IsActive = false, Examtime = _boexammng[i].TestTime } } }); } } var _userExamFileList = from p in _userExamlist group p.ExamCodeList by p.CategoryName into g select new { SecondCategory = g.Key, ExamCodeList = g.ToList() }; // listFile.ItemsSource = _userExamFileList; //treeview.Items.Clear(); treeview.ItemsSource = _userExamFileList; }