public static string GetQueryForReconciliedData(ViewModelClass.ReconciliationFilter filter) { string query = "Select * from NonCustom_GLReconciliationTable where "; int qrylength = query.Length; if (!string.IsNullOrEmpty(filter.CardNumber) && !string.IsNullOrEmpty(filter.MemberCaseNumber)) { query = query + "MemberCase='" + filter.MemberCaseNumber.Trim() + "' and CardNumber ='" + filter.CardNumber.Trim() + "' and"; } else if (!string.IsNullOrEmpty(filter.MemberCaseNumber)) { query = query + "MemberCase='" + filter.MemberCaseNumber.Trim() + "' and"; } else if (!string.IsNullOrEmpty(filter.CardNumber)) { query = query + "CardNumber='" + filter.CardNumber.Trim() + "' and"; } query += " IsActive='1';"; return(query); }
public static List <NonCustom_GLReconciliationTable> GetReconsiledReportFilterd(ViewModelClass.ReconciliationFilter filter) { List <NonCustom_GLReconciliationTable> list = new List <NonCustom_GLReconciliationTable>(); try { CBDB db = new CBDB(); list = db.NonCustom_GLReconciliationTable.SqlQuery(GetQueryForReconciliedData(filter)).ToList(); } catch (Exception ex) { throw ex; } return(list); }