public List<FormDocumentLanguage> GetAllByDocumentId(int DocumentId, int LanguageId) { FormDocumentLanguageDAC _formDocumentLanguageComponent = new FormDocumentLanguageDAC(); IDataReader reader = _formDocumentLanguageComponent.GetAllFormDocumentLanguage(String.Format("DocumentId = {0} AND LanguageId = {1}", DocumentId, LanguageId)).CreateDataReader(); List<FormDocumentLanguage> _formDocumentLanguageList = new List<FormDocumentLanguage>(); while (reader.Read()) { if (_formDocumentLanguageList == null) _formDocumentLanguageList = new List<FormDocumentLanguage>(); FormDocumentLanguage _formDocumentLanguage = new FormDocumentLanguage(); if (reader["FormDocumentLanguageId"] != DBNull.Value) _formDocumentLanguage.FormDocumentLanguageId = Convert.ToInt32(reader["FormDocumentLanguageId"]); if (reader["DocumentId"] != DBNull.Value) _formDocumentLanguage.DocumentId = Convert.ToInt32(reader["DocumentId"]); if (reader["LanguageId"] != DBNull.Value) _formDocumentLanguage.LanguageId = Convert.ToInt32(reader["LanguageId"]); if (reader["Title"] != DBNull.Value) _formDocumentLanguage.Title = Convert.ToString(reader["Title"]); if (reader["Description"] != DBNull.Value) _formDocumentLanguage.Description = Convert.ToString(reader["Description"]); if (reader["ConfirmationText"] != DBNull.Value) _formDocumentLanguage.ConfirmationText = Convert.ToString(reader["ConfirmationText"]); _formDocumentLanguage.NewRecord = false; _formDocumentLanguageList.Add(_formDocumentLanguage); } reader.Close(); return _formDocumentLanguageList; }
public FormDocumentLanguage GetByID(int _formDocumentLanguageId) { FormDocumentLanguageDAC _formDocumentLanguageComponent = new FormDocumentLanguageDAC(); IDataReader reader = _formDocumentLanguageComponent.GetByIDFormDocumentLanguage(_formDocumentLanguageId); FormDocumentLanguage _formDocumentLanguage = null; while(reader.Read()) { _formDocumentLanguage = new FormDocumentLanguage(); if(reader["FormDocumentLanguageId"] != DBNull.Value) _formDocumentLanguage.FormDocumentLanguageId = Convert.ToInt32(reader["FormDocumentLanguageId"]); if(reader["DocumentId"] != DBNull.Value) _formDocumentLanguage.DocumentId = Convert.ToInt32(reader["DocumentId"]); if(reader["LanguageId"] != DBNull.Value) _formDocumentLanguage.LanguageId = Convert.ToInt32(reader["LanguageId"]); if(reader["Title"] != DBNull.Value) _formDocumentLanguage.Title = Convert.ToString(reader["Title"]); if(reader["Description"] != DBNull.Value) _formDocumentLanguage.Description = Convert.ToString(reader["Description"]); if(reader["ConfirmationText"] != DBNull.Value) _formDocumentLanguage.ConfirmationText = Convert.ToString(reader["ConfirmationText"]); _formDocumentLanguage.NewRecord = false; } reader.Close(); return _formDocumentLanguage; }
public bool Update(FormDocumentLanguage formdocumentlanguage ,int old_formDocumentLanguageId) { FormDocumentLanguageDAC formdocumentlanguageComponent = new FormDocumentLanguageDAC(); return formdocumentlanguageComponent.UpdateFormDocumentLanguage( formdocumentlanguage.DocumentId, formdocumentlanguage.LanguageId, formdocumentlanguage.Title, formdocumentlanguage.Description, formdocumentlanguage.ConfirmationText, old_formDocumentLanguageId); }
public bool Insert(FormDocumentLanguage formdocumentlanguage) { int autonumber = 0; FormDocumentLanguageDAC formdocumentlanguageComponent = new FormDocumentLanguageDAC(); bool endedSuccessfuly = formdocumentlanguageComponent.InsertNewFormDocumentLanguage( ref autonumber, formdocumentlanguage.DocumentId, formdocumentlanguage.LanguageId, formdocumentlanguage.Title, formdocumentlanguage.Description, formdocumentlanguage.ConfirmationText); if(endedSuccessfuly) { formdocumentlanguage.FormDocumentLanguageId = autonumber; } return endedSuccessfuly; }