Exemplo n.º 1
0
 public FooterViewComponent(GalleryRepository galleryRepo, NoticeRepository noticeRepo, SetupRepository setupRepo, PageCategoryRepository pageCategoryRepo)
 {
     _galleryRepo      = galleryRepo;
     _noticeRepo       = noticeRepo;
     _setupRepo        = setupRepo;
     _pageCategoryRepo = pageCategoryRepo;
 }
 public NoticeServiceImpl(TransactionManager transactionManager, NoticeRepository noticeRepo, NoticeMaker noticeMaker, IHostingEnvironment hostingEnvironment)
 {
     _transactionManager = transactionManager;
     _noticeRepo         = noticeRepo;
     _noticeMaker        = noticeMaker;
     _hostingEnvironment = hostingEnvironment;
 }
Exemplo n.º 3
0
        public ActionResult Visualize(long noticeId, Guid userId)
        {
            var noticeRepository = new NoticeRepository(_context);
            var notSeenNotices   = noticeRepository.ListNotSeenNotices(userId);

            var userNotice = new UserNotice
            {
                VisualizationDateTime = DateTime.Now,
                NoticeId = noticeId,
                UserId   = userId
            };

            _context.GetList <UserNotice>().Add(userNotice);
            _context.Save();

            var dateTimeHumanizerStrategy = new DefaultDateTimeHumanizeStrategy();
            var nextNotice = noticeRepository.ListNotSeenNotices(userId).Except(notSeenNotices).FirstOrDefault();

            if (nextNotice != null)
            {
                return(Json(NoticeViewModel.FromEntity(nextNotice, dateTimeHumanizerStrategy)));
            }

            return(new EmptyResult());
        }
Exemplo n.º 4
0
        public ActionResult Index(Nullable <int> categoryId = null)
        {
            var categoryRepo = new CategoryRepository();
            var allCategory  = categoryRepo.GetAllCategory();

            var noticeRepo  = new NoticeRepository();
            var noticesList = new List <NoticeRepo>();

            if (categoryId == null)
            {
                noticesList = noticeRepo.GetAllNotices();
            }
            else
            {
                noticesList = noticeRepo.GetNoticesByCategoryId(categoryId.Value);
            }

            var result = new HomeViewModel();

            result.CategoriesList     = allCategory;
            result.NoticesList        = noticesList;
            result.SelectedCategoryId = categoryId;

            return(View(result));
        }
        public ActionResult AddNoticeToDatabase(NewNoticeViewModel model)
        {
            try
            {
                var newNoticeToAdd = new NoticeEntity();
                newNoticeToAdd.Amount        = decimal.Parse(model.Amount);
                newNoticeToAdd.CategoryId    = int.Parse(model.SelectedCategoryId);
                newNoticeToAdd.CreateDate    = DateTime.Now;
                newNoticeToAdd.Description   = model.Description;
                newNoticeToAdd.ExprireDate   = DateTime.Now.AddDays(int.Parse(model.ExpireTo));
                newNoticeToAdd.NoticePlaceId = int.Parse(model.NoticePlaceId);
                newNoticeToAdd.Title         = model.Title;
                newNoticeToAdd.UserProfileId = WebMatrix.WebData.WebSecurity.CurrentUserId;

                var noticeRepo = new NoticeRepository();
                noticeRepo.AddNewNotice(newNoticeToAdd);
                ViewBag.Message = "Dodano ogłoszenie.";
            }
            catch (Exception ex)
            {
                ViewBag.Message       = "Ups coś poszło nie tak.";
                ViewBag.ExtendMessage = ex.Message;
            }
            return(View());
        }
Exemplo n.º 6
0
 public NoticeController(NoticeRepository noticeRepo, EventRepository eventRepo, SetupRepository setupRepo, PaginatedMetaService paginatedMetaService, CareerRepository careerRepo)
 {
     _noticeRepo           = noticeRepo;
     _eventRepo            = eventRepo;
     _setupRepo            = setupRepo;
     _paginatedMetaService = paginatedMetaService;
     _careerRepo           = careerRepo;
 }
