public void Insert(FurnizoriDetails details) { var select = MySQL.GetQuery(string.Format("select IdFurnizor from furnizor ORDER BY IdFurnizor DESC LIMIT 1")); int id = int.Parse(select[0][0].ToString()) + 1; MySQL.ExecuteQuery(string.Format("insert into Furnizor(IdFurnizor,Nume,CUI,Sold,Email) values('{0}','{1}','{2}','{3}','{4}')", id, details.Nume, details.CUI, details.Sold, details.Email)); this.details = details; }
public void Update(ComboBox comboBox) { foreach (var row in rows) { if (row[1] == comboBox.SelectedItem) { details = new FurnizoriDetails(); details.Id = int.Parse(row[0].ToString()); details.Nume = row[1].ToString(); details.CUI = row[2].ToString(); details.Sold = Convert.ToDouble(row[3].ToString()); details.Email = row[4].ToString(); } } }