//protected void lnkGenerateReport_OnClick(object sender, EventArgs e) //{ // //get the values from the dropdownlist // fromMonth = DateTime.ParseExact(ddlFromMonth.SelectedValue.ToString(), "MMMM", CultureInfo.CurrentCulture).Month.ToString(); // fromYear = ddlFromYear.SelectedValue.ToString(); // toMonth = DateTime.ParseExact(ddlToMonth.SelectedValue.ToString(), "MMMM", CultureInfo.CurrentCulture).Month.ToString(); // toYear = ddlToYear.SelectedValue.ToString(); // GenerateReport(fromMonth, fromYear, toMonth, toYear); //} private void GenerateReport(string fromMonth, string fromYear, string toMonth, string toYear) { ReportDocument rptDocument = new ReportDocument(); dsSales dsales = new dsSales(); DataTable dt = SalesReportManager.GetSalesByDateRange(fromMonth, fromYear, toMonth, toYear); dt.TableName = "Sales Report"; dsales.Tables[0].Merge(dt); rptDocument.Load(Server.MapPath("../Reports/src/SalesWithDateRange.rpt")); //set dataset to the report viewer rptDocument.SetDataSource(dsales); rptSalesByDateRange.ReportSource = rptDocument; //display the date range selected by the user In the Report Heading // the 'to' notation stands for Text Object //get from month and year string fromParameters = ddlFromMonth.SelectedValue.ToString() + " " + ddlFromYear.SelectedValue.ToString(); //get to month and year string toParameters = ddlToMonth.SelectedValue.ToString() + " " + ddlToYear.SelectedValue.ToString(); TextObject toDateRangeValue = (TextObject)rptDocument.ReportDefinition.Sections["Section2"].ReportObjects["txtDateRangeValue"]; toDateRangeValue.Text = fromParameters + " to " + toParameters;; //ddlFromMonth.SelectedValue.ToString() + " " + ddlFromYear.SelectedValue.ToString(); //refresh the report rptSalesByDateRange.RefreshReport(); }
public override global::System.Data.DataSet Clone() { dsSales cln = ((dsSales)(base.Clone())); cln.InitVars(); cln.SchemaSerializationMode = this.SchemaSerializationMode; return(cln); }
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs) { dsSales ds = new dsSales(); global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType(); global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence(); global::System.Xml.Schema.XmlSchemaAny any = new global::System.Xml.Schema.XmlSchemaAny(); any.Namespace = ds.Namespace; sequence.Items.Add(any); type.Particle = sequence; global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable(); if (xs.Contains(dsSchema.TargetNamespace)) { global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream(); global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream(); try { global::System.Xml.Schema.XmlSchema schema = null; dsSchema.Write(s1); for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext();) { schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current)); s2.SetLength(0); schema.Write(s2); if ((s1.Length == s2.Length)) { s1.Position = 0; s2.Position = 0; for (; ((s1.Position != s1.Length) && (s1.ReadByte() == s2.ReadByte()));) { ; } if ((s1.Position == s1.Length)) { return(type); } } } } finally { if ((s1 != null)) { s1.Close(); } if ((s2 != null)) { s2.Close(); } } } xs.Add(dsSchema); return(type); }
static SalesNew() { dsSales = new dsSales(); customerModifyTableAdapter customerModifyTableAdapter = new customerModifyTableAdapter(); equipmentModifyTableAdapter equipmentModifyTableAdapter = new equipmentModifyTableAdapter(); try { customerModifyTableAdapter.Fill(dsSales.customerModify); equipmentModifyTableAdapter.Fill(dsSales.equipmentModify); } catch (Exception) { } }
static SalesSearch() { dsSales = new dsSales(); customerModifyTableAdapter customerModifyTableAdapter = new customerModifyTableAdapter(); equipmentModifyTableAdapter equipmentModifyTableAdapter = new equipmentModifyTableAdapter(); receiptModifyTableAdapter receiptModifyTableAdapter = new receiptModifyTableAdapter(); order_lineTableAdapter order_LineTableAdapter = new order_lineTableAdapter(); service_orderTableAdapter service_OrderTableAdapter = new service_orderTableAdapter(); try { customerModifyTableAdapter.Fill(dsSales.customerModify); equipmentModifyTableAdapter.Fill(dsSales.equipmentModify); receiptModifyTableAdapter.Fill(dsSales.receiptModify); order_LineTableAdapter.Fill(dsSales.order_line); service_OrderTableAdapter.Fill(dsSales.service_order); } catch (Exception) { } }
private void GenerateReport(string sortExpression, string sortDirection) { ReportDocument rptDocument = new ReportDocument(); dsSales dsales = new dsSales(); DataTable dt = ProductManager.GetLowStock(sortExpression, sortDirection); dt.TableName = "Low Stock Report"; dsales.Tables["LowStock"].Merge(dt); rptDocument.Load(Server.MapPath("../Reports/src/ProductsBelowReorderLevel.rpt")); //set dataset to the report viewer rptDocument.SetDataSource(dsales); rptProductsUnderStock.ReportSource = rptDocument; rptProductsUnderStock.RefreshReport(); }
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedTableSchema(global::System.Xml.Schema.XmlSchemaSet xs) { global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType(); global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence(); dsSales ds = new dsSales(); global::System.Xml.Schema.XmlSchemaAny any1 = new global::System.Xml.Schema.XmlSchemaAny(); any1.Namespace = "http://www.w3.org/2001/XMLSchema"; any1.MinOccurs = new decimal(0); any1.MaxOccurs = decimal.MaxValue; any1.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax; sequence.Items.Add(any1); global::System.Xml.Schema.XmlSchemaAny any2 = new global::System.Xml.Schema.XmlSchemaAny(); any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1"; any2.MinOccurs = new decimal(1); any2.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax; sequence.Items.Add(any2); global::System.Xml.Schema.XmlSchemaAttribute attribute1 = new global::System.Xml.Schema.XmlSchemaAttribute(); attribute1.Name = "namespace"; attribute1.FixedValue = ds.Namespace; type.Attributes.Add(attribute1); global::System.Xml.Schema.XmlSchemaAttribute attribute2 = new global::System.Xml.Schema.XmlSchemaAttribute(); attribute2.Name = "tableTypeName"; attribute2.FixedValue = "dtSalesDataTable"; type.Attributes.Add(attribute2); type.Particle = sequence; global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable(); if (xs.Contains(dsSchema.TargetNamespace)) { global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream(); global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream(); try { global::System.Xml.Schema.XmlSchema schema = null; dsSchema.Write(s1); for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext();) { schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current)); s2.SetLength(0); schema.Write(s2); if ((s1.Length == s2.Length)) { s1.Position = 0; s2.Position = 0; for (; ((s1.Position != s1.Length) && (s1.ReadByte() == s2.ReadByte()));) { ; } if ((s1.Position == s1.Length)) { return(type); } } } } finally { if ((s1 != null)) { s1.Close(); } if ((s2 != null)) { s2.Close(); } } } xs.Add(dsSchema); return(type); }