Exemplo n.º 7
0
 public NoticeController(NoticeRepository noticeRepo, NoticeService noticeService, IMapper mapper, PaginatedMetaService paginatedMetaService, FileHelper fileHelper)
 {
     _noticeRepo           = noticeRepo;
     _noticeService        = noticeService;
     _mapper               = mapper;
     _paginatedMetaService = paginatedMetaService;
     _fileHelper           = fileHelper;
 }
Exemplo n.º 8
0
 public CategoryService()
 {
     _customerRepository           = new CustomerRepository();
     _meetingRoomRepository        = new MeetingRoomRepository();
     _statusRepository             = new StatusRepository();
     _applicationLoggingRepository = new ApplicationLoggingRepository();
     _noticeRepository             = new NoticeRepository();
 }
Exemplo n.º 9
0
        public ActionResult NoticePanel()
        {
            var repo    = new NoticeRepository(_context);
            var notices = repo.ListNotSeenNotices(_loggedUser.Id);
            var dateTimeHumanizerStrategy = new DefaultDateTimeHumanizeStrategy();

            return(PartialView("_NoticePanel", NoticeViewModel.FromEntityList(notices, dateTimeHumanizerStrategy)));
        }
Exemplo n.º 10
0
        public ParserContext(Driver driver, TokenStream stream)
        {
            this.Driver = driver;
            this.Stream = stream;

            // Create a new notice repository instance.
            this.NoticeRepository = new NoticeRepository(this.Stream, driver.Module.FileName);
        }
Exemplo n.º 11
0
 public EventController(EventRepository eventRepo, NoticeRepository noticeRepo, PaginatedMetaService paginatedMetaService, SetupRepository setupRepo, CareerRepository careerRepo, TestimonialRepository testimonialRepo)
 {
     _eventRepo            = eventRepo;
     _noticeRepo           = noticeRepo;
     _paginatedMetaService = paginatedMetaService;
     _setupRepo            = setupRepo;
     _careerRepo           = careerRepo;
     _testimonialRepo      = testimonialRepo;
 }
        //
        // GET: /UserNotices/

        public ActionResult Index()
        {
            var noticeRepo  = new NoticeRepository();
            var noticesList = new List <NoticeRepo>();

            noticesList = noticeRepo.GetNoticesByUserId();

            return(View(noticesList));
        }
Exemplo n.º 13
0
        public UnitOfWork(ApplicationDbContext context)
        {
            _context = context;

            Notices       = new NoticeRepository(context);
            Products      = new ProductRepository(context);
            GalleryImages = new GalleryImageRepository(context);
            Categories    = new CategoryRepository(context);
            Comments      = new CommentRepository(context);
        }
Exemplo n.º 14
0
 public HeaderViewComponent(EmailSenderService emailSenderService, GalleryRepository galleryRepo, AppointmentRepository appoitmentRepo, NoticeRepository noticeRepo, SetupRepository setupRepo, PageCategoryRepository pageCategoryRepo, EventRepository eventRepo, ServicesRepository serviceRepository)
 {
     _galleryRepo        = galleryRepo;
     _noticeRepo         = noticeRepo;
     _setupRepo          = setupRepo;
     _pageCategoryRepo   = pageCategoryRepo;
     _eventRepo          = eventRepo;
     _appointmentRepo    = appoitmentRepo;
     _serviceRepository  = serviceRepository;
     _emailSenderService = emailSenderService;
 }
 public BlogController(BlogRepository blogRepo, BlogService blogService, BlogCommentService blogCommentService, BlogCommentRepository blogCommentRepo, IMapper mapper, PaginatedMetaService paginatedMetaService, EventRepository eventRepo, SetupRepository setupRepo, NoticeRepository noticeRepo)
 {
     _blogRepo             = blogRepo;
     _eventRepo            = eventRepo;
     _blogService          = blogService;
     _setupRepo            = setupRepo;
     _mapper               = mapper;
     _blogCommentRepo      = blogCommentRepo;
     _blogCommentService   = blogCommentService;
     _paginatedMetaService = paginatedMetaService;
     _noticeRepo           = noticeRepo;
 }
Exemplo n.º 16
0
        public ActionResult EmployerData(DateTime cutdate)
        {
            Users usr        = UserRepository.Details(User.Identity.Name);
            var   serializer = new JavaScriptSerializer {
                MaxJsonLength = int.MaxValue, RecursionLimit = 100
            };

            return(new ContentResult()
            {
                Content = serializer.Serialize(new { data = NoticeRepository.GetEmployer(cutdate.Date, usr.hub_code) }),
                ContentType = "json",
            });
        }
