public DataTable GetExportNcb(ExportNcbSearchFilter searchFilter) { _reportDataAccess = new ReportDataAccess(_context); IList <ExportNcbEntity> exportNcb = _reportDataAccess.GetExportNcb(searchFilter); DataTable dt = DataTableHelpers.ConvertTo(exportNcb); return(dt); }
public DataTable GetExportVerifyDetail(ExportVerifyDetailSearchFilter searchFilter) { _reportDataAccess = new ReportDataAccess(_context); IList <ExportVerifyDetailEntity> exportVerifyDetail = _reportDataAccess.GetExportVerifyDetail(searchFilter); DataTable dt = DataTableHelpers.ConvertTo(exportVerifyDetail); return(dt); }
protected override void ProcessRecord() { var cellmap = VisioScripting.Models.CellSrcDictionary.GetCellMapForPages(); if (this.Cells == null || this.Cells.Length < 1 || this.Cells.Contains("*")) { this.Cells = cellmap.GetNames().ToArray(); } Get_VisioPageCell.EnsureEnoughCellNames(this.Cells); var target_page = this.Page ?? this.Client.Page.Get(); this.WriteVerbose("Valid Names: " + string.Join(",", cellmap.GetNames())); var query = cellmap.ToQuery(this.Cells); var surface = new ShapeSheetSurface(target_page); var target_shapeids = new[] { surface.Target.Page.PageSheet.ID }; var dt = DataTableHelpers.QueryToDataTable(query, this.GetResults, this.ResultType, target_shapeids, surface); this.WriteObject(dt); }
public string GetEmployees(DataTableAjaxPostViewModel model) { SearchComponents searchComponents = DataTableHelpers.DataTableAjaxPostViewModelToComponents <Employee>(model); Column dateOfBirthColumn = model.Columns.Single(c => c.Data == "DateOfBirth"); searchComponents.FilterProps["DateOfBirth"] = new Dictionary <string, DateTime?> { { "MinDate", dateOfBirthColumn.DateSearch.MinDate }, { "MaxDate", dateOfBirthColumn.DateSearch.MaxDate } }; int recordsTotal = Employee.TotalCount(); int recordsFiltered = Employee.FilteredCount(searchComponents.SearchTerm, searchComponents.FilterProps); IEnumerable <Employee> employees = Employee.SearchEmployees(searchComponents.SearchTerm, searchComponents.Take, searchComponents.Skip, searchComponents.OrderBy, searchComponents.OrderDirection, searchComponents.FilterProps); return(JsonConvert.SerializeObject(new { model.Draw, recordsTotal, recordsFiltered, data = employees })); }
protected override void ProcessRecord() { var cellmap = CellSrcDictionary.GetCellMapForShapes(); if (this.Cells == null || this.Cells.Length < 1 || this.Cells.Contains("*")) { this.Cells = cellmap.GetNames().ToArray(); } Get_VisioPageCell.EnsureEnoughCellNames(this.Cells); var target_shapes = this.Shapes ?? this.Client.Selection.GetShapes(); var v = string.Join(",", cellmap.GetNames()); this.WriteVerbose(string.Format("Valid Names: {0}", v)); var query = cellmap.ToQuery(this.Cells); var surface = this.Client.ShapeSheet.GetShapeSheetSurface(); var target_shapeids = target_shapes.Select(s => s.ID).ToList(); var dt = DataTableHelpers.QueryToDataTable(query, this.GetResults, this.ResultType, target_shapeids, surface); this.WriteObject(dt); }
public bool SaveBdwContact(List <BdwContactEntity> bdwContacts) { SqlConnection con = null; SqlBulkCopy bc = null; try { if (bdwContacts != null && bdwContacts.Count > 0) { _context.Database.ExecuteSqlCommand("DELETE FROM TB_I_BDW_CONTACT"); this.Save(); int pageSize = 5000; int totalPage = (bdwContacts.Count + pageSize - 1) / pageSize; Task.Factory.StartNew(() => Parallel.For(0, totalPage, new ParallelOptions { MaxDegreeOfParallelism = WebConfig.GetTotalCountToProcess() }, k => { var lstContact = from contact in bdwContacts.Skip(k * pageSize).Take(pageSize) select new TB_I_BDW_CONTACT { DATA_TYPE = contact.DataType, DATA_DATE = contact.DataDate, DATA_SOURCE = contact.DataSource, CARD_NO = contact.CardNo, TITILE_TH = contact.TitileTh, NAME_TH = contact.NameTh, SURNAME_TH = contact.SurnameTh, TITILE_EN = contact.TitileEn, NAME_EN = contact.NameEn, SURNAME_EN = contact.SurnameEn, ACCOUNT_NO = contact.AccountNo, LOAN_MAIN = contact.LoanMain, PRODUCT_GROUP = contact.ProductGroup, PRODUCT = contact.Product, RELATIONSHIP = contact.Relationship, PHONE = contact.Phone, ACCOUNT_STATUS = contact.AccountStatus, CARD_TYPE_CODE = contact.CardTypeCode, CAMPAIGN = contact.Campaign }; DataTable dt = DataTableHelpers.ConvertTo(lstContact); con = new SqlConnection(WebConfig.GetConnectionString("CSMConnectionString")); bc = new SqlBulkCopy(con.ConnectionString, SqlBulkCopyOptions.TableLock); bc.DestinationTableName = "TB_I_BDW_CONTACT"; bc.BatchSize = dt.Rows.Count; con.Open(); bc.WriteToServer(dt); })).Wait(); bdwContacts = null; // clear } return(true); } catch (Exception ex) { Logger.Error("Exception occur:\n", ex); } finally { if (bc != null) { bc.Close(); } if (con != null) { con.Close(); } } return(false); }
public bool InsertHRTempTable(List <HRIEmployeeEntity> data) { SqlConnection con = null; SqlBulkCopy bc = null; try { if (data != null && data.Any()) { //_context.Database.ExecuteSqlCommand("TRUNCATE TABLE TB_I_HR_EMPLOYEE;"); _context.Database.ExecuteSqlCommand("DELETE FROM TB_I_HR_EMPLOYEE;"); Save(); int pageSize = 5000; int totalPage = (data.Count() + pageSize - 1) / pageSize; Task.Factory.StartNew(() => Parallel.For(0, totalPage, new ParallelOptions { MaxDegreeOfParallelism = WebConfig.GetTotalCountToProcess() }, k => { var lst = from d in data.Skip(k * pageSize).Take(pageSize) select new TB_I_HR_EMPLOYEE { BRANCH = d.Branch, BRANCHDESC = d.BranchDesc, EMPLOYEEID = d.EmployeeId, TITLEID = d.TitleId, TTITLE = d.Title, TFNAME = d.FName, TLNAME = d.LName, NICKNAME = d.Nickname, XENGNAME = d.FullNameEng, ETITLE = d.ETitle, EFNAME = d.EFName, ELNAME = d.ELName, SEX = d.Sex, BIRTHDAY = d.BirthDay, EMPTYPE = d.EmpType, EMPTYPEDESC = d.EmpTypeDesc, POSITION = d.Position, POSITONDESC = d.PositionDesc, BU1 = d.BU1, BU1DESC = d.BU1Desc, BU2 = d.BU2, BU2DESC = d.BU2Desc, BU3 = d.BU3, BU3DESC = d.BU3Desc, BU4 = d.BU4, BU4DESC = d.BU4Desc, JOB = d.Job, JOBPOSITION = d.JobPosition, STARTDATE = d.StartDate, FIRSTHIREDATE = d.FirstHireDate, RESIGNDATE = d.ResignDate, STATUS = d.Status, EMAIL = d.Email, NOTESADDRESS = d.NotesAddress, WORKAREA = d.WorkArea, WORKAREADESC = d.WorkAreaDesc, COSTCENTER = d.CostCenter, COSTCENTERDESC = d.CostCenterDesc, TELEXT = d.TelExt, BOSS = d.Boss, BOSSNAME = d.BossName, ASSESSOR1 = d.Assessor1, ASSESSOR1NAME = d.Assessor1Name, ASSESSOR2 = d.Assessor2, ASSESSOR2NAME = d.Assessor2Name, ASSESSOR3 = d.Assessor3, ASSESSOR3NAME = d.Assessor3Name, TELNO = d.TelNo, MOBILENO = d.MobileNo, ADUSER = d.ADUser, OFFICER_ID = d.OfficerId, OFFICER_DESC = d.OfficerDesc, ADDITIONJOB = d.AdditionJob, UNITBOSS = d.UnitBoss, UNITBOSSNAME = d.UnitBossName, IDNO = d.IDNO, ERROR = d.Error }; DataTable dt = DataTableHelpers.ConvertTo(lst); con = new SqlConnection(WebConfig.GetConnectionString("CSMConnectionString")); bc = new SqlBulkCopy(con.ConnectionString, SqlBulkCopyOptions.TableLock); bc.DestinationTableName = "TB_I_HR_EMPLOYEE"; bc.BatchSize = dt.Rows.Count; con.Open(); bc.WriteToServer(dt); })).Wait(); data = null; // clear } return(true); } catch (Exception ex) { Logger.Error("Exception occur:\n", ex); } finally { if (bc != null) { bc.Close(); } if (con != null) { con.Close(); } } return(false); }