/// <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));
}