Exemplo n.º 17
0
 public VkParser(IConfiguration configuration, NoticeRepository noticeRepository)
 {
     this.noticeRepository = noticeRepository;
     api = new VkApi();
     api.Authorize(new ApiAuthParams
     {
         ClientSecret  = configuration["VkClientSecret"],
         AccessToken   = configuration["VkAccessToken"],
         ResponseType  = ResponseType.Token,
         ApplicationId = ulong.Parse(configuration["VkAppId"]),
     });
     groups = new Dictionary <string, int[]>();
     configuration.GetSection("VkGroups").Bind(groups);
 }
Exemplo n.º 18
0
        public StudentNotes(string ID, string User, string semester, string courseName, string sectionName)
        {
            InitializeComponent();
            this.ID                   = ID;
            this.User                 = User;
            this.semester             = semester;
            this.courseName           = courseName;
            this.section              = sectionName;
            this.NameLabel.Text       = "Welcome " + User;
            this.SubjectLabel.Text    = "Course: " + courseName;
            this.SubjectLabel.Visible = false;

            //NoteRepository nr = new NoteRepository();
            //List<Note> nList = new List<Note>();

            //nList = nr.GetAllNotes(semester, ID);
            //DataTable nTable = new DataTable();
            //nTable.Columns.Add("Notes", typeof(FileDialog));

            //string path = Application.StartupPath;

            //for (int i = 0; i < nList.Count; i++)
            //{
            //    nTable.Rows.Add(path + nList[i].NotePath);

            //}

            NoticeRepository nc     = new NoticeRepository();
            List <Notice>    ncList = new List <Notice>();

            CourseRepository cr = new CourseRepository();
            Course           cs = new Course();

            cs = cr.GetCourseId(courseName, semester, section);

            ncList = nc.GetAllNotice(semester, cs.CourseId, section);
            DataTable ncTable = new DataTable();

            ncTable.Columns.Add("Date", typeof(string));
            ncTable.Columns.Add("Notice", typeof(string));

            for (int i = 0; i < ncList.Count; i++)
            {
                ncTable.Rows.Add(ncList[i].Date, ncList[i].Noticee);
            }

            NotesGridView.DataSource = ncTable;
            NotesGridView.ReadOnly   = true;
        }
Exemplo n.º 19
0
        public ActionResult ShowNoticeDetails(int noticeId)
        {
            var categoryRepo = new CategoryRepository();
            var allCategory  = categoryRepo.GetAllCategory();

            var noticeRepo    = new NoticeRepository();
            var currentNotice = noticeRepo.GetNoticeById(noticeId);

            var result = new NoticeDetailsViewModel();

            result.CategoriesList = allCategory;
            result.Notice         = currentNotice;

            return(View(result));
        }
Exemplo n.º 20
0
 public ParseVkJob(
     TelegramBotClient client,
     StateRepository stateRepository,
     NoticeRepository noticeRepository,
     VkParser parser,
     Categorizer categorizer,
     Geocoding geocoding,
     ILogger logger)
     : base(client, stateRepository, logger)
 {
     this.parser           = parser;
     this.noticeRepository = noticeRepository;
     this.categorizer      = categorizer;
     this.geocoding        = geocoding;
 }
        public ActionResult EditNotice(int noticeId)
        {
            var categoryRepo    = new CategoryRepository();
            var allCategory     = categoryRepo.GetAllCategory();
            var noticePlaceRepo = new NoticePlaceRepository();
            var allNoticePlace  = noticePlaceRepo.GetAllNoticePlace();

            var result = new NewNoticeViewModel();

            var categoryListTemporary = new List <SelectListItem>();

            foreach (var category in allCategory)
            {
                categoryListTemporary.AddRange(category.SubCategory.Select(x => new SelectListItem
                {
                    Text  = string.Format("{0}, {1}", category.Name, x.Name),
                    Value = x.Id.ToString()
                }));
            }
            result.CategoryList = categoryListTemporary;

            result.NoticePlaceList = allNoticePlace.Select(x => new SelectListItem
            {
                Text  = string.Format("{0}, {1}", x.Province, x.City),
                Value = x.Id.ToString()
            }).OrderBy(x => x.Text);


            var noticeRepo    = new NoticeRepository();
            var currentNotice = noticeRepo.GetNoticeById(noticeId);

            result.Title       = currentNotice.Title;
            result.Amount      = currentNotice.Amount.ToString();
            result.Description = currentNotice.Description;
            //result.ExpireTo = currentNotice.Title;
            result.SelectedCategoryId = currentNotice.CategoryId.ToString();
            result.NoticePlaceId      = currentNotice.NoticePlaceId.ToString();
            result.Id = currentNotice.Id;

            return(View(result));
        }
