示例#1
0
        public Boolean editResidence(Residence r, int residence_id)
        {
            //update hq id not implemented yet
            String query = "UPDATE employee_residence SET country = '" + r.Country + "', city = '" + r.City + "', street = '" + r.Street + "', number = '" + r.Number + "', postal_code = '" + r.Postal_code + "', current_residence = '" + r.Current_residence + "' WHERE id = '" + residence_id + "'";

            try { residence.Insert(query); return(true); }
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
                return(false);
            }
        }
示例#2
0
        public Boolean addResidence(Residence r)
        {
            String query = "INSERT INTO employee_residence(employee_id, country, city, street, number, postal_code, current_residence) VALUES('" + r.Employee_id + "', '" + r.Country + "', '" + r.City + "', '" + r.Street + "', '" + r.Number + "', '" + r.Postal_code + "', '" + r.Current_residence + "')";

            try
            { residence.Insert(query); return(true); }
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
                return(false);
            }
        }
示例#3
0
        private void btnSave_Click(object sender, EventArgs e)
        {
            Residence residence = new Residence();

            residence.Employee_id = employee_id;
            residence.City        = textBox_city.Text;
            residence.Street      = textBox_street.Text;
            residence.Country     = textBox_city.Text;
            residence.Postal_code = textBox_postalcode.Text;
            residence.Number      = int.Parse(textBox_housenr.Text);
            if (residence_id == 0)
            {
                db1.addResidence(residence);
            }
            else
            {
                db1.editResidence(residence, residence_id);
            }
            this.Close();
        }
示例#4
0
        private void AddEditEmployee_Activated(object sender, EventArgs e)
        {
            var residences        = db1.getSingleUserResidence(employee_id);
            var current_residence = new Residence();

            residenceListbox.DataSource    = new BindingSource(residences, null);
            residenceListbox.DisplayMember = "Street";
            residenceListbox.ValueMember   = "Id";
            degreeListBox.DataSource       = new BindingSource(db1.getSingleUserDegree(employee_id), null);
            degreeListBox.DisplayMember    = "course";
            degreeListBox.ValueMember      = "id";
            foreach (var residence in residences)
            {
                if (residence.Current_residence == true)
                {
                    current_residence = residence;
                }
            }

            if (employeeBsn != 0)
            {
                residenceListbox.SelectedItem = current_residence;
            }
        }