public GroupDetailViewModel GetDetail(int id) { var sqlScript = @" SELECT [g].[Id], [g].[Name], [g].[Created] FROM [dbo].[Group] [g] WHERE [Id] = @id SELECT [u].[Name] FROM [dbo].[UserGroup] [ug] LEFT JOIN [dbo].[User] [u] ON [u].[Id] = [ug].[UserId] WHERE [ug].[GroupId] = @id SELECT [r].[Name] FROM [dbo].[GroupRole] [gr] LEFT JOIN [dbo].[Role] [r] ON [gr].[RoleId] = [r].[Id] WHERE [gr].[GroupId] = @id "; var parameters = new DynamicParameters(); parameters.Add("id", id, DbType.Int32); var result = new GroupDetailViewModel(); using (var conn = new SqlConnection(ConnectionString)) { var reader = conn.QueryMultiple(sqlScript, parameters); result.Group = reader.Read <Group>().FirstOrDefault(); result.UserNames = reader.Read <string>().ToArray(); result.RoleNames = reader.Read <string>().ToArray(); } return(result); }
public ActionResult ShowGroupDetail(int id, string currentUser) { var groupService = this.Service <IGroupService>(); var groupMemberService = this.Service <IGroupMemberService>(); ResponseModel <GroupDetailViewModel> response = null; try { Group group = groupService.FindGroupById(id); GroupDetailViewModel result = Mapper.Map <GroupDetailViewModel>(group); result.IsAdmin = groupMemberService.CheckAdmin(currentUser, result.Id); result.IsMember = groupMemberService.CheckMember(currentUser, result.Id); response = new ResponseModel <GroupDetailViewModel>(true, "Thông tin nhóm:", null, result); } catch (Exception) { response = ResponseModel <GroupDetailViewModel> .CreateErrorResponse("Tải thông tin thất bại!", systemError); } return(Json(response)); }
public async Task <ActionResult> GovernanceChangeHistoryAsync(int id, int skip = 0, string sortBy = null) { var result = await _groupReadService.GetAsync(id, User); if (result.ReturnValue == null) { return(HttpNotFound()); } var model = result.ReturnValue; var viewModel = new GroupDetailViewModel { Group = model, GroupTypeName = model.GroupTypeId.HasValue ? await _lookup.GetNameAsync(() => model.GroupTypeId) : null, LocalAuthorityName = await _lookup.GetNameAsync(() => model.LocalAuthorityId), GroupStatusName = await _lookup.GetNameAsync(() => model.StatusId, "Group"), Address = model.GroupTypeId.OneOfThese(GT.SingleacademyTrust, GT.MultiacademyTrust, GT.ChildrensCentresGroup) ? model.Address.ToString() : null, IsUserLoggedOn = User.Identity.IsAuthenticated, GroupTypeId = model.GroupTypeId ?? -1, IsClosed = model.StatusId == (int)GS.Closed || model.StatusId == (int)GS.CreatedInError, IsClosedInError = model.StatusId == (int)GS.CreatedInError, CloseDate = model.ClosedDate, ChangeHistory = await _groupReadService.GetGovernanceChangeHistoryAsync(id, skip, 100, sortBy, User) }; return(View("GovernanceChangeHistory", viewModel)); }
public async Task <ActionResult> Details(int id, string searchQueryString = "", eLookupSearchSource searchSource = eLookupSearchSource.Groups, int skip = 0, string sortBy = null, bool saved = false) { ViewBag.ShowSaved = saved; var model = (await _groupReadService.GetAsync(id, User)).GetResult(); var viewModel = new GroupDetailViewModel { SearchQueryString = searchQueryString, SearchSource = searchSource, CanUserEdit = await _groupReadService.CanEditAsync(id, User), CanUserEditGovernance = await _groupReadService.CanEditGovernanceAsync(id, User), Group = model, GroupTypeName = model.GroupTypeId.HasValue ? await _lookup.GetNameAsync(() => model.GroupTypeId) : null, LocalAuthorityName = model.LocalAuthorityId.HasValue ? await _lookup.GetNameAsync(() => model.LocalAuthorityId) : null, GroupStatusName = model.StatusId.HasValue ? await _lookup.GetNameAsync(() => model.StatusId, "Group") : null, Address = model.GroupTypeId.OneOfThese(GT.SingleacademyTrust, GT.MultiacademyTrust, GT.ChildrensCentresGroup) ? model.Address.ToString() : null, IsUserLoggedOn = User.Identity.IsAuthenticated, GroupTypeId = model.GroupTypeId ?? -1, IsClosed = model.StatusId == (int)eLookupGroupStatus.Closed || model.StatusId == (int)eLookupGroupStatus.CreatedInError, IsClosedInError = model.StatusId == (int)eLookupGroupStatus.CreatedInError, CloseDate = model.ClosedDate }; if (viewModel.IsUserLoggedOn) { viewModel.ChangeHistory = await _groupReadService.GetChangeHistoryAsync(id, skip, 100, sortBy.Clean() ?? "requestedDateUtc-desc", User); } await PopulateEstablishmentList(viewModel.Establishments, model.GroupUId.Value, true); return(View(viewModel)); }
public ActionResult Edit(string id) { try { //初始化物件 var m = new GroupDetailViewModel(); //取得群組資料 var dtGroup = GroupDataAccess.GetGroupList(id, null, new Pages()); var listGroup = Util.ToList <GroupDetailViewModel>(dtGroup); m = listGroup[0]; //取得排序過的選單清單 var dtMenu = GroupDataAccess.GetGroupMenuAuth(id); m.AuthList = Util.ToList <MenuAuth>(dtMenu); //取得群組底下的使用者清單 var dtGroupUser = GroupDataAccess.GetGroupUser(id); m.GroupUserItems = Util.ToList <GroupUserItem>(dtGroupUser); return(View("Detail", m)); } catch { return(RedirectToAction("Error", "Home")); } }
private GroupDetailWindow() { model = new GroupDetailViewModel(); this.DataContext = model; model.Window = this; this.AddModel(model); InitializeComponent(); }
public GroupDetailWindow(GroupDetailViewModel vmGroup = null) : this() { if (vmGroup != null) { vmGroup.CopyTo(model); } base.Title = model.IsNew ? "新增组织" : "修改组织"; txtGpCode.IsReadOnly = model.groupdata.gp_code.IsNotEmpty(); }
public async Task<IActionResult> EditGroupDetail(GroupDetailViewModel model) { if (ModelState.IsValid) { var groupDetailEntity = await _converterHelper.ToGroupDetailEntityAsync(model, false); _context.Update(groupDetailEntity); await _context.SaveChangesAsync(); return RedirectToAction($"{nameof(DetailsGroup)}/{model.GroupId}"); } return View(model); }
public GroupDetailPage(GroupDetailViewModel viewModel) { InitializeComponent(); BindingContext = this.viewModel = viewModel; this.viewModel.OnFinished += OnFinished; viewModel.OnNavigateToDetails = async(detailsViewModel) => { await Navigation.PushAsync(new DetailPage(detailsViewModel)); }; }
public async Task <IActionResult> EditGroupDetail(GroupDetailViewModel model) { if (ModelState.IsValid) { GroupDetailEntity groupDetailEntity = await contenedorTrabajo.Converter.ToGroupDetailEntityAsync(model, false); contenedorTrabajo.Tournament.UpdateDetailGroupEntity(groupDetailEntity); contenedorTrabajo.Save(); return(RedirectToAction("DetailsGroup", "Tournaments", new { id = model.GroupId })); } return(View(model)); }
public async Task <IActionResult> EditGroupDetail(GroupDetailViewModel model) { if (ModelState.IsValid) { GroupDetailEntity groupDetailEntity = await _converterHelper.ToGroupDetailEntityAsync(model, false); _context.Update(groupDetailEntity); await _context.SaveChangesAsync(); return(RedirectToAction("DetailsGroup", new { id = model.GroupId })); } return(View(model)); }
public async Task<IActionResult> AddGroupDetail(GroupDetailViewModel model) { if (ModelState.IsValid) { var groupDetailEntity = await _converterHelper.ToGroupDetailEntityAsync(model, true); _context.Add(groupDetailEntity); await _context.SaveChangesAsync(); return RedirectToAction($"{nameof(DetailsGroup)}/{model.GroupId}"); } model.Group = await _context.Groups.FindAsync(model.GroupId); model.Teams = _combosHelper.GetComboTeams(); return View(model); }
public GroupDetailViewModel GetDetail(int id) { var sqlScript = @" SELECT [g].[Id], [g].[Name], [g].[Created] FROM [dbo].[Group] [g] WHERE [Id] = @id SELECT [u].[Name] FROM [dbo].[UserGroup] [ug] LEFT JOIN [dbo].[User] [u] ON [u].[Id] = [ug].[UserId] WHERE [ug].[GroupId] = @id SELECT [r].[Name] FROM [dbo].[GroupRole] [gr] LEFT JOIN [dbo].[Role] [r] ON [gr].[RoleId] = [r].[Id] WHERE [gr].[GroupId] = @id "; var result = new GroupDetailViewModel(); using (var dbContext = DbContextFactory.CreateEfDbContext()) { var command = dbContext.Database.Connection.CreateCommand(); command.CommandText = sqlScript; command.CommandType = CommandType.Text; command.Parameters.Clear(); var parameter = new SqlParameter(parameterName: "id", value: id) { SqlDbType = SqlDbType.Int }; command.Parameters.Add(parameter); dbContext.Database.Connection.Open(); using (var reader = command.ExecuteReader()) { var objectContextAdapter = ((IObjectContextAdapter)dbContext).ObjectContext; result.Group = objectContextAdapter.Translate <Group>(reader).FirstOrDefault(); reader.NextResult(); result.UserNames = objectContextAdapter.Translate <string>(reader).ToArray(); reader.NextResult(); result.RoleNames = objectContextAdapter.Translate <string>(reader).ToArray(); } } return(result); }
public async Task <GroupDetailEntity> ToGroupDetailEntityAsync(GroupDetailViewModel model, bool isNew) { return(new GroupDetailEntity { GoalsAgainst = model.GoalsAgainst, GoalsFor = model.GoalsFor, Group = await _context.Groups.FindAsync(model.GroupId), Id = isNew ? 0 : model.Id, MatchesLost = model.MatchesLost, MatchesPlayed = model.MatchesPlayed, MatchesTied = model.MatchesTied, MatchesWon = model.MatchesWon, Team = await _context.Teams.FindAsync(model.TeamId) }); }
public async Task <IActionResult> AddGroupDetail(GroupDetailViewModel model) { if (ModelState.IsValid) { GroupDetailEntity groupDetailEntity = await contenedorTrabajo.Converter.ToGroupDetailEntityAsync(model, true); contenedorTrabajo.Tournament.AddDetailGroupEntity(groupDetailEntity); contenedorTrabajo.Save(); return(RedirectToAction("DetailsGroup", "Tournaments", new { id = model.GroupId })); } model.Group = await contenedorTrabajo.Tournament.GetGroup(model.GroupId); model.Teams = contenedorTrabajo.Combos.GetComboTeams(); return(View(model)); }
public JsonResult Save(GroupDetailViewModel m) { Result r = new Result(); try { GroupDataAccess.SaveGroupInfo(m); r.Set(ResultCode.Success, "作業成功"); } catch (Exception e) { r.Set(ResultCode.Error, e.Message); } return(Json(r, JsonRequestBehavior.AllowGet)); }
public async Task <IActionResult> AddGroupDetail(GroupDetailViewModel model) { if (ModelState.IsValid) { GroupDetailEntity groupDetailEntity = await _converterHelper.ToGroupDetailEntityAsync(model, true); _context.Add(groupDetailEntity); await _context.SaveChangesAsync(); return(RedirectToAction("DetailsGroup", new { id = model.GroupId })); } model.Group = await _context.Groups.FindAsync(model.GroupId); model.Teams = _combosHelper.GetComboTeams(); return(View(model)); }
public async Task <IActionResult> AddGroupDetail(GroupDetailViewModel model) { if (ModelState.IsValid) { var groupDetailEntity = await _converterHelper.ToGroupDetailEntityAsync(model, true); _context.Add(groupDetailEntity); await _context.SaveChangesAsync(); return(RedirectToAction($"{nameof(DetailsGroup)}/{model.GroupId}")); } //Aqui se hace cuando el modeo falla para que no se pierda el combo model.Group = await _context.Groups.FindAsync(model.GroupId); model.Teams = _combosHelper.GetComboTeams(); return(View(model)); }
public ActionResult Add(string id) { try { //初始化物件 var m = new GroupDetailViewModel(); //取得排序過的選單清單 var dtMenu = GroupDataAccess.GetGroupMenuAuth("0"); m.AuthList = Util.ToList <MenuAuth>(dtMenu); return(View("Detail", m)); } catch { return(RedirectToAction("Error", "Home")); } }
public async Task <IActionResult> EditGroupDetail(int?id) { if (id == null) { return(NotFound()); } GroupDetailEntity groupDetailEntity = await _dataContext.GroupDetails.Include(gd => gd.Group).Include(gd => gd.Team).FirstOrDefaultAsync(gd => gd.Id == id); if (groupDetailEntity == null) { return(NotFound()); } GroupDetailViewModel model = _converterHelper.ToGroupDetailViewModel(groupDetailEntity); return(View(model)); }
public async Task <IActionResult> EditGroupDetail(int?id) { if (id == null) { return(NotFound()); } GroupDetailEntity groupDetailEntity = await contenedorTrabajo.Tournament.GetGroupDetailEntity(id.Value); if (groupDetailEntity == null) { return(NotFound()); } GroupDetailViewModel model = contenedorTrabajo.Converter.ToGroupDetailViewModel(groupDetailEntity); return(View(model)); }
public ActionResult UpdateGroup(GroupDetailViewModel model) { var result = new AjaxOperationResult(); var groupSerive = this.Service <IGroupService>(); var groupId = model.Id; var group = groupSerive.FirstOrDefaultActive(p => p.Id == groupId); if (group != null) { group.StartTime = model.StartTime; group.EndTime = model.EndTime; group.PlaceId = model.PlaceId; group.Name = model.Name; group.Description = model.Description; group.SportId = model.SportId; if (model.Days != null) { string[] days = model.Days.Split(','); int repeatDay = 0; for (int i = 0; i < days.Length; i++) { if (days[i].Length > 0) { int mark = 1 << Int16.Parse(days[i]); repeatDay = repeatDay | mark; } } group.AvailableDays = repeatDay; } else { group.AvailableDays = null; } groupSerive.Update(group); groupSerive.Save(); result.Succeed = true; } else { result.Succeed = false; } return(Json(result)); }
public ActionResult EditGroup(int id) { var groupService = this.Service <IGroupService>(); var _sportService = this.Service <ISportService>(); var placeService = this.Service <IPlaceService>(); Group group = groupService.FirstOrDefaultActive(p => p.Id == id); GroupDetailViewModel model = Mapper.Map <GroupDetailViewModel>(group); var sports = _sportService.GetActive() .Select(s => new SelectListItem { Text = s.Name, Value = s.Id.ToString() }).OrderBy(s => s.Value); ViewBag.Sport = sports; var places = placeService.GetActive() .Select(s => new SelectListItem { Text = s.Name, Value = s.Id.ToString() }).OrderBy(s => s.Value); ViewBag.Place = places; var dayOfWeek = new List <int>(); if (model.AvailableDays != null) { var bits = new bool[8]; for (var i = 7; i >= 0; i--) { bits[i] = (model.AvailableDays & (1 << i)) != 0; } for (var j = 1; j < bits.Length; j++) { if (bits[j]) { dayOfWeek.Add(j); } } } ViewBag.availableDayOfWeek = dayOfWeek; return(this.PartialView(model)); }
public async Task <IActionResult> EditGroupDetail(int?id) { if (id == null) { return(NotFound()); } GroupDetailEntity entity = await _context.GroupDetails.Include(t => t.Group) .Include(t => t.Team) .FirstOrDefaultAsync(t => t.Id == id); if (entity == null) { return(NotFound()); } GroupDetailViewModel model = _converter.ToGroupDetailViewModelAsync(entity); return(View(model)); }
// GET: Groups/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Group group = db.Groups.Find(id); GroupDetailViewModel model = new GroupDetailViewModel(); if (group == null) { return(HttpNotFound()); } model.Id = group.ID; //model.IsCreator = group.CreatorID==User.Identity.GetUserId(); model.Name = group.Name; model.Date = group.CreatedDate; model.Members = group.Receviers.Select(g => g.UserName).ToList(); return(View(model)); }
public async Task<IActionResult> AddGroupDetail(int? id) { if (id == null) { return NotFound(); } var groupEntity = await _context.Groups.FindAsync(id); if (groupEntity == null) { return NotFound(); } var model = new GroupDetailViewModel { Group = groupEntity, GroupId = groupEntity.Id, Teams = _combosHelper.GetComboTeams() }; return View(model); }
public ActionResult Edit(string groupId) { if (groupId.IsNullOrWhiteSpace()) { return(View("Error")); } int grpId = Int32.Parse(groupId); // Get the group var groupService = new GroupService(DbContext); var grp = groupService.GetGroupById(grpId); var model = new GroupDetailViewModel() { AdminId = grp.AdminID, GroupId = grp.GroupId, Name = grp.Name, Members = new List <UserViewModel>() }; // Get the members of the group var userService = new UserService(DbContext); var membersOfGroup = groupService.GetMembersOfGroup(grpId); foreach (var id in membersOfGroup) { var currUser = userService.GetUserById(id); if (currUser.Id != User.Identity.GetUserId()) { model.Members.Add(new UserViewModel() { UserId = currUser.Id, Name = currUser.Name }); } } return(View(model)); }
public async Task <IActionResult> AddGroupDetail(int?id) { if (id == null) { return(NotFound()); } GroupEntity groupEntity = await contenedorTrabajo.Tournament.GetGroup(id.Value); if (groupEntity == null) { return(NotFound()); } GroupDetailViewModel model = new GroupDetailViewModel { Group = groupEntity, GroupId = groupEntity.Id, Teams = contenedorTrabajo.Combos.GetComboTeams() }; return(View(model)); }
public async Task <IActionResult> AddGroupDetail(int?id) { if (id == null) { return(NotFound()); } GroupEntity entity = await _context.Groups.FindAsync(id); if (entity == null) { return(NotFound()); } GroupDetailViewModel model = new GroupDetailViewModel { Group = entity, GroupId = entity.Id, Teams = _combo.GetComboTeams() }; return(View(model)); }
/// <summary> /// Admin can view request to be Expert. /// /// Author: Chris Schwebach /// </summary> /// <param name="group"></param> /// <returns></returns> public ActionResult MngExpert() { int userId = RetrieveUserId(); GroupManager grMangr = new GroupManager(); Group grp = grMangr.RetrieveGroupByName(WebConfigurationManager.AppSettings["ExpertGroup"]); int groupId = grp.GroupID; var viewModel = new GroupDetailViewModel(); viewModel.Requests = new List <GroupMemberRequestModel>(); List <GroupRequest> requests = new GroupManager().GetGroupRequests(groupId); foreach (GroupRequest request in requests) { GroupMemberRequestModel requestModel = new GroupMemberRequestModel(); requestModel.Request = request; requestModel.Requestor = new UserManager().GetUser(request.UserID); viewModel.Requests.Add(requestModel); } return(View(viewModel)); }
public ActionResult Index(Guid id) { GroupDto group = readModel.GetGroups().FirstOrDefault(g => g.Id == id); if (group != null) { GroupDetailViewModel model = new GroupDetailViewModel(); model.Name = group.Name; model.Id = group.Id; model.Description = group.Description; model.Users = group.Members; model.Moderators = group.Moderators; model.Photos = group.Photos; model.Albums = group.Albums; model.Privacy = group.Privacy; model.LatestAnnouncement = group.Announcements.OrderByDescending(g => g.Time).FirstOrDefault(); ViewBag.LoggedIn = Session["user"] != null; ViewBag.InGroup = ViewBag.LoggedIn ? model.Users.Any(u => u.Username == ((UserDto)Session["user"]).Username) : false; ViewBag.IsModerator = ViewBag.InGroup ? group.Moderators.Contains(((UserDto)Session["user"])) : false; ViewBag.IsAdmin = ViewBag.InGroup ? group.Admin.Id == ((UserDto)Session["user"]).Id : false; ViewBag.RequestPending = ViewBag.LoggedIn ? group.JoinRequests.Contains(((UserDto)Session["user"])) : false; return View(model); } else return new HttpNotFoundResult(); }