/// <summary>
/// Read a language
/// </summary>
/// <param name="lngIsoCode"></param>
/// <returns></returns>
internal Language_DTO_Create Read(string lngIsoCode)
{
ADO Ado = new ADO("defaultConnection");
try
{
Language_DTO_Create dto = new Language_DTO_Create();
Language_ADO lAdo = new Language_ADO(Ado);
Language_DTO_Read readDTO = new Language_DTO_Read();
readDTO.LngIsoCode = lngIsoCode;
var retval = lAdo.Read(readDTO);
if (retval.hasData)
{
dto.LngIsoCode = lngIsoCode;
dto.LngIsoName = retval.data[0].LngIsoName;
}
return(dto);
}
catch (Exception ex)
{
throw ex;
}
finally
{
Ado.Dispose();
}
}
/// <summary>
/// Execute
/// </summary>
/// <returns></returns>
protected override bool Execute()
{
//Validation of parameters and user have been successful. We may now proceed to read from the database
var adoLanguage = new Language_ADO(Ado);
//First we must check if the language exists already (we can't have duplicates)
if (adoLanguage.Exists(DTO.LngIsoCode))
{
//This language exists already, we can't proceed
Log.Instance.Debug("The ISO Code '" + DTO.LngIsoCode + "' exists already.");
Response.error = Label.Get("error.duplicate");
return(false);
}
//Create the language - and retrieve the newly created Id
int newId = adoLanguage.Create(DTO, SamAccountName);
if (newId == 0)
{
Log.Instance.Debug("Can't Create Language");
Response.error = Label.Get("error.create");
return(false);
}
Response.data = JSONRPC.success;
return(true);
}
/// <summary>
/// Execute
/// </summary>
/// <returns></returns>
protected override bool Execute()
{
var adoLanguage = new Language_ADO(Ado);
//Check if the language is used in a related entity. If so, we can't proceed with the delete request
if (adoLanguage.IsInUse(DTO.LngIsoCode))
{
//The language is in use by at least one related entity, we cannot proceed with the delete request
Log.Instance.Debug("The ISO Code '" + DTO.LngIsoCode + "' is currently is use and cannot be deleted.");
Response.error = Label.Get("error.delete");
return(false);
}
//attempting to delete. The number of entities deleted are passed to the entitiesDeleted variable (this is 1 for a successful delete)
int nDeleted = adoLanguage.Delete(DTO, SamAccountName);
if (nDeleted == 0)
{
Log.Instance.Debug("Can't delete Language");
Ado.RollbackTransaction();
Response.error = Label.Get("error.delete");
return(false);
}
Ado.CommitTransaction();
Response.data = JSONRPC.success;
return(true);
}
/// <summary>
/// Execute
/// </summary>
/// <returns></returns>
protected override bool Execute()
{
var adoLanguage = new Language_ADO(Ado);
Response.data = adoLanguage.ReadListByRelease(DTO.RlsCode);
return(true);
}
/// <summary>
/// Execute
/// </summary>
/// <returns></returns>
protected override bool Execute()
{
//Validation of parameters and user have been successful. We may now proceed to read from the database
var adoLanguage = new Language_ADO(Ado);
//Languages are returned as an ADO result
ADO_readerOutput result = adoLanguage.Read(DTO);
if (!result.hasData)
{
return(false);
}
Response.data = result.data;
return(true);
}
/// <summary>
///
/// </summary>
/// <returns></returns>
protected override bool Execute()
{
var adoLanguage = new Language_ADO(Ado);
//Create the language - and retrieve the number of updated rows
int nUpdated = adoLanguage.Update(DTO, SamAccountName);
if (nUpdated == 0)
{
Log.Instance.Debug("No record has been updated");
Ado.RollbackTransaction();
Response.error = Label.Get("error.update");
return(false);
}
Log.Instance.Debug("Language updated: " + JsonConvert.SerializeObject(DTO));
Ado.CommitTransaction();
Response.data = JSONRPC.success;
return(true);
}
/// <summary>
/// Execute
/// </summary>
/// <returns></returns>
protected override bool Execute()
{
//Validation of parameters and user have been successful. We may now proceed to read from the database
var adoLanguage = new Language_ADO(Ado);
LanguageUtility lu = new LanguageUtility();
var languageFileNames = lu.GetLanguageCodes();
if (!languageFileNames.Contains(DTO.LngIsoCode))
{
//This language exists already, we can't proceed
Log.Instance.Debug("You must create a language file in resources for language " + DTO.LngIsoName);
Response.error = Label.Get("error.settings.language-json-invalid");
return(false);
}
//First we must check if the language exists already (we can't have duplicates)
if (adoLanguage.Exists(DTO.LngIsoCode))
{
//This language exists already, we can't proceed
Log.Instance.Debug("The ISO Code '" + DTO.LngIsoCode + "' exists already.");
Response.error = Label.Get("error.duplicate");
return(false);
}
//Create the language - and retrieve the newly created Id
int newId = adoLanguage.Create(DTO, SamAccountName);
if (newId == 0)
{
Log.Instance.Debug("Can't Create Language");
Response.error = Label.Get("error.create");
return(false);
}
Response.data = JSONRPC.success;
return(true);
}
