/// <summary>
/// Fonction testant si les logins et le mot passe de passe renseignés sont corrects et renvoyant l'id du type utilisateur
/// </summary>
/// <returns>The connexion ok.</returns>
/// <param name="Login">Login.</param>
/// <param name="Password">Password.</param>
public int isConnexionOK(string Login, string Password)
{
int idTypeUtilisateur = -1;
try
{
Login = Login.Replace("'", "''");
Password = Password.Replace("'", "''");
string requete = "select idTypeUtilisateur ";
requete = requete + "from tblUtilisateur ";
requete = requete + " where Login='******' ";
requete = requete + " and Password='******' ";
DataTable data = db.recupererDonnees(requete);
DataRow dr;
if (data != null && data.Rows.Count > 0)
{
dr = data.Rows[0];
idTypeUtilisateur = Convert.ToInt32(dr[0]);
}
}
catch (Exception e)
{
idTypeUtilisateur = -1;
Commons.Logger.genererErreur(typeof(UtilisateurDAL), "Login ="******" et Password ="******" : " + e.ToString());
}
return(idTypeUtilisateur);
}
/// <summary>
/// Gets the nombre documents par categorie.
/// </summary>
/// <returns>The nombre documents par categorie.</returns>
/// <param name="idCategorieDocument">Identifier categorie document.</param>
public int getNombreDocumentsParCategorie(int idCategorieDocument)
{
int result = 1;
try
{
string requete = "select count(*) ";
requete = requete + "from tblDocument ";
requete = requete + " where IFNULL(CheminDocument,'')<>'' and idCategorieDocument=" + idCategorieDocument.ToString();
DataTable data = db.recupererDonnees(requete);
DataRow dr;
if (data != null && data.Rows.Count > 0)
{
dr = data.Rows[0];
result = Convert.ToInt32(dr[0]);
}
}
catch (Exception e)
{
string stridCategorie = idCategorieDocument.ToString();
Commons.Logger.genererErreur(typeof(DocumentDAL), "stridCategorie = " + stridCategorie + " " + e.ToString());
}
return(result);
}
/// <summary>
/// Fonction permettant de récupérer les logs applicatives
/// </summary>
/// <returns>The logs.</returns>
public List <Log4Net> getLogs()
{
List <Log4Net> result = new List <Log4Net>();
try
{
string requete = "select Id, Level, Thread ,Date ";
requete = requete + ",Logger,Message,Exception ";
requete = requete + "from tblLog4Net order by id desc";
DataTable data = db.recupererDonnees(requete);
for (int i = 0; i < data.Rows.Count; i++)
{
DataRow dr = data.Rows[i];
Log4Net log = new Log4Net();
log.Id = Convert.ToInt32(dr[0]);
log.Level = Convert.ToString(dr[1]);
log.Thread = Convert.ToString(dr[2]);
log.Date = Convert.ToDateTime(dr[3]);
log.Logger = Convert.ToString(dr[4]);
log.Message = Convert.ToString(dr[5]);
log.Exception = Convert.ToString(dr[6]);
log.strDate = Commons.Utils.getFormatStringPourDateAffichage(Convert.ToDateTime(dr[3]));
result.Add(log);
}
}
catch (Exception e)
{
Commons.Logger.genererErreur(typeof(Log4Net), e.ToString());
}
return(result);
}
/// <summary>
/// Fonction déterminant si le mois en cours possède déja des stats
/// </summary>
/// <returns><c>true</c>, if nouveau mois was ised, <c>false</c> otherwise.</returns>
/// <param name="Mois">Mois.</param>
public bool isNouveauMois(string Mois)
{
bool result = false;
try
{
DataTable data = db.recupererDonnees("select count(*) from tblStat where Mois='" + Mois + "'");
DataRow dr = data.Rows[0];
int n = Convert.ToInt32(dr[0]);
if (n == 0)
{
result = true;
}
}
catch (Exception e)
{
Commons.Logger.genererErreur(typeof(StatDAL), e.ToString());
}
return(result);
}
/// <summary>
/// Gets the actualite count.
/// </summary>
/// <returns>The actualite count.</returns>
public int getActualiteCount()
{
int result = 0;
try
{
string requete = "select count(*) ";
requete = requete + "from tblActualite ";
DataTable data = db.recupererDonnees(requete);
DataRow dr;
if (data != null && data.Rows.Count > 0)
{
dr = data.Rows[0];
result = Convert.ToInt32(dr[0]);
}
}
catch (Exception e)
{
Commons.Logger.genererErreur(typeof(ActualiteDAL), e.ToString());
}
return(result);
}
/// <summary>
/// Gets the nex identifier equipe.
/// </summary>
/// <returns>The nex identifier equipe.</returns>
public int getNexIdEquipe()
{
int result = 1;
try
{
string requete = "select max(id) ";
requete = requete + "from tblEquipe ";
DataTable data = db.recupererDonnees(requete);
DataRow dr;
if (data != null && data.Rows.Count > 0)
{
dr = data.Rows[0];
result = Convert.ToInt32(dr[0]) + 1;
}
}
catch (Exception e)
{
Commons.Logger.genererErreur(typeof(EquipeDAL), e.ToString());
}
return(result);
}
/// <summary>
/// Récupération des commentaires
/// </summary>
/// <returns>The liste commentaires.</returns>
/// <param name="idActualite">Identifier actualite.</param>
/// <param name="idDocument">Identifier document.</param>
public List <Commentaire> getListeCommentaires(int?idActualite, int?idDocument)
{
List <Commentaire> result = new List <Commentaire>();
try
{
string requete = "select c.Id,c.NomUtilisateur,c.Message ";
requete = requete + ", c.DateCreation, c.idActualite, c.idDocument, IFNULL(a.Titre,''), IFNULL(d.Titre,'') ";
requete = requete + " from tblCommentaire c ";
requete = requete + " left join tblActualite a on a.id=c.idActualite ";
requete = requete + " left join tblDocument d on d.id=c.idDocument ";
requete = requete + " where 1=1 ";
if (idActualite != null)
{
requete = requete + " and idActualite=" + idActualite.ToString();
}
if (idDocument != null)
{
requete = requete + " and idDocument=" + idDocument.ToString();
}
requete = requete + " order by c.id asc";
DataTable data = db.recupererDonnees(requete);
for (int i = 0; i < data.Rows.Count; i++)
{
DataRow dr = data.Rows[i];
Commentaire objet = new Commentaire();
objet.Id = Convert.ToInt32(dr[0]);
objet.Utilisateur = Convert.ToString(dr[1]);
objet.Message = Convert.ToString(dr[2]);
objet.DateCreation = Convert.ToDateTime(dr[3]);
objet.strDateCreation = Commons.Utils.getFormatStringPourDateAffichage(objet.DateCreation);
objet.LibelleActualite = Convert.ToString(dr[6]);
objet.LibelleDocument = Convert.ToString(dr[7]);
if (dr[4] != DBNull.Value)
{
objet.idActualite = Convert.ToInt32(dr[4]);
}
if (dr[5] != DBNull.Value)
{
objet.idDocument = Convert.ToInt32(dr[5]);
}
result.Add(objet);
}
}
catch (Exception e)
{
string strIdActualite = "NULL";
string strIdDocument = "NULL";
if (idActualite != null)
{
strIdActualite = idActualite.ToString();
}
if (idDocument != null)
{
strIdDocument = idDocument.ToString();
}
Commons.Logger.genererErreur(typeof(CommentaireDAL), "strIdActualite = " + strIdActualite + " et strIdDocument " + strIdDocument + " :" + e.ToString());
}
return(result);
}