private static CommErrors SetNewDate(DateTime newDate)
{
OracleConnection connection = GetConnection();
CommErrors err = CommErrors.ConnectionError;
string query;
try
{
connection.Open();
query = "UPDATE t_timemachine SET date_courante = to_date('"
+ newDate.ToString(DateFormat) + "','" + DateFormat + "')";
Debug.WriteLine("DAO - SetNewDate()- currentDate:" + newDate.ToString(DateFormat));
OracleCommand sql = new OracleCommand();
sql.Connection = connection;
sql.CommandText = query;
sql.CommandType = System.Data.CommandType.Text;
sql.ExecuteNonQuery();
err = CommErrors.Success;
}
catch (Exception e)
{
Debug.WriteLine("DAO SetNextDay() - bloc catch :" + e.Message);
err = CommErrors.ConnectionError;
}
finally
{
connection.Close();
}
return(err);
}
private void btnConnecter_Click(object sender, EventArgs e)
{
DAO objDAO = new DAO();
try
{
User objUser = new User(decimal.Parse(txtAgentId.Text), txtPassword.Text);
objDAO.Utilisateur = objUser;
CommErrors err = objDAO.Login();
switch (err)
{
case CommErrors.ConnectionError: MessageBox.Show("Problème de connexion ... \nréessayer plus tard");
break;
case CommErrors.LoginFailed: MessageBox.Show("Numéro d'agent ou mot de passe incorrect");
break;
case CommErrors.Success: Program.user = objDAO.Utilisateur; // login réussi, objUser contient le profile "agent" ou "admin" dans
// la propriété "Utilisateur"
this.DialogResult = DialogResult.OK;
break;
default: break;
}
Debug.WriteLine("LoginScreen - btnConnecter_Click err: " + err);
}
catch (FormatException ex)
{
MessageBox.Show("Le numéro d'agent ne doit contenir que des chiffres");
}
}
public static DateTime GetCurrentDate(out CommErrors err)
{
DateTime currentDate = new DateTime();
OracleConnection connection = GetConnection();
try
{
connection.Open();
string query = "SELECT * FROM t_timemachine where id_date = 1";
OracleDataReader reader = SelectNatif(query, connection);
while (reader.Read())
{
currentDate = (DateTime)reader[1];
}
err = CommErrors.Success;
}
catch (Exception e)
{
Debug.WriteLine("DAO GetCurrentDate() - bloc catch :" + e.Message);
err = CommErrors.ConnectionError;
}
finally
{
connection.Close();
}
return(currentDate);
}
public static DateTime GetCurrentDate(out CommErrors err)
{
DateTime currentDate = new DateTime();
OracleConnection connection = GetConnection();
try
{
connection.Open();
string query = "SELECT * FROM t_timemachine where id_date = 1";
OracleDataReader reader = SelectNatif(query, connection);
while (reader.Read())
{
currentDate = (DateTime)reader[1];
}
err = CommErrors.Success;
}
catch (Exception e)
{
Debug.WriteLine("DAO GetCurrentDate() - bloc catch :" + e.Message);
err = CommErrors.ConnectionError;
}
finally
{
connection.Close();
}
return currentDate;
}
public void GetCurrentDateTest()
{
CommErrors expected = CommErrors.Success;
CommErrors actual;
DateTime currentDate = DAO.GetCurrentDate(out actual);
Assert.AreEqual(expected, actual);
}
public void SetNextMonthTest()
{
CommErrors expected = CommErrors.Success;
CommErrors actual;
actual = DAO.SetNextMonth();
Assert.AreEqual(expected, actual);
}
public void GetCurrentDateTest()
{
CommErrors err = new CommErrors();
CommErrors errExpected = CommErrors.Success;
DateTime actual;
actual = DAO.GetCurrentDate(out err);
Assert.AreEqual(errExpected, err);
}
public void GetCurrentDateTest()
{
CommErrors err = new CommErrors();
CommErrors errExpected = CommErrors.Success;
DateTime actual;
actual = DAO.GetCurrentDate(out err);
Assert.AreEqual(errExpected, err);
}
public void SetNewDateTest()
{
DateTime newDate = new DateTime(); // TODO: initialisez à une valeur appropriée
CommErrors expected = CommErrors.Success; // TODO: initialisez à une valeur appropriée
CommErrors actual;
actual = DAO_Accessor.SetNewDate(newDate);
Assert.AreEqual(expected, actual);
}
public void LoginTest()
{
DAO target = new DAO();
target.Utilisateur = new User(1, "1111");
CommErrors expected = CommErrors.Success;
CommErrors actual;
actual = target.Login();
Assert.AreEqual(expected, actual);
}
public void GetSequenceTest()
{
string table = "polices";
CommErrors err = new CommErrors();
CommErrors errExpected = CommErrors.Success;
Decimal notExpected = 0;
Decimal actual;
actual = DAO.GetSequence(table, out err);
Assert.AreEqual(errExpected, err);
Assert.AreNotEqual(notExpected, actual);
}
public void LoginTest()
{
DAO target = new DAO(); // TODO: initialisez à une valeur appropriée
target.Utilisateur = new User(1, "1111");
CommErrors expected = CommErrors.Success; // TODO: initialisez à une valeur appropriée
CommErrors actual;
actual = target.Login();
Assert.AreEqual(expected, actual);
}
public void GetSequenceTest()
{
string table = "polices";
CommErrors err = new CommErrors();
CommErrors errExpected = CommErrors.Success;
Decimal notExpected = 0;
Decimal actual;
actual = DAO.GetSequence(table, out err);
Assert.AreEqual(errExpected, err);
Assert.AreNotEqual(notExpected, actual);
}
private void btnProchainJour_Click(object sender, EventArgs e)
{
CommErrors err = DAO.SetNextDay();
if (CommErrors.Success == err)
{
AfficherDateCourante();
lstLogs.Items.Add("Ok:\\> Nouvelle date du système: " + DateCourante.ToString("dd MMM yyyy"));
}
else
{
lstLogs.Items.Add("Error:\\> Une erreur de connexion s'est produite");
}
}
public CommErrors Login()
{
decimal agentId = this.Utilisateur.AgentId;
string password = this.Utilisateur.Password;
CommErrors returnValue = CommErrors.ConnectionError;
OracleConnection connection = GetConnection();
try
{
Debug.WriteLine("DAO Login - Connexion vers Oracle ...");
connection.Open();
string query = "SELECT * from agents where agent_id=" + agentId + " and mot_passe ='" + password + "'";
OracleDataReader reader = SelectNatif(query, connection);
string profile = "";
while (reader.Read())
{
profile = (string)reader[1];
}
// vérification du résultat
if (profile.Equals(""))
{
returnValue = CommErrors.LoginFailed;
}
else
{
this.Utilisateur.Profile = profile.Equals("agent") ? Profile.Agent : Profile.Admin;
returnValue = CommErrors.Success;
}
}
catch (Exception e)
{
Debug.WriteLine("DAO Login - bloc catch :" + e.Message);
returnValue = CommErrors.ConnectionError;
}
finally
{
connection.Close();
}
Debug.WriteLine("DAO - Login returnValue: " + returnValue);
return(returnValue);
}
public static decimal GetSequence(string table, out CommErrors err)
{
decimal returnValue = 0;
err = CommErrors.ConnectionError;
OracleConnection connection = GetConnection();
try
{
Debug.WriteLine("DAO GetSequence- Connexion vers Oracle ...");
connection.Open();
string query = "SELECT TO_CHAR("+table+"_seq.nextval) FROM DUAL";
OracleDataReader reader = SelectNatif(query, connection);
string sequence = "";
while (reader.Read())
{
sequence = (string)reader[0];
}
returnValue = decimal.Parse(sequence);
err = CommErrors.Success;
}
catch (Exception e)
{
Debug.WriteLine("DAO GetSequence - bloc catch :" + e.Message);
err = CommErrors.ConnectionError;
}
finally
{
connection.Close();
}
Debug.WriteLine("DAO - GetSequence returnValue: " + returnValue);
return returnValue;
}
public SerialPrinter(string CommPort)
{
hcom = Kernel32.CreateFile(
CommPort, //port name
Kernel32.GENERIC_WRITE, //write only
0, //no sharing
IntPtr.Zero, //no security
Kernel32.OPEN_EXISTING, //open existing port only
Kernel32.FILE_FLAG_OVERLAPPED, //async(overlapped) I/O
IntPtr.Zero); //Null for Comm Devices
if (hcom == (IntPtr)Kernel32.INVALID_HANDLE_VALUE)
{
CommErrors e = (CommErrors)Marshal.GetLastWin32Error();
Console.WriteLine("Error opening serial port: {0}", e.ToString());
}
else
{
PortOpen = true;
}
}
public static decimal GetSequence(string table, out CommErrors err)
{
decimal returnValue = 0;
err = CommErrors.ConnectionError;
OracleConnection connection = GetConnection();
try
{
Debug.WriteLine("DAO GetSequence- Connexion vers Oracle ...");
connection.Open();
string query = "SELECT TO_CHAR(" + table + "_seq.nextval) FROM DUAL";
OracleDataReader reader = SelectNatif(query, connection);
string sequence = "";
while (reader.Read())
{
sequence = (string)reader[0];
}
returnValue = decimal.Parse(sequence);
err = CommErrors.Success;
}
catch (Exception e)
{
Debug.WriteLine("DAO GetSequence - bloc catch :" + e.Message);
err = CommErrors.ConnectionError;
}
finally
{
connection.Close();
}
Debug.WriteLine("DAO - GetSequence returnValue: " + returnValue);
return(returnValue);
}
