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