public void Save() { if (Changed) { if (ID >= 0) { DBInterface.CommandText = "UPDATE `sellcontroller`.`label` SET `name` = @name, " + "`comment` = @comment, `color` = @color, `idParent` = @idParent WHERE `idLabel` = @id;"; DBInterface.AddParameter("@name", MySql.Data.MySqlClient.MySqlDbType.String, Name); DBInterface.AddParameter("@comment", MySql.Data.MySqlClient.MySqlDbType.String, Comment); DBInterface.AddParameter("@color", MySql.Data.MySqlClient.MySqlDbType.VarBinary, GetColor()); if (ParentID > -1) { DBInterface.AddParameter("@idParent", MySql.Data.MySqlClient.MySqlDbType.Int32, ParentID); } else { DBInterface.AddParameter("@idParent", MySql.Data.MySqlClient.MySqlDbType.Int32, null); } DBInterface.AddParameter("@id", MySql.Data.MySqlClient.MySqlDbType.Int32, ID); DBInterface.ExecuteTransaction(); if (Updated != null) { Updated(this, new DBEventArgs() { ForceUpdate = false }); } } else { InsertRow insertRow = new InsertRow("label"); insertRow.Add("name", MySql.Data.MySqlClient.MySqlDbType.String, Name); insertRow.Add("comment", MySql.Data.MySqlClient.MySqlDbType.String, Comment); insertRow.Add("color", MySql.Data.MySqlClient.MySqlDbType.VarBinary, GetColor()); if (ParentID > -1) { insertRow.Add("idParent", MySql.Data.MySqlClient.MySqlDbType.Int32, ParentID); } insertRow.Execute(); if (Updated != null) { Updated(this, new DBEventArgs() { ForceUpdate = true }); } } Changed = false; } }
private void AssertInvalid(string name, object value) { var row = new InsertRow(); Assert.Throws <ArgumentException>(() => row.Add(name, value)); Assert.Throws <ArgumentException>(() => row[name] = value); Assert.Throws <ArgumentException>(() => row.Add(new Dictionary <string, object> { { name, value } })); }
public void AttachToPerson() { if (!LoadAttachedData(false)) { InsertRow insertRow = new InsertRow("personlabel"); insertRow.Add("note", MySql.Data.MySqlClient.MySqlDbType.String, Note); insertRow.Add("idPerson", MySql.Data.MySqlClient.MySqlDbType.Int32, person.ID); insertRow.Add("idLabel", MySql.Data.MySqlClient.MySqlDbType.Int32, ID); insertRow.Execute(); } else { throw new DuplicateNameException("Its impossible to add the same label to person twice"); } }
public void Save() { if (Changed) { if (ID >= 0) { DBInterface.CommandText = "UPDATE `sellcontroller`.`country` SET `nameCountry` = @name, " + "`codeISO2` = @iso2, `codeISO3` = @iso3, `codeCitizen` = @nat WHERE `idCountry` = @id;"; DBInterface.AddParameter("@name", MySql.Data.MySqlClient.MySqlDbType.String, Name); DBInterface.AddParameter("@iso2", MySql.Data.MySqlClient.MySqlDbType.String, ISO); DBInterface.AddParameter("@iso3", MySql.Data.MySqlClient.MySqlDbType.String, ISO3); DBInterface.AddParameter("@nat", MySql.Data.MySqlClient.MySqlDbType.String, Nationality); DBInterface.AddParameter("@id", MySql.Data.MySqlClient.MySqlDbType.Int32, ID); DBInterface.ExecuteTransaction(); if (Updated != null) { Updated(this, new DBEventArgs() { ForceUpdate = false }); } } else { InsertRow insertRow = new InsertRow("country"); insertRow.Add("nameCountry", MySql.Data.MySqlClient.MySqlDbType.String, Name); insertRow.Add("codeISO2", MySql.Data.MySqlClient.MySqlDbType.String, ISO); insertRow.Add("codeISO3", MySql.Data.MySqlClient.MySqlDbType.String, ISO3); insertRow.Add("codeCitizen", MySql.Data.MySqlClient.MySqlDbType.String, Nationality); insertRow.Execute(); if (Updated != null) { Updated(this, new DBEventArgs() { ForceUpdate = true }); } } Changed = false; } }
public void Save() { if (Changed) { if (ID >= 0) { DBInterface.CommandText = "UPDATE sellcontroller.contact SET value = @content, description = @desc WHERE idContact = @id;"; DBInterface.AddParameter("@content", MySql.Data.MySqlClient.MySqlDbType.String, Content); DBInterface.AddParameter("@desc", MySql.Data.MySqlClient.MySqlDbType.String, Description); DBInterface.AddParameter("@id", MySql.Data.MySqlClient.MySqlDbType.Int32, ID); DBInterface.ExecuteTransaction(); if (Updated != null) { Updated(this, new DBEventArgs() { ForceUpdate = false }); } } else { InsertRow insertRow = new InsertRow("contact"); insertRow.Add("idTypeContact", MySql.Data.MySqlClient.MySqlDbType.Int32, ContactTypeID()); insertRow.Add("idPerson", MySql.Data.MySqlClient.MySqlDbType.String, person.ID); insertRow.Add("value", MySql.Data.MySqlClient.MySqlDbType.String, Content); insertRow.Add("description", MySql.Data.MySqlClient.MySqlDbType.String, Description); insertRow.Execute(); if (Updated != null) { Updated(this, new DBEventArgs() { ForceUpdate = true }); } } Changed = false; } }
public void AddNewUser(string FullName, string Name, bool IsAdmin) { if ((role.RoleString == "admin") && (FullName != null) && (FullName != string.Empty) && (Name != null) && (Name != string.Empty)) { string pass = "******"; int IsAdminInt = 0; if (IsAdmin) { IsAdminInt = 1; } InsertRow insertRow = new InsertRow("user"); insertRow.Add("login", MySql.Data.MySqlClient.MySqlDbType.String, Name); insertRow.Add("Name", MySql.Data.MySqlClient.MySqlDbType.String, FullName); insertRow.Add("isAdminRole", MySql.Data.MySqlClient.MySqlDbType.Int32, IsAdminInt); insertRow.Add("hashcode", MySql.Data.MySqlClient.MySqlDbType.String, PassHash(pass)); insertRow.Execute(); } }
public void Save() { if (Changed) { if (ID >= 0) { DBInterface.CommandText = "UPDATE `sellcontroller`.`contact` SET `value` = @content WHERE `idContact` = @id;"; DBInterface.AddParameter("@content", MySql.Data.MySqlClient.MySqlDbType.String, Content); DBInterface.AddParameter("@id", MySql.Data.MySqlClient.MySqlDbType.Int32, ID); DBInterface.ExecuteTransaction(); if (Updated != null) { Updated(this, new DBEventArgs() { ForceUpdate = false }); } } else { InsertRow insertRow = new InsertRow("contact", "idContact"); insertRow.Add("value", MySql.Data.MySqlClient.MySqlDbType.String, Content); insertRow.Execute(); if (Updated != null) { Updated(this, new DBEventArgs() { ForceUpdate = true }); } } Changed = false; } }
public void Save() { if (Changed) { if (ID >= 0) { DBInterface.CommandText = "update passport set " + "ownerName = @name, " + "ownerSurname = @surname, " + "number = @number, " + "expireDate = @date, " + "note = @note, " + "idCitizen = @idCitizen, " + "idCountry = @idCountry " + "where idPassport = @id;"; DBInterface.AddParameter("@id", MySql.Data.MySqlClient.MySqlDbType.Int32, ID); DBInterface.AddParameter("@name", MySql.Data.MySqlClient.MySqlDbType.String, PersonName); DBInterface.AddParameter("@surname", MySql.Data.MySqlClient.MySqlDbType.String, PersonSurname); DBInterface.AddParameter("@number", MySql.Data.MySqlClient.MySqlDbType.String, SerialNumber); DBInterface.AddParameter("@date", MySql.Data.MySqlClient.MySqlDbType.DateTime, ValidTill); DBInterface.AddParameter("@note", MySql.Data.MySqlClient.MySqlDbType.String, Description); if (Citizen != null) { DBInterface.AddParameter("@idCitizen", MySql.Data.MySqlClient.MySqlDbType.Int32, Citizen.ID); } if (CountryOfEmmitation != null) { DBInterface.AddParameter("@idCountry", MySql.Data.MySqlClient.MySqlDbType.Int32, CountryOfEmmitation.ID); } DBInterface.ExecuteTransaction(); if (Updated != null) { Updated(this, new DBEventArgs() { ForceUpdate = false }); } } else { InsertRow insertRow = new InsertRow("passport"); insertRow.Add("ownerName", MySql.Data.MySqlClient.MySqlDbType.String, PersonName); insertRow.Add("ownerSurname", MySql.Data.MySqlClient.MySqlDbType.String, PersonSurname); insertRow.Add("number", MySql.Data.MySqlClient.MySqlDbType.String, SerialNumber); insertRow.Add("expireDate", MySql.Data.MySqlClient.MySqlDbType.DateTime, ValidTill); insertRow.Add("note", MySql.Data.MySqlClient.MySqlDbType.String, Description); if (Citizen != null) { insertRow.Add("idCitizen", MySql.Data.MySqlClient.MySqlDbType.Int32, Citizen.ID); } if (CountryOfEmmitation != null) { insertRow.Add("idCountry", MySql.Data.MySqlClient.MySqlDbType.Int32, CountryOfEmmitation.ID); } insertRow.Add("isActive", MySql.Data.MySqlClient.MySqlDbType.Int32, 1); insertRow.Add("idPeople", MySql.Data.MySqlClient.MySqlDbType.Int32, person.PersonID); insertRow.Execute(); if (Updated != null) { Updated(this, new DBEventArgs() { ForceUpdate = true }); } } Changed = false; } }