public JuridicalWhere ReturnDate(JuridicalFilters date_where)
{
return(new JuridicalWhere
{
dateFrom = Utils.Utils.GetRequestDate(date_where.dt_from, true),
dateTo = Utils.Utils.GetRequestDate(date_where.dt_to, false),
where = ReturnWhere(date_where),
_filter = date_where.drp_filter,
page = date_where.page
});
}
public string ReturnWhere(JuridicalFilters filter)
{
string where = "";
if (filter.name != null)
{
where = "and " + filter.drp_filter + " LIKE N'%" + filter.name + "%'";
if (filter.drp_filter == "cr.status" || filter.drp_filter == "cr.tower_id" || filter.drp_filter == "c.type")
{
where = filter.drp_filter + "=" + filter.name;
}
else if (filter.drp_filter == "c.lastname c.name")
{
filter.drp_filter = "c.lastname+c.name";
where = "and " + filter.drp_filter + " LIKE N'%" + filter.name + "%'";
}
where = where.Replace("+", "+' '+");
}
if (filter.status != null && filter.status != "")
{
if (filter.j_checked == false || filter.j_checked == null)
{
if (filter.status == "-1")
{
where = where + "and cr.juridical_verify_status LIKE '%" + filter.status + "%' and cr.juridical_verification LIKE '%" + filter.status + "%'";
}
else
{
where = where + " and cr.juridical_verify_status='" + filter.status + "'";
}
}
else
{
where = where + "and cr.juridical_verify_status LIKE '%" + filter.status + "%'";
}
}
return(where);
}
public async System.Threading.Tasks.Task <JuridicalModel> EndJuridical(JuridicalFilters juridicalFilter)
{
JuridicalLogic juridicalLogic = new JuridicalLogic();
return(await juridicalLogic.ReturnResult(juridicalFilter));
}
//public JuridicalLogic() { }
public async System.Threading.Tasks.Task <JuridicalModel> ReturnResult(JuridicalFilters juridicalFil)
{
JuridicalData juridicalData = new JuridicalData();
return(await juridicalData.ReturnResultJuridical(juridicalFil, ReturnDate(juridicalFil)));
}
//public JuridicalData()
//{
//}
public async System.Threading.Tasks.Task <JuridicalModel> ReturnResultJuridical(JuridicalFilters juridicalFilter, JuridicalWhere juridicalWhereQuery)
{
using (DataContext _db = new DataContext())
{
var _counts = await _db.Database.SqlQuery <int>(FilterCount(juridicalWhereQuery)).FirstOrDefaultAsync();
return(new JuridicalModel
{
JuridicalStatus = _db.Database.SqlQuery <JuridicalStatus>("SELECT * FROM dbo.JuridicalStatus").ToList(),
count = _counts,
juridicalLists = await _db.Database.SqlQuery <JuridicalResult>(Filter(juridicalWhereQuery)).ToRawPagedListAsync(_counts, juridicalFilter.page, juridicalWhereQuery.pageSize),
page = juridicalFilter.page,
drpfiltet = juridicalFilter.drp_filter,
filterText = juridicalFilter.name,
totalItemsCount = _counts
});
}
}
