// Insert public int insert(string connectionString, Reprocess reprocess) { using (SQLiteConnection conn = new SQLiteConnection(connectionString)) { try { int x = -9; conn.Open(); if (conn.State == System.Data.ConnectionState.Open) { SQLiteCommand command = new SQLiteCommand(@"INSERT INTO " + TABLE_NAME + " ('" + COLONNE_EDIFILEID + "', '" + COLONNE_FILENAME + "', '" + COLONNE_FILEPATH + "', '" + COLONNE_COUNT + "') VALUES(" + reprocess.ediFileID + ",'" + reprocess.fileName + "','" + reprocess.filePath + "','" + reprocess.fileReprocessCount + "')", conn); x = command.ExecuteNonQuery(); //Console.WriteLine("Table created"); } conn.Close(); return(x); } catch (Exception ex) { Console.WriteLine("\nReproccess Insert [ERROR]"); Console.WriteLine("Message : " + ex.Message); Console.WriteLine(""); Console.WriteLine("\nStackTrace : " + ex.StackTrace); conn.Close(); return(-99); } } }
// Delete by ID public bool drop(string connectionString, Reprocess reprocess) { using (SQLiteConnection conn = new SQLiteConnection(connectionString)) { try { conn.Open(); if (conn.State == System.Data.ConnectionState.Open) { using (IDbConnection db = conn) { SQLiteCommand command = new SQLiteCommand(SQL_drop, conn); command.ExecuteNonQuery(); conn.Close(); return(true); } } conn.Close(); return(false); } catch (Exception ex) { Console.WriteLine("\nDELETE Reproccess [ERROR]"); Console.WriteLine(ex.Message); conn.Close(); return(false); } } }
// Update public int update(string connectionString, Reprocess reprocess, StreamWriter writer) { using (SQLiteConnection conn = new SQLiteConnection(connectionString)) { try { int x = -9; conn.Open(); writer.WriteLine(DateTime.Now + " :: ReprocessManager.dll => update() | Creation d'une Instance"); if (conn.State == System.Data.ConnectionState.Open) { writer.WriteLine(DateTime.Now + " :: ReprocessManager.dll => update() | SQL => UPDATE " + TABLE_NAME + " SET " + COLONNE_FILENAME + " = '" + reprocess.fileName + "', " + COLONNE_FILEPATH + " = '" + reprocess.filePath + "', " + COLONNE_COUNT + " = '" + reprocess.fileReprocessCount + "' WHERE " + COLONNE_EDIFILEID + " = " + reprocess.ediFileID); SQLiteCommand command = new SQLiteCommand(@"UPDATE " + TABLE_NAME + " SET " + COLONNE_FILENAME + " = '" + reprocess.fileName + "', " + COLONNE_FILEPATH + " = '" + reprocess.filePath + "', " + COLONNE_COUNT + " = '" + reprocess.fileReprocessCount + "' WHERE " + COLONNE_EDIFILEID + " = " + reprocess.ediFileID, conn); x = command.ExecuteNonQuery(); writer.WriteLine(DateTime.Now + " :: ReprocessManager.dll => update() | ediFileID : " + reprocess.ediFileID + " is Updated !"); } writer.Flush(); conn.Close(); return(x); } catch (Exception ex) { writer.WriteLine(DateTime.Now + " :: ReprocessManager.dll => update() | ##################################################"); writer.WriteLine(DateTime.Now + " :: ReprocessManager.dll => update() | [ERROR] update"); writer.WriteLine(DateTime.Now + " :: ReprocessManager.dll => update() | Message : " + ex.Message); writer.WriteLine(DateTime.Now + " :: ReprocessManager.dll => update() | StackTrace : " + ex.StackTrace); writer.WriteLine(""); writer.Flush(); conn.Close(); return(-99); } } }
// Delete by ID public bool deleteById(string connectionString, Reprocess reprocess) { using (SQLiteConnection conn = new SQLiteConnection(connectionString)) { try { conn.Open(); if (conn.State == System.Data.ConnectionState.Open) { using (IDbConnection db = conn) { SQLiteCommand command = new SQLiteCommand(@"DELETE FROM " + TABLE_NAME + " WHERE " + COLONNE_EDIFILEID + " = " + reprocess.ediFileID, conn); command.ExecuteNonQuery(); Console.WriteLine(reprocess.ediFileID + " data have been deleted from " + TABLE_NAME + " !"); conn.Close(); return(true); } } conn.Close(); return(false); } catch (Exception ex) { Console.WriteLine("\nDELETE Reproccess [ERROR]"); Console.WriteLine(ex.Message); conn.Close(); return(false); } } }
// Update public int update(string connectionString, Reprocess reprocess) { using (SQLiteConnection conn = new SQLiteConnection(connectionString)) { try { int x = -9; conn.Open(); if (conn.State == System.Data.ConnectionState.Open) { SQLiteCommand command = new SQLiteCommand(@"UPDATE " + TABLE_NAME + " SET " + COLONNE_FILENAME + " = '" + reprocess.fileName + "', " + COLONNE_FILEPATH + " = '" + reprocess.filePath + "', " + COLONNE_COUNT + " = '" + reprocess.fileReprocessCount + "' WHERE " + COLONNE_EDIFILEID + " = " + reprocess.ediFileID, conn); x = command.ExecuteNonQuery(); Console.WriteLine("ediFileID : " + reprocess.ediFileID + " is Updated !"); } conn.Close(); return(x); } catch (Exception ex) { Console.WriteLine("\n Reproccess Update [ERROR]"); Console.WriteLine(ex.Message); conn.Close(); return(-99); } } }
public ConfigurationGeneral(General General_, Paths paths_, PlannerTask plannerTask_, PriceType priceType_, Reprocess reprocess_) { this.general = General_; this.paths = paths_; this.plannerTask = plannerTask_; this.priceType = priceType_; this.reprocess = reprocess_; }
// Get by ID public Reprocess getById(string connectionString, string ediFileID, StreamWriter writer) { using (SQLiteConnection conn = new SQLiteConnection(connectionString)) { try { Reprocess list = null; conn.Open(); writer.WriteLine(DateTime.Now + " :: ReprocessManager.dll => getById(ediFileID: " + ediFileID + ") | Creation d'un Instance."); if (conn.State == System.Data.ConnectionState.Open) { using (IDbConnection db = conn) { writer.WriteLine(DateTime.Now + " :: ReprocessManager.dll => getById(ediFileID: " + ediFileID + ") | SQL => SELECT " + COLONNE_EDIFILEID + ", " + COLONNE_FILENAME + ", " + COLONNE_FILEPATH + ", " + COLONNE_COUNT + " FROM " + TABLE_NAME + " WHERE " + COLONNE_EDIFILEID + " = " + ediFileID); var xxx = conn.Query <Reprocess>("SELECT " + COLONNE_EDIFILEID + ", " + COLONNE_FILENAME + ", " + COLONNE_FILEPATH + ", " + COLONNE_COUNT + " FROM " + TABLE_NAME + " WHERE " + COLONNE_EDIFILEID + " = " + ediFileID); if (xxx.ToList() == null || xxx.ToList().Count == 0) { writer.WriteLine(DateTime.Now + " :: ReprocessManager.dll => getById() | Aucun resulta."); writer.Flush(); conn.Close(); return(null); } list = xxx.ToList()[0]; writer.WriteLine(DateTime.Now + " :: ReprocessManager.dll => getById() | Reprocess obj recu"); } } writer.Flush(); //conn.Close(); return(list); } catch (Exception ex) { writer.WriteLine(DateTime.Now + " :: ReprocessManager.dll => getById() | ##################################################"); writer.WriteLine(DateTime.Now + " :: ReprocessManager.dll => getById() | [ERROR] getById"); writer.WriteLine(DateTime.Now + " :: ReprocessManager.dll => getById() | Message : " + ex.Message); writer.WriteLine(DateTime.Now + " :: ReprocessManager.dll => getById() | StackTrace : " + ex.StackTrace); writer.WriteLine(""); writer.Flush(); //conn.Close(); return(null); } } }
// Delete by ID public bool deleteById(string connectionString, Reprocess reprocess, StreamWriter writer) { using (SQLiteConnection conn = new SQLiteConnection(connectionString)) { try { conn.Open(); writer.WriteLine(DateTime.Now + " :: ReprocessManager.dll => deleteById(reprocess .ediFileID: " + reprocess.ediFileID + ") | Creation d'une Instance"); if (conn.State == System.Data.ConnectionState.Open) { using (IDbConnection db = conn) { writer.WriteLine(DateTime.Now + " :: ReprocessManager.dll => deleteById() | SQL => DELETE FROM " + TABLE_NAME); SQLiteCommand command = new SQLiteCommand(@"DELETE FROM " + TABLE_NAME + " WHERE " + COLONNE_EDIFILEID + " = " + reprocess.ediFileID, conn); command.ExecuteNonQuery(); writer.WriteLine(DateTime.Now + " :: ReprocessManager.dll => deleteById() | Les donnees de la table " + TABLE_NAME + " sont supprime!"); writer.Flush(); conn.Close(); return(true); } } writer.Flush(); conn.Close(); return(false); } catch (Exception ex) { writer.WriteLine(DateTime.Now + " :: ReprocessManager.dll => deleteById() | ##################################################"); writer.WriteLine(DateTime.Now + " :: ReprocessManager.dll => deleteById() | [ERROR] deleteById (obj)"); writer.WriteLine(DateTime.Now + " :: ReprocessManager.dll => deleteById() | Message : " + ex.Message); writer.WriteLine(DateTime.Now + " :: ReprocessManager.dll => deleteById() | StackTrace : " + ex.StackTrace); writer.WriteLine(""); writer.Flush(); conn.Close(); return(false); } } }
// Insert public int insert(string connectionString, Reprocess reprocess, StreamWriter writer) { using (SQLiteConnection conn = new SQLiteConnection(connectionString)) { try { int x = -9; conn.Open(); writer.WriteLine(""); writer.WriteLine(DateTime.Now + " :: ReprocessManager.dll => insert() | Creation d'une instance"); if (conn.State == System.Data.ConnectionState.Open) { writer.WriteLine(DateTime.Now + " :: ReprocessManager.dll => insert() | Creation d'une instance"); SQLiteCommand command = new SQLiteCommand(@"INSERT INTO " + TABLE_NAME + " ('" + COLONNE_EDIFILEID + "', '" + COLONNE_FILENAME + "', '" + COLONNE_FILEPATH + "', '" + COLONNE_COUNT + "') VALUES(" + reprocess.ediFileID + ",'" + reprocess.fileName + "','" + reprocess.filePath + "','" + reprocess.fileReprocessCount + "')", conn); x = command.ExecuteNonQuery(); Console.WriteLine("Table created"); writer.WriteLine(DateTime.Now + " :: ReprocessManager.dll => insert() | Creation d'une instance"); } writer.Flush(); conn.Close(); return(x); } catch (Exception ex) { writer.WriteLine(DateTime.Now + " :: ReprocessManager.dll => insert() | ##################################################"); writer.WriteLine(DateTime.Now + " :: ReprocessManager.dll => insert() | Reproccess Insert [ERROR]"); writer.WriteLine(DateTime.Now + " :: ReprocessManager.dll => insert() | Message : " + ex.Message); writer.WriteLine(DateTime.Now + " :: ReprocessManager.dll => insert() | StackTrace : " + ex.StackTrace); writer.WriteLine(""); writer.Flush(); conn.Close(); return(-99); } } }
// Get by ID public Reprocess getById(string connectionString, string ediFileID) { using (SQLiteConnection conn = new SQLiteConnection(connectionString)) { try { Reprocess list = null; conn.Open(); if (conn.State == System.Data.ConnectionState.Open) { using (IDbConnection db = conn) { var xxx = conn.Query <Reprocess>("SELECT " + COLONNE_EDIFILEID + ", " + COLONNE_FILENAME + ", " + COLONNE_FILEPATH + ", " + COLONNE_COUNT + " FROM " + TABLE_NAME + " WHERE " + COLONNE_EDIFILEID + " = " + ediFileID); if (xxx.ToList() == null || xxx.ToList().Count == 0) { conn.Close(); return(null); } list = xxx.ToList()[0]; Console.WriteLine("Reprocess list size : 1"); } } //conn.Close(); return(list); } catch (Exception ex) { Console.WriteLine("\nGET Reproccess [ERROR]"); Console.WriteLine(ex.Message); //conn.Close(); return(null); } } }