private void previewPurchaseRequestDetail(string pPurchaseRequestId)
{
try
{
foreach (DataRow _dr in loPurchaseRequest.getAllData("", pPurchaseRequestId, "").Rows)
{
loPurchaseRequestDetailRpt.SetDataSource(GlobalVariables.DTCompanyLogo);
loPurchaseRequestDetailRpt.Database.Tables[1].SetDataSource(loPurchaseRequestDetail.getPurchaseRequestDetails("ViewAll", pPurchaseRequestId));
loPurchaseRequestDetailRpt.SetParameterValue("CompanyName", GlobalVariables.CompanyName);
loPurchaseRequestDetailRpt.SetParameterValue("CompanyAddress", GlobalVariables.CompanyAddress);
loPurchaseRequestDetailRpt.SetParameterValue("CompanyContactNumber", GlobalVariables.ContactNumber);
loPurchaseRequestDetailRpt.SetParameterValue("Username", GlobalVariables.Userfullname);
loPurchaseRequestDetailRpt.SetParameterValue("Title", "Purchase Request");
loPurchaseRequestDetailRpt.SetParameterValue("SubTitle", "Purchase Request");
loPurchaseRequestDetailRpt.SetParameterValue("PRId", _dr["Id"].ToString());
loPurchaseRequestDetailRpt.SetParameterValue("Date", _dr["Date"].ToString());
loPurchaseRequestDetailRpt.SetParameterValue("RequestedBy", _dr["Requested By"].ToString());
loPurchaseRequestDetailRpt.SetParameterValue("Reference", _dr["Reference"].ToString());
loPurchaseRequestDetailRpt.SetParameterValue("DateNeeded", _dr["Date Needed"].ToString());
loPurchaseRequestDetailRpt.SetParameterValue("Supplier", _dr["Supplier"].ToString());
loPurchaseRequestDetailRpt.SetParameterValue("Instructions", _dr["Instructions"].ToString());
loPurchaseRequestDetailRpt.SetParameterValue("Terms", _dr["Terms"].ToString());
loReportViewer.crystalReportViewer.ReportSource = loPurchaseRequestDetailRpt;
loReportViewer.ShowDialog();
}
}
catch (Exception ex)
{
throw ex;
}
}
private void previewInventoryDetail(string pInventoryId)
{
try
{
foreach (DataRow _dr in loInventory.getAllData("Stock Receiving", "", pInventoryId, "").Rows)
{
loStockReceivingDetailRpt.SetDataSource(GlobalVariables.DTCompanyLogo);
loStockReceivingDetailRpt.Database.Tables[1].SetDataSource(loInventoryDetail.getInventoryDetails("ViewAll", pInventoryId));
loStockReceivingDetailRpt.SetParameterValue("CompanyName", GlobalVariables.CompanyName);
loStockReceivingDetailRpt.SetParameterValue("CompanyAddress", GlobalVariables.CompanyAddress);
loStockReceivingDetailRpt.SetParameterValue("CompanyContactNumber", GlobalVariables.ContactNumber);
loStockReceivingDetailRpt.SetParameterValue("Username", GlobalVariables.Userfullname);
loStockReceivingDetailRpt.SetParameterValue("Title", "Stock Receiving");
loStockReceivingDetailRpt.SetParameterValue("SubTitle", "Stock Receiving");
loStockReceivingDetailRpt.SetParameterValue("SRId", _dr["Id"].ToString());
loStockReceivingDetailRpt.SetParameterValue("Date", _dr["Date"].ToString());
loStockReceivingDetailRpt.SetParameterValue("PreparedBy", _dr["Prepared By"].ToString());
loStockReceivingDetailRpt.SetParameterValue("Reference", _dr["Reference"].ToString());
loStockReceivingDetailRpt.SetParameterValue("POId", _dr["P.O. Id"].ToString());
loStockReceivingDetailRpt.SetParameterValue("Supplier", _dr["Supplier"].ToString());
loStockReceivingDetailRpt.SetParameterValue("FinalizedBy", _dr["Finalized By"].ToString());
loReportViewer.crystalReportViewer.ReportSource = loStockReceivingDetailRpt;
loReportViewer.ShowDialog();
}
}
catch (Exception ex)
{
throw ex;
}
}
private void previewSalesOrderDetail(string pSalesOrderId)
{
try
{
foreach (DataRow _dr in loSalesOrder.getAllData("", pSalesOrderId, "").Rows)
{
loSalesOrderDetailRpt.SetDataSource(GlobalVariables.DTCompanyLogo);
loSalesOrderDetailRpt.Database.Tables[1].SetDataSource(loSalesOrderDetail.getSalesOrderDetails("ViewAll",pSalesOrderId));
loSalesOrderDetailRpt.SetParameterValue("CompanyName", GlobalVariables.CompanyName);
loSalesOrderDetailRpt.SetParameterValue("CompanyAddress", GlobalVariables.CompanyAddress);
loSalesOrderDetailRpt.SetParameterValue("CompanyContactNumber", GlobalVariables.ContactNumber);
loSalesOrderDetailRpt.SetParameterValue("Username", GlobalVariables.Userfullname);
loSalesOrderDetailRpt.SetParameterValue("Title", "Sales Order");
loSalesOrderDetailRpt.SetParameterValue("SubTitle", "Sales Order");
loSalesOrderDetailRpt.SetParameterValue("SOId", _dr["Id"].ToString());
loSalesOrderDetailRpt.SetParameterValue("Date", _dr["Date"].ToString());
loSalesOrderDetailRpt.SetParameterValue("PreparedBy", _dr["Prepared By"].ToString());
loSalesOrderDetailRpt.SetParameterValue("Reference", _dr["Reference"].ToString());
loSalesOrderDetailRpt.SetParameterValue("DueDate", _dr["Due Date"].ToString());
loSalesOrderDetailRpt.SetParameterValue("Customer", _dr["Customer"].ToString());
loSalesOrderDetailRpt.SetParameterValue("Instructions", _dr["Instructions"].ToString());
loSalesOrderDetailRpt.SetParameterValue("Terms", _dr["Terms"].ToString());
loSalesOrderDetailRpt.SetParameterValue("TotalQty", string.Format("{0:n}",decimal.Parse(_dr["Total S.O. Qty"].ToString())));
loSalesOrderDetailRpt.SetParameterValue("TotalAmount", string.Format("{0:n}", decimal.Parse(_dr["Total Amount"].ToString())));
loSalesOrderDetailRpt.SetParameterValue("FinalizedBy", _dr["Finalized By"].ToString());
loReportViewer.crystalReportViewer.ReportSource = loSalesOrderDetailRpt;
loReportViewer.ShowDialog();
}
}
catch (Exception ex)
{
throw ex;
}
}
private void previewPriceQuotationDetail(string pPriceQuotationId)
{
try
{
foreach (DataRow _dr in loPriceQuotation.getAllData("", pPriceQuotationId, "").Rows)
{
loPriceQuotationDetailRpt.SetDataSource(GlobalVariables.DTCompanyLogo);
loPriceQuotationDetailRpt.Database.Tables[1].SetDataSource(loPriceQuotationDetail.getPriceQuotationDetails("ViewAll", pPriceQuotationId));
loPriceQuotationDetailRpt.SetParameterValue("CompanyName", GlobalVariables.CompanyName);
loPriceQuotationDetailRpt.SetParameterValue("CompanyAddress", GlobalVariables.CompanyAddress);
loPriceQuotationDetailRpt.SetParameterValue("CompanyContactNumber", GlobalVariables.ContactNumber);
loPriceQuotationDetailRpt.SetParameterValue("Username", GlobalVariables.Userfullname);
loPriceQuotationDetailRpt.SetParameterValue("Title", "Price Quotation");
loPriceQuotationDetailRpt.SetParameterValue("SubTitle", "Price Quotation");
loPriceQuotationDetailRpt.SetParameterValue("PQId", _dr["Id"].ToString());
loPriceQuotationDetailRpt.SetParameterValue("Date", _dr["Date"].ToString());
loPriceQuotationDetailRpt.SetParameterValue("SalesPerson", _dr["Sales Person"].ToString());
loPriceQuotationDetailRpt.SetParameterValue("Reference", _dr["Reference"].ToString());
loPriceQuotationDetailRpt.SetParameterValue("ValidUntil", _dr["Valid Until"].ToString());
loPriceQuotationDetailRpt.SetParameterValue("Customer", _dr["Customer"].ToString());
loPriceQuotationDetailRpt.SetParameterValue("Instructions", _dr["Instructions"].ToString());
loPriceQuotationDetailRpt.SetParameterValue("Terms", _dr["Terms"].ToString());
loPriceQuotationDetailRpt.SetParameterValue("ShipDate", _dr["Ship Date"].ToString());
loPriceQuotationDetailRpt.SetParameterValue("ShipVia", _dr["Ship Via"].ToString());
loPriceQuotationDetailRpt.SetParameterValue("TotalQty", string.Format("{0:n}", decimal.Parse(_dr["Total Qty"].ToString())));
loPriceQuotationDetailRpt.SetParameterValue("TotalAmount", string.Format("{0:n}", decimal.Parse(_dr["Total Amount"].ToString())));
loReportViewer.crystalReportViewer.ReportSource = loPriceQuotationDetailRpt;
loReportViewer.ShowDialog();
}
}
catch (Exception ex)
{
throw ex;
}
}
private void previewDetails(string pSRId)
{
try
{
foreach (DataRow _dr in loInventoryHeader.getAllData("", pSRId, "", "Stock Receiving").Rows)
{
DataTable _dt = loInventoryDetail.getAllData(_dr[0].ToString());
loStockReceivingDetailRpt.SetDataSource(GlobalVariables.DTCompanyLogo);
loStockReceivingDetailRpt.Database.Tables[1].SetDataSource(_dt);
loStockReceivingDetailRpt.SetParameterValue("CompanyName", GlobalVariables.CompanyName);
loStockReceivingDetailRpt.SetParameterValue("CompanyAddress", GlobalVariables.CompanyAddress);
loStockReceivingDetailRpt.SetParameterValue("CompanyContactNumber", GlobalVariables.ContactNumber);
loStockReceivingDetailRpt.SetParameterValue("Username", GlobalVariables.Userfullname);
loStockReceivingDetailRpt.SetParameterValue("Title", "Stock Receiving Slip");
loStockReceivingDetailRpt.SetParameterValue("SubTitle", "Stock Receiving Slip");
loStockReceivingDetailRpt.SetParameterValue("Id", _dr["Id"].ToString());
loStockReceivingDetailRpt.SetParameterValue("Date", string.Format("{0:MM-dd-yyyy}", DateTime.Parse(_dr["Date"].ToString())));
foreach (DataRow _dr1 in _dt.Rows)
{
loStockReceivingDetailRpt.SetParameterValue("Location", _dr1["Location"].ToString());
}
loStockReceivingDetailRpt.SetParameterValue("Supplier", _dr["Supplier"].ToString());
loStockReceivingDetailRpt.SetParameterValue("Reference", _dr["Reference"].ToString());
//loStockReceivingDetailRpt.SetParameterValue("TotalAmount", string.Format("{0:n}", decimal.Parse(_dr["Total Amount"].ToString())));
loStockReceivingDetailRpt.SetParameterValue("ReceivedBy", _dr["Username"].ToString());
loStockReceivingDetailRpt.SetParameterValue("Remarks", _dr["Remarks"].ToString());
loReportViewer.crystalReportViewer.ReportSource = loStockReceivingDetailRpt;
loReportViewer.ShowDialog();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void previewDetail(string pJournalEntryId)
{
try
{
foreach (DataRow _dr in loJournalEntry.getAllData("", "", pJournalEntryId, "").Rows)
{
loJournalVoucherRpt.SetDataSource(GlobalVariables.DTCompanyLogo);
loJournalVoucherRpt.Database.Tables[1].SetDataSource(loJournalEntryDetail.getJournalEntryDetails("ViewAll", pJournalEntryId));
loJournalVoucherRpt.SetParameterValue("CompanyName", GlobalVariables.CompanyName);
loJournalVoucherRpt.SetParameterValue("CompanyAddress", GlobalVariables.CompanyAddress);
loJournalVoucherRpt.SetParameterValue("CompanyContactNumber", GlobalVariables.ContactNumber);
loJournalVoucherRpt.SetParameterValue("Username", GlobalVariables.Userfullname);
loJournalVoucherRpt.SetParameterValue("Title", "Journal Voucher");
loJournalVoucherRpt.SetParameterValue("SubTitle", "Journal Voucher");
loJournalVoucherRpt.SetParameterValue("JEId", _dr["Id"].ToString());
loJournalVoucherRpt.SetParameterValue("FY", _dr["F.Y."].ToString());
loJournalVoucherRpt.SetParameterValue("VoucherNo", _dr["Voucher No."].ToString());
loJournalVoucherRpt.SetParameterValue("DatePrepared", _dr["Date Prepared"].ToString());
loJournalVoucherRpt.SetParameterValue("Reference", _dr["Reference"].ToString());
loJournalVoucherRpt.SetParameterValue("BegBal", _dr["Beg. Bal."].ToString());
loJournalVoucherRpt.SetParameterValue("Adjustment", _dr["Adjustment"].ToString());
loJournalVoucherRpt.SetParameterValue("ClosingEntry", _dr["Closing Entry"].ToString());
loJournalVoucherRpt.SetParameterValue("Explanation", _dr["Explanation"].ToString());
loJournalVoucherRpt.SetParameterValue("PreparedBy", _dr["Prepared By"].ToString());
loJournalVoucherRpt.SetParameterValue("PostedBy", _dr["Posted By"].ToString());
loReportViewer.crystalReportViewer.ReportSource = loJournalVoucherRpt;
loReportViewer.ShowDialog();
}
}
catch (Exception ex)
{
throw ex;
}
}
private void previewDetails(string pHeaderId)
{
try
{
foreach (DataRow _dr in loInventoryHeader.getAllData("", pHeaderId, "", "Stock Withdrawal").Rows)
{
DataTable _dt = loInventoryDetail.getAllData(_dr[0].ToString());
loStockWithdrawalDetailRpt.SetDataSource(GlobalVariables.DTCompanyLogo);
loStockWithdrawalDetailRpt.Database.Tables[1].SetDataSource(_dt);
loStockWithdrawalDetailRpt.SetParameterValue("CompanyName", GlobalVariables.CompanyName);
loStockWithdrawalDetailRpt.SetParameterValue("CompanyAddress", GlobalVariables.CompanyAddress);
loStockWithdrawalDetailRpt.SetParameterValue("CompanyContactNumber", GlobalVariables.ContactNumber);
loStockWithdrawalDetailRpt.SetParameterValue("Username", GlobalVariables.Userfullname);
loStockWithdrawalDetailRpt.SetParameterValue("Title", "Stock Withdrawal Slip");
loStockWithdrawalDetailRpt.SetParameterValue("SubTitle", "Stock Withdrawal Slip");
loStockWithdrawalDetailRpt.SetParameterValue("Id", _dr["Id"].ToString());
loStockWithdrawalDetailRpt.SetParameterValue("Date", string.Format("{0:MM-dd-yyyy}", DateTime.Parse(_dr["Date"].ToString())));
foreach (DataRow _dr1 in _dt.Rows)
{
loStockWithdrawalDetailRpt.SetParameterValue("Location", _dr1["Location"].ToString());
}
loStockWithdrawalDetailRpt.SetParameterValue("Customer", _dr["Customer"].ToString());
loStockWithdrawalDetailRpt.SetParameterValue("Reference", _dr["Reference"].ToString());
loStockWithdrawalDetailRpt.SetParameterValue("ReleasedBy", _dr["Username"].ToString());
loStockWithdrawalDetailRpt.SetParameterValue("Remarks", _dr["Remarks"].ToString());
loReportViewer.crystalReportViewer.ReportSource = loStockWithdrawalDetailRpt;
loReportViewer.ShowDialog();
}
}
catch { }
}
private void btnPreview_Click(object sender, EventArgs e)
{
if (!GlobalFunctions.checkRights("tsmAuditTrail", "Preview"))
{
return;
}
try
{
loAuditTrailRpt.SetDataSource(ldtAuditTrail);
loAuditTrailRpt.Database.Tables[1].SetDataSource(GlobalVariables.DTCompanyLogo);
loAuditTrailRpt.SetParameterValue("CompanyName", GlobalVariables.CompanyName);
loAuditTrailRpt.SetParameterValue("CompanyAddress", GlobalVariables.CompanyAddress);
loAuditTrailRpt.SetParameterValue("CompanyContactNumber", GlobalVariables.ContactNumber);
loAuditTrailRpt.SetParameterValue("Username", GlobalVariables.Userfullname);
loAuditTrailRpt.SetParameterValue("Title", "Audit Trail");
loAuditTrailRpt.SetParameterValue("SubTitle", "Audit Trail");
loReportViewer.crystalReportViewer.ReportSource = loAuditTrailRpt;
loReportViewer.ShowDialog();
}
catch (Exception ex)
{
MessageBoxUI mb = new MessageBoxUI(ex, GlobalVariables.Icons.Error, GlobalVariables.Buttons.Close);
mb.ShowDialog();
return;
}
}
private void previewDetail(string pId)
{
try
{
foreach (DataRow _dr in loInventoryHeader.getAllData("ViewAll", pId, "", "Stock Receiving").Rows)
{
loStockReceivingDetailRpt.SetDataSource(GlobalVariables.DTCompanyLogo);
loStockReceivingDetailRpt.Database.Tables[1].SetDataSource(loInventoryDetail.getAllData(_dr[0].ToString()));
loStockReceivingDetailRpt.SetParameterValue("CompanyName", GlobalVariables.CompanyName);
loStockReceivingDetailRpt.SetParameterValue("CompanyAddress", GlobalVariables.CompanyAddress);
loStockReceivingDetailRpt.SetParameterValue("CompanyContactNumber", GlobalVariables.ContactNumber);
loStockReceivingDetailRpt.SetParameterValue("Username", GlobalVariables.Userfullname);
loStockReceivingDetailRpt.SetParameterValue("Title", "Stock Receiving Details");
loStockReceivingDetailRpt.SetParameterValue("SubTitle", "Stock Receiving Details");
loStockReceivingDetailRpt.SetParameterValue("Id", _dr["Id"].ToString());
loStockReceivingDetailRpt.SetParameterValue("Date", _dr["Date"].ToString());
loStockReceivingDetailRpt.SetParameterValue("Explanation", _dr["Explanation"].ToString());
loStockReceivingDetailRpt.SetParameterValue("ReceivedBy", _dr["Received By"].ToString());
loStockReceivingDetailRpt.SetParameterValue("Remarks", _dr["Remarks"].ToString());
loReportViewer.crystalReportViewer.ReportSource = loStockReceivingDetailRpt;
loReportViewer.ShowDialog();
}
}
catch { }
}
private void btnPreview_Click(object sender, EventArgs e)
{
try
{
loDailyCollectionAndReleaseSheetRpt.SetDataSource(GlobalVariables.DTCompanyLogo);
loDailyCollectionAndReleaseSheetRpt.Subreports["DailyCollectionRpt.rpt"].SetDataSource(loLoanApplicationDetail.getDailyCollectionSheet(dtpDate.Value, cboCollector.SelectedValue.ToString()));
loDailyCollectionAndReleaseSheetRpt.Subreports["ForReleaseRpt.rpt"].SetDataSource(loLoanApplication.getForReleaseSheet(dtpDate.Value, cboCollector.SelectedValue.ToString()));
loDailyCollectionAndReleaseSheetRpt.SetParameterValue("CompanyName", GlobalVariables.CompanyName);
loDailyCollectionAndReleaseSheetRpt.SetParameterValue("CompanyAddress", GlobalVariables.CompanyAddress);
loDailyCollectionAndReleaseSheetRpt.SetParameterValue("CompanyContactNumber", GlobalVariables.ContactNumber);
loDailyCollectionAndReleaseSheetRpt.SetParameterValue("Username", GlobalVariables.Userfullname);
loDailyCollectionAndReleaseSheetRpt.SetParameterValue("Title", "Daily Collection & Release Sheet");
loDailyCollectionAndReleaseSheetRpt.SetParameterValue("SubTitle", "Daily Collection & Release Sheet");
loDailyCollectionAndReleaseSheetRpt.SetParameterValue("Date", string.Format("{0:MM-dd-yyyy}", dtpDate.Value));
loDailyCollectionAndReleaseSheetRpt.SetParameterValue("PreparedBy", GlobalVariables.Userfullname);
loDailyCollectionAndReleaseSheetRpt.SetParameterValue("Branch", cboBranch.Text);
loDailyCollectionAndReleaseSheetRpt.SetParameterValue("Collector", cboCollector.Text);
loReportViewer.crystalReportViewer.ReportSource = loDailyCollectionAndReleaseSheetRpt;
loReportViewer.ShowDialog();
}
catch (Exception ex)
{
throw ex;
}
}
private void btnPreview_Click(object sender, EventArgs e)
{
try
{
if (!GlobalFunctions.checkRights("tsmAuditTrail", "Preview"))
{
return;
}
if (dgvAuditTrail.Rows.Count > 0)
{
loAuditTrailRpt.SetDataSource(GlobalVariables.DTCompanyLogo);
loAuditTrailRpt.Database.Tables[1].SetDataSource(ldtAuditTrail);
loAuditTrailRpt.SetParameterValue("CompanyName", GlobalVariables.CompanyName);
loAuditTrailRpt.SetParameterValue("CompanyAddress", GlobalVariables.CompanyAddress);
loAuditTrailRpt.SetParameterValue("CompanyContactNumber", GlobalVariables.ContactNumber);
loAuditTrailRpt.SetParameterValue("Username", GlobalVariables.Userfullname);
loAuditTrailRpt.SetParameterValue("Title", "Audit Trail");
loAuditTrailRpt.SetParameterValue("SubTitle", "Audit Trail");
loReportViewer.crystalReportViewer.ReportSource = loAuditTrailRpt;
loReportViewer.ShowDialog();
}
}
catch (Exception ex)
{
ErrorMessageUI em = new ErrorMessageUI(ex.Message, this.Name, "btnPreview_Click");
em.ShowDialog();
return;
}
}
private void btnPreviewAllStocks_Click(object sender, EventArgs e)
{
try
{
loStockInventoryRpt.SetDataSource(GlobalVariables.DTCompanyLogo);
loStockInventoryRpt.Database.Tables[1].SetDataSource(ldtAllStocks);
loStockInventoryRpt.SetParameterValue("CompanyName", GlobalVariables.CompanyName);
loStockInventoryRpt.SetParameterValue("CompanyAddress", GlobalVariables.CompanyAddress);
loStockInventoryRpt.SetParameterValue("CompanyContactNumber", GlobalVariables.ContactNumber);
loStockInventoryRpt.SetParameterValue("Username", GlobalVariables.Userfullname);
loStockInventoryRpt.SetParameterValue("Title", "Stock Inventory");
loStockInventoryRpt.SetParameterValue("SubTitle", "Stock Inventory");
loReportViewer.crystalReportViewer.ReportSource = loStockInventoryRpt;
loReportViewer.ShowDialog();
}
catch (Exception ex)
{
ErrorMessageUI em = new ErrorMessageUI(ex.Message, this.Name, "btnPreviewAllStocks_Click");
em.ShowDialog();
return;
}
}
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 "ProcurementDiscount":
ProcurementDiscountRpt loProcurementDiscountRpt = new ProcurementDiscountRpt();
loProcurementDiscountRpt.SetDataSource(GlobalVariables.DTCompanyLogo);
loProcurementDiscountRpt.Database.Tables[1].SetDataSource(ldtShow);
loProcurementDiscountRpt.SetParameterValue("CompanyName", GlobalVariables.CompanyName);
loProcurementDiscountRpt.SetParameterValue("CompanyAddress", GlobalVariables.CompanyAddress);
loProcurementDiscountRpt.SetParameterValue("CompanyContactNumber", GlobalVariables.ContactNumber);
loProcurementDiscountRpt.SetParameterValue("Username", GlobalVariables.Userfullname);
loProcurementDiscountRpt.SetParameterValue("Title", "Procurement Discount List");
loProcurementDiscountRpt.SetParameterValue("SubTitle", "Procurement Discount List");
try
{
if (loSearches.lAlias == "")
{
loProcurementDiscountRpt.SetParameterValue("QueryString", loSearches.lQuery.Replace("WHERE ", ""));
}
else
{
loProcurementDiscountRpt.SetParameterValue("QueryString", loSearches.lQuery.Replace("WHERE ", "").Replace(loSearches.lAlias, ""));
}
}
catch
{
loProcurementDiscountRpt.SetParameterValue("QueryString", "");
}
loReportViewer.crystalReportViewer.ReportSource = loProcurementDiscountRpt;
loReportViewer.ShowDialog();
break;
}
}
}
catch (Exception ex)
{
ErrorMessageUI em = new ErrorMessageUI(ex.Message, this.Name, "btnPreview_Click");
em.ShowDialog();
return;
}
}
private void btnPreview_Click(object sender, EventArgs e)
{
try
{
if (!GlobalFunctions.checkRights("tsmStockCard", "Preview"))
{
return;
}
decimal _qtyTotalIn = 0;
decimal _qtyTotalOut = 0;
decimal _qtyBegBal = 0;
foreach (DataRow _dr in loStock.getStockCardBegBal(dtpFromDate.Value, dgvStockList.CurrentRow.Cells[0].Value.ToString(), cboLocation.SelectedValue.ToString()).Rows)
{
_qtyTotalIn += decimal.Parse(_dr[0].ToString());
_qtyTotalOut += decimal.Parse(_dr[1].ToString());
_qtyBegBal += decimal.Parse(_dr[2].ToString());
}
loStockCardRpt.SetDataSource(GlobalVariables.DTCompanyLogo);
loStockCardRpt.Database.Tables[1].SetDataSource(ldtList);
loStockCardRpt.SetParameterValue("CompanyName", GlobalVariables.CompanyName);
loStockCardRpt.SetParameterValue("CompanyAddress", GlobalVariables.CompanyAddress);
loStockCardRpt.SetParameterValue("CompanyContactNumber", GlobalVariables.ContactNumber);
loStockCardRpt.SetParameterValue("Username", GlobalVariables.Userfullname);
loStockCardRpt.SetParameterValue("Title", "Stock Card");
loStockCardRpt.SetParameterValue("SubTitle", "Stock Card");
loStockCardRpt.SetParameterValue("DateFrom", string.Format("{0:MM-dd-yyyy}", dtpFromDate.Value));
loStockCardRpt.SetParameterValue("DateTo", string.Format("{0:MM-dd-yyyy}", dtpToDate.Value));
loStockCardRpt.SetParameterValue("Stock", dgvStockList.CurrentRow.Cells[1].Value.ToString());
loStockCardRpt.SetParameterValue("Location", cboLocation.Text);
loStockCardRpt.SetParameterValue("QtyTotalIn", string.Format("{0:n}", _qtyTotalIn));
loStockCardRpt.SetParameterValue("QtyTotalOut", string.Format("{0:n}", _qtyTotalOut));
loStockCardRpt.SetParameterValue("QtyBegBal", string.Format("{0:n}", _qtyBegBal));
loReportViewer.crystalReportViewer.ReportSource = loStockCardRpt;
loReportViewer.ShowDialog();
}
catch (Exception ex)
{
ErrorMessageUI em = new ErrorMessageUI(ex.Message, this.Name, "btnPreview_Click");
em.ShowDialog();
return;
}
}
private void btnPreview_Click(object sender, EventArgs e)
{
try
{
if (!GlobalFunctions.checkRights("tsmCashierPeriods", "Preview"))
{
return;
}
try
{
if (ldtCashierPeriod.Rows.Count > 0)
{
loCashierPeriodsRpt.SetDataSource(GlobalVariables.DTCompanyLogo);
loCashierPeriodsRpt.Database.Tables[1].SetDataSource(ldtCashierPeriod);
loCashierPeriodsRpt.SetParameterValue("CompanyName", GlobalVariables.CompanyName);
loCashierPeriodsRpt.SetParameterValue("CompanyAddress", GlobalVariables.CompanyAddress);
loCashierPeriodsRpt.SetParameterValue("CompanyContactNumber", GlobalVariables.ContactNumber);
loCashierPeriodsRpt.SetParameterValue("Username", GlobalVariables.Userfullname);
loCashierPeriodsRpt.SetParameterValue("DateFrom", string.Format("{0:MM-dd-yyyy}", dtpFromDate.Value));
loCashierPeriodsRpt.SetParameterValue("DateTo", string.Format("{0:MM-dd-yyyy}", dtpToDate.Value));
loCashierPeriodsRpt.SetParameterValue("Title", "Cashier Periods");
loCashierPeriodsRpt.SetParameterValue("SubTitle", "Cashier Periods");
loReportViewer.crystalReportViewer.ReportSource = loCashierPeriodsRpt;
loReportViewer.ShowDialog();
}
}
catch (Exception ex)
{
throw ex;
}
}
catch (Exception ex)
{
ErrorMessageUI em = new ErrorMessageUI(ex.Message, this.Name, "btnRefresh_Click");
em.ShowDialog();
return;
}
}
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 "ChartOfAccount":
ChartOfAccountRpt loChartOfAccountRpt = new ChartOfAccountRpt();
loChartOfAccountRpt.SetDataSource(GlobalVariables.DTCompanyLogo);
loChartOfAccountRpt.Database.Tables[1].SetDataSource(ldtShow);
loChartOfAccountRpt.SetParameterValue("CompanyName", GlobalVariables.CompanyName);
loChartOfAccountRpt.SetParameterValue("CompanyAddress", GlobalVariables.CompanyAddress);
loChartOfAccountRpt.SetParameterValue("CompanyContactNumber", GlobalVariables.ContactNumber);
loChartOfAccountRpt.SetParameterValue("Username", GlobalVariables.Userfullname);
loChartOfAccountRpt.SetParameterValue("Title", "Chart of Account List");
loChartOfAccountRpt.SetParameterValue("SubTitle", "Chart of Account List");
try
{
if (loSearches.lAlias == "")
{
loChartOfAccountRpt.SetParameterValue("QueryString", loSearches.lQuery.Replace("WHERE ", ""));
}
else
{
loChartOfAccountRpt.SetParameterValue("QueryString", loSearches.lQuery.Replace("WHERE ", "").Replace(loSearches.lAlias, ""));
}
}
catch
{
loChartOfAccountRpt.SetParameterValue("QueryString", "");
}
loReportViewer.crystalReportViewer.ReportSource = loChartOfAccountRpt;
loReportViewer.ShowDialog();
break;
case "Classification":
ClassificationRpt loClassification = new ClassificationRpt();
loClassification.SetDataSource(GlobalVariables.DTCompanyLogo);
loClassification.Database.Tables[1].SetDataSource(ldtShow);
loClassification.SetParameterValue("CompanyName", GlobalVariables.CompanyName);
loClassification.SetParameterValue("CompanyAddress", GlobalVariables.CompanyAddress);
loClassification.SetParameterValue("CompanyContactNumber", GlobalVariables.ContactNumber);
loClassification.SetParameterValue("Username", GlobalVariables.Userfullname);
loClassification.SetParameterValue("Title", "Classification List");
loClassification.SetParameterValue("SubTitle", "Classification List");
try
{
if (loSearches.lAlias == "")
{
loClassification.SetParameterValue("QueryString", loSearches.lQuery.Replace("WHERE ", ""));
}
else
{
loClassification.SetParameterValue("QueryString", loSearches.lQuery.Replace("WHERE ", "").Replace(loSearches.lAlias, ""));
}
}
catch
{
loClassification.SetParameterValue("QueryString", "");
}
loReportViewer.crystalReportViewer.ReportSource = loClassification;
loReportViewer.ShowDialog();
break;
case "SubClassification":
SubClassificationRpt loSubClassificationRpt = new SubClassificationRpt();
loSubClassificationRpt.SetDataSource(GlobalVariables.DTCompanyLogo);
loSubClassificationRpt.Database.Tables[1].SetDataSource(ldtShow);
loSubClassificationRpt.SetParameterValue("CompanyName", GlobalVariables.CompanyName);
loSubClassificationRpt.SetParameterValue("CompanyAddress", GlobalVariables.CompanyAddress);
loSubClassificationRpt.SetParameterValue("CompanyContactNumber", GlobalVariables.ContactNumber);
loSubClassificationRpt.SetParameterValue("Username", GlobalVariables.Userfullname);
loSubClassificationRpt.SetParameterValue("Title", "Sub Classification List");
loSubClassificationRpt.SetParameterValue("SubTitle", "Sub Classification List");
try
{
if (loSearches.lAlias == "")
{
loSubClassificationRpt.SetParameterValue("QueryString", loSearches.lQuery.Replace("WHERE ", ""));
}
else
{
loSubClassificationRpt.SetParameterValue("QueryString", loSearches.lQuery.Replace("WHERE ", "").Replace(loSearches.lAlias, ""));
}
}
catch
{
loSubClassificationRpt.SetParameterValue("QueryString", "");
}
loReportViewer.crystalReportViewer.ReportSource = loSubClassificationRpt;
loReportViewer.ShowDialog();
break;
case "MainAccount":
MainAccountRpt loMainAccountRpt = new MainAccountRpt();
loMainAccountRpt.SetDataSource(GlobalVariables.DTCompanyLogo);
loMainAccountRpt.Database.Tables[1].SetDataSource(ldtShow);
loMainAccountRpt.SetParameterValue("CompanyName", GlobalVariables.CompanyName);
loMainAccountRpt.SetParameterValue("CompanyAddress", GlobalVariables.CompanyAddress);
loMainAccountRpt.SetParameterValue("CompanyContactNumber", GlobalVariables.ContactNumber);
loMainAccountRpt.SetParameterValue("Username", GlobalVariables.Userfullname);
loMainAccountRpt.SetParameterValue("Title", "Main Account List");
loMainAccountRpt.SetParameterValue("SubTitle", "Main Account List");
try
{
if (loSearches.lAlias == "")
{
loMainAccountRpt.SetParameterValue("QueryString", loSearches.lQuery.Replace("WHERE ", ""));
}
else
{
loMainAccountRpt.SetParameterValue("QueryString", loSearches.lQuery.Replace("WHERE ", "").Replace(loSearches.lAlias, ""));
}
}
catch
{
loMainAccountRpt.SetParameterValue("QueryString", "");
}
loReportViewer.crystalReportViewer.ReportSource = loMainAccountRpt;
loReportViewer.ShowDialog();
break;
case "Equipment":
EquipmentRpt loEquipmentRpt = new EquipmentRpt();
loEquipmentRpt.SetDataSource(GlobalVariables.DTCompanyLogo);
loEquipmentRpt.Database.Tables[1].SetDataSource(ldtShow);
loEquipmentRpt.SetParameterValue("CompanyName", GlobalVariables.CompanyName);
loEquipmentRpt.SetParameterValue("CompanyAddress", GlobalVariables.CompanyAddress);
loEquipmentRpt.SetParameterValue("CompanyContactNumber", GlobalVariables.ContactNumber);
loEquipmentRpt.SetParameterValue("Username", GlobalVariables.Userfullname);
loEquipmentRpt.SetParameterValue("Title", "Equipment List");
loEquipmentRpt.SetParameterValue("SubTitle", "Equipment List");
try
{
if (loSearches.lAlias == "")
{
loEquipmentRpt.SetParameterValue("QueryString", loSearches.lQuery.Replace("WHERE ", ""));
}
else
{
loEquipmentRpt.SetParameterValue("QueryString", loSearches.lQuery.Replace("WHERE ", "").Replace(loSearches.lAlias, ""));
}
}
catch
{
loEquipmentRpt.SetParameterValue("QueryString", "");
}
loReportViewer.crystalReportViewer.ReportSource = loEquipmentRpt;
loReportViewer.ShowDialog();
break;
case "Building":
BuildingRpt loBuildingRpt = new BuildingRpt();
loBuildingRpt.SetDataSource(GlobalVariables.DTCompanyLogo);
loBuildingRpt.Database.Tables[1].SetDataSource(ldtShow);
loBuildingRpt.SetParameterValue("CompanyName", GlobalVariables.CompanyName);
loBuildingRpt.SetParameterValue("CompanyAddress", GlobalVariables.CompanyAddress);
loBuildingRpt.SetParameterValue("CompanyContactNumber", GlobalVariables.ContactNumber);
loBuildingRpt.SetParameterValue("Username", GlobalVariables.Userfullname);
loBuildingRpt.SetParameterValue("Title", "Building List");
loBuildingRpt.SetParameterValue("SubTitle", "Building List");
try
{
if (loSearches.lAlias == "")
{
loBuildingRpt.SetParameterValue("QueryString", loSearches.lQuery.Replace("WHERE ", ""));
}
else
{
loBuildingRpt.SetParameterValue("QueryString", loSearches.lQuery.Replace("WHERE ", "").Replace(loSearches.lAlias, ""));
}
}
catch
{
loBuildingRpt.SetParameterValue("QueryString", "");
}
loReportViewer.crystalReportViewer.ReportSource = loBuildingRpt;
loReportViewer.ShowDialog();
break;
case "Bank":
BankRpt loBankRpt = new BankRpt();
loBankRpt.SetDataSource(GlobalVariables.DTCompanyLogo);
loBankRpt.Database.Tables[1].SetDataSource(ldtShow);
loBankRpt.SetParameterValue("CompanyName", GlobalVariables.CompanyName);
loBankRpt.SetParameterValue("CompanyAddress", GlobalVariables.CompanyAddress);
loBankRpt.SetParameterValue("CompanyContactNumber", GlobalVariables.ContactNumber);
loBankRpt.SetParameterValue("Username", GlobalVariables.Userfullname);
loBankRpt.SetParameterValue("Title", "Bank List");
loBankRpt.SetParameterValue("SubTitle", "Bank List");
try
{
if (loSearches.lAlias == "")
{
loBankRpt.SetParameterValue("QueryString", loSearches.lQuery.Replace("WHERE ", ""));
}
else
{
loBankRpt.SetParameterValue("QueryString", loSearches.lQuery.Replace("WHERE ", "").Replace(loSearches.lAlias, ""));
}
}
catch
{
loBankRpt.SetParameterValue("QueryString", "");
}
loReportViewer.crystalReportViewer.ReportSource = loBankRpt;
loReportViewer.ShowDialog();
break;
}
}
}
catch (Exception ex)
{
ErrorMessageUI em = new ErrorMessageUI(ex.Message, this.Name, "btnPreview_Click");
em.ShowDialog();
return;
}
}
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;
}
}
private void printOrderSlip(string pPOSTransactionId, string pORNo)
{
foreach (DataRow _dr in loPOSTransaction.getPOSTransaction(pPOSTransactionId).Rows)
{
if (GlobalVariables.ORSize == "Plain Continuous-Long")
{
loOrderSlipRpt.SetDataSource(GlobalVariables.DTCompanyLogo);
loOrderSlipRpt.Database.Tables[1].SetDataSource(loPOSTransactionDetail.getPOSTransactionDetails(pPOSTransactionId));
loOrderSlipRpt.SetParameterValue("CompanyName", GlobalVariables.CompanyName);
loOrderSlipRpt.SetParameterValue("CompanyAddress", GlobalVariables.CompanyAddress);
loOrderSlipRpt.SetParameterValue("CompanyContactNumber", GlobalVariables.ContactNumber);
loOrderSlipRpt.SetParameterValue("Username", GlobalVariables.Userfullname);
loOrderSlipRpt.SetParameterValue("Title", "Order Slip");
loOrderSlipRpt.SetParameterValue("SubTitle", "Order Slip");
loOrderSlipRpt.SetParameterValue("TransactionNo", _dr["Id"].ToString());
loOrderSlipRpt.SetParameterValue("Date", _dr["Date"].ToString());
loOrderSlipRpt.SetParameterValue("TotalPrice", string.Format("{0:n}", decimal.Parse(_dr["Total Price"].ToString())));
loOrderSlipRpt.SetParameterValue("TotalDiscount", string.Format("{0:n}", decimal.Parse(_dr["Total Discount"].ToString())));
loOrderSlipRpt.SetParameterValue("TotalDue", string.Format("{0:n}", decimal.Parse(_dr["Total Due"].ToString())));
loOrderSlipRpt.SetParameterValue("PreparedBy", _dr["PreparedBy"].ToString());
loOrderSlipRpt.SetParameterValue("Customer", _dr["Customer"].ToString());
loOrderSlipRpt.SetParameterValue("Address", _dr["CustomerAddress"].ToString());
if (GlobalVariables.PreviewOR)
{
loReportViewer.crystalReportViewer.ReportSource = loOrderSlipRpt;
loReportViewer.ShowDialog();
}
else
{
try
{
loOrderSlipRpt.PrintOptions.PrinterName = GlobalVariables.PrinterName;
loOrderSlipRpt.PrintToPrinter(0, false, 0, 0);
}
catch { }
}
}
else if (GlobalVariables.ORSize == "Receipt Printed(80mm)")
{
try
{
foreach (DataRow _dr80mm in loPOSTransaction.getPOSTransaction(pPOSTransactionId).Rows)
{
loOrderSlipRpt.Subreports["TransactionDetailListRpt.rpt"].SetDataSource(loPOSTransactionDetail.getPOSTransactionDetails(pPOSTransactionId));
loOrderSlipRpt.SetParameterValue("CompanyName", GlobalVariables.CompanyName.ToUpper());
loOrderSlipRpt.SetParameterValue("CompanyAddress", GlobalVariables.CompanyAddress);
loOrderSlipRpt.SetParameterValue("CompanyContactNumber", GlobalVariables.ContactNumber);
loOrderSlipRpt.SetParameterValue("Date", string.Format("{0:MM-dd-yyyy}", DateTime.Parse(_dr80mm["Date"].ToString())));
loOrderSlipRpt.SetParameterValue("TransactionNo", pPOSTransactionId);
loOrderSlipRpt.SetParameterValue("Customer", _dr["Customer"].ToString());
}
}
catch { }
if (GlobalVariables.PreviewSlip)
{
loReportViewer.crystalReportViewer.ReportSource = loOrderSlipRpt;
loReportViewer.ShowDialog();
}
else
{
try
{
loOrderSlipRpt.PrintOptions.PrinterName = GlobalVariables.PrinterName;
loOrderSlipRpt.PrintToPrinter(0, false, 0, 0);
}
catch { }
}
}
}
}
private void btnClosePeriod_Click(object sender, EventArgs e)
{
try
{
if (!GlobalFunctions.checkRights("tsmCloseCashierPeriod", "Close"))
{
return;
}
string _CashierPeriodId = GlobalVariables.CashierPeriodId;
if (loCashierPeriod.closeCashierPeriod(_CashierPeriodId, GlobalVariables.CashierId,
decimal.Parse(lblTotalSales.Text), decimal.Parse(lblReturnedItemTotal.Text),
decimal.Parse(lblTotalDiscount.Text), decimal.Parse(lblNetSales.Text),
decimal.Parse(lblNonCashSales.Text), decimal.Parse(lblCashSales.Text),
decimal.Parse(lblNetCashSales.Text), decimal.Parse(txtCashCount.Text),
decimal.Parse(lblVariance.Text), txtRemarks.Text))
{
//insert to Accounting entry to Sales Journal
//insertJournalEntry(decimal.Parse(lblNetSales.Text), "POS Sales ("+string.Format("{0:MM-dd-yyyy}",DateTime.Now)+") || Cashier Period Id:"+GlobalVariables.CashierPeriodId);
GlobalVariables.CashierPeriodId = "";
MessageBoxUI _mb = new MessageBoxUI("Cashier period has been close successfully!", GlobalVariables.Icons.Save, GlobalVariables.Buttons.OK);
_mb.showDialog();
this.Close();
foreach (DataRow _dr in loCashierPeriod.getAllData("", _CashierPeriodId, "").Rows)
{
if (GlobalVariables.ORSize == "Plain Continuous-Long")
{
loCashierPeriodSummaryRpt.SetDataSource(GlobalVariables.DTCompanyLogo);
loCashierPeriodSummaryRpt.Subreports["CashierPeriodStockSoldRpt.rpt"].SetDataSource(loCashierPeriod.getCashierPeriodStockSold(_CashierPeriodId));
loCashierPeriodSummaryRpt.Subreports["CashierPeriodReturnedItemRpt.rpt"].SetDataSource(loCashierPeriod.getCashierPeriodReturnedItem(_CashierPeriodId));
//loCashierPeriodSummaryRpt.Database.Tables[1].SetDataSource(loPOSTransactionDetail.getPOSTransactionDetails(pPOSTransactionId));
loCashierPeriodSummaryRpt.SetParameterValue("CompanyName", GlobalVariables.CompanyName);
loCashierPeriodSummaryRpt.SetParameterValue("CompanyAddress", GlobalVariables.CompanyAddress);
loCashierPeriodSummaryRpt.SetParameterValue("CompanyContactNumber", GlobalVariables.ContactNumber);
loCashierPeriodSummaryRpt.SetParameterValue("Username", GlobalVariables.Userfullname);
loCashierPeriodSummaryRpt.SetParameterValue("Title", "Cashier Period Summary");
loCashierPeriodSummaryRpt.SetParameterValue("SubTitle", "Cashier Period Summary");
loCashierPeriodSummaryRpt.SetParameterValue("CashierPeriodNo", _dr["Id"].ToString());
loCashierPeriodSummaryRpt.SetParameterValue("DateOpen", _dr["Date Open"].ToString());
loCashierPeriodSummaryRpt.SetParameterValue("DateClose", _dr["Date Close"].ToString());
loCashierPeriodSummaryRpt.SetParameterValue("PeriodStatus", _dr["Period Status"].ToString());
loCashierPeriodSummaryRpt.SetParameterValue("OpenCashier", _dr["Open Cashier"].ToString());
loCashierPeriodSummaryRpt.SetParameterValue("CloseCashier", _dr["Close Cashier"].ToString());
loCashierPeriodSummaryRpt.SetParameterValue("CashDeposit", string.Format("{0:n}", decimal.Parse(_dr["Cash Deposit"].ToString())));
loCashierPeriodSummaryRpt.SetParameterValue("TotalSales", string.Format("{0:n}", decimal.Parse(_dr["Total Sales"].ToString())));
loCashierPeriodSummaryRpt.SetParameterValue("ReturnedItemTotal", string.Format("{0:n}", decimal.Parse(_dr["Returned Item Total"].ToString())));
loCashierPeriodSummaryRpt.SetParameterValue("TotalDiscount", string.Format("{0:n}", decimal.Parse(_dr["Total Discount"].ToString())));
loCashierPeriodSummaryRpt.SetParameterValue("NetSales", string.Format("{0:n}", decimal.Parse(_dr["Net Sales"].ToString())));
loCashierPeriodSummaryRpt.SetParameterValue("NonCashSales", string.Format("{0:n}", decimal.Parse(_dr["Non-Cash Sales"].ToString())));
loCashierPeriodSummaryRpt.SetParameterValue("CashSales", string.Format("{0:n}", decimal.Parse(_dr["Cash Sales"].ToString())));
loCashierPeriodSummaryRpt.SetParameterValue("NetCashSales", string.Format("{0:n}", decimal.Parse(_dr["Net Cash Sales"].ToString())));
loCashierPeriodSummaryRpt.SetParameterValue("CashCount", string.Format("{0:n}", decimal.Parse(_dr["Cash Count"].ToString())));
loCashierPeriodSummaryRpt.SetParameterValue("Variance", string.Format("{0:n}", decimal.Parse(_dr["Variance"].ToString())));
loCashierPeriodSummaryRpt.SetParameterValue("Remarks", _dr["Remarks"].ToString());
loCashierPeriodSummaryRpt.SetParameterValue("PreparedBy", _dr["Close Cashier"].ToString());
loReportViewer.crystalReportViewer.ReportSource = loCashierPeriodSummaryRpt;
loReportViewer.ShowDialog();
}
else if (GlobalVariables.ORSize == "Receipt Printed(80mm)")
{
loCloseCashierPeriodRpt.Subreports["ItemSoldRpt.rpt"].SetDataSource(loCashierPeriod.getCashierPeriodStockSold(_CashierPeriodId));
loCloseCashierPeriodRpt.Subreports["ItemReturnedRpt.rpt"].SetDataSource(loCashierPeriod.getCashierPeriodReturnedItem(_CashierPeriodId));
loCloseCashierPeriodRpt.SetParameterValue("CompanyName", GlobalVariables.CompanyName.ToUpper());
loCloseCashierPeriodRpt.SetParameterValue("CompanyAddress", GlobalVariables.CompanyAddress);
loCloseCashierPeriodRpt.SetParameterValue("CompanyContactNumber", GlobalVariables.ContactNumber);
loCloseCashierPeriodRpt.SetParameterValue("PeriodNo", _dr["Id"].ToString());
loCloseCashierPeriodRpt.SetParameterValue("Cashier", _dr["Close Cashier"].ToString());
//loCloseCashierPeriodRpt.SetParameterValue("Date", _dr["Date Close"].ToString());
loCloseCashierPeriodRpt.SetParameterValue("DateOpen", _dr["Date Open"].ToString());
loCloseCashierPeriodRpt.SetParameterValue("DateClose", _dr["Date Close"].ToString());
loCloseCashierPeriodRpt.SetParameterValue("CashDeposit", string.Format("{0:n}", decimal.Parse(_dr["Cash Deposit"].ToString())));
loCloseCashierPeriodRpt.SetParameterValue("TotalSales", string.Format("{0:n}", decimal.Parse(_dr["Total Sales"].ToString())));
loCloseCashierPeriodRpt.SetParameterValue("ReturnedItem", "(" + string.Format("{0:n}", decimal.Parse(_dr["Returned Item Total"].ToString())) + ")");
loCloseCashierPeriodRpt.SetParameterValue("TotalDiscount", string.Format("{0:n}", decimal.Parse(_dr["Total Discount"].ToString())));
loCloseCashierPeriodRpt.SetParameterValue("NetSales", string.Format("{0:n}", decimal.Parse(_dr["Net Sales"].ToString())));
loCloseCashierPeriodRpt.SetParameterValue("NonCashSales", string.Format("{0:n}", decimal.Parse(_dr["Non-Cash Sales"].ToString())));
loCloseCashierPeriodRpt.SetParameterValue("CashSales", string.Format("{0:n}", decimal.Parse(_dr["Cash Sales"].ToString())));
loCloseCashierPeriodRpt.SetParameterValue("NetCashSales", string.Format("{0:n}", decimal.Parse(_dr["Net Cash Sales"].ToString())));
loCloseCashierPeriodRpt.SetParameterValue("CashCount", string.Format("{0:n}", decimal.Parse(_dr["Cash Count"].ToString())));
loCloseCashierPeriodRpt.SetParameterValue("Variance", string.Format("{0:n}", decimal.Parse(_dr["Variance"].ToString())));
loCloseCashierPeriodRpt.SetParameterValue("Remarks", _dr["Remarks"].ToString());
if (GlobalVariables.PreviewOR)
{
loReportViewer.crystalReportViewer.ReportSource = loCloseCashierPeriodRpt;
loReportViewer.ShowDialog();
}
else
{
try
{
loCloseCashierPeriodRpt.PrintOptions.PrinterName = GlobalVariables.PrinterName;
loCloseCashierPeriodRpt.PrintToPrinter(0, false, 0, 0);
}
catch { }
}
}
}
}
}
catch { }
}
