/*
* Create By 蒋予飞
* 通过ID获取管理员
* （ID没有对应管理员？）
*/
public Admin getAdminById(string id)
{
AdminDBContext adminDB = new AdminDBContext();
Admin admin = adminDB.admins.Find(id);
return(admin);
}
/*
* Create By 蒋予飞
* 列举所有管理员
*/
public List <Admin> listAllAdmins()
{
AdminDBContext adminDB = new AdminDBContext();
var admin = adminDB.admins.ToList();
return(admin);
}
public ActionResult Contact()
{
ViewBag.Message = "Your contact page.";
AdminDBContext db = new AdminDBContext();
ViewBag.welcome = db.welcomeNoticeModels.Select(x => x.WelcomeNotice).FirstOrDefault();
return(View());
}
public static RoleManager <AppRole, int> CreateRole()
{
var dbContext = new AdminDBContext();
var store = new RoleStore <AppRole, int, AppUserRole>(dbContext);
var rolemanager = new RoleManager <AppRole, int>(store);
return(rolemanager);
}
public ActionResult Index()
{
ApplicationDbContext context = new ApplicationDbContext();
AdminDBContext db = new AdminDBContext();
ViewBag.welcome = db.welcomeNoticeModels.Select(x => x.WelcomeNotice).FirstOrDefault();
ViewBag.rolelist = new SelectList(context.Roles.ToList(), "Name", "Name");//new SelectList(list1);
return(View());
}
public ValuesController(AdminDBContext context)
{
_context = context;
if (_context.Customers.Count() == 0)
{
_context.Customers.Add(new Customer {
CustomerName = "Axtest"
});
_context.SaveChanges();
}
}
/*
* Create By 蒋予飞
* 按管理员ID更新密码
*/
public int changePasswdById(string id, string password)
{
try
{
AdminDBContext adminDB = new AdminDBContext();
Admin admin = adminDB.admins.Find(id);
admin.password = password;
return(adminDB.SaveChanges());
}
catch (Exception e)
{
return(-1);
}
}
/*
* Create By 蒋予飞
* 按管理员ID更新姓名
*/
public int changeNameById(string id, string name)
{
try
{
AdminDBContext adminDB = new AdminDBContext();
Admin admin = adminDB.admins.Find(id);
admin.name = name;
return(adminDB.SaveChanges());
}
catch (Exception e)
{
return(-1);
}
}
/*
* Create By 蒋予飞
* 通过ID删除管理员
*/
public int deleteAdminById(string id)
{
try
{
AdminDBContext adminDB = new AdminDBContext();
Admin admin = adminDB.admins.Find(id);
adminDB.admins.Remove(admin);
return(adminDB.SaveChanges());
}
catch (Exception e)
{
return(-1);
}
}
/*
* Create By 蒋予飞
* 添加管理员
*/
public int addAdmin(Admin admin)
{
try
{
AdminDBContext adminDB = new AdminDBContext();
adminDB.admins.Add(admin);
return(adminDB.SaveChanges());
}
catch (Exception e)
{
//throw e;
//LogUtil.writeLogToFile(e);
return(-1);
}
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IHostingEnvironment env, AdminDBContext dbContext)
{
//adminDbContext = dbContext;
//adminDbContext.Database.EnsureCreated();
//if (env.IsDevelopment())
//{
// app.UseDeveloperExceptionPage();
//}
//else
//{
// app.UseExceptionHandler("/Home/Error");
// app.UseHsts();
//}
//app.UseHttpsRedirection();
//app.UseStaticFiles();
//app.UseAuthentication();
//app.UseCookiePolicy();
//app.UseMvc(routes =>
//{
// routes.MapRoute(
// name: "default",
// template: "{controller=Home}/{action=Index}/{id?}");
//});
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
}
else
{
app.UseExceptionHandler("/Home/Error");
app.UseHsts();
}
app.UseHttpsRedirection();
app.UseStaticFiles();
app.UseCookiePolicy();
app.UseAuthentication();
app.UseMvc(routes =>
{
routes.MapRoute(
name: "default",
template: "{controller=Home}/{action=Index}/{id?}");
});
}
/*
* Create By 蒋予飞
* 通过ID删除多个管理员
*/
public int deleteAdminsByIds(string[] ids)
{
try
{
AdminDBContext adminDB = new AdminDBContext();
Admin admin;
foreach (string id in ids)
{
admin = adminDB.admins.Find(id);
adminDB.admins.Remove(admin);
}
return(adminDB.SaveChanges());
}
catch (Exception e)
{
return(-1);
}
}
/*
* Create By 高晔
* 创建和初始化本地数据库
*/
public static void initLocalDB()
{
StudentDBContext studentDB = new StudentDBContext();
studentDB.students.Find("");
AdminDBContext adminDB = new AdminDBContext();
adminDB.admins.Find("");
DeanDBContext deanDB = new DeanDBContext();
deanDB.deans.Find("");
ProfessorDBContext professorDB = new ProfessorDBContext();
professorDB.professors.Find("");
SettingDBContext settingDBContext = new SettingDBContext();
//settingDBContext.settings.Find("");
MajorDBContext majorDBContext = new MajorDBContext();
majorDBContext.majors.Find(0);
}
public static UserManager <AppUser, int> Create()
{
var dbContext = new AdminDBContext();
var store = new UserStore <AppUser, AppRole, int, AppUserLogin, AppUserRole, AppUserClaim>(dbContext);
var usermanager = new UserManager <AppUser, int>(store);
// allow alphanumeric characters in username
usermanager.UserValidator = new UserValidator <AppUser, int>(usermanager)
{
AllowOnlyAlphanumericUserNames = false,
RequireUniqueEmail = false,
};
usermanager.PasswordValidator = new PasswordValidator()
{
RequiredLength = 4,
RequireDigit = false,
RequireUppercase = false
};
return(usermanager);
}
public ActionResult LogOn(Models.Admin admin)
{
if (ModelState.IsValid)
{
using (AdminDBContext db = new AdminDBContext())
{
var u =
db.Admins.FirstOrDefault(
adminCheck => adminCheck.Email == admin.Email && adminCheck.Password == admin.Password);
if (u != null)
{
return(RedirectToAction("ReservationInfoList", "ReservationDeatils", new { area = "Admin" }));
}
else
{
ModelState.AddModelError("", "Invalid Email and Password Combination!!");
}
}
}
return(View());
}
public AdminController(AdminDBContext adb)
{
_adb = adb;
}
public AdminRepository(AdminDBContext context)
{
this.context = context;
}
public CustomersController(AdminDBContext context)
{
_context = context;
}
public SystemUsersController(AdminDBContext context)
{
_context = context;
}
