public Parameters()
{
dateFrom = DateTime.Now;
dateTo = DateTime.Now;
dateFormatPublish = new List <string> {
"DAY", "MONTH", "YEAR"
}; //{ "d.m.y", "dd.mm.yy", "dd/mm/yy", "M-yy" };
entityPublish = new List <string> {
"ACQ", "MT", "ECOMM"
};
PropertyRepo.propertyInitilize(typeof(FD_ACQ_D));
entitySelected = typeof(FD_ACQ_D).ToString();
ParametersPublish = (from s in PropertyRepo.properyList select s.propertyName).ToList(); //new List<string> { "MERCHANT", "PAY_SYS", "TYPE_TRANSACTION", "DT_REG", "ALL", "none" };
listCount = QueriesToDbSet.GetList();
selectedDateFormat = from s in dateFormatPublish select new SelectListItem {
Text = s.ToString()
};
selectedParameters = from s in ParametersPublish select new SelectListItem {
Text = s.ToString()
};
selectedEntity = from s in entityPublish select new SelectListItem {
Text = s.ToString()
};
}
public static IQueryable <FD_ACQ_DTO> list_group(Parameters parameters_)
{
bool cond = PropertyRepo.GetPropertyCondition("DT_REG");
return
(from s in list_d(parameters_)
group s by new
{
DT_REG = FIELDS_REF.dt_reg != false ? s.DT_REG : null,
TYPE_TRANSACTION = FIELDS_REF.tran_type != null ? s.TYPE_TRANSACTION : null,
MERCHANT = FIELDS_REF.merchant != null ? s.MERCHANT : null,
PAY_SYS = FIELDS_REF.pay_sys != null ? s.PAY_SYS : null
} into g
select new FD_ACQ_DTO
{
DT_REG = g.Key.DT_REG != null ? g.Key.DT_REG : null,
TYPE_TRANSACTION = g.Key.TYPE_TRANSACTION != null ? g.Key.TYPE_TRANSACTION : null,
MERCHANT = g.Key.MERCHANT != null ? g.Key.MERCHANT : null,
PAY_SYS = g.Key.PAY_SYS != null ? g.Key.PAY_SYS : null,
AMT = g.Sum(s => s.AMT)
});
}