Exemplo n.º 22
0
        private void buttonUploadNotice_Click(object sender, EventArgs e)
        {
            if (textBoxNotice.Text == "")
            {
                MessageBox.Show("Notice Box can not be empty");
            }
            else if (textBoxNotice.Text != "")
            {
                string fullName    = comboBoxSelectCourse.Text;
                string nameCourse  = fullName.Remove(fullName.Length - 2, 2);
                string nameSection = comboBoxSelectCourse.Text;
                nameSection = "" + nameSection[fullName.Length - 1];

                CourseRepository cr = new CourseRepository();
                Course           co = cr.GetCourseId(nameCourse, comboBoxSelectSemester.Text, nameSection);

                Notice no = new Notice();

                no.CourseId = co.CourseId;
                no.Semester = comboBoxSelectSemester.Text;
                no.Section  = nameSection;
                no.Noticee  = textBoxNotice.Text;
                no.Date     = DateTime.Now.ToString();

                //labelUserName.Text = no.CourseId + " " + no.Semester + " " + no.Section + " " + no.Noticee + " " + " " + no.Date;

                NoticeRepository nr = new NoticeRepository();
                if (nr.Insert(no))
                {
                    MessageBox.Show("Notice Updated Successfully");
                }
                else
                {
                    MessageBox.Show("OOPS ! Something went wrong");
                }
            }
        }
 public HomeController(PartnersRepository partnersRepository, MembersRepository membersRepository, GalleryImageRepository galleryRepo, MenuRepository menuRepo, MenuCategoryRepository menuCategoryRepo, NoticeRepository noticeRepo, PageRepository pageRepo, CoursesRepository productRepo, IMapper mapper, SetupRepository setupRepo, EmailSenderService emailSenderService, TestimonialRepository testimonialRepo, BlogRepository blogRepo, EventRepository eventRepo, VideoRepository videoRepository, NewsRepository newsRepository, DoctorsRepository doctorsRepository, ServicesRepository servicesRepository, AppointmentService appointmentService, AppointmentRepository appointmentRepository, AppointmentMaker appointmentMaker)
 {
     _galleryRepo           = galleryRepo;
     _newsRepository        = newsRepository;
     _noticeRepo            = noticeRepo;
     _pageRepo              = pageRepo;
     _productRepo           = productRepo;
     _mapper                = mapper;
     _setupRepo             = setupRepo;
     _testimonialRepo       = testimonialRepo;
     _emailSenderService    = emailSenderService;
     _blogRepo              = blogRepo;
     _eventRepo             = eventRepo;
     _videoRepository       = videoRepository;
     _doctorsRepository     = doctorsRepository;
     _servicesRepository    = servicesRepository;
     _appointmentService    = appointmentService;
     _appointmentRepository = appointmentRepository;
     _appointmentMaker      = appointmentMaker;
     _menuRepo              = menuRepo;
     _menuCategoryRepo      = menuCategoryRepo;
     _membersRepository     = membersRepository;
     _partnersRepository    = partnersRepository;
 }
Exemplo n.º 24
0
 /// <summary>
 /// 构造函数
 /// </summary>
 /// <param name="noticeRepository"></param>
 public OperateNoticeService(NoticeRepository noticeRepository)
 {
     this._noticeRepository = noticeRepository;
 }
Exemplo n.º 25
0
 private NoticeService()
 {
     noticeRepo = new NoticeRepository();
 }
