public List<OrganizationLanguages> GetAllByOrganizationId(int OrganizationId)
{
OrganizationLanguagesDAC _organizationLanguagesComponent = new OrganizationLanguagesDAC();
IDataReader reader = _organizationLanguagesComponent.GetAllOrganizationLanguages("OrganizationId = " + OrganizationId).CreateDataReader();
List<OrganizationLanguages> _organizationLanguagesList = new List<OrganizationLanguages>();
while (reader.Read())
{
if (_organizationLanguagesList == null)
_organizationLanguagesList = new List<OrganizationLanguages>();
OrganizationLanguages _organizationLanguages = new OrganizationLanguages();
if (reader["OrganizationLanguagesId"] != DBNull.Value)
_organizationLanguages.OrganizationLanguagesId = Convert.ToInt32(reader["OrganizationLanguagesId"]);
if (reader["OrganizationId"] != DBNull.Value)
_organizationLanguages.OrganizationId = Convert.ToInt32(reader["OrganizationId"]);
if (reader["LanguageId"] != DBNull.Value)
_organizationLanguages.LanguageId = Convert.ToInt32(reader["LanguageId"]);
if (reader["OrganizationName"] != DBNull.Value)
_organizationLanguages.OrganizationName = Convert.ToString(reader["OrganizationName"]);
if (reader["OrganizationDescription"] != DBNull.Value)
_organizationLanguages.OrganizationDescription = Convert.ToString(reader["OrganizationDescription"]);
if (reader["AddressLine1"] != DBNull.Value)
_organizationLanguages.AddressLine1 = Convert.ToString(reader["AddressLine1"]);
if (reader["AddressLine2"] != DBNull.Value)
_organizationLanguages.AddressLine2 = Convert.ToString(reader["AddressLine2"]);
_organizationLanguages.NewRecord = false;
_organizationLanguagesList.Add(_organizationLanguages);
} reader.Close();
return _organizationLanguagesList;
}
public OrganizationLanguages GetByID(int _organizationLanguagesId)
{
OrganizationLanguagesDAC _organizationLanguagesComponent = new OrganizationLanguagesDAC();
IDataReader reader = _organizationLanguagesComponent.GetByIDOrganizationLanguages(_organizationLanguagesId);
OrganizationLanguages _organizationLanguages = null;
while(reader.Read())
{
_organizationLanguages = new OrganizationLanguages();
if(reader["OrganizationLanguagesId"] != DBNull.Value)
_organizationLanguages.OrganizationLanguagesId = Convert.ToInt32(reader["OrganizationLanguagesId"]);
if(reader["OrganizationId"] != DBNull.Value)
_organizationLanguages.OrganizationId = Convert.ToInt32(reader["OrganizationId"]);
if(reader["LanguageId"] != DBNull.Value)
_organizationLanguages.LanguageId = Convert.ToInt32(reader["LanguageId"]);
if(reader["OrganizationName"] != DBNull.Value)
_organizationLanguages.OrganizationName = Convert.ToString(reader["OrganizationName"]);
if(reader["OrganizationDescription"] != DBNull.Value)
_organizationLanguages.OrganizationDescription = Convert.ToString(reader["OrganizationDescription"]);
if(reader["AddressLine1"] != DBNull.Value)
_organizationLanguages.AddressLine1 = Convert.ToString(reader["AddressLine1"]);
if(reader["AddressLine2"] != DBNull.Value)
_organizationLanguages.AddressLine2 = Convert.ToString(reader["AddressLine2"]);
_organizationLanguages.NewRecord = false; } reader.Close();
return _organizationLanguages;
}
public bool Update(OrganizationLanguages organizationlanguages ,int old_organizationLanguagesId)
{
OrganizationLanguagesDAC organizationlanguagesComponent = new OrganizationLanguagesDAC();
return organizationlanguagesComponent.UpdateOrganizationLanguages( organizationlanguages.OrganizationId, organizationlanguages.LanguageId, organizationlanguages.OrganizationName, organizationlanguages.OrganizationDescription, organizationlanguages.AddressLine1, organizationlanguages.AddressLine2, old_organizationLanguagesId);
}
public bool Insert(OrganizationLanguages organizationlanguages)
{
int autonumber = 0;
OrganizationLanguagesDAC organizationlanguagesComponent = new OrganizationLanguagesDAC();
bool endedSuccessfuly = organizationlanguagesComponent.InsertNewOrganizationLanguages( ref autonumber, organizationlanguages.OrganizationId, organizationlanguages.LanguageId, organizationlanguages.OrganizationName, organizationlanguages.OrganizationDescription, organizationlanguages.AddressLine1, organizationlanguages.AddressLine2);
if(endedSuccessfuly)
{
organizationlanguages.OrganizationLanguagesId = autonumber;
}
return endedSuccessfuly;
}