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