private void btnPreview_Click(object sender, EventArgs e) { try { string vWhere = string.Empty; Reports.RptReportViewer vForm = new Reports.RptReportViewer(); if (!string.IsNullOrEmpty(this.txtVendorID.Text)) { vWhere = " AND PartyID=" + this.txtVendorID.Text; } if (chkSupplier.Checked == true) { vWhere += " AND Isnull(IsSupplier)=1"; } if (chkCustomer.Checked == true) { vWhere += " AND Isnull(IsCustomer)=1"; } DataTable dt = objDAL.getPartiesList(vWhere); if (dt.Rows.Count == 0) { MessageBox.Show("No Data To Display", "No Data"); return; } vForm.ShowReport("PARTIES LIST", dt); vForm.ShowDialog(); } catch (Exception exc) { MessageBox.Show(exc.Message, "Error"); } }
public void ShowLedger(string vPartyID, string vRange, DateTime vFromDate, DateTime vToDate, DataTable dt, bool LetterHead = false) { try { DataTable dt1, dt2; string vPartyName = string.Empty; string vPartyAddress = string.Empty; objDAL.connectionstring = System.Configuration.ConfigurationManager.ConnectionStrings["MyString"].ConnectionString; dt1 = objDAL.getCompanyInfo(); dt2 = objDAL.getPartiesList(" AND Parties.PartyID=" + vPartyID); if (dt2.Rows.Count > 0) { vPartyName = dt2.Rows[0]["PartyName"].ToString(); vPartyAddress = dt2.Rows[0]["Address"].ToString(); vPartyAddress += "(" + dt2.Rows[0]["ContactNo"].ToString() + ")"; } else { dt2 = objDAL.getAccountsList(" AND AccountNo='" + vPartyID + "'"); vPartyName = dt2.Rows[0]["AccountTitle"].ToString(); vPartyAddress = dt2.Rows[0]["AccountType"].ToString(); } if (LetterHead) { CrpPartyLedgerLH Rpt = new CrpPartyLedgerLH(); Rpt.Database.Tables[0].SetDataSource(dt); Rpt.Database.Tables[1].SetDataSource(dt1); Rpt.SetParameterValue("PartyID", vPartyID); Rpt.SetParameterValue("PartyName", vPartyName); Rpt.SetParameterValue("PartyAddress", vPartyAddress); Rpt.SetParameterValue("DateRange", vRange); Rpt.SetParameterValue("FromDate", vFromDate); Rpt.SetParameterValue("ToDate", vToDate); this.CRViewer.ReportSource = Rpt; } else { CrpPartyLedger Rpt = new CrpPartyLedger(); Rpt.Database.Tables[0].SetDataSource(dt); Rpt.Database.Tables[1].SetDataSource(dt1); Rpt.SetParameterValue("PartyID", vPartyID); Rpt.SetParameterValue("PartyName", vPartyName); Rpt.SetParameterValue("PartyAddress", vPartyAddress); Rpt.SetParameterValue("DateRange", vRange); Rpt.SetParameterValue("FromDate", vFromDate); Rpt.SetParameterValue("ToDate", vToDate); this.CRViewer.ReportSource = Rpt; } } catch (Exception exc) { MessageBox.Show(exc.Message, "Error"); } }
private void FrmSplash_Load(object sender, EventArgs e) { try { //Cursor.Current = Cursors.WaitCursor; //// Start the BackgroundWorker. //backgroundWorker1.RunWorkerAsync(); objDAL.connectionstring = System.Configuration.ConfigurationManager.ConnectionStrings["MyString"].ConnectionString; Omni.MyGlobal omni = new Omni.MyGlobal(); omni.MyConString = objDAL.connectionstring; omni.Authentication(); string vWhere = " AND PartyID=0"; Reports.RptReportViewer cForm = new Reports.RptReportViewer(); DataTable dt = objDAL.getPartiesList(vWhere); //if (dt.Rows.Count == 0) //{ // MessageBox.Show("No Data To Display", "No Data"); // return; //} cForm.ShowReport("PARTIES LIST", dt); //if (File.Exists("Regd.txt")) //{ // //Get Mac Address // //string mac = ""; // //// Win32_CPU will work too // //var search = new ManagementObjectSearcher("SELECT * FROM Win32_baseboard"); // //var mobos = search.Get(); // //foreach (var m in mobos) // //{ // // mac += m["SerialNumber"]; // ProcessorID if you use Win32_CPU // //} // ////Get Reg Code // //StreamReader sr = new StreamReader("Regd.txt"); // //string vTemp = sr.ReadToEnd(); // //string vCode = Decrypt(vTemp); // //string vVersion = vCode.Substring(0, 3); // //vCode = vCode.Substring(3, vCode.Length - 7); // //if (mac != vCode) // //{ // // MessageBox.Show("Product Not Registered. Contact\r\n\n Panthersoft ([email protected]) For Assistance!", "Registration Failure", MessageBoxButtons.OK, MessageBoxIcon.Error); // // Close(); // //} // //else // //{ // // //Cursor.Current = Cursors.WaitCursor; // // // Start the BackgroundWorker. // // //backgroundWorker1.RunWorkerAsync(); // // timer1.Enabled = true; // //} // timer1.Enabled = true; //} //else //{ // MessageBox.Show("Registration File Not Found.", "Registration Missing", MessageBoxButtons.OK, MessageBoxIcon.Stop); // Close(); //} timer1.Enabled = true; } catch (Exception exc) { MessageBox.Show("Error:" + exc.Message); Close(); } }