Example #1
0
        public DataSetInvoice GetInvoiceDailySalesBusinessName(string query, string businessName, DateTime today)
        {
            DataSetInvoice invoice2;
            SqlCommand     command = new SqlCommand(query)
            {
                CommandType = CommandType.StoredProcedure
            };

            using (SqlConnection connection = new SqlConnection(this.connString))
            {
                using (SqlDataAdapter adapter = new SqlDataAdapter())
                {
                    command.Connection    = connection;
                    adapter.SelectCommand = command;
                    command.Parameters.AddWithValue("@businessName", businessName);
                    command.Parameters.AddWithValue("@today", today);
                    using (DataSetInvoice invoice = new DataSetInvoice())
                    {
                        adapter.Fill(invoice, "tbl_sales_details");
                        invoice2 = invoice;
                    }
                }
            }
            return(invoice2);
        }
 protected void btnGetReportsByTaxRatesBetweenDates_Click(object sender, EventArgs e)
 {
     this.ReportViewerTaxRateWise.ProcessingMode         = ProcessingMode.Local;
     this.ReportViewerTaxRateWise.LocalReport.ReportPath = base.Server.MapPath("~/Reports/rpt_GetAllTaxesTaxRateWise.rdlc");
     try
     {
         DataSetInvoice invoice = BusinessReport.GetInvoiceDatesAllByTaxRate("usp_GetAllTaxesGroupByTaxRates", DateTime.Parse(this.txtFromDate.Text.ToString()), DateTime.Parse(this.txtToDate.Text.ToString()));
         if (invoice.Tables[1].Rows.Count > 0)
         {
             ReportDataSource item = new ReportDataSource("DataSetInvoice", invoice.Tables[1]);
             this.ReportViewerTaxRateWise.LocalReport.DataSources.Clear();
             this.ReportViewerTaxRateWise.LocalReport.DataSources.Add(item);
         }
         else
         {
             ReportDataSource item = new ReportDataSource("DataSetInvoice", invoice.Tables[1]);
             this.ReportViewerTaxRateWise.LocalReport.DataSources.Clear();
             this.ReportViewerTaxRateWise.LocalReport.DataSources.Add(item);
             this.alertDanger.Visible = true;
             this.lblDanger.Text      = "No Report Content!";
         }
     }
     catch (Exception exception)
     {
         this.lblDanger.Text = exception.Message;
     }
 }
Example #3
0
        public static DataSetInvoice GetInvoiceDatesAllByTaxRate(string query, DateTime fromDate, DateTime toDate)
        {
            DataSetInvoice invoice2;
            SqlCommand     command = new SqlCommand(query)
            {
                CommandType = CommandType.StoredProcedure
            };

            using (SqlConnection connection = new SqlConnection(connStaticString))
            {
                using (SqlDataAdapter adapter = new SqlDataAdapter())
                {
                    command.Connection    = connection;
                    adapter.SelectCommand = command;
                    command.Parameters.AddWithValue("@fromDate", DateTime.Parse(fromDate.ToString("yyyy-MM-dd")));
                    command.Parameters.AddWithValue("@toDate", DateTime.Parse(toDate.ToString("yyyy-MM-dd")));
                    using (DataSetInvoice invoice = new DataSetInvoice())
                    {
                        adapter.Fill(invoice, "tbl_GetAllTaxesTaxRateWise");
                        invoice2 = invoice;
                    }
                }
            }
            return(invoice2);
        }
Example #4
0
        private DataSetInvoice GetInvoiceByDatesBusinessName(string query, string businessName, DateTime fromDate, DateTime toDate)
        {
            DataSetInvoice invoice2;
            SqlCommand     command = new SqlCommand(query)
            {
                CommandType = CommandType.StoredProcedure
            };

            using (SqlConnection connection = new SqlConnection(this.connString))
            {
                using (SqlDataAdapter adapter = new SqlDataAdapter())
                {
                    command.Connection    = connection;
                    adapter.SelectCommand = command;
                    command.Parameters.AddWithValue("@businessName", businessName);
                    command.Parameters.AddWithValue("@fromDate", DateTime.Parse(fromDate.ToString("yyyy-MM-dd")));
                    command.Parameters.AddWithValue("@toDate", DateTime.Parse(toDate.ToString("yyyy-MM-dd")));
                    using (DataSetInvoice invoice = new DataSetInvoice())
                    {
                        adapter.Fill(invoice, "tbl_GetAllTaxesWithTaxRatesofaBusiness");
                        invoice2 = invoice;
                    }
                }
            }
            return(invoice2);
        }
Example #5
0
        public static DataSetInvoice GetInvoiceDatesAllBusinesses(string query)
        {
            DataSetInvoice invoice2;
            SqlCommand     command = new SqlCommand(query)
            {
                CommandType = CommandType.StoredProcedure
            };

            using (SqlConnection connection = new SqlConnection(connStaticString))
            {
                using (SqlDataAdapter adapter = new SqlDataAdapter())
                {
                    command.Connection    = connection;
                    adapter.SelectCommand = command;
                    using (DataSetInvoice invoice = new DataSetInvoice())
                    {
                        adapter.Fill(invoice, "tbl_GetAllTaxesWithTaxRatesofaBusiness");
                        invoice2 = invoice;
                    }
                }
            }
            return(invoice2);
        }
