public ActionResult createExpanseReportsDateDay(String userName) { ViewData["userName"] = userName; ViewData["month"] = Convert.ToInt32(Request.Form["Month"]); ViewData["year"] = Convert.ToInt32(Request.Form["Year"]); int mois = Convert.ToInt32(Request.Form["Month"]); var userId = User.Identity.GetUserId(); ExpanseRepportRepositery expRepRepo = new ExpanseRepportRepositery(); EmployesRepositery empRepository = new EmployesRepositery(); ExpanseReports exp = new ExpanseReports(); var idEmployer = empRepository.GetByIdUser(userId).Employee_ID; var actor_id = idEmployer; exp.ExpanseReport_ID = Guid.NewGuid(); exp.CreationDate = DateTime.Now; exp.Year = Convert.ToInt32(Request.Form["Year"]); exp.Month = mois; exp.StatusCode = Convert.ToInt32(00); exp.ManagerValidationDate = Convert.ToDateTime(Request.Form["CreationDate"]); exp.ManagerComment = Convert.ToString(" no comment"); exp.AccountingValidatationDate = Convert.ToDateTime(Request.Form["CreationDate"]); exp.AccountingComment = Convert.ToString(" no comment"); exp.Total_HT = Convert.ToDouble(0); exp.Total_TTC = Convert.ToDouble(0); exp.Total_TVA = Convert.ToDouble(0); exp.Employee_ID = idEmployer; exp.Author_ID = actor_id; expRepRepo.AddExpansesReports(exp); return(RedirectToAction("AllExpanses", "Expanses", new { idExpanseReport = exp.ExpanseReport_ID })); }
public ActionResult Delete(Guid id) { ExpanseRepportRepositery expRep = new ExpanseRepportRepositery(); ExpanseReports expReport = expRep.GetById(id); expRep.Delete(expReport); expRep.Save(); return(RedirectToAction("AllExpansesReports")); }
public ActionResult annulExpanseReports(Guid idExpanseReport) { ExpanseRepportRepositery expRepRep = new ExpanseRepportRepositery(); ExpanseReports expRep = expRepRep.GetById(idExpanseReport); String managerComment = "no comment"; String comtableComment = "no comment"; int StatusCode = 35; expRepRep.updateStatus(expRep, StatusCode, managerComment, comtableComment); return(RedirectToAction("AllExpansesReports")); }
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)); }
public ActionResult Delete(Guid id) { ExpanseRepositery expRepo = new ExpanseRepositery(); ExpanseRepportRepositery expRapRep = new ExpanseRepportRepositery(); Expanses exp = expRepo.GetById(id); Guid idExpRapo = exp.ExpanseReport_ID; ExpanseReports expReport = expRapRep.GetById(idExpRapo); double ttc = expReport.Total_TTC - exp.Amount_TTC; double ht = expReport.Total_HT - exp.Amount_HT; double tva = expReport.Total_TVA - exp.Amount_TVA; expRapRep.updateExpanseReports(expReport, ttc, ht, tva); expRepo.Delete(exp); expRepo.Save(); return(RedirectToAction("AllExpanses", new { idExpanseReport = idExpRapo })); }
public ActionResult Delete(Guid id) { ProjetRepositery prjtRepo = new ProjetRepositery(); Projects project = prjtRepo.GetById(id); ExpanseRepositery expRep = new ExpanseRepositery(); ExpanseRepportRepositery expRepRep = new ExpanseRepportRepositery(); List <Expanses> expList = expRep.GetByProject(id).ToList(); foreach (var expanse in expList) { expRep.Delete(expanse); } expRep.Save(); prjtRepo.Delete(project); prjtRepo.Save(); return(RedirectToAction("AllProjets")); }
public ActionResult modifCommentExpanseReports(Guid idExpanseReport) { ExpanseRepportRepositery expRepRep = new ExpanseRepportRepositery(); ExpanseReports expRep = expRepRep.GetById(idExpanseReport); String managerComment = "no comment"; String comtableComment = "no comment"; int StatusCode = 15; managerComment = Convert.ToString(Request.Form["ManagerComment"]); if (User.IsInRole("Comptable")) { StatusCode = 25; comtableComment = Convert.ToString(Request.Form["ManagerComment"]); managerComment = "no comment"; } expRepRep.updateStatus(expRep, StatusCode, managerComment, comtableComment); return(RedirectToAction("AllExpansesReportsToValid")); }
public ActionResult validateExpanseReportByAdminOrManager(Guid id) { ExpanseRepportRepositery expRep = new ExpanseRepportRepositery(); String managerComment = "no comment"; String comtableComment = "no comment"; int StatusCode = 10; ExpanseReports expReport = expRep.GetById(id); if (User.IsInRole("Manager")) { StatusCode = 20; expRep.updateStatus(expReport, StatusCode, managerComment, comtableComment); return(RedirectToAction("AllExpansesReportsToValid")); } else if (User.IsInRole("Comptable")) { StatusCode = 30; expRep.updateStatus(expReport, StatusCode, managerComment, comtableComment); return(RedirectToAction("AllExpansesReportsToValid")); } expRep.updateStatus(expReport, StatusCode, managerComment, comtableComment); return(RedirectToAction("AllExpansesReportsToValid")); }
public ActionResult Delete(Guid id) { PolesRepository poleRep = new PolesRepository(); ProjetRepositery prjtRepo = new ProjetRepositery(); ExpanseRepositery expRep = new ExpanseRepositery(); EmployesRepositery empRepo = new EmployesRepositery(); ExpanseRepportRepositery expRepRep = new ExpanseRepportRepositery(); List <Projects> projets = prjtRepo.GetByIdPole(id).ToList(); foreach (var pro in projets) { List <Expanses> expList = expRep.GetByProject(pro.Project_ID).ToList(); foreach (var expanse in expList) { expRep.Delete(expanse); } expRep.Save(); prjtRepo.Delete(pro); } prjtRepo.Save(); foreach (var empl in empRepo.getByIdPole(id)) { List <ExpanseReports> expanseReports = expRepRep.GetByEmployesId(empl.Employee_ID).ToList(); foreach (var expRepo in expanseReports) { expRepRep.Delete(expRepo); } expRepRep.Save(); empRepo.Delete(empl); } empRepo.Save(); Poles pole = poleRep.GetById(id); poleRep.Delete(pole); poleRep.Save(); return(RedirectToAction("AllPoles")); }
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)); }