private static BulletinDescription CreateBulletinDescriptionFromRecord(IDataRecord record) { var bulletin = new BulletinDescription { bulletinID = record.GetValue <int>(0), groupEID = record.GetValue <long>(1), title = record.GetValue <string>(2), startDate = record.GetValue <DateTime>(3), startedBy = record.GetValue <int>(4) }; return(bulletin); }
public void SendBulletinUpdate(BulletinDescription bulletin, CorporationBulletinEvent bulletinEvent, Character issuer) { var result = new Dictionary <string, object> { { k.description, bulletin.ToDictionary() }, { k.eventType, (int)bulletinEvent }, { k.characterID, issuer.Id } }; var corporation = Corporation.GetOrThrow(bulletin.groupEID); Message.Builder.SetCommand(Commands.CorporationBulletinUpdate) .WithData(result) .ToCorporation(corporation) .Send(); }
public BulletinDescription StartBulletin(long groupEID, string title, Character startedBy) { var bulletinID = Db.Query().CommandText("insert bulletins (groupEID,title,startedby) values (@groupEID,@title,@startedBy); select cast (scope_identity() as int)") .SetParameter("@groupEID", groupEID) .SetParameter("@title", title) .SetParameter("@startedBy", startedBy.Id) .ExecuteScalar <int>(); var bd = new BulletinDescription { bulletinID = bulletinID, title = title, groupEID = groupEID, startDate = DateTime.Now, startedBy = startedBy.Id }; return(bd); }