private void btnSetting_Click(object sender, RoutedEventArgs e) { try { if (!string.IsNullOrEmpty(myPasswordBox.Password) && myPasswordBox.Password == myPasswordBoxRepeat.Password) { tbl_Setting setting = liteDb.Select(1); setting.isStartUp = startUpSwitch.IsChecked == true ? true : false; setting.passWord = myPasswordBox.Password; setting.title = titleTextBox.Text; if (liteDb.Update(setting)) { InstallMeOnStartUp(setting.isStartUp); Message("موفقیت", "اطلاعات ذخیره شد", NotificationType.Information); show_hideSettingBox(); } else { Message("خطای برنامه", "مشکلی پیش آمده است لطفا دوباره تلاش کنید", NotificationType.Information); } } else { Message("هشدار", "رمز عبورها باید یکسان باشند و نمیتواند خالی باشد", NotificationType.Warning); } } catch (Exception ex) { Debug.Text(ex, "btnSetting_Click()"); } }
private void Button_Click_1(object sender, RoutedEventArgs e) { PersonAccountingdbEntities db = new PersonAccountingdbEntities(); tbl_Setting set = new tbl_Setting(); set.Image1 = File.ReadAllBytes(Op.FileName); db.tbl_Setting.Add(set); db.SaveChanges(); MessageBox.Show("image has been saved"); }
// fill Settings Values from DataBase private void fillSettings() { try { tbl_Setting setting = liteDb.Select(1); titleTextBox.Text = txtTitle.Text = setting.title; startUpSwitch.IsChecked = setting.isStartUp; } catch (Exception ex) { Debug.Text(ex, "fillSettings()"); } }
public void CreateSettings() { /* * create test settings */ foundGlobalLegacyClaims = _uow.Settings.Get(x => x.IssuerId == null && x.AudienceId == null && x.UserId == null && x.ConfigKey == SettingsConstants.GlobalLegacyClaims).SingleOrDefault(); if (foundGlobalLegacyClaims == null) { foundGlobalLegacyClaims = _uow.Settings.Create( _map.Map <tbl_Setting>(new SettingV1() { ConfigKey = SettingsConstants.GlobalLegacyClaims, ConfigValue = "true", IsDeletable = true, })); _uow.Commit(); } foundGlobalLegacyIssuer = _uow.Settings.Get(x => x.IssuerId == null && x.AudienceId == null && x.UserId == null && x.ConfigKey == SettingsConstants.GlobalLegacyIssuer).SingleOrDefault(); if (foundGlobalLegacyIssuer == null) { foundGlobalLegacyIssuer = _uow.Settings.Create( _map.Map <tbl_Setting>(new SettingV1() { ConfigKey = SettingsConstants.GlobalLegacyIssuer, ConfigValue = "true", IsDeletable = true, })); _uow.Commit(); } foundGlobalTotpExpire = _uow.Settings.Get(x => x.IssuerId == null && x.AudienceId == null && x.UserId == null && x.ConfigKey == SettingsConstants.GlobalTotpExpire).SingleOrDefault(); if (foundGlobalTotpExpire == null) { foundGlobalTotpExpire = _uow.Settings.Create( _map.Map <tbl_Setting>(new SettingV1() { ConfigKey = SettingsConstants.GlobalTotpExpire, ConfigValue = 1200.ToString(), IsDeletable = true, })); _uow.Commit(); } }
// save new setting in db private void btnSetting_Click(object sender, RoutedEventArgs e) { tbl_Setting setting = dbSetting.Select(1); if (setting == null) { setting = new tbl_Setting() { id = 1, isDark = toggleDark.IsChecked ?? false, isLock = toggleProtection.IsChecked ?? false, username = "******" }; if (passwordBox.Password == passwordBoxRepeat.Password) { setting.password = passwordBox.Password; } else { alertMessage("err", "err", ToastTypes.Error); return; }; dbSetting.Insert(setting); } else { if (passwordBox.Password == passwordBoxRepeat.Password) { setting.password = passwordBox.Password; } else { alertMessage("err", "err", ToastTypes.Error); return; }; setting.isLock = toggleProtection.IsChecked ?? false; setting.isDark = toggleDark.IsChecked ?? false; dbSetting.Update(setting); } loadSetting(); }
// load settings from db in wrapPnael void loadSetting() { tbl_Setting setting = dbSetting.Select(1); if (setting == null) { setting = new tbl_Setting() { id = 1, isDark = false, isLock = false, password = "", username = "******" }; dbSetting.Insert(setting); } toggleDark.IsChecked = setting.isDark; toggleProtection.IsChecked = setting.isLock; // set Dark ui if (setting.isDark) { titleBar.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#3A4047")); mainGrid.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#282E33")); minimizeIcon.Foreground = maximizeIcon.Foreground = closeIcon.Foreground = new SolidColorBrush(Colors.White); cardSetting.Style = cardAdd.Style = cardShow.Style = (Style)Application.Current.Resources["customCardDark"]; } // set Light ui else { titleBar.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#F1F1F1")); mainGrid.Background = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#FFFFFF")); minimizeIcon.Foreground = maximizeIcon.Foreground = closeIcon.Foreground = new SolidColorBrush(Colors.DimGray); cardSetting.Style = cardAdd.Style = cardShow.Style = (Style)Application.Current.Resources["customCardLight"]; } }
public static void Seed(this ModelBuilder modelBuilder) { //if (!System.Diagnostics.Debugger.IsAttached) // System.Diagnostics.Debugger.Launch(); //context.Privilliges.RemoveRange(context.Privilliges.ToList()); //context.Menus.RemoveRange(context.Menus.ToList()); //context.SaveChanges(); //context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [tbl_Privillige] ON"); //context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [tbl_Menu] ON"); //context.Database.ExecuteSqlCommand("TRUNCATE TABLE [tbl_Privillige]"); //context.Database.ExecuteSqlCommand("TRUNCATE TABLE [tbl_Menu]"); //DBCC CHECKIDENT('tbl_Privillige',RESEED, 0) #region Seed #region UserTypes tbl_UserType ut1 = new tbl_UserType() { NameAr = "مريض", NameEn = "Patient" }; tbl_UserType ut2 = new tbl_UserType() { NameAr = "طبيب", NameEn = "Doctor" }; tbl_UserType ut3 = new tbl_UserType() { NameAr = "ادارة النظام", NameEn = "Administrator" }; fillbase(ut1); fillbase(ut2); fillbase(ut3); modelBuilder.Entity <tbl_UserType>().HasData(ut1, ut2, ut3); #endregion #region Privilliges tbl_Privillige Page_administration = new tbl_Privillige() { Key = common.Enums.Enum_Privilliges.Page_administration.ToString(), NameAr = common.Enums.Enum_Privilliges.Page_administration.ToString(), NameEn = common.Enums.Enum_Privilliges.Page_administration.ToString() }; tbl_Privillige Page_Groups = new tbl_Privillige() { Key = common.Enums.Enum_Privilliges.Page_Groups.ToString(), NameAr = common.Enums.Enum_Privilliges.Page_Groups.ToString(), NameEn = common.Enums.Enum_Privilliges.Page_Groups.ToString() }; tbl_Privillige Page_Groups_Add = new tbl_Privillige() { Key = common.Enums.Enum_Privilliges.Page_Groups_Add.ToString(), NameAr = common.Enums.Enum_Privilliges.Page_Groups_Add.ToString(), NameEn = common.Enums.Enum_Privilliges.Page_Groups_Add.ToString() }; tbl_Privillige Page_Users = new tbl_Privillige() { Key = common.Enums.Enum_Privilliges.Page_Users.ToString(), NameAr = common.Enums.Enum_Privilliges.Page_Users.ToString(), NameEn = common.Enums.Enum_Privilliges.Page_Users.ToString() }; tbl_Privillige Page_Users_Add = new tbl_Privillige() { Key = common.Enums.Enum_Privilliges.Page_Users_Add.ToString(), NameAr = common.Enums.Enum_Privilliges.Page_Users_Add.ToString(), NameEn = common.Enums.Enum_Privilliges.Page_Users_Add.ToString() }; fillbase(Page_Groups); fillbase(Page_Groups_Add); fillbase(Page_Users); fillbase(Page_Users_Add); fillbase(Page_administration); modelBuilder.Entity <tbl_Privillige>().HasData(Page_Groups, Page_Groups_Add, Page_Users, Page_Users_Add, Page_administration); #endregion #region Privilliges_Groups tbl_Group AdminGroup = new tbl_Group() { NameAr = common.Enums.Enum_PrivilligesGroup.AdminGroup.ToString(), NameEn = common.Enums.Enum_PrivilligesGroup.AdminGroup.ToString() }; tbl_Group DoctorGroup = new tbl_Group() { NameAr = common.Enums.Enum_PrivilligesGroup.DoctorGroup.ToString(), NameEn = common.Enums.Enum_PrivilligesGroup.DoctorGroup.ToString() }; tbl_Group PatientGroup = new tbl_Group() { NameAr = common.Enums.Enum_PrivilligesGroup.PatientGroup.ToString(), NameEn = common.Enums.Enum_PrivilligesGroup.PatientGroup.ToString() }; fillbase(AdminGroup); fillbase(DoctorGroup); fillbase(PatientGroup); modelBuilder.Entity <tbl_Group>().HasData(AdminGroup, DoctorGroup, PatientGroup); #endregion #region Menu List <tbl_Menu> Menus = new List <tbl_Menu>(); #region Security //tbl_Menu Menu_Security_Privilliges = new tbl_Menu() //{ // NameAr = "Privilliges", // icon = "ion-card", // NameEn = "Privilliges", // link = "/pages/Security/privilliges/Index", //}; tbl_Menu Menu_Security = new tbl_Menu() { ParentID = null, NameAr = " الادارة", NameEn = "administration", icon = "ion-settings", link = "", PrivilligeID = Page_administration.ID, //Children = new List<tbl_Menu>() //{ // Menu_Security_Users, // Menu_Security_Groups, //} }; fillbase(Menu_Security); tbl_Menu Menu_Security_Groups = new tbl_Menu() { ID = Guid.NewGuid(), ParentID = Menu_Security.ID, NameAr = "المجموعات", icon = "fa fa-object-group", NameEn = "groups", link = "/pages/administration/groups", }; fillbase(Menu_Security_Groups); tbl_Menu Menu_Security_Users = new tbl_Menu() { ID = Guid.NewGuid(), ParentID = Menu_Security.ID, NameAr = "المستخدمون", NameEn = "Users", icon = "ion-person-stalker", link = "/pages/administration/users", }; fillbase(Menu_Security_Users); Menus.Add(Menu_Security); Menus.Add(Menu_Security_Groups); Menus.Add(Menu_Security_Users); foreach (var m in Menus) { fillbase(m); foreach (var m_child in m.Children) { fillbase(m_child); } } modelBuilder.Entity <tbl_Menu>().HasData(Menu_Security, Menu_Security_Users, Menu_Security_Groups); #endregion #endregion #region Settings tbl_Setting sett1 = new tbl_Setting() { Conf_Key = "Active_Directory_Domain", Conf_Value = "GETGROUP.com" }; fillbase(sett1); modelBuilder.Entity <tbl_Setting>().HasData(sett1); #endregion #region Users tbl_User ahmedadmin = new tbl_User() { Email = "*****@*****.**", NameAr = "احمد حسن", NameEn = "ahmed hassan", Password = "******", isActivated = true, Mobile = "01111376958", Name = "*****@*****.**", ActivationStartDate = DateTime.Now.AddDays(-1), ActivationEndDate = null, UserTypeID = ut3.ID }; tbl_User user1 = new tbl_User() { Email = "*****@*****.**", NameAr = "admin1", NameEn = "admin1", Password = "******", isActivated = true, ActivationStartDate = DateTime.Now.AddDays(-1), ActivationEndDate = DateTime.MaxValue }; tbl_User user2 = new tbl_User() { Email = "*****@*****.**", NameAr = "admin2", NameEn = "admin2", Password = "******", isActivated = true, ActivationStartDate = DateTime.Now.AddDays(-1), ActivationEndDate = DateTime.MaxValue, }; fillbase(ahmedadmin); fillbase(user1); fillbase(user2); modelBuilder.Entity <tbl_User>().HasData(ahmedadmin); List <tbl_Privilligetbl_User> usersInPriv = new List <tbl_Privilligetbl_User>() { new tbl_Privilligetbl_User() { //User = ahmedadmin, tbl_User_ID = ahmedadmin.ID, tbl_Privillige_ID = Page_Groups.ID, //Privillige = Page_Groups }, new tbl_Privilligetbl_User() { //User = ahmedadmin, tbl_User_ID = ahmedadmin.ID, tbl_Privillige_ID = Page_Groups_Add.ID, //Privillige = Page_Groups_Add }, new tbl_Privilligetbl_User() { //User = ahmedadmin, tbl_User_ID = ahmedadmin.ID, tbl_Privillige_ID = Page_Users.ID, //Privillige = Page_Users }, new tbl_Privilligetbl_User() { //User = ahmedadmin, tbl_User_ID = ahmedadmin.ID, tbl_Privillige_ID = Page_Users_Add.ID, //Privillige = Page_Users_Add }, new tbl_Privilligetbl_User() { //User = ahmedadmin, tbl_User_ID = ahmedadmin.ID, tbl_Privillige_ID = Page_administration.ID, //Privillige = Page_Users_Add } }; //var ahmedadminPriv0 = new tbl_Privilligetbl_User() //{ // User = ahmedadmin, // Privillige = Page_administration //}; //var ahmedadminPriv1 = new tbl_Privilligetbl_User() //{ // User = ahmedadmin, // Privillige = Page_Groups //}; //var ahmedadminPriv2 = new tbl_Privilligetbl_User() //{ // User = ahmedadmin, // Privillige = Page_Users //}; //var ahmedadminPriv3 = new tbl_Privilligetbl_User() //{ // User = ahmedadmin, // Privillige = Page_Groups_Add //}; //var ahmedadminPriv4 = new tbl_Privilligetbl_User() //{ // User = ahmedadmin, // Privillige = Page_Users_Add //}; modelBuilder.Entity <tbl_Privilligetbl_User>().HasData(usersInPriv[0], usersInPriv[1], usersInPriv[2], usersInPriv[3], usersInPriv[4]); #endregion #endregion // context.Database.ExecuteSqlCommand(@"CREATE SEQUENCE [dbo].[ReferenceNmberSequence] // AS[bigint] // START WITH 40425942 // INCREMENT BY 1 // MINVALUE - 9223372036854775808 // MAXVALUE 99999999 // CACHE //GO"); //context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [tbl_Privillige] OFF"); //context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [tbl_Menu] OFF"); }