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);
}