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