public override global::System.Data.DataSet Clone() { DSTTokenSummryUserWise cln = ((DSTTokenSummryUserWise)(base.Clone())); cln.InitVars(); cln.SchemaSerializationMode = this.SchemaSerializationMode; return(cln); }
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs) { DSTTokenSummryUserWise ds = new DSTTokenSummryUserWise(); 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); }
//public DSTTokenSummryUserWise GetTokenSummaryUserWise(DateTime fromDate, DateTime toDate) public DSTTokenSummryUserWise GetTokenSummaryUserWise(DateTime fromDate, DateTime toDate, Boolean isTime) { DSTTokenSummryUserWise ds = new DSTTokenSummryUserWise(); try { string select; if (isTime == true) { select = "select (Select u.UName from unames u where u.UNo=TokenBy) as UserName , COUNT(ID) as TotalTokens,SUM(TokenAmount) as TotalAmount from PatientRegistration where TokenDate>='" + fromDate.ToString("MM/dd/yyyy HH:mm") + "' and TokenDate<='" + toDate.ToString("MM/dd/yyyy HH:mm") + "' GROUP by tokenby"; } else { select = "select (Select u.UName from unames u where u.UNo=TokenBy) as UserName , COUNT(ID) as TotalTokens,SUM(TokenAmount) as TotalAmount from PatientRegistration where Convert(date, TokenDate) >='" + fromDate.ToString("MM/dd/yyyy") + "' and Convert(date, TokenDate) <='" + toDate.ToString("MM/dd/yyyy") + "' GROUP by tokenby"; } DataTable dt = new DataTable(); con = new OleDbConnection(); readconfile = new ReadConfigFile(); con.ConnectionString = readconfile.ConfigString(ConfigFiles.ProjectConfigFile); con.Open(); if (con.State == ConnectionState.Open) { da = new OleDbDataAdapter(select, con); da.Fill(ds, ds.Tables[0].TableName); } return(ds); // return labTests; } catch (Exception ex) { throw ex; } finally { con.Close(); } }
private void PrintPreview(bool preview) { DSTTokenSummryUserWise printds = new DSTTokenSummryUserWise(); // DsTokenSummary.PatientRegistrationDataTable resultTalbe = new DsTokenSummary.PatientRegistrationDataTable(); DSTTokenSummryUserWise.TokenSummeryUserWiseDataTable resultTalbe = new DSTTokenSummryUserWise.TokenSummeryUserWiseDataTable(); rptTokensUserWise crp = new rptTokensUserWise(); string BranchName = ConfigurationManager.AppSettings["Name"].ToString(); string BranchAddress = ConfigurationManager.AppSettings["Address"].ToString(); // string shifttime=""; ///////// --------------------------- Asif - 04-05-19 - Disable if & send time flag as parameter printds = new TokenSummaryBLL().GetTokenSummaryUserWise(dtpFrom.Value, dtpTo.Value, chkSelectTime.Checked); //if (chkSelectTime.Checked==true) //{ // printds = new TokenSummaryBLL().GetTokenSummaryUserWise(dtpFrom.Value, dtpTo.Value); //} //else //{ // printds = new TokenSummaryBLL().GetTokenSummaryUserWise(dtpFrom.Value.Date, dtpTo.Value.Date); //} ///////// --------------------------- Asif - 04-05-19 - Disable // printds = new TokenSummaryBLL().GetTokenSummaryUserWise(dtpFrom.Value, dtpTo.Value); //if (cbxShifts.SelectedIndex == 0 || cbxShifts.SelectedIndex == -1) // printds = new TokenSummaryBLL().GetTokenSummary(dtpFrom.Value.Date, dtpTo.Value.Date, rbAll.Checked, rbInjection.Checked, rbCheckup.Checked, rbLab.Checked, rbMedicine.Checked, cb50.Checked); //else //{ // Shift shift = (Shift)cbxShifts.SelectedItem; // shift = new BLL.ShiftsBLL().GetShiftStartEndTime(shift,this.dtpFrom.Value.Date); // shifttime = shift.ChangeDateTime.ToString("hh:mm:ss"); //} //string tokenType = ""; //string tokenRange = ""; //if (rbAll.Checked == true) // tokenType = "All tokens"; //else if (rbCheckup.Checked == true) // tokenType = "Checkup only"; //else if (rbInjection.Checked == true) // tokenType = "Injection only"; //else if (rbLab.Checked == true) // tokenType = "Lab test only"; //else if (rbMedicine.Checked == true) // tokenType = "Medicines"; //tokenType += " - " + cbxShifts.Text+shifttime; //if (rbRange.Checked == true) //{ // try // { // int to = 0, from = 0; // bool r; // if (txtToToken.Text.Trim() != string.Empty) // r = int.TryParse(txtToToken.Text.Trim(), out to); // if (txtFromToken.Text.Trim() != string.Empty) // r = int.TryParse(txtFromToken.Text.Trim(), out from); // if (to == 0) // { // MessageBox.Show("Please Enter the Valid Token Number"); // this.txtToToken.Focus(); // return; // } // if (from == 0) // { // MessageBox.Show("Please Enter the Valid Token Number"); // this.txtFromToken.Focus(); // return; // } // string filterExpression = "TokenNumber >= " + from.ToString() + " and TokenNumber <= " + to.ToString(); // DataRow[] TokenRows = ((DataTable)printds.PatientRegistration).Select(filterExpression); // foreach (DataRow row in TokenRows) // { // resultTalbe.ImportRow(row); // } // tokenRange = from.ToString() + " to " + to.ToString(); // } // catch (Exception ex) // { // MessageBox.Show(ex.Message, "Token Range Invalid"); // return; // } //} //else //{ // resultTalbe = printds.PatientRegistration; // tokenRange = "All Tokens"; //} resultTalbe = printds.TokenSummeryUserWise; crp.SetDataSource((DataTable)resultTalbe); // crp.SetParameterValue("TokenType", tokenType); if (chkSelectTime.Checked == true) { crp.SetParameterValue("fromDate", dtpFrom.Value.ToString("dd/MM/yyyy HH:mm")); crp.SetParameterValue("toDate", dtpTo.Value.ToString("dd/MM/yyyy HH:mm")); } else { crp.SetParameterValue("fromDate", dtpFrom.Value.ToString("dd/MM/yyyy")); crp.SetParameterValue("toDate", dtpTo.Value.ToString("dd/MM/yyyy")); } //crp.SetParameterValue("TokenRange", tokenRange); crp.SetParameterValue("BranchName", BranchName); crp.SetParameterValue("BranchAddress", BranchAddress); FrmReportViewer frmViewer = new FrmReportViewer(); frmViewer.crystalReportViewer1.ReportSource = crp; if (preview) { frmViewer.ShowDialog(); } else { frmViewer.crystalReportViewer1.RefreshReport(); frmViewer.crystalReportViewer1.PrintReport(); } }
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(); DSTTokenSummryUserWise ds = new DSTTokenSummryUserWise(); 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 = "TokenSummeryUserWiseDataTable"; 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); }