public static void Insert(Organisation_RegisterBindModel register)
{
Organisation org = Organisations.GetById(register.OrganisationID);
RegisterManagement registerFromDatabase = RegistersManagement.GetById(register.RegisterID);
if (org == null || registerFromDatabase == null)
{
return;
}
string sql = "INSERT INTO Organisation_Register VALUES(@OrganisationID, @RegisterID, @FromDate, @UntilDate)";
DbParameter par0 = Database.AddParameter(ConfigurationManager.AppSettings["ConnectionStringItBedrijf"], "@OrganisationID", register.OrganisationID);
DbParameter par1 = Database.AddParameter(ConfigurationManager.AppSettings["ConnectionStringItBedrijf"], "@RegisterID", register.RegisterID);
DbParameter par2 = Database.AddParameter(ConfigurationManager.AppSettings["ConnectionStringItBedrijf"], "@FromDate", register.FromDate);
DbParameter par3 = Database.AddParameter(ConfigurationManager.AppSettings["ConnectionStringItBedrijf"], "@UntilDate", register.UntilDate);
Database.InsertData(ConfigurationManager.AppSettings["ConnectionStringItBedrijf"], sql, par0, par1, par2, par3);
sql = "INSERT INTO Registers VALUES(@ID, @RegisterName, @Device)";
ConnectionStringSettings settings = new ConnectionStringSettings("KlantDynamicConnection", org.DatabaseConnectionString, "System.Data.SqlClient");;
DbParameter parRegisterName = Database.AddParameter(settings, "@RegisterName", registerFromDatabase.Name);
DbParameter parID = Database.AddParameter(settings, "@ID", registerFromDatabase.ID);
DbParameter parRegisterDevice = Database.AddParameter(settings, "@Device", registerFromDatabase.Device);
Database.InsertData(settings, sql, parRegisterDevice, parRegisterName, parID);
}
public static void DeleteRegister(int id)
{
RegisterManagement register = RegistersManagement.GetById(id);
string sql = "DELETE FROM Organisation_Register WHERE RegisterID=@ID";
DbParameter parId = Database.AddParameter(ConfigurationManager.AppSettings["ConnectionStringItBedrijf"], "@ID", id);
Database.ModifyData(ConfigurationManager.AppSettings["ConnectionStringItBedrijf"], sql, parId);
// Delete the register from the client database
if (register.AssignedTo != null)
{
sql = "DELETE FROM Registers WHERE ID=@ID";
ConnectionStringSettings settings = new ConnectionStringSettings("KlantDynamicConnection", register.AssignedTo.DatabaseConnectionString, "System.Data.SqlClient");;
DbParameter parRegisterID = Database.AddParameter(settings, "@ID", register.ID);
Database.ModifyData(settings, sql, parRegisterID);
}
}