private void AttAndRemoveAttributeForExcel(List <ObjectitemTabTree> Items, string TypeName)
{
FilterExpression fe = myApplication.CreateFilter();
fe.Add(AttributeId.Designation, BinaryOperator.Equal, TypeName);
var oc = myApplication.Folders.TypeDefinitions.FindObjects(fe, SearchBehavior.Hierarchical, true).FirstOrDefault();
foreach (var Tab in Items)
{
if (!Tab.TabTreeName.Contains("System Attributes"))
{
foreach (var att in Tab.TabTreeChildren)
{
int ssid = int.Parse(att.AddedId);
try
{
oc.Attributes.AddAttributeToMask((AttributeId)ssid, Tab.TabTreeName);
}
catch
{
System.Windows.MessageBox.Show(" Atribute " + ssid + " Already Exist in " + Tab.TabTreeName);
}
}
}
else
{
System.Windows.MessageBox.Show(" Cant Add attributes to " + Tab.TabTreeName + " yet !!");
}
}
}
private void AddFilterExpression(Expression expression)
{
if (FilterExpression == null)
{
FilterExpression = new DynamoExpression(AttributeNames, AttributeValues);
}
FilterExpression.Add(expression);
}
private ObjectItem searchTypeFromDefination(string typeName)
{
FilterExpression fe = myApplication.CreateFilter();
fe.Add(AttributeId.Designation, BinaryOperator.Equal, typeName);
var typeObj = myApplication.Folders.TypeDefinitions.FindObjects(fe, SearchBehavior.Hierarchical, true).FirstOrDefault();
return(typeObj);
}
private static List <int> FetchDataModel(StackAppContext appContext, int parentId, BaseField parentField, IDBEntity entity)
{
var filterExp = new FilterExpression(entity.EntityId);
var relField = (OneToManyField)parentField;
filterExp.Add(new FilterExpField(relField.RefFieldName, FilterOperationType.Equal, parentId));
var ids = entity.ReadIds(appContext, filterExp);
return(ids);
}
protected override void PrepareFilter(DbQuery query, DataListDefinition defn)
{
var itemId = RequestQuery.ItemId;
var filterExp = new FilterExpression(SourceEntityId);
var relField = (RelationalField)EntityField;
filterExp.Add(new FilterExpField(relField.RefFieldName, FilterOperationType.Equal, itemId));
query.SetFixedFilter(filterExp);
}
public DBModelBase Read(StackAppContext appContext, int id, List <string> fields)
{
var exp = new FilterExpression(this.EntityId);
exp.Add(new FilterExpField(this.IDField, FilterOperationType.Equal, id));
var d = ReadAll(appContext, fields, exp);
if (d.Count > 0)
{
return(d.First());
}
throw new UserException("Record is not available with id: " + id.ToString());
}
private ObjectCollection searchAttribute(List <ObjectMaskDescription> Attributes)
{
ObjectCollection AttObj = null;
MultiFilterExpression fa = myApplication.CreateMultiFilter();
int i = 0;
foreach (var item in Attributes)
{
i++;
FilterExpression fe = myApplication.CreateFilter();
fe.Add(AttributeId.Designation, BinaryOperator.Equal, item.Name);
fa.AddFilter(fe);
}
return(AttObj);
}
private void AttAndRemoveAttributeForExcel(List <MaskDescriptionModel> data, string TypeName)
{
FilterExpression fe = myApplication.CreateFilter();
fe.Add(AttributeId.Designation, BinaryOperator.Equal, TypeName);
var oc = myApplication.Folders.TypeDefinitions.FindObjects(fe, SearchBehavior.Hierarchical, true).FirstOrDefault();
foreach (var obj in data)
{
foreach (var item in obj.AttibuteNameAndID)
{
int ssid = int.Parse(item.AttributesIdString);
if (String.Equals(item.Function, "ADD", StringComparison.OrdinalIgnoreCase))
{
try
{
oc.Attributes.AddAttributeToMask((AttributeId)ssid, obj.TabNameString);
}
catch
{
System.Windows.MessageBox.Show(" Atribute " + ssid + " Already Exist in " + obj.TabNameString);
}
}
else if (String.Equals(item.Function, "REMOVE", StringComparison.OrdinalIgnoreCase))
{
try
{
oc.Attributes.Remove((AttributeId)ssid);
}
catch (Exception ex)
{
//System.Windows.MessageBox.Show(" Atribute " + ssid + " Does Not Exist To Remove " + obj.TabNameString);
System.Windows.MessageBox.Show(ex.Message);
}
}
else
{
System.Windows.MessageBox.Show(" Nothing to Remove Or Add Please Check If ADD OR REMOVE Word Has Been Added To Coloum C ");
}
}
}
}
private List <ObjectCollection> searchAttribute(List <ObjectMaskDescription> Attributes)
{
ObjectCollection AttObj = null;
List <ObjectCollection> AttObjList = new List <ObjectCollection>();
MultiFilterExpression fa = myApplication.CreateMultiFilter();
int i = 0;
try
{
if (Attributes.Count != 0)
{
foreach (var item in Attributes)
{
i++;
FilterExpression fe = myApplication.CreateFilter();
var sxc = (int)item.ID;
//fe.FindById((AttributeId)sxc);
fe.Add((AttributeId.Aid), BinaryOperator.Equal, sxc);
fa.AddFilter(fe);
if (i == 25)
{
AttObj = myApplication.Folders.Attributes.FindObjects(fa, true);
fe = myApplication.CreateFilter();
AttObjList.Add(AttObj);
}
else if (i == 50)
{
AttObj = myApplication.Folders.Attributes.FindObjects(fa, true);
fe = myApplication.CreateFilter();
AttObjList.Add(AttObj);
}
}
AttObj = myApplication.Folders.Attributes.FindObjects(fa, SearchBehavior.Deep);
var t = from u in AttObj from k in Attributes where u.Name != k.Name select k;
AttObjList.Add(AttObj);
}
}
catch { System.Windows.MessageBox.Show("Finding Attribute Failed", "System Error", System.Windows.MessageBoxButton.OK, System.Windows.MessageBoxImage.Error); }
return(AttObjList);
}
public int AuthenticateUser(string loginId, string pwd, out string email)
{
var exp = new FilterExpression(this.EntityId);
exp.Add(new FilterExpField("loginid", FilterOperationType.Equal, loginId));
var data = UserDbService.GetUserInfoForAuth(loginId);
email = null;
if (data.Count() > 0)
{
var d = data.First();
email = d.Get("emailid", "");
var userpwd = Decrypt(d.Get("Password", ""));
if (pwd == userpwd)
{
return(d.Get("id", 0));
}
}
return(-1);
}
private void AddFilterExpression(Expression expression)
{
FilterExpression ??= new DynamoExpression(AttributeNames, AttributeValues);
FilterExpression.Add(expression);
}