Example #6
0
        private DataSetInvoice GetInvoiceByBusiness(string query, string businessName)
        {
            DataSetInvoice invoice2;
            SqlCommand     command = new SqlCommand(query)
            {
                CommandType = CommandType.StoredProcedure
            };

            using (SqlConnection connection = new SqlConnection(this.connString))
            {
                using (SqlDataAdapter adapter = new SqlDataAdapter())
                {
                    command.Connection    = connection;
                    adapter.SelectCommand = command;
                    command.Parameters.AddWithValue("@businessName", businessName);
                    using (DataSetInvoice invoice = new DataSetInvoice())
                    {
                        adapter.Fill(invoice, "tbl_invoice_by_business_code");
                        invoice2 = invoice;
                    }
                }
            }
            return(invoice2);
        }
Example #7
0
        protected void btnBusinessName_Click(object sender, EventArgs e)
        {
            Thread thread1 = new Thread(() =>
            {
                if (this.chkBusinessName.Checked && !this.chkDates.Checked)
                {
                    this.chkBusinessName.Checked                    = false;
                    this.ReportViewerInvoice.ProcessingMode         = ProcessingMode.Local;
                    this.ReportViewerInvoice.LocalReport.ReportPath = base.Server.MapPath("~/Reports/rpt_GetAllTaxesWithTaxRatesofaBusiness.rdlc");
                    DataSetInvoice invoiceByBusinessName            = this.GetInvoiceByBusinessName("usp_GetAllTaxesWithTaxRatesofaBusinessByName", this.txtBusinessName.Text.ToString());
                    if (invoiceByBusinessName.Tables[0].Rows.Count > 0)
                    {
                        ReportDataSource item = new ReportDataSource("DataSetInvoice", invoiceByBusinessName.Tables[0]);
                        this.ReportViewerInvoice.LocalReport.DataSources.Clear();
                        this.ReportViewerInvoice.LocalReport.DataSources.Add(item);
                    }
                    else
                    {
                        this.alertDanger.Visible = true;
                        this.lblDanger.Text      = "No Report Content!";
                        ReportDataSource item    = new ReportDataSource("DataSetInvoice", invoiceByBusinessName.Tables[0]);
                        this.ReportViewerInvoice.LocalReport.DataSources.Clear();
                        this.ReportViewerInvoice.LocalReport.DataSources.Add(item);
                    }
                }
                else if (this.chkBusinessCode.Checked)
                {
                    this.chkBusinessCode.Checked                    = false;
                    this.ReportViewerInvoice.ProcessingMode         = ProcessingMode.Local;
                    this.ReportViewerInvoice.LocalReport.ReportPath = base.Server.MapPath("~/Reports/rpt_GetAllTaxesWithTaxRatesofaBusiness.rdlc");
                    DataSetInvoice invoiceByBusinessCode            = this.GetInvoiceByBusinessCode("usp_GetAllTaxesWithTaxRatesofaBusiness", this.txtBusinessCode.Text.ToString());
                    if (invoiceByBusinessCode.Tables[0].Rows.Count > 0)
                    {
                        ReportDataSource item = new ReportDataSource("DataSetInvoice", invoiceByBusinessCode.Tables[0]);
                        this.ReportViewerInvoice.LocalReport.DataSources.Clear();
                        this.ReportViewerInvoice.LocalReport.DataSources.Add(item);
                    }
                    else
                    {
                        this.alertDanger.Visible = true;
                        this.lblDanger.Text      = "No Report Content!";
                        ReportDataSource item    = new ReportDataSource("DataSetInvoice", invoiceByBusinessCode.Tables[0]);
                        this.ReportViewerInvoice.LocalReport.DataSources.Clear();
                        this.ReportViewerInvoice.LocalReport.DataSources.Add(item);
                    }
                }
                else if (this.chkDates.Checked && this.chkBusinessName.Checked)
                {
                    this.chkDates.Checked                           = false;
                    this.chkBusinessName.Checked                    = false;
                    this.ReportViewerInvoice.ProcessingMode         = ProcessingMode.Local;
                    this.ReportViewerInvoice.LocalReport.ReportPath = base.Server.MapPath("~/Reports/rpt_GetAllTaxesWithTaxRatesofaBusiness.rdlc");
                    DataSetInvoice invoice3                         = this.GetInvoiceByDatesBusinessName("usp_GetAllTaxesWithTaxRatesofaBusinessByDate", this.txtBusinessName.Text.ToString(), DateTime.Parse(this.txtFromDate.Text.ToString()), DateTime.Parse(this.txtToDate.Text.ToString()));
                    if (invoice3.Tables[0].Rows.Count > 0)
                    {
                        ReportDataSource item = new ReportDataSource("DataSetInvoice", invoice3.Tables[0]);
                        this.ReportViewerInvoice.LocalReport.DataSources.Clear();
                        this.ReportViewerInvoice.LocalReport.DataSources.Add(item);
                    }
                    else
                    {
                        this.alertDanger.Visible = true;
                        this.lblDanger.Text      = "No Report Content!";
                        ReportDataSource item    = new ReportDataSource("DataSetInvoice", invoice3.Tables[0]);
                        this.ReportViewerInvoice.LocalReport.DataSources.Clear();
                        this.ReportViewerInvoice.LocalReport.DataSources.Add(item);
                    }
                }
            });

            thread1.Start();
            thread1.Join();
        }