private void PrintReport() { if (radGridView.ItemsSource != null) { StiReport report = new StiReport(); using (var uow = new SainaDbContext()) { dynamic data; if (radGridView.SelectedItems.Any()) { data = radGridView.SelectedItems.Cast <Currency>() .Select(currency => new { CurrencyTitle = currency.CurrencyTitle, CurrencyTitle2 = currency.CurrencyTitle2, NumberDecimal = currency.NumberDecimal, TitleDecimal = currency.TitleDecimal, TitleDecimal2 = currency.TitleDecimal2, }).ToList(); } else { data = _viewModel.Currencies.Cast <Currency>() .Select(currency => new { CurrencyTitle = currency.CurrencyTitle, CurrencyTitle2 = currency.CurrencyTitle2, NumberDecimal = currency.NumberDecimal, TitleDecimal = currency.TitleDecimal, TitleDecimal2 = currency.TitleDecimal2, }).ToList(); } report.RegBusinessObject("CurrencyReport", data); report.Load($"{Environment.CurrentDirectory}\\Report\\currencyReport.mrt"); report.Print(); } } }
public void LoadedFlow() { _uow = new SainaDbContext(); var ids = new List <int> { 1, 3, 4, 5, 6 }; TypeDocuments = _uow.TypeDocuments.Where(x => !ids.Contains(x.TypeDocumentId)).ToList(); SLs = _uow.SLs.Where(x => x.Status == true).ToList(); DLs = _uow.DLs.ToList(); SLStandardDescriptions = _uow.SLStandardDescriptions.ToList(); Currencies = _uow.Currencies.ToList(); AccDocumentHeaders = new QueryableCollectionView(_uow.AccDocumentHeaders.Include(x => x.AccDocumentItems.Select(s => s.SL)).Where(x => _uow.ShamsiToMiladi(x.DocumentDate, "Saal") == DateFlow.ToString() && (HeaderId == 0 || x.AccDocumentHeaderId == HeaderId) && (TypeEnum == 0 || x.TypeDocumentId == TypeEnum)).ToList()); AccDocumentHeaders.CollectionChanged += AccDocumentHeaders_CollectionChanged; _uow.SaveChanges(); }
private void ShowReportAll() { if (radGridView.ItemsSource != null) { StiReport report = new StiReport(); using (var uow = new SainaDbContext()) { dynamic data; if (radGridView.SelectedItems.Any()) { data = _viewModel.Groups.Cast <Group>() .Select(group => new { GroupName = group.Name, }).ToList(); report.RegBusinessObject("GroupReport", data); report.Load($"{Environment.CurrentDirectory}\\Report\\groupReport.mrt"); report.Show(); } } } }
private void PrintReport() { StiReport report = new StiReport(); using (var uow = new SainaDbContext()) { var data = _viewModel.AccDocumentItems.Cast <AccDocumentItem1>() .Select(accDocumentItemDTO => new { accDocumentItemDTO.AccDocumentHeaderId, accDocumentItemDTO.AccDocumentItemId, accDocumentItemDTO.Credit, accDocumentItemDTO?.CurrencyAmount, accDocumentItemDTO?.CurrencyId, accDocumentItemDTO?.CurrencyTitle, accDocumentItemDTO.Debit, accDocumentItemDTO.Description1, accDocumentItemDTO.Description2, accDocumentItemDTO?.DLCode1, accDocumentItemDTO?.DLCode2, accDocumentItemDTO?.DLTitle1, accDocumentItemDTO?.DLTitle2, accDocumentItemDTO.DocumentDate, accDocumentItemDTO.DocumentDateString, accDocumentItemDTO.ExchangeRate, accDocumentItemDTO.Runningtotal, accDocumentItemDTO.SLCode, accDocumentItemDTO.SLTitle, accDocumentItemDTO.Status, accDocumentItemDTO?.TrackingDate, accDocumentItemDTO?.TrackingNumber }).ToList(); report.RegBusinessObject("AccDocumentItemDTOReport", data); report.Load($"{Environment.CurrentDirectory}\\Report\\accDocumentItemDTOReport.mrt"); report.Print(); } }
private void PrintReportAll() { if (RadGridView1.ItemsSource != null) { StiReport report = new StiReport(); using (var uow = new SainaDbContext()) { dynamic data; if (RadGridView1.SelectedItems.Any()) { data = _viewModel.AccDocumentItems.Cast <AccDocumentItemGroupedDTO>() .Select(accDocumentItemGroupedDTO => new { accDocumentItemGroupedDTO.CurrencyTitle, accDocumentItemGroupedDTO.DL1Code, accDocumentItemGroupedDTO.DL2Code, accDocumentItemGroupedDTO.DLTitle1, accDocumentItemGroupedDTO.DLTitle2, accDocumentItemGroupedDTO.DocumentDate, accDocumentItemGroupedDTO.ParityRate, accDocumentItemGroupedDTO.SLCode, accDocumentItemGroupedDTO.SLTitle, accDocumentItemGroupedDTO.SumCredit, accDocumentItemGroupedDTO.SumCurrencyAmount, accDocumentItemGroupedDTO.SumDebit, accDocumentItemGroupedDTO.TrackingNumber, }).ToList(); report.RegBusinessObject("CurrencyExchangeReport", data); report.Load($"{Environment.CurrentDirectory}\\Report\\currencyExchangeReport.mrt"); report.Print(); } } } }
private void ShowReport() { if (RadGridView1.ItemsSource != null) { StiReport report = new StiReport(); var headerIds = RadGridView1.SelectedItems.Cast <TLDocumentHeader>().Select(z => z.TLDocumentHeaderId); using (var uow = new SainaDbContext()) { //dynamic data; // if (RadGridView1.SelectedItems.Any()) var data = uow.TLDocumentItems.Include(x => x.TLDocumentHeader).Where(x => headerIds.Contains(x.TLDocumentHeaderId)) // data = RadGridView1.SelectedItems.Cast<TLDocumentHeader>() .Select(tLDocumentHeader => new { TLDocumentExport = tLDocumentHeader.TLDocumentHeader.TLDocumentExport == TLDocumentExportEnum.Daily ? "روزانه" : tLDocumentHeader.TLDocumentHeader.TLDocumentExport == TLDocumentExportEnum.Monthly ? "ماهانه" : "", tLDocumentHeader.TLDocumentHeader.TLDocumentHeaderDate, tLDocumentHeader.TLDocumentHeader.TLDocumentNumber, TLDocumentType = tLDocumentHeader.TLDocumentHeader.TLDocumentType == TLDocumentTypeEnum.Closing ? "اختتامیه" : tLDocumentHeader.TLDocumentHeader.TLDocumentType == TLDocumentTypeEnum.Litter ? "تسعیر" : tLDocumentHeader.TLDocumentHeader.TLDocumentType == TLDocumentTypeEnum.Opening ? "افتتاحیه" : tLDocumentHeader.TLDocumentHeader.TLDocumentType == TLDocumentTypeEnum.Profit ? "سود و زیانی" : tLDocumentHeader.TLDocumentHeader.TLDocumentType == TLDocumentTypeEnum.None ? "هیچ کدام" : "", tLDocumentHeader.TLDocumentItemCode, tLDocumentHeader.TLDocumentItemDate, tLDocumentHeader.TLId, tLDocumentHeader.TLTitle, tLDocumentHeader.Credit, tLDocumentHeader.Debit }).ToList(); //else //{ // // data = _viewModel.ExchangeRates.Cast<ExchangeRate>() // } report.RegBusinessObject("TLDocumentHeaderReport", data); report.Load($"{Environment.CurrentDirectory}\\Report\\tLDocumentHeaderReport.mrt"); report.Show(); } } }
private void PrintReport() { if (radGridView.ItemsSource != null) { StiReport report = new StiReport(); using (var uow = new SainaDbContext()) { dynamic data; if (radGridView.SelectedItems.Any()) { data = radGridView.SelectedItems.Cast <User>() .Select(user => new { UserName = user.UserName, FriendlyName = user.FriendlyName, GroupName = user.Group.Name, Password = user.Password, }).ToList(); } else { data = _viewModel.Users.Cast <User>() .Select(user => new { UserName = user.UserName, FriendlyName = user.FriendlyName, GroupName = user.Group.Name, Password = user.Password, }).ToList(); } report.RegBusinessObject("UserReport", data); report.Load($"{Environment.CurrentDirectory}\\Report\\userReport.mrt"); report.Print(); } } }
private void PrintReportAll() { if (RadGridView1.ItemsSource != null) { StiReport report = new StiReport(); using (var uow = new SainaDbContext()) { dynamic data; if (RadGridView1.SelectedItems.Any()) { data = _viewModel.TLDocumentHeaders.Cast <TLDocumentHeader>() .Select(tLDocumentHeadert => new { tLDocumentHeadert.TLDocumentType }).ToList(); report.RegBusinessObject("TLDocumentHeaderReport", data); report.Load($"{Environment.CurrentDirectory}\\Report\\tLDocumentHeaderReport.mrt"); report.Print(); } } } }
private IQueryable <AccDocumentItem> ApplyFilter() { _uow = new SainaDbContext(); // var xx= _uow.AccDocumentItems.ToList(); var accDocumentItems = _uow.AccDocumentItems.AsNoTracking() .Include(x => x.AccDocumentHeader).Include(x => x.Currency).Include(x => x.DL1).Include(x => x.DL2).Include(x => x.SL).Include(x => x.SL.TL).Include(x => x.SL.TL.GL) .Where(x => x.AccDocumentHeader.DocumentNumber >= _accDocumentHeaderFilter.FromNumber && x.AccDocumentHeader.DocumentNumber <= _accDocumentHeaderFilter.ToNumber && x.AccDocumentHeader.DocumentDate >= _accDocumentHeaderFilter.FromDate && x.AccDocumentHeader.DocumentDate <= _accDocumentHeaderFilter.ToDate && (x.AccDocumentHeader.TypeDocumentId & ((int)_accDocumentHeaderFilter.TLDocumentType)) == x.AccDocumentHeader.TypeDocumentId && (_accDocumentHeaderFilter.AccountGLEnum.HasFlag(x.SL.TL.GL.AccountGLEnum)) && (x.AccDocumentHeader.Status != StatusEnum.Draft) ); // AccountGLEnum TLDocumentType AccDocumentHeaders = new QueryableCollectionView(_uow.AccDocumentHeaders.Include(x => x.AccDocumentItems).Where(x => _uow.ShamsiToMiladi(x.DocumentDate, "Saal") == _appContextService.CurrentFinancialYear.ToString()).ToList()); //if (accDocumentItems.ToList().Any(x => x.DL1Id == null)) //{ // int y = 0; // var z = accDocumentItems.ToList(); //} return(accDocumentItems); }
private void PrintReportAll() { if (radGridView.ItemsSource != null) { StiReport report = new StiReport(); using (var uow = new SainaDbContext()) { dynamic data; if (radGridView.SelectedItems.Any()) { data = _viewModel.AccDocumentHeaders.Cast <AccDocumentHeaderDTO>() .Select(accDocumentHeader => new { AmountDocument = accDocumentHeader.AmountDocument, DailyNumber = accDocumentHeader.DailyNumber, DocumentDate = accDocumentHeader.DocumentDate, DocumentNumber = accDocumentHeader.DocumentNumber, Exporter = accDocumentHeader.Exporter, HeaderDescription = accDocumentHeader.HeaderDescription, ManualDocumentNumber = accDocumentHeader.ManualDocumentNumber, Seconder = accDocumentHeader.Seconder, Status = accDocumentHeader.Status, SystemFixNumber = accDocumentHeader.SystemFixNumber, SystemName = accDocumentHeader.SystemName, TypeDocumentTitle = accDocumentHeader.TypeDocumentTitle, }).ToList(); report.RegBusinessObject("ConvertDocumentReport", data); report.Load($"{Environment.CurrentDirectory}\\Report\\convertDocumentReport.mrt"); report.Print(); } } } }
private void PrintReportAll() { if (GLRadGridView.ItemsSource != null) { StiReport report = new StiReport(); using (var uow = new SainaDbContext()) { dynamic data; data = _viewModel.GLs.Cast <GL>() .Select(gl => new { GLCode = gl.GLCode, Title = gl.Title, Title2 = gl.Title2, Status = gl.Status == true ? "فعال" : "غیرفعال", AccountGLEnum = gl.AccountGLEnum == AccountGLEnum.BalanceSheet ? "ترازنامه ای" : gl.AccountGLEnum == AccountGLEnum.Disciplinary ? "انتظامی" : gl.AccountGLEnum == AccountGLEnum.ProfitLoss ? "سود و زیانی" : "", Address = _viewModel.CompanyInformationModel.Address }).ToList(); report.RegBusinessObject("GLReport", data); report.Load($"{Environment.CurrentDirectory}\\Report\\glReport.mrt"); report.Print(); } } }
private void PrintReport() { if (radGridView.ItemsSource != null) { StiReport report = new StiReport(); using (var uow = new SainaDbContext()) { dynamic data; if (radGridView.SelectedItems.Any()) { data = radGridView.SelectedItems.Cast <ExchangeRate>() .Select(exchangeRate => new { Description = exchangeRate.Description, CurrencyTitle = exchangeRate.Currency.CurrencyTitle, EffectiveDate = exchangeRate.EffectiveDate.ToShortDateString(), ParityRate = exchangeRate.ParityRate }).ToList(); } else { data = _viewModel.ExchangeRates.Cast <ExchangeRate>() .Select(exchangeRate => new { Description = exchangeRate.Description, CurrencyTitle = exchangeRate.Currency.CurrencyTitle, EffectiveDate = exchangeRate.EffectiveDate.ToShortDateString(), ParityRate = exchangeRate.ParityRate }).ToList(); } report.RegBusinessObject("ExchangeRateReport", data); report.Load($"{Environment.CurrentDirectory}\\Report\\exchangeRateReport.mrt"); report.Print(); } } }
private void ShowReportAll() { if (radGridView.ItemsSource != null) { StiReport report = new StiReport(); using (var uow = new SainaDbContext()) { dynamic data; if (radGridView.SelectedItems.Any()) { data = _viewModel.TypeDocuments.Cast <TypeDocument>() .Select(typeDocument => new { typeDocument.TypeDocumentTitle }).ToList(); report.RegBusinessObject("TypeDocumentReport", data); report.Load($"{Environment.CurrentDirectory}\\Report\\typeDocumentReport.mrt"); report.Show(); } } } }
/// <summary> /// سازنده کلاس /// </summary> /// <param name="uow">وهلهای از الگوی واحد کار یا زمینه ایی اف</param> public CurrencyExchangesService(SainaDbContext uow, IAppContextService appContextService) { _uow = uow; _appContextService = appContextService; }
/// <summary> /// سازنده کلاس /// </summary> /// <param name="uow">وهلهای از الگوی واحد کار یا زمینه ایی اف</param> public StylesService(SainaDbContext uow, IAppContextService appContextService) { _uow = uow; _appContextService = appContextService; }
/// <summary> /// سازنده کلاس /// </summary> /// <param name="uow">وهلهای از الگوی واحد کار یا زمینه ایی اف</param> public SystemSettingSalesService(SainaDbContext uow, IAppContextService appContextService) { _uow = uow; _appContextService = appContextService; _keyValues = _uow.Set <KeyValue>(); }
/// <summary> /// سازنده کلاس /// </summary> /// <param name="uow">وهلهای از الگوی واحد کار یا زمینه ایی اف</param> public TLsService(SainaDbContext uow, IAppContextService appContextService) { _uow = uow; _appContextService = appContextService; _gLs = _uow.Set <GL>(); }
/// <summary> /// سازنده کلاس /// </summary> /// <param name="uow">وهلهای از الگوی واحد کار یا زمینه ایی اف</param> public SLStandardDescriptionsService(SainaDbContext uow, IAppContextService appContextService) { _uow = uow; _appContextService = appContextService; //_accountGroups = _uow.Set<AccountGroup>(); }
/// <summary> /// سازنده کلاس /// </summary> /// <param name="uow">وهلهای از الگوی واحد کار یا زمینه ایی اف</param> public SLsService(SainaDbContext uow, IAppContextService appContextService) { _uow = uow; _appContextService = appContextService; // _tLs = _uow.Set<TL>(); }
/// <summary> /// سازنده کلاس /// </summary> /// <param name="uow">وهلهای از الگوی واحد کار یا زمینه ایی اف</param> public CountingWaysService(SainaDbContext uow, IAppContextService appContextService) { _uow = uow; _appContextService = appContextService; }
/// <summary> /// سازنده کلاس /// </summary> /// <param name="uow">وهلهای از الگوی واحد کار یا زمینه ایی اف</param> public CompanyInformationsService(SainaDbContext uow, IAppContextService appContextService) { _uow = uow; _appContextService = appContextService; _keyValues = _uow.Set <KeyValue>(); }
private void DesignReport() { StiReport report = new StiReport(); using (var uow = new SainaDbContext()) { var AddressCompany = _viewModel.CompanyInformationModel.Address; var CityCompany = _viewModel.CompanyInformationModel.City; var EconomicStoreCodeCompany = _viewModel.CompanyInformationModel.EconomicStoreCode; var FaxCompany = _viewModel.CompanyInformationModel.Fax; var LogoCompany = _viewModel.CompanyInformationModel.Logo; var ManagerNameCompany = _viewModel.CompanyInformationModel.ManagerName; var MobileCompany = _viewModel.CompanyInformationModel.Mobile; var PhoneCompany = _viewModel.CompanyInformationModel.Phone; var Phone2Company = _viewModel.CompanyInformationModel.Phone2; var PostalCodeCompany = _viewModel.CompanyInformationModel.PostalCode; var ProvinceCompany = _viewModel.CompanyInformationModel.Province; var StoreNameCompany = _viewModel.CompanyInformationModel.StoreName; var StoreCodeCompany = _viewModel.CompanyInformationModel.StoreCode; var TownCompany = _viewModel.CompanyInformationModel.Town; var WebSiteCompany = _viewModel.CompanyInformationModel.WebSite; var data = _viewModel.AccDocumentItems.Cast <AccDocumentItem1>() .Select(accDocumentItemDTO => new { accDocumentItemDTO.AccDocumentHeaderId, accDocumentItemDTO.AccDocumentItemId, accDocumentItemDTO.Credit, accDocumentItemDTO?.CurrencyAmount, accDocumentItemDTO?.CurrencyId, accDocumentItemDTO?.CurrencyTitle, accDocumentItemDTO.Debit, accDocumentItemDTO.Description1, accDocumentItemDTO.Description2, accDocumentItemDTO?.DLCode1, accDocumentItemDTO?.DLCode2, accDocumentItemDTO?.DLTitle1, accDocumentItemDTO?.DLTitle2, accDocumentItemDTO.DocumentDate, accDocumentItemDTO.DocumentDateString, accDocumentItemDTO.ExchangeRate, accDocumentItemDTO.Runningtotal, accDocumentItemDTO.SLCode, accDocumentItemDTO.SLTitle, accDocumentItemDTO.Status, accDocumentItemDTO?.TrackingDate, accDocumentItemDTO?.TrackingNumber , AddressCompany = AddressCompany, CityCompany = CityCompany, EconomicStoreCode = EconomicStoreCodeCompany, FaxCompany = FaxCompany, LogoCompany = LogoCompany, ManagerNameCompany = ManagerNameCompany, MobileCompany = MobileCompany, PhoneCompany = PhoneCompany, Phone2Company = Phone2Company, PostalCodeCompany = PostalCodeCompany, ProvinceCompany = ProvinceCompany, StoreNameCompany = StoreNameCompany, StoreCodeCompany = StoreCodeCompany, TownCompany = TownCompany, WebSiteCompany = WebSiteCompany, }).ToList(); var path = $"{Environment.CurrentDirectory}\\Report\\accDocumentItemDTOReport.mrt"; report.RegBusinessObject("AccDocumentItemDTOReport", data); // report.RegBusinessObject("GLReport1", Address); // report.RegData("xx", Address); if (!File.Exists(path)) { File.Copy($"{Environment.CurrentDirectory}\\Report\\Report.mrt", path, false); } report.Load(path); report.Design(); } }
public OrdersRepository(SainaDbContext context) { _context = context; }
/// <summary> /// سازنده کلاس /// </summary> /// <param name="uow">وهلهای از الگوی واحد کار یا زمینه ایی اف</param> public AccountDocumentsService(SainaDbContext uow, IAppContextService appContextService) { _uow = uow; _appContextService = appContextService; }
private void DesignReport() { StiReport report = new StiReport(); using (var uow = new SainaDbContext()) { var AddressCompany = _viewModel.CompanyInformationModel.Address; var CityCompany = _viewModel.CompanyInformationModel.City; var EconomicStoreCodeCompany = _viewModel.CompanyInformationModel.EconomicStoreCode; var FaxCompany = _viewModel.CompanyInformationModel.Fax; var LogoCompany = _viewModel.CompanyInformationModel.Logo; var ManagerNameCompany = _viewModel.CompanyInformationModel.ManagerName; var MobileCompany = _viewModel.CompanyInformationModel.Mobile; var PhoneCompany = _viewModel.CompanyInformationModel.Phone; var Phone2Company = _viewModel.CompanyInformationModel.Phone2; var PostalCodeCompany = _viewModel.CompanyInformationModel.PostalCode; var ProvinceCompany = _viewModel.CompanyInformationModel.Province; var StoreNameCompany = _viewModel.CompanyInformationModel.StoreName; var StoreCodeCompany = _viewModel.CompanyInformationModel.StoreCode; var TownCompany = _viewModel.CompanyInformationModel.Town; var WebSiteCompany = _viewModel.CompanyInformationModel.WebSite; var data = radGridView.SelectedItems.Cast <AccDocumentHeaderDTO>().ToList() .Select(accDocumentHeader => new { AmountDocument = accDocumentHeader.AmountDocument, DailyNumber = accDocumentHeader.DailyNumber, DocumentDate = accDocumentHeader.DocumentDate, DocumentNumber = accDocumentHeader.DocumentNumber, Exporter = accDocumentHeader.Exporter, HeaderDescription = accDocumentHeader.HeaderDescription, ManualDocumentNumber = accDocumentHeader.ManualDocumentNumber, Seconder = accDocumentHeader.Seconder, Status = accDocumentHeader.Status, //SumCredit= accDocumentHeader..SumCredit, //SumDebit= accDocumentHeader.SumDebit, SystemFixNumber = accDocumentHeader.SystemFixNumber, SystemName = accDocumentHeader.SystemName, TypeDocumentTitle = accDocumentHeader.TypeDocumentTitle, AddressCompany = AddressCompany, CityCompany = CityCompany, EconomicStoreCode = EconomicStoreCodeCompany, FaxCompany = FaxCompany, LogoCompany = LogoCompany, ManagerNameCompany = ManagerNameCompany, MobileCompany = MobileCompany, PhoneCompany = PhoneCompany, Phone2Company = Phone2Company, PostalCodeCompany = PostalCodeCompany, ProvinceCompany = ProvinceCompany, StoreNameCompany = StoreNameCompany, StoreCodeCompany = StoreCodeCompany, TownCompany = TownCompany, WebSiteCompany = WebSiteCompany, }); var path = $"{Environment.CurrentDirectory}\\Report\\convertDocumentReport.mrt"; report.RegBusinessObject("ConvertDocumentReport", data); if (!File.Exists(path)) { File.Copy($"{Environment.CurrentDirectory}\\Report\\Report.mrt", path, false); } report.Load(path); report.Design(); } }
/// <summary> /// سازنده کلاس /// </summary> /// <param name="uow">وهلهای از الگوی واحد کار یا زمینه ایی اف</param> public DLsService(SainaDbContext uow, IAppContextService appContextService) { _uow = uow; _appContextService = appContextService; _sLs = _uow.Set <SL>(); }
/// <summary> /// سازنده کلاس /// </summary> /// <param name="uow">وهلهای از الگوی واحد کار یا زمینه ایی اف</param> public ExchangeRatesService(SainaDbContext uow, IAppContextService appContextService) { _uow = uow; _appContextService = appContextService; _currencies = _uow.Set <Currency>(); }
/// <summary> /// سازنده کلاس /// </summary> /// <param name="uow">وهلهای از الگوی واحد کار یا زمینه ایی اف</param> public DocumentNumberingsService(SainaDbContext uow, IAppContextService appContextService) { _uow = uow; _appContextService = appContextService; _documents = _uow.Set <AccountDocument>(); }
/// <summary> /// سازنده کلاس /// </summary> /// <param name="uow">وهلهای از الگوی واحد کار یا زمینه ایی اف</param> public BankTypesService(SainaDbContext uow, IAppContextService appContextService) { _uow = uow; _appContextService = appContextService; //_accountGroups = _uow.Set<AccountGroup>(); }
public DynamicPagesService(SainaDbContext uow, IAppContextService appContextService) { _uow = uow; _appContextService = appContextService; }