public override Lettre Insert(Lettre toInsert)
{
Dictionary <string, object> Parameters = MapToDico(toInsert);
base.Insert(Parameters);
return(toInsert);
}
private Dictionary <string, object> MapToDico(Lettre toInsert)
{
Dictionary <string, object> p = new Dictionary <string, object>();
p["IdMembre"] = toInsert.IdMembre;
p["IdEvenement"] = toInsert.IdEvenement;
p["Contenu"] = toInsert.Contenu;
return(p);
}
private void MajLettreActuelle(Lettre nouvelleLettre)
{
if (lettreActuelle != null)
{
blanchirMot(lettreActuelle);
}
surlignerMot(nouvelleLettre);
lettreActuelle = nouvelleLettre;
transform.position = lettreActuelle.Go.transform.position + Vector3.back;
}
public static void genererTlettre(ref Lettre[] Tlettre, ref string[] Tvaleur)
{
Tlettre = new Lettre[Tvaleur.Length];
for (int i = 0; i < Tvaleur.Length; i++)
{
Tlettre[i] = new Lettre();
Tlettre[i].Numero = i;
Tlettre[i].Valeur = Tvaleur[i];
}
}
private void blanchirMot(Lettre lettre)
{
if (lettre.MotHorizontal != null)
{
foreach (Lettre l in lettre.MotHorizontal.ListeLettres)
{
l.GoRenderer.color = Color.white;
}
}
if (lettre.MotVertical != null)
{
foreach (Lettre l in lettre.MotVertical.ListeLettres)
{
l.GoRenderer.color = Color.white;
}
}
}
private void surlignerMot(Lettre lettre)
{
if (horizontalMode)
{
if (lettre.MotHorizontal != null)
{
foreach (Lettre l in lettre.MotHorizontal.ListeLettres)
{
l.GoRenderer.color = Color.cyan;
}
}
}
else
{
if (lettre.MotVertical != null)
{
foreach (Lettre l in lettre.MotVertical.ListeLettres)
{
l.GoRenderer.color = Color.cyan;
}
}
}
}
/// <summary>
/// Lit le plan des cases et crée une grille
/// </summary>
/// <param name="gridAsString"></param>
private void LireGridFile(string gridAsString)
{
List <string> eachLine = new List <string>();
eachLine.AddRange(gridAsString.Split((new string[] { "\r\n", "\n" }), System.StringSplitOptions.None));
nbLignes = eachLine.Count;
nbColonnes = eachLine[0].Length;
listeLettres = new Lettre[nbLignes, nbColonnes];
for (int y = 0; y < nbLignes; y++)
{
for (int x = 0; x < nbColonnes; x++)
{
if (eachLine[y].Substring(x, 1).CompareTo("1") == 0)
{
listeLettres [x, y] = new Lettre(".", x, y);
}
else
{
listeLettres [x, y] = new Lettre(null, x, y);
}
}
}
}
static void NbreCaract() // Menu 4
{
string Phrase;
string Lettre;
int Compt = 0;
Phrase = GetString("Entrez une phrase :");
Lettre = GetString("Quelle lettre voulez-vous compter :");
for (int i = 0; i < Phrase.Length; i++)
{
if (Lettre.IndexOf(Phrase.Substring(i, 1)) != -1)
{
Compt++;
}
}
Console.WriteLine("Dans {0}, il y a {1} fois {2}", Phrase, Compt, Lettre);
//Console.WriteLine();
//Console.WriteLine("Menu 4");
}
public override bool Update(Lettre toUpdate)
{
Dictionary <string, object> Parameters = MapToDico(toUpdate);
return(base.Update(Parameters));
}
public override string ToString()
{
return(Lettre.ToString() + ", du noeud n°" + Origine.Numero + " vers le n°" + Destination.Numero);
}
/// <summary>
/// Ajoute une lettre au mot courant
/// </summary>
/// <param name="l"></param>
public void AjouterLettre(Lettre l)
{
listeLettres.Add(l);
taille = listeLettres.Count;
}
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 }));
}
}
}
