public static System.Xml.Schema.XmlSchemaComplexType GetTypedTableSchema(System.Xml.Schema.XmlSchemaSet xs)
{
System.Xml.Schema.XmlSchemaComplexType type = new System.Xml.Schema.XmlSchemaComplexType();
System.Xml.Schema.XmlSchemaSequence sequence = new System.Xml.Schema.XmlSchemaSequence();
dsComplaint ds = new dsComplaint();
xs.Add(ds.GetSchemaSerializable());
System.Xml.Schema.XmlSchemaAny any1 = new System.Xml.Schema.XmlSchemaAny();
any1.Namespace = "http://www.w3.org/2001/XMLSchema";
any1.MinOccurs = new decimal(0);
any1.MaxOccurs = decimal.MaxValue;
any1.ProcessContents = System.Xml.Schema.XmlSchemaContentProcessing.Lax;
sequence.Items.Add(any1);
System.Xml.Schema.XmlSchemaAny any2 = new System.Xml.Schema.XmlSchemaAny();
any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1";
any2.MinOccurs = new decimal(1);
any2.ProcessContents = System.Xml.Schema.XmlSchemaContentProcessing.Lax;
sequence.Items.Add(any2);
System.Xml.Schema.XmlSchemaAttribute attribute1 = new System.Xml.Schema.XmlSchemaAttribute();
attribute1.Name = "namespace";
attribute1.FixedValue = ds.Namespace;
type.Attributes.Add(attribute1);
System.Xml.Schema.XmlSchemaAttribute attribute2 = new System.Xml.Schema.XmlSchemaAttribute();
attribute2.Name = "tableTypeName";
attribute2.FixedValue = "dtComplaintListDataTable";
type.Attributes.Add(attribute2);
type.Particle = sequence;
return(type);
}
public override System.Data.DataSet Clone()
{
dsComplaint cln = ((dsComplaint)(base.Clone()));
cln.InitVars();
cln.SchemaSerializationMode = this.SchemaSerializationMode;
return(cln);
}
public static System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(System.Xml.Schema.XmlSchemaSet xs)
{
dsComplaint ds = new dsComplaint();
System.Xml.Schema.XmlSchemaComplexType type = new System.Xml.Schema.XmlSchemaComplexType();
System.Xml.Schema.XmlSchemaSequence sequence = new System.Xml.Schema.XmlSchemaSequence();
xs.Add(ds.GetSchemaSerializable());
System.Xml.Schema.XmlSchemaAny any = new System.Xml.Schema.XmlSchemaAny();
any.Namespace = ds.Namespace;
sequence.Items.Add(any);
type.Particle = sequence;
return(type);
}
public void generateReport()
{
LocalReport rpvComplaint = new LocalReport();
//declare connection string
string cnString = "Data Source=(local);Initial Catalog=RealWorld;Integrated Security=SSPI;";
//declare Connection, command and other related objects
SqlConnection conReport = new SqlConnection(cnString);
SqlCommand cmdReport = new SqlCommand();
SqlDataReader drReport;
DataSet dsReport = new dsComplaint();
try
{
//open connection
conReport.Open();
//prepare connection object to get the data through reader and populate into dataset
cmdReport.CommandType = CommandType.Text;
cmdReport.Connection = conReport;
cmdReport.CommandText = "Select * FROM Complaint ORDER BY ComplaintLevel, ComplaintSource, ComplaintID";
//read data from command object
drReport = cmdReport.ExecuteReader();
//load data directly from reader to dataset
dsReport.Tables[0].Load(drReport);
//close reader and connection
drReport.Close();
conReport.Close();
//provide local report information to viewer
rpvComplaint.ReportEmbeddedResource = "Complaint.rptComplaint.rdlc";
//prepare report data source
ReportDataSource rds = new ReportDataSource();
rds.Name = "dsComplaint_dtComplaintList";
rds.Value = dsReport.Tables[0];
rpvComplaint.DataSources.Add(rds);
Warning[] warnings;
string[] streamids;
string mimeType;
string encoding;
string filenameExtension;
byte[] bytes = rpvComplaint.Render(
"PDF", null, out mimeType, out encoding, out filenameExtension,
out streamids, out warnings);
using (FileStream fs = new FileStream(@"c:\output.pdf", FileMode.Create))
{
fs.Write(bytes, 0, bytes.Length);
}
//send newly create pdf file as email attachment
//SendMail("SMTPserver", "Complaint", SettingsComplaint.Default.EmailTo, "Service Stoped!", "Contact IT support", "output.pdf");
}
catch (Exception ex)
{
string strInitialError = "Initial Error Message: " + ex.Message;
string FinalErrorMessage = string.Empty;
Exception innerError = ex.InnerException;
while (!((innerError == null)))
{
FinalErrorMessage += innerError.Message;
innerError = innerError.InnerException;
}
//write the error message to text file
using (StreamWriter sw = new StreamWriter(@"c:\ServiceError.txt"))
{
sw.WriteLine(strInitialError);
sw.WriteLine("-------------------");
sw.WriteLine(FinalErrorMessage);
}
}
finally
{
//check if connection is still open then attempt to close it
if (conReport.State == ConnectionState.Open)
{
conReport.Close();
}
}
}