/// <summary>
/// Find method.
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public Language Find(int id)
{
var langDac = new LanguageDAC();
var result = langDac.SelectById(id);
return(result);
}
/// <summary>
/// Find by language culture
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public Language FindByLangCulture(string langcult)
{
var langDac = new LanguageDAC();
var result = langDac.SelectByLanguageCulture(langcult);
return(result);
}
public bool Insert(string LanguageCode, string Name)
{
LanguageDAC languageComponent = new LanguageDAC();
int LanguageId = 0;
return(languageComponent.InsertNewLanguage(ref LanguageId, LanguageCode, Name));
}
/// <summary>
/// FindAll method.
/// </summary>
/// <returns></returns>
public List <Language> All()
{
var langDac = new LanguageDAC();
var result = langDac.Select();
return(result);
}
public List <Language> GetAll()
{
LanguageDAC _languageComponent = new LanguageDAC();
IDataReader reader = _languageComponent.GetAllLanguage().CreateDataReader();
List <Language> _languageList = new List <Language>();
while (reader.Read())
{
if (_languageList == null)
{
_languageList = new List <Language>();
}
Language _language = new Language();
if (reader["LanguageId"] != DBNull.Value)
{
_language.LanguageId = Convert.ToInt32(reader["LanguageId"]);
}
if (reader["LanguageCode"] != DBNull.Value)
{
_language.LanguageCode = Convert.ToString(reader["LanguageCode"]);
}
if (reader["Name"] != DBNull.Value)
{
_language.Name = Convert.ToString(reader["Name"]);
}
_language.NewRecord = false;
_languageList.Add(_language);
}
reader.Close();
return(_languageList);
}
public Language GetByCode(string LanguageCode)
{
LanguageDAC _languageComponent = new LanguageDAC();
IDataReader reader = _languageComponent.GetByCodeLanguage(LanguageCode);
Language _language = null;
while (reader.Read())
{
_language = new Language();
if (reader["LanguageId"] != DBNull.Value)
{
_language.LanguageId = Convert.ToInt32(reader["LanguageId"]);
}
if (reader["LanguageCode"] != DBNull.Value)
{
_language.LanguageCode = Convert.ToString(reader["LanguageCode"]);
}
if (reader["Name"] != DBNull.Value)
{
_language.Name = Convert.ToString(reader["Name"]);
}
_language.NewRecord = false;
}
reader.Close();
return(_language);
}
public bool Insert(Language language)
{
int autonumber = 0;
LanguageDAC languageComponent = new LanguageDAC();
bool endedSuccessfuly = languageComponent.InsertNewLanguage(ref autonumber, language.LanguageCode, language.Name);
if (endedSuccessfuly)
{
language.LanguageId = autonumber;
}
return(endedSuccessfuly);
}
/// Esta abstracciones están acá si quieren poner los datos en el servicio REST
#region Abstracciones de Datos
private static Language ObtenerIdioma(string languageCulture)
{
LanguageDAC languageDAC = new LanguageDAC();
return(languageDAC.SelectByLanguageCulture(languageCulture));
}
/// <summary>
/// Update method.
/// </summary>
/// <param name="lang"></param>
public void Edit(Language lang)
{
var langDac = new LanguageDAC();
langDac.UpdateById(lang);
}
/// <summary>
/// Delete method.
/// </summary>
/// <param name="id"></param>
public void Remove(int id)
{
var langDac = new LanguageDAC();
langDac.DeleteById(id);
}
/// <summary>
/// Add method.
/// </summary>
/// <param name="lang"></param>
/// <returns></returns>
public Language Add(Language lang)
{
var langDac = new LanguageDAC();
return(langDac.Create(lang));
}
public bool Update(string LanguageCode, string Name, int Original_LanguageId)
{
LanguageDAC languageComponent = new LanguageDAC();
return(languageComponent.UpdateLanguage(LanguageCode, Name, Original_LanguageId));
}
public bool Update(Language language, int old_languageId)
{
LanguageDAC languageComponent = new LanguageDAC();
return(languageComponent.UpdateLanguage(language.LanguageCode, language.Name, old_languageId));
}
public int UpdateDataset(System.Data.DataSet dataset)
{
LanguageDAC languagecomponent = new LanguageDAC();
return(languagecomponent.UpdateDataset(dataset));
}
public void Delete(int Original_LanguageId)
{
LanguageDAC languageComponent = new LanguageDAC();
languageComponent.DeleteLanguage(Original_LanguageId);
}