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