public RegisterOrganisation Post(RegisterOrganisation r)
{
int id = RegistersOrganisation.Insert(Claims.GetConnectionString(User), r);
r.ID = id;
return(r);
}
public void organisation_should_not_be_duplicated()
{
var ovoNumber = Fixture.Create <OvoNumber>();
var registerOrganisationCommand = new RegisterOrganisation(ovoNumber);
Assert(new Scenario()
.Given(ovoNumber,
new OrganisationWasRegistered(ovoNumber))
.When(registerOrganisationCommand)
.Throws(new WrongExpectedVersionException($"Append failed due to WrongExpectedVersion.Stream: {ovoNumber}, Expected version: -1")));
}
public static int Insert(ConnectionStringSettings connectionString, RegisterOrganisation register)
{
string sql = "INSERT INTO Registers(RegisterName,Device) VALUES(@RegisterName,@Device)";
if (register.Name == null)
{
register.Name = "";
}
if (register.Device == null)
{
register.Device = "";
}
DbParameter par1 = Database.AddParameter(connectionString, "@RegisterName", register.Name);
DbParameter par2 = Database.AddParameter(connectionString, "@Device", register.Device);
return(Database.InsertData(connectionString, sql, par1, par2));
}
public HttpStatusCode Put(long id, RegisterOrganisation r)
{
RegistersOrganisation.Update(Claims.GetConnectionString(User), id, r);
return(HttpStatusCode.OK);
}
public static void Update(ConnectionStringSettings connectionString, long id, RegisterOrganisation reg)
{
string sql = "UPDATE registers SET RegisterName=@RegisterName,Device=@DeviceName WHERE ID=@ID;";
if (reg.Name == null)
{
reg.Name = "";
}
if (reg.Device == null)
{
reg.Device = "";
}
DbParameter regName = Database.AddParameter(connectionString, "@RegisterName", reg.Name);
DbParameter regDeviceName = Database.AddParameter(connectionString, "@DeviceName", reg.Device);
DbParameter regId = Database.AddParameter(connectionString, "@ID", id);
Database.ModifyData(connectionString, sql, regName, regDeviceName, regId);
}
