public ActionResult FormAttestation(string Mode, int Code) { ATTESTATIONS Element = new ATTESTATIONS(); if (Mode == "Create") { ViewBag.TITRE_PAGE = "AJOUTER UNE NOUVELLE ATTESTATION"; ViewBag.DATE = DateTime.Today.ToShortDateString(); int Max = 1; List <ATTESTATIONS> liste = BD.ATTESTATIONS.Where(Elt => Elt.DATE.Year == DateTime.Today.Year).ToList(); if (liste.Count > 0) { Max = liste.Select(Elt => Elt.NUMERO).Max(); Max++; } ViewBag.REFERENCE = "ATT" + Max.ToString("000") + "/" + DateTime.Today.Year; } if (Mode == "Edit") { Element = BD.ATTESTATIONS.Find(Code); ViewBag.TITRE_PAGE = "MODIFIER UNE ATTESTATION"; ViewBag.DATE = Element.DATE.ToShortDateString(); ViewBag.REFERENCE = Element.REFERENCE; } ViewBag.Mode = Mode; ViewBag.Code = Code; return(View(Element)); }
public ActionResult Delete(int Code) { ATTESTATIONS Selected = BD.ATTESTATIONS.Find(Code); BD.ATTESTATIONS.Remove(Selected); BD.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult GetFileByID(string id) { int ID = int.Parse(id); ATTESTATIONS attestation = BD.ATTESTATIONS.Find(ID); dynamic dt = new { LOCALITE = attestation.LOCALITE, DATE = attestation.DATE.ToShortDateString(), REFERENCE = attestation.REFERENCE, TITRE = attestation.MODELES_ATTESTATIONS.TITRE, DESCRIPTION = GetDescriptionByEmployee(ID), SIGNE_PAR = attestation.SIGNE_PAR, }; ReportDocument rptH = new ReportDocument(); string FileName = Server.MapPath("/Reports/ATTESTATION.rpt"); rptH.Load(FileName); rptH.SetDataSource(new[] { dt }); Stream stream = rptH.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); return(File(stream, "application/pdf")); }
public string GetDescriptionByEmployee(int id) { string Result = string.Empty; ATTESTATIONS attestation = BD.ATTESTATIONS.Find(id); EMPLOYEES employee = attestation.EMPLOYEES; MODELES_ATTESTATIONS model = attestation.MODELES_ATTESTATIONS; List <CHAMPS_MODELES> liste = BD.CHAMPS_MODELES.Where(Element => Element.MODELES_ATTESTATIONS.ID == model.ID).OrderBy(Element => Element.ORDRE).ToList(); foreach (CHAMPS_MODELES Element in liste) { if (Element.TYPE == "TEXT") { if (Element.VALEUR.Trim() == string.Empty) { Result += Environment.NewLine; Result += Environment.NewLine; } Result += Element.VALEUR + " "; } if (Element.TYPE == "TABLE") { if (Element.VALEUR == "CIN") { Result += employee.CIN + " "; } if (Element.VALEUR == "FULLNAME") { Result += employee.FULLNAME + " "; } if (Element.VALEUR == "NUM_ASS_SOC") { Result += employee.NUM_ASS_SOC + " "; } if (Element.VALEUR == "QUALIFICATION") { Result += employee.QUALIFICATION + " "; } if (Element.VALEUR == "NUMERO") { Result += employee.NUMERO + " "; } if (Element.VALEUR == "ADRESSE") { Result += employee.ADRESSE + " "; } if (Element.VALEUR == "CIVILITE") { Result += employee.CIVILITE + " "; } if (Element.VALEUR == "SALAIRE") { Result += ((decimal)employee.SALAIRE) * 13 + " "; } if (Element.VALEUR == "DEMARRAGE") { Result += employee.DEMARRAGE.Value.ToShortDateString() + " "; } } } return(Result); }
public ActionResult SendFormAttestation(string Mode, string Code) { string REFERENCE = Request.Params["REFERENCE"] != null ? Request.Params["REFERENCE"].ToString() : string.Empty; string MODELE = Request.Params["MODELE"] != null ? Request.Params["MODELE"].ToString() : string.Empty; string employee = Request.Params["employee"] != null ? Request.Params["employee"].ToString() : string.Empty; string LOCALITE = Request.Params["LOCALITE"] != null ? Request.Params["LOCALITE"].ToString() : string.Empty; string DATE = Request.Params["DATE"] != null ? Request.Params["DATE"].ToString() : string.Empty; string SIGNE_PAR = Request.Params["SIGNE_PAR"] != null ? Request.Params["SIGNE_PAR"].ToString() : string.Empty; string DECHARGE = Request.Params["DECHARGE"] != null ? "true" : "false"; string COMMENTAIRE = Request.Params["COMMENTAIRE"] != null ? Request.Params["COMMENTAIRE"].ToString() : ""; DateTime SelectedDate = DateTime.Parse(DATE); int ID = int.Parse(employee); EMPLOYEES SelectedEmployee = BD.EMPLOYEES.Find(ID); int SelectedModel = int.Parse(MODELE); MODELES_ATTESTATIONS Model = BD.MODELES_ATTESTATIONS.Find(SelectedModel); if (Mode == "Create") { int Max = 1; List <ATTESTATIONS> liste = BD.ATTESTATIONS.Where(Elt => Elt.DATE.Year == DateTime.Today.Year).ToList(); if (liste.Count > 0) { Max = liste.Select(Elt => Elt.NUMERO).Max(); Max++; } ATTESTATIONS NewElement = new ATTESTATIONS(); NewElement.EMPLOYE = ID; NewElement.EMPLOYEES = SelectedEmployee; NewElement.DATE = SelectedDate; NewElement.REFERENCE = REFERENCE; NewElement.NUMERO = Max; NewElement.MODELE = SelectedModel; NewElement.MODELES_ATTESTATIONS = Model; NewElement.LOCALITE = LOCALITE; NewElement.COMMENTAIRE = COMMENTAIRE != "undefined" ? COMMENTAIRE : string.Empty; NewElement.SIGNE_PAR = SIGNE_PAR; NewElement.DECHARGE = Boolean.Parse(DECHARGE); BD.ATTESTATIONS.Add(NewElement); BD.SaveChanges(); } if (Mode == "Edit") { int SeletedPretID = int.Parse(Code); ATTESTATIONS NewElement = BD.ATTESTATIONS.Find(SeletedPretID); NewElement.EMPLOYE = ID; NewElement.EMPLOYEES = SelectedEmployee; NewElement.DATE = SelectedDate; //NewElement.REFERENCE = REFERENCE; //NewElement.NUMERO = Max; NewElement.MODELE = SelectedModel; NewElement.MODELES_ATTESTATIONS = Model; NewElement.LOCALITE = LOCALITE; NewElement.COMMENTAIRE = COMMENTAIRE != "undefined" ? COMMENTAIRE : string.Empty; NewElement.SIGNE_PAR = SIGNE_PAR; NewElement.DECHARGE = Boolean.Parse(DECHARGE); BD.SaveChanges(); } return(RedirectToAction("Index")); }