private void InitData() { RegistryInfos.Clear(); RegistryInfoModel r1 = new RegistryInfoModel() { RKey = "InstallationDateTime", RValue = DateTime.Now.ToString() }; RegistryInfoModel r2 = new RegistryInfoModel() { RKey = "InstallationLocation", RValue = @"C:\Program Files\BIMProduct\BIMProductUpdate For Revit 2016\" }; RegistryInfoModel r3 = new RegistryInfoModel() { RKey = "ProductName", RValue = "BIMProduct" }; RegistryInfoModel r4 = new RegistryInfoModel() { RKey = "ProductNameInEng", RValue = "BIMProduct2018" }; RegistryInfoModel r5 = new RegistryInfoModel() { RKey = "ProductVersion", RValue = "18.1.4.0" }; RegistryInfoModel r6 = new RegistryInfoModel() { RKey = "RevitVersion", RValue = "Revit2016" }; RegistryInfos.Add(r1); RegistryInfos.Add(r2); RegistryInfos.Add(r3); RegistryInfos.Add(r4); RegistryInfos.Add(r5); RegistryInfos.Add(r6); }
/// <summary> /// Save Registry Information into the database /// </summary> /// <param name="registry"> /// The registry data, you want to save /// </param> public async Task <bool> SaveRegistryInfo(RegistryInfoModel registry) { using (IDbConnection connection = new SqlConnection(GlobalConfig.ConnString())) { //Check if registryId is 0 if (registry.Id == 0) { //This is a new record so save var param = new DynamicParameters(); param.Add("@MunicipalName", registry.MunicipalName); param.Add("@RegistryName", registry.RegistryName); param.Add("@Address", registry.Address); param.Add("@Email", registry.Email); param.Add("@Contact", registry.Contact); param.Add("@Id", 0, DbType.Int32, ParameterDirection.Output); if (registry.PicData != null) { param.Add("@PicName", registry.PicName); param.Add("@PicData", registry.PicData); await connection.ExecuteAsync("spRegistry_Create", param, commandType : CommandType.StoredProcedure); } else { await connection.ExecuteAsync("spRegistry_CreateNoImage", param, commandType : CommandType.StoredProcedure); } registry.Id = param.Get <int>("@Id"); return(registry.Id > 0); } else { //Update the record; var param = new DynamicParameters(); param.Add("@MunicipalName", registry.MunicipalName); param.Add("@RegistryName", registry.RegistryName); param.Add("@Address", registry.Address); param.Add("@Email", registry.Email); param.Add("@Contact", registry.Contact); param.Add("@Id", registry.Id); int result = 0; if (registry.PicData != null) { param.Add("@PicName", registry.PicName); param.Add("@PicData", registry.PicData); result = await connection.ExecuteAsync("spRegistry_Update", param, commandType : CommandType.StoredProcedure); } else { result = await connection.ExecuteAsync("spRegistry_UpdateNoImage", param, commandType : CommandType.StoredProcedure); } return(result > 0); } } }
private async Task LoadRegistryInfo() { registryRecord = await registry.GetRegistryInfo(); }