/// <summary> /// Récupère les catgories de document à partir de l'id de catégorie père /// </summary> /// <returns>The liste sous categories document.</returns> /// <param name="idCategorieDocumentPere">Identifier categorie document pere.</param> public List <CategorieDocument> getListeSousCategoriesDocument(int idCategorieDocumentPere) { List <CategorieDocument> result = new List <CategorieDocument>(); try { string requete = "select Id, Libelle, idCategorieDocumentPere "; requete = requete + "from tblCategorieDocument e"; requete = requete + " where "; requete = requete + " idCategorieDocumentPere=" + idCategorieDocumentPere.ToString(); requete = requete + " order by ordre"; DataTable data = db.recupererDonnees(requete); for (int i = 0; i < data.Rows.Count; i++) { DataRow dr = data.Rows[i]; CategorieDocument objet = new CategorieDocument(); objet.Id = Convert.ToInt32(dr[0]); objet.Libelle = Convert.ToString(dr[1]); objet.URL = Commons.Const.URLDocuments + Convert.ToString(dr[0]); objet.NombreDocuments = getNombreDocumentsParCategorie(objet.Id); result.Add(objet); } } catch (Exception e) { Commons.Logger.genererErreur(typeof(DocumentDAL), e.ToString()); } return(result); }
/// <summary> /// Gets the categorie document by identifier. /// </summary> /// <returns>The categorie document by identifier.</returns> /// <param name="idCategorieDocument">Identifier categorie document.</param> public CategorieDocument getCategorieDocumentById(int idCategorieDocument) { CategorieDocument objet = new CategorieDocument(); objet.Libelle = ""; try { string requete = "select Id, Libelle "; requete = requete + "from tblCategorieDocument where id=" + idCategorieDocument.ToString(); DataTable data = db.recupererDonnees(requete); if (data.Rows != null && data.Rows.Count > 0) { DataRow dr = data.Rows[0]; objet.Id = Convert.ToInt32(dr[0]); objet.Libelle = Convert.ToString(dr[1]); } } catch (Exception e) { string stridCategorieDocument = idCategorieDocument.ToString(); Commons.Logger.genererErreur(typeof(DocumentDAL), "stridCategorieDocument = " + stridCategorieDocument + " " + e.ToString()); } return(objet); }
/// <summary> /// Fonction retournant la liste des catégories de document /// </summary> /// <returns>The liste categories document.</returns> /// <param name="idCategorieDocumentPere">Identifier categorie document pere.</param> public List <CategorieDocument> getListeCategoriesDocument() { List <CategorieDocument> result = new List <CategorieDocument>(); try { string requete = "select Id, Libelle, (select count(*) from tblDocument d2,tblCategorieDocument c2 where IFNULL(d2.CheminDocument,'')<>'' and d2.idCategorieDocument=c2.id and c2.idCategorieDocumentPere=e.id) "; requete = requete + "from tblCategorieDocument e"; requete = requete + " where ( idCategorieDocumentPere is null "; requete = requete + " or 0=(select count(*) from tblCategorieDocument c"; requete = requete + " where e.idCategorieDocumentPere=c.Id)) "; requete = requete + " order by e.ordre"; DataTable data = db.recupererDonnees(requete); for (int i = 0; i < data.Rows.Count; i++) { DataRow dr = data.Rows[i]; CategorieDocument objet = new CategorieDocument(); objet.Id = Convert.ToInt32(dr[0]); objet.Libelle = Convert.ToString(dr[1]); objet.URL = Commons.Const.URLDocuments + Convert.ToString(dr[0]); objet.ListSousCategorie = getListeSousCategoriesDocument(objet.Id); objet.NombreDocuments = Convert.ToInt32(dr[2]); // si la somme de la requete vaut 0, on regarde les documents directements liés à la catégorie if (objet.NombreDocuments == 0) { objet.NombreDocuments = getNombreDocumentsParCategorie(objet.Id); } result.Add(objet); } } catch (Exception e) { Commons.Logger.genererErreur(typeof(DocumentDAL), e.ToString()); } return(result); }
/// <summary> /// Affichers the documents. /// </summary> /// <returns>The documents.</returns> /// <param name="idCategorieDocument">Identifier categorie document.</param> public ActionResult AfficherDocuments(int idCategorieDocument, bool?isMobilePhone) { ObjDocument model = new ObjDocument(); model.idCategorieDocument = idCategorieDocument; string view = "~/Views/Document/Documents.cshtml"; try { Business.StatBLL.ajouterStat("PageDocument"); if (isMobilePhone == null || !isMobilePhone.Value) { model.NombreDocumentsParLigne = 4; model.NombreLignes = 2; } else { model.NombreDocumentsParLigne = 1; model.NombreLignes = 6; } using (DocumentDAL db = new DocumentDAL()) { // récupération de tous les documents CategorieDocument Categorie = db.getCategorieDocumentById(idCategorieDocument); model.LibelleCategorieDocument = Categorie.Libelle; model.ElementCount = db.getNombreDocumentsParCategorie(idCategorieDocument); } } catch (Exception e) { string strCategorieDocument = idCategorieDocument.ToString(); Commons.Logger.genererErreur(typeof(DocumentController), "strCategorieDocument =" + strCategorieDocument + " : " + e.ToString()); return(RedirectToAction("AfficherErreur", "Error", new { message = e.Message })); } return(View(view, model)); }
/// <summary> /// Affichers the documents. /// </summary> /// <returns>The documents.</returns> /// <param name="idCategorieDocument">Identifier categorie document.</param> public ActionResult AfficherDocuments(int idCategorieDocument) { ObjDocument model = new ObjDocument(); model.NombreDocumentsParLigne = 4; try { Business.StatBLL.ajouterStat("PageDocument"); using (DocumentDAL db = new DocumentDAL()) { // récupération de tous les documents model.ListeDocuments = db.getListeDocuments(idCategorieDocument); CategorieDocument Categorie = db.getCategorieDocumentById(idCategorieDocument); model.LibelleCategorieDocument = Categorie.Libelle; } } catch (Exception e) { string strCategorieDocument = idCategorieDocument.ToString(); Commons.Logger.genererErreur(typeof(DocumentController), "strCategorieDocument =" + strCategorieDocument + " : " + e.ToString()); return(RedirectToAction("AfficherErreur", "Error", new { message = e.Message })); } return(View("~/Views/Document/Documents.cshtml", model)); }