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)); }
public ActionResult modifExpanseReports(Guid idExpanseReport) { ExpanseRepportRepositery expRepRep = new ExpanseRepportRepositery(); ExpanseReports expRep = expRepRep.GetById(idExpanseReport); ExpanseReportsModel expRepModel = new ExpanseReportsModel(); expRepModel.ExpanseReport_ID = expRep.ExpanseReport_ID; expRepModel.Author_ID = expRep.Author_ID; expRepModel.ManagerComment = expRep.ManagerComment; return(PartialView("_modifExpanseReports", expRepModel)); }
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)); }
public ActionResult AllExpansesReports(int?pageIndex) { var userId = User.Identity.GetUserId(); EmployesRepositery empRepository = new EmployesRepositery(); if (empRepository.GetByIdUser(userId) == null) { ViewData["erreurMessage"] = "Vouns ĂȘtes pas encore Employer"; return(View("ErrorEmptyList")); } var idEmployer = empRepository.GetByIdUser(userId).Employee_ID; ExpanseRepportRepositery expRepRepo = new ExpanseRepportRepositery(); var countElementPage = 10; var expansesReports = expRepRepo.allExpanseReports(idEmployer); List <ExpanseReportsModel> expanseReportModelList = new List <ExpanseReportsModel>(); if (expansesReports.Count() == 0) { ViewData["erreurMessage"] = "Vouns n'avez aucune note de frais"; ViewData["element"] = "ExpanseReports"; ViewData["create"] = "false"; return(View("ErrorEmptyList")); } foreach (var exp in expansesReports) { ExpanseReportsModel expReportModel = new ExpanseReportsModel(); EmployeesModel employer = new EmployeesModel(); expReportModel.ExpanseReport_ID = exp.ExpanseReport_ID; employer.FirstName = expRepRepo.GetByIdEmployes(exp.Employee_ID).FirstName; expReportModel.Employees = employer; expReportModel.CreationDate = exp.CreationDate; expReportModel.Year = exp.Year; expReportModel.Month = exp.Month; expReportModel.StatusCode = exp.StatusCode; expReportModel.ManagerValidationDate = exp.ManagerValidationDate; expReportModel.ManagerComment = exp.ManagerComment; expReportModel.AccountingValidatationDate = exp.AccountingValidatationDate; expReportModel.AccountingComment = exp.AccountingComment; expReportModel.Total_HT = exp.Total_HT; expReportModel.Total_TTC = exp.Total_TTC; expReportModel.Total_TVA = exp.Total_TVA; expanseReportModelList.Add(expReportModel); } IQueryable <ExpanseReportsModel> listExpanseReports = expanseReportModelList.AsQueryable(); PaginatedList <ExpanseReportsModel> lst = new PaginatedList <ExpanseReportsModel>(listExpanseReports, pageIndex, countElementPage); return(View("MyExpanseReports", lst)); }
// GET: Expanses public PartialViewResult Index(String userName) { var userId = User.Identity.GetUserId(); EmployesRepositery empRepository = new EmployesRepositery(); ViewData["employer"] = "false"; if (empRepository.GetByIdUser(userId) == null) { ViewData["employer"] = "true"; } ViewData["userName"] = userName; ExpanseReportsModel model = new ExpanseReportsModel(); model.Year = DateTime.Now.Year; return(PartialView("_MonthYear", model)); }
public ActionResult Searche(String query, int?pageIndex) { EmployesRepositery empRepository = new EmployesRepositery(); var userId = User.Identity.GetUserId(); var idEmployer = empRepository.GetByIdUser(userId).Employee_ID; var countElementPage = 10; ExpanseRepportRepositery expRep = new ExpanseRepportRepositery(); var expanse = expRep.getSerachingExpanseReports(query, idEmployer); List <ExpanseReportsModel> expanseReportModelList = new List <ExpanseReportsModel>(); foreach (var exp in expanse) { ExpanseReportsModel expReportModel = new ExpanseReportsModel(); EmployeesModel employer = new EmployeesModel(); expReportModel.ExpanseReport_ID = exp.ExpanseReport_ID; employer.FirstName = expRep.GetByIdEmployes(exp.Employee_ID).FirstName; expReportModel.Employees = employer; expReportModel.CreationDate = exp.CreationDate; expReportModel.Year = exp.Year; expReportModel.Month = exp.Month; expReportModel.StatusCode = exp.StatusCode; expReportModel.ManagerValidationDate = exp.ManagerValidationDate; expReportModel.ManagerComment = exp.ManagerComment; expReportModel.AccountingValidatationDate = exp.AccountingValidatationDate; expReportModel.AccountingComment = exp.AccountingComment; expReportModel.Total_HT = exp.Total_HT; expReportModel.Total_TTC = exp.Total_TTC; expReportModel.Total_TVA = exp.Total_TVA; expanseReportModelList.Add(expReportModel); } IQueryable <ExpanseReportsModel> listCust = expanseReportModelList.AsQueryable(); PaginatedList <ExpanseReportsModel> lst = new PaginatedList <ExpanseReportsModel>(listCust, pageIndex, countElementPage); return(View("MyExpanseReports", lst)); }