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();
}
}