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();
}
