public DetailsViewModel()
{
_shared = GetService <SharedService>();
}
public virtual void Replace(T oldEntity, T newEntity)
{
SharedService.CopyEntity <T>(oldEntity, newEntity);
Save();
}
public ExplorerViewModel()
{
_shared = GetService <SharedService>();
_onDirectoryChanged = EventAggregator.Subscribe <DirectoryChangedEventArgs>(DirectoryChanged);
}
public JsonResult DeleteEntity(Guid entityId)
{
try
{
var entity = EntityService.QueryEntityById(entityId);
if (entity == null)
{
return(Json(new { message = "Le système n'a pas trouvé l'enregistrement à supprimer!", type = "error" }, JsonRequestBehavior.AllowGet));
}
#region Delete Field Records
var fieldsDeleteError = false;
var fields = FieldService.QueryFieldsByEntityId(entityId);
foreach (var field in fields)
{
var fieldId = (Guid)field.FirstOrDefault(x => x.Key == "Id").Value;
var returnValue = SharedService.ExecutePostSqlStoredProcedure("[eduq].[Field_deletefieldbyfieldid]",
new List <SqlParameter>
{
new SqlParameter("@fieldId", fieldId)
});
if (returnValue != 1)
{
return(Json(new { message = "Une erreur s'est produise pendant la supprimation de l'attribut!", type = "error" }, JsonRequestBehavior.AllowGet));
}
var deletedField = FieldService.QueryFieldById(fieldId);
if (deletedField != null)
{
fieldsDeleteError = true;
}
}
if (fieldsDeleteError)
{
return(Json(new { message = "Une erreur s'est produise pendant la supprimation de l'attribut!", type = "error" }, JsonRequestBehavior.AllowGet));
}
#endregion
#region Delete Entity Record
var returnValueDeleteEntity = SharedService.ExecutePostSqlStoredProcedure("[eduq].[Entity_deleteentitybyentityid]",
new List <SqlParameter>
{
new SqlParameter("@entityId", entityId)
});
if (returnValueDeleteEntity != 1)
{
return(Json(new { message = "Une erreur s'est produise pendant la supprimation de l'attribut!", type = "error" }, JsonRequestBehavior.AllowGet));
}
var deletedEntity = EntityService.QueryEntityById(entityId);
if (deletedEntity != null)
{
return(Json(new { message = "Une erreur s'est produise pendant la supprimation de l'attribut!", type = "error" }, JsonRequestBehavior.AllowGet));
}
#endregion
#region Delete Sql Table
var entityName = entity.FirstOrDefault(x => x.Key == "Name").Value.ToString();
var returnValueDeleteSqlTableColumn = SqlService.DeleteSqlTable(entityName);
if (!returnValueDeleteSqlTableColumn)
{
return(Json(new { message = "Une erreur s'est produise pendant la supprimation de l'attribut!", type = "error" }, JsonRequestBehavior.AllowGet));
}
#endregion
return(Json(new { message = "L'entité a été supprimé avec succès!.", type = "success" }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(ex.Message, JsonRequestBehavior.AllowGet));
}
}
public BooleanToTreeNodeVisibilityConverter()
{
_shared = ServiceLocator.Instance.GetService <SharedService>();
}
public ToolbarViewModel()
{
_shared = GetService <SharedService>();
}
private static void ConfigureServices(IServiceCollection serviceCollection, ConfigurationService configurationService, CommandService commandService, MemoryCacheService memoryCacheService, NavigationService navigationService, SharedService sharedService)
{
serviceCollection.AddSingleton <IConfigurationService>(configurationService);
serviceCollection.AddSingleton <ICommandService>(commandService);
serviceCollection.AddSingleton <IMemoryCacheService>(memoryCacheService);
serviceCollection.AddSingleton <INavigationService>(navigationService);
serviceCollection.AddSingleton <ISharedService>(sharedService);
serviceCollection.AddSingleton <IPluginProvider, PluginProvider>();
}
public SharedController()
{
_SharedService = new SharedService();
}
public ServicesController()
{
servicesService = new ServicesService();
sharedService = new SharedService();
}
public RequestController()
{
_requestService = new RequestService();
_sharedService = new SharedService();
}
public PreviewViewModel()
{
_shared = GetService <SharedService>();
}
public MainViewModel()
{
WindowTitle = "Jaya";
_onDirectoryChanged = EventAggregator.Subscribe <DirectoryChangedEventArgs>(DirectoryChanged);
_shared = GetService <SharedService>();
}
public MenuViewModel()
{
_shared = GetService <SharedService>();
SimpleCommand = new RelayCommand <byte>(_shared.SimpleCommandAction);
}
public JsonResult CreateEntity(List <KeyValue> keyValues)
{
try
{
var id = Guid.NewGuid();
var name = keyValues.FirstOrDefault(x => x.Key == "Name")?.Value;
var displayName = keyValues.FirstOrDefault(x => x.Key == "DisplayName")?.Value;
var pluralName = keyValues.FirstOrDefault(x => x.Key == "PluralName")?.Value;
var fieldTypes = FieldTypeService.QueryFieldTypes();
#region Create entity record
var returnValue = SharedService.ExecutePostSqlStoredProcedure("[eduq].[Entity_create]",
new List <SqlParameter>
{
new SqlParameter("@id", id),
new SqlParameter("@name", (name.ToLower())),
new SqlParameter("@displayName", displayName),
new SqlParameter("@pluralName", pluralName),
new SqlParameter("@stateId", 1)
});
if (returnValue != 1)
{
return(Json(new { message = "Une erreur s'est produise pendant la creation de l'entité!", type = "error" }, JsonRequestBehavior.AllowGet));
}
var newlyCreatedEntity = EntityService.QueryEntityById(id);
if (newlyCreatedEntity == null)
{
return(Json(new { message = "Une erreur s'est produise pendant la creation de l'entité!", type = "error" }, JsonRequestBehavior.AllowGet));
}
#endregion
#region Create sql table
var returnValueCreateSqlTable = SqlService.CreateSqlTable(name);
if (!returnValueCreateSqlTable)
{
return(Json(new { message = "Une erreur s'est produise pendant la creation de l'entité!", type = "error" }, JsonRequestBehavior.AllowGet));
}
#endregion
/*Create Fields*/
#region Id Field
/*Id*/
var fieldId = Guid.NewGuid();
var fieldName = "Id";
var fieldDisplayName = "Id";
var fieldDescription = "";
var fieldDefaultValue = "";
var fieldEntityId = id;
var GuidFieldType = FieldTypeService.QueryFieldTypeByName("Guid");
var GuidFieldTypeId = (int)GuidFieldType.FirstOrDefault(x => x.Key == "Id").Value;
var GuidFieldTypeSqlDataType = GuidFieldType.FirstOrDefault(x => x.Key == "SqlDataTypeName").Value.ToString();
var fieldStateId = 1;
var returnValueCreateField = FieldService.CreateField(fieldId, fieldName, fieldDisplayName, fieldDescription, fieldDefaultValue, fieldEntityId, GuidFieldTypeId, true, fieldStateId);
if (returnValueCreateField == Guid.Empty)
{
return(Json(new { message = "Une erreur s'est produise pendant la creation de l'entité!", type = "error" }, JsonRequestBehavior.AllowGet));
}
#endregion
#region Name Field
/*Name*/
fieldId = Guid.NewGuid();
fieldName = "Name";
fieldDisplayName = "Name";
fieldDescription = "";
fieldDefaultValue = "";
fieldEntityId = id;
var texteFieldType = FieldTypeService.QueryFieldTypeByName("Texte");
var texteFieldTypeId = (int)texteFieldType.FirstOrDefault(x => x.Key == "Id").Value;
fieldStateId = 1;
returnValueCreateField = FieldService.CreateField(fieldId, fieldName, fieldDisplayName, fieldDescription, fieldDefaultValue, fieldEntityId, texteFieldTypeId, true, fieldStateId);
if (returnValueCreateField == Guid.Empty)
{
return(Json(new { message = "Une erreur s'est produise pendant la creation de l'entité!", type = "error" }, JsonRequestBehavior.AllowGet));
}
#endregion
#region CreatedOn Field
/*CreatedOn*/
fieldId = Guid.NewGuid();
fieldName = "CreatedOn";
fieldDisplayName = "Date de Création";
fieldDescription = "";
fieldDefaultValue = "";
fieldEntityId = id;
var dateTimeFieldType = FieldTypeService.QueryFieldTypeByName("Date et Heure");
var dateTimeFieldTypeId = (int)dateTimeFieldType.FirstOrDefault(x => x.Key == "Id").Value;
fieldStateId = 1;
returnValueCreateField = FieldService.CreateField(fieldId, fieldName, fieldDisplayName, fieldDescription, fieldDefaultValue, fieldEntityId, dateTimeFieldTypeId, true, fieldStateId);
if (returnValueCreateField == Guid.Empty)
{
return(Json(new { message = "Une erreur s'est produise pendant la creation de l'entité!", type = "error" }, JsonRequestBehavior.AllowGet));
}
#endregion
#region CreatedById Field
/*CreatedId*/
fieldId = Guid.NewGuid();
fieldName = "CreatedById";
fieldDisplayName = "Créer par";
fieldDescription = "";
fieldDefaultValue = "";
fieldEntityId = id;
var lookupFieldType = FieldTypeService.QueryFieldTypeByName("Recherche");
var lookupFieldTypeId = (int)lookupFieldType.FirstOrDefault(x => x.Key == "Id").Value;
fieldStateId = 1;
returnValueCreateField = FieldService.CreateField(fieldId, fieldName, fieldDisplayName, fieldDescription, fieldDefaultValue, fieldEntityId, lookupFieldTypeId, true, fieldStateId);
if (returnValueCreateField == Guid.Empty)
{
return(Json(new { message = "Une erreur s'est produise pendant la creation de l'entité!", type = "error" }, JsonRequestBehavior.AllowGet));
}
#endregion
#region ModifiedOn
/*ModifiedOn*/
fieldId = Guid.NewGuid();
fieldName = "ModifiedOn";
fieldDisplayName = "Date de modification";
fieldDescription = "";
fieldDefaultValue = "";
fieldEntityId = id;
fieldStateId = 1;
returnValueCreateField = FieldService.CreateField(fieldId, fieldName, fieldDisplayName, fieldDescription, fieldDefaultValue, fieldEntityId, dateTimeFieldTypeId, true, fieldStateId);
if (returnValueCreateField == Guid.Empty)
{
return(Json(new { message = "Une erreur s'est produise pendant la creation de l'entité!", type = "error" }, JsonRequestBehavior.AllowGet));
}
#endregion
#region ModifiedById Field
/*ModifiedById*/
fieldId = Guid.NewGuid();
fieldName = "ModifiedById";
fieldDisplayName = "Modifié par";
fieldDescription = "";
fieldDefaultValue = "";
fieldEntityId = id;
lookupFieldType = FieldTypeService.QueryFieldTypeByName("Recherche");
lookupFieldTypeId = (int)lookupFieldType.FirstOrDefault(x => x.Key == "Id").Value;
fieldStateId = 1;
returnValueCreateField = FieldService.CreateField(fieldId, fieldName, fieldDisplayName, fieldDescription, fieldDefaultValue, fieldEntityId, lookupFieldTypeId, true, fieldStateId);
if (returnValueCreateField == Guid.Empty)
{
return(Json(new { message = "Une erreur s'est produise pendant la creation de l'entité!", type = "error" }, JsonRequestBehavior.AllowGet));
}
#endregion
return(Json(new { message = id, type = "success" }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(ex.Message, JsonRequestBehavior.AllowGet));
}
}
public JsonResult CreateField(List <KeyValue> keyValues)
{
try
{
var id = Guid.NewGuid();
var name = keyValues.FirstOrDefault(x => x.Key == "Name")?.Value;
var displayName = keyValues.FirstOrDefault(x => x.Key == "DisplayName")?.Value;
var description = keyValues.FirstOrDefault(x => x.Key == "Description")?.Value;
var entityId = keyValues.FirstOrDefault(x => x.Key == "EntityId")?.Value;
var entityName = keyValues.FirstOrDefault(x => x.Key == "EntityName")?.Value;
var fieldTypeId = keyValues.FirstOrDefault(x => x.Key == "FieldTypeId")?.Value;
var fieldTypeName = keyValues.FirstOrDefault(x => x.Key == "FieldTypeName")?.Value;
var isRequired = keyValues.FirstOrDefault(x => x.Key == "IsRequired")?.Value;
var lookupEntityName = keyValues.FirstOrDefault(x => x.Key == "LookupEntityName")?.Value;
#region Create field record
var returnValue = SharedService.ExecutePostSqlStoredProcedure("[eduq].[Field_create]",
new List <SqlParameter>
{
new SqlParameter("@id", id),
new SqlParameter("@name", name),
new SqlParameter("@displayName", displayName),
new SqlParameter("@description", description),
new SqlParameter("@entityId", entityId),
new SqlParameter("@fieldTypeId", fieldTypeId),
new SqlParameter("@isRequired", isRequired),
new SqlParameter("@stateId", 1)
});
if (returnValue != 1)
{
return(Json(new { message = "Une erreur s'est produise pendant la creation de l'attribut!", type = "error" }, JsonRequestBehavior.AllowGet));
}
var newlyCreatedField = FieldService.QueryFieldById(id);
if (newlyCreatedField == null)
{
return(Json(new { message = "Une erreur s'est produise pendant la creation de l'attribut!", type = "error" }, JsonRequestBehavior.AllowGet));
}
#endregion
#region Create sql table column
var returnValueCreateSqlTableColumn = SqlService.CreateSqlTableColumn(entityName, name, fieldTypeName, (isRequired == "true" ? "NOT NULL": ""));
if (!returnValueCreateSqlTableColumn)
{
return(Json(new { message = "Une erreur s'est produise pendant la creation de l'attribut!", type = "error" }, JsonRequestBehavior.AllowGet));
}
#endregion
#region Create sql foreign key constraint
if (lookupEntityName == null)
{
return(Json(new { message = id, type = "success" }, JsonRequestBehavior.AllowGet));
}
var returnValueCreateSqlForeignKeyConstraint = SqlService.CreateSqlForeignKeyConstraint(entityName, lookupEntityName, name);
if (!returnValueCreateSqlForeignKeyConstraint)
{
return(Json(new { message = "Une erreur s'est produise pendant la creation de l'attribut!", type = "error" }, JsonRequestBehavior.AllowGet));
}
#endregion
return(Json(new { message = id, type = "success" }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new { message = ex.Message, type = "error" }, JsonRequestBehavior.AllowGet));
}
}
public static List <CartItem> QueryCartItemByInspection(HttpClient httpClient, Guid inspectionId, List <PriceList> priceLists)
{
try
{
var cartItems = new List <CartItem>();
if (priceLists == null || priceLists.Count == 0)
{
priceLists = PriceListService.QueryPriceListByPortalUserRole(httpClient, (int)PortalUserrole.Consumer);
}
var fetchXml = string.Empty;
fetchXml += "<fetch version='1.0' output-format='xml-platform' mapping='logical' distinct='true'>";
fetchXml += " <entity name='product'>";
fetchXml += " <attribute name='name' />";
fetchXml += " <attribute name='productid' />";
fetchXml += " <attribute name='defaultuomid' />";
fetchXml += " <attribute name='blu_buyerpays' />";
fetchXml += " <attribute name='parentproductid' />";
fetchXml += " <attribute name='blu_appointmentduration' />";
fetchXml += " <attribute name='blu_requiredinspectorskills' />";
fetchXml += " <attribute name='blu_sellableto' />";
fetchXml += " <attribute name='blu_reportisreleasedto' />";
fetchXml += " <attribute name='blu_finalbuyerpays' />";
fetchXml += " <attribute name='blu_freereport' />";
fetchXml += " <attribute name='blu_reportisreleasedto' />";
fetchXml += " <filter type='and'>";
fetchXml += " <condition attribute='blu_reportisresellable' operator='eq' value='1' />";
if (priceLists != null && priceLists.Count > 0)
{
fetchXml += " <condition attribute='pricelevelid' operator='in'>";
foreach (var priceList in priceLists)
{
fetchXml += " <value>" + priceList.Id + "</value>";
}
fetchXml += " </condition>";
}
fetchXml += " </filter>";
fetchXml += " <link-entity name='blu_inspectiondetail' from='blu_productid' to='productid' link-type='inner' alias='ae'>";
fetchXml += " <filter type='and'>";
fetchXml += " <condition attribute='statecode' operator='eq' value='0' />";
fetchXml += " </filter>";
fetchXml += " <link-entity name='blu_inspection' from='blu_inspectionid' to='blu_inspectionid' link-type='inner' alias='af'>";
fetchXml += " <filter type='and'>";
fetchXml += " <condition attribute='statecode' operator='eq' value='0' />";
fetchXml += " <condition attribute='blu_inspectionid' operator='eq' value='" + inspectionId + "' />";
fetchXml += " </filter>";
fetchXml += " </link-entity>";
fetchXml += " </link-entity>";
fetchXml += " <link-entity name='product' from='productid' to='blu_stockingproduct' link-type='inner' alias='ag'>";
fetchXml += " <link-entity name='blu_productinventory' from='blu_reporttype' to='productid' link-type='inner' alias='ah'>";
fetchXml += " <filter type='and'>";
fetchXml += " <condition attribute='blu_property' operator='eq' value='" + inspectionId + "' />";
fetchXml += " </filter>";
fetchXml += " </link-entity>";
fetchXml += " </link-entity>";
fetchXml += " </entity>";
fetchXml += "</fetch>";
var encodedQuery = SharedService.UrlEncode(fetchXml);
var odataQuery = webApiQueryUrl + EntityPluralName + "?fetchXml=" +
encodedQuery;
var retrieveResponse = httpClient.GetAsync(odataQuery);
var jRetrieveResponse = JObject.Parse(retrieveResponse.Result.Content.ReadAsStringAsync().Result);
dynamic systemUserObject = JsonConvert.DeserializeObject(jRetrieveResponse.ToString());
if (systemUserObject == null || systemUserObject.value == null)
{
return(null);
}
if (systemUserObject.value.Count == 0)
{
return(null);
}
foreach (var data in systemUserObject.value)
{
var cartItem = new CartItem()
{
ProductId = data["productid"] == null ? Guid.Empty : Guid.Parse(data["productid"].ToString()),
ProductName = data["name"] == null
? ""
: data["name"].ToString(),
ParentProductName = data["*****@*****.**"] ?? "",
Amount =
data["blu_buyerpays"] == null
? 0
: (decimal)data["blu_buyerpays"],
AmountText =
data["*****@*****.**"] ?? "",
UomId = data["_defaultuomid_value"] == null
? Guid.Empty
: Guid.Parse(data["_defaultuomid_value"].ToString()),
InspectionDetailStateCode = data["ae_x002e_statecode"] == null
? 0
: (int)data["ae_x002e_statecode"],
InspectionDetailStatusCode = data["ae_x002e_statuscode"] == null
? 0
: (int)data["ae_x002e_statuscode"],
ProductSkills = data["blu_requiredinspectorskills"] == null
? new string[0]
: data["blu_requiredinspectorskills"].ToString().Split(','),
AppointmentDuration = data["blu_appointmentduration"] == null ? 0 : (int)data["blu_appointmentduration"],
IsPriceOverriden = true,
ProductCategory = true,
SellableTo = data["blu_sellableto"] == null
? 0
: (int)data["blu_sellableto"],
BuyerPays =
data["blu_buyerpays"] == null
? 0
: (decimal)data["blu_buyerpays"],
BuyerPaysText =
data["*****@*****.**"] ?? "",
FinalBuyerPays =
data["blu_finalbuyerpays"] == null
? 0
: (decimal)data["blu_finalbuyerpays"],
FinalBuyerPaysText =
data["*****@*****.**"] ?? "",
ReportIsReleasedTo = data["blu_reportisreleasedto"] == null
? 0
: (int)data["blu_reportisreleasedto"],
ReportIsReleasedToText = data["*****@*****.**"] == null
? ""
: data["*****@*****.**"],
Conditions = data["blu_conditions"] == null
? ""
: data["blu_conditions"],
FreeReport = data["blu_freereport"] != null && (bool)data["blu_freereport"],
};
cartItems.Add(cartItem);
}
return(cartItems);
}
catch (Exception ex)
{
LogService.LogMessage(httpClient, new Log()
{
Level = (int)LogType.Error,
Name = ex.Message,
FunctionName = ClassName + " | " + MethodBase.GetCurrentMethod().Name,
Message = ex.InnerException != null ? ex.InnerException.Message : ex.Message
});
return(null);
}
}
public RibbonViewModel()
{
_shared = GetService <SharedService>();
}
public MenuViewModel()
{
_shared = GetService <SharedService>();
}
public FileSystemObjectToFileNameConverter()
{
_shared = ServiceLocator.Instance.GetService <SharedService>();
}
public OptionsViewModel()
{
_shared = GetService <SharedService>();
}
public StatusbarViewModel()
{
_onSelectionChanged = EventAggregator?.Subscribe <SelectionChangedEventArgs>(SelectionChanged);
_shared = GetService <SharedService>();
}
public async void UploadWav(string AbsolutePath)
{
AllRequestResult result = null;
await Task.Run(async() =>
{
result = await new SoundRecognitionService().SoundRecognition(AbsolutePath);
});
if (result.IsSuccess)
{
string FrogName = (string)result.Result;
l_Result.Text = FrogName;
if (FrogName == "台北樹蛙")
{
iv_ResultFrogImage.Image = UIImage.FromBundle("tptreefrog");
}
else if (FrogName == "面天樹蛙")
{
iv_ResultFrogImage.Image = UIImage.FromBundle("facefrog");
}
else if (FrogName == "澤蛙")
{
iv_ResultFrogImage.Image = UIImage.FromBundle("waterfrog");
}
else if (FrogName == "小雨蛙")
{
iv_ResultFrogImage.Image = UIImage.FromBundle("rainfrog");
}
else if (FrogName == "艾氏樹蛙")
{
iv_ResultFrogImage.Image = UIImage.FromBundle("aistreefrog");
}
else if (FrogName == "拉都希氏赤蛙")
{
iv_ResultFrogImage.Image = UIImage.FromBundle("ladofrog");
}
else if (FrogName == "虎皮蛙")
{
iv_ResultFrogImage.Image = UIImage.FromBundle("lionskinfrog");
}
else if (FrogName == "豎琴蛙")
{
iv_ResultFrogImage.Image = UIImage.FromBundle("harpfrog");
}
else if (FrogName == "布氏樹蛙")
{
iv_ResultFrogImage.Image = UIImage.FromBundle("boostreefrog");
}
else if (FrogName == "貢德氏赤蛙")
{
iv_ResultFrogImage.Image = UIImage.FromBundle("gondesfrog");
}
else
{
iv_ResultFrogImage.Image = UIImage.FromBundle("people");
}
}
else
{
SharedService.WebExceptionHandler((WebException)result.Result, this);
}
}
