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