// #region internal static void delObject(...);
internal static void delObject(
DBConnection dbConnection_in,
long idText_in
//) {
// delObject(
// dbConnection_in,
// idText_in,
// -1
// );
//}
//public static void delObject(
// DBConnection dbConnection_in,
// long idText_in,
// int sourceTableField_ref_in
)
{
DO_DIC_TextLanguage.delRecord_byText(
idText_in,
dbConnection_in
);
DO_DIC_Text.delObject(
idText_in,
dbConnection_in
);
}
internal static void updObject(
DBConnection dbConnection_in,
long idText_in,
params OGen.NTier.Kick.Libraries.DataLayer.Shared.Structures.SO_DIC__TextLanguage[] textLanguage_in
)
{
SO_DIC_TextLanguage _textlanguage;
foreach (OGen.NTier.Kick.Libraries.DataLayer.Shared.Structures.SO_DIC__TextLanguage _text in textLanguage_in)
{
#region _textlanguage = ...;
_textlanguage
= new SO_DIC_TextLanguage(
idText_in,
_text.IFLanguage,
"",
""
);
if (_text.Text.Length > 8000)
{
_textlanguage.Text__large = _text.Text;
_textlanguage.Text__small_isNull = true;
}
else
{
_textlanguage.Text__large_isNull = true;
_textlanguage.Text__small = _text.Text;
}
#endregion
DO_DIC_TextLanguage.setObject(
_textlanguage,
true,
dbConnection_in
);
}
}
public static void delLanguage(
string sessionGuid_in,
string ip_forLogPurposes_in,
int idLanguage_in,
out int[] errors_out
)
{
List <int> _errorlist;
Guid _sessionguid;
Sessionuser _sessionuser;
#region check...
if (!SBO_CRD_Authentication.isSessionGuid_valid(
sessionGuid_in,
ip_forLogPurposes_in,
out _sessionguid,
out _sessionuser,
out _errorlist,
out errors_out
))
{
//// no need!
//errors_out = _errors.ToArray();
return;
}
#endregion
#region check permissions...
if (!_sessionuser.hasPermission(PermissionType.Language__delete))
{
_errorlist.Add(ErrorType.language__lack_of_permissions_to_delete);
errors_out = _errorlist.ToArray();
return;
}
#endregion
#region check existence... SO_DIC_Language _language = ...;
SO_DIC_Language _language = DO_DIC_Language.getObject(idLanguage_in);
if (_language == null)
{
_errorlist.Add(ErrorType.data__not_found);
errors_out = _errorlist.ToArray();
return;
}
#endregion
Exception _exception = null;
#region DBConnection _con = DO__Utilities.DBConnection_createInstance(...);
DBConnection _con = DO__Utilities.DBConnection_createInstance(
DO__Utilities.DBServerType,
DO__Utilities.DBConnectionstring,
DO__Utilities.DBLogfile
);
#endregion
try {
_con.Open();
_con.Transaction.Begin();
DO_DIC_LanguageApplication.delRecord_byLanguage(
idLanguage_in,
_con
);
DO_DIC_TextLanguage.delRecord_byText(
_language.TX_Name,
_con
);
// ONLY language name translations (short), NOT all translations (all)
DO_DIC_TextLanguage.delRecord_byLanguage_short(
idLanguage_in,
_con
);
DO_DIC_Language.delObject(
idLanguage_in,
_con
);
DO_DIC_Text.delObject(
_language.TX_Name,
_con
);
#region _con.Transaction.Commit();
if (_con.Transaction.InTransaction)
{
_con.Transaction.Commit();
}
#endregion
_errorlist.Add(ErrorType.language__successfully_deleted__WARNING);
} catch (Exception _ex) {
#region _con.Transaction.Rollback();
if (
_con.IsOpen
&&
_con.Transaction.InTransaction
)
{
_con.Transaction.Rollback();
}
#endregion
_exception = _ex;
} finally {
#region _con.Transaction.Terminate(); _con.Close(); _con.Dispose();
if (_con.IsOpen)
{
if (_con.Transaction.InTransaction)
{
_con.Transaction.Terminate();
}
_con.Close();
}
_con.Dispose();
#endregion
}
if (_exception != null)
{
#region SBO_LOG_Log.log(ErrorType.data);
OGen.NTier.Kick.Libraries.BusinessLayer.SBO_LOG_Log.log(
_sessionuser,
LogType.error,
ErrorType.data,
-1L,
_sessionuser.IDApplication,
"{0}",
new string[] {
_exception.Message
}
);
#endregion
_errorlist.Add(ErrorType.data);
}
errors_out = _errorlist.ToArray();
}
public static void insLanguage(
string sessionGuid_in,
string ip_forLogPurposes_in,
SO_DIC__TextLanguage[] languageName_in,
SO_DIC__TextLanguage[] existingLanguagesInNewLanguage_in,
out int[] errors_out
)
{
List <int> _errorlist;
Guid _sessionguid;
Sessionuser _sessionuser;
#region check...
if (!SBO_CRD_Authentication.isSessionGuid_valid(
sessionGuid_in,
ip_forLogPurposes_in,
out _sessionguid,
out _sessionuser,
out _errorlist,
out errors_out
))
{
//// no need!
//errors_out = _errors.ToArray();
return;
}
#endregion
#region check permissions...
if (!_sessionuser.hasPermission(PermissionType.Language__insert))
{
_errorlist.Add(ErrorType.language__lack_of_permissions_to_write);
errors_out = _errorlist.ToArray();
return;
}
#endregion
Exception _exception = null;
#region DBConnection _con = DO__Utilities.DBConnection_createInstance(...);
DBConnection _con = DO__Utilities.DBConnection_createInstance(
DO__Utilities.DBServerType,
DO__Utilities.DBConnectionstring,
DO__Utilities.DBLogfile
);
#endregion
try {
_con.Open();
_con.Transaction.Begin();
#region long _idtext = DO_DIC_Text.insObject(...);
#region SO_DIC_Text _text = ...;
SO_DIC_Text _text = new SO_DIC_Text(
-1L,
-1,
-1
);
_text.IFApplication_isNull = true;
_text.SourceTableField_ref_isNull = true;
#endregion
long _idtext = DO_DIC_Text.insObject(
_text,
true,
_con
);
#endregion
#region int _idlanguage = DO_DIC_Language.insObject(...);
int _idlanguage = DO_DIC_Language.insObject(
new SO_DIC_Language(
-1,
_idtext
),
true,
_con
);
#endregion
for (int i = 0; i < languageName_in.Length; i++)
{
updObject(
_con,
_idtext,
(languageName_in[i].IFLanguage > 0)
// name of the new language on existing languages
? languageName_in[i]
// name of the new language (on new language)
: new SO_DIC__TextLanguage(
_idlanguage,
languageName_in[i].Text
)
);
}
SO_DIC_TextLanguage _textlanguage;
for (int i = 0; i < existingLanguagesInNewLanguage_in.Length; i++)
{
_textlanguage = new SO_DIC_TextLanguage();
_textlanguage.IFText = DO_DIC_Language.getObject(
existingLanguagesInNewLanguage_in[i].IFLanguage
).TX_Name;
_textlanguage.IFLanguage = _idlanguage;
if (existingLanguagesInNewLanguage_in[i].Text.Length > 8000)
{
_textlanguage.Text__large = existingLanguagesInNewLanguage_in[i].Text;
_textlanguage.Text__small_isNull = true;
}
else
{
_textlanguage.Text__large_isNull = true;
_textlanguage.Text__small = existingLanguagesInNewLanguage_in[i].Text;
}
DO_DIC_TextLanguage.setObject(
_textlanguage,
true,
_con
);
}
#region _con.Transaction.Commit();
if (_con.Transaction.InTransaction)
{
_con.Transaction.Commit();
}
#endregion
_errorlist.Add(ErrorType.language__successfully_created__WARNING);
} catch (Exception _ex) {
#region _con.Transaction.Rollback();
if (
_con.IsOpen
&&
_con.Transaction.InTransaction
)
{
_con.Transaction.Rollback();
}
#endregion
_exception = _ex;
} finally {
#region _con.Transaction.Terminate(); _con.Close(); _con.Dispose();
if (_con.IsOpen)
{
if (_con.Transaction.InTransaction)
{
_con.Transaction.Terminate();
}
_con.Close();
}
_con.Dispose();
#endregion
}
if (_exception != null)
{
#region SBO_LOG_Log.log(ErrorType.data);
OGen.NTier.Kick.Libraries.BusinessLayer.SBO_LOG_Log.log(
_sessionuser,
LogType.error,
ErrorType.data,
-1L,
_sessionuser.IDApplication,
"{0}",
new string[] {
_exception.Message
}
);
#endregion
_errorlist.Add(ErrorType.data);
}
errors_out = _errorlist.ToArray();
}
