예제 #1
0
        public void Edit(string newName, string newAppt)
        {
            MySqlConnection conn = DB.Connection();

            conn.Open();
            var cmd = conn.CreateCommand() as MySqlCommand;

            cmd.CommandText = @"UPDATE clients SET name = @newName, raw_appt = @newAppt WHERE id = @searchId;";

            MySqlParameter searchId = new MySqlParameter();

            searchId.ParameterName = "@searchId";
            searchId.Value         = _id;
            cmd.Parameters.Add(searchId);

            MySqlParameter name = new MySqlParameter();

            name.ParameterName = "@newName";
            name.Value         = newName;
            cmd.Parameters.Add(name);

            MySqlParameter rawAppt = new MySqlParameter();

            rawAppt.ParameterName = "@newAppt";
            rawAppt.Value         = newAppt;
            cmd.Parameters.Add(rawAppt);

            cmd.ExecuteNonQuery();
            _name = newName;

            conn.Close();
            if (conn != null)
            {
                conn.Dispose();
            }
        }
예제 #2
0
        public List <SpecialtyClass> GetSpecialties()
        {
            List <SpecialtyClass> allSpecialties = new List <SpecialtyClass> {
            };
            MySqlConnection conn = DB.Connection();

            conn.Open();
            MySqlCommand cmd = conn.CreateCommand() as MySqlCommand;

            cmd.CommandText = @"SELECT specialties.* FROM specialties JOIN stylists_specialties ON (specialties.Id = stylists_specialties.specialty_Id) JOIN stylists ON (stylists_specialties.stylist_Id = stylists.Id) WHERE stylists.Id = (@specialtyId);";
            MySqlParameter stylistId = new MySqlParameter();

            stylistId.ParameterName = "@stylistId";
            stylistId.Value         = this._id;
            cmd.Parameters.Add(stylistId);
            MySqlParameter specialtyId = new MySqlParameter();

            specialtyId.ParameterName = "@specialtyId";
            specialtyId.Value         = this._id;
            cmd.Parameters.Add(specialtyId);
            MySqlDataReader rdr = cmd.ExecuteReader() as MySqlDataReader;

            while (rdr.Read())
            {
                int            specialty_Id = rdr.GetInt32(0);
                string         feature      = rdr.GetString(1);
                SpecialtyClass newSpecialty = new SpecialtyClass(feature, specialty_Id);
                allSpecialties.Add(newSpecialty);
            }
            conn.Close();
            if (conn != null)
            {
                conn.Dispose();
            }
            return(allSpecialties);
        }
예제 #3
0
        public void Update(string name, int stylistId)
        {
            MySqlConnection conn = DB.Connection();

            conn.Open();
            var cmd = conn.CreateCommand() as MySqlCommand;

            cmd.CommandText = @"UPDATE clients SET name = @name, stylistId = @stylistId WHERE id = @clientId;";

            MySqlParameter tempName      = new MySqlParameter("@name", name);
            MySqlParameter tempStylistId = new MySqlParameter("@stylistId", stylistId);
            MySqlParameter tempClientId  = new MySqlParameter("@clientId", this.GetId());

            cmd.Parameters.Add(tempName);
            cmd.Parameters.Add(tempStylistId);
            cmd.Parameters.Add(tempClientId);

            cmd.ExecuteNonQuery();
            conn.Close();
            if (conn != null)
            {
                conn.Dispose();
            }
        }
        public void Save()
        {
            MySqlConnection conn = DB.Connection();

            conn.Open();

            var cmd = conn.CreateCommand() as MySqlCommand;

            cmd.CommandText = @"INSERT INTO clients (name, notes, stylist_id) VALUES (@name, @notes, @stylistId);";

            MySqlParameter name = new MySqlParameter();

            name.ParameterName = "@name";
            name.Value         = this._name;
            cmd.Parameters.Add(name);

            MySqlParameter notes = new MySqlParameter();

            notes.ParameterName = "@notes";
            notes.Value         = this._notes;
            cmd.Parameters.Add(notes);

            MySqlParameter stylistId = new MySqlParameter();

            stylistId.ParameterName = "@stylistId";
            stylistId.Value         = this._stylistId;
            cmd.Parameters.Add(stylistId);

            cmd.ExecuteNonQuery();
            _id = (int)cmd.LastInsertedId;
            conn.Close();
            if (conn != null)
            {
                conn.Dispose();
            }
        }