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 { } }