public Result <SettingVM> GetSetting()
{
var result = ConvertDataTableToList.BindList <GeneralSetting>(_dataSource.List());
if (result.Count > 0 || result.Count == 0)
{
var setting = new SettingVM();
setting.SiteUrl = result.FirstOrDefault(x => x.Name.Equals("SiteUrl")).Value;
setting.SiteName = result.FirstOrDefault(x => x.Name.Equals("SiteName")).Value;
setting.SiteKeyword = result.FirstOrDefault(x => x.Name.Equals("SiteKeyword")).Value;
setting.SiteDescription = result.FirstOrDefault(x => x.Name.Equals("SiteDescription")).Value;
setting.Address = result.FirstOrDefault(x => x.Name.Equals("Address")).Value;
setting.CountShowArticle = result.FirstOrDefault(x => x.Name.Equals("CountShowArticle")).Value;
setting.CountShowNews = result.FirstOrDefault(x => x.Name.Equals("CountShowNews")).Value;
setting.CountShowProduct = result.FirstOrDefault(x => x.Name.Equals("CountShowProduct")).Value;
setting.CountShowEvents = result.FirstOrDefault(x => x.Name.Equals("CountShowEvents")).Value;
setting.CountShowSlider = result.FirstOrDefault(x => x.Name.Equals("CountShowSlider")).Value;
setting.FacebookUrl = result.FirstOrDefault(x => x.Name.Equals("FacebookUrl")).Value;
setting.Fax = result.FirstOrDefault(x => x.Name.Equals("Fax")).Value;
setting.InstagramUrl = result.FirstOrDefault(x => x.Name.Equals("InstagramUrl")).Value;
setting.Mobile = result.FirstOrDefault(x => x.Name.Equals("Mobile")).Value;
setting.Phone = result.FirstOrDefault(x => x.Name.Equals("Phone")).Value;
setting.SiteMetaTag = result.FirstOrDefault(x => x.Name.Equals("SiteMetaTag")).Value;
setting.TelegramUrl = result.FirstOrDefault(x => x.Name.Equals("TelegramUrl")).Value;
setting.TwitterUrl = result.FirstOrDefault(x => x.Name.Equals("TwitterUrl")).Value;
setting.WhatsAppUrl = result.FirstOrDefault(x => x.Name.Equals("WhatsAppUrl")).Value;
return(Result <SettingVM> .Successful(data : setting));
}
return(Result <SettingVM> .Failure());
}
public IActionResult SendEmailToCustomer(SettingVM setting)
{
try
{
foreach (var item in setting.Information)
{
var supplierInfo = context.Supplier.Find(x => x.Id == item).FirstOrDefault();
if (supplierInfo != null && supplierInfo.Email != "")
{
MailMessage message = new MailMessage(
"*****@*****.**",
supplierInfo.Email,
setting.Subject,
setting.Message
);
message.IsBodyHtml = false;
SmtpClient smtpClient = new SmtpClient("Smtp.gmail.com", 587);
smtpClient.EnableSsl = true;
smtpClient.Credentials = new NetworkCredential("*****@*****.**", "shakilrana7055");
smtpClient.Send(message);
}
}
return(Json(true));
}
catch (Exception ex)
{
return(Json(false));
throw ex;
}
}
public SettingVM GetSettingByID(int settingID)
{
try
{
var settingData = unitOfWork.TblSettingRepository.GetByID(settingID);
SettingVM settingVM = new SettingVM();
settingVM.SettingID = settingData.SettingID;
settingVM.DesignationID = settingData.DesignationID != null?Convert.ToInt32(settingData.DesignationID) : 0;
if (settingVM.DesignationID > 0)
{
settingVM.DesignationName = settingData.tblDesignation.Designation;
}
settingVM.SettingCode = settingData.SettingCode;
settingVM.SettingDescription = settingData.SettingDesc;
settingVM.CreatedDate = settingData.CreatedDate != null?settingData.CreatedDate.ToString() : string.Empty;
settingVM.ModifiedDate = settingData.ModifiedDate != null?settingData.ModifiedDate.ToString() : string.Empty;
settingVM.CreatedBy = settingData.CreatedBy != null?Convert.ToInt32(settingData.CreatedBy) : 0;
settingVM.ModifiedBy = settingData.ModifiedBy != null?Convert.ToInt32(settingData.ModifiedBy) : 0;
return(settingVM);
}
catch (Exception ex)
{
throw;
}
}
public bool UpdateSetting(SettingVM settingVM)
{
using (var dbTransaction = unitOfWork.dbContext.Database.BeginTransaction())
{
try
{
tblSetting setting = unitOfWork.TblSettingRepository.GetByID(settingVM.SettingID);
setting.DesignationID = settingVM.DesignationID;
setting.SettingCode = settingVM.SettingCode;
setting.SettingDesc = settingVM.SettingDescription;
setting.ModifiedDate = DateTime.Now;
setting.ModifiedBy = settingVM.ModifiedBy;
unitOfWork.TblSettingRepository.Update(setting);
unitOfWork.Save();
//Complete the Transaction
dbTransaction.Commit();
return(true);
}
catch (Exception ex)
{
//Roll back the Transaction
dbTransaction.Rollback();
return(false);
}
}
}
public void DeleteSetting(SettingVM value)
{
var data = ObjectMapper.Mapper.Map <Setting>(value);
_stockMarketUow.SettingRepo.Delete(data);
_stockMarketUow.Save();
}
public SettingPage()
{
this.InitializeComponent();
settingVM = new SettingVM();
LoadUI();
LoadPlayer();
LoadDanmu();
LoadLiveDanmu();
LoadDownlaod();
}
public IActionResult SendEmailToCustomer()
{
var customerList = context.Customer.GetAll().ToList();
SettingVM setting = new SettingVM()
{
SupplierItem = POSHelper.Customer(customerList),
};
return(View(setting));
}
public IActionResult SendEmailToSupplier()
{
var supplier = context.Supplier.GetAll().ToList();
SettingVM setting = new SettingVM()
{
SupplierItem = POSHelper.Supplier(supplier),
};
return(View(setting));
}
public Result Update(SettingVM model)
{
try
{
var commands = PreUpdate(model);
SQLHelper.BatchExcute(commands.ToArray());
return(Result.Successful());
}
catch (Exception e) { throw; }
}
public async Task <IViewComponentResult> InvokeAsync()
{
var rqf = Request.HttpContext.Features.Get <IRequestCultureFeature>();
var culture = rqf.RequestCulture.Culture;
SettingVM model = new SettingVM {
Setting = await _db.Setting.Include("SocialActivities").FirstOrDefaultAsync(),
SettingTranslate = await _db.SettingTranslates.FirstOrDefaultAsync(a => a.Language.LanguageCode == culture.ToString())
};
return(View(model));
}
public IHttpActionResult Edit(SettingVM model)
{
try
{
var result = _service.Edit(model);
_cacheService.RemoveSiteSettings();
_cacheService.GetSiteSettings();
return(Ok(result));
}
catch { return(NotFound()); }
}
public Result Edit(SettingVM model)
{
var result = _dataSource.Update(model);
//if (result.Success)
//{
// _cacheService.RemoveSiteSettings();
// _cacheService.GetSiteSettings();
//}
return(result);
}
public override DataTemplate SelectTemplate(object item, DependencyObject container)
{
SettingVM setting = (SettingVM)item;
var controlFactory = new FrameworkElementFactory(setting.ControlType);
controlFactory.SetValue(FrameworkElement.DataContextProperty, item);
controlFactory.SetValue(FrameworkElement.MarginProperty, new Thickness(0, 0, 0, 4));
return(new DataTemplate()
{
VisualTree = controlFactory
});
}
public static bool PageSizeOptionsInAdvancedSettingsValidator(SettingVM model, string value)
{
if (model.Name.ToLower().Contains("pagesizeoptions"))
{
if (string.IsNullOrEmpty(value))
{
return(false);
}
var notValid = value.Split(',').Select(p => p.Trim()).GroupBy(p => p).Any(p => p.Count() > 1);
return(!notValid);
}
return(true);
}
public ActionResult UpdateSetting([FromBody] SettingVM value)
{
try
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
_stockMarketBusinessSevice.UpdateSetting(value);
return(Ok());
}
catch (Exception ex)
{
return(StatusCode(StatusCodes.Status500InternalServerError, ex));
}
}
public LiveDetailPage()
{
this.InitializeComponent();
this.NavigationCacheMode = NavigationCacheMode.Disabled;
dispRequest = new DisplayRequest();
DataTransferManager dataTransferManager = DataTransferManager.GetForCurrentView();
dataTransferManager.DataRequested += DataTransferManager_DataRequested;
_config = new FFmpegInteropConfig();
_config.FFmpegOptions.Add("rtsp_transport", "tcp");
_config.FFmpegOptions.Add("user_agent", "Mozilla/5.0 BiliDroid/1.12.0 ([email protected])");
_config.FFmpegOptions.Add("referer", "https://live.bilibili.com/");
//每过2秒就设置焦点
timer_focus = new DispatcherTimer()
{
Interval = TimeSpan.FromSeconds(2)
};
timer_focus.Tick += Timer_focus_Tick;
controlTimer = new DispatcherTimer()
{
Interval = TimeSpan.FromSeconds(1)
};
controlTimer.Tick += ControlTimer_Tick;
settingVM = new SettingVM();
liveRoomVM = new LiveRoomVM();
mediaPlayer = new MediaPlayer();
mediaPlayer.PlaybackSession.PlaybackStateChanged += PlaybackSession_PlaybackStateChanged;
mediaPlayer.PlaybackSession.BufferingStarted += PlaybackSession_BufferingStarted;
mediaPlayer.PlaybackSession.BufferingProgressChanged += PlaybackSession_BufferingProgressChanged;
mediaPlayer.PlaybackSession.BufferingEnded += PlaybackSession_BufferingEnded;
mediaPlayer.MediaOpened += MediaPlayer_MediaOpened;
mediaPlayer.MediaEnded += MediaPlayer_MediaEnded;;
mediaPlayer.MediaFailed += MediaPlayer_MediaFailed;
liveRoomVM.ChangedPlayUrl += LiveRoomVM_ChangedPlayUrl;
liveRoomVM.AddNewDanmu += LiveRoomVM_AddNewDanmu;
liveRoomVM.LotteryEnd += LiveRoomVM_LotteryEnd;
this.Loaded += LiveDetailPage_Loaded;
this.Unloaded += LiveDetailPage_Unloaded;
//TODO 快捷键
}
public SettingsVM(ISettings settings, UIElementsIntegration uiIntegration)
{
this.settings = settings;
CloseCommand = new Command(Close);
ResetCommand = new Command(Reset);
SaveCommand = new Command(Save);
SettingsSections = new ObservableCollection <SettingsSectionVM>();
ControlSelector = new ConfigControlTemplateSelector();
var groups = uiIntegration.SettingItems.Groups.Where(g => g != null).OrderBy(g => uiIntegration.SettingItems.GetGroupOrder(g));
foreach (var section in groups)
{
var sectionVM = new SettingsSectionVM(section);
foreach (SettingItem item in uiIntegration.SettingItems[section])
{
Type controlType = item.ControlType ?? GetDefaultControlType(item.DefaultValue.GetType());
if (controlType != null)
{
var vm = new SettingVM(settings, item.Name, item.EnabledCondition, controlType);
sectionVM.Add(vm);
}
}
SettingsSections.Add(sectionVM);
}
SelectedSection = SettingsSections.FirstOrDefault();
Text.LocaleChanged += () => NotifyPropertyChanged(
nameof(WindowTitle),
nameof(SaveText),
nameof(CloseText),
nameof(ResetToDefaultsText)
);
this.settings.Save("Current");
}
public IActionResult EditAll()
{
SettingVM setting = new SettingVM()
{
Footer = _context.Settings.Where(x => x.Key.Equals("Footer")).Select(x => x.Value).FirstOrDefault(),
AboutUs = _context.Settings.Where(x => x.Key.Equals("AboutUs")).Select(x => x.Value).FirstOrDefault(),
Address = _context.Settings.Where(x => x.Key.Equals("Address")).Select(x => x.Value).FirstOrDefault(),
ContactUs = _context.Settings.Where(x => x.Key.Equals("ContactUs")).Select(x => x.Value).FirstOrDefault(),
Email = _context.Settings.Where(x => x.Key.Equals("Email")).Select(x => x.Value).FirstOrDefault(),
Facebook = _context.Settings.Where(x => x.Key.Equals("Facebook")).Select(x => x.Value).FirstOrDefault(),
Instagram = _context.Settings.Where(x => x.Key.Equals("Instagram")).Select(x => x.Value).FirstOrDefault(),
linkedin = _context.Settings.Where(x => x.Key.Equals("linkedin")).Select(x => x.Value).FirstOrDefault(),
Phone = _context.Settings.Where(x => x.Key.Equals("Phone")).Select(x => x.Value).FirstOrDefault(),
PhoneNumber = _context.Settings.Where(x => x.Key.Equals("PhoneNumber")).Select(x => x.Value).FirstOrDefault(),
SiteLogo = _context.Settings.Where(x => x.Key.Equals("SiteLogo")).Select(x => x.Value).FirstOrDefault(),
SiteTitle = _context.Settings.Where(x => x.Key.Equals("SiteTitle")).Select(x => x.Value).FirstOrDefault(),
Successful = _context.Settings.Where(x => x.Key.Equals("Successful")).Select(x => x.Value).FirstOrDefault(),
Telegram = _context.Settings.Where(x => x.Key.Equals("Telegram")).Select(x => x.Value).FirstOrDefault(),
Twitter = _context.Settings.Where(x => x.Key.Equals("Twitter")).Select(x => x.Value).FirstOrDefault(),
whatsapp = _context.Settings.Where(x => x.Key.Equals("whatsapp")).Select(x => x.Value).FirstOrDefault(),
Slider1Text = _context.Settings.Where(x => x.Key.Equals("Slider1")).Select(x => x.Value).FirstOrDefault(),
Slider2Text = _context.Settings.Where(x => x.Key.Equals("Slider2")).Select(x => x.Value).FirstOrDefault(),
Slider3Text = _context.Settings.Where(x => x.Key.Equals("Slider3")).Select(x => x.Value).FirstOrDefault(),
Category1 = _context.Settings.Where(x => x.Key.Equals("Category1")).Select(x => x.Value).FirstOrDefault(),
Category1Title = _context.Settings.Where(x => x.Key.Equals("Category1")).Select(x => x.Title).FirstOrDefault(),
Category2 = _context.Settings.Where(x => x.Key.Equals("Category2")).Select(x => x.Value).FirstOrDefault(),
Category2Title = _context.Settings.Where(x => x.Key.Equals("Category2")).Select(x => x.Title).FirstOrDefault(),
Category3 = _context.Settings.Where(x => x.Key.Equals("Category3")).Select(x => x.Value).FirstOrDefault(),
Category3Title = _context.Settings.Where(x => x.Key.Equals("Category3")).Select(x => x.Title).FirstOrDefault(),
Category4 = _context.Settings.Where(x => x.Key.Equals("Category4")).Select(x => x.Value).FirstOrDefault(),
Category4Title = _context.Settings.Where(x => x.Key.Equals("Category4")).Select(x => x.Title).FirstOrDefault(),
Category5 = _context.Settings.Where(x => x.Key.Equals("Category5")).Select(x => x.Value).FirstOrDefault(),
Category5Title = _context.Settings.Where(x => x.Key.Equals("Category5")).Select(x => x.Title).FirstOrDefault(),
Category6 = _context.Settings.Where(x => x.Key.Equals("Category6")).Select(x => x.Value).FirstOrDefault(),
Category6Title = _context.Settings.Where(x => x.Key.Equals("Category6")).Select(x => x.Title).FirstOrDefault(),
Category7 = _context.Settings.Where(x => x.Key.Equals("Category7")).Select(x => x.Value).FirstOrDefault(),
Category7Title = _context.Settings.Where(x => x.Key.Equals("Category7")).Select(x => x.Title).FirstOrDefault()
};
return(View(setting));
}
public IHttpActionResult UpdateSetting([FromBody] JObject data)
{
try
{
int settingID = !string.IsNullOrEmpty(data.SelectToken("SettingID").Value <string>()) ? Convert.ToInt32(data.SelectToken("SettingID").Value <string>()) : 0;
int designationID = !string.IsNullOrEmpty(data.SelectToken("DesignationID").Value <string>()) ? Convert.ToInt32(data.SelectToken("DesignationID").Value <string>()) : 0;
string settingCode = !string.IsNullOrEmpty(data.SelectToken("SettingCode").Value <string>()) ? data.SelectToken("SettingCode").Value <string>() : string.Empty;
string settingDesc = !string.IsNullOrEmpty(data.SelectToken("SettingDesc").Value <string>()) ? data.SelectToken("SettingDesc").Value <string>() : string.Empty;
int userID = !string.IsNullOrEmpty(data.SelectToken("UserID").Value <string>()) ? Convert.ToInt32(data.SelectToken("UserID").Value <string>()) : 0;
if (!manageSetting.IsSettingAvailable(settingID, settingCode))
{
SettingVM settingVM = new SettingVM();
settingVM.SettingID = settingID;
settingVM.DesignationID = designationID;
settingVM.SettingCode = settingCode;
settingVM.SettingDescription = settingDesc;
settingVM.ModifiedBy = userID;
bool status = manageSetting.UpdateSetting(settingVM);
if (status)
{
return(Json(new { status = true, message = "Successfully updated" }));
}
else
{
return(Json(new { status = false, message = "Update Failed" }));
}
}
else
{
return(Json(new { status = false, message = "Setting Code already exists" }));
}
}
catch (Exception ex)
{
return(Json(new { status = false, message = "Unknown error occurred" }));
}
}
public List <SettingVM> GetAllSettings()
{
try
{
var settingData = unitOfWork.TblSettingRepository.Get().ToList();
List <SettingVM> settingList = new List <SettingVM>();
foreach (var setting in settingData)
{
SettingVM settingVM = new SettingVM();
settingVM.SettingID = setting.SettingID;
settingVM.DesignationID = setting.DesignationID != null?Convert.ToInt32(setting.DesignationID) : 0;
if (settingVM.DesignationID > 0)
{
settingVM.DesignationName = setting.tblDesignation.Designation;
}
settingVM.SettingCode = setting.SettingCode;
settingVM.SettingDescription = setting.SettingDesc;
settingVM.CreatedDate = setting.CreatedDate != null?setting.CreatedDate.ToString() : string.Empty;
settingVM.ModifiedDate = setting.ModifiedDate != null?setting.ModifiedDate.ToString() : string.Empty;
settingVM.CreatedBy = setting.CreatedBy != null?Convert.ToInt32(setting.CreatedBy) : 0;
settingVM.ModifiedBy = setting.ModifiedBy != null?Convert.ToInt32(setting.ModifiedBy) : 0;
settingList.Add(settingVM);
}
return(settingList);
}
catch (Exception ex)
{
throw;
}
}
public async Task <IViewComponentResult> InvokeAsync()
{
UserClient user = new UserClient();
var cookieValue = Request.Cookies["Token"];
if (cookieValue != null)
{
user = await _db.UserClients.FirstOrDefaultAsync(a => a.Token == cookieValue);
}
var rqf = Request.HttpContext.Features.Get <IRequestCultureFeature>();
var culture = rqf.RequestCulture.Culture;
ViewBag.languageId = _db.Languages.FirstOrDefault(a => a.LanguageCode == culture.ToString()).Id;
SettingVM model = new SettingVM
{
Setting = await _db.Setting.Include("SocialActivities").FirstOrDefaultAsync(),
User = user,
SettingTranslate = await _db.SettingTranslates.FirstOrDefaultAsync(a => a.Language.LanguageCode == culture.ToString()),
ProductCategories = await _db.ProductCategories.Include("ProductCategoryTranslate").Include("ProductSubCategories.ProductSubCategoryTranslate").Include("ProductSubCategories.BrandProductCategories.Brand").Where(p => p.Status == true).ToListAsync()
};
return(View(model));
}
public void AddSetting(SettingVM value)
{
_stockMarketDataSevice.AddSetting(value);
}
public void UpdateSetting(SettingVM value)
{
_stockMarketDataSevice.UpdateSetting(value);
}
private List <SqlCommand> PreUpdate(SettingVM model)
{
var commands = new List <SqlCommand>();
var setting = new SettingVM();
var result = ConvertDataTableToList.BindList <GeneralSetting>(List());
if (result.Count > 0 || result.Count == 0)
{
setting.SiteUrl = result.FirstOrDefault(x => x.Name.Equals("SiteUrl")).Value;
setting.SiteName = result.FirstOrDefault(x => x.Name.Equals("SiteName")).Value;
setting.SiteKeyword = result.FirstOrDefault(x => x.Name.Equals("SiteKeyword")).Value;
setting.SiteDescription = result.FirstOrDefault(x => x.Name.Equals("SiteDescription")).Value;
setting.Address = result.FirstOrDefault(x => x.Name.Equals("Address")).Value;
setting.CountShowArticle = result.FirstOrDefault(x => x.Name.Equals("CountShowArticle")).Value;
setting.CountShowNews = result.FirstOrDefault(x => x.Name.Equals("CountShowNews")).Value;
setting.CountShowProduct = result.FirstOrDefault(x => x.Name.Equals("CountShowProduct")).Value;
setting.CountShowEvents = result.FirstOrDefault(x => x.Name.Equals("CountShowEvents")).Value;
setting.CountShowSlider = result.FirstOrDefault(x => x.Name.Equals("CountShowSlider")).Value;
setting.FacebookUrl = result.FirstOrDefault(x => x.Name.Equals("FacebookUrl")).Value;
setting.Fax = result.FirstOrDefault(x => x.Name.Equals("Fax")).Value;
setting.InstagramUrl = result.FirstOrDefault(x => x.Name.Equals("InstagramUrl")).Value;
setting.Mobile = result.FirstOrDefault(x => x.Name.Equals("Mobile")).Value;
setting.Phone = result.FirstOrDefault(x => x.Name.Equals("Phone")).Value;
setting.SiteMetaTag = result.FirstOrDefault(x => x.Name.Equals("SiteMetaTag")).Value;
setting.TelegramUrl = result.FirstOrDefault(x => x.Name.Equals("TelegramUrl")).Value;
setting.TwitterUrl = result.FirstOrDefault(x => x.Name.Equals("TwitterUrl")).Value;
setting.WhatsAppUrl = result.FirstOrDefault(x => x.Name.Equals("WhatsAppUrl")).Value;
}
if (setting.Address != model.Address)
{
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@Name", "Address");
param[1] = new SqlParameter("@Value", model.Address);
commands.Add(SQLHelper.CreateCommand("pbl.spModifyGeneralSetting", CommandType.StoredProcedure, param));
}
if (setting.CountShowArticle != model.CountShowArticle)
{
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@Name", "CountShowArticle");
param[1] = new SqlParameter("@Value", model.CountShowArticle);
commands.Add(SQLHelper.CreateCommand("pbl.spModifyGeneralSetting", CommandType.StoredProcedure, param));
}
if (setting.CountShowNews != model.CountShowNews)
{
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@Name", "CountShowNews");
param[1] = new SqlParameter("@Value", model.CountShowNews);
commands.Add(SQLHelper.CreateCommand("pbl.spModifyGeneralSetting", CommandType.StoredProcedure, param));
}
if (setting.CountShowProduct != model.CountShowProduct)
{
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@Name", "CountShowProduct");
param[1] = new SqlParameter("@Value", model.CountShowProduct);
commands.Add(SQLHelper.CreateCommand("pbl.spModifyGeneralSetting", CommandType.StoredProcedure, param));
}
if (setting.CountShowSlider != model.CountShowSlider)
{
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@Name", "CountShowSlider");
param[1] = new SqlParameter("@Value", model.CountShowSlider);
commands.Add(SQLHelper.CreateCommand("pbl.spModifyGeneralSetting", CommandType.StoredProcedure, param));
}
if (setting.FacebookUrl != model.FacebookUrl)
{
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@Name", "FacebookUrl");
param[1] = new SqlParameter("@Value", model.FacebookUrl);
commands.Add(SQLHelper.CreateCommand("pbl.spModifyGeneralSetting", CommandType.StoredProcedure, param));
}
if (setting.Fax != model.Fax)
{
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@Name", "Fax");
param[1] = new SqlParameter("@Value", model.Fax);
commands.Add(SQLHelper.CreateCommand("pbl.spModifyGeneralSetting", CommandType.StoredProcedure, param));
}
if (setting.InstagramUrl != model.InstagramUrl)
{
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@Name", "InstagramUrl");
param[1] = new SqlParameter("@Value", model.InstagramUrl);
commands.Add(SQLHelper.CreateCommand("pbl.spModifyGeneralSetting", CommandType.StoredProcedure, param));
}
if (setting.Mobile != model.Mobile)
{
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@Name", "Mobile");
param[1] = new SqlParameter("@Value", model.Mobile);
commands.Add(SQLHelper.CreateCommand("pbl.spModifyGeneralSetting", CommandType.StoredProcedure, param));
}
if (setting.Phone != model.Phone)
{
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@Name", "Phone");
param[1] = new SqlParameter("@Value", model.Phone);
commands.Add(SQLHelper.CreateCommand("pbl.spModifyGeneralSetting", CommandType.StoredProcedure, param));
}
if (setting.SiteDescription != model.SiteDescription)
{
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@Name", "SiteDescription");
param[1] = new SqlParameter("@Value", model.SiteDescription);
commands.Add(SQLHelper.CreateCommand("pbl.spModifyGeneralSetting", CommandType.StoredProcedure, param));
}
if (setting.SiteKeyword != model.SiteKeyword)
{
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@Name", "SiteKeyword");
param[1] = new SqlParameter("@Value", model.SiteKeyword);
commands.Add(SQLHelper.CreateCommand("pbl.spModifyGeneralSetting", CommandType.StoredProcedure, param));
}
if (setting.SiteMetaTag != model.SiteMetaTag)
{
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@Name", "SiteMetaTag");
param[1] = new SqlParameter("@Value", model.SiteMetaTag);
commands.Add(SQLHelper.CreateCommand("pbl.spModifyGeneralSetting", CommandType.StoredProcedure, param));
}
if (setting.SiteName != model.SiteName)
{
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@Name", "SiteName");
param[1] = new SqlParameter("@Value", model.SiteName);
commands.Add(SQLHelper.CreateCommand("pbl.spModifyGeneralSetting", CommandType.StoredProcedure, param));
}
if (setting.SiteUrl != model.SiteUrl)
{
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@Name", "SiteUrl");
param[1] = new SqlParameter("@Value", model.SiteUrl);
commands.Add(SQLHelper.CreateCommand("pbl.spModifyGeneralSetting", CommandType.StoredProcedure, param));
}
if (setting.TelegramUrl != model.TelegramUrl)
{
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@Name", "TelegramUrl");
param[1] = new SqlParameter("@Value", model.TelegramUrl);
commands.Add(SQLHelper.CreateCommand("pbl.spModifyGeneralSetting", CommandType.StoredProcedure, param));
}
if (setting.TwitterUrl != model.TwitterUrl)
{
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@Name", "TwitterUrl");
param[1] = new SqlParameter("@Value", model.TwitterUrl);
commands.Add(SQLHelper.CreateCommand("pbl.spModifyGeneralSetting", CommandType.StoredProcedure, param));
}
if (setting.WhatsAppUrl != model.WhatsAppUrl)
{
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@Name", "WhatsAppUrl");
param[1] = new SqlParameter("@Value", model.WhatsAppUrl);
commands.Add(SQLHelper.CreateCommand("pbl.spModifyGeneralSetting", CommandType.StoredProcedure, param));
}
if (setting.CountShowEvents != model.CountShowEvents)
{
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@Name", "CountShowEvents");
param[1] = new SqlParameter("@Value", model.CountShowEvents);
commands.Add(SQLHelper.CreateCommand("pbl.spModifyGeneralSetting", CommandType.StoredProcedure, param));
}
return(commands);
}
public void DeleteSetting(SettingVM value)
{
_stockMarketDataSevice.DeleteSetting(value);
}
public ScheduleSettings()
{
InitializeComponent();
settingVM = new SettingVM();
DataContext = settingVM;
}
public ViewSetting()
{
InitializeComponent();
vm = new SettingVM(new SettingModel());
this.DataContext = vm;
}
