public Empleat UpdateEmpleat(Empleat new_empleat) { Empleat emp = new Empleat(); emp = new_empleat; using (MySqlConnection conn = GetConnection()) { conn.Open(); MySqlCommand cmd = new MySqlCommand("update Empleat set nom='" + new_empleat.Nom + "',cognom='" + new_empleat.Cognom + "', carrec='" + new_empleat.Carrec + "',sou='" + new_empleat.Sou + "' where id='" + new_empleat.Id + "';", conn); using (var reader = cmd.ExecuteReader()) { while (reader.Read()) { } } } return(emp); }
public Empleat InsertEmpleat(Empleat new_empleat) { Empleat emp = new Empleat(); emp = new_empleat; using (MySqlConnection conn = GetConnection()) { conn.Open(); MySqlCommand cmd = new MySqlCommand("insert into Empleat (id,nom,cognom,carrec,sou) values('" + new_empleat.Id + "','" + new_empleat.Nom + "','" + new_empleat.Cognom + "','" + new_empleat.Carrec + "','" + new_empleat.Sou + "');", conn); using (var reader = cmd.ExecuteReader()) { while (reader.Read()) { } } } return(emp); }
public Empleat DeleteEmpleat(int id_empleat, string nom_empleat, string cognom_empleat, string carrec_empleat, int sou_empleat) { Empleat emp = new Empleat(); using (MySqlConnection conn = GetConnection()) { conn.Open(); MySqlCommand cmd = new MySqlCommand("delete from Empleat where id =" + id_empleat, conn); using (var reader = cmd.ExecuteReader()) { while (reader.Read()) { } ; emp.Id = id_empleat; emp.Nom = nom_empleat; emp.Cognom = cognom_empleat; emp.Carrec = carrec_empleat; emp.Sou = sou_empleat; }; } return(emp); }