public string exportdetailsqueryresults(string start_time, string end_time, string hide_cols) { string response = ""; try { DateTime start = DateTime.Parse(start_time); DateTime end = DateTime.Parse(end_time); List <_cases> list = (from t in db_context.cases where t.report_time >= start && t.report_time <= end select new _cases() { insurant_name = t.insurant_name, insurant_habitation = t.insurant_habitation, accident_time = t.accident_time, is_reported = t.is_reported, is_submit = t.is_submit, report_time = t.report_time, hospital_type = t.hospital_type, invoice_amount = t.invoice_amount, deductible_amount = t.deductible_amount, subtract_amount = t.subtract_amount, compensation_type = t.compensation_type, compensation_amount = t.compensation_amount, current_state = t.current_state }).ToList(); FileOperate file_oper = new FileOperate(); response = file_oper.ExportDetailsQueryResults(start, end, list, hide_cols); } catch (Exception ex) { response = ex.Message; throw ex; } return(response); }
public string exportdetailsqueryresults(string start_time, string end_time, string hide_cols) { string response = ""; try { DateTime start = DateTime.Parse(start_time); DateTime end = DateTime.Parse(end_time); List<_cases> list = (from t in db_context.cases where t.report_time >= start && t.report_time <= end select new _cases() { insurant_name = t.insurant_name, insurant_habitation = t.insurant_habitation, accident_time = t.accident_time, is_reported = t.is_reported, is_submit = t.is_submit, report_time = t.report_time, hospital_type = t.hospital_type, invoice_amount = t.invoice_amount, deductible_amount = t.deductible_amount, subtract_amount = t.subtract_amount, compensation_type = t.compensation_type, compensation_amount = t.compensation_amount, current_state = t.current_state }).ToList(); FileOperate file_oper = new FileOperate(); response = file_oper.ExportDetailsQueryResults(start, end, list, hide_cols); } catch (Exception ex) { response = ex.Message; throw ex; } return response; }