private void Button_Click(object sender, RoutedEventArgs e)
{
//IDatabaseInitializer<BddContext> init = new CreateDatabaseIfNotExists<BddContext>();
//IDatabaseInitializer<BddContext> init = new DropCreateDatabaseAlways<BddContext>();
IDatabaseInitializer <BddContext> init = new DropCreateDatabaseIfModelChanges <BddContext>();
Database.SetInitializer(init);
init.InitializeDatabase(new BddContext());
}
public ActionResult Index()
{
dbInit.InitializeDatabase(db);
IdentityInitializer i = new IdentityInitializer();
i.Init(db);
return(RedirectToAction("Index", "Home"));
}
public bool Init(ApplicationDbContext db, string adminUserEmail, string adminPassword)
{
try
{
dbInit.InitializeDatabase(db);
var userManager = System.Web.HttpContext.Current.GetOwinContext().GetUserManager <ApplicationUserManager>();
var roleStore = new RoleStore <IdentityRole>(db);
var roleManager = new RoleManager <IdentityRole>(roleStore);
string name = adminUserEmail;
string password = adminPassword;
string roleName = "Admin";
//Create Role Admin if it does not exist
var role = roleManager.FindByName(roleName);
if (role == null)
{
role = new IdentityRole(roleName);
var roleresult = roleManager.Create(role);
}
var user = userManager.FindByName(name);
if (user == null)
{
user = new ApplicationUser {
UserName = name, Email = name
};
var result = userManager.Create(user, password);
result = userManager.SetLockoutEnabled(user.Id, false);
}
// Add user admin to Role Admin if not already added
var rolesForUser = userManager.GetRoles(user.Id);
if (!rolesForUser.Contains(role.Name))
{
var result = userManager.AddToRole(user.Id, role.Name);
}
return(true);
}
#pragma warning disable CS0168 // Variable is declared but never used
catch (Exception ex)
#pragma warning restore CS0168 // Variable is declared but never used
{
return(false);
}
}
public bool Init(ApplicationDbContext db, string adminUserEmail, string adminPassword)
{
try
{
dbInit.InitializeDatabase(db);
ApplicationUserManager userManager = System.Web.HttpContext.Current.GetOwinContext().GetUserManager <ApplicationUserManager>();
RoleStore <IdentityRole> roleStore = new RoleStore <IdentityRole>(db);
RoleManager <IdentityRole> roleManager = new RoleManager <IdentityRole>(roleStore);
string name = adminUserEmail;
string password = adminPassword;
string roleName = "Admin";
//Create Role Admin if it does not exist
IdentityRole role = roleManager.FindByName(roleName);
if (role == null)
{
role = new IdentityRole(roleName);
IdentityResult roleresult = roleManager.Create(role);
}
ApplicationUser user = userManager.FindByName(name);
if (user == null)
{
user = new ApplicationUser {
UserName = name, Email = name
};
IdentityResult result = userManager.Create(user, password);
result = userManager.SetLockoutEnabled(user.Id, false);
}
// Add user admin to Role Admin if not already added
System.Collections.Generic.IList <string> rolesForUser = userManager.GetRoles(user.Id);
if (!rolesForUser.Contains(role.Name))
{
IdentityResult result = userManager.AddToRole(user.Id, role.Name);
}
return(true);
}
catch (Exception)
{
return(false);
}
}
protected void Application_Start()
{
AreaRegistration.RegisterAllAreas();
GlobalConfiguration.Configure(WebApiConfig.Register);
FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters);
RouteConfig.RegisterRoutes(RouteTable.Routes);
BundleConfig.RegisterBundles(BundleTable.Bundles);
//IDatabaseInitializer<EasyGradeManagerContext> init = new DropCreateDatabaseAlways<EasyGradeManagerContext>();
IDatabaseInitializer <EasyGradeManagerContext> init = new DropCreateDatabaseIfModelChanges <EasyGradeManagerContext>();
Database.SetInitializer(init);
init.InitializeDatabase(new EasyGradeManagerContext());
HttpConfiguration config = GlobalConfiguration.Configuration;
config.Formatters.JsonFormatter
.SerializerSettings
.ReferenceLoopHandling = Newtonsoft.Json.ReferenceLoopHandling.Ignore;
config.Formatters.JsonFormatter
.SerializerSettings
.DateFormatString = "yyyy-MM-dd";
}
public void Configuration(IAppBuilder app)
{
try
{
// check if db needs to be deleted
var initializer = new DropCreateDatabaseIfModelChanges <SsnDbContext>();
Database.SetInitializer(initializer);
initializer.InitializeDatabase(new SsnDbContext());
}
catch (Exception ex)
{
Global.Logger.Error(ex.ToString());
}
app.UseCookieAuthentication(new CookieAuthenticationOptions
{
AuthenticationType = DefaultAuthenticationTypes.ApplicationCookie,
LoginPath = new PathString("/Authentication/Login")
});
}
public void InitializeDb()
{
var initializer = new DropCreateDatabaseIfModelChanges<SurveyorContext>();
using (var db = new SurveyorContext())
{
initializer.InitializeDatabase(db);
DbSeeder.Seed(db);
db.SaveChanges();
}
}
protected void Application_Start(object sender, EventArgs e)
{
var dbInitializer = new DropCreateDatabaseIfModelChanges <FrequentFlyersContext>();
dbInitializer.InitializeDatabase(new FrequentFlyersContext(BlueYonder.FrequentFlyerService.Implementation.FrequentFlyerService.ConnectionName));
}
static void Main(string[] args)
{
var dbInitializer = new DropCreateDatabaseIfModelChanges <MyDbContext>();
dbInitializer.InitializeDatabase(new MyDbContext());
UserDetailsImpl imp = new UserDetailsImpl();
UserDetailsDAO dao = new UserDetailsImpl();
int i;
string ch = "y";
while (!ch.Equals("n"))
{
Console.WriteLine("======================\n1. Add User \n2. Delete User \n3. Update User \n4. Get All User \n5. Get Data by ID \n======================");
Console.Write("\nEnter your Choice : ");
i = Int32.Parse(Console.ReadLine());
if (i < 6)
{
switch (i)
{
case 1:
UserDetails u = new UserDetails();
Console.Write("\nEnter Name : ");
u.Name = Console.ReadLine();
Console.Write("Enter Age : ");
u.Age = Int32.Parse(Console.ReadLine());
Console.Write("\nEnter Email : ");
u.UserEmail = Console.ReadLine();
Console.Write("\nEnter Password : "******"\nEnter Mobile : ");
u.UserMobile = long.Parse(Console.ReadLine());
Console.Write("\nEnter Adress : ");
u.UserAdress = Console.ReadLine();
Console.Write("\nEnter Role : ");
u.UserRole = Console.ReadLine();
Console.Write("\nEnter Status : ");
u.UserStatus = Console.ReadLine();
dao.addUser(u);
break;
case 2:
string delChoice = "y";
while (!delChoice.Equals("n"))
{
Console.Write("\nEnter ID to Delete: ");
UserDetails ud = new UserDetails();
ud.UserId1 = Int32.Parse(Console.ReadLine());
ud = dao.getSqlDataByUserId(ud);
Console.WriteLine(ud.UserId1 + "\t" + ud.Name + "\t" + ud.Age + "\t" + ud.UserAdress + "\t" + ud.UserEmail + "\t" + ud.UserPassword + "\t" + ud.UserMobile + "\t" + ud.UserRole + "\t" + ud.UserStatus);
Console.Write("Do you wanna delete this record? (y/n) : ");
string mchoice = Console.ReadLine();
if (mchoice == "y" || mchoice == "Y")
{
dao.removeUser(ud);
Console.WriteLine("Data deleted successfully.");
Console.Write("Delete more? (y/n) : ");
delChoice = Console.ReadLine();
}
else if (mchoice == "n" || mchoice == "N")
{
continue;
}
else
{
Console.WriteLine("Invalid input");
}
}
break;
case 3:
UserDetails uu = new UserDetails();
Console.Write("Enter the User ID to update data : ");
uu.UserId1 = Int32.Parse(Console.ReadLine());
Console.Write("New Name : ");
uu.Name = Console.ReadLine();
//Console.Write("New ID : ");
// uu.UserId1 = Int32.Parse(Console.ReadLine());
Console.Write("New Age : ");
uu.Age = Int32.Parse(Console.ReadLine());
Console.Write("New Adress : ");
uu.UserAdress = Console.ReadLine();
Console.Write("New Email : ");
uu.UserEmail = Console.ReadLine();
Console.Write("New Password : "******"\nNew Mobile : ");
uu.UserMobile = long.Parse(Console.ReadLine());
Console.Write("New Role : ");
uu.UserRole = Console.ReadLine();
Console.Write("New Status : ");
uu.UserStatus = Console.ReadLine();
dao.updateUser(uu);
break;
case 4:
List <UserDetails> uall = dao.getAllUsers();
Console.WriteLine("\n\nID\tName\tAge\n===================");
foreach (UserDetails ur in uall)
{
Console.WriteLine(ur.UserId1 + "\t" + ur.Name + "\t" + ur.Age + "\t" + ur.UserAdress + "\t" + ur.UserEmail + "\t" + ur.UserPassword + "\t" + ur.UserMobile + "\t" + ur.UserRole + "\t" + ur.UserStatus);
Console.WriteLine("-------------------");
}
break;
case 5:
UserDetails x = new UserDetails();
UserDetails y = new UserDetails();
Console.WriteLine("1. Get data by ID \n2. Get data by User ID");
int choice = Int32.Parse(Console.ReadLine());
if (choice == 1)
{
Console.Write("Enter ID: ");
x.Id = Int32.Parse(Console.ReadLine());
y = dao.getSqlDataById(x);
Console.WriteLine(y.UserId1 + "\t" + y.Name + "\t" + y.Age + "\t" + y.UserAdress + "\t" + y.UserEmail + "\t" + y.UserPassword + "\t" + y.UserMobile + "\t" + y.UserRole + "\t" + y.UserStatus);
}
else if (choice == 2)
{
Console.WriteLine("Enter User ID : ");
x.UserId1 = Int32.Parse(Console.ReadLine());
y = dao.getSqlDataByUserId(x);
Console.WriteLine(y.UserId1 + "\t" + y.Name + "\t" + y.Age + "\t" + y.UserAdress + "\t" + y.UserEmail + "\t" + y.UserPassword + "\t" + y.UserMobile + "\t" + y.UserRole + "\t" + y.UserStatus);
}
else
{
Console.WriteLine("Invalid Option.....\nPlease try again.");
continue;
}
break;
}
}
else
{
Console.WriteLine("\nInvalid Option.....\nPlease try again.\n");
continue;
}
Console.Write("\n\nRun prrogramme again? (y/n) : ");
ch = Console.ReadLine();
Console.WriteLine("\n\n");
}
}
