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