/// <summary>
/// Get query filter search descriptor.
/// </summary>
/// <param name="search">The search value.</param>
/// <returns></returns>
private Func <SearchDescriptor <VendorTransectionElasticSearchModel>, ISearchRequest> GetQueryFilter(VendorTransectionSearchViewModel search)
{
var startDate = UtilityService.ConvertToDateTime(search.StartDate, ConstantValue.DateTimeFormat);
var endDate = UtilityService.ConvertToDateTime(search.EndDate, ConstantValue.DateTimeFormat);
ISearchRequest searchFunc(SearchDescriptor <VendorTransectionElasticSearchModel> s) => s
.Index(ConstantValue.VendorTransactionIndex)
//.From(0)
//.Take(1000)
.Query(q =>
//q.Bool(b =>
// //b.Must(m =>
// // m.Match(mm =>
// // mm.Field(f => search.PurGroup.Contains(f.PurgropCode))
// // .Field(f => _token.PurchasingOrg.Contains(f.PurorgCode))
// // ))
// //b.Filter(ff =>
// // // ff.DateRange(t => t.Field(f => f.ReceiptDate).GreaterThanOrEquals(startDate).LessThanOrEquals(endDate)) &&
// // ff.Term(t => t.Field(f => f.PurgropCode).Value(search.PurGroup))
// //)
// )
q.Match(m => m.Field(f => search.PurGroup.Contains(f.PurgropCode)))
)
.Sort(m => m.Descending(f => f.Id));
return(searchFunc);
}
/// <summary>
/// Holiday logic edit item.
/// </summary>
/// <param name="year">The year target holiday calendar.</param>
/// <param name="holidayList">The holiday list.</param>
/// <param name="data">The master holiday target year list for edit.</param>
/// <param name="updateHoliday">The holiday data update.</param>
/// <param name="addHoliday">The new holiday.</param>
private void InitialEditHolidayCalendar(string year,
IEnumerable <HolidayCalendarDetail> holidayList,
IEnumerable <HolidayCalendar> data,
List <HolidayCalendar> updateHoliday,
List <HolidayCalendar> addHoliday)
{
foreach (var item in holidayList)
{
item.HolidayDate = UtilityService.ConvertToDateTime(item.HolidayDateString, ConstantValue.DateTimeFormat);
var holidayItem = data.FirstOrDefault(x => x.HolidayDate.Value.Date == item.HolidayDate.Date);
if (holidayItem != null)
{
holidayItem.LastModifyBy = _token.EmpNo;
holidayItem.LastModifyDate = DateTime.Now;
holidayItem.Description = item.Description;
updateHoliday.Add(holidayItem);
}
else
{
addHoliday.Add(new HolidayCalendar
{
Year = year,
HolidayDate = item.HolidayDate,
Description = item.Description,
CreateBy = _token.EmpNo,
CreateDate = DateTime.Now
});
}
}
}
/// <summary>
/// The Method insert employee information.
/// </summary>
/// <param name="formData">The employee data.</param>
private void SaveEmployee(RegisterViewModel formData)
{
var data = _mapper.Map <RegisterViewModel, Employee>(formData);
data.StartWorkingDay = UtilityService.ConvertToDateTime(formData.StartWorkingDayText, ConstantValue.DATE_TIME_FORMAT);
_unitOfWork.GetRepository <Employee>().Add(data);
_unitOfWork.Complete();
}
/// <summary>
/// Initial evaluation string to datetime.
/// </summary>
/// <param name="periodItems">The period group items.</param>
private IEnumerable <PeriodItemViewModel> InitialEvaluationDate(IEnumerable <PeriodItemViewModel> periodItems)
{
foreach (var item in periodItems)
{
item.StartEvaDate = UtilityService.ConvertToDateTime(item.StartEvaDateString, ConstantValue.DateTimeFormat);
item.EndEvaDate = UtilityService.ConvertToDateTime(item.EndEvaDateString, ConstantValue.DateTimeFormat);
}
return(periodItems);
}
/// <summary>
/// Get Vendor transection.
/// </summary>
/// <param name="startDateString">The start transection date.</param>
/// <param name="endDateString">The end transection date.</param>
/// <param name="purGroup">The purGroup code.</param>
/// <returns></returns>
public IEnumerable <VendorTransaction> GetTransections(string startDateString, string endDateString, string[] purGroup)
{
var startDate = UtilityService.ConvertToDateTime(startDateString, ConstantValue.DateTimeFormat);
var endDate = UtilityService.ConvertToDateTime(endDateString, ConstantValue.DateTimeFormat);
return(_unitOfWork.GetRepository <VendorTransaction>().Get(x => purGroup.Contains(x.PurgropCode) &&
_token.PurchasingOrg.Contains(x.PurorgCode) &&
x.ReceiptDate.Value.Date >= startDate.Date &&
x.ReceiptDate.Value.Date <= endDate.Date));
}
/// <summary>
/// Get Transection list by condition.
/// </summary>
/// <param name="startDateString">The start transection date.</param>
/// <param name="endDateString">The end transection date.</param>
/// <param name="purGroup">The purGroup code.</param>
/// <param name="comCode">The company code.</param>
/// <param name="purOrg">The purchase org.</param>
/// <returns></returns>
public IEnumerable <VendorTransaction> GetTransections(string startDateString, string endDateString, string[] purGroup, string comCode, string purOrg)
{
var startDate = UtilityService.ConvertToDateTime(startDateString, ConstantValue.DateTimeFormat);
var endDate = UtilityService.ConvertToDateTime(endDateString, ConstantValue.DateTimeFormat);
return(_unitOfWork.GetRepository <VendorTransaction>().Get(x => purGroup.Contains(x.PurgropCode) &&
x.CompanyCode == comCode &&
x.PurorgCode == purOrg &&
x.ReceiptDate.Value.Date >= startDate.Date &&
x.ReceiptDate.Value.Date <= endDate.Date));
//return _elasticSearch.SearchFilter(this.GetQueryFilter(startDate, endDate, purGroup, comCode, purOrg));
}
/// <summary>
/// Insert new Plan item.
/// </summary>
/// <param name="model">The Plan information value.</param>
/// <returns></returns>
public ResultViewModel Save(PlanViewModel model)
{
var result = new ResultViewModel();
using (TransactionScope scope = new TransactionScope())
{
var plan = _mapper.Map <PlanViewModel, Plan>(model);
plan.CreateBy = _token.EmpId;
plan.StartDate = UtilityService.ConvertToDateTime(model.StartDate, ConstantValue.DateTimeFormat);
plan.EndDate = UtilityService.ConvertToDateTime(model.EndDate, ConstantValue.DateTimeFormat);
_unitOfWork.GetRepository <Plan>().Add(plan);
_unitOfWork.Complete(scope);
}
return(result);
}
/// <summary>
/// Update Plan item.
/// </summary>
/// <param name="model">The Plan information value.</param>
/// <returns></returns>
public ResultViewModel Edit(PlanViewModel model)
{
var result = new ResultViewModel();
using (TransactionScope scope = new TransactionScope())
{
var plan = _unitOfWork.GetRepository <Plan>().GetById(model.Id);
plan.PlanName = model.PlanName;
plan.StartDate = UtilityService.ConvertToDateTime(model.StartDate, ConstantValue.DateTimeFormat);
plan.EndDate = UtilityService.ConvertToDateTime(model.EndDate, ConstantValue.DateTimeFormat);
_unitOfWork.GetRepository <Plan>().Update(plan);
_unitOfWork.Complete(scope);
}
return(result);
}
/// <summary>
/// Update delegate task user.
/// </summary>
/// <param name="model">The information delegate task.</param>
/// <returns></returns>
public ResultViewModel UpdateDelegate(WorkflowDelegateViewModel model)
{
var result = new ResultViewModel();
model.StartDate = UtilityService.ConvertToDateTime(model.StartDateString, ConstantValue.DateTimeFormat);
model.EndDate = UtilityService.ConvertToDateTime(model.EndDateString, ConstantValue.DateTimeFormat);
using (TransactionScope scope = new TransactionScope())
{
var data = _mapper.Map <WorkflowDelegateViewModel, WorkflowDelegate>(model);
_unitOfWork.GetRepository <WorkflowDelegate>().Update(data);
_k2Service.SetOutofOffice(data.FromUser, data.ToUser, ConstantValue.K2SharingEdit, data.StartDate.Value, data.EndDate.Value);
_unitOfWork.Complete(scope);
}
return(result);
}
/// <summary>
/// Update TimeSheet to database.
/// </summary>
/// <param name="timeSheetList">The TimeSheet information.</param>
/// <param name="email">The owner timesheet and tasklist.</param>
private void UpdateTimeSheet(List <TimeSheetModel> timeSheetList, string email)
{
foreach (var item in timeSheetList)
{
var data = new TimeSheet.Data.Pocos.TimeSheet
{
Id = item.TimeSheetId,
Email = email,
DateTimeStamp = UtilityService.ConvertToDateTime(item.DateTimeStamp, ConstantValue.DATE_TIME_FORMAT)
};
_unitOfWork.GetRepository <Data.Pocos.TimeSheet>().Update(data);
_unitOfWork.Complete();
item.TaskList = item.TaskList.Select(c => { c.TimeSheetId = data.Id; return(c); }).ToList();
this.UpdateTaskList(item.TimeSheetId, item.TaskList);
}
}
/// <summary>
/// Save deletegate task fromuser touser.
/// </summary>
/// <param name="model">The information delegate task.</param>
/// <returns></returns>
public ResultViewModel SaveDelegateFromInbox(WorkflowDelegateRequestModel model)
{
var result = new ResultViewModel();
using (TransactionScope scope = new TransactionScope())
{
var data = new WorkflowDelegate
{
FromUser = _token.AdUser,
ToUser = model.ToUser,
StartDate = UtilityService.ConvertToDateTime(model.StartDate, ConstantValue.DateTimeFormat),
EndDate = UtilityService.ConvertToDateTime(model.EndDate, ConstantValue.DateTimeFormat)
};
_unitOfWork.GetRepository <WorkflowDelegate>().Add(data);
_k2Service.SetOutofOffice(data.FromUser, data.ToUser, ConstantValue.K2SharingCreate, data.StartDate.Value, data.EndDate.Value);
_unitOfWork.Complete(scope);
}
return(result);
}
/// <summary>
/// Insert new Contract item.
/// </summary>
/// <param name="model">The Contract information value.</param>
/// <returns></returns>
public ResultViewModel Save(ContractViewModel model, string status)
{
var result = new ResultViewModel();
using (TransactionScope scope = new TransactionScope())
{
var contract = _mapper.Map <ContractViewModel, Data.Pocos.Contract>(model);
contract.StartDate = UtilityService.ConvertToDateTime(model.StartDateString, ConstantValue.DateTimeFormat);
contract.EndDate = UtilityService.ConvertToDateTime(model.EndDateString, ConstantValue.DateTimeFormat);
contract.Status = status;
_unitOfWork.GetRepository <Data.Pocos.Contract>().Add(contract);
_unitOfWork.Complete();
this.SaveItem(contract.Id, model.ContractItems);
_unitOfWork.Complete(scope);
}
_activityTimeLine.Save(new ActivityTimeLineViewModel {
AccountId = model.AccountId.Value, ActivityComment = ConstantValue.ActCreateContract
});
return(result);
}
/// <summary>
/// Update Contract item.
/// </summary>
/// <param name="model">The ContractType information value.</param>
/// <returns></returns>
public ResultViewModel Edit(ContractViewModel model, string status)
{
var result = new ResultViewModel();
using (TransactionScope scope = new TransactionScope())
{
var contract = _unitOfWork.GetRepository <Data.Pocos.Contract>().Get(x => x.Id == model.Id).FirstOrDefault();
contract.Contract1 = model.Contract1;
contract.MainContract = model.MainContract;
contract.StartDate = UtilityService.ConvertToDateTime(model.StartDateString, ConstantValue.DateTimeFormat);
contract.EndDate = UtilityService.ConvertToDateTime(model.EndDateString, ConstantValue.DateTimeFormat);
contract.Status = status;
_unitOfWork.GetRepository <Data.Pocos.Contract>().Update(contract);
this.EditItem(contract.Id, model.ContractItems);
_unitOfWork.Complete(scope);
}
_activityTimeLine.Save(new ActivityTimeLineViewModel {
AccountId = model.AccountId.Value, ActivityComment = ConstantValue.ActEditContract
});
return(result);
}
/// <summary>
/// Get TimeSheet Stamp.
/// </summary>
/// <param name="email">The employee email.</param>
/// <param name="date">The target month.</param>
/// <returns></returns>
private IEnumerable <TimeSheetModel> GetTimeSheet(string email, string date)
{
var result = new List <TimeSheetModel>();
var startDate = SetToFirstDay(UtilityService.ConvertToDateTime(date, ConstantValue.DATE_TIME_FORMAT));
var endDate = SetToLastDay(startDate);
var dataList = _unitOfWork.GetRepository <TimeSheet.Data.Pocos.TimeSheet>().Get(x => x.Email == email &&
(x.DateTimeStamp.Value.Date >= startDate.Date &&
x.DateTimeStamp.Value.Date <= endDate.Date));
foreach (var data in dataList)
{
result.Add(new TimeSheetModel
{
TimeSheetId = data.Id,
DateTimeStamp = data.DateTimeStamp.Value.ToString(ConstantValue.DATE_TIME_FORMAT),
TaskList = this.GetTaskList(data.Id).ToList()
});
}
return(result);
}
/// <summary>
/// Insert TimeSheet to database.
/// </summary>
/// <param name="timeSheetList">The TimeSheet information.</param>
/// <param name="email">The owner timesheet and tasklist.</param>
private void SaveTimeSheet(List <TimeSheetModel> timeSheetList, string email, ref ResultViewModel result)
{
foreach (var item in timeSheetList)
{
var data = new TimeSheet.Data.Pocos.TimeSheet
{
Email = email,
DateTimeStamp = UtilityService.ConvertToDateTime(item.DateTimeStamp, ConstantValue.DATE_TIME_FORMAT)
};
if (!IsAlreadyDateTimeStamp(data.DateTimeStamp.Value))
{
_unitOfWork.GetRepository <Data.Pocos.TimeSheet>().Add(data);
_unitOfWork.Complete();
item.TaskList = item.TaskList.Select(c => { c.TimeSheetId = data.Id; return(c); }).ToList();
SaveTaskList(item.TaskList);
}
else
{
result = UtilityService.InitialResultError($"The {data.DateTimeStamp.Value.ToString("yyyy-MM-dd")} is already exits.");
}
}
}
/// <summary>
/// Insert new holiday canlendar.
/// </summary>
/// <param name="model">The holiday calendar information value.</param>
/// <returns></returns>
public ResultViewModel Save(HolidayCalendarViewModel model)
{
var result = new ResultViewModel();
using (TransactionScope scope = new TransactionScope())
{
var data = new List <HolidayCalendar>();
foreach (var item in model.HolidayList)
{
data.Add(new HolidayCalendar
{
Year = model.Year,
HolidayDate = UtilityService.ConvertToDateTime(item.HolidayDateString, ConstantValue.DateTimeFormat),
Description = item.Description,
CreateBy = _token.EmpNo,
CreateDate = DateTime.Now
});
}
_unitOfWork.GetRepository <HolidayCalendar>().AddRange(data);
_unitOfWork.Complete(scope);
}
this.ReloadCacheHolidayCalendar();
return(result);
}
