protected void Page_Load(object sender, EventArgs e)
{
var markets = _productRepository.MarketList;
LocationRpt.DataSource = markets;
LocationRpt.DataBind();
}
private void btnPreview_Click(object sender, EventArgs e)
{
try
{
if (!GlobalFunctions.checkRights("tsm" + lType.Name, "Preview"))
{
return;
}
if (dgvLists.Rows.Count != 0)
{
switch (lType.Name)
{
case "Supplier":
SupplierRpt loSupplierRpt = new SupplierRpt();
loSupplierRpt.SetDataSource(GlobalVariables.DTCompanyLogo);
loSupplierRpt.Database.Tables[1].SetDataSource(ldtShow);
loSupplierRpt.SetParameterValue("CompanyName", GlobalVariables.CompanyName);
loSupplierRpt.SetParameterValue("CompanyAddress", GlobalVariables.CompanyAddress);
loSupplierRpt.SetParameterValue("CompanyContactNumber", GlobalVariables.ContactNumber);
loSupplierRpt.SetParameterValue("Username", GlobalVariables.Userfullname);
loSupplierRpt.SetParameterValue("Title", "Supplier List");
loSupplierRpt.SetParameterValue("SubTitle", "Supplier List");
try
{
if (loSearches.lAlias == "")
{
loSupplierRpt.SetParameterValue("QueryString", loSearches.lQuery.Replace("WHERE ", ""));
}
else
{
loSupplierRpt.SetParameterValue("QueryString", loSearches.lQuery.Replace("WHERE ", "").Replace(loSearches.lAlias, ""));
}
}
catch
{
loSupplierRpt.SetParameterValue("QueryString", "");
}
loReportViewer.crystalReportViewer.ReportSource = loSupplierRpt;
loReportViewer.ShowDialog();
break;
case "Customer":
CustomerRpt loCustomerRpt = new CustomerRpt();
loCustomerRpt.SetDataSource(GlobalVariables.DTCompanyLogo);
loCustomerRpt.Database.Tables[1].SetDataSource(ldtShow);
loCustomerRpt.SetParameterValue("CompanyName", GlobalVariables.CompanyName);
loCustomerRpt.SetParameterValue("CompanyAddress", GlobalVariables.CompanyAddress);
loCustomerRpt.SetParameterValue("CompanyContactNumber", GlobalVariables.ContactNumber);
loCustomerRpt.SetParameterValue("Username", GlobalVariables.Userfullname);
loCustomerRpt.SetParameterValue("Title", "Customer List");
loCustomerRpt.SetParameterValue("SubTitle", "Customer List");
try
{
if (loSearches.lAlias == "")
{
loCustomerRpt.SetParameterValue("QueryString", loSearches.lQuery.Replace("WHERE ", ""));
}
else
{
loCustomerRpt.SetParameterValue("QueryString", loSearches.lQuery.Replace("WHERE ", "").Replace(loSearches.lAlias, ""));
}
}
catch
{
loCustomerRpt.SetParameterValue("QueryString", "");
}
loReportViewer.crystalReportViewer.ReportSource = loCustomerRpt;
loReportViewer.ShowDialog();
break;
case "InventoryGroup":
InventoryGroupRpt loInventoryGroupRpt = new InventoryGroupRpt();
loInventoryGroupRpt.SetDataSource(GlobalVariables.DTCompanyLogo);
loInventoryGroupRpt.Database.Tables[1].SetDataSource(ldtShow);
loInventoryGroupRpt.SetParameterValue("CompanyName", GlobalVariables.CompanyName);
loInventoryGroupRpt.SetParameterValue("CompanyAddress", GlobalVariables.CompanyAddress);
loInventoryGroupRpt.SetParameterValue("CompanyContactNumber", GlobalVariables.ContactNumber);
loInventoryGroupRpt.SetParameterValue("Username", GlobalVariables.Userfullname);
loInventoryGroupRpt.SetParameterValue("Title", "Inventory Group List");
loInventoryGroupRpt.SetParameterValue("SubTitle", "Inventory Group List");
try
{
if (loSearches.lAlias == "")
{
loInventoryGroupRpt.SetParameterValue("QueryString", loSearches.lQuery.Replace("WHERE ", ""));
}
else
{
loInventoryGroupRpt.SetParameterValue("QueryString", loSearches.lQuery.Replace("WHERE ", "").Replace(loSearches.lAlias, ""));
}
}
catch
{
loInventoryGroupRpt.SetParameterValue("QueryString", "");
}
loReportViewer.crystalReportViewer.ReportSource = loInventoryGroupRpt;
loReportViewer.ShowDialog();
break;
case "Category":
CategoryRpt loCategoryRpt = new CategoryRpt();
loCategoryRpt.SetDataSource(GlobalVariables.DTCompanyLogo);
loCategoryRpt.Database.Tables[1].SetDataSource(ldtShow);
loCategoryRpt.SetParameterValue("CompanyName", GlobalVariables.CompanyName);
loCategoryRpt.SetParameterValue("CompanyAddress", GlobalVariables.CompanyAddress);
loCategoryRpt.SetParameterValue("CompanyContactNumber", GlobalVariables.ContactNumber);
loCategoryRpt.SetParameterValue("Username", GlobalVariables.Userfullname);
loCategoryRpt.SetParameterValue("Title", "Category List");
loCategoryRpt.SetParameterValue("SubTitle", "Category List");
try
{
if (loSearches.lAlias == "")
{
loCategoryRpt.SetParameterValue("QueryString", loSearches.lQuery.Replace("WHERE ", ""));
}
else
{
loCategoryRpt.SetParameterValue("QueryString", loSearches.lQuery.Replace("WHERE ", "").Replace(loSearches.lAlias, ""));
}
}
catch
{
loCategoryRpt.SetParameterValue("QueryString", "");
}
loReportViewer.crystalReportViewer.ReportSource = loCategoryRpt;
loReportViewer.ShowDialog();
break;
case "Stock":
StockRpt loStockRpt = new StockRpt();
loStockRpt.SetDataSource(GlobalVariables.DTCompanyLogo);
loStockRpt.Database.Tables[1].SetDataSource(ldtShow);
loStockRpt.SetParameterValue("CompanyName", GlobalVariables.CompanyName);
loStockRpt.SetParameterValue("CompanyAddress", GlobalVariables.CompanyAddress);
loStockRpt.SetParameterValue("CompanyContactNumber", GlobalVariables.ContactNumber);
loStockRpt.SetParameterValue("Username", GlobalVariables.Userfullname);
loStockRpt.SetParameterValue("Title", "Stock List");
loStockRpt.SetParameterValue("SubTitle", "Stock List");
try
{
if (loSearches.lAlias == "")
{
loStockRpt.SetParameterValue("QueryString", loSearches.lQuery.Replace("WHERE ", ""));
}
else
{
loStockRpt.SetParameterValue("QueryString", loSearches.lQuery.Replace("WHERE ", "").Replace(loSearches.lAlias, ""));
}
}
catch
{
loStockRpt.SetParameterValue("QueryString", "");
}
loReportViewer.crystalReportViewer.ReportSource = loStockRpt;
loReportViewer.ShowDialog();
break;
case "Unit":
UnitRpt loUnitRpt = new UnitRpt();
loUnitRpt.SetDataSource(GlobalVariables.DTCompanyLogo);
loUnitRpt.Database.Tables[1].SetDataSource(ldtShow);
loUnitRpt.SetParameterValue("CompanyName", GlobalVariables.CompanyName);
loUnitRpt.SetParameterValue("CompanyAddress", GlobalVariables.CompanyAddress);
loUnitRpt.SetParameterValue("CompanyContactNumber", GlobalVariables.ContactNumber);
loUnitRpt.SetParameterValue("Username", GlobalVariables.Userfullname);
loUnitRpt.SetParameterValue("Title", "Unit List");
loUnitRpt.SetParameterValue("SubTitle", "Unit List");
try
{
if (loSearches.lAlias == "")
{
loUnitRpt.SetParameterValue("QueryString", loSearches.lQuery.Replace("WHERE ", ""));
}
else
{
loUnitRpt.SetParameterValue("QueryString", loSearches.lQuery.Replace("WHERE ", "").Replace(loSearches.lAlias, ""));
}
}
catch
{
loUnitRpt.SetParameterValue("QueryString", "");
}
loReportViewer.crystalReportViewer.ReportSource = loUnitRpt;
loReportViewer.ShowDialog();
break;
case "InventoryType":
InventoryTypeRpt loInventoryTypeRpt = new InventoryTypeRpt();
loInventoryTypeRpt.SetDataSource(GlobalVariables.DTCompanyLogo);
loInventoryTypeRpt.Database.Tables[1].SetDataSource(ldtShow);
loInventoryTypeRpt.SetParameterValue("CompanyName", GlobalVariables.CompanyName);
loInventoryTypeRpt.SetParameterValue("CompanyAddress", GlobalVariables.CompanyAddress);
loInventoryTypeRpt.SetParameterValue("CompanyContactNumber", GlobalVariables.ContactNumber);
loInventoryTypeRpt.SetParameterValue("Username", GlobalVariables.Userfullname);
loInventoryTypeRpt.SetParameterValue("Title", "Inventory Type List");
loInventoryTypeRpt.SetParameterValue("SubTitle", "Inventory Type List");
try
{
if (loSearches.lAlias == "")
{
loInventoryTypeRpt.SetParameterValue("QueryString", loSearches.lQuery.Replace("WHERE ", ""));
}
else
{
loInventoryTypeRpt.SetParameterValue("QueryString", loSearches.lQuery.Replace("WHERE ", "").Replace(loSearches.lAlias, ""));
}
}
catch
{
loInventoryTypeRpt.SetParameterValue("QueryString", "");
}
loReportViewer.crystalReportViewer.ReportSource = loInventoryTypeRpt;
loReportViewer.ShowDialog();
break;
case "Location":
LocationRpt loLocationRpt = new LocationRpt();
loLocationRpt.SetDataSource(GlobalVariables.DTCompanyLogo);
loLocationRpt.Database.Tables[1].SetDataSource(ldtShow);
loLocationRpt.SetParameterValue("CompanyName", GlobalVariables.CompanyName);
loLocationRpt.SetParameterValue("CompanyAddress", GlobalVariables.CompanyAddress);
loLocationRpt.SetParameterValue("CompanyContactNumber", GlobalVariables.ContactNumber);
loLocationRpt.SetParameterValue("Username", GlobalVariables.Userfullname);
loLocationRpt.SetParameterValue("Title", "Location List");
loLocationRpt.SetParameterValue("SubTitle", "Location List");
try
{
if (loSearches.lAlias == "")
{
loLocationRpt.SetParameterValue("QueryString", loSearches.lQuery.Replace("WHERE ", ""));
}
else
{
loLocationRpt.SetParameterValue("QueryString", loSearches.lQuery.Replace("WHERE ", "").Replace(loSearches.lAlias, ""));
}
}
catch
{
loLocationRpt.SetParameterValue("QueryString", "");
}
loReportViewer.crystalReportViewer.ReportSource = loLocationRpt;
loReportViewer.ShowDialog();
break;
}
}
}
catch (Exception ex)
{
ErrorMessageUI em = new ErrorMessageUI(ex.Message, this.Name, "btnPreview_Click");
em.ShowDialog();
return;
}
}
