public static void addDirectory(DirectoryInfo AInfo)
{
Document doc = new Document(-1,"Repertoire",AInfo.FullName,AInfo.LastWriteTime,0,"","Ok");
database.addFileInfo(ref doc);
}
public static int addFile(FileInfo AInfo)
{
Document doc = new Document(-1,"Fichier",AInfo.FullName,AInfo.LastWriteTime,AInfo.Length,"MD5","Nouveau");
return database.addFileInfo(ref doc);
}
private static void readerToDocument(ref SqlDataReader AReader,ref Document ADoc)
{
ADoc.Id = Convert.ToInt32(AReader["DocumentId"].ToString());
ADoc.Type = AReader["Type"].ToString();
ADoc.Nom = AReader["Nom"].ToString();
ADoc.DateModification = Convert.ToDateTime(AReader["DateModification"].ToString());
ADoc.Taille = Convert.ToInt64(AReader["Taille"].ToString());
ADoc.Hash = AReader["Hash"].ToString();
ADoc.Etat = AReader["Etat"].ToString();
}
private static int addFileInfo(ref Document ADoc)
{
int id=-1;
SqlConnection connect = new SqlConnection(connecstring);
connect.Open();
SqlCommand command = new SqlCommand("insert into Documents (Type,Nom,DateModification,Taille,Hash,Etat) values (@type,@file,@date,@taille,@hash,@etat) select @@identity as id",connect);
command.Parameters.Add("@type",SqlDbType.VarChar).Value = ADoc.Type;
command.Parameters.Add("@file",SqlDbType.VarChar).Value = ADoc.Nom;
command.Parameters.Add("@date",SqlDbType.DateTime).Value = ADoc.DateModification;
command.Parameters.Add("@taille",SqlDbType.Int).Value = ADoc.Taille;
command.Parameters.Add("@hash",SqlDbType.VarChar).Value = "md5";
command.Parameters.Add("@etat",SqlDbType.VarChar).Value = ADoc.Etat;
SqlDataReader dr = command.ExecuteReader();
dr.Read();
id = Convert.ToInt32(dr["id"].ToString());
connect.Close();
return id;
}
public static void updateFileInfo(ref Document ADoc)
{
SqlConnection connect = new SqlConnection(connecstring);
connect.Open();
SqlCommand command = new SqlCommand("update Documents set Type=@type,Nom=@file,DateModification=@date,Taille=@taille,Hash=@hash,Etat=@etat where DocumentId=@id",connect);
command.Parameters.Add("@id",SqlDbType.VarChar).Value = ADoc.Id;
command.Parameters.Add("@type",SqlDbType.VarChar).Value = ADoc.Type;
command.Parameters.Add("@file",SqlDbType.VarChar).Value = ADoc.Nom;
command.Parameters.Add("@date",SqlDbType.DateTime).Value = ADoc.DateModification;
command.Parameters.Add("@taille",SqlDbType.Int).Value = ADoc.Taille;
command.Parameters.Add("@hash",SqlDbType.VarChar).Value = "md5";
command.Parameters.Add("@etat",SqlDbType.VarChar).Value = ADoc.Etat;
command.ExecuteNonQuery();
connect.Close();
}
public static Document[] searchDocument(string AClauseWhere,int limit)
{
string top = "";
if (limit>0)
{
top = "top " + limit.ToString();
}
string sql = "select " + top + " documents.* from documents inner join documentclef on documents.documentid=documentclef.documentid where " + AClauseWhere;
SqlConnection connect = new SqlConnection(connecstring);
connect.Open();
SqlCommand command = new SqlCommand(sql,connect);
ArrayList list = new ArrayList();
SqlDataReader dr = database.ReaderMesureTime(ref command);
try
{
while (dr.Read())
{
Document doc = new Document();
readerToDocument(ref dr,ref doc);
list.Add(doc);
}
}
finally
{
if (dr != null) dr.Close();
command.Dispose();
connect.Close();
}
return (Document[])list.ToArray(typeof(Document));
}
public static Document GetNextIndex()
{
Document doc = new Document();
SqlConnection connect = new SqlConnection(connecstring);
connect.Open();
SqlCommand command = new SqlCommand("select top 1 * from documents where type='fichier' and etat<>'OK' and etat<>'Erreur' and etat<>'FullText'",connect);
SqlDataReader dr = command.ExecuteReader();
if (dr.Read())
{
database.readerToDocument(ref dr,ref doc);
}
connect.Close();
return doc;
}