public void UpdateToDb() { DynamicSqlQuery.Update("transportassignments", new { collateral, reward, targetbaseeid, taken, volunteercharacterid = volunteercharacter?.Id, expiry, started }, new { id }).ThrowIfEqual(0, ErrorCodes.SQLUpdateError); }
public void WriteLog(TransportAssignmentEvent transportAssignmentEvent, long baseEid) { var o = new { assignmentevent = (int)transportAssignmentEvent, baseeid = baseEid, ownercharacterid = ownercharacter.Id, volunteercharacterid = volunteercharacter?.Id, assignmentid = id, containername, }; DynamicSqlQuery.Insert("transportassignmentslog", o).ThrowIfEqual(0, ErrorCodes.SQLInsertError); }
public void InsertToDb() { id = DynamicSqlQuery.InsertAndGetIdentity("transportassignments", new { sourcebaseeid, targetbaseeid, ownercharacterid = ownercharacter.Id, reward, collateral, containereid, volume, expiry, containername }).ThrowIfLessOrEqual(0, ErrorCodes.SQLInsertError); }
public void HandleRequest(IRequest request) { using (var scope = Db.CreateTransaction()) { var character = request.Session.Character; var target = Character.Get(request.Data.GetOrDefault <int>(k.target)); var note = request.Data.GetOrDefault <string>(k.note); if (string.IsNullOrEmpty(note)) { // ha ures a string akkor toroljuk Db.Query().CommandText("delete from characternotes where characterid = @characterid and targetid = @targetid") .SetParameter("@characterid", character.Id) .SetParameter("@targetid", target.Id).ExecuteNonQuery(); return; } note = note.Clamp(2000); var id = Db.Query().CommandText("select targetid from characternotes where characterid = @characterid and targetid = @targetid") .SetParameter("@characterid", character.Id) .SetParameter("@targetid", target.Id).ExecuteScalar <int>(); if (id > 0) { DynamicSqlQuery.Update("characternotes", new { note }, new { characterId = character.Id, targetId = target.Id }).ThrowIfEqual(0, ErrorCodes.SQLUpdateError); } else { DynamicSqlQuery.Insert("characternotes", new { characterId = character.Id, targetId = target.Id, note }).ThrowIfEqual(0, ErrorCodes.SQLInsertError); } Transaction.Current.OnCommited(() => Message.Builder.FromRequest(request).WithOk().Send()); scope.Complete(); } }