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();
}
}
}
