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