public ActionResult GetReportSumaryReturnMoneyEat([DataSourceRequest] DataSourceRequest request, Can_ReportSumaryReturnMoneyEatSearchModel Model)
{
var service = new Can_ReportServices();
var hrService = new Hre_ProfileServices();
ListQueryModel lstModel = new ListQueryModel
{
PageIndex = request.Page,
PageSize = request.PageSize,
Filters = ExtractFilterAttributes(request),
Sorts = ExtractSortAttributes(request)
};
DateTime From = SqlDateTime.MinValue.Value;
DateTime To = SqlDateTime.MaxValue.Value;
if (Model.DateFrom != null)
{
From = Model.DateFrom.Value;
}
if (Model.DateTo != null)
{
To = Model.DateTo.Value;
}
var result = service.GetReportSumaryReturnMoneyEat(Model.CateringIDs, Model.CanteenIDs, Model.LineIDs, Model.WorkPlaceID, From, To, Model.OrgStructureID, Model.CodeEmp, Model.IsIncludeQuitEmp);
#region xử lý xuất báo cáo
if (Model.ExportID != Guid.Empty)
{
var fullPath = ExportService.Export(Model.ExportID, result);
return Json(fullPath);
}
#endregion
request.Page = 1;
var dataSourceResult = result.ToDataSourceResult(request);
return Json(result.ToDataSourceResult(request));
}
public ActionResult GetReportDetailCard([DataSourceRequest] DataSourceRequest request, Can_ReportDetailCardSearchModel Model)
{
var service = new Can_ReportServices();
var hrService = new Hre_ProfileServices();
ListQueryModel lstModel = new ListQueryModel
{
PageIndex = request.Page,
PageSize = request.PageSize,
Filters = ExtractFilterAttributes(request),
Sorts = ExtractSortAttributes(request)
};
DateTime From = SqlDateTime.MinValue.Value;
DateTime To = SqlDateTime.MaxValue.Value;
if (Model.DateFrom != null)
{
From = Model.DateFrom.Value;
}
if (Model.DateTo != null)
{
To = Model.DateTo.Value;
}
if (Model.CanteenID != null) Model.CanteenIDs.Add(Model.CanteenID);
if (Model.CateringID != null) Model.CateringIDs.Add(Model.CateringID);
if (Model.LineID != null) Model.LineIDs.Add(Model.LineID);
var result = service.ReportDetailCard(Model.CateringIDs, Model.CanteenIDs, Model.LineIDs, From, To, Model.OrgStructureID);
var rs = result.Translate<Can_ReportDetailCardModel>();
#region xử lý xuất báo cáo
if (Model.ExportID != Guid.Empty)
{
var fullPath = ExportService.Export(Model.ExportID, rs);
return Json(fullPath);
}
#endregion
request.Page = 1;
var dataSourceResult = result.ToDataSourceResult(request);
return Json(rs.ToDataSourceResult(request));
}
public ActionResult GetReportMultiSlideCard([DataSourceRequest] DataSourceRequest request, Can_ReportMultiSlideCardSearchModel Model)
{
var service = new Can_ReportServices();
var hrService = new Hre_ProfileServices();
var Actionservices = new ActionService(UserLogin);
ListQueryModel lstModel = new ListQueryModel
{
PageIndex = request.Page,
PageSize = request.PageSize,
Filters = ExtractFilterAttributes(request),
Sorts = ExtractSortAttributes(request)
};
DateTime From = SqlDateTime.MinValue.Value;
DateTime To = SqlDateTime.MaxValue.Value;
if (Model.DateFrom != null)
{
From = Model.DateFrom.Value;
}
if (Model.DateTo != null)
{
To = Model.DateTo.Value;
}
List<Guid?> OrgIds = new List<Guid?>();
if (Model.OrgStructureID != null && Model.OrgStructureID.Count() > 0)
{
OrgIds = Model.OrgStructureID;
}
string strOrgIDs = Common.ListToString(OrgIds);
string status = string.Empty;
string profilename = null;
string codeemp = null;
List<object> objectsearch = new List<object>();
objectsearch.Add(strOrgIDs);
objectsearch.Add(profilename);
objectsearch.Add(codeemp);
List<Guid> lstProfileIDs = Actionservices.GetData<Hre_ProfileIdEntity>(objectsearch, ConstantSql.hrm_hr_sp_get_ProfileIdsByOrg, ref status).Select(s => s.ID).ToList();
var result = service.ReportMultiSlideCard(Model.CateringID, Model.CanteenID, Model.LineID, Model.WorkPlaceID, From, To, lstProfileIDs, Model.IsIncludeQuitEmp);
var rs = result.Translate<Can_ReportMultiSlideCardModel>();
#region xử lý xuất báo cáo
if (Model.ExportID != Guid.Empty)
{
var fullPath = ExportService.Export(Model.ExportID, rs);
return Json(fullPath);
}
#endregion
request.Page = 1;
var dataSourceResult = result.ToDataSourceResult(request);
return Json(rs.ToDataSourceResult(request));
}
public ActionResult ComputeSumryMealRecord(Guid CutoffdurationID, string OrgStructureID)
{
BaseService baseservices = new BaseService();
var Actionservices = new ActionService(UserLogin);
string status = string.Empty;
List<object> listModel = new List<object>();
listModel.AddRange(new object[18]);
listModel[2] = OrgStructureID;
listModel[16] = 1;
listModel[17] = Int32.MaxValue - 1;
List<Hre_ProfileEntity> ListProfile = Actionservices.GetData<Hre_ProfileEntity>(listModel, ConstantSql.hrm_hr_sp_get_Profile, ref status);
Can_ReportServices CanteenServices = new Can_ReportServices();
bool result = CanteenServices.SaveSumryMealRecord(CutoffdurationID, ListProfile.Select(m => m.ID).ToList());
return Json(result, JsonRequestBehavior.AllowGet);
}
public ActionResult GetReportAdjustmentMealAllowancePayment([DataSourceRequest] DataSourceRequest request, Can_ReportAdjustmentMealAllowancePaymentModel Model)
{
var service = new Can_ReportServices();
var hrService = new Hre_ProfileServices();
var Actionservices = new ActionService(UserLogin);
ListQueryModel lstModel = new ListQueryModel
{
PageIndex = request.Page,
PageSize = request.PageSize,
Filters = ExtractFilterAttributes(request),
Sorts = ExtractSortAttributes(request)
};
DateTime From = SqlDateTime.MinValue.Value;
DateTime To = SqlDateTime.MaxValue.Value;
if (Model.DateFrom != null)
{
From = Model.DateFrom.Value;
}
if (Model.DateTo != null)
{
To = Model.DateTo.Value;
}
List<Guid?> OrgIds = new List<Guid?>();
if (Model.OrgStructureID != null && Model.OrgStructureID.Count() > 0)
{
OrgIds = Model.OrgStructureID;
}
string strOrgIDs = Common.ListToString(OrgIds);
string profileName = string.Empty;
string codeEmp = string.Empty;
if (Model.ProfileName != string.Empty)
{
profileName = Model.ProfileName;
}
if (Model.CodeEmp != string.Empty)
{
codeEmp = Model.CodeEmp;
}
List<Guid> lstProfileIDs = new List<Guid>();
List<Object> Lstsearch = new List<object>();
Lstsearch.Add(strOrgIDs);
Lstsearch.Add(profileName);
Lstsearch.Add(codeEmp);
if (Model.OrgStructureID != null)
{
string status = string.Empty;
lstProfileIDs = Actionservices.GetData<Hre_ProfileIdEntity>(Lstsearch, ConstantSql.hrm_hr_sp_get_ProfileIdsByOrg, ref status).Select(s => s.ID).ToList();
}
var result = service.ReportAdjustmentMealAllowancePayment(From, To, lstProfileIDs);
if (Model.ExportID != Guid.Empty)
{
var fullPath = ExportService.Export(Model.ExportID, result);
return Json(fullPath);
}
return Json(result.ToDataSourceResult(request));
}
public ActionResult GetReportMealTimeSummary([DataSourceRequest] DataSourceRequest request, Can_ReportMealTimeSummaryModel Model)
{
var service = new Can_ReportServices();
var hrService = new Hre_ProfileServices();
ListQueryModel lstModel = new ListQueryModel
{
PageIndex = request.Page,
PageSize = request.PageSize,
Filters = ExtractFilterAttributes(request),
Sorts = ExtractSortAttributes(request)
};
DateTime From = DateTime.Now.AddMonths(-1);
DateTime To = DateTime.Now;
if (Model.DateFrom != null)
{
From = Model.DateFrom.Value;
}
if (Model.DateTo != null)
{
To = Model.DateTo.Value;
}
string status = string.Empty;
var result = service.ReportMealTimeSummary(Model.CateringIDs,
Model.CanteenIDs,
Model.LineIDs,
From,
To,
Model.OrgIDs);
if (Model.ExportID != Guid.Empty)
{
var fullPath = ExportService.Export(Model.ExportID, result);
return Json(fullPath);
}
return Json(result.ToDataSourceResult(request));
}
