public void ReportView() { try { if (Session["DsDatos"] != null) { var dsDiseño = new dsCustomer(); var dsEjecucion = (DataSet)Session["DsDatos"]; for (var i = 0; i < dsEjecucion.Tables[0].Rows.Count; i++) { var row = dsDiseño.SWIFT_CUSTOMERS.NewRow(); row[0] = dsEjecucion.Tables[0].Rows[i]["CODE_CUSTOMER"]; row[1] = dsEjecucion.Tables[0].Rows[i]["NAME_CUSTOMER"]; row[2] = dsEjecucion.Tables[0].Rows[i]["NAME_CLASSIFICATION"]; row[3] = dsEjecucion.Tables[0].Rows[i]["CONTACT_CUSTOMER"]; row[4] = dsEjecucion.Tables[0].Rows[i]["NAME_ROUTE"]; dsDiseño.SWIFT_CUSTOMERS.Rows.Add(row); } Session["DsDatos"] = dsDiseño; var reporte = new Report.ReportCustomer { DataSource = dsDiseño }; Session["DSDISEÑO"] = dsDiseño; ASPxDocumentViewer1.Report = reporte; ASPxDocumentViewer1.DataBind(); } } catch (Exception ex) { ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('Error: " + ex.Message + "');", true); } }
public void populateDropDownList(string sValue) { try { dsCustomer dsPopulate = new dsCustomer(); string tempPath = Server.MapPath("~/HTVDatabase1.mdb"); clsDataLayer dataLayerObj = new HTV.clsDataLayer(tempPath); dsPopulate = dataLayerObj.dsCustomerDropDown(); //these codes bind the data from the dataset to the drop down menu //the TextField shows the Text in the dropdownlist //the ValueField holds the values ddlCustomerID.DataSource = dsPopulate; ddlCustomerID.DataTextField = "Customer"; ddlCustomerID.DataValueField = "CustomerID"; ddlCustomerID.DataBind(); //ddlCustomerID.Items.FindByValue(storeFieldtemp).Selected = true; ddlCustomerID.SelectedValue = sValue; //ddlCustomerID.Items.Insert(0, new ListItem("<Select CustomerID", "0")); } catch (Exception error) { Warnings.Text = "Critical Error: " + error; } }
public override global::System.Data.DataSet Clone() { dsCustomer cln = ((dsCustomer)(base.Clone())); cln.InitVars(); cln.SchemaSerializationMode = this.SchemaSerializationMode; return(cln); }
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs) { dsCustomer ds = new dsCustomer(); 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); }
//populates a dataset with information from the Customer Table public dsCustomer findCustomer(int customerID) { //create an SQL query that returns customers with a specific customerID string sqlStmt = "select * from Customer where customerID like '" + customerID + "'"; OleDbDataAdapter sqlDataAdapter = new OleDbDataAdapter(sqlStmt, dbConnection); dsCustomer tempDataSet = new dsCustomer(); sqlDataAdapter.Fill(tempDataSet.Customer); //returns the resulting data set -- should be only up to 1 line return(tempDataSet); }
//the data layer side that searches for duplicate Social Security Numbers public dsCustomer dsCheckForDuplicateSocials(string tSSN, string tCID) { //This SQL builds a data set with all similar SSN to the current customer selected //However, the data set will exclude the current customer. Any SSN that appears on this list IS a duplicate string sqlStmt = "Select * FROM Customer WHERE socialSecurity like '" + tSSN + "' AND NOT customerID like '" + tCID + "'"; OleDbDataAdapter sqlDataAdapter = new OleDbDataAdapter(sqlStmt, dbConnection); dsCustomer tempDataSet = new dsCustomer(); sqlDataAdapter.Fill(tempDataSet.Customer); //if this returns any rows, that means another customer already uses that Social Security Number return(tempDataSet); }
//this method connects the business layer to the data layer to verify that no Social Security Numbers will be duplicated. public Boolean isDuplicateSocial(string tSSN, string tCID) { //this will fill a dataset with customer information dsCustomer tempDataSet = myDataLayer.dsCheckForDuplicateSocials(tSSN, tCID); //if the SSN is already in use, the tempDataSet will have entries, otherwise, this method will return false. if (tempDataSet.Customer.Rows.Count > 0) { return(true); } else { return(false); } }
//populates a dropDownMenu with all Customers from the Customer Table public dsCustomer dsCustomerDropDown() { //this SQL query creates a table called Customer with 2 columns. //Column 1: contains the customer's ID //Column 2: contains the customer Social Security Number: LastName, First Name string sqlStmt = "Select CustomerID, SocialSecurity & ': ' & lastName & ', ' & FirstName AS Customer FROM Customer"; OleDbDataAdapter sqlDataAdapter = new OleDbDataAdapter(sqlStmt, dbConnection); dsCustomer tempDataSet = new dsCustomer(); sqlDataAdapter.Fill(tempDataSet.Customer); //returns the resulting data set -- this list should be expected to have many rows return(tempDataSet); }
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(); dsCustomer ds = new dsCustomer(); 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 = "SWIFT_CUSTOMERSDataTable"; 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); }