public ActionResult GetSectors(int?page, int?sortColumnIndex, int?sortDirection, string searchText) { ManageSectorModel SectorModel = new ManageSectorModel(); SearchAttributes searchParam = new SearchAttributes(); searchParam.CurrentPageNumber = (page.HasValue && page.Value > 0) ? page.Value : 1; searchParam.RecordsPerPage = AppSettingsUtility.GetInt(AppSettingsKeys.RecordsPerPage); searchParam.SortColumnIndex = (sortColumnIndex.HasValue && sortColumnIndex.Value > 0) ? sortColumnIndex.Value : 1; searchParam.SortDirection = (sortDirection.HasValue && sortDirection.Value == 1) ? Entity.SortDirection.Descending : Entity.SortDirection.Ascending; if (!string.IsNullOrEmpty(searchText)) { searchParam.SearchText = searchText; } SectorModel.SearchParam = searchParam; SectorModel.GetAllSector(searchParam); //for Ajax Specific Request if (Request.IsAjaxRequest()) { return(View("~/Views/Shared/PartialViews/Admin/Sector/_SectorList.cshtml", SectorModel)); } else { return(View("~/Views/Admin/Sector/SectorList.cshtml", SectorModel)); } }
/// <summary> /// Get Records By Search Param /// </summary> /// <param name="searchParam"></param> /// <returns></returns> public static List <Record> GetRecords(SearchAttributes searchParam, Guid langID) { IEnumerable <Record> records; List <Record> lstRecord = new List <Record>(); using (var context = new TSMContext()) { records = context.Records.Include("Record_Languages").Where(r => r.IsDeleted == false); if (!string.IsNullOrEmpty(searchParam.SearchText)) { string searchText = searchParam.SearchText.ToLower(); records = records.Where(rl => rl.Record_Languages[0].Name.ToLower().Contains(searchText)); } switch (searchParam.SortColumnIndex) { case 1: records = searchParam.SortDirection == SortDirection.Ascending ? records.OrderBy(r => r.Record_Languages[0].Name) : records.OrderByDescending(r => r.Record_Languages[0].Name); break; } searchParam.TotalRecordCount = records.Count(); searchParam.TotalPages = (int)Math.Ceiling((double)searchParam.TotalRecordCount / searchParam.RecordsPerPage); return(records.Skip((searchParam.CurrentPageNumber - 1) * searchParam.RecordsPerPage) .Take(searchParam.RecordsPerPage).ToList()); } }
/// <summary> /// Get Variable By Search Param and Language /// </summary> /// <param name="searchParam"></param> /// <param name="LanguageId"></param> /// <returns></returns> public static List <Variable> GetVariables(SearchAttributes searchParam, Guid LanguageId) { List <Variable> lstVariables = new List <Variable>(); using (var context = new TSMContext()) { lstVariables = context.Variables.Include("Variable_Languages").Where(c => c.IsDeleted == false).ToList(); if (!string.IsNullOrEmpty(searchParam.SearchText)) { string searchText = searchParam.SearchText.ToLower(); lstVariables = lstVariables.Where(u => (u.Variable_Languages[0].Name.ToLower().Contains(searchText)) || (u.Variable_Languages[0].DisplayName.ToLower().Contains(searchText))).ToList(); } switch (searchParam.SortColumnIndex) { case 1: lstVariables = searchParam.SortDirection == SortDirection.Ascending ? lstVariables.OrderBy(u => u.Variable_Languages[0].Name).ToList() : lstVariables.OrderByDescending(u => u.Variable_Languages[0].Name).ToList(); break; case 2: lstVariables = searchParam.SortDirection == SortDirection.Ascending ? lstVariables.OrderBy(u => u.Variable_Languages[0].DisplayName).ToList() : lstVariables.OrderByDescending(u => u.Variable_Languages[0].DisplayName).ToList(); break; } searchParam.TotalRecordCount = lstVariables.Count(); searchParam.TotalPages = (int)Math.Ceiling((double)searchParam.TotalRecordCount / searchParam.RecordsPerPage); return(lstVariables.Skip((searchParam.CurrentPageNumber - 1) * searchParam.RecordsPerPage) .Take(searchParam.RecordsPerPage).ToList()); } }
/// <summary> /// Get Users /// </summary> /// <param name="searchParam"></param> /// <returns></returns> public static List <User> GetUsers(SearchAttributes searchParam) { IEnumerable <User> users; using (var context = new TSMContext()) { users = context.Users.Where(u => !u.IsDeleted.Value); //users = context.Users; if (!string.IsNullOrEmpty(searchParam.SearchText)) { string searchText = searchParam.SearchText.ToLower(); users = users.Where(u => u.Email.ToLower().Contains(searchText) || u.FirstName.ToLower().Contains(searchText) || u.LastName.ToLower().Contains(searchText)); } switch (searchParam.SortColumnIndex) { case 2: users = searchParam.SortDirection == SortDirection.Ascending ? users.OrderBy(u => u.Email) : users.OrderByDescending(u => u.Email); break; case 1: users = searchParam.SortDirection == SortDirection.Ascending ? users.OrderBy(u => u.FirstName).ThenBy(u => u.LastName) : users.OrderByDescending(u => u.FirstName).ThenByDescending(u => u.LastName); break; } searchParam.TotalRecordCount = users.Count(); searchParam.TotalPages = (int)Math.Ceiling((double)searchParam.TotalRecordCount / searchParam.RecordsPerPage); //return users.ToList(); return(users.Skip((searchParam.CurrentPageNumber - 1) * searchParam.RecordsPerPage) .Take(searchParam.RecordsPerPage).ToList()); } }
/// <summary> /// Get Record Language By Search Param /// </summary> /// <param name="searchParam"></param> /// <returns></returns> public static List <Record_Language> GetRecordLanguages(SearchAttributes searchParam, Guid langID) { //IEnumerable<Record> records; //List<Record> lstRecord = new List<Record>(); using (var context = new TSMContext()) { var lstrecordLanguage = context.Record_Languages.Include("Record").Where(r => r.Record.IsDeleted == false && r.Record.IsActive == true && r.LanguageID == langID); if (!string.IsNullOrEmpty(searchParam.SearchText)) { string searchText = searchParam.SearchText.ToLower(); lstrecordLanguage = lstrecordLanguage.Where(rl => rl.Name.ToLower().Contains(searchText)); } switch (searchParam.SortColumnIndex) { case 1: lstrecordLanguage = searchParam.SortDirection == SortDirection.Ascending ? lstrecordLanguage.OrderBy(r => r.Name) : lstrecordLanguage.OrderByDescending(r => r.Name); break; } searchParam.TotalRecordCount = lstrecordLanguage.Count(); searchParam.TotalPages = (int)Math.Ceiling((double)searchParam.TotalRecordCount / searchParam.RecordsPerPage); return(lstrecordLanguage.Skip((searchParam.CurrentPageNumber - 1) * searchParam.RecordsPerPage) .Take(searchParam.RecordsPerPage).ToList()); } }
public ActionResult Records(int?page, int?sortColumnIndex, int?sortDirection, string searchText) { RecordListModel model = new RecordListModel(); SearchAttributes searchParam = new SearchAttributes(); searchParam.CurrentPageNumber = (page.HasValue && page.Value > 0) ? page.Value : 1; searchParam.RecordsPerPage = AppSettingsUtility.GetInt(AppSettingsKeys.RecordsPerPage); if (sortColumnIndex.HasValue) { searchParam.SortColumnIndex = sortColumnIndex.Value; } else { searchParam.SortColumnIndex = 1; } searchParam.SortDirection = (sortDirection.HasValue && sortDirection.Value == 1) ? Entity.SortDirection.Descending : Entity.SortDirection.Ascending; if (!string.IsNullOrEmpty(searchText)) { searchParam.SearchText = searchText; } model.SearchParam = searchParam; model.Populate(searchParam); //for Ajax Specific Request if (Request.IsAjaxRequest()) { return(View("~/Views/Shared/PartialViews/Admin/Record/_RecordList.cshtml", model)); } else { return(View("~/Views/Admin/Record/RecordList.cshtml", model)); } }
/// <summary> /// Get Pages /// </summary> /// <param name="searchParam"></param> /// <returns></returns> public static List <Content> GetPages(SearchAttributes searchParam) { IEnumerable <Content> pages; using (var context = new TSMContext()) { pages = context.Contents.Where(c => c.IsActive && c.IsPublic && c.Type != ContentType.News); if (!string.IsNullOrEmpty(searchParam.SearchText)) { string searchText = searchParam.SearchText; pages = pages.Where(p => p.Type.ToString().Contains(searchText)); } switch (searchParam.SortColumnIndex) { case 1: pages = searchParam.SortDirection == SortDirection.Ascending ? pages.OrderBy(p => p.Type.ToString()) : pages.OrderByDescending(p => p.Type.ToString()); break; } searchParam.TotalRecordCount = pages.Count(); searchParam.TotalPages = (int)Math.Ceiling((double)searchParam.TotalRecordCount / searchParam.RecordsPerPage); return(pages.Skip((searchParam.CurrentPageNumber - 1) * searchParam.RecordsPerPage) .Take(searchParam.RecordsPerPage).ToList()); } }
/// <summary> /// Get Content By SearchAttributes /// </summary> /// <param name="searchParam"></param> /// <returns></returns> public static List <Content> GetContents(SearchAttributes searchParam, Guid langID) { List <Content> listContent = new List <Content>(); using (var context = new TSMContext()) { listContent = context.Contents.Include("Content_Languages").Where(c => c.IsActive && c.Type == ContentType.News).ToList().FindAll(c => c.Content_Languages.Find(cl => cl.LanguageID == langID) != null); // listContent=from lc in listContent join cl in context.Content_Languages on lc.ID equals cl.ID where cl.LanguageID==langID select lc; if (!string.IsNullOrEmpty(searchParam.SearchText)) { string searchText = searchParam.SearchText; listContent = listContent.Where(u => u.Content_Languages.Any(v => v.Title.ToLower().Contains(searchText.ToLower()) && v.LanguageID == langID)).ToList(); } switch (searchParam.SortColumnIndex) { case 1: listContent = searchParam.SortDirection == SortDirection.Ascending ? listContent.OrderBy(u => u.ContentDate).ToList() : listContent.OrderByDescending(u => u.ContentDate).ToList(); break; case 2: listContent = searchParam.SortDirection == SortDirection.Ascending ? listContent.Where(u => u.Content_Languages.Count > 0).OrderBy(u => u.Content_Languages[0].Title).ToList() : listContent.Where(u => u.Content_Languages.Count > 0).OrderByDescending(u => u.Content_Languages[0].Title).ToList(); break; } searchParam.TotalRecordCount = listContent.Count(); searchParam.TotalPages = (int)Math.Ceiling((double)searchParam.TotalRecordCount / searchParam.RecordsPerPage); return(listContent.Skip((searchParam.CurrentPageNumber - 1) * searchParam.RecordsPerPage) .Take(searchParam.RecordsPerPage).ToList()); } }
/// <summary> /// Get Content Languages by search attribute /// </summary> /// <param name="searchParam"></param> /// <param name="langID"></param> /// <returns></returns> public static List <Content_Language> GetContentLanguages(SearchAttributes searchParam, Guid langID) { using (var context = new TSMContext()) { var contentLanguages = context.Content_Languages.Include("Content").Where(cl => cl.Content.IsActive && cl.Content.Type == ContentType.News && cl.LanguageID == langID); if (!string.IsNullOrEmpty(searchParam.SearchText)) { string searchText = searchParam.SearchText; contentLanguages = contentLanguages.Where(cl => cl.Title.ToLower().Contains(searchText.ToLower())); } switch (searchParam.SortColumnIndex) { case 1: contentLanguages = searchParam.SortDirection == SortDirection.Ascending ? contentLanguages.OrderBy(cl => cl.Content.ContentDate) : contentLanguages.OrderByDescending(cl => cl.Content.ContentDate); break; case 2: contentLanguages = searchParam.SortDirection == SortDirection.Ascending ? contentLanguages.OrderBy(cl => cl.Title) : contentLanguages.OrderByDescending(cl => cl.Title); break; } searchParam.TotalRecordCount = contentLanguages.Count(); searchParam.TotalPages = (int)Math.Ceiling((double)searchParam.TotalRecordCount / searchParam.RecordsPerPage); return(contentLanguages.Skip((searchParam.CurrentPageNumber - 1) * searchParam.RecordsPerPage) .Take(searchParam.RecordsPerPage).ToList()); } }
/// <summary> /// Search Param /// </summary> /// <param name="CacheKey"></param> public static SearchAttributes GetSearchParam() { SearchAttributes searchParam = new SearchAttributes(); searchParam.CurrentPageNumber = 1; searchParam.RecordsPerPage = 20000; searchParam.SortColumnIndex = 1; searchParam.SortDirection = TSM.Entity.SortDirection.Descending; return(searchParam); }
/// <summary> /// Populate Users /// </summary> /// <param name="search"></param> public void Populate(SearchAttributes searchParam) { try { this.Users = UserService.GetUsers(searchParam); this.SearchParam = searchParam; } catch (Exception ex) { ErrorLog.WriteLog("ManageUserModel", "Populate", ex, ""); } }
/// <summary> /// Populate Pages /// </summary> /// <param name="search"></param> public void Populate(SearchAttributes searchParam) { try { this.Pages = PageService.GetPages(searchParam); this.SearchParam = searchParam; } catch (Exception ex) { ErrorLog.WriteLog("PageListModel", "Populate", ex, ""); } }
/// <summary> /// Populate News List /// </summary> public void Populate(SearchAttributes searchParam) { try { List <Content_Language> NewsCont = NewsService.GetContentLanguages(searchParam, TSM.Model.TSMContext.CurrentSiteLanguageID); //this.NewsContents = NewsService.GetContents(searchParam,TSM.Model.TSMContext.CurrentSiteLanguageID).Where(z => z.Type == ContentType.News).ToList(); this.NewsContents = NewsCont.Select(n => n.Content).Where(z => z.Type == ContentType.News).ToList(); } catch (Exception ex) { ErrorLog.WriteLog("ManageNewsModel", "Populate", ex, ""); } }
/// <summary> /// Get All Sectors /// </summary> /// <returns></returns> public void GetAllSector(SearchAttributes searchParam) { try { this.lstSector = new List <TSMSector>(); this.SearchParam = searchParam; this.lstSector = SectorService.GetSectors(searchParam, TSMContext.CurrentLanguageID); } catch (Exception ex) { ErrorLog.WriteLog("ManageUserModel", "Populate", ex, ""); } }
/// <summary> /// Populate Records /// </summary> /// <param name="search"></param> public void Populate(SearchAttributes searchParam) { try { var lstRecordLanguage = RecordService.GetRecordLanguages(searchParam, TSM.Model.TSMContext.CurrentSiteLanguageID); this.Records = lstRecordLanguage.Select(r => r.Record).ToList(); //this.Records = RecordService.GetRecords(searchParam,TSM.Model.TSMContext.CurrentSiteLanguageID); this.SearchParam = searchParam; } catch (Exception ex) { ErrorLog.WriteLog("RecordListModel", "Populate", ex, ""); } }
public void Populate(SearchAttributes searchParam) { try { var variableLanguages = VariableService.GetVariableLanguages(searchParam, TSMContext.CurrentLanguageID); this.Variables = variableLanguages.Select(v => v.Variable).ToList(); // this.Variables = VariableService.GetVariables(); this.SearchParam = searchParam; } catch (Exception ex) { ErrorLog.WriteLog("ManageVariableModel", "Populate", ex, ""); } }
public ActionResult ResultSearch(SearchAttributes searchParameters) { string strWithoutSpaces = Regex.Replace(searchParameters.SearchQuery, @"^\s+", ""); strWithoutSpaces = Regex.Replace(strWithoutSpaces, @"\s+$", ""); if (searchParameters.SearchQuery != null) { return(RedirectToAction( "ResultSearch", "Main", new { searchQuery = strWithoutSpaces, selectSearch = searchParameters.Select })); } return(HttpNotFound()); }
public PartialViewResult SearchMenu() { var model = new SearchAttributes(); model.SelectList = new List <SelectListItem> { new SelectListItem { Value = ((int)SearchType.ByNamesOrArticles).ToString(), Text = "Articles" }, new SelectListItem { Value = ((int)SearchType.ByTags).ToString(), Text = "Tags" }, new SelectListItem { Value = ((int)SearchType.ByDate).ToString(), Text = "Date" } }; return(PartialView(model)); }
public ActionResult PopulateAdvanceSearchFilter(string[] region, string[] country, string[] sector, string[] document, string[] year, string[] period, string[] last_Update, string[] counterpart, string[] DocCheckboxData, string[] thematicCheckboxData, string[] designProcessCheckboxData, string[] pagesize, string[] page, int?sortColumnIndex, int?sortDirection) { SearchMapModel model = new SearchMapModel(); #region [Page] int pageSize = 5; if (pagesize != null) { int.TryParse(pagesize[0], out pageSize); } int Pages = 1; if (page != null) { int.TryParse(page[0], out Pages); } #endregion SearchAttributes searchParam = new SearchAttributes(); searchParam.CurrentPageNumber = Pages; // searchParam.RecordsPerPage = AppSettingsUtility.GetInt(AppSettingsKeys.RecordsPerPage); searchParam.RecordsPerPage = pageSize; if (sortColumnIndex.HasValue) { searchParam.SortColumnIndex = sortColumnIndex.Value; } else { searchParam.SortColumnIndex = 1; } searchParam.SortDirection = (sortDirection.HasValue && sortDirection.Value == 1) ? Entity.SortDirection.Descending : Entity.SortDirection.Ascending; model.SearchParam = searchParam; model.PageSize = pageSize; List <RecordData> recordDataList = new List <RecordData>(); model.GetFilterRecordInformation(region, country, sector, document, year, period, last_Update, counterpart, DocCheckboxData, thematicCheckboxData, designProcessCheckboxData, pageSize, searchParam, sortColumnIndex, sortDirection, out recordDataList); return(View("~/Views/Shared/PartialViews/search/_RecordFilter.cshtml", model)); }
/// <summary> /// Populate /// </summary> /// <param name="query"></param> public void Populate(string query, int pageNo) { this.Query = query; if (string.IsNullOrEmpty(query)) { return; } string indexPath = HttpContext.Current.Server.MapPath("~/LuceneIndex/"); var result = SiteSearchService.Search(query, indexPath); //Implement Paging this.SearchParam = new SearchAttributes(); this.SearchParam.RecordsPerPage = 10; this.SearchParam.TotalRecordCount = result.Count; SearchParam.TotalPages = (int)Math.Ceiling((double)SearchParam.TotalRecordCount / SearchParam.RecordsPerPage); SearchParam.CurrentPageNumber = pageNo; this.SearchResult = result.Skip((SearchParam.CurrentPageNumber - 1) * SearchParam.RecordsPerPage) .Take(SearchParam.RecordsPerPage).ToList(); }
/// <summary> /// Page Action Result /// </summary> /// <returns></returns> public ActionResult Pages(int?page, int?sortColumnIndex, int?sortDirection) { PageListModel model = new PageListModel(); SearchAttributes searchParam = new SearchAttributes(); searchParam.CurrentPageNumber = (page.HasValue && page.Value > 0) ? page.Value : 1; searchParam.RecordsPerPage = AppSettingsUtility.GetInt(AppSettingsKeys.RecordsPerPage); searchParam.SortColumnIndex = 1; searchParam.SortDirection = (sortDirection.HasValue && sortDirection.Value == 1) ? Entity.SortDirection.Descending : Entity.SortDirection.Ascending; model.Populate(searchParam); //for Ajax Specific Request if (Request.IsAjaxRequest()) { return(View("~/Views/Shared/PartialViews/Admin/Page/_PageList.cshtml", model)); } else { return(View("~/Views/Admin/Page/PageList.cshtml", model)); } }
/// <summary> /// Get Sectors For Listing /// </summary> /// <param name="searchParam"></param> /// <returns></returns> public static List <TSMSector> GetSectors(SearchAttributes searchParam, Guid LanguageId) { IEnumerable <TSMSector> TSMsector; using (var context = new TSMContext()) { TSMsector = context.TSMSector.Where(u => u.IsDeleted == false); if (!string.IsNullOrEmpty(searchParam.SearchText)) { string searchText = searchParam.SearchText; TSMsector = TSMsector.Where(u => u.Name.ToLower().Contains(searchText.ToLower())); } switch (searchParam.SortColumnIndex) { case 1: TSMsector = searchParam.SortDirection == SortDirection.Ascending ? TSMsector.OrderBy(u => u.NomenclatureType) : TSMsector.OrderByDescending(u => u.NomenclatureType); break; case 2: TSMsector = searchParam.SortDirection == SortDirection.Ascending ? TSMsector.OrderBy(u => u.Type) : TSMsector.OrderByDescending(u => u.Type); break; case 3: TSMsector = searchParam.SortDirection == SortDirection.Ascending ? TSMsector.OrderBy(u => u.Name) : TSMsector.OrderByDescending(u => u.Name); break; } searchParam.TotalRecordCount = TSMsector.Count(); searchParam.TotalPages = (int)Math.Ceiling((double)searchParam.TotalRecordCount / searchParam.RecordsPerPage); return(TSMsector.Skip((searchParam.CurrentPageNumber - 1) * searchParam.RecordsPerPage) .Take(searchParam.RecordsPerPage).ToList()); } }
public static List <Content> GetContents(SearchAttributes searchParam) { List <Content> listContent = new List <Content>(); using (var context = new TSMContext()) { listContent = context.Contents.Include("Content_Languages").Where(c => c.IsActive).OrderBy(c => c.Type.ToString()).ToList(); switch (searchParam.SortColumnIndex) { case 2: listContent = searchParam.SortDirection == SortDirection.Ascending ? listContent.OrderBy(u => u.Content_Languages[0].SubTitle).ToList() : listContent.OrderByDescending(u => u.Content_Languages[0].SubTitle).ToList(); break; case 1: listContent = searchParam.SortDirection == SortDirection.Ascending ? listContent.OrderBy(u => u.Content_Languages[0].Title).ToList() : listContent.OrderByDescending(u => u.Content_Languages[0].Title).ToList(); break; } searchParam.TotalRecordCount = listContent.Count(); searchParam.TotalPages = (int)Math.Ceiling((double)searchParam.TotalRecordCount / searchParam.RecordsPerPage); return(listContent.Skip((searchParam.CurrentPageNumber - 1) * searchParam.RecordsPerPage) .Take(searchParam.RecordsPerPage).ToList()); } }
/// <summary> /// Returns a <see cref="System.String" /> that represents this instance. /// </summary> /// <returns> /// A <see cref="System.String" /> that represents this instance. /// </returns> /// <exception cref="NotImplementedException"></exception> public override string ToString() { if (string.IsNullOrEmpty(ObjectStructureName)) { throw new ArgumentException($"Required paramater '{nameof(ObjectStructureName)}' was not given."); } var sb = new StringBuilder(); sb.Append($"{ObjectStructureName}?"); if (Select != null && Select.Any()) { var selectSb = new StringBuilder("oslc.select="); foreach (var att in Select) { selectSb.Append($"{att}{SELECT_SEPERATOR}"); } var selectStr = selectSb.ToString(); if (selectStr.EndsWith(SELECT_SEPERATOR)) { selectStr = selectStr.Remove(selectStr.Length - SELECT_SEPERATOR.Length); } sb.Append(selectStr); } else { sb.Append("oslc.select=*"); } if (SearchAttributes.Any() && !string.IsNullOrEmpty(SearchTerm)) { var searchSb = new StringBuilder("&searchAttributes="); foreach (var attribute in SearchAttributes) { searchSb.Append($"{attribute}{SELECT_SEPERATOR}"); } var searchStr = searchSb.ToString(); if (searchStr.EndsWith(SELECT_SEPERATOR)) { searchStr = searchStr.Remove(searchStr.Length - SELECT_SEPERATOR.Length); } sb.Append(searchStr); sb.Append($"&oslc.searchTerms=\"{SearchTerm}\""); } if (OrderBy != null) { sb.Append("&orderBy="); sb.Append(OrderByDescending ? "-" : "%2B"); sb.Append(OrderBy); } if (PageSize != null && PageSize > 0) { sb.Append($"&oslc.pageSize={PageSize}"); if (PageNumber != null && PageNumber > 1) { sb.Append($"&pageno={PageNumber}"); } } if (UseLean) { sb.Append("&lean=1"); } return(sb.ToString()); }
public static List <Record> GetFilterRecordInformation(List <Guid> recordID, int pageSize, SearchAttributes searchParam) { List <Record> records = new List <Record>(); using (var context = new TSMContext()) { var filteredRecordsID = recordID; var recordData = context.Records.Include("Record_Languages").Include("Variables"). Include("Documents").Include("Countries"). Include("Regions").Include("Sectors").Where(r => filteredRecordsID.Contains(r.ID)).ToList(); records = recordData.ToList(); searchParam.TotalRecordCount = records.Count(); searchParam.TotalPages = (int)Math.Ceiling((double)searchParam.TotalRecordCount / searchParam.RecordsPerPage); return(records.Skip((searchParam.CurrentPageNumber - 1) * searchParam.RecordsPerPage) .Take(searchParam.RecordsPerPage).ToList()); } }
public static List <Record> GetFilterRecordInformationForSearch(List <Guid> recordID, int pageSize, SearchAttributes searchParam) { List <Record> records = new List <Record>(); List <Record> listRecordData = new List <Record>(); using (var context = new TSMContext()) { var filteredRecordsID = recordID; var recordData = context.Records.Include("Record_Languages").Include("Variables"). Include("Documents").Include("Countries"). Include("Regions").Include("Sectors").ToList(); listRecordData = recordData; return(listRecordData); } }
public ExportRecordData CreateNewRecord(Guid recd) { ExportRecordData ExportRecordData = new ExportRecordData(); if (recd != Guid.Empty) { Guid recID = recd; List <Guid> listRecordsID = new List <Guid>(); listRecordsID.Add(recID); List <Record> recordlist = new List <Record>(); SearchAttributes searchParam = GetSearchParam(); recordlist = SearchServices.GetFilterRecordInformation(listRecordsID, 20000, searchParam); Record rec = recordlist.FirstOrDefault(); Guid languageId = TSM.Model.TSMContext.CurrentLanguageID; ExportRecordData.Records = new List <ExportRecord>(); #region [Data Load] //Get Variable Items List <Variable_Language> variableItems = new List <Variable_Language>(); variableItems = SearchServices.GetVariableLanguageForVariable(languageId).ToList(); //Get Get All Country With Region List <Country> listofAllCountries = new List <Country>(); listofAllCountries = SearchServices.GetAllCountryWithRegion(); //Get list of All Region List <Region_Language> listofAllRegion = new List <Region_Language>(); listofAllRegion = SearchServices.GetAllRegionWithLanguage(); //Get list of All Country with language List <Country_Language> lstCountryLang = new List <Country_Language>(); lstCountryLang = SearchServices.GetAllCountry(languageId); //Get Sector Language List <Sector_Language> lstSectorLanguage = new List <Sector_Language>(); lstSectorLanguage = SearchServices.GetAllSectorNames(languageId); //Get Sector List <TSMSector> lstTSMSector = new List <TSMSector>(); lstTSMSector = SearchServices.GetAllSector(); // Get Record Variable List <Record_Variable> recordVariables = new List <Record_Variable>(); recordVariables = SearchServices.GetAllRecordVariable(); #endregion ExportRecordData.Variables = new List <KeyValue>(); foreach (var keyValue in variableItems) { KeyValue keyValuevariableLanguageItem = new KeyValue { Key = keyValue.ID.ToString(), Value = keyValue.Name }; ExportRecordData.Variables.Add(keyValuevariableLanguageItem); } ExportRecord exportRecord = null; #region [sector = 0 && country = 1] if ((rec.Countries.Count == 1) && (rec.Sectors.Count == 0)) { exportRecord = new ExportRecord(); //document try { if (rec.Documents.Count > 0) { exportRecord.Document = rec.Documents[0].Path.Split('.')[0].ToString(); } else { exportRecord.Document = null; } } catch { exportRecord.Document = ""; } //ID exportRecord.RecordID = rec.ID; //Name exportRecord.Name = rec.Record_Languages.FirstOrDefault().Name; //Regions start var selectedRegion = new List <Region>(); Country tmpCountry = listofAllCountries.Where(c => c.ID == rec.Countries[0].ID).FirstOrDefault(); if (tmpCountry != null) { foreach (var r in tmpCountry.Regions) { selectedRegion.Add(r); } } var regionLanguageList = (from rl in listofAllRegion join r in selectedRegion on rl.ID equals r.ID where r.Type == TSM.Entity.RegionType.Geographical && rl.LanguageID == languageId select rl.Name).ToList(); if (regionLanguageList.Count > 0) { exportRecord.Regions = regionLanguageList[0].ToString(); } //Region end //Country start Country_Language countryLanguage = lstCountryLang.Where(cl => cl.ID == rec.Countries[0].ID).FirstOrDefault(); exportRecord.Countries = countryLanguage.Name; //country end exportRecord.CountryCode = rec.Countries[0].ISOCode; //variable values exportRecord.VariableValues = new List <string>(); List <string> recordVariableKey = new List <string>(); foreach (var variableValue in ExportRecordData.Variables) { if (variableValue != null && variableValue.Value != null && !string.IsNullOrEmpty(variableValue.Value) && variableValue.Value != "") { recordVariableKey.Add(variableValue.Key); exportRecord.VariableValues.Add(SearchServices.GetVariableValueByVariableIdFromList(languageId, rec.ID, recordVariableKey, variableValue.Key, recordVariables)); //exportRecord.VariableValues.Add(SearchServices.GetVariableValueByVariableId(languageId, rec.ID, recordVariableKey, variableValue.Key)); } } if (exportRecord != null) { ExportRecordData.Records.Add(exportRecord); ExportRecordData.RecID = exportRecord.RecordID; } } #endregion #region [sector > 0 && country = 1] else if ((rec.Countries.Count == 1) && (rec.Sectors.Count > 0)) { foreach (var sec in rec.Sectors) { exportRecord = new ExportRecord(); //document try { if (rec.Documents.Count > 0) { exportRecord.Document = rec.Documents[0].Path.Split('.')[0].ToString(); } else { exportRecord.Document = null; } } catch { exportRecord.Document = ""; } //ID exportRecord.RecordID = rec.ID; //Name exportRecord.Name = rec.Record_Languages.FirstOrDefault().Name; //Regions start var selectedRegion = new List <Region>(); Country tmpCountry = listofAllCountries.Where(c => c.ID == rec.Countries[0].ID).FirstOrDefault(); if (tmpCountry != null) { foreach (var r in tmpCountry.Regions) { selectedRegion.Add(r); } } var regionLanguageList = (from rl in listofAllRegion join r in selectedRegion on rl.ID equals r.ID where r.Type == TSM.Entity.RegionType.Geographical && rl.LanguageID == languageId select rl.Name).ToList(); if (regionLanguageList.Count > 0) { exportRecord.Regions = regionLanguageList[0].ToString(); } //Region end //Country start Country_Language countryLanguage = lstCountryLang.Where(cl => cl.ID == rec.Countries[0].ID).FirstOrDefault(); exportRecord.Countries = countryLanguage.Name; //country end exportRecord.CountryCode = rec.Countries[0].ISOCode; //variable values exportRecord.VariableValues = new List <string>(); List <string> recordVariableKey = new List <string>(); foreach (var variableValue in ExportRecordData.Variables) { if (variableValue != null && variableValue.Value != null && !string.IsNullOrEmpty(variableValue.Value) && variableValue.Value != "") { recordVariableKey.Add(variableValue.Key); exportRecord.VariableValues.Add(SearchServices.GetVariableValueByVariableIdFromList(languageId, rec.ID, recordVariableKey, variableValue.Key, recordVariables)); //exportRecord.VariableValues.Add(SearchServices.GetVariableValueByVariableId(languageId, rec.ID, recordVariableKey, variableValue.Key)); } } //sector Sector_Language secLang = lstSectorLanguage.Where(sl => sl.ID == sec.ID).FirstOrDefault(); exportRecord.Sectors = secLang.Name; exportRecord.SectorType = sec.Type.ToString(); var intSec = exportRecord.Sectors; //International Nomenclature Code string intNId = ""; if (sec.International_NomenclatureID != Guid.Empty) { try { var interNid = sec.International_NomenclatureID.Value; TSMSector INT_Nom = new TSMSector(); INT_Nom = lstTSMSector.Where(u => u.ID == interNid && u.NomenclatureType == NomenclatureType.International && u.Type == sec.Type).FirstOrDefault(); if (INT_Nom != null) { intNId = INT_Nom.Code; } } catch { } } if (intNId == "") { TSMSector INT_Nom = new TSMSector(); INT_Nom = lstTSMSector.Where(u => u.Name == intSec && u.NomenclatureType == NomenclatureType.International && u.Type == sec.Type).FirstOrDefault(); if (INT_Nom != null) { intNId = INT_Nom.Code; } } //ITC Nomenclature Code string itcNid = ""; if (sec.ITC_NomenclatureID != Guid.Empty) { try { var itcid = sec.ITC_NomenclatureID.Value; TSMSector ITC_Nom = new TSMSector(); ITC_Nom = lstTSMSector.Where(u => u.ID == itcid && u.NomenclatureType == NomenclatureType.ITC && u.Type == sec.Type).FirstOrDefault(); if (ITC_Nom != null) { itcNid = ITC_Nom.Code; } } catch { } } if (itcNid == "") { TSMSector ITC_Nom = new TSMSector(); ITC_Nom = lstTSMSector.Where(u => u.Name == intSec && u.NomenclatureType == NomenclatureType.ITC && u.Type == sec.Type).FirstOrDefault(); if (ITC_Nom != null) { itcNid = ITC_Nom.Code; } } exportRecord.ITCCode = itcNid; exportRecord.INTCode = intNId; if (exportRecord != null) { ExportRecordData.Records.Add(exportRecord); ExportRecordData.RecID = exportRecord.RecordID; } } } #endregion #region [sector > 0 && country > 1] else if ((rec.Countries.Count > 1) && (rec.Sectors.Count > 0)) { foreach (var cnt in rec.Countries) { Country_Language countryLanguage = lstCountryLang.Where(cl => cl.ID == cnt.ID).FirstOrDefault(); var selectedRegion = new List <Region>(); Country tmpCountry = listofAllCountries.Where(c => c.ID == rec.Countries[0].ID).FirstOrDefault(); if (tmpCountry != null) { foreach (var r in tmpCountry.Regions) { selectedRegion.Add(r); } } var regionLanguageList = (from rl in listofAllRegion join r in selectedRegion on rl.ID equals r.ID where r.Type == TSM.Entity.RegionType.Geographical && rl.LanguageID == languageId select rl.Name).ToList(); foreach (var sec in rec.Sectors) { exportRecord = new ExportRecord(); //document try { if (rec.Documents.Count > 0) { exportRecord.Document = rec.Documents[0].Path.Split('.')[0].ToString(); } else { exportRecord.Document = null; } } catch { exportRecord.Document = ""; } //ID exportRecord.RecordID = rec.ID; //Name exportRecord.Name = rec.Record_Languages.FirstOrDefault().Name; //Regions if (regionLanguageList.Count > 0) { exportRecord.Regions = regionLanguageList[0].ToString(); } //Country exportRecord.Countries = countryLanguage.Name; exportRecord.CountryCode = cnt.ISOCode; //variable values exportRecord.VariableValues = new List <string>(); List <string> recordVariableKey = new List <string>(); foreach (var variableValue in ExportRecordData.Variables) { if (variableValue != null && variableValue.Value != null && !string.IsNullOrEmpty(variableValue.Value) && variableValue.Value != "") { recordVariableKey.Add(variableValue.Key); exportRecord.VariableValues.Add(SearchServices.GetVariableValueByVariableIdFromList(languageId, rec.ID, recordVariableKey, variableValue.Key, recordVariables)); //exportRecord.VariableValues.Add(SearchServices.GetVariableValueByVariableId(languageId, rec.ID, recordVariableKey, variableValue.Key)); } } //sector Sector_Language secLang = lstSectorLanguage.Where(sl => sl.ID == sec.ID).FirstOrDefault(); exportRecord.Sectors = secLang.Name; exportRecord.SectorType = sec.Type.ToString(); var intSec = exportRecord.Sectors; //International Nomenclature Code string intNId = ""; if (sec.International_NomenclatureID != Guid.Empty) { try { var interNid = sec.International_NomenclatureID.Value; TSMSector INT_Nom = new TSMSector(); INT_Nom = lstTSMSector.Where(u => u.ID == interNid && u.NomenclatureType == NomenclatureType.International && u.Type == sec.Type).FirstOrDefault(); if (INT_Nom != null) { intNId = INT_Nom.Code; } } catch { } } if (intNId == "") { TSMSector INT_Nom = new TSMSector(); INT_Nom = lstTSMSector.Where(u => u.Name == intSec && u.NomenclatureType == NomenclatureType.International && u.Type == sec.Type).FirstOrDefault(); if (INT_Nom != null) { intNId = INT_Nom.Code; } } //ITC Nomenclature Code string itcNid = ""; if (sec.ITC_NomenclatureID != Guid.Empty) { try { var itcid = sec.ITC_NomenclatureID.Value; TSMSector ITC_Nom = new TSMSector(); ITC_Nom = lstTSMSector.Where(u => u.ID == itcid && u.NomenclatureType == NomenclatureType.ITC && u.Type == sec.Type).FirstOrDefault(); if (ITC_Nom != null) { itcNid = ITC_Nom.Code; } } catch { } } if (itcNid == "") { TSMSector ITC_Nom = new TSMSector(); ITC_Nom = lstTSMSector.Where(u => u.Name == intSec && u.NomenclatureType == NomenclatureType.ITC && u.Type == sec.Type).FirstOrDefault(); if (ITC_Nom != null) { itcNid = ITC_Nom.Code; } } exportRecord.ITCCode = itcNid; exportRecord.INTCode = intNId; if (exportRecord != null) { ExportRecordData.Records.Add(exportRecord); ExportRecordData.RecID = exportRecord.RecordID; } } } } #endregion #region [sector = 0 && country > 1] else if ((rec.Countries.Count > 1) && (rec.Sectors.Count == 0)) { foreach (var cnt in rec.Countries) { Country_Language countryLanguage = lstCountryLang.Where(cl => cl.ID == cnt.ID).FirstOrDefault(); var selectedRegion = new List <Region>(); Country tmpCountry = listofAllCountries.Where(c => c.ID == rec.Countries[0].ID).FirstOrDefault(); if (tmpCountry != null) { foreach (var r in tmpCountry.Regions) { selectedRegion.Add(r); } } var regionLanguageList = (from rl in listofAllRegion join r in selectedRegion on rl.ID equals r.ID where r.Type == TSM.Entity.RegionType.Geographical && rl.LanguageID == languageId select rl.Name).ToList(); exportRecord = new ExportRecord(); //document try { if (rec.Documents.Count > 0) { exportRecord.Document = rec.Documents[0].Path.Split('.')[0].ToString(); } else { exportRecord.Document = null; } } catch { exportRecord.Document = ""; } //ID exportRecord.RecordID = rec.ID; //Name exportRecord.Name = rec.Record_Languages.FirstOrDefault().Name; //Regions if (regionLanguageList.Count > 0) { exportRecord.Regions = regionLanguageList[0].ToString(); } //Country exportRecord.Countries = countryLanguage.Name; exportRecord.CountryCode = cnt.ISOCode; //variable values exportRecord.VariableValues = new List <string>(); List <string> recordVariableKey = new List <string>(); foreach (var variableValue in ExportRecordData.Variables) { if (variableValue != null && variableValue.Value != null && !string.IsNullOrEmpty(variableValue.Value) && variableValue.Value != "") { recordVariableKey.Add(variableValue.Key); exportRecord.VariableValues.Add(SearchServices.GetVariableValueByVariableIdFromList(languageId, rec.ID, recordVariableKey, variableValue.Key, recordVariables)); //exportRecord.VariableValues.Add(SearchServices.GetVariableValueByVariableId(languageId, rec.ID, recordVariableKey, variableValue.Key)); } } if (exportRecord != null) { ExportRecordData.Records.Add(exportRecord); ExportRecordData.RecID = exportRecord.RecordID; } } } #endregion } return(ExportRecordData); }
public void RebuildRecordAsync() { Guid languageId = TSM.Model.TSMContext.CurrentLanguageID; List <Record> record = new List <Record>(); List <Guid> listRecordsID = RecordService.GetAllRecordID(); List <ExportRecordData> ExportdataList = new List <ExportRecordData>(); var cacheProvider = CacheFactory.Get(); if (listRecordsID != null) { SearchAttributes searchParam = GetSearchParam(); record = SearchServices.GetFilterRecordInformation(listRecordsID, 20000, searchParam); ExportRecordData ExportRecordData = new ExportRecordData(); ExportRecordData.Records = new List <ExportRecord>(); #region [If Not Null Record] if (record != null) { #region [Cache Data Load] //Get Variable Items List <Variable_Language> variableItems = new List <Variable_Language>(); variableItems = SearchServices.GetVariableLanguageForVariable(languageId).ToList(); //Get Get All Country With Region List <Country> listofAllCountries = new List <Country>(); listofAllCountries = SearchServices.GetAllCountryWithRegion(); //Get list of All Region List <Region_Language> listofAllRegion = new List <Region_Language>(); listofAllRegion = SearchServices.GetAllRegionWithLanguage(); //Get list of All Country with language List <Country_Language> lstCountryLang = new List <Country_Language>(); lstCountryLang = SearchServices.GetAllCountry(languageId); //Get Sector Language List <Sector_Language> lstSectorLanguage = new List <Sector_Language>(); lstSectorLanguage = SearchServices.GetAllSectorNames(languageId); //Get Sector List <TSMSector> lstTSMSector = new List <TSMSector>(); lstTSMSector = SearchServices.GetAllSector(); // Get Record Variable List <Record_Variable> recordVariables = new List <Record_Variable>(); recordVariables = SearchServices.GetAllRecordVariable(); #endregion foreach (var exportRecordData in record) { try { ExportRecordData.Variables = new List <KeyValue>(); foreach (var keyValue in variableItems) { KeyValue keyValuevariableLanguageItem = new KeyValue { Key = keyValue.ID.ToString(), Value = keyValue.Name }; ExportRecordData.Variables.Add(keyValuevariableLanguageItem); } ExportRecord exportRecord = null; #region [sector = 0 && country = 1] if ((exportRecordData.Countries.Count == 1) && (exportRecordData.Sectors.Count == 0)) { exportRecord = new ExportRecord(); //document try { if (exportRecordData.Documents.Count > 0) { exportRecord.Document = exportRecordData.Documents[0].Path.Split('.')[0].ToString(); } else { exportRecord.Document = null; } } catch { exportRecord.Document = ""; } //ID exportRecord.RecordID = exportRecordData.ID; //Name exportRecord.Name = exportRecordData.Record_Languages.FirstOrDefault().Name.ToString();//.ToLower(); //Regions start var selectedRegion = new List <Region>(); Country tmpCountry = listofAllCountries.Where(c => c.ID == exportRecordData.Countries[0].ID).FirstOrDefault(); if (tmpCountry != null) { foreach (var r in tmpCountry.Regions) { selectedRegion.Add(r); } } var regionLanguageList = (from rl in listofAllRegion join r in selectedRegion on rl.ID equals r.ID where r.Type == TSM.Entity.RegionType.Geographical && rl.LanguageID == languageId select rl.Name).ToList(); if (regionLanguageList.Count > 0) { exportRecord.Regions = regionLanguageList[0].ToString(); } //Region end //Country start Country_Language countryLanguage = lstCountryLang.Where(cl => cl.ID == exportRecordData.Countries[0].ID).FirstOrDefault(); exportRecord.Countries = countryLanguage.Name; //country end exportRecord.CountryCode = exportRecordData.Countries[0].ISOCode; //variable values exportRecord.VariableValues = new List <string>(); List <string> recordVariableKey = new List <string>(); foreach (var variableValue in ExportRecordData.Variables) { if (variableValue != null && variableValue.Value != null && !string.IsNullOrEmpty(variableValue.Value) && variableValue.Value != "") { recordVariableKey.Add(variableValue.Key); exportRecord.VariableValues.Add(SearchServices.GetVariableValueByVariableIdFromList(languageId, exportRecordData.ID, recordVariableKey, variableValue.Key, recordVariables)); //exportRecord.VariableValues.Add(SearchServices.GetVariableValueByVariableId(languageId, exportRecordData.ID, recordVariableKey, variableValue.Key)); } } if (exportRecord != null) { ExportRecordData.Records.Add(exportRecord); ExportRecordData.RecID = exportRecord.RecordID; } } #endregion #region [sector > 0 && country = 1] else if ((exportRecordData.Countries.Count == 1) && (exportRecordData.Sectors.Count > 0)) { foreach (var sec in exportRecordData.Sectors) { exportRecord = new ExportRecord(); //document try { if (exportRecordData.Documents.Count > 0) { exportRecord.Document = exportRecordData.Documents[0].Path.Split('.')[0].ToString(); } else { exportRecord.Document = null; } } catch { exportRecord.Document = ""; } //ID exportRecord.RecordID = exportRecordData.ID; //Name exportRecord.Name = exportRecordData.Record_Languages.FirstOrDefault().Name.ToString();//.ToLower(); //Regions start var selectedRegion = new List <Region>(); Country tmpCountry = listofAllCountries.Where(c => c.ID == exportRecordData.Countries[0].ID).FirstOrDefault(); if (tmpCountry != null) { foreach (var r in tmpCountry.Regions) { selectedRegion.Add(r); } } var regionLanguageList = (from rl in listofAllRegion join r in selectedRegion on rl.ID equals r.ID where r.Type == TSM.Entity.RegionType.Geographical && rl.LanguageID == languageId select rl.Name).ToList(); if (regionLanguageList.Count > 0) { exportRecord.Regions = regionLanguageList[0].ToString(); } //Region end //Country start Country_Language countryLanguage = lstCountryLang.Where(cl => cl.ID == exportRecordData.Countries[0].ID).FirstOrDefault(); exportRecord.Countries = countryLanguage.Name; //country end exportRecord.CountryCode = exportRecordData.Countries[0].ISOCode; //variable values exportRecord.VariableValues = new List <string>(); List <string> recordVariableKey = new List <string>(); foreach (var variableValue in ExportRecordData.Variables) { if (variableValue != null && variableValue.Value != null && !string.IsNullOrEmpty(variableValue.Value) && variableValue.Value != "") { recordVariableKey.Add(variableValue.Key); exportRecord.VariableValues.Add(SearchServices.GetVariableValueByVariableIdFromList(languageId, exportRecordData.ID, recordVariableKey, variableValue.Key, recordVariables)); //exportRecord.VariableValues.Add(SearchServices.GetVariableValueByVariableId(languageId, exportRecordData.ID, recordVariableKey, variableValue.Key)); } } //sector Sector_Language secLang = lstSectorLanguage.Where(sl => sl.ID == sec.ID).FirstOrDefault(); exportRecord.Sectors = secLang.Name; exportRecord.SectorType = sec.Type.ToString(); var intSec = exportRecord.Sectors; //International Nomenclature Code string intNId = ""; if (sec.International_NomenclatureID != Guid.Empty) { try { var interNid = sec.International_NomenclatureID.Value; TSMSector INT_Nom = new TSMSector(); INT_Nom = lstTSMSector.Where(u => u.ID == interNid && u.NomenclatureType == NomenclatureType.International && u.Type == sec.Type).FirstOrDefault(); if (INT_Nom != null) { intNId = INT_Nom.Code; } } catch { } } if (intNId == "") { TSMSector INT_Nom = new TSMSector(); INT_Nom = lstTSMSector.Where(u => u.Name == intSec && u.NomenclatureType == NomenclatureType.International && u.Type == sec.Type).FirstOrDefault(); if (INT_Nom != null) { intNId = INT_Nom.Code; } } //ITC Nomenclature Code string itcNid = ""; if (sec.ITC_NomenclatureID != Guid.Empty) { try { var itcid = sec.ITC_NomenclatureID.Value; TSMSector ITC_Nom = new TSMSector(); ITC_Nom = lstTSMSector.Where(u => u.ID == itcid && u.NomenclatureType == NomenclatureType.ITC && u.Type == sec.Type).FirstOrDefault(); if (ITC_Nom != null) { itcNid = ITC_Nom.Code; } } catch { } } if (itcNid == "") { TSMSector ITC_Nom = new TSMSector(); ITC_Nom = lstTSMSector.Where(u => u.Name == intSec && u.NomenclatureType == NomenclatureType.ITC && u.Type == sec.Type).FirstOrDefault(); if (ITC_Nom != null) { itcNid = ITC_Nom.Code; } } exportRecord.ITCCode = itcNid; exportRecord.INTCode = intNId; if (exportRecord != null) { ExportRecordData.Records.Add(exportRecord); ExportRecordData.RecID = exportRecord.RecordID; } } } #endregion #region [sector > 0 && country > 1] else if ((exportRecordData.Countries.Count > 1) && (exportRecordData.Sectors.Count > 0)) { foreach (var cnt in exportRecordData.Countries) { Country_Language countryLanguage = lstCountryLang.Where(cl => cl.ID == cnt.ID).FirstOrDefault(); var selectedRegion = new List <Region>(); Country tmpCountry = listofAllCountries.Where(c => c.ID == exportRecordData.Countries[0].ID).FirstOrDefault(); if (tmpCountry != null) { foreach (var r in tmpCountry.Regions) { selectedRegion.Add(r); } } var regionLanguageList = (from rl in listofAllRegion join r in selectedRegion on rl.ID equals r.ID where r.Type == TSM.Entity.RegionType.Geographical && rl.LanguageID == languageId select rl.Name).ToList(); foreach (var sec in exportRecordData.Sectors) { exportRecord = new ExportRecord(); //document try { if (exportRecordData.Documents.Count > 0) { exportRecord.Document = exportRecordData.Documents[0].Path.Split('.')[0].ToString(); } else { exportRecord.Document = null; } } catch { exportRecord.Document = ""; } //ID exportRecord.RecordID = exportRecordData.ID; //Name exportRecord.Name = exportRecordData.Record_Languages.FirstOrDefault().Name.ToString();//.ToLower(); //Regions if (regionLanguageList.Count > 0) { exportRecord.Regions = regionLanguageList[0].ToString(); } //Country exportRecord.Countries = countryLanguage.Name; exportRecord.CountryCode = cnt.ISOCode; //variable values exportRecord.VariableValues = new List <string>(); List <string> recordVariableKey = new List <string>(); foreach (var variableValue in ExportRecordData.Variables) { if (variableValue != null && variableValue.Value != null && !string.IsNullOrEmpty(variableValue.Value) && variableValue.Value != "") { recordVariableKey.Add(variableValue.Key); exportRecord.VariableValues.Add(SearchServices.GetVariableValueByVariableIdFromList(languageId, exportRecordData.ID, recordVariableKey, variableValue.Key, recordVariables)); //exportRecord.VariableValues.Add(SearchServices.GetVariableValueByVariableId(languageId, exportRecordData.ID, recordVariableKey, variableValue.Key)); } } //sector Sector_Language secLang = lstSectorLanguage.Where(sl => sl.ID == sec.ID).FirstOrDefault(); exportRecord.Sectors = secLang.Name; exportRecord.SectorType = sec.Type.ToString(); var intSec = exportRecord.Sectors; //International Nomenclature Code string intNId = ""; if (sec.International_NomenclatureID != Guid.Empty) { try { var interNid = sec.International_NomenclatureID.Value; TSMSector INT_Nom = new TSMSector(); INT_Nom = lstTSMSector.Where(u => u.ID == interNid && u.NomenclatureType == NomenclatureType.International && u.Type == sec.Type).FirstOrDefault(); if (INT_Nom != null) { intNId = INT_Nom.Code; } } catch { } } if (intNId == "") { TSMSector INT_Nom = new TSMSector(); INT_Nom = lstTSMSector.Where(u => u.Name == intSec && u.NomenclatureType == NomenclatureType.International && u.Type == sec.Type).FirstOrDefault(); if (INT_Nom != null) { intNId = INT_Nom.Code; } } //ITC Nomenclature Code string itcNid = ""; if (sec.ITC_NomenclatureID != Guid.Empty) { try { var itcid = sec.ITC_NomenclatureID.Value; TSMSector ITC_Nom = new TSMSector(); ITC_Nom = lstTSMSector.Where(u => u.ID == itcid && u.NomenclatureType == NomenclatureType.ITC && u.Type == sec.Type).FirstOrDefault(); if (ITC_Nom != null) { itcNid = ITC_Nom.Code; } } catch { } } if (itcNid == "") { TSMSector ITC_Nom = new TSMSector(); ITC_Nom = lstTSMSector.Where(u => u.Name == intSec && u.NomenclatureType == NomenclatureType.ITC && u.Type == sec.Type).FirstOrDefault(); if (ITC_Nom != null) { itcNid = ITC_Nom.Code; } } exportRecord.ITCCode = itcNid; exportRecord.INTCode = intNId; if (exportRecord != null) { ExportRecordData.Records.Add(exportRecord); ExportRecordData.RecID = exportRecord.RecordID; } } } } #endregion #region [sector = 0 && country > 1] else if ((exportRecordData.Countries.Count > 1) && (exportRecordData.Sectors.Count == 0)) { foreach (var cnt in exportRecordData.Countries) { Country_Language countryLanguage = lstCountryLang.Where(cl => cl.ID == cnt.ID).FirstOrDefault(); var selectedRegion = new List <Region>(); Country tmpCountry = listofAllCountries.Where(c => c.ID == exportRecordData.Countries[0].ID).FirstOrDefault(); if (tmpCountry != null) { foreach (var r in tmpCountry.Regions) { selectedRegion.Add(r); } } var regionLanguageList = (from rl in listofAllRegion join r in selectedRegion on rl.ID equals r.ID where r.Type == TSM.Entity.RegionType.Geographical && rl.LanguageID == languageId select rl.Name).ToList(); exportRecord = new ExportRecord(); //document try { if (exportRecordData.Documents.Count > 0) { exportRecord.Document = exportRecordData.Documents[0].Path.Split('.')[0].ToString(); } else { exportRecord.Document = null; } } catch { exportRecord.Document = ""; } //ID exportRecord.RecordID = exportRecordData.ID; //Name exportRecord.Name = exportRecordData.Record_Languages.FirstOrDefault().Name.ToString();//.ToLower(); //Regions if (regionLanguageList.Count > 0) { exportRecord.Regions = regionLanguageList[0].ToString(); } //Country exportRecord.Countries = countryLanguage.Name; exportRecord.CountryCode = cnt.ISOCode; //variable values exportRecord.VariableValues = new List <string>(); List <string> recordVariableKey = new List <string>(); foreach (var variableValue in ExportRecordData.Variables) { if (variableValue != null && variableValue.Value != null && !string.IsNullOrEmpty(variableValue.Value) && variableValue.Value != "") { recordVariableKey.Add(variableValue.Key); exportRecord.VariableValues.Add(SearchServices.GetVariableValueByVariableIdFromList(languageId, exportRecordData.ID, recordVariableKey, variableValue.Key, recordVariables)); //exportRecord.VariableValues.Add(SearchServices.GetVariableValueByVariableId(languageId, exportRecordData.ID, recordVariableKey, variableValue.Key)); } } if (exportRecord != null) { ExportRecordData.Records.Add(exportRecord); ExportRecordData.RecID = exportRecord.RecordID; } } } #endregion recordProcessed++; } catch (Exception ee) { recordNotProcessed++; ErrorLog.WriteLog("RebuildDownload", "AsyncCall", ee, ""); } } } ExportdataList.Add(ExportRecordData); //Save(ExportdataList); //return; if (SaveXMLToData(ExportdataList)) { isSaved = 1; TotalRows = ExportdataList[0].Records.Count.ToString(); //lblNumberRows.Text = TotalRows; ScriptManager.RegisterStartupScript(this, GetType(), "disableButton1", "$('#btnRebuildDownloadCache').prop('disabled', false); $('#loaderImg').hide();", true); ScriptManager.RegisterStartupScript(this, GetType(), "disableSuccess1", "$('#dvSuccess').show();", true); ScriptManager.RegisterStartupScript(this, GetType(), "disableFailure1", "$('#dvFailure').hide();", true); } else { isSaved = 2; ScriptManager.RegisterStartupScript(this, GetType(), "disableButton1", "$('#btnRebuildDownloadCache').prop('disabled', false); $('#loaderImg').hide();", true); ScriptManager.RegisterStartupScript(this, GetType(), "disableSuccess", "$('#dvSuccess').hide();", true); ScriptManager.RegisterStartupScript(this, GetType(), "disableFailure", "$('#dvFailure').show();", true); } #endregion } }
public ActionResult ExportPDF(string[] region, string[] country, string[] sector, string[] document, string[] year, string[] period, string[] last_Update, string[] counterpart, string[] DocCheckboxData, string[] thematicCheckboxData, string[] designProcessCheckboxData, string[] pagesize, string[] page, int?sortColumnIndex, int?sortDirection, string filetype) { SearchMapModel model = new SearchMapModel(); #region [Page] int pageSize = 20000; //if (pagesize != null) //{ // int.TryParse(pagesize[0], out pageSize); //} int Pages = 1; if (page != null) { int.TryParse(page[0], out Pages); } #endregion SearchAttributes searchParam = new SearchAttributes(); searchParam.CurrentPageNumber = Pages; // searchParam.RecordsPerPage = AppSettingsUtility.GetInt(AppSettingsKeys.RecordsPerPage); searchParam.RecordsPerPage = pageSize; if (sortColumnIndex.HasValue) { searchParam.SortColumnIndex = sortColumnIndex.Value; } else { searchParam.SortColumnIndex = 1; } searchParam.SortDirection = (sortDirection.HasValue && sortDirection.Value == 1) ? Entity.SortDirection.Descending : Entity.SortDirection.Ascending; model.SearchParam = searchParam; List <ExportRecordData> exportRecordData = new List <ExportRecordData>(); exportRecordData = model.GetExportFilteredData(region, country, sector, document, year, period, last_Update, counterpart, DocCheckboxData, thematicCheckboxData, designProcessCheckboxData, pageSize, model.SearchParam, sortColumnIndex, sortDirection); ExportList <ExportRecordData> exp = new ExportList <ExportRecordData>(); string filePathExport = string.Empty; exp.PathTemplateFolder = Server.MapPath("~/ExportTemplates/"); if (filetype == "excel") { filePathExport = Server.MapPath("~/ExportFiles/" + DateTime.Now.Ticks + ".xlsx"); exp.ExportTo(exportRecordData, ExportToFormat.Excel2007, filePathExport); } else if (filetype == "pdf") { filePathExport = Server.MapPath("~/ExportFiles/" + DateTime.Now.Ticks + ".csv"); exp.ExportTo(exportRecordData, ExportToFormat.CSV, filePathExport); } else if (filetype == "csv") { filePathExport = Server.MapPath("~/ExportFiles/" + DateTime.Now.Ticks + ".csv"); exp.ExportTo(exportRecordData, ExportToFormat.CSV, filePathExport); } else { filePathExport = Server.MapPath("~/ExportFiles/" + DateTime.Now.Ticks + ".csv"); exp.ExportTo(exportRecordData, ExportToFormat.CSV, filePathExport); } //return this.File(filePathExport, "application/octet-stream", System.IO.Path.GetFullPath(filePathExport)); return(Json(new { fileurl = "/ExportFiles/" + System.IO.Path.GetFileName(filePathExport) }, JsonRequestBehavior.AllowGet)); }
public void RebuildRecordAsync() { Console.WriteLine("Index Rebuild Started"); Guid languageId = TSM.Model.TSMContext.CurrentLanguageID; List <Record> record = new List <Record>(); List <Guid> listRecordsID = RecordService.GetAllRecordID(); List <ExportRecordData> ExportdataList = new List <ExportRecordData>(); if (listRecordsID != null) { SearchAttributes searchParam = GetSearchParam(); record = SearchServices.GetFilterRecordInformation(listRecordsID, 20000, searchParam); ExportRecordData ExportRecordData = new ExportRecordData(); ExportRecordData.Records = new List <ExportRecord>(); #region [If Not Null Record] if (record != null) { #region [Data Load] //Get Variable Items List <Variable_Language> variableItems = new List <Variable_Language>(); variableItems = SearchServices.GetVariableLanguageForVariable(languageId).ToList(); //Get Get All Country With Region List <Country> listofAllCountries = new List <Country>(); listofAllCountries = SearchServices.GetAllCountryWithRegion(); //Get list of All Region List <Region_Language> listofAllRegion = new List <Region_Language>(); listofAllRegion = SearchServices.GetAllRegionWithLanguage(); //Get list of All Country with language List <Country_Language> lstCountryLang = new List <Country_Language>(); lstCountryLang = SearchServices.GetAllCountry(languageId); //Get Sector Language List <Sector_Language> lstSectorLanguage = new List <Sector_Language>(); lstSectorLanguage = SearchServices.GetAllSectorNames(languageId); //Get Sector List <TSMSector> lstTSMSector = new List <TSMSector>(); lstTSMSector = SearchServices.GetAllSector(); // Get Record Variable List <Record_Variable> recordVariables = new List <Record_Variable>(); recordVariables = SearchServices.GetAllRecordVariable(); #endregion TotalRecord = record.Count; Console.WriteLine("Total Records: " + TotalRecord.ToString()); foreach (var exportRecordData in record) { try { ExportRecordData.Variables = new List <KeyValue>(); foreach (var keyValue in variableItems) { KeyValue keyValuevariableLanguageItem = new KeyValue { Key = keyValue.ID.ToString(), Value = keyValue.Name }; ExportRecordData.Variables.Add(keyValuevariableLanguageItem); } ExportRecord exportRecord = null; #region [sector = 0 && country = 1] if ((exportRecordData.Countries.Count == 1) && (exportRecordData.Sectors.Count == 0)) { exportRecord = new ExportRecord(); //document try { if (exportRecordData.Documents.Count > 0) { exportRecord.Document = exportRecordData.Documents[0].Path.Split('.')[0].ToString(); } else { exportRecord.Document = null; } } catch { exportRecord.Document = ""; } //ID exportRecord.RecordID = exportRecordData.ID; //Name exportRecord.Name = exportRecordData.Record_Languages.FirstOrDefault().Name.ToString(); //Regions start var selectedRegion = new List <Region>(); Country tmpCountry = listofAllCountries.Where(c => c.ID == exportRecordData.Countries[0].ID).FirstOrDefault(); if (tmpCountry != null) { foreach (var r in tmpCountry.Regions) { selectedRegion.Add(r); } } var regionLanguageList = (from rl in listofAllRegion join r in selectedRegion on rl.ID equals r.ID where r.Type == TSM.Entity.RegionType.Geographical && rl.LanguageID == languageId select rl.Name).ToList(); if (regionLanguageList.Count > 0) { exportRecord.Regions = regionLanguageList[0].ToString(); } //Region end //Country start Country_Language countryLanguage = lstCountryLang.Where(cl => cl.ID == exportRecordData.Countries[0].ID).FirstOrDefault(); exportRecord.Countries = countryLanguage.Name; //country end exportRecord.CountryCode = exportRecordData.Countries[0].ISOCode; //variable values exportRecord.VariableValues = new List <string>(); List <string> recordVariableKey = new List <string>(); foreach (var variableValue in ExportRecordData.Variables) { if (variableValue != null && variableValue.Value != null && !string.IsNullOrEmpty(variableValue.Value) && variableValue.Value != "") { recordVariableKey.Add(variableValue.Key); exportRecord.VariableValues.Add(SearchServices.GetVariableValueByVariableIdFromList(languageId, exportRecordData.ID, recordVariableKey, variableValue.Key, recordVariables)); } } if (exportRecord != null) { ExportRecordData.Records.Add(exportRecord); ExportRecordData.RecID = exportRecord.RecordID; } } #endregion #region [sector > 0 && country = 1] else if ((exportRecordData.Countries.Count == 1) && (exportRecordData.Sectors.Count > 0)) { foreach (var sec in exportRecordData.Sectors) { exportRecord = new ExportRecord(); //document try { if (exportRecordData.Documents.Count > 0) { exportRecord.Document = exportRecordData.Documents[0].Path.Split('.')[0].ToString(); } else { exportRecord.Document = null; } } catch { exportRecord.Document = ""; } //ID exportRecord.RecordID = exportRecordData.ID; //Name exportRecord.Name = exportRecordData.Record_Languages.FirstOrDefault().Name.ToString(); //Regions start var selectedRegion = new List <Region>(); Country tmpCountry = listofAllCountries.Where(c => c.ID == exportRecordData.Countries[0].ID).FirstOrDefault(); if (tmpCountry != null) { foreach (var r in tmpCountry.Regions) { selectedRegion.Add(r); } } var regionLanguageList = (from rl in listofAllRegion join r in selectedRegion on rl.ID equals r.ID where r.Type == TSM.Entity.RegionType.Geographical && rl.LanguageID == languageId select rl.Name).ToList(); if (regionLanguageList.Count > 0) { exportRecord.Regions = regionLanguageList[0].ToString(); } //Region end //Country start Country_Language countryLanguage = lstCountryLang.Where(cl => cl.ID == exportRecordData.Countries[0].ID).FirstOrDefault(); exportRecord.Countries = countryLanguage.Name; //country end exportRecord.CountryCode = exportRecordData.Countries[0].ISOCode; //variable values exportRecord.VariableValues = new List <string>(); List <string> recordVariableKey = new List <string>(); foreach (var variableValue in ExportRecordData.Variables) { if (variableValue != null && variableValue.Value != null && !string.IsNullOrEmpty(variableValue.Value) && variableValue.Value != "") { recordVariableKey.Add(variableValue.Key); exportRecord.VariableValues.Add(SearchServices.GetVariableValueByVariableIdFromList(languageId, exportRecordData.ID, recordVariableKey, variableValue.Key, recordVariables)); } } //sector Sector_Language secLang = lstSectorLanguage.Where(sl => sl.ID == sec.ID).FirstOrDefault(); exportRecord.Sectors = secLang.Name; exportRecord.SectorType = sec.Type.ToString(); var intSec = exportRecord.Sectors; //International Nomenclature Code string intNId = ""; if (sec.International_NomenclatureID != Guid.Empty) { try { var interNid = sec.International_NomenclatureID.Value; TSMSector INT_Nom = new TSMSector(); INT_Nom = lstTSMSector.Where(u => u.ID == interNid && u.NomenclatureType == NomenclatureType.International && u.Type == sec.Type).FirstOrDefault(); if (INT_Nom != null) { intNId = INT_Nom.Code; } } catch { } } if (intNId == "") { TSMSector INT_Nom = new TSMSector(); INT_Nom = lstTSMSector.Where(u => u.Name == intSec && u.NomenclatureType == NomenclatureType.International && u.Type == sec.Type).FirstOrDefault(); if (INT_Nom != null) { intNId = INT_Nom.Code; } } //ITC Nomenclature Code string itcNid = ""; if (sec.ITC_NomenclatureID != Guid.Empty) { try { var itcid = sec.ITC_NomenclatureID.Value; TSMSector ITC_Nom = new TSMSector(); ITC_Nom = lstTSMSector.Where(u => u.ID == itcid && u.NomenclatureType == NomenclatureType.ITC && u.Type == sec.Type).FirstOrDefault(); if (ITC_Nom != null) { itcNid = ITC_Nom.Code; } } catch { } } if (itcNid == "") { TSMSector ITC_Nom = new TSMSector(); ITC_Nom = lstTSMSector.Where(u => u.Name == intSec && u.NomenclatureType == NomenclatureType.ITC && u.Type == sec.Type).FirstOrDefault(); if (ITC_Nom != null) { itcNid = ITC_Nom.Code; } } exportRecord.ITCCode = itcNid; exportRecord.INTCode = intNId; if (exportRecord != null) { ExportRecordData.Records.Add(exportRecord); ExportRecordData.RecID = exportRecord.RecordID; } } } #endregion #region [sector > 0 && country > 1] else if ((exportRecordData.Countries.Count > 1) && (exportRecordData.Sectors.Count > 0)) { foreach (var cnt in exportRecordData.Countries) { Country_Language countryLanguage = lstCountryLang.Where(cl => cl.ID == cnt.ID).FirstOrDefault(); var selectedRegion = new List <Region>(); Country tmpCountry = listofAllCountries.Where(c => c.ID == exportRecordData.Countries[0].ID).FirstOrDefault(); if (tmpCountry != null) { foreach (var r in tmpCountry.Regions) { selectedRegion.Add(r); } } var regionLanguageList = (from rl in listofAllRegion join r in selectedRegion on rl.ID equals r.ID where r.Type == TSM.Entity.RegionType.Geographical && rl.LanguageID == languageId select rl.Name).ToList(); foreach (var sec in exportRecordData.Sectors) { exportRecord = new ExportRecord(); //document try { if (exportRecordData.Documents.Count > 0) { exportRecord.Document = exportRecordData.Documents[0].Path.Split('.')[0].ToString(); } else { exportRecord.Document = null; } } catch { exportRecord.Document = ""; } //ID exportRecord.RecordID = exportRecordData.ID; //Name exportRecord.Name = exportRecordData.Record_Languages.FirstOrDefault().Name.ToString(); //Regions if (regionLanguageList.Count > 0) { exportRecord.Regions = regionLanguageList[0].ToString(); } //Country exportRecord.Countries = countryLanguage.Name; exportRecord.CountryCode = cnt.ISOCode; //variable values exportRecord.VariableValues = new List <string>(); List <string> recordVariableKey = new List <string>(); foreach (var variableValue in ExportRecordData.Variables) { if (variableValue != null && variableValue.Value != null && !string.IsNullOrEmpty(variableValue.Value) && variableValue.Value != "") { recordVariableKey.Add(variableValue.Key); exportRecord.VariableValues.Add(SearchServices.GetVariableValueByVariableIdFromList(languageId, exportRecordData.ID, recordVariableKey, variableValue.Key, recordVariables)); } } //sector Sector_Language secLang = lstSectorLanguage.Where(sl => sl.ID == sec.ID).FirstOrDefault(); exportRecord.Sectors = secLang.Name; exportRecord.SectorType = sec.Type.ToString(); var intSec = exportRecord.Sectors; //International Nomenclature Code string intNId = ""; if (sec.International_NomenclatureID != Guid.Empty) { try { var interNid = sec.International_NomenclatureID.Value; TSMSector INT_Nom = new TSMSector(); INT_Nom = lstTSMSector.Where(u => u.ID == interNid && u.NomenclatureType == NomenclatureType.International && u.Type == sec.Type).FirstOrDefault(); if (INT_Nom != null) { intNId = INT_Nom.Code; } } catch { } } if (intNId == "") { TSMSector INT_Nom = new TSMSector(); INT_Nom = lstTSMSector.Where(u => u.Name == intSec && u.NomenclatureType == NomenclatureType.International && u.Type == sec.Type).FirstOrDefault(); if (INT_Nom != null) { intNId = INT_Nom.Code; } } //ITC Nomenclature Code string itcNid = ""; if (sec.ITC_NomenclatureID != Guid.Empty) { try { var itcid = sec.ITC_NomenclatureID.Value; TSMSector ITC_Nom = new TSMSector(); ITC_Nom = lstTSMSector.Where(u => u.ID == itcid && u.NomenclatureType == NomenclatureType.ITC && u.Type == sec.Type).FirstOrDefault(); if (ITC_Nom != null) { itcNid = ITC_Nom.Code; } } catch { } } if (itcNid == "") { TSMSector ITC_Nom = new TSMSector(); ITC_Nom = lstTSMSector.Where(u => u.Name == intSec && u.NomenclatureType == NomenclatureType.ITC && u.Type == sec.Type).FirstOrDefault(); if (ITC_Nom != null) { itcNid = ITC_Nom.Code; } } exportRecord.ITCCode = itcNid; exportRecord.INTCode = intNId; if (exportRecord != null) { ExportRecordData.Records.Add(exportRecord); ExportRecordData.RecID = exportRecord.RecordID; } } } } #endregion #region [sector = 0 && country > 1] else if ((exportRecordData.Countries.Count > 1) && (exportRecordData.Sectors.Count == 0)) { foreach (var cnt in exportRecordData.Countries) { Country_Language countryLanguage = lstCountryLang.Where(cl => cl.ID == cnt.ID).FirstOrDefault(); var selectedRegion = new List <Region>(); Country tmpCountry = listofAllCountries.Where(c => c.ID == exportRecordData.Countries[0].ID).FirstOrDefault(); if (tmpCountry != null) { foreach (var r in tmpCountry.Regions) { selectedRegion.Add(r); } } var regionLanguageList = (from rl in listofAllRegion join r in selectedRegion on rl.ID equals r.ID where r.Type == TSM.Entity.RegionType.Geographical && rl.LanguageID == languageId select rl.Name).ToList(); exportRecord = new ExportRecord(); //document try { if (exportRecordData.Documents.Count > 0) { exportRecord.Document = exportRecordData.Documents[0].Path.Split('.')[0].ToString(); } else { exportRecord.Document = null; } } catch { exportRecord.Document = ""; } //ID exportRecord.RecordID = exportRecordData.ID; //Name exportRecord.Name = exportRecordData.Record_Languages.FirstOrDefault().Name.ToString(); //Regions if (regionLanguageList.Count > 0) { exportRecord.Regions = regionLanguageList[0].ToString(); } //Country exportRecord.Countries = countryLanguage.Name; exportRecord.CountryCode = cnt.ISOCode; //variable values exportRecord.VariableValues = new List <string>(); List <string> recordVariableKey = new List <string>(); foreach (var variableValue in ExportRecordData.Variables) { if (variableValue != null && variableValue.Value != null && !string.IsNullOrEmpty(variableValue.Value) && variableValue.Value != "") { recordVariableKey.Add(variableValue.Key); exportRecord.VariableValues.Add(SearchServices.GetVariableValueByVariableIdFromList(languageId, exportRecordData.ID, recordVariableKey, variableValue.Key, recordVariables)); } } if (exportRecord != null) { ExportRecordData.Records.Add(exportRecord); ExportRecordData.RecID = exportRecord.RecordID; } } } #endregion recordProcessed++; int percentRecord = (recordProcessed / TotalRecord) * 100; //Console.Clear(); Console.WriteLine(recordProcessed.ToString() + " of " + TotalRecord.ToString() + " records done. Plese wait..."); } catch (Exception ee) { recordNotProcessed++; Console.WriteLine(recordNotProcessed.ToString() + " of " + TotalRecord.ToString()); ErrorLog.WriteLog("Import", "Import", ee, ""); } } } ExportdataList.Add(ExportRecordData); if (DeleteFile()) { Console.WriteLine("Delete Success"); if (SaveXMLToData(ExportdataList)) { Console.WriteLine("Save Success"); } else { Console.WriteLine("Save Error!"); } } else { Console.Write("Delete Error!"); } #endregion } Console.WriteLine(recordProcessed.ToString() + " of " + TotalRecord.ToString() + " & " + recordNotProcessed.ToString() + " fail(s)."); }