public ActionResult AccountList(string type)
{
using (WakilRecouvContext WakilContext = new WakilRecouvContext())
{
using (UnitOfWork UOW = new UnitOfWork(WakilContext))
{
EmployeService EmpService = new EmployeService(UOW);
RoleService RoleService = new RoleService(UOW);
var Roles = RoleService.GetAll();
ViewBag.RoleList = new SelectList(Roles, "RoleId", "role");
if (type == "0")
{
return(View(EmpService.GetAll()));
}
else if (type == "1")
{
return(View(EmpService.GetEmployeByVerified(true)));
}
else if (type == "2")
{
return(View(EmpService.GetEmployeByVerified(false)));
}
else
{
return(View(EmpService.GetAll()));
}
}
}
}
//INSERT LIVRAISON
public ActionResult Livraison(int empStock, int employe, int quantite,
int resteNonVendu, string dateLivraison, int pointDeVente)
{
//Insertion livraison
livraisonCarteService = new LivraisonCarteService();
empStockService = new EmployeStockService();
empService = new EmployeService();
Employe emp = new Employe(employe);
PointDeVente pointVente = new PointDeVente(pointDeVente);
EmployeStock employeStock = new EmployeStock(empStock);
DateTime date = DateTime.Parse(dateLivraison);
LivraisonCarte livCarte = new LivraisonCarte(employeStock, quantite, resteNonVendu,
date, pointVente);
livraisonCarteService.insert(livCarte);
//Update stock
EmployeStockVue emplStock = empStockService.findById(empStock);
Debug.WriteLine("Emp stock update " + emplStock.Stock + "-" + empStock);
int stockUpdate = emplStock.Stock - quantite;
EmployeStock empStockUpdate = new EmployeStock(emplStock.Id, stockUpdate);
empStockService.update(empStockUpdate);
//GET ALL STOCK
EmployeVue empl = empService.findById(employe);
List <EmployeStockVue> listAll = empStockService.search(new EmployeStockVue(empl.Nom, emp.Prenom));
ViewBag.listStock = listAll;
return(View());
}
public void GetListEmployesTest()
{
var entrepriseService = new EmployeService(new MockStorage());
var employes = entrepriseService.GetListEmployes();
Assert.AreEqual(employes.Count, 2);
}
public ActionResult ChangePassword(CompteConfigViewModel CompteCVM)
{
using (WakilRecouvContext WakilContext = new WakilRecouvContext())
{
using (UnitOfWork UOW = new UnitOfWork(WakilContext))
{
RoleService RoleService = new RoleService(UOW);
EmployeService EmpService = new EmployeService(UOW);
Employe e = EmpService.GetEmployeByUername(Session["username"].ToString());
if (e.Password == CompteCVM.Password)
{
e.Password = CompteCVM.NewPassword;
e.ConfirmPassword = CompteCVM.NewPassword;
EmpService.Update(e);
EmpService.Commit();
}
else
{
ModelState.AddModelError("Password", "Votre mot de passe actuel est incorrect");
}
return(View());
}
}
}
public ActionResult InscriptionCompte(Employe emp)
{
using (WakilRecouvContext WakilContext = new WakilRecouvContext())
{
using (UnitOfWork UOW = new UnitOfWork(WakilContext))
{
RoleService RoleService = new RoleService(UOW);
EmployeService EmpService = new EmployeService(UOW);
var Roles = RoleService.GetAll();
ViewBag.RoleList = new SelectList(Roles, "RoleId", "role");
if (EmpService.GetEmployeByUername(emp.Username) != null)
{
ModelState.AddModelError("Username", "Nom d'utilisateur existe deja !");
}
else
{
EmpService.Add(emp);
EmpService.Commit();
return(RedirectToAction("Login"));
}
//Response.Write("<script>alert('" + emp.RoleId + "')</script>");
return(View());
}
}
}
public ActionResult mensuelStatTraite(string year, string month)
{
using (WakilRecouvContext WakilContext = new WakilRecouvContext())
{
using (UnitOfWork UOW = new UnitOfWork(WakilContext))
{
LotService LotService = new LotService(UOW);
FormulaireService FormulaireService = new FormulaireService(UOW);
AffectationService AffectationService = new AffectationService(UOW);
EmployeService EmpService = new EmployeService(UOW);
int mensuelPoste1Tot = 0;
int mensuelPoste2Tot = 0;
int mensuelPoste3Tot = 0;
int mensuelPoste4Tot = 0;
int tot = 0;
double mensuelRentaPoste1Tot = 0;
double mensuelRentaPoste2Tot = 0;
double mensuelRentaPoste3Tot = 0;
double mensuelRentaPoste4Tot = 0;
double totRenta = 0;
List <ClientAffecteViewModel> JoinedList = new List <ClientAffecteViewModel>();
JoinedList = (from f in FormulaireService.GetAll()
join a in AffectationService.GetAll() on f.AffectationId equals a.AffectationId
join l in LotService.GetAll() on a.LotId equals l.LotId
select new ClientAffecteViewModel
{
Formulaire = f,
Affectation = a,
Lot = l,
}).ToList();
if (month != "" && year != "" && month != null && year != null)
{
mensuelPoste1Tot = JoinedList.Where(j => j.Affectation.Employe.Username == "POSTE1" && j.Formulaire.TraiteLe.Date.Year + "" == year && j.Formulaire.TraiteLe.Date.Month + "" == month).Count();
mensuelPoste2Tot = JoinedList.Where(j => j.Affectation.Employe.Username == "POSTE2" && j.Formulaire.TraiteLe.Date.Year + "" == year && j.Formulaire.TraiteLe.Date.Month + "" == month).Count();
mensuelPoste3Tot = JoinedList.Where(j => j.Affectation.Employe.Username == "POSTE3" && j.Formulaire.TraiteLe.Date.Year + "" == year && j.Formulaire.TraiteLe.Date.Month + "" == month).Count();
mensuelPoste4Tot = JoinedList.Where(j => j.Affectation.Employe.Username == "POSTE4" && j.Formulaire.TraiteLe.Date.Year + "" == year && j.Formulaire.TraiteLe.Date.Month + "" == month).Count();
tot = mensuelPoste1Tot + mensuelPoste2Tot + mensuelPoste3Tot + mensuelPoste4Tot;
mensuelRentaPoste1Tot = rentabiliteAgents(year, month, "POSTE1", LotService, FormulaireService, AffectationService);
mensuelRentaPoste2Tot = rentabiliteAgents(year, month, "POSTE2", LotService, FormulaireService, AffectationService);
mensuelRentaPoste3Tot = rentabiliteAgents(year, month, "POSTE3", LotService, FormulaireService, AffectationService);
mensuelRentaPoste4Tot = rentabiliteAgents(year, month, "POSTE4", LotService, FormulaireService, AffectationService);
totRenta = mensuelRentaPoste1Tot + mensuelRentaPoste2Tot + mensuelRentaPoste3Tot + mensuelRentaPoste4Tot;
}
return(Json(new { tot = tot, mensuelPoste1Tot = mensuelPoste1Tot, mensuelPoste2Tot = mensuelPoste2Tot, mensuelPoste3Tot = mensuelPoste3Tot, mensuelPoste4Tot = mensuelPoste4Tot, totRenta = String.Format("{0:0.00}", totRenta), mensuelRentaPoste1Tot = mensuelRentaPoste1Tot, mensuelRentaPoste2Tot = mensuelRentaPoste2Tot, mensuelRentaPoste3Tot = mensuelRentaPoste3Tot, mensuelRentaPoste4Tot = mensuelRentaPoste4Tot }));
}
}
}
protected override void OnInitialized()
{
base.OnInitialized();
var employee = EmployeService.GetEmployee(1);
Id = employee.Id;
Name = employee.Name;
Dept = employee.Dept;
Address = employee.Address;
}
public AddWorkDoneForm(ApplicationDbContext context)
{
dbContext = context;
subjectService = new SubjectService(dbContext);
solidWasteService = new SolidWasteService(dbContext);
argumentService = new ArgumentService(dbContext);
collectService = new CollectService(dbContext);
employeService = new EmployeService(dbContext);
InitializeComponent();
}
public ActionResult UpdateAccount(int id)
{
using (WakilRecouvContext WakilContext = new WakilRecouvContext())
{
using (UnitOfWork UOW = new UnitOfWork(WakilContext))
{
EmployeService EmpService = new EmployeService(UOW);
RoleService RoleService = new RoleService(UOW);
var Roles = RoleService.GetAll();
ViewBag.RoleList = new SelectList(Roles, "RoleId", "role");
return(View(EmpService.GetById(id)));
}
}
}
//
// GET: /Accueil/
public ActionResult Index(string id, string utilisateur)
{
distribCarteService = new DistributionCarteService();
carteService = new CarteService();
empService = new EmployeService();
typeEmployeService = new TypeEmployeService();
List <DistributionCarteVue> listCarteDistribue = distribCarteService.getAll();
List <Carte> listCarte = carteService.getAll();
TypeEmploye typEmp = typeEmployeService.findById(3);
Employe emp = new Employe(typEmp);
List <EmployeVue> listEmp = new EmployeDAO().search(emp);
ViewBag.ListeCarteDistr = listCarteDistribue;
ViewBag.ListeCarte = listCarte;
ViewBag.ListEmp = listEmp;
return(View());
}
public ActionResult Index(int id)
{
empStockService = new EmployeStockService();
empService = new EmployeService();
pointDeVenteService = new PointDeVenteService();
List <EmployeVue> listEmploye = empService.getAll();
List <PointDeVenteVue> listPointDeVente = pointDeVenteService.getAll();
ViewBag.listEmploye = listEmploye;
ViewBag.listPointVente = listPointDeVente;
EmployeVue emp = empService.findById(id);
List <EmployeStockVue> listAll = empStockService.search(new EmployeStockVue(emp.Nom, emp.Prenom));
ViewBag.listStock = listAll;
return(View());
}
public IEnumerable <SelectListItem> AgentListForDropDown(EmployeService EmpService)
{
List <Employe> agents = EmpService.GetMany(emp => emp.Role.role.Equals("agent") && emp.IsVerified == true).ToList();
List <SelectListItem> listItems = new List <SelectListItem>();
listItems.Add(new SelectListItem {
Selected = true, Text = "Tous les agents", Value = "0"
});
agents.ForEach(l =>
{
listItems.Add(new SelectListItem {
Text = l.Username, Value = l.EmployeId + ""
});
});
return(listItems);
}
// Add card
public ActionResult InsertCard(int carte, int employe, int quantite, string date)
{
//instanciation des services
distribCarteService = new DistributionCarteService();
empStockService = new EmployeStockService();
empService = new EmployeService();
carteService = new CarteService();
employeStockHistoService = new EmployeStockHistoService();
//instanciation objet depuis argument
Carte c = new Carte(carte);
Employe emp = new Employe(employe);
DateTime dateTime = DateTime.Parse(date);
EmployeVue employee = empService.findById(employe);
Carte cartee = carteService.findById(carte);
//instanciation distribution carte
DistributionCarte carteDist = new DistributionCarte(c, emp, quantite, dateTime);
//Recherche du stock de l'employe actuelle
EmployeStockVue empStockActu = new EmployeStockVue();
empStockActu.Carte = cartee.Libelle;
empStockActu.Nom = employee.Nom;
List <EmployeStockVue> listEmpStockActu = empStockService.search(empStockActu);
//insertion de la distribution
distribCarteService.insert(carteDist);
//mise a jour du stock du coursier
int stock = listEmpStockActu[0].Stock + quantite;
empStockService.update(new EmployeStock(employe, stock, carte));
//insertion du nouveau stock du coursier
employeStockHistoService.insert(new EmployeStockHisto(employe, quantite, carte));
//Recherche liste carte distribue
List <DistributionCarteVue> listCarteDistr = distribCarteService.getAll();
ViewBag.ListCarteDistr = listCarteDistr;
return(View());
}
public IEnumerable <SelectListItem> AgentListForDropDown()
{
using (WakilRecouvContext WakilContext = new WakilRecouvContext())
{
using (UnitOfWork UOW = new UnitOfWork(WakilContext))
{
EmployeService EmpService = new EmployeService(UOW);
List <Employe> agents = EmpService.GetMany(emp => emp.Role.role.Equals("agent") && emp.IsVerified == true).ToList();
List <SelectListItem> listItems = new List <SelectListItem>();
agents.ForEach(l => {
listItems.Add(new SelectListItem {
Text = l.Username, Value = l.EmployeId + ""
});
});
return(listItems);
}
}
}
public ActionResult Login(Compte compte)
{
using (WakilRecouvContext WakilContext = new WakilRecouvContext())
{
using (UnitOfWork UOW = new UnitOfWork(WakilContext))
{
EmployeService EmpService = new EmployeService(UOW);
Employe emp = EmpService.GetEmployeByUername(compte.Username);
if (emp == null)
{
ModelState.AddModelError("Username", "Nom d'utilisateur inexistant");
}
else if (emp != null)
{
if (emp.Password == compte.Password)
{
if (emp.IsVerified == false)
{
ModelState.AddModelError("Connect", "Votre compte n'est pas encore validé par un administrateur");
}
else if (emp.IsVerified == true)
{
Session["username"] = emp.Username;
Session["role"] = emp.Role.role;
return(RedirectToAction("Index", "Home"));
}
}
else
{
ModelState.AddModelError("Password", "Mot de passe incorrect");
}
}
return(View());
}
}
}
public ActionResult Renseigner(int?page)
{
using (WakilRecouvContext WakilContext = new WakilRecouvContext())
{
using (UnitOfWork UOW = new UnitOfWork(WakilContext))
{
LettreService lettreService = new LettreService(UOW);
LotService LotService = new LotService(UOW);
EmployeService EmployeService = new EmployeService(UOW);
List <Lettre> lettreList = lettreService.GetAll().OrderByDescending(f => f.DateExtrait).ToList();
ViewData["list"] = new SelectList(NumLotListForDropDown(LotService), "Value", "Text");
ViewBag.AgentList = new SelectList(AgentListForDropDown(EmployeService), "Value", "Text");
ViewBag.total = lettreList.Count();
int pageSize = 10;
int pageNumber = (page ?? 1);
return(View(lettreList.ToPagedList(pageNumber, pageSize)));
}
}
}
public ActionResult Create([Bind(Include = "IdEmploye,Matricule,NomComplet,DateEmbauche,IdPoste,IdDepartement,Actif,Ville,Email,Telephone")] Employe employe)
{
if (ModelState.IsValid)
{
var employeService = new EmployeService();
if (!employeService.Exist(employe.Matricule))
{
var employeRepository = new EmployeRepository();
employeRepository.AddEmploye(employe);
return(RedirectToAction("Index"));
}
else
{
ModelState.AddModelError("Matricule", "Ce matricule existe déjà");
}
}
ViewBag.IdDepartement = new SelectList(db.Departement, "IdDepartement", "NomDepartement", employe.IdDepartement);
ViewBag.IdPoste = new SelectList(db.Poste, "IdPoste", "NomPoste", employe.IdPoste);
return(View(employe));
}
public DataTable GenerateDatatableFromJoinedList(List <ClientCompte> list)
{
using (WakilRecouvContext WakilContext = new WakilRecouvContext())
{
using (UnitOfWork UOW = new UnitOfWork(WakilContext))
{
LotService LotService = new LotService(UOW);
FormulaireService FormulaireService = new FormulaireService(UOW);
AffectationService AffectationService = new AffectationService(UOW);
EmployeService EmpService = new EmployeService(UOW);
List <ClientCompte> newList = new List <ClientCompte>();
DataTable dataTable = new DataTable();
newList = list.Select(j =>
new ClientCompte
{
Nom = j.Nom,
Compte = j.Compte
}).ToList();
dataTable.Columns.Add("Nom", typeof(string));
dataTable.Columns.Add("Compte", typeof(string));
foreach (ClientCompte c in newList)
{
DataRow row = dataTable.NewRow();
row["Nom"] = c.Nom;
row["Compte"] = c.Compte;
dataTable.Rows.Add(row);
}
Debug.WriteLine("---->" + dataTable.Rows.Count);
return(dataTable);
}
}
}
public ActionResult updateLot(int id)
{
using (WakilRecouvContext WakilContext = new WakilRecouvContext())
{
using (UnitOfWork UOW = new UnitOfWork(WakilContext))
{
LotService LotService = new LotService(UOW);
AffectationService AffectationService = new AffectationService(UOW);
EmployeService EmpService = new EmployeService(UOW);
ViewData["list"] = new SelectList(NumLotListForDropDown(), "Value", "Text");
ViewData["agent"] = new SelectList(AgentListForDropDown(), "Value", "Text");
//Lot lot = LotService.GetById(id);
ClientAffecteViewModel cavm = new ClientAffecteViewModel();
cavm = (from a in AffectationService.GetAll()
join l in LotService.GetAll() on a.LotId equals l.LotId
where l.LotId == id
select new ClientAffecteViewModel
{
Affectation = a,
Lot = l
}).FirstOrDefault();
if (cavm == null)
{
cavm = new ClientAffecteViewModel();
Lot lot = LotService.GetById(id);
cavm.Lot = lot;
}
return(View(cavm));
}
}
}
public ActionResult UpdateAccount(int id, Employe e)
{
using (WakilRecouvContext WakilContext = new WakilRecouvContext())
{
using (UnitOfWork UOW = new UnitOfWork(WakilContext))
{
EmployeService EmpService = new EmployeService(UOW);
RoleService RoleService = new RoleService(UOW);
var Roles = RoleService.GetAll();
ViewBag.RoleList = new SelectList(Roles, "RoleId", "role");
Employe emp = EmpService.GetById(id);
emp.RoleId = e.RoleId;
emp.IsVerified = e.IsVerified;
emp.ConfirmPassword = emp.Password;
EmpService.Update(emp);
EmpService.Commit();
return(View("AccountList", EmpService.GetAll()));
}
}
}
public HistoriqueController()
{
demandeService = new DemandeService();
employeService = new EmployeService();
}
protected override async Task OnInitializedAsync()
{
employes = (await EmployeService.GetEmployes()).ToList();
}
public AddEmployeForm(ApplicationDbContext context)
{
dbContext = context;
employeService = new EmployeService(dbContext);
InitializeComponent();
}
public CustomAutorizationAttribute()
{
UtilisateurService = new EmployeService(new RoleService());
}
public ActionResult Index()
{
using (WakilRecouvContext WakilContext = new WakilRecouvContext())
{
using (UnitOfWork UOW = new UnitOfWork(WakilContext))
{
EmployeService EmpService = new EmployeService(UOW);
RoleService RoleService = new RoleService(UOW);
AffectationService AffectationService = new AffectationService(UOW);
LotService LotService = new LotService(UOW);
FormulaireService FormulaireService = new FormulaireService(UOW);
List <ClientAffecteViewModel> traiteList = new List <ClientAffecteViewModel>();
List <HomeViewModel> result = new List <HomeViewModel>();
List <Lot> lots = new List <Lot>();
string[] lotsLst = { };
lots = LotService.GetAll().ToList();
lotsLst = lots.DistinctBy(l => l.NumLot).Select(l => l.NumLot).ToArray();
List <Affectation> Affectations = new List <Affectation>();
List <Formulaire> Formulaires = new List <Formulaire>();
string[] agents = { };
Affectations = AffectationService.GetAll().ToList();
Formulaires = FormulaireService.GetAll().OrderByDescending(o => o.TraiteLe).ToList();
foreach (string numlot in lotsLst)
{
lots = LotService.GetAll().Where(l => l.NumLot.Equals(numlot)).ToList();
traiteList = (from f in Formulaires
join a in Affectations on f.AffectationId equals a.AffectationId
join l in lots on a.LotId equals l.LotId
select new ClientAffecteViewModel
{
Formulaire = f,
Affectation = a,
Lot = l,
}).DistinctBy(d => d.Formulaire.AffectationId).ToList();
var agentLinq = (from a in Affectations
join l in lots on a.LotId equals l.LotId
select new ClientAffecteViewModel
{
Affectation = a
});
agents = agentLinq.DistinctBy(a => a.Affectation.Employe.Username).Select(a => a.Affectation.Employe.Username).ToArray();
string agentsStr = string.Join(", ", agents);
float nbAffTotal = agentLinq.Count();
float nbTraite = traiteList.Count();
string avgLot = String.Format("{0:0.00}", (nbTraite / nbAffTotal) * 100);
HomeViewModel homeViewModel = new HomeViewModel
{
agents = agentsStr,
nbAffTotal = nbAffTotal + "",
nbTraite = nbTraite + "",
numLot = numlot,
avancement = avgLot.Replace(",", ".")
};
result.Add(homeViewModel);
}
return(View(result));
}
}
}
public ActionResult StatLot(int numLot, string typeStat, string dateStat, string agent)
{
using (WakilRecouvContext WakilContext = new WakilRecouvContext())
{
using (UnitOfWork UOW = new UnitOfWork(WakilContext))
{
LotService LotService = new LotService(UOW);
FormulaireService FormulaireService = new FormulaireService(UOW);
AffectationService AffectationService = new AffectationService(UOW);
EmployeService EmpService = new EmployeService(UOW);
ViewData["list"] = new SelectList(NumLotListForDropDown(), "Value", "Text");
ViewData["sortOrder"] = new SelectList(TypeStatForDropDown(), "Value", "Text");
ViewBag.AgentList = new SelectList(AgentListForDropDown(), "Value", "Text");
int nb = 0;
int rdv = 0;
int fn = 0;
int versement = 0;
int encours = 0;
string avgRdv = 0 + "";
string avgVers = 0 + "";
string avgFn = 0 + "";
string avgencours = 0 + "";
ViewData["years"] = new SelectList(YearListForDropDown(), "Value", "Text");
ViewData["month"] = new SelectList(MonthListForDropDown(), "Value", "Text");
List <Affectation> affectations = new List <Affectation>();
List <Lot> lots = new List <Lot>();
List <ClientAffecteViewModel> rdvCAVm = new List <ClientAffecteViewModel>();
List <ClientAffecteViewModel> fnCAVm = new List <ClientAffecteViewModel>();
List <ClientAffecteViewModel> versCAVm = new List <ClientAffecteViewModel>();
List <ClientAffecteViewModel> encoursCAVm = new List <ClientAffecteViewModel>();
List <ClientAffecteViewModel> tot = new List <ClientAffecteViewModel>();
if (numLot == 0)
{
tot = (from a in AffectationService.GetAll()
join l in LotService.GetAll() on a.LotId equals l.LotId
select new ClientAffecteViewModel
{
Affectation = a,
Lot = l,
}).ToList();
rdvCAVm = (from f in FormulaireService.GetAll().OrderByDescending(o => o.TraiteLe)
join a in AffectationService.GetAll() on f.AffectationId equals a.AffectationId
join l in LotService.GetAll() on a.LotId equals l.LotId
select new ClientAffecteViewModel
{
Formulaire = f,
Affectation = a,
Lot = l,
}).DistinctBy(d => d.Formulaire.AffectationId).Where(f => f.Formulaire.EtatClient == Note.RDV).ToList();
fnCAVm = (from f in FormulaireService.GetAll().OrderByDescending(o => o.TraiteLe)
join a in AffectationService.GetAll() on f.AffectationId equals a.AffectationId
join l in LotService.GetAll() on a.LotId equals l.LotId
select new ClientAffecteViewModel
{
Formulaire = f,
Affectation = a,
Lot = l,
}).DistinctBy(d => d.Formulaire.AffectationId).Where(f => f.Formulaire.EtatClient == Note.FAUX_NUM).ToList();
versCAVm = (from f in FormulaireService.GetAll().OrderByDescending(o => o.TraiteLe)
join a in AffectationService.GetAll() on f.AffectationId equals a.AffectationId
join l in LotService.GetAll() on a.LotId equals l.LotId
select new ClientAffecteViewModel
{
Formulaire = f,
Affectation = a,
Lot = l,
}).DistinctBy(d => d.Formulaire.AffectationId).Where(f => f.Formulaire.EtatClient == Note.SOLDE_TRANCHE || f.Formulaire.EtatClient == Note.SOLDE).ToList();
encoursCAVm = (from f in FormulaireService.GetAll().OrderByDescending(o => o.TraiteLe)
join a in AffectationService.GetAll() on f.AffectationId equals a.AffectationId
join l in LotService.GetAll() on a.LotId equals l.LotId
select new ClientAffecteViewModel
{
Formulaire = f,
Affectation = a,
Lot = l,
}).DistinctBy(d => d.Formulaire.AffectationId).Where(f => f.Formulaire.EtatClient == Note.REFUS_PAIEMENT || f.Formulaire.EtatClient == Note.RAPPEL || f.Formulaire.EtatClient == Note.RACCROCHE || f.Formulaire.EtatClient == Note.NRP || f.Formulaire.EtatClient == Note.INJOIGNABLE || f.Formulaire.EtatClient == Note.AUTRE || f.Formulaire.EtatClient == Note.A_VERIFIE).ToList();
}
else
{
tot = (from a in AffectationService.GetAll()
join l in LotService.GetAll() on a.LotId equals l.LotId
where l.NumLot == numLot.ToString()
select new ClientAffecteViewModel
{
Affectation = a,
Lot = l,
}).ToList();
rdvCAVm = (from f in FormulaireService.GetAll().OrderByDescending(o => o.TraiteLe)
join a in AffectationService.GetAll() on f.AffectationId equals a.AffectationId
join l in LotService.GetAll() on a.LotId equals l.LotId
where l.NumLot == numLot + ""
select new ClientAffecteViewModel
{
Formulaire = f,
Affectation = a,
Lot = l,
}).DistinctBy(d => d.Formulaire.AffectationId).Where(f => f.Formulaire.EtatClient == Note.RDV).ToList();
fnCAVm = (from f in FormulaireService.GetAll().OrderByDescending(o => o.TraiteLe)
join a in AffectationService.GetAll() on f.AffectationId equals a.AffectationId
join l in LotService.GetAll() on a.LotId equals l.LotId
where l.NumLot == numLot + ""
select new ClientAffecteViewModel
{
Formulaire = f,
Affectation = a,
Lot = l,
}).DistinctBy(d => d.Formulaire.AffectationId).Where(f => f.Formulaire.EtatClient == Note.FAUX_NUM).ToList();
versCAVm = (from f in FormulaireService.GetAll().OrderByDescending(o => o.TraiteLe)
join a in AffectationService.GetAll() on f.AffectationId equals a.AffectationId
join l in LotService.GetAll() on a.LotId equals l.LotId
where l.NumLot == numLot + ""
select new ClientAffecteViewModel
{
Formulaire = f,
Affectation = a,
Lot = l,
}).DistinctBy(d => d.Formulaire.AffectationId).Where(f => f.Formulaire.EtatClient == Note.SOLDE_TRANCHE || f.Formulaire.EtatClient == Note.SOLDE).ToList();
encoursCAVm = (from f in FormulaireService.GetAll().OrderByDescending(o => o.TraiteLe)
join a in AffectationService.GetAll() on f.AffectationId equals a.AffectationId
join l in LotService.GetAll() on a.LotId equals l.LotId
where l.NumLot == numLot + ""
select new ClientAffecteViewModel
{
Formulaire = f,
Affectation = a,
Lot = l,
}).DistinctBy(d => d.Formulaire.AffectationId).Where(f => f.Formulaire.EtatClient == Note.REFUS_PAIEMENT || f.Formulaire.EtatClient == Note.RAPPEL || f.Formulaire.EtatClient == Note.RACCROCHE || f.Formulaire.EtatClient == Note.NRP || f.Formulaire.EtatClient == Note.INJOIGNABLE || f.Formulaire.EtatClient == Note.AUTRE || f.Formulaire.EtatClient == Note.A_VERIFIE).ToList();
}
if (typeStat == "1")
{
nb = tot.Count();
rdv = rdvCAVm.Count();
fn = fnCAVm.Count();
versement = versCAVm.Count();
encours = encoursCAVm.Count();
avgRdv = String.Format("{0:0.00}", ((float)rdv / (float)nb) * 100);
avgFn = String.Format("{0:0.00}", ((float)fn / (float)nb) * 100);
avgVers = String.Format("{0:0.00}", ((float)versement / (float)nb) * 100);
avgencours = String.Format("{0:0.00}", ((float)encours / (float)nb) * 100);
}
else if (typeStat == "2")
{
rdv = rdvCAVm.Where(f => f.Formulaire.TraiteLe.Date == DateTime.Parse(dateStat).Date).Count();
fn = fnCAVm.Where(f => f.Formulaire.TraiteLe.Date == DateTime.Parse(dateStat).Date).Count();
versement = versCAVm.Where(f => f.Formulaire.TraiteLe.Date == DateTime.Parse(dateStat).Date).Count();
encours = encoursCAVm.Where(f => f.Formulaire.TraiteLe.Date == DateTime.Parse(dateStat).Date).Count();
nb = rdv + fn + versement + encours;
avgRdv = String.Format("{0:0.00}", ((float)rdv / (float)nb) * 100);
avgFn = String.Format("{0:0.00}", ((float)fn / (float)nb) * 100);
avgVers = String.Format("{0:0.00}", ((float)versement / (float)nb) * 100);
avgencours = String.Format("{0:0.00}", ((float)encours / (float)nb) * 100);
}
else if (typeStat == "3")
{
rdv = rdvCAVm.Where(a => a.Affectation.EmployeId + "" == agent).Count();
fn = fnCAVm.Where(a => a.Affectation.EmployeId + "" == agent).Count();
versement = versCAVm.Where(a => a.Affectation.EmployeId + "" == agent).Count();
encours = encoursCAVm.Where(a => a.Affectation.EmployeId + "" == agent).Count();
nb = rdv + fn + versement + encours;
avgRdv = String.Format("{0:0.00}", ((float)rdv / (float)nb) * 100);
avgFn = String.Format("{0:0.00}", ((float)fn / (float)nb) * 100);
avgVers = String.Format("{0:0.00}", ((float)versement / (float)nb) * 100);
avgencours = String.Format("{0:0.00}", ((float)encours / (float)nb) * 100);
}
else if (typeStat == "4")
{
rdv = rdvCAVm.Where(a => a.Affectation.EmployeId + "" == agent && a.Formulaire.TraiteLe.Date == DateTime.Parse(dateStat).Date).Count();
fn = fnCAVm.Where(a => a.Affectation.EmployeId + "" == agent && a.Formulaire.TraiteLe.Date == DateTime.Parse(dateStat).Date).Count();
versement = versCAVm.Where(a => a.Affectation.EmployeId + "" == agent && a.Formulaire.TraiteLe.Date == DateTime.Parse(dateStat).Date).Count();
encours = encoursCAVm.Where(a => a.Affectation.EmployeId + "" == agent && a.Formulaire.TraiteLe.Date == DateTime.Parse(dateStat).Date).Count();
nb = rdv + fn + versement + encours;
avgRdv = String.Format("{0:0.00}", ((float)rdv / (float)nb) * 100);
avgFn = String.Format("{0:0.00}", ((float)fn / (float)nb) * 100);
avgVers = String.Format("{0:0.00}", ((float)versement / (float)nb) * 100);
avgencours = String.Format("{0:0.00}", ((float)encours / (float)nb) * 100);
}
StatLot statLot = new StatLot()
{
nb = nb,
rdv = rdv,
fn = fn,
versement = versement,
encours = encours,
avgRdv = avgRdv.Replace(",", "."),
avgFn = avgFn.Replace(",", "."),
avgVers = avgVers.Replace(",", "."),
avgencours = avgencours.Replace(",", ".")
};
return(View("Index", statLot));
}
}
}
public async Task GetEmployeList()
{
EmployeService employeService = new EmployeService();
Employes = await employeService.GetEmployeAsync();
}
public ActionResult ExtraireLettreAction(string numLot, string debutDate, string finDate, string agent)
{
using (WakilRecouvContext WakilContext = new WakilRecouvContext())
{
using (UnitOfWork UOW = new UnitOfWork(WakilContext))
{
FormulaireService FormulaireService = new FormulaireService(UOW);
AffectationService AffectationService = new AffectationService(UOW);
LotService LotService = new LotService(UOW);
LettreService lettreService = new LettreService(UOW);
EmployeService EmployeService = new EmployeService(UOW);
ViewData["list"] = new SelectList(NumLotListForDropDown(LotService), "Value", "Text");
ViewBag.AgentList = new SelectList(AgentListForDropDown(EmployeService), "Value", "Text");
string lettreDir = GetFolderNameForLettre();
DateTime startDate = DateTime.Parse(debutDate);
DateTime endDate = DateTime.Parse(finDate);
if (!Directory.Exists(lettreDir))
{
Directory.CreateDirectory(lettreDir);
}
string lettreDirList = Directory.GetDirectories(lettreDir).Length + 1 + "_" + ((DateTimeOffset)DateTime.UtcNow).ToUnixTimeSeconds() + "";
string dirLettre = "";
if (!Directory.Exists(lettreDir + "/" + lettreDirList))
{
Directory.CreateDirectory(lettreDir + "/" + lettreDirList);
dirLettre = lettreDir + "/" + lettreDirList;
}
List <LettreContent> lettreJoinedList = new List <LettreContent>();
if (numLot == "0")
{
lettreJoinedList = (from f in FormulaireService.GetAll()
join a in AffectationService.GetAll() on f.AffectationId equals a.AffectationId
join l in LotService.GetAll() on a.LotId equals l.LotId
where (f.TraiteLe.Date >= startDate.Date && f.TraiteLe.Date <= endDate.Date) && (f.EtatClient == Note.FAUX_NUM || f.EtatClient == Note.NRP || f.EtatClient == Note.INJOIGNABLE) && lettreIsTrue(FormulaireService, a.AffectationId)
select new LettreContent
{
NumLot = l.NumLot,
Adresse = l.Adresse,
NomClient = l.NomClient,
Agence = l.DescIndustry,
Compte = l.Compte
}).ToList();
if (int.Parse(agent) != 0)
{
lettreJoinedList = (from f in FormulaireService.GetAll()
join a in AffectationService.GetAll() on f.AffectationId equals a.AffectationId
join l in LotService.GetAll() on a.LotId equals l.LotId
where (f.TraiteLe.Date >= startDate.Date && f.TraiteLe.Date <= endDate.Date) && (f.EtatClient == Note.FAUX_NUM || f.EtatClient == Note.NRP || f.EtatClient == Note.INJOIGNABLE) && lettreIsTrue(FormulaireService, a.AffectationId) && a.EmployeId == int.Parse(agent)
select new LettreContent
{
NumLot = l.NumLot,
Adresse = l.Adresse,
NomClient = l.NomClient,
Agence = l.DescIndustry,
Compte = l.Compte
}).ToList();
}
else
{
lettreJoinedList = (from f in FormulaireService.GetAll()
join a in AffectationService.GetAll() on f.AffectationId equals a.AffectationId
join l in LotService.GetAll() on a.LotId equals l.LotId
where (f.TraiteLe.Date >= startDate.Date && f.TraiteLe.Date <= endDate.Date) && (f.EtatClient == Note.FAUX_NUM || f.EtatClient == Note.NRP || f.EtatClient == Note.INJOIGNABLE) && lettreIsTrue(FormulaireService, a.AffectationId)
select new LettreContent
{
NumLot = l.NumLot,
Adresse = l.Adresse,
NomClient = l.NomClient,
Agence = l.DescIndustry,
Compte = l.Compte
}).ToList();
}
}
else
{
if (int.Parse(agent) != 0)
{
lettreJoinedList = (from f in FormulaireService.GetAll()
join a in AffectationService.GetAll() on f.AffectationId equals a.AffectationId
join l in LotService.GetAll() on a.LotId equals l.LotId
where (f.TraiteLe.Date >= startDate.Date && f.TraiteLe.Date <= endDate.Date) && (f.EtatClient == Note.FAUX_NUM || f.EtatClient == Note.NRP || f.EtatClient == Note.INJOIGNABLE) && lettreIsTrue(FormulaireService, a.AffectationId) && (l.NumLot.Equals(numLot)) && a.EmployeId == int.Parse(agent)
select new LettreContent
{
NumLot = l.NumLot,
Adresse = l.Adresse,
NomClient = l.NomClient,
Agence = l.DescIndustry,
Compte = l.Compte,
IdAgent = a.EmployeId + ""
}).ToList();
}
else
{
lettreJoinedList = (from f in FormulaireService.GetAll()
join a in AffectationService.GetAll() on f.AffectationId equals a.AffectationId
join l in LotService.GetAll() on a.LotId equals l.LotId
where (f.TraiteLe.Date >= startDate.Date && f.TraiteLe.Date <= endDate.Date) && (f.EtatClient == Note.FAUX_NUM || f.EtatClient == Note.NRP || f.EtatClient == Note.INJOIGNABLE) && lettreIsTrue(FormulaireService, a.AffectationId) && (l.NumLot.Equals(numLot))
select new LettreContent
{
NumLot = l.NumLot,
Adresse = l.Adresse,
NomClient = l.NomClient,
Agence = l.DescIndustry,
Compte = l.Compte,
IdAgent = a.EmployeId + ""
}).ToList();
}
}
int x = 0;
ViewBag.total = lettreJoinedList.Count();
foreach (LettreContent lc in lettreJoinedList)
{
string path = dirLettre + "/" + x + "_" + "lettre" + "_" + lc.Compte + ".docx";
if (Directory.Exists(dirLettre))
{
GenerateWordForLettre(path, lc);
}
ViewData["currClient"] = x;
x++;
}
string zipPath = zipFolderResult(dirLettre);
string adressExcelPath = Server.MapPath("~/Uploads/Lettre/0_Result/") + DateTime.Now.ToString("dd.MM.yyyy") + "_" + Path.GetFileName(dirLettre) + ".xlsx";
GenerateExcelForLettre(GenerateDatatableFromJoinedListForLettre(lettreJoinedList), adressExcelPath);
Lettre lettre = new Lettre
{
DateDeb = startDate.Date,
DateFin = endDate.Date,
DateExtrait = DateTime.Now,
LettrePathName = zipPath,
LettreAdressPathName = Path.GetFileName(adressExcelPath)
};
lettreService.Add(lettre);
lettreService.Commit();
return(RedirectToAction("Renseigner", new { page = 1 }));
}
}
}
public EmployeController()
{
employeService = new EmployeService();
}
