public List <SummarySalesVM> GetSalesSummary(int organizationId = 0, string FromBillDate = "", string ToBillDate = "", string GroupNo = "", string BillNo = "", string IsStaff = "", int ClassId = 0, int SectionId = 0, int StudentId = 0, int StaffId = 0) { string sql = " exec SummarySalesReport " + organizationId; if (!string.IsNullOrEmpty(FromBillDate)) { sql += " ,'" + FromBillDate + "'"; } else { sql += " ,null"; } if (!string.IsNullOrEmpty(ToBillDate)) { sql += " ,'" + ToBillDate + "'"; } else { sql += " ,null"; } if (!string.IsNullOrEmpty(GroupNo)) { sql += " ,'" + GroupNo + "'"; } else { sql += " ,null"; } if (!string.IsNullOrEmpty(BillNo)) { sql += " ,'" + BillNo + "'"; } else { sql += " ,null"; } if (!string.IsNullOrEmpty(IsStaff)) { if (IsStaff == "Yes") { sql += " ,1,0,0,0"; if (StaffId > 0) { sql += "," + StaffId; } } else if (IsStaff == "No") { sql += " ,0"; if (ClassId > 0) { sql += "," + ClassId; } else { sql += " ,0"; } if (SectionId > 0) { sql += "," + SectionId; } else { sql += " ,0"; } if (StudentId > 0) { sql += "," + StudentId; } else { sql += " ,0"; } sql += ",0"; } else { sql += " ,null,0,0,0,0"; } } else { sql += " ,null,0,0,0,0"; } using (var db = DbHelper.GetDBConnection()) { var lst = db.Query <SummarySalesVM>(sql).ToList(); db.Close(); return(lst); } }