/// <summary>
/// Permet de remplir les propriétés de mappage de l'entité difficulté.
/// </summary>
/// <param name="reader">reader contenant les données.</param>
/// <returns>Un objet difficulteDTO</returns>
public override Mappage.DTOBase populateDTO(System.Data.SqlClient.SqlDataReader reader)
{
difficulteDTO difficulte = new difficulteDTO();
if (!reader.IsDBNull(ordDifficulteGuid)) { difficulte.difficulteGuid = reader.GetGuid(ordDifficulteGuid); }
if (!reader.IsDBNull(ordDifficulteNiveau)) { difficulte.difficulteNiveau = reader.GetString(ordDifficulteNiveau); }
difficulte.isNew = false;
return difficulte;
}
/// <summary>
/// Permet remplir les propriétés de mappage de l'entité admin.
/// </summary>
/// <param name="reader">reader contenant les données.</param>
/// <returns>Un objet adminDTO.</returns>
public override Mappage.DTOBase populateDTO(System.Data.SqlClient.SqlDataReader reader)
{
typeDTO type = new typeDTO();
if (!reader.IsDBNull(ordTypeGuid)) { type.typeGuid = reader.GetGuid(ordTypeGuid); }
if (!reader.IsDBNull(ordTypeType)) { type.typeType = reader.GetString(ordTypeType); }
type.isNew = false;
return type;
}
/// <summary>
/// Permet de remplir les propriétés de mappage de l'entité highscore.
/// </summary>
/// <param name="reader">reader contenant les données.</param>
/// <returns>Un objet adminDTO.</returns>
public override Mappage.DTOBase populateDTO(System.Data.SqlClient.SqlDataReader reader)
{
highscoreDTO highscore = new highscoreDTO();
if (!reader.IsDBNull(ordHighscoreGuid)) { highscore.highscoreGuid = reader.GetGuid(ordHighscoreGuid); }
if (!reader.IsDBNull(ordHighscorePseudo)) { highscore.highscorePseudo = reader.GetString(ordHighscorePseudo); }
if (!reader.IsDBNull(ordHighscoreScore)) { highscore.highscoreScore = reader.GetInt32(ordHighscoreScore); }
highscore.isNew = false;
return highscore;
}
/// <summary>
/// Permet remplir les propriétés de mappage de l'entité admin.
/// </summary>
/// <param name="reader">reader contenant les données.</param>
/// <returns>Un objet adminDTO.</returns>
public override Mappage.DTOBase populateDTO(System.Data.SqlClient.SqlDataReader reader)
{
adminDTO admin = new adminDTO();
if (!reader.IsDBNull(ordAdminGuid)) { admin.adminGuid = reader.GetGuid(ordAdminGuid); }
if (!reader.IsDBNull(ordAdminLogin)) { admin.adminLogin = reader.GetString(ordAdminLogin); }
if (!reader.IsDBNull(ordAdminPassword)) { admin.adminPassword = reader.GetString(ordAdminPassword); }
admin.isNew = false;
return admin;
}
/// <summary>
/// Permet remplir les propriétés de mappage de l'entité réponse.
/// </summary>
/// <param name="reader">reader contenant les données.</param>
/// <returns>Un objet reponseDTO.</returns>
public override Mappage.DTOBase populateDTO(System.Data.SqlClient.SqlDataReader reader)
{
reponseDTO reponse = new reponseDTO();
if (!reader.IsDBNull(ordReponseGuid)) { reponse.reponseGuid = reader.GetGuid(ordReponseGuid); }
if (!reader.IsDBNull(ordReponseIntitule)) { reponse.reponseIntitule = reader.GetString(ordReponseIntitule); }
if (!reader.IsDBNull(ordReponseJuste)) { reponse.reponseJuste = reader.GetBoolean(ordReponseJuste); }
if (!reader.IsDBNull(ordReponseQuestionGuid)) { reponse.reponseQuestionGuid = reader.GetInt32(ordReponseQuestionGuid); }
reponse.isNew = false;
return reponse;
}
/// <summary>
/// Permet remplir les propriétés de mappage de l'entité métier.
/// </summary>
/// <param name="reader">reader contenant les données.</param>
/// <returns>Un objet metierDTO.</returns>
public override Mappage.DTOBase populateDTO(System.Data.SqlClient.SqlDataReader reader)
{
metierDTO metier = new metierDTO();
if (!reader.IsDBNull(ordMetierGuid)) { metier.metierGuid = reader.GetGuid(ordMetierGuid); }
if (!reader.IsDBNull(ordMetierNom)) { metier.metierNom = reader.GetString(ordMetierNom); }
if (!reader.IsDBNull(ordMetierFiche)) { metier.metierFiche = reader.GetString(ordMetierFiche); }
if (!reader.IsDBNull(ordMetierScoreReseau)) { metier.metierScoreReseau = reader.GetInt32(ordMetierScoreReseau); }
if (!reader.IsDBNull(ordMetierScoreLogiciel)) { metier.metierScorelogiciel = reader.GetInt32(ordMetierScoreLogiciel); }
metier.isNew = false;
return metier;
}
/// <summary>
/// Permet de remplir les propriétés de mappage de l'entité question.
/// </summary>
/// <param name="reader">reader contenant les données.</param>
/// <returns>Un objet questionDTO.</returns>
public override Mappage.DTOBase populateDTO(System.Data.SqlClient.SqlDataReader reader)
{
questionDTO question = new questionDTO(); // On crée un nouveau questionDTO. Etant donné qu'il hérite de DTOBase on peut l'utiliser comme valeur de retour.
// On utilise l'ordinal correspondant pour s'assurer que la valeur retournée par le reader n'est pas null.
// Si cette valeur n'est pas null, on utilise getXXX typée du reader pour obtenir la valeur.
if (!reader.IsDBNull(ordQuestionGuid)) { question.questionGuid = reader.GetGuid(ordQuestionGuid); }
if (!reader.IsDBNull(ordQuestionIntitule)) { question.questionIntitule = reader.GetString(ordQuestionIntitule); }
if (!reader.IsDBNull(ordQuestionReponseGuid)) { question.questionReponseGuid = reader.GetInt32(ordQuestionReponseGuid); }
if (!reader.IsDBNull(ordQuestionDifficulteGuid)) { question.questionDifficulteGuid = reader.GetInt32(ordQuestionDifficulteGuid); }
if (!reader.IsDBNull(ordQuestionTypeGuid)) { question.questionTypeGuid = reader.GetInt32(ordQuestionTypeGuid); }
question.isNew = false;
return question;
}
private static hierarchy3a ORM_CreateProxy(System.Data.IDataReader result, System.Collections.Generic.IDictionary<string, int> ordinals)
{
return new hierarchy3a()
{
pid = result.IsDBNull(ordinals["pid"]) ? new Guid() : result.GetGuid(ordinals["pid"]),
fid = result.IsDBNull(ordinals["fid"]) ? 0 : result.GetInt64(ordinals["fid"]),
uid = result.IsDBNull(ordinals["uid"]) ? new Guid() : result.GetGuid(ordinals["uid"]),
numfield1 = result.IsDBNull(ordinals["numfield1"]) ? 0 : result.GetInt32(ordinals["numfield1"]),
numfield2 = result.IsDBNull(ordinals["numfield2"]) ? 0 : result.GetInt32(ordinals["numfield2"]),
numfield3 = result.IsDBNull(ordinals["numfield3"]) ? 0 : result.GetInt32(ordinals["numfield3"]),
textfield1 = result.IsDBNull(ordinals["textfield1"]) ? null : result.GetString(ordinals["textfield1"]),
textfield2 = result.IsDBNull(ordinals["textfield2"]) ? null : result.GetString(ordinals["textfield2"]),
textfield3 = result.IsDBNull(ordinals["textfield3"]) ? null : result.GetString(ordinals["textfield3"])
};
//var obj = new hierarchy3a();
//obj.pid = result.IsDBNull(ordinals["pid"]) ? new Guid() : result.GetGuid(ordinals["pid"]),
//obj.fid = result.IsDBNull(ordinals["fid"]) ? 0 : result.GetInt64(ordinals["fid"]),
//obj.uid = result.IsDBNull(ordinals["uid"]) ? new Guid() : result.GetGuid(ordinals["uid"]),
//obj.numfield1 = result.IsDBNull(ordinals["numfield1"]) ? 0 : result.GetInt32(ordinals["numfield1"]),
//obj.numfield2 = result.IsDBNull(ordinals["numfield2"]) ? 0 : result.GetInt32(ordinals["numfield2"]),
//obj.numfield3 = result.IsDBNull(ordinals["numfield3"]) ? 0 : result.GetInt32(ordinals["numfield3"]),
//obj.textfield1 = result.IsDBNull(ordinals["textfield1"]) ? null : result.GetString(ordinals["textfield1"]),
//obj.textfield2 = result.IsDBNull(ordinals["textfield2"]) ? null : result.GetString(ordinals["textfield2"]),
//obj.textfield3 = result.IsDBNull(ordinals["textfield3"]) ? null : result.GetString(ordinals["textfield3"])
//return obj;
}
/// <summary>
///
/// </summary>
/// <param name="acDomain"></param>
/// <param name="commandType"></param>
/// <param name="record"></param>
/// <returns></returns>
internal static CommandRecord Create(IAcDomain acDomain, MessageTypeKind commandType, System.Data.IDataRecord record)
{
MessageType requestType;
record.GetString(record.GetOrdinal("MessageType")).TryParse(out requestType);
ClientType clientType;
record.GetString(record.GetOrdinal("ClientType")).TryParse(out clientType);
return new CommandRecord(commandType,
record.GetGuid(record.GetOrdinal("Id")),
DataItemsTuple.Create(
acDomain,
record.GetNullableString("InfoId"),
record.GetNullableString("InfoValue"),
record.GetNullableString("QueryList"),
record.GetString(record.GetOrdinal("InfoFormat"))))
{
Verb = new Verb(record.GetString(record.GetOrdinal("Verb"))),
Ontology = record.GetString(record.GetOrdinal("Ontology")),
LocalEntityId = record.GetNullableString("LocalEntityId"),
CatalogCode = record.GetNullableString("CatalogCode"),
ClientId = record.GetString(record.GetOrdinal("ClientId")),
TimeStamp = record.GetDateTime(record.GetOrdinal("TimeStamp")),
ReceivedOn = record.GetDateTime(record.GetOrdinal("ReceivedOn")),
CreateOn = record.GetDateTime(record.GetOrdinal("CreateOn")),
ClientType = clientType,
MessageType = requestType,
MessageId = record.GetString(record.GetOrdinal("MessageId")),
Status = record.GetInt32(record.GetOrdinal("Status")),
ReasonPhrase = record.GetNullableString(record.GetOrdinal("ReasonPhrase")),
Description = record.GetNullableString(record.GetOrdinal("Description")),
EventSubjectCode = record.GetNullableString(record.GetOrdinal("EventSubjectCode")),
EventSourceType = record.GetNullableString(record.GetOrdinal("EventSourceType")),
UserName = record.GetNullableString("UserName"),
IsDumb = record.GetBoolean(record.GetOrdinal("IsDumb")),
Version = record.GetString(record.GetOrdinal("Version"))
};
}
private Model.hierarchy3a GetInstance(System.Data.IDataReader result, System.Collections.Generic.IDictionary<string, int> ordinals)
{
var obj = new Model.hierarchy3a()
{
pid = result.IsDBNull(ordinals["pid"]) ? new Guid() : result.GetGuid(ordinals["pid"]),
fid = result.IsDBNull(ordinals["fid"]) ? 0 : result.GetInt64(ordinals["fid"]),
uid = result.IsDBNull(ordinals["uid"]) ? new Guid() : result.GetGuid(ordinals["uid"]),
numfield1 = result.IsDBNull(ordinals["numfield1"]) ? 0 : result.GetInt32(ordinals["numfield1"]),
numfield2 = result.IsDBNull(ordinals["numfield2"]) ? 0 : result.GetInt32(ordinals["numfield2"]),
numfield3 = result.IsDBNull(ordinals["numfield3"]) ? 0 : result.GetInt32(ordinals["numfield3"]),
textfield1 = result.IsDBNull(ordinals["textfield1"]) ? null : result.GetString(ordinals["textfield1"]),
textfield2 = result.IsDBNull(ordinals["textfield2"]) ? null : result.GetString(ordinals["textfield2"]),
textfield3 = result.IsDBNull(ordinals["textfield3"]) ? null : result.GetString(ordinals["textfield3"])
};
return obj;
}
