public static int GetCustomerCount(DateTime d1, DateTime d2, bool isclose, bool useconstr = false, string newconstr = "p") { var ret = 0; var ta = new SalesAmountDetailsTableAdapter { Connection = { ConnectionString = useconstr ? newconstr : _constr } }; if (!isclose) ret = (int) (ta.GetInvoiceCount() ?? 0); else ret = (int) (ta.GetInvoiceCountByDate(d1, d2) ?? 0); return (int) ret; }
public static DsReports.SalesAmountDetailsDataTable GetDailySalesReport(DateTime d1, DateTime d2, bool bydate = false, bool useconstr = false, string newconstr = "p") { var ta = new SalesAmountDetailsTableAdapter { Connection = { ConnectionString = useconstr ? newconstr:_constr } }; var ds = new DsReports().SalesAmountDetails; if (!bydate) { ta.Fill(ds); } else { ta.FillByDate(ds, d1, d2); } return ds; }