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