public object SourseWiseRegistration(ReportModel model) { try { StringBuilderService builder = new StringBuilderService(); string fromDate = builder.ExtractText(Convert.ToString(model.ReportOption), "fromDate", ","); string toDate = builder.ExtractText(Convert.ToString(model.ReportOption), "toDate", ","); string regStatus = builder.ExtractText(Convert.ToString(model.ReportOption), "regStatus", ","); string status = builder.ExtractText(Convert.ToString(model.ReportOption), "status", ","); string regSource = builder.ExtractText(Convert.ToString(model.ReportOption), "regSource", ","); string branchCode = builder.ExtractText(Convert.ToString(model.ReportOption), "branchCode", "}"); ReportViewer reportViewer = new ReportViewer(); List <SourceWiseRegistration> SourceWiseRegistrationList = new List <SourceWiseRegistration>(); SourceWiseRegistrationList = service.SourceWiseRegistration(fromDate, toDate, regStatus, status, regSource, branchCode); reportViewer.LocalReport.ReportPath = HostingEnvironment.MapPath("~/Reports/RDLC/RPTSourceWiseRegistration.rdlc"); //Request.RequestUri(""); reportViewer.LocalReport.SetParameters(GetReportParameterForSourceWiseRegistration(fromDate, toDate)); ReportDataSource A = new ReportDataSource("SourceWiseRegistration", SourceWiseRegistrationList); reportViewer.LocalReport.DataSources.Add(A); ReportUtility reportUtility = new ReportUtility(); MFSFileManager fileManager = new MFSFileManager(); return(reportUtility.GenerateReport(reportViewer, model.FileType)); } catch (Exception ex) { return(ex.ToString()); } }
public byte[] CustomerRegistration(ReportModel model) { StringBuilderService builder = new StringBuilderService(); string mphone = builder.ExtractText(Convert.ToString(model.ReportOption), "mphone", ","); string fromDate = builder.ExtractText(Convert.ToString(model.ReportOption), "fromDate", ","); string toDate = builder.ExtractText(Convert.ToString(model.ReportOption), "toDate", ","); string agentNo = builder.ExtractText(Convert.ToString(model.ReportOption), "agentNo", "}"); if (!string.IsNullOrEmpty(agentNo)) { var agentInfo = (Reginfo)kycService.GetClientInfoByMphone(agentNo); if (agentInfo.Pmphone != mphone) { return(null); } } List <CustomerRegDistPort> customerRegDistPorts = service.CustomerRegistration(mphone, fromDate, toDate, agentNo); ReportViewer reportViewer = new ReportViewer(); reportViewer.LocalReport.ReportPath = HostingEnvironment.MapPath("~/Reports/RDLC/RPTDist_CustReg.rdlc"); //Request.RequestUri(""); reportViewer.LocalReport.SetParameters(CustomerRegistrationRptParameter(mphone, fromDate, toDate, agentNo)); ReportDataSource A = new ReportDataSource("CustomerRegDistPort", customerRegDistPorts); reportViewer.LocalReport.DataSources.Add(A); ReportUtility reportUtility = new ReportUtility(); MFSFileManager fileManager = new MFSFileManager(); return(reportUtility.GenerateReport(reportViewer, model.FileType)); }
public byte[] EmsReport(ReportModel model) { StringBuilderService builder = new StringBuilderService(); string transNo = builder.ExtractText(Convert.ToString(model.ReportOption), "transNo", ","); string fromDate = builder.ExtractText(Convert.ToString(model.ReportOption), "fromDate", ","); string toDate = builder.ExtractText(Convert.ToString(model.ReportOption), "toDate", ","); string studentId = builder.ExtractText(Convert.ToString(model.ReportOption), "studentId", ","); string branchCode = builder.ExtractText(Convert.ToString(model.ReportOption), "branchCode", "}"); string schoolId = builder.ExtractText(Convert.ToString(model.ReportOption), "schoolId", ","); string dateType = builder.ExtractText(Convert.ToString(model.ReportOption), "dateType", ","); List <EmsReport> emsReports = emsService.GetEmsReport(fromDate, toDate, transNo, studentId, schoolId, branchCode, dateType); ReportViewer reportViewer = new ReportViewer(); reportViewer.LocalReport.ReportPath = HostingEnvironment.MapPath("~/Reports/RDLC/RPTEmsInfo.rdlc"); //Request.RequestUri(""); reportViewer.LocalReport.SetParameters(GetEmsRptParameter(fromDate, toDate, transNo, studentId, schoolId)); ReportDataSource A = new ReportDataSource("EmsReport", emsReports); reportViewer.LocalReport.DataSources.Add(A); ReportUtility reportUtility = new ReportUtility(); MFSFileManager fileManager = new MFSFileManager(); return(reportUtility.GenerateReport(reportViewer, model.FileType)); }
public object KycCommission(ReportModel model) { try { StringBuilderService builder = new StringBuilderService(); string reportName = builder.ExtractText(Convert.ToString(model.ReportOption), "reportName", ","); string regFromDate = builder.ExtractText(Convert.ToString(model.ReportOption), "regFromDate", ","); string regToDate = builder.ExtractText(Convert.ToString(model.ReportOption), "regToDate", ","); string commissionStatus = builder.ExtractText(Convert.ToString(model.ReportOption), "commissionStatus", ","); string authFromDate = builder.ExtractText(Convert.ToString(model.ReportOption), "authFromDate", ","); string authToDate = builder.ExtractText(Convert.ToString(model.ReportOption), "authToDate", ","); string agentNo = builder.ExtractText(Convert.ToString(model.ReportOption), "agentNo", "}"); string distributorNo = builder.ExtractText(Convert.ToString(model.ReportOption), "distributorNo", ","); string transNo = builder.ExtractText(Convert.ToString(model.ReportOption), "transNo", ","); ReportViewer reportViewer = new ReportViewer(); List <KycCommission> kycCommissions = new List <KycCommission>(); kycCommissions = service.GetRptkycCommissionsList(reportName, regFromDate, regToDate, commissionStatus, authFromDate, authToDate, distributorNo, agentNo, transNo); reportViewer.LocalReport.ReportPath = HostingEnvironment.MapPath("~/Reports/RDLC/RPTKycCom.rdlc"); reportViewer.LocalReport.SetParameters(GenerateParamKycCom(regFromDate, regToDate, reportName)); ReportDataSource A = new ReportDataSource("KycCommission", kycCommissions); reportViewer.LocalReport.DataSources.Add(A); ReportUtility reportUtility = new ReportUtility(); MFSFileManager fileManager = new MFSFileManager(); return(reportUtility.GenerateReport(reportViewer, model.FileType)); } catch (Exception ex) { return(ex.ToString()); } }
public object MerchantBankInfo(ReportModel model) { try { StringBuilderService builder = new StringBuilderService(); string fromDate = builder.ExtractText(Convert.ToString(model.ReportOption), "fromDate", ","); string toDate = builder.ExtractText(Convert.ToString(model.ReportOption), "toDate", ","); string accNo = builder.ExtractText(Convert.ToString(model.ReportOption), "accNo", ","); string catId = builder.ExtractText(Convert.ToString(model.ReportOption), "catId", "}"); ReportViewer reportViewer = new ReportViewer(); List <MerchantBankInfo> merchantBankInfos = new List <MerchantBankInfo>(); merchantBankInfos = service.MerchantBankInfoReport(fromDate, toDate, accNo, catId); reportViewer.LocalReport.ReportPath = HostingEnvironment.MapPath("~/Reports/RDLC/RPTMerchantBankInfo.rdlc"); //Request.RequestUri(""); reportViewer.LocalReport.SetParameters(GetReportParameterForChannelBankInfoReport(fromDate, toDate, catId)); ReportDataSource A = new ReportDataSource("MerchantBank", merchantBankInfos); reportViewer.LocalReport.DataSources.Add(A); ReportUtility reportUtility = new ReportUtility(); MFSFileManager fileManager = new MFSFileManager(); return(reportUtility.GenerateReport(reportViewer, model.FileType)); } catch (Exception ex) { return(ex.ToString()); } }
//public ICommand PrintSummaryCommandView //{ // get { return _printListCommandView ?? (_printListCommandView = new RelayCommand<Object>(PrintList)); } //} //public void PrintList(object obj) //{ // var myReport4 = new PinnaFit.WPF.Reports.Summary.NumberSummay(); // myReport4.SetDataSource(GetNumberListDataSet()); // //MenuItem menu = obj as MenuItem; // //if (menu != null) // // new ReportUtility().DirectPrinter(myReport4); // //else // //{ // var report = new ReportViewerCommon(myReport4); // report.Show(); // //} //} //public FitnessDataSet GetNumberListDataSet() //{ // var myDataSet = new FitnessDataSet(); // var serNo = 1; // var selectedCompany = new CompanyService(true).GetCompany(); // MemberSubscriptionListForNumberSummary = MemberSubscriptionListForNumberSummary.Where(m => !m.IsExpired).ToList(); // #region Group By Facility // var querFacility = from memberSubscriptionList in MemberSubscriptionListForNumberSummary // group memberSubscriptionList by memberSubscriptionList.FacilityName // into newGroup // orderby newGroup.Key // select newGroup; // MemberCategorySubList = querFacility.Select(nameGroup => new SubscriptionSumModel // { // Category = nameGroup.Key, // SubscriptionModels = nameGroup // }).ToList(); // foreach (var subscriptionSumModel in MemberCategorySubList) // { // string cat = subscriptionSumModel.Category; // var subModels = subscriptionSumModel.SubscriptionModels; // var querSubscription = from memberSubscriptionList in subModels // group memberSubscriptionList by memberSubscriptionList.SubscriptionName // into newGroup // orderby newGroup.Key // select newGroup; // var memberCategorySubList2 = querSubscription.Select(nameGroup => new SubscriptionSumModel // { // Category = nameGroup.Key, // SubscriptionModels = nameGroup // }).ToList(); // int permonth = 0, threemonth = 0, sixmonth = 0, oneyear = 0; // var firstOrDefault = memberCategorySubList2.FirstOrDefault(a => a.Category == "Per Month"); // if (firstOrDefault != null) // { // permonth = firstOrDefault.TotalNumber; // } // firstOrDefault = memberCategorySubList2.FirstOrDefault(a => a.Category == "3 Months"); // if (firstOrDefault != null) // { // threemonth = firstOrDefault.TotalNumber; // } // firstOrDefault = memberCategorySubList2.FirstOrDefault(a => a.Category == "6 Months"); // if (firstOrDefault != null) // { // sixmonth = firstOrDefault.TotalNumber; // } // firstOrDefault = memberCategorySubList2.FirstOrDefault(a => a.Category == "1 Year"); // if (firstOrDefault != null) // { // oneyear = firstOrDefault.TotalNumber; // } // var tot = oneyear + permonth + threemonth + sixmonth; // myDataSet.SummaryReport.Rows.Add( // serNo, // ReportUtility.GetEthCalendarFormated(DateTime.Now, "-") + "(" + // DateTime.Now.ToShortDateString() + ")", // cat, // 0, // permonth, // threemonth, // sixmonth, // oneyear, // tot, // "", // "", // 0, 0, selectedCompany.Header, ""); // serNo++; // } // #endregion // return myDataSet; //} //public ICommand PrintDailySummaryCommandView //{ // get { return _printDailySummaryCommandView ?? (_printDailySummaryCommandView = new RelayCommand<Object>(PrintDailySummaryList)); } //} //public void PrintDailySummaryList(object obj) //{ // var myReport4 = new Reports.Summary.DailySummay(); // var dSet = GetSummaryDataSet(); // if (dSet == null) // return; // myReport4.SetDataSource(dSet); // var report = new ReportViewerCommon(myReport4); // report.Show(); //} //public FitnessDataSet GetSummaryDataSet() //{ // try // { // var selectDate = SelectedEthioDay.Value + "/" + SelectedEthioMonth.Value + "/" + SelectedEthioYear.Display; // var selectedDate = ReportUtility.GetGregorCalendar(SelectedEthioYear.Value, SelectedEthioMonth.Value, // SelectedEthioDay.Value); // var myDataSet = new FitnessDataSet(); // var serNo = 1; // var selectedCompany = new CompanyService(true).GetCompany(); // var MemberSubsList = MemberSubscriptionList.Where( // m => m.TransactionDate.Day == selectedDate.Day && // m.TransactionDate.Month == selectedDate.Month && // m.TransactionDate.Year == selectedDate.Year).ToList(); // if (MemberSubsList.Count == 0) // { // MessageBox.Show("No Data found on: " + Environment.NewLine + selectDate + "(" + // selectedDate.ToShortDateString() + ")" + "(" + SelectedShiftType.Display + ")", "No Data", // MessageBoxButtons.OK, MessageBoxIcon.Error); // return null; // } // #region Group By Facility // var querFacility = from memberSubscriptionList in MemberSubsList // group memberSubscriptionList by memberSubscriptionList.PackageName // into newGroup // orderby newGroup.Key // select newGroup; // MemberCategorySubList = querFacility.Select(nameGroup => new SubscriptionSumModel // { // Category = nameGroup.Key, // SubscriptionModels = nameGroup // }).ToList(); // foreach (var subscriptionSumModel in MemberCategorySubList) // { // var subtototal = subscriptionSumModel.TotalAmount / (decimal)1.15; // var tax = subtototal * (decimal)0.15; // myDataSet.DailySummaryReport.Rows.Add( // serNo, // ReportUtility.GetEthCalendarFormated(selectedDate, "-") + "(" + // selectedDate.ToShortDateString() + ") - (" + SelectedShiftType.Display + ")", // subscriptionSumModel.Category, // subscriptionSumModel.TotalUnit, // subtototal, // tax, // subscriptionSumModel.TotalAmount, // "", // "", // 0, 0, selectedCompany.Header, ""); // serNo++; // } // #endregion // return myDataSet; // } // catch // { // return null; // } //} #endregion #region Filter List public void FillCalendar() { #region Initialize _ethioDays = new ObservableCollection <ListDataItem>(); _ethioMonths = new ObservableCollection <ListDataItem>(); _ethioYears = new ObservableCollection <ListDataItem>(); _selectedEthioDay = new ListDataItem(); _selectedEthioMonth = new ListDataItem(); _selectedEthioYear = new ListDataItem(); #endregion for (var i = 1; i <= 30; i++) { EthioDays.Add(new ListDataItem { Display = i.ToString(), Value = i }); } for (var i = 1; i <= 12; i++) { EthioMonths.Add(new ListDataItem { Display = ReportUtility.GetAmhMonth(i - 1), Value = i }); } EthioMonths.Add(new ListDataItem { Display = ReportUtility.GetAmhMonth(12), Value = 13 }); for (var i = 2008; i <= 2020; i++) { EthioYears.Add(new ListDataItem { Display = i.ToString(), Value = i }); } }
public object DormantAgent(ReportModel model) { try { StringBuilderService builder = new StringBuilderService(); string type = builder.ExtractText(Convert.ToString(model.ReportOption), "type", ","); string fromDate = builder.ExtractText(Convert.ToString(model.ReportOption), "fromDate", ","); string toDate = builder.ExtractText(Convert.ToString(model.ReportOption), "toDate", "}"); ReportViewer reportViewer = new ReportViewer(); List <DormantAgent> dormantAgentList = new List <DormantAgent>(); dormantAgentList = service.GetDormantAgentList(fromDate, toDate, type); reportViewer.LocalReport.ReportPath = HostingEnvironment.MapPath("~/Reports/RDLC/RPTDormantAgent.rdlc"); //Request.RequestUri(""); reportViewer.LocalReport.SetParameters(GenerateParamEmerchantSettlementInfo(fromDate, toDate)); ReportDataSource A = new ReportDataSource("DormantAgent", dormantAgentList); reportViewer.LocalReport.DataSources.Add(A); ReportUtility reportUtility = new ReportUtility(); MFSFileManager fileManager = new MFSFileManager(); return(reportUtility.GenerateReport(reportViewer, model.FileType)); } catch (Exception ex) { return(ex.ToString()); } }
protected override void OnUnload(EventArgs e) { base.OnUnload(e); m_Registration.Dispose(); m_Registration = null; m_ReportUtil = null; }
public MainViewModel() { CheckRoles(); TitleText = "PinnaStock, Stock Management System (" + Singleton.User.UserName + ") - " + DateTime.Now.ToString("dd/MM/yyyy") + " (" + ReportUtility.getEthCalendarFormated(DateTime.Now, "-") + ") - " + new ProductActivationDTO().BiosSn; if (UserRoles.OnHandInventory == "Visible") { HeaderText = "OnHand Inventories"; OnHandInventoryViewModel.LoadData = true; CurrentViewModel = OnHandInventoryViewModel; } else if (UserRoles.Sales == "Visible") { HeaderText = "Sales Management"; TransactionsViewModel.TransactionType = TransactionTypes.Sale; CurrentViewModel = TransactionsViewModel; } DashBoardViewCommand = new RelayCommand(ExecuteDashBoardViewCommand); PhysicalInventoryViewCommand = new RelayCommand(ExecutePhysicalInventoriesViewCommand); ItemsMovementViewCommand = new RelayCommand(ItemsMovementsViewCommand); OnHandInventoryViewCommand = new RelayCommand(ExecuteOnHandInventoriesViewCommand); SalesViewCommand = new RelayCommand(ExecuteSalesViewCommand); PurchasesViewCommand = new RelayCommand(ExecutePurchasesViewCommand); }
public object CommissionReport(ReportModel model) { try { StringBuilderService builder = new StringBuilderService(); string mphone = builder.ExtractText(Convert.ToString(model.ReportOption), "mphone", "}"); string fromDate = builder.ExtractText(Convert.ToString(model.ReportOption), "fromDate", ","); string toDate = builder.ExtractText(Convert.ToString(model.ReportOption), "toDate", ","); ReportViewer reportViewer = new ReportViewer(); List <CommissionReport> commissionReports = new List <CommissionReport>(); commissionReports = service.CommissionReport(mphone, fromDate, toDate); reportViewer.LocalReport.ReportPath = HostingEnvironment.MapPath("~/Reports/RDLC/RPTCommssion.rdlc"); //Request.RequestUri(""); reportViewer.LocalReport.SetParameters(GetGenerateCommissionReportParameter(fromDate, toDate, mphone)); ReportDataSource A = new ReportDataSource("Commission", commissionReports); reportViewer.LocalReport.DataSources.Add(A); ReportUtility reportUtility = new ReportUtility(); MFSFileManager fileManager = new MFSFileManager(); return(reportUtility.GenerateReport(reportViewer, model.FileType)); } catch (Exception ex) { return(ex.ToString()); } }
public byte[] LankaBanglaDpsPaymentDetails(ReportModel model) { StringBuilderService builder = new StringBuilderService(); string fromDate = builder.ExtractText(Convert.ToString(model.ReportOption), "fromDate", ","); string toDate = builder.ExtractText(Convert.ToString(model.ReportOption), "toDate", "}"); List <LankaBangla> dpsDeilsReports = service.GetDpsDetailsInfo(fromDate, toDate); ReportViewer reportViewer = new ReportViewer(); if (model.FileType == "EXCEL") { reportViewer.LocalReport.ReportPath = HostingEnvironment.MapPath("~/Reports/RDLC/RPT_Lb_Dps_Dtl_Excel.rdlc"); //Request.RequestUri(""); } else { reportViewer.LocalReport.ReportPath = HostingEnvironment.MapPath("~/Reports/RDLC/RPT_Lb_Dps_Dtl.rdlc"); //Request.RequestUri(""); } reportViewer.LocalReport.SetParameters(GetDpsDetailsInfoRptParameter(fromDate, toDate)); ReportDataSource A = new ReportDataSource("LankaBangla", dpsDeilsReports); reportViewer.LocalReport.DataSources.Add(A); ReportUtility reportUtility = new ReportUtility(); MFSFileManager fileManager = new MFSFileManager(); return(reportUtility.GenerateReport(reportViewer, model.FileType)); }
public object CashBackReport(ReportModel model) { try { StringBuilderService builder = new StringBuilderService(); string mphone = builder.ExtractText(Convert.ToString(model.ReportOption), "mphone", ","); string fromDate = builder.ExtractText(Convert.ToString(model.ReportOption), "fromDate", ","); string toDate = builder.ExtractText(Convert.ToString(model.ReportOption), "toDate", ","); string options = builder.ExtractText(Convert.ToString(model.ReportOption), "reportType", ","); string cbType = builder.ExtractText(Convert.ToString(model.ReportOption), "cbType", "}"); ReportViewer reportViewer = new ReportViewer(); List <CashBackReport> cashBackReports = new List <CashBackReport>(); if (options == "dtl") { cashBackReports = service.CashBackDetails(mphone, fromDate, toDate, cbType); reportViewer.LocalReport.ReportPath = HostingEnvironment.MapPath("~/Reports/RDLC/RPTCashBackDtl.rdlc"); //Request.RequestUri(""); } if (options == "sum") { cashBackReports = service.CashBackSummaryReport(mphone, fromDate, toDate, cbType); reportViewer.LocalReport.ReportPath = HostingEnvironment.MapPath("~/Reports/RDLC/RPTCashBackSum.rdlc"); //Request.RequestUri(""); } reportViewer.LocalReport.SetParameters(GetGenerateCashBackParameter(fromDate, toDate, cbType)); ReportDataSource A = new ReportDataSource("CashBack", cashBackReports); reportViewer.LocalReport.DataSources.Add(A); ReportUtility reportUtility = new ReportUtility(); MFSFileManager fileManager = new MFSFileManager(); return(reportUtility.GenerateReport(reportViewer, model.FileType)); } catch (Exception ex) { return(ex.ToString()); } }
public ActionResult PayerMapping(long?nodeId, int reportType, string currentDateTime) { string fileName = string.Empty; ContractPayerMapReport contractPayerMapReport = new ContractPayerMapReport { NodeId = nodeId, ReportType = Constants.PayerMapping[reportType], CommandTimeoutForModelingReport = Convert.ToInt32(GlobalConfigVariable.CommandTimeout), LoggedInUser = GetLoggedInUserName() }; var mappedReport = PostApiResponse <ContractPayerMapReport>(Constants.ContractPayerMapReport, Convert.ToString(Enums.Action.Get), contractPayerMapReport); var payerMapReportViewModel = AutoMapper.Mapper.Map <ContractPayerMapReport, ContractPayerMapReportViewModel>(mappedReport); payerMapReportViewModel.NodeId = nodeId; payerMapReportViewModel.LoggedInUser = GetCurrentUserName(); // Gets local timeZone string. payerMapReportViewModel.CurrentDateTime = Utilities.GetLocalTimeString(currentDateTime); if (payerMapReportViewModel.ContractPayerMapReportViewModels != null && payerMapReportViewModel.ContractPayerMapReportViewModels.Count > 0) { fileName = ReportUtility.CreateFileUsingTelerik(new PayerMapping(payerMapReportViewModel), Enums.DownloadFileType.Pdf, GlobalConfigVariable.ReportsFilePath, Constants.PayerMappingReportFileBaseName, currentDateTime); } return(Json(fileName)); }
public ActionResult NegativeDetail(int issueId) { ViewBag.Tab = "history"; ViewBag.Submenu = 1; var issue = ReportUtility.GetNegativeIssue(issueId); return(View(issue)); }
/// <summary> /// Download the report for a requested format /// </summary> /// <param name="reportFileName">Holds report file name</param> /// <param name="currentDateTime"></param> /// <returns>files result. is used to download the file</returns> public ActionResult DownloadReport(string reportFileName, string currentDateTime) { string fileName; string contentType; string filePath = ReportUtility.GetReportFileDetailsToDownload(Constants.ClaimVarianceReportFileBaseName, reportFileName, out fileName, Enums.DownloadFileType.Csv, out contentType, currentDateTime); return(File(filePath, contentType, fileName)); }
private void Print() { LoadDeposits(); var myDataSet = new ReportDataSet(); var serNo = 1; var selectedCompany = new CompanyService(true).GetCompany(); string datecaption = ReportUtility.GetEthCalendar(FilterStartDate, true) + "(" + FilterStartDate.ToShortDateString() + ")"; if (FilterStartDate.Day != FilterEndDate.Day || FilterStartDate.Month != FilterEndDate.Month || FilterStartDate.Year != FilterEndDate.Year) { datecaption = "ከ " + datecaption + " እስከ " + ReportUtility.GetEthCalendar(FilterEndDate, true) + "(" + FilterEndDate.ToShortDateString() + ")"; } var returned = ""; if (SelectedCpoType.Value != 1) { returned = "የተመለሰበት ቀን"; } foreach (var rentalPaymentDTO in RentDeposits) { var rentee = rentalPaymentDTO.Contrat.Rentee.DisplayName; if (rentee.Length > 20) { rentee = rentee.Substring(0, 18) + "..."; } myDataSet.RentalPayment.Rows.Add( serNo, SelectedCpoType.Display, datecaption, rentalPaymentDTO.DepositedDateStringAmharicFormatted, rentalPaymentDTO.Contrat.Room.Number, rentee, "", 0.0, 0.0, 0.0, 0.0, 0.0, rentalPaymentDTO.TotalDepositAmount, rentalPaymentDTO.ReturnedDateStringAmharicFormatted, 0, 0.0, returned, "", "", "", selectedCompany.Header, null, ""); serNo++; } var myReport4 = new DepositList(); myReport4.SetDataSource(myDataSet); var report = new ReportViewerCommon(myReport4); report.Show(); }
public string GetEquipmentNumber(int equipmentId) { var pref = equipmentId.ToString(); if (equipmentId < 1000) { var id = equipmentId + 110000; pref = id.ToString(); //pref = pref.Substring(1); } var amhCalender = ReportUtility.GetEthCalendar(DateTime.Now, false); return(pref + amhCalender.Substring(6)); }
public string GetBusinessPartnerNumber(int businessPartnerId) { var pref = businessPartnerId.ToString(); if (businessPartnerId < 1000) { var id = businessPartnerId + 10000; pref = id.ToString(); pref = pref.Substring(1); } var amhCalender = ReportUtility.GetEthCalendar(DateTime.Now, false); return("DFT/" + pref + "/" + amhCalender.Substring(6)); }
public string GetRentalPaymentNumber(int rentalPaymentId) { var pref = rentalPaymentId.ToString(); if (rentalPaymentId < 1000) { var id = rentalPaymentId + 10000; pref = id.ToString(); pref = pref.Substring(1); } var amhCalender = ReportUtility.GetEthCalendar(DateTime.Now, false); return("DRN/" + pref + "/" + amhCalender.Substring(6)); }
public MainViewModel() { CheckRoles(); TitleText = "PDMAS V1.0.0.0, PDEX Delivery Management System - " + Singleton.User.UserName + " - " + DateTime.Now.ToString("dd/MM/yyyy") + " - " + ReportUtility.GetEthCalendarFormated(DateTime.Now, "/"); HeaderText = "Request Managment"; DeliveryViewModel.LoadData = true; CurrentViewModel = DeliveryViewModel; DeliveryViewModelViewCommand = new RelayCommand(ExecuteDeliveryViewModelViewCommand); FollowUpViewModelViewCommand = new RelayCommand(ExecuteFollowUpViewModelViewCommand); }
void PrintBOM() { // bool BOMWorkspaceExist = false; SalesOrder salesorder = new SalesOrder(); List <SalesOrder> salesOrdersList = salesorder.GetAllSalesOrders(); if (salesOrdersList.Count > 0) { ReportViewerUI repWindow = new ReportViewerUI(); BOMReport soReport = new BOMReport(); ReportUtility.Display_report(soReport, salesOrdersList, repWindow); } }
public object BranchWiseCount(ReportModel model) { try { StringBuilderService builder = new StringBuilderService(); string branchCode = builder.ExtractText(Convert.ToString(model.ReportOption), "branchCode", ","); string userId = builder.ExtractText(Convert.ToString(model.ReportOption), "userId", ","); string option = builder.ExtractText(Convert.ToString(model.ReportOption), "option", ","); string fromDate = builder.ExtractText(Convert.ToString(model.ReportOption), "fromDate", ","); string toDate = builder.ExtractText(Convert.ToString(model.ReportOption), "toDate", "}"); if (branchCode == "null") { branchCode = null; } if (userId == "null") { userId = null; } if (fromDate == "null") { fromDate = DateTime.Now.AddYears(-99).ToString("yyyy/MM/dd"); } if (toDate == "null") { toDate = DateTime.Now.ToString("yyyy/MM/dd"); } ReportViewer reportViewer = new ReportViewer(); List <BranchWiseCount> BranchWiseCountList = new List <BranchWiseCount>(); BranchWiseCountList = service.BranchWiseCount(branchCode, userId, option, fromDate, toDate); reportViewer.LocalReport.ReportPath = HostingEnvironment.MapPath("~/Reports/RDLC/RPTBranchWiseCount.rdlc"); //Request.RequestUri(""); reportViewer.LocalReport.SetParameters(GetReportParameterForSourceWiseRegistration(fromDate, toDate)); ReportDataSource A = new ReportDataSource("BranchWiseCount", BranchWiseCountList); reportViewer.LocalReport.DataSources.Add(A); ReportUtility reportUtility = new ReportUtility(); MFSFileManager fileManager = new MFSFileManager(); return(reportUtility.GenerateReport(reportViewer, model.FileType)); } catch (Exception ex) { return(ex.ToString()); } }
public void SetEthioValues() { try { var gregorDayFrom = new DateTime(SelectedGregorYear.Value, SelectedGregorMonth.Value, SelectedGregorDay.Value); var ethioDayFrom = ReportUtility.getEthCalendar(gregorDayFrom, false); int dayf = Convert.ToInt32(ethioDayFrom.Substring(0, 2)), monthf = Convert.ToInt32(ethioDayFrom.Substring(2, 2)), yearf = Convert.ToInt32(ethioDayFrom.Substring(4, 4)); SelectedEthioDay = EthioDays[dayf - 1]; SelectedEthioMonth = EthioMonths[monthf - 1]; SelectedEthioYear = EthioYears[yearf - 2000]; } catch { //MessageBox.Show("Can't convert, may be out side of the scope!"); } }
public byte[] GetAgentDsrListByPmphone(ReportModel model) { StringBuilderService builder = new StringBuilderService(); string mphone = builder.ExtractText(Convert.ToString(model.ReportOption), "mphone", "}"); List <AgentDsrList> registrationReports = service.GetAgentDsrListByPmphone(mphone); ReportViewer reportViewer = new ReportViewer(); reportViewer.LocalReport.ReportPath = HostingEnvironment.MapPath("~/Reports/RDLC/RPTAgentDsr.rdlc"); //Request.RequestUri(""); reportViewer.LocalReport.SetParameters(GetAgentDsrListByPmphoneRptParameter(mphone)); ReportDataSource A = new ReportDataSource("AgentDsrList", registrationReports); reportViewer.LocalReport.DataSources.Add(A); ReportUtility reportUtility = new ReportUtility(); MFSFileManager fileManager = new MFSFileManager(); return(reportUtility.GenerateReport(reportViewer, model.FileType)); }
public void SetGregorValues() { try { //var ethioDayFrom = new DateTime(SelectedEthioYear.Value, SelectedEthioMonth.Value, SelectedEthioDay.Value); //var ethioDayTo = new DateTime(SelectedEthioYearTo.Value, SelectedEthioMonthTo.Value, SelectedEthioDayTo.Value); var gregorDayFrom = ReportUtility.getGregorCalendar(SelectedEthioYear.Value, SelectedEthioMonth.Value, SelectedEthioDay.Value); int dayf = Convert.ToInt32(gregorDayFrom.Day), monthf = Convert.ToInt32(gregorDayFrom.Month), yearf = Convert.ToInt32(gregorDayFrom.Year); SelectedGregorDay = GregorDays[dayf - 1]; SelectedGregorMonth = GregorMonths[monthf - 1]; SelectedGregorYear = GregorYears[yearf - 2010]; } catch { //MessageBox.Show("Can't convert, may be out side of the scope!"); } }
public object OutletSumTransReportByTranDate(ReportModel model) { try { StringBuilderService builder = new StringBuilderService(); string mphone = builder.ExtractText(Convert.ToString(model.ReportOption), "mphone", ","); string fromDate = builder.ExtractText(Convert.ToString(model.ReportOption), "fromDate", ","); string toDate = builder.ExtractText(Convert.ToString(model.ReportOption), "toDate", ","); string dateType = builder.ExtractText(Convert.ToString(model.ReportOption), "dateType", "}"); var clientInfo = (Reginfo)kycService.GetClientInfoByMphone(mphone); if (clientInfo.CatId != "M") { return("NOTM"); } double totalTransAmt = 0; double totalTransCount = 0; List <MerchantTransactionSummary> merchantTransactionList = new List <MerchantTransactionSummary>(); merchantTransactionList = childMerchantService.ChainMerTransSummReportByTd(mphone, fromDate, toDate).ToList(); if (merchantTransactionList.Count() > 0) { totalTransCount = merchantTransactionList.Count(); totalTransAmt = merchantTransactionList.Sum(x => x.TransAmt); } ReportViewer reportViewer = new ReportViewer(); reportViewer.LocalReport.ReportPath = HostingEnvironment.MapPath("~/Reports/RDLC/RPTChainMerTranSumByTd.rdlc"); reportViewer.LocalReport.SetParameters(GetReportParameterMerchantSummary(mphone, fromDate, toDate, merchantTransactionList.Count() > 1 ? merchantTransactionList[1].MerchantCode : null, merchantTransactionList.Count() > 1 ? merchantTransactionList[1].MerchantName : null, totalTransCount, totalTransAmt)); ReportDataSource A = new ReportDataSource("MerchantTransferSummary", merchantTransactionList); reportViewer.LocalReport.DataSources.Add(A); ReportUtility reportUtility = new ReportUtility(); MFSFileManager fileManager = new MFSFileManager(); return(reportUtility.GenerateReport(reportViewer, model.FileType)); } catch (Exception ex) { throw; } }
public object RegistrationReportSummary(ReportModel model) { StringBuilderService builder = new StringBuilderService(); string fromDate = builder.ExtractText(Convert.ToString(model.ReportOption), "fromDate", ","); string toDate = builder.ExtractText(Convert.ToString(model.ReportOption), "toDate", ","); string options = builder.ExtractText(Convert.ToString(model.ReportOption), "options", "}"); List <RegistrationSummary> registrationReports = service.GetRegistrationReportSummary(fromDate, toDate, options); ReportViewer reportViewer = new ReportViewer(); reportViewer.LocalReport.ReportPath = HostingEnvironment.MapPath("~/Reports/RDLC/RPTRegistrationSummary.rdlc"); //Request.RequestUri(""); reportViewer.LocalReport.SetParameters(GetRegistrationRptParameter(fromDate, toDate, options)); ReportDataSource A = new ReportDataSource("RegistrationSummary", registrationReports); reportViewer.LocalReport.DataSources.Add(A); ReportUtility reportUtility = new ReportUtility(); MFSFileManager fileManager = new MFSFileManager(); return(reportUtility.GenerateReport(reportViewer, model.FileType)); }
public MainViewModel() { CheckRoles(); TitleText = "PinnaFit V1.0.0.1, Gym and Fitness Management System - " + Singleton.User.UserName + " - " + DateTime.Now.ToString("dd/MM/yyyy") + " - " + ReportUtility.GetEthCalendarFormated(DateTime.Now, "/"); if (UserRoles.DashboardMgmt == "Visible") { HeaderText = "Dashboard"; CurrentViewModel = DashBoardViewModel; } else { HeaderText = "ስራዎች ማስተዳደሪያ"; CurrentViewModel = AttendanceListViewModel; } DeliveryViewModelViewCommand = new RelayCommand(ExecuteDeliveryViewModelViewCommand); FollowUpViewModelViewCommand = new RelayCommand(ExecuteFollowUpViewModelViewCommand); }
private void bootstrapButton1_Click(object sender, EventArgs e) { var data = gridControl1.DataSource as IList <QuotationDetail>; if (data == null || data.Count < 1) { return; } var data2 = new List <QuotationDetail>(data); var data1 = data[0]; for (int i = 0; i < 10; i++) { data2.Add(data1); } Report.Reportmain report = new Report.Reportmain(); IReportUtility ireprot = new ReportUtility(report); ireprot.Binding(report.bindingSource1, data2); ireprot.ShowPreview(); }
private void ExecutePrintCommand() { var myReport4 = new Reports.Summary.DailyActivity(); var myDataSet = new FitnessDataSet(); var selectedCompany = new CompanyService(true).GetCompany(); var selectedDate = DateTime.Now; int serNo = 1; string shift = EnumUtil.GetEnumDesc(ShiftTypes.Morning); if (selectedDate.Hour > 14) { shift = EnumUtil.GetEnumDesc(ShiftTypes.Afternoon); } foreach (var itemQuantityDto in ItemsQuantity) { myDataSet.DailySummaryReport.Rows.Add( serNo, ReportUtility.GetEthCalendarFormated(selectedDate, "-") + "(" + selectedDate.ToShortDateString() + ") - (" + shift + ")", itemQuantityDto.Item.DisplayName, itemQuantityDto.QuantityOnHand, null, null, null, itemQuantityDto.Item.UnitOfMeasure.DisplayName, "", null, null, selectedCompany.Header, SelectedWarehouse.DisplayName); serNo++; } myReport4.SetDataSource(myDataSet); new ReportUtil().DirectPrinter(myReport4); //var report = new ReportViewerCommon(myReport4); //report.Show(); }