private void btnVendor_Click(object sender, EventArgs e)
{
object rValue;
rValue = FrmGSearch.Show("Select PrID,Convert(varchar(12),PrDate,106) AS [PrDate],VendorName From Trans_PurchaseM Where IsActive=1", false, "All Purchase Items");
if (rValue == null)
{
return;
}
PrID = long.Parse(rValue.ToString());
DataTable dt = new DataTable();
Bp_RptPurchase NewBP = new Bp_RptPurchase();
dt = NewBP.GetVendorName(int.Parse(PrID.ToString()));
if (dt.Rows.Count > 0)
{
txtVendorName.Text = dt.Rows[0]["VendorName"].ToString();
}
dt.Dispose();
}
private void btnPreview_Click(object sender, EventArgs e)
{
try
{
if (!ValidateReportForm())
{
return;
}
if (lstvReports.SelectedItems[0].Key.Equals("RptClientIssuenceDateWise"))
{
DataTable dt = new DataTable();
BP_RptClientIssuencecDateWise NewBP = new BP_RptClientIssuencecDateWise();
dt = NewBP.GetReportData(int.Parse(ClientID.ToString()));
if (dt.Rows.Count == 0)
{
MessageBox.Show("No Record Found", "Easy Rashan Management System", MessageBoxButtons.OK, MessageBoxIcon.Stop);
return;
}
else
{
Reports.RptClientIssuenceDateWise rpt = new EasyRashanManagementSystem.Reports.RptClientIssuenceDateWise();
rpt.SetDataSource(dt);
CommonDAL.ShowReport(rpt, "Isuence Report DateWise");
dt.Dispose();
}
}
if (lstvReports.SelectedItems[0].Key.Equals("RptStockBalance"))
{
DataTable dt = new DataTable();
BP_RptStockBalance NewBPObj = new BP_RptStockBalance();
dt = NewBPObj.GetStockBalance();
if (dt.Rows.Count == 0)
{
MessageBox.Show("No Record Found", "Easy Rashan Management System", MessageBoxButtons.OK, MessageBoxIcon.Stop);
}
else
{
Reports.RptStockBalance rpt = new EasyRashanManagementSystem.Reports.RptStockBalance();
rpt.SetDataSource(dt);
TextObject txtDate = (TextObject)rpt.ReportDefinition.ReportObjects["txtDate"];
txtDate.Text = DateTime.Now.ToString();
CommonDAL.ShowReport(rpt, "Stock Balance Report");
dt.Dispose();
}
}
if (lstvReports.SelectedItems[0].Key.Equals("Rpt_Purchase"))
{
DataTable dt = new DataTable();
Bp_RptPurchase NewBP = new Bp_RptPurchase();
dt = NewBP.ShowPurchaseItems(int.Parse(PrID.ToString()));
if (dt.Rows.Count == 0)
{
MessageBox.Show("No Record Found", "Easy Rashan Management System", MessageBoxButtons.OK, MessageBoxIcon.Stop);
}
else
{
Reports.Rpt_Purchase rpt = new EasyRashanManagementSystem.Reports.Rpt_Purchase();
rpt.SetDataSource(dt);
CommonDAL.ShowReport(rpt, "All PurchaseItems");
dt.Dispose();
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Easy Rashan Management System", MessageBoxButtons.OK, MessageBoxIcon.Stop);
}
}
