コード例 #1
0
        public ActionResult Searche(String query, int?pageIndex, Guid id)
        {
            var countElementPage      = 10;
            ExpanseRepositery expRepo = new ExpanseRepositery();
            var expanses = expRepo.getSerachingExpanses(query, id);
            List <ExpansesModel> expanseModel = new List <ExpansesModel>();

            ViewData["idExpanseReport"] = id;
            foreach (var exp in expanses)
            {
                ExpansesModel       expanse        = new ExpansesModel();
                CustomersModel      customer       = new CustomersModel();
                ExpanseTypesModel   expType        = new ExpanseTypesModel();
                ExpanseReportsModel expanseRapport = new ExpanseReportsModel();
                ProjectsModel       projet         = new ProjectsModel();
                expanse.Expanse_ID     = exp.Expanse_ID;
                expanse.Amount_HT      = exp.Amount_HT;
                expanse.Amount_TTC     = exp.Amount_TTC;
                expanse.Amount_TVA     = exp.Amount_TVA;
                customer.Name          = expRepo.GetByIdCutomer(exp.Customer_ID).Name;
                projet.Name            = expRepo.GetByIdProjects(exp.Project_ID).Name;
                expType.Name           = expRepo.GetByIdExpanseTypes(exp.ExpanseType_ID).Name;
                expanseRapport.Year    = expRepo.GetByIdExpansesRepport(exp.ExpanseReport_ID).Year;
                expanse.Customers      = customer;
                expanse.Projects       = projet;
                expanse.ExpanseReports = expanseRapport;
                expanse.ExpanseTypes   = expType;
                expanseModel.Add(expanse);
            }
            IQueryable <ExpansesModel>    listCust = expanseModel.AsQueryable();
            PaginatedList <ExpansesModel> lst      = new PaginatedList <ExpansesModel>(listCust, pageIndex, countElementPage);

            return(View("AllExpanses", lst));
        }
コード例 #2
0
        public ActionResult AllExpanses(int?pageIndex, Guid idExpanseReport)
        {
            ExpanseRepositery expRepo = new ExpanseRepositery();
            double            ttc     = 0;
            double            tva     = 0;
            double            ht      = 0;

            var countElementPage = 10;
            var expanses         = expRepo.GetAllByIdExpansesRepport(idExpanseReport);

            ViewData["idExpanseReport"] = idExpanseReport;
            List <ExpansesModel> expanseModel = new List <ExpansesModel>();

            foreach (var exp in expanses)
            {
                tva = tva + exp.Amount_TVA;
                ht  = ht + exp.Amount_HT;
                ttc = ttc + exp.Amount_TTC;
                ExpansesModel       expanse        = new ExpansesModel();
                CustomersModel      customer       = new CustomersModel();
                ExpanseTypesModel   expType        = new ExpanseTypesModel();
                ExpanseReportsModel expanseRapport = new ExpanseReportsModel();
                ProjectsModel       projet         = new ProjectsModel();
                expanseRapport.ExpanseReport_ID = idExpanseReport;
                expanse.ExpanseReport_ID        = exp.Expanse_ID;
                expanse.Expanse_ID     = exp.Expanse_ID;
                expanse.Amount_HT      = exp.Amount_HT;
                expanse.Amount_TTC     = exp.Amount_TTC;
                expanse.Amount_TVA     = exp.Amount_TVA;
                expanse.Day            = exp.Day;
                customer.Name          = expRepo.GetByIdCutomer(exp.Customer_ID).Name;
                projet.Name            = expRepo.GetByIdProjects(exp.Project_ID).Name;
                expType.Name           = expRepo.GetByIdExpanseTypes(exp.ExpanseType_ID).Name;
                expanseRapport.Year    = expRepo.GetByIdExpansesRepport(exp.ExpanseReport_ID).Year;
                expanse.Customers      = customer;
                expanse.Projects       = projet;
                expanse.ExpanseReports = expanseRapport;
                expanse.ExpanseTypes   = expType;
                expanseModel.Add(expanse);
            }
            ExpanseRepportRepositery expRapRep = new ExpanseRepportRepositery();
            ExpanseReports           expRap    = expRapRep.GetById(idExpanseReport);

            expRapRep.updateExpanseReports(expRap, ttc, ht, tva);
            ViewData["idExpanseReport"] = idExpanseReport;
            IQueryable <ExpansesModel>    listExpanse = expanseModel.AsQueryable();
            PaginatedList <ExpansesModel> lst         = new PaginatedList <ExpansesModel>(listExpanse, pageIndex, countElementPage);

            return(View("AllExpanses", lst));
        }