public UISettingsModel GetUISettings(Guid?languageId)
{
UISettingsModel data = null;
using (var command = Context.Connection.GenerateCommand(
"admdata.get_nfooter",
new
{
languageId
}))
{
using (var reader = command.ExecuteReaderSafety())
{
if (reader.Read())
{
data = new UISettingsModel
{
Id = reader.GetFieldValue <Guid?>("id"),
Address = new SortedDictionary <string, string>(),
Phone = reader.GetFieldValue <string>("phone"),
WorkingTime = new SortedDictionary <string, string>(),
Email = reader.GetFieldValue <string>("email"),
Explanation = new SortedDictionary <string, string>(),
PortalName = new SortedDictionary <string, string>(),
PortalSubName = new SortedDictionary <string, string>(),
PortalRights = new SortedDictionary <string, string>(),
FbLink = reader.GetFieldValue <string>("fblink"),
LinkedInLink = reader.GetFieldValue <string>("ytlink")
};
var languages = reader.GetFieldValue <Guid[]>("languageid");
var addresses = reader.GetFieldValue <string[]>("address");
var workingTimes = reader.GetFieldValue <string[]>("workingtime");
var signalsText = reader.GetFieldValue <string[]>("signalstext");
var portalNamesText = reader.GetFieldValue <string[]>("portalname");
var portalSubNamesText = reader.GetFieldValue <string[]>("portalsubname");
var portalRightsText = reader.GetFieldValue <string[]>("portalrights");
for (var i = 0; i < languages.Length; i++)
{
var language = languages[i].ToString();
data.Address.Add(language, addresses[i]);
data.WorkingTime.Add(language, workingTimes[i]);
data.Explanation.Add(language, signalsText[i]);
data.PortalName.Add(language, portalNamesText[i]);
data.PortalSubName.Add(language, portalSubNamesText[i]);
data.PortalRights.Add(language, portalRightsText[i]);
}
}
}
}
return(data);
}
public void UpsertUISetting(UISettingsModel model)
{
using (var command = Context.Connection.GenerateCommand(
"admdata.upd_nfooter",
null,
new Dictionary <string, object>
{
{ "paddress", model.Address.Values.ToArray() },
{ "pphone", model.Phone },
{ "pworkingtime", model.WorkingTime.Values.ToArray() },
{ "pemail", model.Email },
{ "psignalstext", model.Explanation.Values.ToArray() },
{ "pfblink", model.FbLink },
{ "pytlink", model.LinkedInLink },
{ "pportalname", model.PortalName.Values.ToArray() },
{ "pportalsubname", model.PortalSubName.Values.ToArray() },
{ "pportalrights", model.PortalRights.Values.ToArray() },
{ "planguageid", model.Address.Keys.Select(Guid.Parse).ToArray() }
}))
{
command.ExecuteNonQuerySafety();
}
}
public void UpsertUISettings(UISettingsModel model)
{
adminRepository.UpsertUISetting(model);
}
