public FitnessDataSet GetListDataSet() { var myDataSet = new FitnessDataSet(); var brCode = new BarcodeProcess(); var memberNumberbarcode = ImageToByteArray(brCode.GetBarcode(SelectedMember.Number.ToString(), 1200, 40, false), ImageFormat.Bmp); //ImageToByteArray(brCode.GetBarcode(SelectedMember.Id.ToString() + "11850908", 1200, 40, false), // ImageFormat.Bmp); var memberPhoto = new AttachmentService(true).Find(SelectedMember.PhotoId.ToString()) ?? new AttachmentDTO(); var memberSub = MemberSubscriptionDetail.FirstOrDefault(); //if (SelectedMember.LastSubscription != null) myDataSet.MemberDetail.Rows.Add( SelectedMember.DisplayName, memberPhoto.AttachedFile, SelectedMember.Number, memberNumberbarcode, SelectedMember.SexAmharic, SelectedMember.Address.AddressDetail, "", "", "", "", SelectedMember.Address.Mobile, "", "", "", "", memberSub != null ? memberSub.StartDateStringAndAmharic : null, memberSub != null ? memberSub.EndDateStringAndAmharic : null, memberSub != null ? memberSub.FacilitySubscription.PackageName : null, ""); //SelectedMember.LastSubscription.SubscribedDateStringAndAmharic, // SelectedMember.LastSubscription.EndDateString, // SelectedMember.LastSubscription.FacilitySubscription.PackageName, return(myDataSet); }
public TransactionDataSet GetListDataSet2() { var myDataSet = new TransactionDataSet(); var selectedCompany = new CompanyService(true).GetCompany(); var SelectedTransaction = SelectedMember.LastSubscription; try { #region Fields var brCode = new BarcodeProcess(); var tranNumberbarcode = ImageToByteArray(brCode.GetBarcode(SelectedTransaction.SubscriptionNumber, 320, 40, true), ImageFormat.Bmp); var subTotal = SelectedTransaction.AmountPaid / (decimal)1.15; var tax = Convert.ToDecimal((subTotal * ((decimal)0.15)).ToString("N2")); string reciptNo = SelectedTransaction.ReceiptNumber, prefix = ""; int recLen = 10 - reciptNo.Length; while (recLen != 0) { prefix = prefix + "0"; recLen--; } reciptNo = prefix + reciptNo; #endregion #region Header myDataSet.TransactionHeader.Rows.Add( reciptNo, tranNumberbarcode, SelectedMember.TinNumber, SelectedMember.DisplayName, SelectedMember.Number, SelectedMember.SexAmharic, SelectedTransaction.SubscribedDateString + "(" + ReportUtility.GetEthCalendarFormated(SelectedTransaction.SubscribedDate, "/") + ")", "", subTotal, "VAT (" + 15 + "%)", tax, subTotal + tax, "linknumber1" ); #endregion #region Client Address myDataSet.ClientDetail.Rows.Add( selectedCompany.Header, selectedCompany.Footer, selectedCompany.Address.AddressDetail, selectedCompany.Address.SubCity, selectedCompany.Address.Kebele, selectedCompany.Address.HouseNumber, selectedCompany.Address.Mobile, selectedCompany.Address.AlternateMobile, selectedCompany.Address.Fax, selectedCompany.Address.PrimaryEmail, selectedCompany.Address.AlternateEmail, selectedCompany.TinNumber, selectedCompany.VatNumber, "CASH", "CASH", Singleton.User.FullName.ToUpper(), "linknumber1"); #endregion #region BPAddress myDataSet.BPAddress.Rows.Add( SelectedMember.Address.AddressDetail, SelectedMember.Address.SubCity, SelectedMember.Address.Kebele, SelectedMember.Address.HouseNumber, SelectedMember.Address.Mobile, SelectedMember.Address.AlternateMobile, SelectedMember.Address.Fax, SelectedMember.Address.PrimaryEmail, SelectedMember.Address.AlternateEmail, "linknumber1"); #endregion #region Lines myDataSet.TransactionLine.Rows.Add( "1", "00" + SelectedTransaction.FacilitySubscription.Facility.Id.ToString(), SelectedTransaction.FacilitySubscription.PackageName, "", "Gym", "Pcs", subTotal, 1, subTotal, 0, "linknumber1"); #endregion } catch (Exception exception) { MessageBox.Show("Can't get data for the report" + Environment.NewLine + exception.Message, "Can't get data", MessageBoxButton.OK, MessageBoxImage.Error); } return(myDataSet); }
public DeliveryDataSet GetListDataSet() { var myDataSet = new DeliveryDataSet(); var brCode = new BarcodeProcess(); try { var company = new CompanyService(true).GetCompany(); var lines = new DeliveryService().GetChilds(SelectedDelivery.Id, true) .Where(d => d.DeliveryType == DeliveryLineRouteTypes.Delivering).ToList(); foreach (var deliveryLineDTO in lines) { var orderNum = "" + SelectedDelivery.Number.Substring(1) + "_" + deliveryLineDTO.Number.Substring(1); var linkno = deliveryLineDTO.Id; var deliverybarcode = ImageToByteArray(brCode.GetBarcode(orderNum, 320, 40, false), ImageFormat.Bmp); myDataSet.ClientDetail.Rows.Add( company.Header, company.Footer, company.Address.AddressDetail, company.Address.SubCity, company.Address.Kebele, company.Address.HouseNumber, company.Address.Telephone, company.Address.Mobile, company.Address.Fax, company.Address.PrimaryEmail, company.Address.AlternateEmail, "", "", "", "", "", "", "", linkno.ToString(CultureInfo.InvariantCulture)); myDataSet.DeliveryLine.Rows.Add( "1", SelectedDelivery.Number + "-" + deliveryLineDTO.Number, SelectedDelivery.OrderDateString, "", SelectedDelivery.OrderByClient.DisplayName, SelectedDelivery.OrderByClient.Address.AddressDetail, SelectedDelivery.OrderByClient.Address.Mobile, SelectedDelivery.OrderByClient.Address.AlternateMobile, SelectedDelivery.OrderByClient.Address.Telephone, deliveryLineDTO.FromClient.DisplayName, deliveryLineDTO.FromAddress.AddressDetail, deliveryLineDTO.FromAddress.Mobile, deliveryLineDTO.FromAddress.AlternateMobile, deliveryLineDTO.FromAddress.Telephone, deliveryLineDTO.ToClient.DisplayName, deliveryLineDTO.ToAddress.AddressDetail, deliveryLineDTO.ToAddress.Mobile, deliveryLineDTO.ToAddress.AlternateMobile, deliveryLineDTO.ToAddress.Telephone, deliverybarcode, "", "", "", "", "", linkno.ToString(CultureInfo.InvariantCulture) ); var serNo = 1; foreach (var message in deliveryLineDTO.Messages) { myDataSet.DeliveryMessage.Rows.Add( serNo, message.Number, message.Category.DisplayName, message.UnitOfMeasure.DisplayName, message.Description, message.Unit, "", "", "", "", "", null, linkno.ToString(CultureInfo.InvariantCulture)); serNo++; } } } catch (Exception exception) { MessageBox.Show("Can't get data for the report" + Environment.NewLine + exception.Message, "Can't get data", MessageBoxButton.OK, MessageBoxImage.Error); } return(myDataSet); }
public TransactionDataSet GetListDataSet() { var myDataSet = new TransactionDataSet(); try { #region Fields var brCode = new BarcodeProcess(); var tranNumberbarcode = ImageToByteArray(brCode.GetBarcode(SelectedTransaction.TransactionNumber, 320, 40, true), ImageFormat.Bmp); var tax = Convert.ToDecimal((SelectedTransaction.TotalCost * (Singleton.Setting.TaxPercent * (decimal)0.01)).ToString("N2")); #endregion #region Header myDataSet.TransactionHeader.Rows.Add( SelectedTransaction.FiscalNumber, tranNumberbarcode, SelectedTransaction.Warehouse.DisplayName, SelectedTransaction.BusinessPartner.DisplayName, SelectedTransaction.BusinessPartner.TinNumber, SelectedTransaction.BusinessPartner.VatNumber, SelectedTransaction.TransactionDateString + "(" + ReportUtility.getEthCalendarFormated(SelectedTransaction.TransactionDate, "/") + ")", SelectedTransaction.Status, SelectedTransaction.TotalCost, EnumUtil.GetEnumDesc(Singleton.Setting.TaxType) + " (" + Singleton.Setting.TaxPercent + "%)", tax, SelectedTransaction.TotalCost + tax, "linknumber1" ); #endregion #region Client Address myDataSet.ClientDetail.Rows.Add( SelectedTransaction.Warehouse.Header, SelectedTransaction.Warehouse.Footer, SelectedTransaction.Warehouse.Address.StreetAddress, SelectedTransaction.Warehouse.Address.SubCity, SelectedTransaction.Warehouse.Address.Kebele, SelectedTransaction.Warehouse.Address.HouseNumber, SelectedTransaction.Warehouse.Address.Telephone, SelectedTransaction.Warehouse.Address.Mobile, SelectedTransaction.Warehouse.Address.Fax, SelectedTransaction.Warehouse.Address.PrimaryEmail, SelectedTransaction.Warehouse.Address.AlternateEmail, SelectedTransaction.Warehouse != null ? SelectedTransaction.Warehouse.TinNumber : "", SelectedTransaction.Warehouse != null ? SelectedTransaction.Warehouse.VatNumber : "", PaymentMethod, PaymentMethod, "", "linknumber1"); #endregion #region BPAddress myDataSet.BPAddress.Rows.Add( SelectedTransaction.BusinessPartner.Addresses.FirstOrDefault().Address.StreetAddress, SelectedTransaction.BusinessPartner.Addresses.FirstOrDefault().Address.SubCity, SelectedTransaction.BusinessPartner.Addresses.FirstOrDefault().Address.Kebele, SelectedTransaction.BusinessPartner.Addresses.FirstOrDefault().Address.HouseNumber, SelectedTransaction.BusinessPartner.Addresses.FirstOrDefault().Address.Telephone, SelectedTransaction.BusinessPartner.Addresses.FirstOrDefault().Address.Mobile, SelectedTransaction.BusinessPartner.Addresses.FirstOrDefault().Address.Fax, SelectedTransaction.BusinessPartner.Addresses.FirstOrDefault().Address.PrimaryEmail, SelectedTransaction.BusinessPartner.Addresses.FirstOrDefault().Address.AlternateEmail, "linknumber1"); #endregion #region Lines var serNo = 1; foreach (var line in TransactionLines) { myDataSet.TransactionLine.Rows.Add( serNo, line.Item.ItemCode, string.IsNullOrEmpty(line.Item.Description) ? line.Item.DisplayName : line.Item.Description, "", line.Item.Category.DisplayName, line.Item.UnitOfMeasure.DisplayName, line.EachPrice, line.Unit, line.LinePrice, 0, "linknumber1"); serNo++; } #endregion } catch (Exception exception) { MessageBox.Show("Can't get data for the report" + Environment.NewLine + exception.Message, "Can't get data", MessageBoxButton.OK, MessageBoxImage.Error); } return(myDataSet); }