public CorporationDocumentConfig(IDataRecord record) { documentType = (CorporationDocumentType)record.GetValue <int>("documenttype"); creationPrice = record.GetValue <int>("creationprice"); rentPrice = record.GetValue <int>("rentprice"); rentPeriodDays = record.GetValue <int>("rentperioddays"); maxPerCharacter = record.GetValue <int>("maxpercharacter"); }
public CorporationDocument(IDataRecord record) { _id = record.GetValue <int>("id"); _ownerCharacter = Character.Get(record.GetValue <int>("ownercharacterid")); _documentType = (CorporationDocumentType)record.GetValue <int>("documenttype"); _creation = record.GetValue <DateTime>("creation"); _lastModified = record.GetValue <DateTime>("lastmodified"); _validUntil = record.GetValue <DateTime?>("validuntil"); version = record.GetValue <int>("version"); }
private CorporationDocument(int freshId, Character character, CorporationDocumentType corporationDocumentType, DateTime?validUntil, string body) { _id = freshId; _creation = DateTime.Now; _lastModified = DateTime.Now; _validUntil = validUntil; _ownerCharacter = character; _documentType = corporationDocumentType; version = 0; _body = body; }
public static ErrorCodes CreateNewToSql(Character character, CorporationDocumentType corporationDocumentType, DateTime?validUntil, string body, out CorporationDocument corporationDocument) { corporationDocument = null; const string cmdStr = InsertQuery + ";select cast(scope_identity() as int)"; var freshId = Db.Query().CommandText(cmdStr).SetParameter("@characterId", character.Id).SetParameter("@type", (int)corporationDocumentType).SetParameter("@validUntil", validUntil).SetParameter("@body", body) .ExecuteScalar <int>(); if (freshId <= 0) { return(ErrorCodes.SQLInsertError); } corporationDocument = new CorporationDocument(freshId, character, corporationDocumentType, validUntil, body); return(ErrorCodes.NoError); }
public static int GetAmountByType(CorporationDocumentType documentType, Character character) { return (Db.Query().CommandText("select count(*) from corporationdocuments where ownercharacterid=@characterId and documenttype=@type").SetParameter("@type", (int)documentType).SetParameter("@characterId", character.Id) .ExecuteScalar <int>()); }
public static ErrorCodes GetDocumentConfig(CorporationDocumentType documentType, out CorporationDocumentConfig documentConfig) { return(corporationDocumentConfig.TryGetValue((int)documentType, out documentConfig) ? ErrorCodes.NoError : ErrorCodes.InvalidDocumentType); }