private async Task <bool> _CheckValidTo(ISession session, IEntity entity, IEntityWalker walker, DateTime dtValidTo, CancellationToken ct)
{
string uidLicence = entity.GetValue("UID_Licence");
// do not check Empty values
if (DbVal.IsEmpty(uidLicence, ValType.String))
{
return(true);
}
if (DbVal.IsEmpty(dtValidTo, ValType.Date))
{
return(true);
}
// Get VailidFrom Licence
DateTime dtValidToLicence = await walker.GetValueAsync <DateTime>("FK(UID_Licence).ValidTo", ct).ConfigureAwait(false);
// Date in Licence is defined ?
if (!DbVal.IsEmpty(dtValidToLicence, ValType.Date))
{
// and smaler than our Date?
if (dtValidToLicence < dtValidTo)
{
// Get Licence-Display
string strLicence = await entity.Columns["UID_Licence"].GetDisplayValueAsync(session, ct).ConfigureAwait(false);
// throw exception
throw new ViException(2133215, ExceptionRelevance.EndUser, strLicence, dtValidToLicence);
}
}
return(true);
}
/// <summary>
/// Gibt es in der Datenbank bereits neuere Einträge für Installationen?
/// </summary>
/// <param name="lastModified">Letzte Modifikation des Feedback-Files.</param>
/// <param name="account"></param>
/// <param name="machine"></param>
public bool NewerInstallDataDoesExist(DateTime lastModified, ISingleDbObject account, ISingleDbObject machine)
{
var exec = Conn.CreateSqlExecutor(ConnectData.PublicKey);
var sql = GetCountOfNewerStatement(lastModified, account, machine);
int cnt = (int)DbVal.ConvertTo(exec.SqlExecuteScalar(sql), ValType.Int);
return(cnt > 0);
}
/// <summary>
/// hat sich der Wert der Spalte geändert, wird UpdatePathVII auf TRUE gesetzt
/// </summary>
private void UpdatePathVII_ValueSet(object sender, ColumnEventArgs e)
{
using (NoRightsCheck())
{
if (DbVal.Compare(e.OldValue, e.NewValue, e.Column.ColDef.Type) != 0)
{
SetValue("UpdatePathVII", true);
}
}
}
private void _Load(VI.Controls.Interfaces.ITreeListControl treeList, bool loadApps)
{
ITreeListProxy proxy = treeList.Proxy;
using (new UpdateHelper(treeList))
{
proxy.Clear();
// Daten holen und prüfen
ISingleDbObject dbobject = m_MainActivator.DbObject;
if (dbobject == null)
{
return;
}
IColDbObject col = Connection.CreateCol("MachineAppsInfo");
col.Prototype["displayname"].IsDisplayItem = true;
col.Prototype["CurrentlyActive"].IsDisplayItem = true;
col.Prototype["Installdate"].IsDisplayItem = true;
col.Prototype["deinstalldate"].IsDisplayItem = true;
col.Prototype["revision"].IsDisplayItem = true;
col.Prototype["UID_OS"].IsDisplayItem = true;
col.Prototype["UID_InstallationType"].IsDisplayItem = true;
col.Prototype.WhereClause = SqlFormatter.AndRelation(!FormTool.CanSee(dbobject, "UID_HardWare") ? "1=2" :
SqlFormatter.UidComparison("UID_Hardware", dbobject["UID_HardWare"].New.String),
SqlFormatter.Comparison("AppsNotDriver", loadApps, ValType.Bool));
col.Prototype.OrderBy = "Displayname, Installdate, DeInstallDate";
col.Load(CollectionLoadType.ForeignDisplays);
foreach (IColElem elem in col)
{
ITreeListNode node = proxy.AddNode(elem.GetDisplayValue("displayname"), (int)VI.ImageLibrary.StockImage.ApplicationProfile);
ITreeListItemSmall item = proxy.CreateCheckBoxItem(elem.GetValue("CurrentlyActive").Bool);
item.Enabled = false;
proxy.AddItem(node, item);
DateTime date = elem.GetValue("Installdate").Date;
item = proxy.AddItem(node, DbVal.IsEmpty(date, ValType.Date) ? "" : date.ToString());
item.Data = date;
date = elem.GetValue("deinstalldate").Date;
item = proxy.AddItem(node, DbVal.IsEmpty(date, ValType.Date) ? "" : date.ToString());
item.Data = date;
item = proxy.AddItem(node, elem["Revision"]);
item.Data = elem.GetValue("Revision").Int;
proxy.AddItem(node, elem.GetDisplayValue("UID_OS"));
proxy.AddItem(node, elem.GetDisplayValue("UID_InstallationType"));
}
}
}
public virtual string GetData(string column)
{
DbVal dbVal = _data[column] as DbVal;
if (dbVal == null)
{
throw new Exception(String.Format("Invalid Columnname {0} for GetData in ObjectBase.", column));
}
return(dbVal.ToString());
}
public ObjectServer(IDataReader rData)
{
DbVal dbVal;
string strColumn;
for (int iCol = 0; iCol < rData.FieldCount; iCol++)
{
// get the data
dbVal = new DbVal(rData.GetValue(iCol));
strColumn = rData.GetName(iCol).ToLowerInvariant();
// add to data hash
_data.Add(strColumn, dbVal);
}
}
/// <summary>
/// FormMethode Copy
/// </summar>
public void FormMethod_Copy()
{
try
{
// Daten holen und prüfen
ISingleDbObject dbobject = m_MainActivator.DbObject;
if (dbobject == null)
{
return;
}
if (m_Combo1.SelectedIndex >= 0 && m_Combo1.SelectedIndex <= 4)
{
if (FormTool.ShowQuestion("SDL_FormApplicationProfileCopyAll_Question_ApplyChanges", MessageBoxButtons.YesNo) != DialogResult.Yes)
{
return;
}
}
object starttime = DbVal.MinDate;
if (m_Option2.Checked)
{
starttime = DbVal.ToUniversalTime(m_DateTimePicker1.Value, TimeZoneInfo.Local);
}
switch (m_Combo1.SelectedIndex)
{
case 0:
dbobject.Custom.CallMethod("SvrCopy", "CopyCL2FDS", "", "", starttime, m_StrDestDomain, false /*m_Checkbox1.Checked*/);
break;
case 1:
dbobject.Custom.CallMethod("SvrCopy", "CopyCL2TAS", "", "", starttime, m_StrDestDomain, false /*m_Checkbox1.Checked*/);
break;
}
}
catch (Exception ex)
{
// Fehler melden
VI.FormBase.ExceptionMgr.Instance.HandleException(
new FormCustomizerException(929001, ex, GetString("SDL_FormApplicationProfileCopyAll_Copy").Replace("&", "")), this);
}
}
public static bool ExistsCopyJobs(NodeType nodeType, string strUID_Server, string strUID_Profile)
{
ISingleDbObject dbObject;
string strScript;
bool bReturn = false;
switch (nodeType)
{
case NodeType.AppProfile:
dbObject = clsMain.Instance.CurrentConnection.Connection.CreateSingle("ApplicationProfile");
strScript = "VI_AE_ApplicationProfileCopyRunning";
break;
case NodeType.DrvProfile:
dbObject = clsMain.Instance.CurrentConnection.Connection.CreateSingle("DriverProfile");
strScript = "VI_AE_DriverProfileCopyRunning";
break;
case NodeType.MacType:
dbObject = clsMain.Instance.CurrentConnection.Connection.CreateSingle("MachineType");
strScript = "VI_AE_MachineTypeCopyRunning";
break;
default:
return(false);
}
ScriptRunner scr = new ScriptRunner(
clsMain.Instance.CurrentConnection.Connection.Scripts["scripts"],
dbObject);
// Script Exists ???
if (scr.Class.HasMethod(strScript))
{
bReturn = new DbVal(scr.Eval(strScript, new object[] { strUID_Server, strUID_Profile })).Bool;
}
else
{
bReturn = false; // No script, no check
}
return(bReturn);
}
public override async Task <Diff> OnSavingAsync(IEntity entity, LogicReadWriteParameters parameters, CancellationToken cancellationToken)
{
LogicParameter lp = new LogicParameter(entity, parameters, cancellationToken);
if (!entity.IsLoaded &&
DbVal.IsEmpty(entity.GetValue <int>("OrderNumber"), ValType.Int))
{
await _SetRightOrderNumber(lp).ConfigureAwait(false);;
}
if (!entity.IsLoaded)
{
await ModProfile.IsUniqueAKProfile(lp).ConfigureAwait(false);
}
if (!entity.IsDeleted())
{
await _HandleTroubleProduct(lp).ConfigureAwait(false);
}
return(await base.OnSavingAsync(entity, parameters, cancellationToken).ConfigureAwait(false));
}
/// <summary>
/// Will be executed before the object is saved to the database.
/// </summary>
protected override void OnSaving()
{
if (!DbObject.IsLoaded &&
DbVal.IsEmpty(DbObject.GetValue("OrderNumber").Int, ValType.Int))
{
_SetRightOrderNumber();
}
ModProfile.CheckAndSetOSMode(DbObject, "OSMode", DbObject["OsMode"].New.String);
if (!DbObject.IsLoaded)
{
ModProfile.IsUniqueAKProfile(DbObject);
}
if (!DbObject.IsDeleted)
{
_HandleTroubleProduct();
}
base.OnSaving();
}
/// <summary>
///
/// </summary>
private void Copy()
{
try
{
// Daten holen und prüfen
ISingleDbObject dbobject = m_MainActivator.DbObject;
if (dbobject == null || dbobject.Custom == null)
{
return;
}
using (new VI.Controls.WaitCursor())
{
object starttime = DbVal.MinDate;
if (m_Option2.Checked)
{
starttime = DbVal.ToUniversalTime(m_DateTimePicker1.Value, TimeZoneInfo.Local);
}
switch (m_Combo1.SelectedIndex)
{
case 0:
dbobject.Custom.CallMethod("SvrCopy", "CopyFDS2CL", "", "", starttime, "");
break;
case 1:
if (m_Combo2.SelectedIndex >= 0)
{
dbobject.Custom.CallMethod("SvrCopy", "CopyFDS_P2FDS_C", "",
m_ColAppServer[m_Combo2.SelectedIndex]["UID_Server"].ToString(), starttime, "");
break;
}
else
{
FormTool.ShowMessage("SDL_FormApplicationProfileCopyAll_Message_ChildServer");
}
break;
case 2:
if (m_Combo2.SelectedIndex >= 0)
{
dbobject.Custom.CallMethod("SvrCopy", "CopyFDS_C2FDS_P", "",
m_ColAppServer[m_Combo2.SelectedIndex]["UID_Server"].ToString(), starttime, "");
break;
}
else
{
FormTool.ShowMessage("SDL_FormApplicationProfileCopyAll_Message_ChildServer");
}
break;
case 3:
dbobject.Custom.CallMethod("SvrCopy", "CopyFDS2TAS", "", "", starttime, "");
break;
case 4:
dbobject.Custom.CallMethod("SvrCopy", "CopyTAS2FDS", "", "", starttime, "");
break;
default:
FormTool.ShowMessage("SDL_FormApplicationProfileCopyAll_Message_Action");
break;
}
}
}
catch (Exception ex)
{
// Fehler melden
HandleException(ex);
}
}
/// <summary>
/// FormMethode Copy
/// </summary>
public void FormMethod_Copy()
{
try
{
// Daten holen und prüfen
ISingleDbObject dbobject = m_MainActivator.DbObject;
if (dbobject?.Custom == null)
{
return;
}
if (m_Combo1.SelectedIndex == 0 || m_Combo1.SelectedIndex == 1 || m_Combo1.SelectedIndex == 4 ||
((m_Combo1.SelectedIndex == 2 || m_Combo1.SelectedIndex == 3) && m_Combo2.SelectedIndex >= 0))
{
if (FormTool.ShowQuestion("SDL_FormApplicationProfileCopyAll_Question_ApplyChanges", MessageBoxButtons.YesNo) != DialogResult.Yes)
{
return;
}
}
object starttime = DbVal.MinDate;
if (m_Option2.Checked)
{
starttime = DbVal.ToUniversalTime(m_DateTimePicker1.Value, TimeZoneInfo.Local);
}
switch (m_Combo1.SelectedIndex)
{
case 0:
dbobject.Custom.CallMethod("SvrCopy", "CopyTAS2FDS", "", "", starttime, "", false /*m_Checkbox1.Checked*/);
break;
case 1:
dbobject.Custom.CallMethod("SvrCopy", "CopyFDS2CL", "", "", starttime, "", false /*m_Checkbox1.Checked*/);
break;
case 2:
if (m_Combo2.SelectedIndex >= 0)
{
dbobject.Custom.CallMethod("SvrCopy", "CopyFDS_P2FDS_C", "",
m_ColAppServer[m_Combo2.SelectedIndex]["UID_Server"].ToString(), starttime, "", false /*m_Checkbox1.Checked*/);
}
else
{
FormTool.ShowMessage("SDL_FormApplicationProfileCopyAll_Message_ChildServer");
}
break;
case 3:
if (m_Combo2.SelectedIndex >= 0)
{
dbobject.Custom.CallMethod("SvrCopy", "CopyFDS_C2FDS_P",
m_ColAppServer[m_Combo2.SelectedIndex]["UID_Server"].ToString(), "", starttime, "", false /*m_Checkbox1.Checked*/);
}
else
{
FormTool.ShowMessage("SDL_FormApplicationProfileCopyAll_Message_ChildServer");
}
break;
case 4:
dbobject.Custom.CallMethod("SvrCopy", "CopyFDS2TAS", "", "", starttime, "", false /*m_Checkbox1.Checked*/);
break;
default:
FormTool.ShowMessage("SDL_FormApplicationProfileCopyAll_Message_Action");
break;
}
}
catch (Exception ex)
{
// Fehler melden
ExceptionMgr.Instance.HandleException(
new FormCustomizerException(929001, ex, GetString("SDL_FormApplicationProfileCopyAll_Copy").Replace("&", "")), this);
}
}
public async Task <T> Dereference <T>(DbVal <T> value) where T : IDbItem => await Repos <T>().Read(value.ToId());
