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