Exemplo n.º 26
0
        public async Task NoticeRepositoryAsyncAllMethodTest()
        {
            #region [0] DbContextOptions<T> Object Creation and ILoggerFactory Object Creation
            // db와의 테스트 할경우는 (identity 충돌하는 경우가 있기때문에) 인메모리로 우선 테스트
            // [0] DbContextOptions<T> Object Creation and ILoggerFactory Object Creation
            var options = new DbContextOptionsBuilder <NoticeAppDbContext>()
                          .UseInMemoryDatabase(databaseName: $"NoticeApp{Guid.NewGuid()}").Options;
            //.UseSqlServer("Data Source=(localdb)\\MSSQLLocalDB;Initial Catalog=NoticeApp;Integrated Security=True;Connect Timeout=60;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False").Options;

            // ILoggerFactory object
            var serviceProvider = new ServiceCollection().AddLogging().BuildServiceProvider();
            var factory         = serviceProvider.GetService <ILoggerFactory>();
            #endregion

            #region [1] AddAsync() Method test
            // [1] AddAsync() Method test
            using (var context = new NoticeAppDbContext(options))
            {
                // [A] Arrange
                var repository = new NoticeRepository(context, factory);
                var model      = new BoardNotices {
                    Name = "[1] 관리자", Title = "공지사항입니다.", Content = "내용입니다."
                };                                                                                            // Id: 1

                // [B] Act
                await repository.AddAsync(model);
            }
            using (var context = new NoticeAppDbContext(options))
            {
                // [C] Assert
                Assert.AreEqual(1, await context.BoardNotices.CountAsync());     // 이 시점에 1개 일거다 주장 assert
                var model = await context.BoardNotices.Where(n => n.Id == 1).SingleOrDefaultAsync();

                Assert.AreEqual("[1] 관리자", model.Name);
            }
            #endregion

            #region [2] GetAllAsync() Method test
            // [2] GetAllAsync() Method test
            using (var context = new NoticeAppDbContext(options))
            {
                // 트랜잭션 관련 코드는 InMemoryDatabase 공급자에서 지원안함
                //using (var transaction = context.Database.BeginTransaction()) { transaction.Commit(); }
                // [A] Arrange
                var repository = new NoticeRepository(context, factory);
                var model      = new BoardNotices {
                    Name = "[2] 홍길동", Title = "공지사항입니다 2", Content = "내용입니다 2"
                };                                                                                                // Id: 2

                // [B] Act
                await repository.AddAsync(model);

                await repository.AddAsync(new BoardNotices { Name = "[3] 백두산", Title = "공지사항입니다 3", Content = "내용입니다 3" });       // Id: 3
            }
            using (var context = new NoticeAppDbContext(options))
            {
                // [C] Assert
                var repository = new NoticeRepository(context, factory);
                var models     = await repository.GetAllAsync();

                Assert.AreEqual(3, models.Count());
            }

            #endregion

            #region [3] GetByIdAsync() Method test
            // [3] GetByIdAsync() Method test
            using (var context = new NoticeAppDbContext(options))
            {
                // Empty
            }
            using (var context = new NoticeAppDbContext(options))
            {
                var repository = new NoticeRepository(context, factory);
                var model      = await repository.GetByIdAsync(2);

                Assert.IsTrue(model.Name.Contains("길동"));
                Assert.AreEqual("[2] 홍길동", model.Name);
            }

            #endregion

            #region [4] EditAsync() Method test
            // [4] EditAsync() Method test
            using (var context = new NoticeAppDbContext(options))
            {
            }

            using (var context = new NoticeAppDbContext(options))
            {
                var repository = new NoticeRepository(context, factory);
                var model      = await repository.GetByIdAsync(2);

                model.Name = "[2] 임꺽정";
                await repository.EditAsync(model);

                var updateModel = await repository.GetByIdAsync(2);

                Assert.IsTrue(updateModel.Name.Contains("꺽정"));
                Assert.AreEqual("[2] 임꺽정", updateModel.Name);
                Assert.AreEqual("[2] 임꺽정",
                                (await context.BoardNotices.Where(m => m.Id == 2).SingleOrDefaultAsync())?.Name);
            }
            #endregion

            #region [5] DeleteAsync() Method test
            // [5] DeleteAsync() Method test
            using (var context = new NoticeAppDbContext(options))
            {
            }

            using (var context = new NoticeAppDbContext(options))
            {
                var repository = new NoticeRepository(context, factory);
                await repository.DeleteAsync(2);

                Assert.AreEqual(2, (await context.BoardNotices.CountAsync()));
                Assert.IsNull(await repository.GetByIdAsync(2));
            }
            #endregion

            #region [6] GetAllAsync(PagingAsync) Method test

            using (var context = new NoticeAppDbContext(options))
            {
            }

            using (var context = new NoticeAppDbContext(options))
            {
                int pageIndex = 0;
                int pageSize  = 1;

                var repository = new NoticeRepository(context, factory);
                var articleSet = await repository.GetAllAsync(pageIndex, pageSize);

                var firstName   = articleSet.Records.FirstOrDefault()?.Name;
                var recordCount = articleSet.TotalRecords;
                Assert.AreEqual("[3] 백두산", firstName);
                Assert.AreEqual(2, recordCount);
            }
            #endregion

            #region [7] GetStatus() Method test
            //[7] GetStatus() Method test
            using (var context = new NoticeAppDbContext(options))
            {
                int parentId = 1;

                var no1 = await context.BoardNotices.Where(m => m.Id == 1).SingleOrDefaultAsync();

                no1.ParentId = parentId;
                no1.IsPinned = true; // 공지글 설정

                context.Entry(no1).State = EntityState.Modified;
                context.SaveChanges();

                var repository = new NoticeRepository(context, factory);
                var r          = await repository.GetStatus(parentId);

                Assert.AreEqual(1, r.Item1);    // Pinned Count == 1
            }
            #endregion
        }
