public override global::System.Data.DataSet Clone() { DSRefrenceCollection cln = ((DSRefrenceCollection)(base.Clone())); cln.InitVars(); cln.SchemaSerializationMode = this.SchemaSerializationMode; return(cln); }
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs) { DSRefrenceCollection ds = new DSRefrenceCollection(); 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); }
private void PrintPreview(bool Privew) { string fromdate = ""; string todate = ""; if (rbselectDonors.Checked == true) { d.DonorName = cbxReference.Text.Trim(); fromdate = dtpFromDate.Value.Date.ToString(); todate = dtpToDate.Value.Date.ToString(); } else if (rbselectMembers.Checked == true) { m.MemberName = cbxReference.Text.Trim(); fromdate = dtpFromDate.Value.Date.ToString(); todate = dtpToDate.Value.Date.ToString(); } ds = new DonorBLL().GetRefrenceCollection(rbselectDonors.Checked, rbselectMembers.Checked, d, m, fromdate, todate); crp.SetDataSource(ds); crp.SetParameterValue("RefrenceBy", cbxReference.Text); crp.SetParameterValue("FromDate", dtpFromDate.Value.Date); crp.SetParameterValue("ToDate", dtpToDate.Value.Date); string BranchName = ConfigurationManager.AppSettings["Name"].ToString(); string BranchAddress = ConfigurationManager.AppSettings["Address"].ToString(); crp.SetParameterValue("Name", BranchName); crp.SetParameterValue("Address", BranchAddress); FrmReportViewer frmViewer = new FrmReportViewer(); frmViewer.crystalReportViewer1.ReportSource = crp; if (Privew) { frmViewer.ShowDialog(); } else { frmViewer.crystalReportViewer1.RefreshReport(); frmViewer.crystalReportViewer1.PrintReport(); } }
private void PrintPreview(bool Privew) { string fromdate = ""; string todate = ""; if (rbselectDonors.Checked == true) { d.DonorName = cbxReference.Text.Trim(); //fromdate = dtpfromDate.Value.Date.ToString(); //todate = dtpTodate.Value.Date.ToString(); } else if (rbselectMembers.Checked == true) { m.MemberName = cbxReference.Text.Trim(); //fromdate = dtpfromDate.Value.Date.ToString(); //todate = dtpTodate.Value.Date.ToString(); } ds = new DonorBLL().GetRefrenceCollection(rbselectDonors.Checked, rbselectMembers.Checked, d, m, fromdate, todate); crp.SetDataSource(ds); FrmReportViewer frmViewer = new FrmReportViewer(); frmViewer.crystalReportViewer1.ReportSource = crp; if (Privew) { frmViewer.ShowDialog(); } else { frmViewer.crystalReportViewer1.RefreshReport(); frmViewer.crystalReportViewer1.PrintReport(); } }
public DSRefrenceCollection GetRefrenceCollection(bool rbDonor, bool rbMember, Donor d, Membership m, string fromdate, string todate) { DSRefrenceCollection ds = new DSRefrenceCollection(); try { //string MyQry = "SELECT MemberCollection.MemberName as MemberName, MemberCollection.CollectionFee as CollectionFee from MemberCollection"+ // " left join MembershipData on MemberCollection.MemberName=MembershipData.Refrence where MemberCollection.MemberName='"+m.MemberName+"'"+ // " UNION ALL"+ // " SELECT DonorCollection.DonorName as MemberName, DonorCollection.CollectionFee as CollectionFee from DonorCollection"+ // " left join Donor on DonorCollection.DonorName=Donor.Refrence where DonorCollection.DonorName='"+d.DonorName+"'"; string MyDonorQry = " Select mc.MemberName,mc.CollectionFee from MemberCollection mc where mc.MemberName='" + d.DonorName + "'" + " or mc.MemberName in(select MembershipData.MemberName from MembershipData where" + " MembershipData.Refrence='" + d.DonorName + "')" + //and CollectionDate>=#"+fromdate+"# and CollectionDate<=#"+todate +"#" + " union all" + " select dc.DonorName,dc.CollectionFee from DonorCollectionCollection dc where dc.DonorName ='" + d.DonorName + "'" + " or dc.DonorName in(select Donor.Donorname from Donor where " + " Donor.Refrence='" + d.DonorName + "') "; //and CollectionDate>=#"+fromdate+"# and CollectionDate<=#"+todate +"#"; String MemberQry = " Select mc.MemberName,mc.CollectionFee from MemberCollection mc where mc.MemberName='" + m.MemberName + "'" + " or mc.MemberName in(select MembershipData.MemberName from MembershipData where" + " MembershipData.Refrence='" + m.MemberName + "')" + // and CollectionDate>=#" + fromdate + "# and CollectionDate<=#" + todate + "#" + " union all" + " select dc.DonorName,dc.CollectionFee from DonorCollection dc where dc.DonorName ='" + m.MemberName + "'" + " or dc.DonorName in(select Donor.Donorname from Donor where " + " Donor.Refrence='" + m.MemberName + "')"; // and CollectionDate>=#"+fromdate+"# and CollectionDate<=#"+todate +"#"; con = new OleDbConnection(); this.readconfile = new ReadConfigFile(); con.ConnectionString = this.readconfile.ConfigString(ConfigFiles.ProjectConfigFile); con.Open(); if (con.State == ConnectionState.Open) { string select = ""; if (rbDonor == true) { select = MyDonorQry; } else { select = MemberQry; } da = new OleDbDataAdapter(select, con); da.Fill(ds, ds.Tables[0].TableName); } return(ds); } catch (Exception ex) { throw ex; } finally { con.Close(); } }
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(); DSRefrenceCollection ds = new DSRefrenceCollection(); 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 = "DSRefrenceCollectionDataTable"; 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); }
public DSRefrenceCollection GetRefrenceCollection(bool rbDonor, bool rbMember, Donor d, Membership m, string fromdate, string todate) { DSRefrenceCollection ds = new DSRefrenceCollection(); try { string MyDonorQry = " Select mc.MemberName,'' as DonorName,mc.CollectionFee from MemberCollection mc where mc.MemberName='" + d.DonorName + "'" + " or mc.MemberName in(select MembershipData.MemberName from MembershipData where" + " MembershipData.Refrence='" + d.DonorName + "'" + " and CollectionDate>=#" + fromdate + "# and CollectionDate<=#" + todate + "#)" + " union all" + " select '' as MemberName,dc.DonorName as DonorName,dc.CollectionFee from DonorCollection dc where dc.DonorName ='" + d.DonorName + "'" + " or dc.DonorName in(select Donor.Donorname from Donor where" + " Donor.Refrence='" + d.DonorName + "' and CollectionDate>=#" + fromdate + "# and CollectionDate<=#" + todate + "#)" + " union all" + " Select dc.DonorName as MemberName,'' as DonorName,dc.CollectionFee from DonorCollection dc where" + " dc.DonorName in(select MembershipData.MemberName from MembershipData where " + " MembershipData.Refrence='" + d.DonorName + "' and CollectionDate>=#" + fromdate + "# and CollectionDate<=#" + todate + "#)"; String MemberQry = " Select mc.MemberName,'' as DonorName,mc.CollectionFee from MemberCollection mc where mc.MemberName='" +m.MemberName+ "'" + " or mc.MemberName in(select MembershipData.MemberName from MembershipData where" + " MembershipData.Refrence='" + m.MemberName+ "'" + " and CollectionDate>=#" + fromdate + "# and CollectionDate<=#" + todate + "#)" + " union all" + " select '' as MemberName,dc.DonorName as DonorName,dc.CollectionFee from DonorCollection dc where dc.DonorName ='" + d.DonorName + "'" + " or dc.DonorName in(select Donor.Donorname from Donor where" + " Donor.Refrence='" +m.MemberName + "' and CollectionDate>=#" + fromdate + "# and CollectionDate<=#" + todate + "#)" + " union all" + " Select dc.DonorName as MemberName,'' as DonorName,dc.CollectionFee from DonorCollection dc where" + " dc.DonorName in(select MembershipData.MemberName from MembershipData where " + " MembershipData.Refrence='" + m.MemberName + "' and CollectionDate>=#" + fromdate + "# and CollectionDate<=#" + todate + "#)"; con = new OleDbConnection(); this.readconfile = new ReadConfigFile(); con.ConnectionString = this.readconfile.ConfigString(ConfigFiles.ProjectConfigFile); con.Open(); if (con.State == ConnectionState.Open) { string select = ""; if (rbDonor == true) select = MyDonorQry; else select = MemberQry; da = new OleDbDataAdapter(select, con); da.Fill(ds, ds.Tables[0].TableName); } return ds; } catch (Exception ex) { throw ex; } finally { con.Close(); } }