Exemplo n.º 1
0
        public void UpdateDB(PersonObject person, COMMAND command, object value, SQLConnectionSettings s)
        {
            try
            {
                MySqlConnection con = Connect(s);

                string QuerySelect = "select * from " + s.Database + "." + s.TableName + " where " + command.ToString() + "=" + value + ";";
                ExecuteSQLCommand(QuerySelect, con);

                con = Connect(s);
                string QueryUpdate = "update " + s.Database + "." + s.TableName + " SET " +
                                     "Grad='" + person.Grad + "'," +
                                     "Name='" + person.Name + "'," +
                                     "Vorname='" + person.Vorname + "'," +
                                     "PicturePath='" + person.PhotoPath + "'," +
                                     "IsChecked='" + Convert.ToInt32(person.IsCheckedIn) + "'," +
                                     "CardID='" + person.CardID + "'," +
                                     "CheckInTime='" + person.CheckInTime.ToString() + "'," +
                                     "CheckOutTime='" + person.CheckOutTime.ToString() + "'" +
                                     "where " + command.ToString() + " = " + value + ";";
                ExecuteSQLCommand(QueryUpdate, con);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
Exemplo n.º 2
0
        public bool TestConnection(SQLConnectionSettings s)
        {
            string          QuerySelect = "select * from " + s.Database + "." + s.TableName;
            MySqlConnection con         = Connect(s);
            MySqlCommand    sqlCommand  = new MySqlCommand(QuerySelect, con);

            return(IsSQLConnected);
        }
Exemplo n.º 3
0
 public void ClearDB(SQLConnectionSettings s)
 {
     try
     {
         string          Query = "DELETE FROM " + s.Database + "." + s.TableName;
         MySqlConnection con   = Connect(s);
         ExecuteSQLCommand(Query, con);
     }
     catch (Exception ex)
     {
         MessageBox.Show(ex.Message);
     }
 }
Exemplo n.º 4
0
 public void Delete(COMMAND command, object value, SQLConnectionSettings s)
 {
     try
     {
         string          Query = "delete from " + s.Database + "." + s.TableName + " where " + command.ToString() + "='" + value + "';";
         MySqlConnection con   = Connect(s);
         ExecuteSQLCommand(Query, con);
     }
     catch (Exception ex)
     {
         MessageBox.Show(ex.Message);
     }
 }
Exemplo n.º 5
0
        public void Write2DB(PersonObject person, SQLConnectionSettings s)
        {
            try
            {
                string Query = "insert into " + s.Database + "." + s.TableName + "(Grad,Name,Vorname,PicturePath,IsChecked,CardID) values('" +
                               person.Grad + "','" +
                               person.Name + "','" +
                               person.Vorname + "','" +
                               person.PhotoPath + "','" +
                               Convert.ToByte(person.IsCheckedIn) + "','" +
                               person.CardID + "');";

                MySqlConnection con = Connect(s);
                ExecuteSQLCommand(Query, con);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
Exemplo n.º 6
0
        public List <PersonObject> ReadFromDB(SQLConnectionSettings s)
        {
            List <PersonObject> persons = new List <PersonObject>();

            try
            {
                string          Query   = "select * from " + s.Database + "." + s.TableName + ";";
                MySqlConnection con     = Connect(s);
                MySqlCommand    command = new MySqlCommand(Query, con);
                //For offline connection we weill use  MySqlDataAdapter class.
                MySqlDataAdapter MyAdapter = new MySqlDataAdapter();
                MyAdapter.SelectCommand = command;
                DataTable dTable = new DataTable();
                MyAdapter.Fill(dTable);
                foreach (DataRow row in dTable.Rows)
                {
                    PersonObject person = new PersonObject();
                    person.ID           = (int)row[0];
                    person.Grad         = (string)row[1];
                    person.Name         = (string)row[2];
                    person.Vorname      = (string)row[3];
                    person.PhotoPath    = (string)row[4];
                    person.IsCheckedIn  = Convert.ToBoolean(row[5]);
                    person.CardID       = (string)row[6];
                    person.CheckInTime  = (string)row[7];
                    person.CheckOutTime = (string)row[8];
                    persons.Add(person);
                }
                command.Connection.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "DB Error", MessageBoxButton.OK, MessageBoxImage.Error);
                return(null);
            }
            return(persons);
        }
Exemplo n.º 7
0
        public PersonObject ReadFromDB(COMMAND command, object value, SQLConnectionSettings s)
        {
            PersonObject person = new PersonObject();

            try
            {
                string          QuerySelect = "select * from " + s.Database + "." + s.TableName + " where " + command.ToString() + "='" + value + "';";
                MySqlConnection con         = Connect(s);
                MySqlCommand    sqlCommand  = new MySqlCommand(QuerySelect, con);
                //For offline connection we weill use  MySqlDataAdapter class.
                MySqlDataAdapter MyAdapter = new MySqlDataAdapter();
                MyAdapter.SelectCommand = sqlCommand;
                DataTable dTable = new DataTable();
                MyAdapter.Fill(dTable);
                DataRow row = dTable.Rows[0];

                person.ID          = (int)row[0];
                person.Grad        = (string)row[1];
                person.Name        = (string)row[2];
                person.Vorname     = (string)row[3];
                person.PhotoPath   = (string)row[4];
                person.IsCheckedIn = Convert.ToBoolean(row[5]);
                person.CardID      = (string)row[6];

                person.CheckInTime  = (string)row[7];
                person.CheckOutTime = (string)row[8];


                sqlCommand.Connection.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
                return(null);
            }
            return(person);
        }
Exemplo n.º 8
0
        private MySqlConnection Connect(SQLConnectionSettings sqlComSettings)
        {
            SQLConnectionSettings s = sqlComSettings;

            return(Connect(s.Server, s.User, s.Port, s.Database, s.Password));
        }