public void ToString_GivenConditionValues_ShouldReturnExpectedStatement(string leftConditionTableName, string leftConditionColumnName, EqualityOperators leftConditionOperator, object leftConditionValue,
BooleanOperator booleanOperator,
string rightConditionTableName, string rightConditionColumnName, EqualityOperators rightConditionOperator, object rightConditionValue,
string expectedStatement)
{
//---------------Set up test pack-------------------
var leftCondition = new ConditionModel(leftConditionTableName, leftConditionColumnName, leftConditionOperator, leftConditionValue)
{
DatabaseProvider = new SqlServerDatabaseProvider()
};
var rightCondition = new ConditionModel(rightConditionTableName, rightConditionColumnName, rightConditionOperator, rightConditionValue)
{
DatabaseProvider = new SqlServerDatabaseProvider()
};
var compoundCondition = new CompoundConditionModel(leftCondition, booleanOperator, rightCondition)
{
DatabaseProvider = new SqlServerDatabaseProvider()
};
//---------------Assert Precondition----------------
//---------------Execute Test ----------------------
var selectStatement = compoundCondition.ToString();
//---------------Test Result -----------------------
Assert.AreEqual(expectedStatement, selectStatement);
}
private void ImportConditons()
{
foreach (ConditionModel conditionModel in _conditions)
{
if (_addAllEntries)
{
_compendium.AddCondition(conditionModel);
}
else if (_skipDuplicateEntries)
{
if (!_compendium.Conditions.Any(x => x.Name.Equals(conditionModel.Name, StringComparison.CurrentCultureIgnoreCase)))
{
_compendium.AddCondition(conditionModel);
}
}
else if (_replaceExistingEntries)
{
ConditionModel existing = _compendium.Conditions.FirstOrDefault(x => x.Name.Equals(conditionModel.Name, StringComparison.CurrentCultureIgnoreCase));
if (existing == null)
{
_compendium.AddCondition(conditionModel);
}
else
{
conditionModel.Id = existing.Id;
_compendium.UpdateCondition(conditionModel);
}
}
}
}
private void CreateUI(ConditionModel model)
{
Func <ConditionModel, string> funHtml = UIStart.getInstance(model).CreatePageUIByType;
Func <ConditionModel, string> funCs = UIStart.getInstance(model).CreatePageCSByType;
#region TCControls
if (RbtnListAndEdit.IsChecked == true)
{
TcControls.Items.Clear();
TcControls.Items.Add(CreateUITabItem("ViewPageHtml", model, ePageType.ViewPage, funHtml));
TcControls.Items.Add(CreateUITabItem("VIewPageCs", model, ePageType.ViewPage, funCs));
TcControls.Items.Add(CreateUITabItem("EditPageHtml", model, ePageType.EditPage, funHtml));
TcControls.Items.Add(CreateUITabItem("EditPageCs", model, ePageType.EditPage, funCs));
}
else if (RbtnListEditListBox.IsChecked == true)
{
TcControls.Items.Clear();
TcControls.Items.Add(CreateUITabItem("简单编辑页面HTML", model, ePageType.ViewEditPageListBox, funHtml));
TcControls.Items.Add(CreateUITabItem("简单编辑页面CS", model, ePageType.ViewEditPageListBox, funCs));
}
else if (RbtnListEditRepeater.IsChecked == true)
{
TcControls.Items.Clear();
TcControls.Items.Add(CreateUITabItem("编辑页面HTML", model, ePageType.ViewEditPageRepeater, funHtml));
TcControls.Items.Add(CreateUITabItem("编辑页面CS", model, ePageType.ViewEditPageRepeater, funCs));
}
#endregion
}
public ActionResult GetPhysicalMetal(int materialId, int sourceMaterialId, int sourceId, int subgroupId, int groupId, int conditionId, string searchText, int type)
{
if (type == 2)
{
type = 1;
}
if (type == 3)
{
type = 2;
}
string sessionId = System.Web.HttpContext.Current.Session["TotalMateriaSession"].ToString();
ConditionModel conditionData = new ConditionModel();
Condition cond = new ConditionTMMetalsBinder().FillPhysicalConditionData(sourceMaterialId, conditionId, materialContextUow, type, sessionId);
conditionData.ConditionId = cond.ConditionId;
conditionData.ConditionName = cond.ConditionName;
conditionData.Properties = cond.Properties;
conditionData.ProductGroupId = ProductGroup.ProductGroupType.Physical;
IService service = new TotalMateriaService();
conditionData.SelectedReferences = service.GetReferencesForSelectedConditionFromService(sessionId, sourceMaterialId, cond.ConditionId, MaterialDetailType.PhysicalProperties);
return(Json(ResponseStatus.Success, RenderPartialViewToString("ConditionPropertiesContent", conditionData), JsonRequestBehavior.AllowGet));
}
/// <summary>
/// Updates the compendium condition with id matching the parameter's id
/// </summary>
public void UpdateCondition(ConditionModel model)
{
ConditionModel currentModel = _conditions.FirstOrDefault(x => x.Id == model.Id);
if (currentModel != null)
{
string oldName = currentModel.Name;
_conditions[_conditions.IndexOf(currentModel)] = model;
List <Guid> characterIDs = new List <Guid>();
foreach (CharacterModel character in _characters)
{
foreach (AppliedConditionModel appliedCondition in character.Conditions)
{
if (appliedCondition.ConditionModel != null && appliedCondition.ConditionModel.Id == model.Id)
{
appliedCondition.ConditionModel = model;
if (appliedCondition.Name.Equals(oldName, StringComparison.CurrentCultureIgnoreCase))
{
appliedCondition.Name = model.Name;
}
characterIDs.Add(character.Id);
}
}
}
if (characterIDs.Any())
{
CharacterChanged?.Invoke(this, new CompendiumChangeEventArgs(characterIDs.Distinct()));
}
}
}
public void Equals_GivenConditionValues_ShouldReturnTrue(string leftConditionTableName, string leftConditionColumnName, EqualityOperators leftConditionOperator, object leftConditionValue,
BooleanOperator booleanOperator,
string rightConditionTableName, string rightConditionColumnName, EqualityOperators rightConditionOperator, object rightConditionValue)
{
//---------------Set up test pack-------------------
var leftCondition = new ConditionModel(leftConditionTableName, leftConditionColumnName, leftConditionOperator, leftConditionValue)
{
DatabaseProvider = new SqlServerDatabaseProvider()
};
var rightCondition = new ConditionModel(rightConditionTableName, rightConditionColumnName, rightConditionOperator, rightConditionValue)
{
DatabaseProvider = new SqlServerDatabaseProvider()
};
var conditionModel = new CompoundConditionModel(leftCondition, booleanOperator, rightCondition)
{
DatabaseProvider = new SqlServerDatabaseProvider()
};
var compareCondition = new CompoundConditionModel(leftCondition, booleanOperator, rightCondition)
{
DatabaseProvider = new SqlServerDatabaseProvider()
};
//---------------Assert Precondition----------------
//---------------Execute Test ----------------------
var equalResult = conditionModel.Equals(compareCondition);
//---------------Test Result -----------------------
Assert.IsTrue(equalResult);
}
private ConditionModel ParseConditionNext(ConditionModel previousCondition)
{
if (Current.Type == TokenType.AndKeyword)
{
DiscardToken();
var nextCondition = ParseCondition();
var op = new OperatorModel(OperatorType.And);
return(new ConditionModel
{
Left = previousCondition,
Value = op,
Right = nextCondition
});
}
else if (Current.Type == TokenType.OrKeyword)
{
DiscardToken();
var nextCondition = ParseCondition();
var op = new OperatorModel(OperatorType.Or);
return(new ConditionModel
{
Left = previousCondition,
Value = op,
Right = nextCondition
});
}
else
{
return(previousCondition);
}
}
public ActionResult GetMechanicalMetal(int materialId, int sourceMaterialId, int sourceId, int subgroupId, int groupId, string searchText, int type, int conditionId = 0)
{
if (type == 2)
{
type = 1;
}
if (type == 3)
{
type = 2;
}
IService service = new TotalMateriaService();
IPlusService servicePLUS = new TMPlusService();
string sessionId = System.Web.HttpContext.Current.Session["TotalMateriaSession"].ToString();
ConditionModel conditionData = new ConditionModel();
Condition cond = new ConditionTMMetalsBinder().FillMechanicalConditionData(subgroupId, sourceMaterialId, conditionId, materialContextUow, type, sessionId);
conditionData.ConditionId = cond.ConditionId;
conditionData.ConditionName = cond.ConditionName;
conditionData.Properties = cond.Properties;
conditionData.ProductGroupId = ProductGroup.ProductGroupType.Mechanical;
//TODO: Fill references
conditionData.SelectedReferences = null;
return(Json(ResponseStatus.Success, RenderPartialViewToString("ConditionPropertiesContent", conditionData), JsonRequestBehavior.AllowGet));
}
private ConditionModel ParseCondition()
{
ConditionModel currentCondition;
if (Current.Type == TokenType.OpenParenthesis)
{
DiscardToken();
currentCondition = ParseCondition();
DiscardToken(TokenType.CloseParenthesis);
}
else
{
var obj = ParseObject();
var op = ParseOperator();
var target = ParseValue();
currentCondition = new ConditionModel
{
Left = new ConditionModel {
Value = obj
},
Value = op,
Right = new ConditionModel {
Value = target
}
};
}
return(ParseConditionNext(currentCondition));
}
public async Task <Message <ConditionModel> > UpdateCondition(int id, ConditionModel model)
{
var requestUrl = CreateRequestUri(string.Format(System.Globalization.CultureInfo.InvariantCulture,
"Conditions/" + id.ToString()));
return(await PutAsync <ConditionModel>(requestUrl, model));
}
public ProductGroup FillChemicalGroup(int subgroupId, int sourceMaterialId, string sessionId, IMaterialsContextUow context, IService service)
{
IList <ConditionModel> chemcialConditionsGlobal = new List <ConditionModel>();
IList <Condition> chemicalConditions = FillChemicalData(subgroupId, sourceMaterialId, sessionId, service);
if (chemicalConditions.Count > 0 && chemicalConditions[0].Properties.Count > 0)
{
foreach (var chemicalCondition in chemicalConditions)
{
foreach (var chemicalElement in chemicalCondition.Properties)
{
var propertyEls = context.PreferredNames.AllAsNoTracking.Where(p => p.PN.ToLower() == chemicalElement.PropertyName.ToLower() && p.taxonomy_id == 2).FirstOrDefault();
if (propertyEls != null)
{
chemicalElement.PropertyId = propertyEls.PN_ID;
}
}
}
ConditionModel cond = FillConditionModel(chemicalConditions, ProductGroup.ProductGroupType.Chemical);
chemcialConditionsGlobal.Add(cond);
ProductGroup propertyGroup = FillPropertyGroup(chemcialConditionsGlobal, ProductGroup.ProductGroupType.Chemical, context);
return(propertyGroup);
}
return(null);
}
public override bool IsValid(object value)
{
int conditionID;
Condition condition;
if (value == null)
{
this.ErrorMessage = "ConditionID es requerido";
return(false);
}
if (!int.TryParse(value.ToString(), out conditionID))
{
this.ErrorMessage = "ConditionID contiene formato inválido";
return(false);
}
if (conditionID == 0 || ConditionModel.IsNull(new ConditionBLL().GetConditionByConditionID((int)value), out condition))
{
this.ErrorMessage = "ConditionID no existente";
return(false);
}
HttpContext.Current.Items["condition"] = condition;
return(true);
}
private void CreateLayersFiles(ConditionModel model)
{
Func <ConditionModel, string> funHtml = UIStart.getInstance(model).CreatePageUIByType;
Func <ConditionModel, string> funCs = UIStart.getInstance(model).CreatePageCSByType;
string dicPath = AppDomain.CurrentDomain.BaseDirectory;;
#region TCControls
if (RbtnListAndEdit.IsChecked == true)
{
CreateFile(dicPath, "ListPageHtml", ePageType.ViewPage, funHtml);
CreateFile(dicPath, "ListPageCs", ePageType.ViewPage, funCs);
CreateFile(dicPath, "EditPageHtml", ePageType.EditPage, funHtml);
CreateFile(dicPath, "EditPageCs", ePageType.EditPage, funCs);
}
else if (RbtnListEditListBox.IsChecked == true)
{
CreateFile(dicPath, "简单编辑页面HTML", ePageType.ViewEditPageListBox, funHtml);
CreateFile(dicPath, "简单编辑页面", ePageType.ViewEditPageListBox, funCs);
}
else if (RbtnListEditRepeater.IsChecked == true)
{
CreateFile(dicPath, "简单编辑页面HTML", ePageType.ViewEditPageRepeater, funHtml);
CreateFile(dicPath, "简单编辑页面", ePageType.ViewEditPageRepeater, funCs);
}
#endregion
}
protected ExpressionBuilderBase()
{
if (Condition == null)
{
Condition = new ConditionModel();
}
}
/// <summary>
/// Extension of Sitecore.Commerce.Plugin.Rules.ModelExtensions.ConvertToCondition to allow boolean values
/// </summary>
internal static ICondition ConvertToConditionExtended(
this ConditionModel model,
IEntityMetadata metaData,
IEntityRegistry registry,
IServiceProvider services)
{
return(model.Properties.Convert <ICondition>(metaData, registry, services));
}
/// <summary>
/// Adds a condition model
/// </summary>
public void AddCondition(ConditionModel conditionModel)
{
if (conditionModel != null &&
!_conditions.Any(x => x.Id == conditionModel.Id))
{
_conditions.Add(conditionModel);
}
}
public static bool IsValid(this ConditionModel model)
{
if (model.Properties != null && !model.Properties.Any <PropertyModel>((Func <PropertyModel, bool>)(p => string.IsNullOrEmpty(p.Value))))
{
return(model.ConditionOperator != null);
}
return(false);
}
/// <summary>
/// Updates the model
/// </summary>
public void UpdateModel(ConditionModel conditionModel)
{
_conditionModel = conditionModel;
Initialize();
OnPropertyChanged("");
}
private void CreateLayersTabItem(ConditionModel model)
{
// TcControls.Items.Add(CreateUITabItem("DAL", Facade.GenerateDAL(GetDt(), nameSpace, entityName)));
TcControls.Items.Add(CreateUITabItem(model.EntityName + "Entity", Facade.GenerateEntity(GetDtFields(Constant.Constant.TableName), model.EntityName + ".Entity", model.EntityName)));
TcControls.Items.Add(CreateUITabItem(model.EntityName + "DAL", Facade.GenerateDAL(GetDtFields(Constant.Constant.TableName), model.NameSpace, model.EntityName)));
TcControls.Items.Add(CreateUITabItem(model.EntityName + "BLL", Facade.GenerateBLL(GetDtFields(Constant.Constant.TableName), model.NameSpace, model.EntityName)));
}
/// <inheritdoc />
public IConditionBuilder WithCondition(string sourceTable, string sourceColumn, EqualityOperators equalityOperator, object conditionValue)
{
var conditionModel = new ConditionModel(sourceTable, sourceColumn, equalityOperator, conditionValue);
_buildConditions.Add(_conditionNumber++, conditionModel);
return(this);
}
public IList <ConditionModel> GetGroupMaterialConditions(int materialId, int subgroupId, int groupId, IMaterialsContextUow context)
{
IList <ConditionModel> conditionsList = new List <ConditionModel>();
IList <GroupMaterialCondition> conditions = context.GroupMaterialConditions.AllAsNoTracking.Where(n => n.MaterialID == materialId && n.SubgroupID == subgroupId && n.GroupId == groupId).ToList();
foreach (var record in conditions)
{
ConditionModel materialCondition = new ConditionModel();
materialCondition.ProductGroupId = (ProductGroup.ProductGroupType)groupId;
materialCondition.Properties = new List <ElsevierMaterials.Models.Property>();
materialCondition.ConditionId = record.ConditionId;
materialCondition.ProductFormId = record.ProductFormId;
materialCondition.ConditionIdProductFormId = record.ConditionId + ";" + record.ProductFormId;
materialCondition.ConditionName = "";
materialCondition.MaterialDescription = record.MaterialDescription;
materialCondition.Thickness = record.Thickness;
if (record.Condition != null && record.Condition != "")
{
materialCondition.ConditionName = record.Condition;
}
if (record.ProductForm != null && record.ProductForm != "")
{
materialCondition.ConditionName = materialCondition.ConditionName + ((materialCondition.ConditionName != "") ? "; " + record.ProductForm : record.ProductForm);
}
if (record.Thickness != null && record.Thickness != "")
{
materialCondition.ConditionName = materialCondition.ConditionName + ((materialCondition.ConditionName != "") ? "; " + record.Thickness : record.Thickness);
}
if (record.MaterialDescription != null && record.MaterialDescription != "")
{
materialCondition.ConditionName = materialCondition.ConditionName + ((materialCondition.ConditionName != "") ? "; " + record.MaterialDescription : record.MaterialDescription);
}
if (record.Phase != null && record.Phase != "")
{
materialCondition.ConditionName = materialCondition.ConditionName + ((materialCondition.ConditionName != "") ? "; " + record.Phase : record.Phase);
}
if (materialCondition.ConditionName == null || materialCondition.ConditionName == "")
{
materialCondition.ConditionName = "All";
}
materialCondition.ConditionName = materialCondition.ConditionName.TrimStart(';').TrimStart();
conditionsList.Add(materialCondition);
}
conditionsList = conditionsList.OrderBy(c => c.ConditionName).ToList();
return(conditionsList);
}
public async Task <IEnumerable <User> > GetUserByCondition(ConditionModel condition)
{
IEnumerable <User> data;
try
{
var decrypt = EncryptDecryptService.DecryptAes(condition.encrypt);
var _condition = JsonConvert.DeserializeObject <ConditionModel>(decrypt);
data = db.User;
// .AsNoTracking()
// .AsExpandable();
if (_condition.sid != null && _condition.sid.Any())
{
data = data.Where(u => u.UserID.Equals(_condition.sid));
}
if (_condition.Name != null && _condition.Name.Any())
{
data = data.Where(u => u.UserName.ToLower().Contains(_condition.Name.ToLower()));
}
if (_condition.Email != null && _condition.Email.Any())
{
data = data.Where(u => u.Email.ToLower().Contains(_condition.Email.ToLower()));
}
//*
//* ตัวอย่างการใช้งานการค้นหาแบบหลายเงื่อนไข
//* ใช้ function ของ LINQKit
//*
// if(mySearchFilter.IsActive)
// result = result.Where(p => p.ActiveOnly);
// if(mySearchFilter.CategoryIds != null && mySearchFilter.CategoryIds.Any())
// result = result.Where(p => mySearchFilter.CategoryIds.Contains(p.CategoryId));
// if(mySearchFilter.Keywords != null && mySearchFilter.Keywords.Any())
// {
// //Crate the builder
// var predicate = PredicateBuilder.New();
// //Loop through the keywords
// foreach(var item in mySearchFilter.Keywords)
// {
// var currentKeyword = item;
// predicate = predicate.Or (p => p.ProductName.Contains (currrentKeyword));
// predicate = predicate.Or (p => p.Description.Contains (currrentKeyword));
// }
// result = result.Where(predicate);
//*
data = data.ToList();
return(await Task.FromResult(data));
}
catch (Exception ex)
{
throw ex;
}
}
public object BindModel(ControllerContext controllerContext, ModelBindingContext bindingContext)
{
ConditionModel model = (ConditionModel)bindingContext.Model ?? new ConditionModel();
model.Field = GetValue(bindingContext, "Field");
//model.Op = GetValue(bindingContext, "Op");
model.Value = GetValue(bindingContext, "Value");
return(model);
}
public static ListEditPage getInstance(ConditionModel model)
{
// if (_instance == null)
{
_instance = new ListEditPage(model);
}
return(_instance);
}
public static UnitListEdit getInstance(ConditionModel model)
{
// if (_instance == null)
{
_instance = new UnitListEdit(model);
}
return(_instance);
}
public void FillElsMaterial(int materialId, int subgroupId, int sourceMaterialId, IMaterialsContextUow context, MaterialDetailsModel model, int type)
{
int setId = (int)context.RecordLinks.All.Where(m => m.MaterialID == materialId && m.SubgroupID == subgroupId).FirstOrDefault().SetID;
IList <RecordLink> conditions = context.RecordLinks.All.Where(n => n.MaterialID == materialId && n.SubgroupID == subgroupId).ToList();
IDictionary <ProductGroup.ProductGroupType, ProductGroup> listOfGroups = new Dictionary <ProductGroup.ProductGroupType, ProductGroup>();
IList <ConditionModel> conditionWithProperties = new List <ConditionModel>();
foreach (var conditionObj in conditions)
{
IList <MaterialProperty> propertiesPerCond = context.MaterialProperties.All.Where(m => m.MaterialId == materialId && m.SubgroupId == subgroupId && m.RowId == conditionObj.RowID).ToList();
foreach (var prop in propertiesPerCond)
{
ProductGroup.ProductGroupType groupId = (ProductGroup.ProductGroupType)context.Trees.Find(n => n.PN_ID == prop.PropertyId).BT_ID;
if (!listOfGroups.ContainsKey(groupId))
{
conditionWithProperties = new List <ConditionModel>();
ConditionModel condition = new ConditionElsBinder().FillElsCondition(materialId, subgroupId, context, conditionObj, prop, type);
conditionWithProperties.Add(condition);
ProductGroup productGroup = FillElsProductGroup(conditionWithProperties, groupId, context);
productGroup.MaterialConditions = productGroup.MaterialConditions.OrderBy(c => c.ConditionName).ToList();
listOfGroups.Add(groupId, productGroup);
}
else
{
ProductGroup selectedGroup = listOfGroups[groupId];
if (!selectedGroup.MaterialConditions.Any(v => v.ConditionId == conditionObj.RowID))
{
ConditionModel condition = new ConditionElsBinder().FillElsCondition(materialId, subgroupId, context, conditionObj, prop, type);
selectedGroup.MaterialConditions.Add(condition);
}
else
{
ConditionModel condition = selectedGroup.MaterialConditions.Where(v => v.ConditionId == conditionObj.RowID).FirstOrDefault();
string unitName = prop.OrigUnit == null ? "" : context.Units.Find(n => n.UnitId == prop.OrigUnit).UnitText;
ElsevierMaterials.Models.Property property = context.PropertiesWithConvertedValues.GetPropertyInfoForMaterialForSelectedMetric(context.PreferredNames.Find(o => o.PN_ID == prop.PropertyId).PN, materialId, subgroupId, conditionObj.RowID, prop.PropertyId, prop.ValueId, type, unitName);
condition.Properties.Add(property);
}
}
listOfGroups[groupId].PropertyCount++;
}
}
model.Properties = new PropertiesModel();
OrderPropertiesGroups(model, listOfGroups);
}
public ConditionModel FillConditionModel(IList <Condition> conditions, ProductGroup.ProductGroupType productGroup)
{
ConditionModel cond = new ConditionModel();
cond.ConditionId = conditions[0].ConditionId;
cond.ConditionName = conditions[0].ConditionName;
cond.Properties = conditions[0].Properties;
cond.ProductGroupId = productGroup;
return(cond);
}
public ActionResult SecondConditionData(int materialId, int sourceMaterialId, int sourceId, int subgroupId, int groupId, int rowId, string searchText, int type)
{
string sessionId = System.Web.HttpContext.Current.Session["TotalMateriaSession"].ToString();
ConditionModel model = MaterialDetailsBinder.ConditionData(materialId, subgroupId, sourceId, sourceMaterialId, groupId, rowId, searchText, sessionId, type, materialContextUow);
model.ProductGroupId = (ProductGroup.ProductGroupType)groupId;
return(Json(ResponseStatus.Success, RenderPartialViewToString("ConditionPropertiesContent", model), JsonRequestBehavior.AllowGet));
}
protected BasePage(ConditionModel model)
{
_model = model;
_unitQuery = new UnitQuery(model);
_unitFunc = new UnitFunc(model);
_unitList = new UnitList(model);
_unitListEdit = new UnitListEdit(model);
_unitEdit = new UnitEdit(model);
_unitScript = new UnitScript(model);
}
public void Constructor()
{
//---------------Set up test pack-------------------
//---------------Assert Precondition----------------
//---------------Execute Test ----------------------
var selectColumn = new ConditionModel("tableName", "columnName", EqualityOperators.Equals, "testValue");
//---------------Test Result -----------------------
Assert.IsNotNull(selectColumn);
}
private ConditionModel ParserTextboxFilter(TextboxQueueViewModel textboxViewModel)
{
ConditionModel result = new ConditionModel();
if (textboxViewModel.LocalSelectedCondition.Equals(CollectionQueueOperators.And.ToString()))
result.isAnd = true;
else if (textboxViewModel.LocalSelectedCondition.Equals(CollectionQueueOperators.Or.ToString()))
result.isAnd = false;
if (textboxViewModel.LocalSelectedOperators1.Text.Equals(CollectionQueueCondition.None) && textboxViewModel.LocalSelectedOperators2.Text.Equals(CollectionQueueCondition.None))
{
result.MinValue = null;
result.MaxValue = null;
result.isAnd = null;
}
else
{
if (textboxViewModel.LocalSelectedOperators1.Text.Equals(CollectionQueueCondition.None))
{
if (textboxViewModel.LocalSelectedOperators2.Text.Equals(CollectionQueueCondition.IsGreaterthan))
{
result.MinValue = textboxViewModel.Value2 == "" ? 0 : Convert.ToDecimal(textboxViewModel.Value2);
result.MaxValue = null;
result.isAnd = null;
}
else if (textboxViewModel.LocalSelectedOperators2.Text.Equals(CollectionQueueCondition.IsLessthan))
{
result.MinValue = null;
result.MaxValue = textboxViewModel.Value2 == "" ? 0 : Convert.ToDecimal(textboxViewModel.Value2);
result.isAnd = null;
}
}
else if (textboxViewModel.LocalSelectedOperators1.Text.Equals(CollectionQueueCondition.IsGreaterthan))
{
if (textboxViewModel.LocalSelectedOperators2.Text.Equals(CollectionQueueCondition.None))
{
result.MinValue = textboxViewModel.Value1 == "" ? 0 : Convert.ToDecimal(textboxViewModel.Value1);
result.MaxValue = null;
result.isAnd = null;
}
else if (textboxViewModel.LocalSelectedOperators2.Text.Equals(CollectionQueueCondition.IsLessthan))
{
result.MinValue = textboxViewModel.Value1 == "" ? 0 : Convert.ToDecimal(textboxViewModel.Value1);
result.MaxValue = textboxViewModel.Value2 == "" ? 0 : Convert.ToDecimal(textboxViewModel.Value2);
}
else if (textboxViewModel.LocalSelectedOperators2.Text.Equals(CollectionQueueCondition.IsGreaterthan))
{
if (result.isAnd == true)
result.MinValue = Convert.ToDouble(textboxViewModel.Value2) > Convert.ToDouble(textboxViewModel.Value1) ? Convert.ToDecimal(textboxViewModel.Value2) : Convert.ToDecimal(textboxViewModel.Value1);
else
result.MinValue = Convert.ToDouble(textboxViewModel.Value2) < Convert.ToDouble(textboxViewModel.Value1) ? Convert.ToDecimal(textboxViewModel.Value2) : Convert.ToDecimal(textboxViewModel.Value1);
result.MaxValue = null;
result.isAnd = null;
}
}
else if (textboxViewModel.LocalSelectedOperators1.Text.Equals(CollectionQueueCondition.IsLessthan))
{
if (textboxViewModel.LocalSelectedOperators2.Text.Equals(CollectionQueueCondition.None))
{
result.MinValue = null;
result.MaxValue = Convert.ToDecimal(textboxViewModel.Value1);
result.isAnd = null;
}
else if (textboxViewModel.LocalSelectedOperators2.Text.Equals(CollectionQueueCondition.IsGreaterthan))
{
result.MinValue = Convert.ToDecimal(textboxViewModel.Value2);
result.MaxValue = Convert.ToDecimal(textboxViewModel.Value1);
}
else if (textboxViewModel.LocalSelectedOperators2.Text.Equals(CollectionQueueCondition.IsLessthan))
{
result.MinValue = null;
if (result.isAnd == true)
result.MaxValue = Convert.ToDouble(textboxViewModel.Value2) < Convert.ToDouble(textboxViewModel.Value1) ? Convert.ToDecimal(textboxViewModel.Value2) : Convert.ToDecimal(textboxViewModel.Value1);
else
result.MaxValue = Convert.ToDouble(textboxViewModel.Value2) > Convert.ToDouble(textboxViewModel.Value1) ? Convert.ToDecimal(textboxViewModel.Value2) : Convert.ToDecimal(textboxViewModel.Value1);
result.isAnd = null;
}
}
}
return result;
}
/// <summary>
/// Initiate connection
/// </summary>
public ServerAccessOracle(ConditionModel.LoggingSystem.LoggingSystemOptions logingOptionsReferince)
{
logingOptions = logingOptionsReferince;
//=== CUSTOM LOGGER===================================================================================
//if (LoggingSystem.LoggingSystem.TraceCode)
{
System.Diagnostics.StackTrace stackTrace; System.Diagnostics.StackFrame fr; string myLog; System.IO.StreamWriter log; stackTrace = new System.Diagnostics.StackTrace(); fr = stackTrace.GetFrame(0);
//LoggingSystem.LoggingSystem.LogMessage = "<div> " + this.GetType().Namespace + " <span style='color:green'> " + this.GetType().Name + " </span>> " + stackTrace.GetFrame(0).GetMethod().ToString().Replace(stackTrace.GetFrame(0).GetMethod().Name, "<span style='color:blue'>" + stackTrace.GetFrame(0).GetMethod().Name + "</span>") + "</div>";
}
//====================================================================================================
if (OracleConnection == null)
{
OracleConnection = getOracleConnection("" + OracleDB + "");
}
// TODO: Complete member initialization
}
