public long?ExistSiteSettingTranslation(long siteSettingID, long languageID)
{
SiteSettingTranslation siteSettingTranslation = context.SiteSettingTranslation.FirstOrDefault(z => z.LanguageID == languageID && z.SiteSettingID == siteSettingID);
long?siteSettingTranslationID = siteSettingTranslation != null ? siteSettingTranslation.ID : new Nullable <long>();
return(siteSettingTranslationID);
}
public SiteSettingIndexModel CreateOrUpdate(SiteSettingIndexModel request)
{
LanguageBusiness languageBusiness = new LanguageBusiness();
SiteSettingBusiness siteSettingBusiness = new SiteSettingBusiness();
bool existLanguage = languageBusiness.ExistLanguage(request.LanguageID);
long?existSiteSettingTranslation = siteSettingBusiness.ExistSiteSettingTranslation(request.SiteSettingID, request.LanguageID);
if (!existLanguage)
{
request.Alerts.AlertList.Add("Dil bulunamadı!");
request.Alerts.AlertType = Model.Base.Alerts.AlertTypes.Error;
return(request);
}
else
{
try
{
if (!existSiteSettingTranslation.HasValue)
{
SiteSettingTranslation siteSettingTranslation = siteSettingBusiness.CreateSiteSettingTranslation(request.LanguageID, request.SiteSettingID, request.Title, request.Description, request.Keyword, request.FooterText);
request.Alerts.AlertList.Add("Site ayarları başarıyla eklendi");
request.Alerts.AlertType = Model.Base.Alerts.AlertTypes.Success;
}
else
{
SiteSettingTranslation siteSettingTranslation = siteSettingBusiness.UpdateSiteSettingTranslation(request.LanguageID, request.SiteSettingID, request.Title, request.Description, request.Keyword, request.FooterText, request.Email, request.EmailPassword, request.EmailPort);
request.Alerts.AlertList.Add("Site ayarları başarıyla güncellendi.");
request.Alerts.AlertType = Model.Base.Alerts.AlertTypes.Success;
}
}
catch (Exception ex)
{
request.Alerts.AlertList.Add("Site ayarları kaydedilemedi [ " + ex.Message + " ]");
request.Alerts.AlertType = Model.Base.Alerts.AlertTypes.Error;
}
}
IEnumerable <Language> languageList = languageBusiness.LanguageList();
request.LanguageList = new SelectList(languageList, "ID", "Name", request.LanguageID);
return(request);
}
public SiteSettingIndexModel LoadIndex(long?languageID)
{
SiteSettingBusiness siteSettingBusiness = new SiteSettingBusiness();
LanguageBusiness languageBusiness = new LanguageBusiness();
SiteSettingIndexModel siteSettingIndexModel = new SiteSettingIndexModel();
SiteSetting siteSetting = siteSettingBusiness.GetSiteSetting();
SiteSettingTranslation siteSettingTranslation = null;
if (languageID.HasValue)
{
siteSettingTranslation = siteSetting.SiteSettingTranslation.FirstOrDefault(z => z.LanguageID == languageID);
}
else
{
siteSettingTranslation = siteSetting.SiteSettingTranslation.FirstOrDefault();
}
if (siteSettingTranslation == null)
{
siteSettingTranslation = new SiteSettingTranslation();
}
IEnumerable <Language> languageList = languageBusiness.LanguageList();
siteSettingIndexModel.LanguageList = new SelectList(languageList, "ID", "Name", languageID);
siteSettingIndexModel.LanguageID = siteSettingTranslation.LanguageID;
siteSettingIndexModel.Title = siteSettingTranslation.Title;
siteSettingIndexModel.Description = siteSettingTranslation.Description;
siteSettingIndexModel.Keyword = siteSettingTranslation.Keyword;
siteSettingIndexModel.FooterText = siteSettingTranslation.FooterText;
siteSettingIndexModel.Email = siteSetting.Email;
siteSettingIndexModel.EmailPassword = siteSetting.EmailPassword;
siteSettingIndexModel.EmailPort = siteSetting.EmailPort;
siteSettingIndexModel.SiteSettingID = siteSetting.ID;
return(siteSettingIndexModel);
}
public SiteSettingTranslation CreateSiteSettingTranslation(long languageID, long siteSettingID, string title, string description, string keyword, string footerText)
{
DateTime date = DateTime.Now;
SiteSettingTranslation siteSettingTranslation = new SiteSettingTranslation
{
Description = description,
FooterText = footerText,
Keyword = keyword,
LanguageID = languageID,
SiteSettingID = siteSettingID,
Title = title,
CreatedDate = date,
UpdatedDate = date
};
context.SiteSettingTranslation.Add(siteSettingTranslation);
SiteSetting siteSetting = this.GetSiteSetting();
siteSetting.UpdatedDate = date;
using (TransactionScope scope = new TransactionScope())
{
try
{
context.SaveChanges();
scope.Complete();
}
catch (Exception ex)
{
throw ex;
}
}
return(siteSettingTranslation);
}
public SiteSettingTranslation UpdateSiteSettingTranslation(long languageID, long siteSettingID, string title, string description, string keyword, string footerText, string email, string emailPassword, string emailPort)
{
DateTime date = DateTime.Now;
SiteSettingTranslation siteSettingTranslation = this.GetSiteSettingTranslation(siteSettingID, languageID);
siteSettingTranslation.Description = description;
siteSettingTranslation.FooterText = footerText;
siteSettingTranslation.Keyword = keyword;
siteSettingTranslation.LanguageID = languageID;
siteSettingTranslation.SiteSettingID = siteSettingID;
siteSettingTranslation.Title = title;
siteSettingTranslation.UpdatedDate = date;
SiteSetting siteSetting = this.GetSiteSetting();
siteSetting.UpdatedDate = date;
siteSetting.Email = email;
siteSetting.EmailPassword = emailPassword;
siteSetting.EmailPort = emailPort;
using (TransactionScope scope = new TransactionScope())
{
try
{
context.SaveChanges();
scope.Complete();
}
catch (Exception ex)
{
throw ex;
}
}
return(siteSettingTranslation);
}
public SiteSettingTranslation GetSiteSettingTranslation(long siteSettingID, long languageID)
{
SiteSettingTranslation siteSettingTranslation = context.SiteSettingTranslation.FirstOrDefault(z => z.SiteSettingID == siteSettingID && z.LanguageID == languageID);
return(siteSettingTranslation);
}
