private void ParseValueData(MixCmsContext _context, IDbContextTransaction _transaction)
{
Fields = Lib.ViewModels.MixDatabaseColumns.UpdateViewModel.Repository.GetModelListBy(f => f.MixDatabaseId == MixDatabaseId, _context, _transaction).Data;
foreach (var field in Fields.OrderBy(f => f.Priority))
{
var val = Values.FirstOrDefault(v => v.MixDatabaseColumnId == field.Id);
if (val == null)
{
val = new Lib.ViewModels.MixDatabaseDataValues.UpdateViewModel(
new MixDatabaseDataValue()
{
MixDatabaseColumnId = field.Id,
MixDatabaseColumnName = field.Name,
}
, _context, _transaction)
{
Priority = field.Priority
};
Values.Add(val);
}
val.Priority = field.Priority;
val.MixDatabaseName = MixDatabaseName;
}
ParseData();
}
public override void ExpandView(MixCmsContext _context = null, IDbContextTransaction _transaction = null)
{
var getValues = Lib.ViewModels.MixDatabaseDataValues.UpdateViewModel
.Repository.GetModelListBy(a => a.DataId == Id && a.Specificulture == Specificulture, _context, _transaction);
if (getValues.IsSucceed)
{
Fields = Lib.ViewModels.MixDatabaseColumns.UpdateViewModel.Repository.GetModelListBy(f => f.MixDatabaseId == MixDatabaseId, _context, _transaction).Data;
Values = getValues.Data.OrderBy(a => a.Priority).ToList();
foreach (var field in Fields.OrderBy(f => f.Priority))
{
var val = Values.FirstOrDefault(v => v.MixDatabaseColumnId == field.Id);
if (val == null)
{
val = new Lib.ViewModels.MixDatabaseDataValues.UpdateViewModel(
new MixDatabaseDataValue()
{
MixDatabaseColumnId = field.Id,
MixDatabaseColumnName = field.Name,
}
, _context, _transaction)
{
Priority = field.Priority
};
Values.Add(val);
}
val.Priority = field.Priority;
val.MixDatabaseName = MixDatabaseName;
}
ParseData();
}
}
private JProperty ParseValue(Lib.ViewModels.MixDatabaseDataValues.UpdateViewModel item)
{
switch (item.DataType)
{
case MixDataType.DateTime:
return(new JProperty(item.MixDatabaseColumnName, item.DateTimeValue));
case MixDataType.Date:
return(new JProperty(item.MixDatabaseColumnName, item.DateTimeValue));
case MixDataType.Time:
return(new JProperty(item.MixDatabaseColumnName, item.DateTimeValue));
case MixDataType.Double:
return(new JProperty(item.MixDatabaseColumnName, item.DoubleValue));
case MixDataType.Boolean:
return(new JProperty(item.MixDatabaseColumnName, item.BooleanValue));
case MixDataType.Integer:
return(new JProperty(item.MixDatabaseColumnName, item.IntegerValue));
case MixDataType.Reference:
//string url = $"/api/v1/odata/en-us/related-attribute-set-data/mobile/parent/set/{Id}/{item.Field.ReferenceId}";
return(new JProperty(item.MixDatabaseColumnName, new JArray()));
case MixDataType.Custom:
case MixDataType.Duration:
case MixDataType.PhoneNumber:
case MixDataType.Text:
case MixDataType.Html:
case MixDataType.MultilineText:
case MixDataType.EmailAddress:
case MixDataType.Password:
case MixDataType.Url:
case MixDataType.ImageUrl:
case MixDataType.CreditCard:
case MixDataType.PostalCode:
case MixDataType.Upload:
case MixDataType.Color:
case MixDataType.Icon:
case MixDataType.VideoYoutube:
case MixDataType.TuiEditor:
default:
return(new JProperty(item.MixDatabaseColumnName, item.StringValue));
}
}
private void ParseModelValue(JToken property, Lib.ViewModels.MixDatabaseDataValues.UpdateViewModel item)
{
switch (item.Field.DataType)
{
case MixDataType.DateTime:
item.DateTimeValue = property.Value <DateTime?>();
item.StringValue = property.Value <string>();
break;
case MixDataType.Date:
item.DateTimeValue = property.Value <DateTime?>();
item.StringValue = property.Value <string>();
break;
case MixDataType.Time:
item.DateTimeValue = property.Value <DateTime?>();
item.StringValue = property.Value <string>();
break;
case MixDataType.Double:
item.DoubleValue = property.Value <double?>();
item.StringValue = property.Value <string>();
break;
case MixDataType.Boolean:
item.BooleanValue = property.Value <bool?>();
item.StringValue = property.Value <string>().ToLower();
break;
case MixDataType.Integer:
item.IntegerValue = property.Value <int?>();
item.StringValue = property.Value <string>();
break;
case MixDataType.Reference:
item.StringValue = property.Value <string>();
break;
case MixDataType.Upload:
string mediaData = property.Value <string>();
if (mediaData.IsBase64())
{
Lib.ViewModels.MixMedias.UpdateViewModel media = new Lib.ViewModels.MixMedias.UpdateViewModel()
{
Specificulture = Specificulture,
Status = MixContentStatus.Published,
MediaFile = new FileViewModel()
{
FileStream = mediaData,
Extension = ".png",
Filename = Guid.NewGuid().ToString(),
FileFolder = "Attributes"
}
};
var saveMedia = media.SaveModel(true);
if (saveMedia.IsSucceed)
{
item.StringValue = saveMedia.Data.FullPath;
Data[item.MixDatabaseColumnName] = item.StringValue;
}
}
else
{
item.StringValue = mediaData;
}
break;
case MixDataType.Custom:
case MixDataType.Duration:
case MixDataType.PhoneNumber:
case MixDataType.Text:
case MixDataType.Html:
case MixDataType.MultilineText:
case MixDataType.EmailAddress:
case MixDataType.Password:
case MixDataType.Url:
case MixDataType.ImageUrl:
case MixDataType.CreditCard:
case MixDataType.PostalCode:
case MixDataType.Color:
case MixDataType.Icon:
case MixDataType.VideoYoutube:
case MixDataType.TuiEditor:
default:
item.StringValue = property.Value <string>();
break;
}
}
public override MixDatabaseData ParseModel(MixCmsContext _context = null, IDbContextTransaction _transaction = null)
{
if (string.IsNullOrEmpty(Id))
{
Id = Guid.NewGuid().ToString();
CreatedDateTime = DateTime.UtcNow;
Priority = Repository.Count(m => m.MixDatabaseName == MixDatabaseName && m.Specificulture == Specificulture, _context, _transaction).Data + 1;
}
if (string.IsNullOrEmpty(MixDatabaseName))
{
MixDatabaseName = _context.MixDatabase.First(m => m.Id == MixDatabaseId)?.Name;
}
if (MixDatabaseId == 0)
{
MixDatabaseId = _context.MixDatabase.First(m => m.Name == MixDatabaseName)?.Id ?? 0;
}
Values = Values ?? Lib.ViewModels.MixDatabaseDataValues.UpdateViewModel
.Repository.GetModelListBy(a => a.DataId == Id && a.Specificulture == Specificulture, _context, _transaction).Data.OrderBy(a => a.Priority).ToList();
Fields = Lib.ViewModels.MixDatabaseColumns.UpdateViewModel.Repository.GetModelListBy(f => f.MixDatabaseId == MixDatabaseId, _context, _transaction).Data;
foreach (var field in Fields.OrderBy(f => f.Priority))
{
var val = Values.FirstOrDefault(v => v.MixDatabaseColumnId == field.Id);
if (val == null)
{
val = new Lib.ViewModels.MixDatabaseDataValues.UpdateViewModel(
new MixDatabaseDataValue()
{
MixDatabaseColumnId = field.Id,
MixDatabaseColumnName = field.Name,
}
, _context, _transaction)
{
StringValue = field.DefaultValue,
Priority = field.Priority,
Field = field
};
Values.Add(val);
}
val.Priority = field.Priority;
val.MixDatabaseName = MixDatabaseName;
if (Data[val.MixDatabaseColumnName] != null)
{
if (val.Field.DataType == MixDataType.Reference)
{
var arr = Data[val.MixDatabaseColumnName].Value <JArray>();
if (arr != null)
{
foreach (JObject objData in arr)
{
string id = objData["id"]?.Value <string>();
// if have id => update data, else add new
if (!string.IsNullOrEmpty(id))
{
//var getData = Repository.GetSingleModel(m => m.Id == id && m.Specificulture == Specificulture, _context, _transaction);
//if (getData.IsSucceed)
//{
// getData.Data.Data = objData;
// RefData.Add(getData.Data);
//}
}
else
{
RefData.Add(new FormViewModel()
{
Specificulture = Specificulture,
MixDatabaseId = field.ReferenceId.Value,
Data = objData
});
}
}
}
}
else
{
ParseModelValue(Data[val.MixDatabaseColumnName], val);
}
}
else
{
Data.Add(ParseValue(val));
}
}
// Save Edm html
var getAttrSet = Mix.Cms.Lib.ViewModels.MixDatabases.ReadViewModel.Repository.GetSingleModel(m => m.Name == MixDatabaseName, _context, _transaction);
var getEdm = Lib.ViewModels.MixTemplates.UpdateViewModel.GetTemplateByPath(getAttrSet.Data.EdmTemplate, Specificulture);
var edmField = Values.FirstOrDefault(f => f.MixDatabaseColumnName == "edm");
if (edmField != null && getEdm.IsSucceed && !string.IsNullOrEmpty(getEdm.Data.Content))
{
string body = getEdm.Data.Content;
foreach (var prop in Data.Properties())
{
body = body.Replace($"[[{prop.Name}]]", Data[prop.Name].Value <string>());
}
var edmFile = new FileViewModel()
{
Content = body,
Extension = ".html",
FileFolder = "edms",
Filename = $"{getAttrSet.Data.EdmSubject}-{Id}"
};
if (MixFileRepository.Instance.SaveWebFile(edmFile))
{
Data["edm"] = edmFile.WebPath;
edmField.StringValue = edmFile.WebPath;
}
}
//End save edm
return(base.ParseModel(_context, _transaction));;
}