Exemplo n.º 27
0
 public NoticeModel()
 {
     _noticeRepository = new NoticeRepository();
 }
Exemplo n.º 28
0
        public void DownloadData(DateTime cutdate)
        {
            Users usr = UserRepository.Details(User.Identity.Name);

            Directory.CreateDirectory(Path.Combine(Server.MapPath("~/Downloads/"), usr.username));
            //Report Initial Notice
            ReportDocument rd = new ReportDocument();

            rd.Load(Path.Combine(Server.MapPath("~/Reports"), "HQP-SLF-034.rpt"));

            ReportDocument rd1 = new ReportDocument();

            rd1.Load(Path.Combine(Server.MapPath("~/Reports"), "HQP-SLF-049.rpt"));


            var er = NoticeRepository.GetEmployer(cutdate.Date, usr.hub_code);
            var em = NoticeRepository.GetMembers(cutdate.Date, er);

            var grp = (from x in em
                       group x by new { x.employerid, x.loan_program } into g
                       select new
            {
                employerid = g.Key.employerid,
                loan_program = g.Key.loan_program
            }).ToList();

            List <Employer> mpl_cal = (from x in grp
                                       group x by new { x.employerid } into g
                                       where g.Count() > 1
                                       select new Employer()
            {
                employerid = g.Key.employerid,
            }).ToList();
            var mpl   = em.Where(a => a.loan_program == "MPL").Select(b => b.start_term).Max().ToString("MMMM dd, yyyy");
            var cal   = em.Where(a => a.loan_program == "CAL").Select(b => b.start_term).Max().ToString("MMMM dd, yyyy");
            var query =
                from c in grp
                where !(from o in mpl_cal
                        select o.employerid)
                .Contains(c.employerid)
                select c;

            foreach (var i in mpl_cal)
            {
                er.Where(a => a.employerid == i.employerid).ToList().ForEach(b =>
                {
                    b.mpl = mpl;
                    b.cal = cal;
                });
            }
            foreach (var j in query)
            {
                if (j.loan_program == "CAL")
                {
                    er.Where(a => a.employerid == j.employerid).ToList().ForEach(b =>
                    {
                        b.mpl = null;
                        b.cal = cal;
                    });
                }
                else
                {
                    er.Where(a => a.employerid == j.employerid).ToList().ForEach(b =>
                    {
                        b.mpl = mpl;
                        b.cal = null;
                    });
                }
            }
            using (ZipFile z = new ZipFile())
            {
                z.UseZip64WhenSaving       = Zip64Option.AsNecessary;
                z.ParallelDeflateThreshold = -1;
                //Employer Notice
                foreach (var ier in er)
                {
                    var employerList = new List <Employer> {
                        ier
                    };
                    employerList.ToList().ForEach(i => i.statement_date = cutdate.AddDays(1));
                    rd.SetDataSource(employerList);

                    //rd.ExportToDisk(ExportFormatType.PortableDocFormat, Path.Combine(Server.MapPath("~/Reports"), item.pagibig_erid+".pdf"));
                    Stream stream_employer = rd.ExportToStream(ExportFormatType.PortableDocFormat);
                    string output_employer = Regex.Replace(ier.eyername, @"[^0-9a-zA-Z]+", "_");
                    output_employer = output_employer + "_" + ier.pagibig_erid + "_ER";

                    //rd.ExportToDisk(ExportFormatType.PortableDocFormat, Path.Combine(Server.MapPath("~/Downloads/"),  usr.username +"/" + output_employer +".pdf"));
                    z.AddEntry(output_employer + ".pdf", stream_employer);
                    //System.IO.File.Delete(output_employer + ".pdf");
                    stream_employer.Seek(0, SeekOrigin.Begin);

                    //List<Members> memberList = em.Where(a => a.employerid == ier.employerid).ToList();
                    List <Members> memberList = (from c in em
                                                 where c.employerid == employerList.FirstOrDefault().employerid
                                                 select c).ToList();

                    //Test(rd1,employerList,memberList,z);
                    rd1.Database.Tables[0].SetDataSource(er);
                    rd1.Database.Tables[1].SetDataSource(memberList);

                    Stream stream_member = rd1.ExportToStream(ExportFormatType.PortableDocFormat);
                    string output_member = Regex.Replace(ier.eyername, @"[^0-9a-zA-Z]+", "_");
                    output_member = output_member + "_" + ier.pagibig_erid + "_BS";
                    //rd1.ExportToDisk(ExportFormatType.PortableDocFormat, Path.Combine(Server.MapPath("~/Downloads/"),usr.username + "/" + output_member + ".pdf"));
                    //z.AddItem(Path.Combine(Server.MapPath("~/Downloads/"), usr.username + "/" + output_member + ".pdf"));
                    z.AddEntry(output_member + ".pdf", stream_member);
                    //System.IO.File.Delete(output_member + ".pdf");
                    stream_member.Seek(0, SeekOrigin.Begin);
                }
                z.Save(Path.Combine(Server.MapPath("~/Downloads/"), usr.username + "/" + usr.username + ".zip"));
            }



            rd.Close();
            rd.Dispose();
            rd1.Close();
            rd1.Dispose();

            //Session["ip"] = filename;

            //return File(Path.Combine(Server.MapPath("~/Downloads"),"test.zip"),"application/zip",  "test.zip");



            //rd.SetParameterValue("billing_date", DateTime.Now.ToString("MMMM dd, yyyy"));
            //rd.SetParameterValue("subject", "Initial Billing Statement & Notice for the period of " + Convert.ToDateTime(TempData["datefrom"]).ToString("MMMM dd, yyyy") + " to " + Convert.ToDateTime(TempData["dateto"]).ToString("MMMM dd, yyyy"));
            //rd.SetParameterValue("mailing_date", DateTime.Now.ToString("MMMM dd, yyyy"));

            //rd.SetParameterValue("signatory", TempData["signatory"].ToString());
            //rd.SetParameterValue("date_from_to", Convert.ToDateTime(TempData["datefrom"]).ToString("MMMM dd") + "-" + Convert.ToDateTime(TempData["dateto"]).ToString("dd yyyy"));



            //return new FileStreamResult(stream, "application/pdf");
            //Stream stream = rd.ExportToDisk(ExportFormatType.PortableDocFormat,"tst.pdf");
            //stream.Seek(0, SeekOrigin.Begin);
            //rd.Close();
            //rd.Dispose();
            //GC.Collect();
            //return new FileStreamResult(stream, "application/pdf");
        }
Exemplo n.º 29
0
 public SysNoticeController()
 {
     noticeRepository = ClassInstance <NoticeRepository> .Instance;
 }
Exemplo n.º 30
0
 public void initialize()
 {
     noticeRepo = new NoticeRepository();
 }