public bool Remove(LanguageObject language)
{
SqlCommand cmd = null;
try
{
ExecuteNonQuery(out cmd, false, "Language_DELETE",
CreateParameter("@lanID", SqlDbType.UniqueIdentifier, language.LanID, ParameterDirection.Input)
);
return(true);
}
catch (Exception exception1)
{
Exception innerException = exception1;
throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
}
finally
{
if (cmd != null)
{
cmd.Dispose();
}
cmd = null;
}
}
void AddItem()
{
LanguageObject newItem = new LanguageObject();
languageListObj.languageList.Add(newItem);
viewIndex = languageListObj.languageList.Count;
bool repeats = true;
int k = 0;
while (repeats)
{
for (int i = 0; i < languageListObj.languageList.Count - 1; ++i)
{
if (languageListObj.languageList[i].itemName ==
languageListObj.languageList[viewIndex - 1].itemName + k.ToString())
{
++k;
continue;
}
}
languageListObj.languageList[viewIndex - 1].itemName =
languageListObj.languageList[viewIndex - 1].itemName + k.ToString();
repeats = false;
}
foreach (var entity in languageListObj.languageList[0].words)
{
languageListObj.languageList[viewIndex - 1].words.Add(entity.Key, "");
}
}
void onLanguageSet()
{
currentLanguage = LanguageLocator.GetLanguage();
switch (TextType)
{
case TEXT_TYPE.ALERT:
SetAlertText();
break;
case TEXT_TYPE.BUTTON:
SetButtonText();
break;
case TEXT_TYPE.DIALOGUE:
SetDialogueText();
break;
case TEXT_TYPE.FEEDBACK:
SetFeedbackText();
break;
case TEXT_TYPE.LOADING:
SetLoadingText();
break;
case TEXT_TYPE.RESOLUTION:
SetResolutionText();
break;
}
}
public void Save(LanguageObject language)
{
SqlCommand cmd = null;
try
{
ExecuteNonQuery(out cmd, false, "Language_SAVE",
CreateParameter("@lanID", SqlDbType.UniqueIdentifier, language.LanID, ParameterDirection.InputOutput),
CreateParameter("@Language", SqlDbType.VarChar, language.Language),
CreateParameter("@LanguageDutch", SqlDbType.VarChar, language.LanguageDutch)
);
language.LanID = (Guid)cmd.Parameters["@lanID"].Value;
}
catch (Exception exception1)
{
Exception innerException = exception1;
throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
}
finally
{
if (cmd != null)
{
cmd.Dispose();
}
cmd = null;
}
}
public void Remove(LanguageObject language)
{
try
{
CheckTransaction();
new LanguageDataService(Transaction).Remove(language);
if (IsOwner)
{
Transaction.Commit();
}
}
catch (Exception exception1)
{
if (IsOwner)
{
Transaction.Rollback();
}
Exception innerException = exception1;
throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
}
finally
{
if (IsOwner)
{
Connection.Close();
}
}
}
public ActionResult EditLanguage(LanguageObject model)
{
if (!ModelState.IsValid)
{
return(View(model));
}
model.Save();
return(RedirectToAction("Languages"));
}
public ActionResult EditLanguage(int?id)
{
LanguageObject model = new LanguageObject();
if (id.HasValue)
{
model = MemoryCache.GetLanguage(id.Value);
}
return(View(model));
}
void SetResolutionText(bool isCompleted)
{
LanguageObject language = LanguageLocator.GetLanguage();
Text resolutionText = GetComponentInChildren <Text>();
if (isCompleted)
{
resolutionText.text = language.GetResolutionText(ResolutionText.COMPLETION.SUCCESS);
}
else
{
resolutionText.text = language.GetResolutionText(ResolutionText.COMPLETION.FAILURE);
}
}
private TResult PickingObject()
{
this.objectStore.player.Popup(false);
Face.sprite = Find;
this.targets.Remove(this.target);
if (this.targets.Count == 0)
{
LogEvent("FINISHED");
this.target = null;
return(DoneAllObjects);
}
this.target = this.targets[UnityEngine.Random.Range(0, this.targets.Count)];
elapsedTime = (Int32)(DateTime.UtcNow.Subtract(new DateTime(1970, 1, 1))).TotalSeconds;
return(Hunting);
}
// Use this for initialization
void Start()
{
this.objectStore = GameObject.Find("/Base_Scene").GetComponent <ObjectStore>();
this.state = Idle;
List <LanguageObject> tempTargets = objectStore.words;
for (int i = 0; i < testWordCount; i++)
{
LanguageObject selection = tempTargets[UnityEngine.Random.Range(0, tempTargets.Count)];
tempTargets.Remove(selection);
targets.Add(selection);
}
Debug.Log(targets.Count);
Int32 unixTimestamp = (Int32)(DateTime.UtcNow.Subtract(new DateTime(1970, 1, 1))).TotalSeconds;
filePath = Application.persistentDataPath + "/SCORE_" + unixTimestamp.ToString() + ".csv";
}
public void Save(LanguageObject language)
{
try
{
CheckTransaction();
new LanguageDataService(Transaction).Save(language);
if (IsOwner) Transaction.Commit();
}
catch (Exception exception1)
{
if (IsOwner) Transaction.Rollback();
Exception innerException = exception1;
throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
}
finally
{
if (IsOwner) Connection.Close();
}
}
public bool Remove(LanguageObject language)
{
SqlCommand cmd = null;
try
{
ExecuteNonQuery(out cmd, false, "Language_DELETE",
CreateParameter("@lanID", SqlDbType.UniqueIdentifier, language.LanID, ParameterDirection.Input)
);
return true;
}
catch (Exception exception1)
{
Exception innerException = exception1;
throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
}
finally
{
if (cmd != null)
{
cmd.Dispose();
}
cmd = null;
}
}
public static LanguageObject LanguageRowToObject(DataRow Language, string alias)
{
LanguageObject obj = new LanguageObject();
try
{
if (Language != null)
{
if (RowFunctions.GetValueFromRowToGuid(Language, LanguageObject.ConvertColumnToAlias(LanguageObject.LAN_ID, alias), false, DataRowVersion.Current) != Guid.Empty)
{
obj.LanID = RowFunctions.GetValueFromRowToGuid(Language, LanguageObject.ConvertColumnToAlias(LanguageObject.LAN_ID, alias), true, DataRowVersion.Current);
obj.Language = RowFunctions.GetValueFromRowToString(Language, LanguageObject.ConvertColumnToAlias(LanguageObject.LANGUAGE, alias), false, DataRowVersion.Current);
obj.LanguageDutch = RowFunctions.GetValueFromRowToString(Language, LanguageObject.ConvertColumnToAlias(LanguageObject.LANGUAGE_DUTCH, alias), false, DataRowVersion.Current);
}
return obj;
}
obj = null;
}
catch (System.Exception exception1)
{
Exception innerException = exception1;
throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
}
return obj;
}
void IEditableObject.EndEdit()
{
try
{
if (_inTxn)
{
_loadedTranscID = this.TranscID;
_loadedTransiID = this.TransiID;
_loadedSurname = this.Surname;
_loadedName = this.Name;
_loadedEmail = this.Email;
_loadedArchive = this.Archive;
_loadedTranscLanguage = this.TranscLanguage;
_loadedLanguage = this.Language;
_loadedRepeatMail = this.RepeatMail;
_inTxn = true;
}
}
catch (Exception exception1)
{
Exception innerException = exception1;
throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
}
}
void IEditableObject.EndEdit()
{
try
{
if (_inTxn)
{
_loadedTranscID = this.TranscID;
_loadedTransiID = this.TransiID;
_loadedSurname = this.Surname;
_loadedName = this.Name;
_loadedEmail = this.Email;
_loadedArchive = this.Archive;
_loadedTranscLanguage = this.TranscLanguage;
_loadedLanguage = this.Language;
_loadedRepeatMail = this.RepeatMail;
_inTxn = true;
}
}
catch (Exception exception1)
{
Exception innerException = exception1;
throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
}
}
public void Save(LanguageObject language)
{
SqlCommand cmd = null;
try
{
ExecuteNonQuery(out cmd, false, "Language_SAVE",
CreateParameter("@lanID", SqlDbType.UniqueIdentifier, language.LanID, ParameterDirection.InputOutput),
CreateParameter("@Language", SqlDbType.VarChar, language.Language),
CreateParameter("@LanguageDutch", SqlDbType.VarChar, language.LanguageDutch)
);
language.LanID = (Guid)cmd.Parameters["@lanID"].Value;
}
catch (Exception exception1)
{
Exception innerException = exception1;
throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
}
finally
{
if (cmd != null)
{
cmd.Dispose();
}
cmd = null;
}
}
// Start is called before the first frame update
void Start()
{
currentLanguage = LanguageLocator.GetLanguage();
AssignLanguage.OnLanguageSet += onLanguageSet;
onLanguageSet();
}
private static IEnumerable <Translation> ParseTranslation(string languageCode, LanguageObject clo)
{
// json response is a bit flawed: it returns an object for 1 result, or an array for multiple results. this is difficult to deserialize so that's why this line looks a bit strange
var translations = (clo.Language != null
? new List <Translation> {
new Translation {
Language = languageCode, Text = clo.Language.Text
}
}
: clo.CommonLanguageObjectArray?.Select(nl => new Translation {
Text = nl.Text, Language = languageCode
}).ToList())
?? new List <Translation>();
return(translations);
}
public string BaseQuery(bool selectTop, int top)
{
QueryBuilder builder;
try
{
builder = new QueryBuilder();
if (selectTop == true)
{
builder.SelectTop(top);
}
else
{
builder.Select();
}
builder.AppendColumn(TaskPeopleObject.TPEOP_ID);
builder.AppendColumn(TaskPeopleObject.TASK_ID);
builder.AppendColumn(TaskPeopleObject.EMP_ID);
builder.AppendColumn(TaskPeopleObject.SUP_ID);
builder.AppendColumn(TaskPeopleObject.CUS_ID);
builder.AppendColumn(TaskPeopleObject.ASSIGNEE);
builder.AppendColumn(TaskPeopleObject.REPORTER);
builder.AppendColumn(EmployeeObject.EMP_ID);
builder.AppendColumn(EmployeeObject.EMAIL);
builder.AppendColumn(EmployeeObject.TRANSC_ID);
builder.AppendColumn(EmployeeObject.TRANSI_ID);
builder.AppendColumn(EmployeeObject.NAME);
builder.AppendColumn(EmployeeObject.SURNAME);
builder.AppendColumn(EmployeeObject.ARCHIVE);
builder.AppendColumn(EmployeeObject.LAN_ID);
builder.AppendColumn(EmployeeObject.TRANSC_LANGUAGE);
builder.AppendColumn(EmployeeObject.REPEAT_MAIL);
builder.AppendColumn(LanguageObject.LAN_ID, "EmployeeLanguage");
builder.AppendColumn(LanguageObject.LANGUAGE, "EmployeeLanguage");
builder.AppendColumn(LanguageObject.LANGUAGE_DUTCH, "EmployeeLanguage");
builder.AppendColumn(SupplierObject.SUP_ID);
builder.AppendColumn(SupplierObject.EMAIL);
builder.AppendColumn(SupplierObject.TRANSC_ID);
builder.AppendColumn(UnknownObject.UNK_ID);
builder.AppendColumn(UnknownObject.EMAIL);
builder.AppendColumn(CustomerObject.CUS_ID);
builder.AppendColumn(CustomerObject.TAS_ID);
builder.AppendColumn(CustomerObject.NAME);
builder.AppendColumn(CustomerObject.NAME2);
builder.AppendColumn(CustomerObject.STREET);
builder.AppendColumn(CustomerObject.HOUSE_NUMBER);
builder.AppendColumn(CustomerObject.ZIPCODE);
builder.AppendColumn(CustomerObject.TOWN);
builder.AppendColumn(CustomerObject.COUNTRY);
builder.AppendColumn(CustomerObject.VAT);
builder.AppendColumn(CustomerObject.PHONE);
builder.AppendColumn(CustomerObject.LANGUAGE);
builder.AppendColumn(CustomerObject.CURRENCY);
builder.AppendColumn(TaskObject.CREATION_DATE);
builder.AppendColumn(TaskObject.DUE_DATE);
builder.AppendColumn(TaskObject.EFFORT);
builder.AppendColumn(TaskObject.PRIORITY);
builder.AppendColumn(TaskObject.STATUS);
builder.AppendColumn(TaskObject.TAG);
builder.AppendColumn(TaskObject.TASK_ID);
builder.AppendColumn(TaskObject.UPDATE_DATE);
builder.AppendFromTable(TaskPeopleObject.TABLE);
builder.AppendLeftJoin(EmployeeObject.TABLE, TaskPeopleObject.EMP_ID, EmployeeObject.EMP_ID);
builder.AppendLeftJoin(SupplierObject.TABLE, TaskPeopleObject.SUP_ID, SupplierObject.SUP_ID);
builder.AppendLeftJoin(CustomerObject.TABLE, TaskPeopleObject.CUS_ID, CustomerObject.CUS_ID);
builder.AppendLeftJoin(UnknownObject.TABLE, TaskPeopleObject.UNK_ID, UnknownObject.UNK_ID);
builder.AppendLeftJoin(TaskObject.TABLE, TaskPeopleObject.TASK_ID, TaskObject.TASK_ID);
builder.AppendLeftJoin(LanguageObject.TABLE, "EmployeeLanguage", LanguageObject.ConvertColumnToAlias(LanguageObject.LAN_ID, "EmployeeLanguage"), EmployeeObject.LAN_ID);
return(builder.Query);
}
catch (System.Exception exception1)
{
Exception innerException = exception1;
throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
}
}
public void RegisterLanguageObject(LanguageObject word)
{
words.Add(word);
}
