public virtual T FindByMove(EditFormActionType actionType)
{
switch (actionType)
{
case EditFormActionType.First:
return(First());
case EditFormActionType.Last:
return(Last());
case EditFormActionType.Next:
return(Next());
case EditFormActionType.Previous:
return(Previous());
case EditFormActionType.Edit:
return(Find());
case EditFormActionType.New:
var o = new T();
if (GetKeys.Contains("CompanyCode") && !(Current is tbl_Company))
{
o.SetValue("CompanyCode", Current.GetValue("CompanyCode"));
}
if (GetKeys.Contains("BranchCode") && !(Current is tbl_Branch))
{
o.SetValue("BranchCode", Current.GetValue("BranchCode"));
}
return(o);
}
return(new T());
}
public virtual T Last()
{
var obj = Current;
string tableName = typeof(T).Name;
string keyName = MasterKey.IsNullOrEmpty() ? GetKeys[0] : MasterKey;
StringBuilder sqlStr = new StringBuilder();
sqlStr.Append($"Select Top 1 * from {tableName} Where 1=1 ");
if (GetKeys.Length > 4 && obj.GetType().GetProperties().Any(p => p.Name.Equals("PkId")) && GetKeys.Contains("TrxTypeId") && GetKeys.Contains("CompanyCode") && GetKeys.Contains("BranchCode"))
{
sqlStr.Append($" And CompanyCode ='{obj.GetValue("CompanyCode")}'");
sqlStr.Append($" And BranchCode ='{obj.GetValue("BranchCode")}'");
sqlStr.Append(" Order by PkId Desc");
}
else if (GetKeys.Contains("CompanyCode"))
{
if (GetKeys.Length > 1 && GetKeys.Length <= 4)
{
for (int i = 1; i < GetKeys.Length; i++)
{
sqlStr.Append($" And {GetKeys[i]} ='{obj.GetValue(GetKeys[i])}'");
}
}
sqlStr.Append($" Order by {keyName} Desc");
}
else
{
sqlStr.Append($" Order by {keyName} Desc");
}
T entity = Context.Set <T>().SqlQuery(sqlStr.ToString()).FirstOrDefault() ?? new T();
return(entity);
}
private void ReturnKey()
{
Debug.Assert(m_stack.Count > 0);
Debug.Assert(m_stack.First().eBuild == eBuildStep.ReturnKey);
//m_keys.Push(m_stack.First().iB);
GetKeys.Add(m_stack.First().iB);
m_stack.Pop();
}
public object Get(GetKeys request)
{
var result = _authRepo.Get(new AuthenticationInfoQuery
{
HasUser = false
});
return(result);
}
private void OutputVertex()
{
//Debug.Assert(m_stack.Count > 0);
//Debug.Assert(m_stack.First().eBuild == eBuildStep.ReturnKey);
//GetKeys.Add(m_stack.First().iB);
//m_stack.Pop();
Debug.Assert(m_stack.Count > 0);
Debug.Assert(m_stack.First().eBuild == eBuildStep.OutputVertex);
Debug.Assert(m_keys.Count > 0);
GetKeys.Add(m_keys.Pop());
m_stack.Pop();
}
public virtual T Find(T entity = null)
{
if (entity == null)
{
entity = Current;
}
var keyvalues = new List <object>();
GetKeys.ToList().ForEach(key =>
{
//entity.GetType().GetProperty(key).GetValue(entity)
keyvalues.Add(entity.GetValue(key));
});
return(Context.Set <T>().Find(keyvalues.ToArray()));
}
/// <summary>
/// Returns a view object that displays a list of all the Symbol objects in the dictionary
/// </summary>
/// <returns>Returns a view object that displays a list of all the Symbol objects.
/// When the dictionary is changed, the view object also reflect these changes.</returns>
public PyList keys()
{
return(GetKeys.ToPyList());
}
/// <summary>
/// Creates a shallow copy of the <see cref="IExtendedDictionary{TKey, TValue}"/>.
/// </summary>
/// <returns>Returns a shallow copy of the dictionary. It doesn't modify the original dictionary.</returns>
public PyDict copy()
{
return(fromkeys(GetKeys.ToArray()));
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
#region update lateral menu
//update lateral menu
foreach (Maquina maquina in VARS.Maquinas)
{
divConsultaRegistos.InnerHtml += "<li class=\"nav-item\">";
divConsultaRegistos.InnerHtml += "<a class=\"nav-link\" href=\"/ConsultarRegistos.aspx?id=" + maquina.Id.ToString() + "\">";
divConsultaRegistos.InnerHtml += "<span class=\"menu-title\">" + maquina.Nome + "</span>";
divConsultaRegistos.InnerHtml += "<i class=\"icon-graph menu-icon\"></i>";
divConsultaRegistos.InnerHtml += "</a></li>";
if (VARS.UserSession.AdministratorPermission)
{
divConfiguraMaquinas.InnerHtml += "<li class=\"nav-item\">";
divConfiguraMaquinas.InnerHtml += "<a class=\"nav-link\" href=\"/Configuracoes.aspx?id=" + maquina.Id.ToString() + "\">";
divConfiguraMaquinas.InnerHtml += "<span class=\"menu-title\">" + maquina.Nome + "</span>";
divConfiguraMaquinas.InnerHtml += "<i class=\"icon-wrench menu-icon\"></i>";
divConfiguraMaquinas.InnerHtml += "</a></li>";
}
}
#endregion
}
#region Verifica se está na pagina de consulta de registos com autenticacao externa
if (Page.TemplateControl.AppRelativeVirtualPath.IndexOf("ConsultarRegistos.aspx") != -1)
{
string key = Request.QueryString["key"];
string id = Request.QueryString["id"];
string dtInicio = Request.QueryString["DtInicio"];
string dtFim = Request.QueryString["DtFim"];
string txtOffset = Request.QueryString["Offset"];
if (!string.IsNullOrEmpty(id) && !string.IsNullOrEmpty(key) && !string.IsNullOrEmpty(dtInicio) && !string.IsNullOrEmpty(dtFim) && !string.IsNullOrEmpty(txtOffset))
{
DateTime[] dateTimes = new DateTime[2];
if (string.IsNullOrEmpty(txtOffset))
{
txtOffset = "0";
}
if (DateTime.TryParse(dtInicio, out dateTimes[0]) && DateTime.TryParse(dtFim, out dateTimes[1]))
{
string encriptacao = new GetKeys().Encripta(dtFim + id + txtOffset.Replace(".", ",") + dtInicio).Replace("+", "X").Replace("=", "Y");
Debug.WriteLine("Chave Encriptacao: " + encriptacao);
this.IsViewModeOnly = encriptacao == key;
if (this.IsViewModeOnly)
{
Debug.WriteLine("******** CHAVE VALIDADA *************");
}
else
{
Debug.WriteLine("======== CHAVE INVALIDA =============");
}
}
}
}
#endregion
if (this.IsViewModeOnly && !VARS.UserSession.SessaoIniciada)
{
sidebar.Style.Add("display", "none");
topBar.Style.Add("display", "none");
hiperlink1.HRef = hiperlink2.HRef = "#";
}
if (!VARS.UserSession.SessaoIniciada && !VARS.DebugMode && !this.IsViewModeOnly)
{
Response.Redirect("/Login.aspx");
}
else
{
if (!VARS.UserSession.AdministratorPermission)
{
btnSepConfiguracoes.Visible = false;
btnConfigsAvancadasDB.HRef = "#";
btnConfigsAvancadasDB.Visible = false;
btnGestaoAcessos.HRef = "#";
btnGestaoAcessos.Visible = false;
btnGestaoAcessos.HRef = "#";
btnGestaoAcessos.Visible = false;
btnGestaoEmails.HRef = "#";
btnGestaoEmails.Visible = false;
}
}
}
T existing = context.Set <T>().Find(GetKeys(obj, context));
public List <AppKeyViewModel> Post(GetKeys request)
{
return(CAppManager.GetKeys(request));
}
public static List<RecordToken> GetKeyToEntryIdPairs(Db4oDataSource db4oData, GetKeys getKeys)
{
IExtObjectContainer database = db4oData.Data.Ext();
IQuery query = database.Query();
query.Constrain(typeof(LexEntry));
IObjectSet entries = query.Execute();
List<RecordToken> result = new List<RecordToken>();
foreach (LexEntry entry in entries)
{
foreach (string key in getKeys(entry))
{
result.Add(new RecordToken(key, new Db4oRepositoryId(database.GetID(entry))));
}
}
return result;
}
public virtual T Previous()
{
var obj = Current;
if (obj == null)
{
return(null);
}
T entity;
string tableName = typeof(T).Name;
string keyName = MasterKey.IsNullOrEmpty() ? GetKeys[0] : MasterKey;
string keyValue = obj.GetValue(GetKeys[0]).IsNull();
StringBuilder sqlStr = new StringBuilder();
StringBuilder sqlWhere = new StringBuilder();
sqlStr.Append($"Select * from {tableName} Where 1=1 ");
if (GetKeys.Length > 4 && obj.GetType().GetProperties().Any(p => p.Name.Equals("PkId")) && GetKeys.Contains("TrxTypeId") && GetKeys.Contains("CompanyCode") && GetKeys.Contains("BranchCode"))
{
string s =
$"Select * From {tableName} Where " +
$"TrxTypeId='{obj.GetValue("TrxTypeId")}' And " +
$"YearId='{obj.GetValue("YearId")}' And " +
$"PeriodId='{obj.GetValue("PeriodId")}' And " +
$"CompanyCode='{obj.GetValue("CompanyCode")}' And " +
$"BranchCode='{obj.GetValue("BranchCode")}'";
if (obj.GetValue("TrxNo") != null)
{
s += $"And TrxNo = '{obj.GetValue("TrxNo")}'";
}
keyValue = Context.Set <T>().SqlQuery(s).FirstOrDefault().GetValue("PkId").IsNull(); //obj.GetValue(GetKeys[0]).IsNull();
sqlWhere.Append($" And CompanyCode ='{obj.GetValue("CompanyCode")}'");
sqlWhere.Append($" And BranchCode ='{obj.GetValue("BranchCode")}'");
if (obj.GetValue("TrxNo") != null)
{
sqlStr.Append($"{sqlWhere} And PkId=(Select Max(PkId) from {tableName} Where PkId < '{keyValue}' {sqlWhere})");
}
entity = Context.Set <T>().SqlQuery(sqlStr.ToString()).FirstOrDefault() ?? obj;
}
else if (GetKeys.Contains("CompanyCode"))
{
if (GetKeys.Length > 1 && GetKeys.Length <= 4)
{
for (int i = 1; i < GetKeys.Length; i++)
{
sqlWhere.Append($" And {GetKeys[i]} ='{obj.GetValue(GetKeys[i])}'");
}
}
if (keyValue != "")
{
sqlStr.Append($"{sqlWhere} And {keyName}=(Select Max({keyName}) from {tableName} Where {keyName} < '{keyValue}' {sqlWhere})");
}
entity = Context.Set <T>().SqlQuery(sqlStr.ToString()).FirstOrDefault();
}
else
{
if (keyValue != "")
{
sqlStr.Append($"{sqlWhere} And {keyName}=(Select Max({keyName}) from {tableName} Where {keyName} < '{keyValue}' {sqlWhere})");
}
entity = Context.Set <T>().SqlQuery(sqlStr.ToString()).FirstOrDefault();
}
return(entity ?? obj);
}
public static List <RecordToken> GetKeyToEntryIdPairs(Db4oDataSource db4oData, GetKeys getKeys)
{
IExtObjectContainer database = db4oData.Data.Ext();
IQuery query = database.Query();
query.Constrain(typeof(LexEntry));
IObjectSet entries = query.Execute();
List <RecordToken> result = new List <RecordToken>();
foreach (LexEntry entry in entries)
{
foreach (string key in getKeys(entry))
{
result.Add(new RecordToken(key, new Db4oRepositoryId(database.GetID(entry))));
}
}
return(result);
}
