public async Task <IActionResult> Demote(string id)
{
const string adminRole = "Administrator";
if (!await this.roleManager.RoleExistsAsync(adminRole))
{
throw new ApplicationException(string.Format("User demotion unsuccessful , {0} role does not exist.", adminRole));
}
if (id == null)
{
throw new ApplicationException(string.Format("Id cannot be null."));
}
var user = await this.userManager.FindByIdAsync(id);
if (user == null)
{
throw new ApplicationException(string.Format("User with id {0} was not found.", id));
}
var removeRoleResult = await this.userManager.RemoveFromRoleAsync(user, adminRole);
if (removeRoleResult.Succeeded == true)
{
await this.userService.UpdateRole(user);
}
else
{
throw new ApplicationException(string.Format("User demotion operation was unsuccessful."));
}
var model = new UserTableViewModel(user);
return(PartialView("_UserTableRowPartial", model));
}
public ActionResult EditAdress(int id)
{
var UserId = User.Identity.GetUserId().ToString();
var UserName = User.Identity.GetUserName().ToString();
var Adress = _context.Address.ToList().FindAll(a => a.ApplicationUserId == UserId).DistinctBy(a => a.Street).ToList();
var Menuss = _context.Menus.ToList().FindAll(a => a.ApplicationUserId == UserId).DistinctBy(a => a.DescriptionMenu).ToList();
var Menu = new Menu();
Table Table = new Table();
var addr = _context.Address.SingleOrDefault(t => t.Id == id);
var viewModel = new UserTableViewModel
{
Id = UserId,
Name = UserName,
Address = addr,
MyTable = Table,
Menu = Menu,
Addresses = Adress,
Menus = Menuss,
};
return(View("new", viewModel));
}
public ActionResult Insert(UserTableViewModel model)
{
try
{
if (model.password != model.confPassword)
{
Session["insert"] = "failedPassword";
return(View());
}
using (var data = new BD_NETLINKEntities1())
{
usuario objUser = new usuario();
objUser.id_rol = 2;
objUser.email = model.email;
objUser.password = Encriptar.EncriptarClave(model.password);
objUser.nombre = model.nombre;
objUser.apellido = model.apellido;
objUser.telefono = model.telefono;
objUser.nombreUsuario = model.nombreUsuario;
data.usuario.Add(objUser);
data.SaveChanges();
}
Session["insert"] = "success";
return(View());
}
catch
{
Session["insert"] = "failed";
return(View());
}
}
public ActionResult Index()
{
var homeModel = new UserTableViewModel()
{
Users = _userService.GetAllUsers()
};
return(View(homeModel));
}
public ActionResult New(int Id)
{
var table = _context.Table.Single(t => t.Id == Id);
UserTableViewModel userTableViewMode = new UserTableViewModel
{
MyTable = table
};
return(View(userTableViewMode));
}
public ActionResult Index()
{
UserTableViewModel model = new UserTableViewModel();
model.Rooms = _roomService.GetAllRooms().Rooms.Select(u => new SelectListItem()
{
Text = u.RoomName, Value = u.RoomId.ToString()
}).ToList();
return(View("../Datatables/UserTable", model));
}
/// <summary>
/// 删除用户
/// </summary>
/// <param name="models"></param>
public void RemoveUserTable(UserTableViewModel models)
{
using (var db = new AALifeDbContext())
{
var userTable = models.Adapt <UserTable>();
db.Entry <UserTable>(userTable).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
}
}
/// <summary>
/// 增加用户
/// </summary>
/// <param name="models"></param>
public void AddUserTable(UserTableViewModel models)
{
using (var db = new AALifeDbContext())
{
var userTable = models.Adapt <UserTable>();
db.UserTable.Add(userTable);
db.SaveChanges();
}
}
public ActionResult UsersList()
{
var t = _context.Users.ToList();
var Model = new UserTableViewModel {
Users = t
};
return(View(Model));
}
public Login_Page()
{
this.InitializeComponent();
try
{
_user = new user();
_userTableVM = new UserTableViewModel();
}
catch
{
}
}
static TableRow CreateRow(int i, UserTableViewModel userTable)
{
// Create 1 row to the table.
TableRow tr1 = new TableRow();
// Add a cell to each column in the row.
TableCell tc1 = new TableCell(new Paragraph(new Run(new Text(i.ToString()))));
TableCell tc2 = new TableCell(new Paragraph(new Run(new Text(userTable.FullName))));
TableCell tc3 = new TableCell(new Paragraph(new Run(new Text(userTable.Email))));
TableCell tc4 = new TableCell(new Paragraph(new Run(new Text(userTable.Count.ToString()))));
tr1.Append(tc1, tc2, tc3, tc4);
return(tr1);
}
public UserTableViewModel GetUserLists(string userName)
{
var userTable = new UserTableViewModel();
SqlParameter[] param =
{
new SqlParameter("@userName", "%" + userName + "%")
};
var convertList = context.Database.SqlQuery <UserViewModel>("select ROW_NUMBER() over(order by CreateTime desc) as PageCount, UserID,UserIdentity,UserName,Pwd,BornDate,Job,Tel,Email,Sex,RoleName from [User] inner join [Role] on [Role].RoleID = [User].RoleID where UserName like @userName", param).ToList();
convertList.ForEach(m => { m.Age = SelfHelp.Utility.Common.CalculateAgeCorrect(m.BornDate, DateTime.Now); m.BornDateFormat = m.BornDate.ToString("yyyy-MM-dd"); });
userTable.ModelList = convertList;
return(userTable);
}
/// <summary>
/// 检查用户是否存在
/// </summary>
/// <param name="models"></param>
/// <param name="userName"></param>
public bool CheckUserExists(UserTableViewModel models, string type)
{
using (var db = new AALifeDbContext())
{
var exists = false;
switch (type)
{
case "UserName":
exists = db.Set <UserTable>().Any(a => a.UserName == models.UserName);
break;
}
return(exists);
}
}
public ActionResult Create(UserTableViewModel userTableViewModel)
{
var UserId = User.Identity.GetUserId().ToString();
var reservation = new Reservation
{
ApplicationUserId = UserId,
TableId = userTableViewModel.MyTable.Id,
ReservationDate = userTableViewModel.MyTable.Date2
};
_context.Reservations.Add(reservation);
_context.SaveChanges();
return(RedirectToAction("Index", "Home"));
}
public async Task <IActionResult> Index()
{
try
{
var users = await _userService.FilterUsersAsync();
var sensors = sensorService.GetAll().ToList();
var userModel = new UserIndexViewModel(users);
var model = new UserTableViewModel(sensors, sensors, userModel);
return(View(model));
}
catch
{
return(View("PageNotFound"));
}
}
public async Task <IActionResult> Restore(string id)
{
if (id == null)
{
throw new ApplicationException($"Passed ID parameter is absent.");
}
var user = await _userService.RestoreUser(id);
if (user == null)
{
throw new ApplicationException($"Unable to find user with ID '{id}'.");
}
var model = new UserTableViewModel(user);
return(PartialView("_UserTableRowPartial", model));
}
public async Task <IActionResult> Filter(string sortOrder, string searchTerm, int?pageSize, int?pageNumber)
{
try
{
sortOrder = sortOrder ?? string.Empty;
searchTerm = searchTerm ?? string.Empty;
var users = await _userService.FilterUsersAsync(sortOrder, searchTerm, pageNumber ?? 1, pageSize ?? 10);
var sensors = sensorService.GetAll().ToList();
var userModel = new UserIndexViewModel(users);
var model = new UserTableViewModel(sensors, sensors, userModel);
return(View("Index", model));
}
catch
{
return(View("PageNotFound"));
}
}
// GET: UserTable
public ActionResult Index()
{
//宣告一個新的頁面模型
UserTableViewModel userviewmodel = new UserTableViewModel();
//從Serivce中取得所有頁面所需要的陣列資料，然後放入到ViewModel中
userviewmodel.DataList = usertable_services.GetPdi_Users();
//若Session["UserID"]為空，表示會員未登入， 就算登入，若權限沒有為最大者，一樣踢出去
if (Session["Member"] == null || Convert.ToInt32(Session["Rank"]) != 5)
{
//建議跳出訊息使用js來顯示
//return View("Index", "_Layout", pdiviewmodel);
//導入到登入畫面
return(RedirectToAction("Index", "PdiTable"));
}
////會員登入狀態，將頁面資料傳入View中
return(View("Index", "_LayoutMember", userviewmodel));
}
public async Task <ActionResult> UsersTable(UserTableViewModel model)
{
if (!Request.IsAjaxRequest())
{
return(RedirectToAction("Index"));
}
ViewBag.hasFunctionBtn = model.HasFunction;
if (model.UserId != null)
{
var user = UserManager.FindById(model.UserId);
ViewBag.RoleName = (await RoleManager.FindByIdAsync(user.Roles.First().RoleId)).Name;
return(View("Ajax/UsersTable", new List <ApplicationUser> {
user
}));
}
ViewBag.RoleName = model.RoleName;
string roleId = (await RoleManager.FindByNameAsync(model.RoleName)).Id;
List <ApplicationUser> userList = await UserManager.FindByRoleIdAsync(roleId);
return(View("Ajax/UsersTable", userList));
}
public ActionResult New()
{
var UserId = User.Identity.GetUserId().ToString();
var UserName = User.Identity.GetUserName().ToString();
var Adress = _context.Address.ToList().FindAll(a => a.ApplicationUserId == UserId).DistinctBy(a => a.Street).ToList();
var Menu = _context.Menus.ToList().FindAll(a => a.ApplicationUserId == UserId);
Table Table = new Table();
var UserTableViewModel = new UserTableViewModel
{
Id = UserId,
Name = UserName,
MyTable = Table,
Addresses = Adress,
Menus = Menu
};
return(View(UserTableViewModel));
}
public UserTableViewModel GetUserList(int pageSize, int pageIndex, string userName)
{
var userTable = new UserTableViewModel();
var totalCount = context.Users.Where(m => m.UserName.Contains(userName)).ToList().Count;
userTable.PageCount = totalCount / pageSize;
if (totalCount < pageSize)
{
userTable.PageCount = 1;
}
if (totalCount % pageSize != 0 && totalCount > pageSize)
{
userTable.PageCount += 1;
}
SqlParameter[] param =
{
new SqlParameter("@userName", "%" + userName + "%")
};
var convertList = context.Database.SqlQuery <UserViewModel>("select UserID,UserIdentity,UserName,Pwd,BornDate,Job,Tel,Email,Sex,RoleName from [User] inner join [Role] on [Role].RoleID = [User].RoleID where UserName like @userName order by CreateTime desc", param).ToList().Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList();
convertList.ForEach(m => { m.Age = SelfHelp.Utility.Common.CalculateAgeCorrect(m.BornDate, DateTime.Now); m.BornDateFormat = m.BornDate.ToString("yyyy-MM-dd"); });
userTable.ModelList = convertList;
return(userTable);
}
public ActionResult Create(UserTableViewModel userTableViewModel, HttpPostedFileBase[] upload)
{
var UserId = User.Identity.GetUserId().ToString();
var UserName = User.Identity.GetUserName().ToString();
if (!ModelState.IsValid)
{
Table Table = new Table();
Address Addr = new Address();
Menu Men = new Menu();
var UserTableViewModelbis = new UserTableViewModel
{
Id = UserId,
Name = UserName,
MyTable = Table,
Address = Addr,
Menu = Men
};
return(View("New", UserTableViewModelbis));
}
userTableViewModel.MyTable.ApplicationUserId = UserId;
userTableViewModel.Address.Id = userTableViewModel.MyTable.AddressId;
userTableViewModel.Address.ApplicationUserId = UserId;
userTableViewModel.Menu.Id = userTableViewModel.MyTable.MenuId;
userTableViewModel.Menu.ApplicationUserId = UserId;
//userTableViewModel.MyTable.Address = userTableViewModel.Address;
//userTableViewModel.MyTable.Menu = userTableViewModel.Menu;
userTableViewModel.MyTable.Files = new List <File> ();
foreach (var file in upload)
{
if (file != null && file.ContentLength > 0)
{
var avatar = new File
{
FileName = System.IO.Path.GetFileName(file.FileName),
FileType = FileType.Avatar,
ContentType = file.ContentType,
};
using (var reader = new System.IO.BinaryReader(file.InputStream))
{
avatar.Content = reader.ReadBytes(file.ContentLength);
}
userTableViewModel.MyTable.Files.Add(avatar);
}
_context.Table.Add(userTableViewModel.MyTable);
_context.Menus.Add(userTableViewModel.Menu);
_context.Address.Add(userTableViewModel.Address);
}
try
{
_context.SaveChanges();
}
catch (DbEntityValidationException e)
{
Console.WriteLine(e);
}
return(RedirectToAction("Index", "Home"));
}
public Register_User_Page()
{
this.InitializeComponent();
newUser = new user();
_userTableViewModel = new UserTableViewModel();
}
