public MeetingModel GetMeetingInfo(long meetingId)
{
var meetingInfo = new MeetingModel();
using (var db = new DBCommand("GetICMeetingsById"))
{
db.AddParameter("@meetingId", meetingId);
var ds = db.ExecuteDataSet().Tables[0];
if (ds.Rows.Count > 0)
{
foreach (System.Data.DataRow r in ds.Rows)
{
meetingInfo.MeetingId = r["MeetingId"].ToLng();
meetingInfo.MeetingDate = r["MeetingDate"].ToShortDateFormatEx();
meetingInfo.MeetingDocLocation = r["MeetingDocLocation"].ToString();
meetingInfo.MeetingStartAt3PM = r["MeetingStartAt3PM"].ToBool();
meetingInfo.MeetingStartTime = r["MeetingStartTime"].ToString();
meetingInfo.MeetingEndTime = r["MeetingEndTime"].ToString();
meetingInfo.OrigNotes1PageInLength = r["OriginalNotes1PageInLength"].ToBool();
meetingInfo.OrigLengthOfNotes = r["OriginalLengthOfNotes"].ToIntEx();
meetingInfo.FinalLengthOfNotes = r["FinalLengthOfNotes"].ToIntEx();
meetingInfo.IsLocked = r["IsLocked"].ToBool();
}
meetingInfo.MeetingAttributes = GetMeetignAttributes(meetingId);
}
}
return(meetingInfo);
}
public async Task <IActionResult> Edit(int id, [Bind("Id,Title,Notes,Start,End")] MeetingModel meetingModel)
{
if (id != meetingModel.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(meetingModel);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!MeetingModelExists(meetingModel.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(meetingModel));
}
public ActionResult iPad(int?id)
{
if (!id.HasValue)
{
return(RedirectShowError("no id"));
}
var m = new MeetingModel(id.Value);
m.showall = true;
if (m.meeting == null)
{
return(RedirectShowError("no meeting"));
}
if (Util2.OrgMembersOnly &&
!DbUtil.Db.OrganizationMembers.Any(om =>
om.OrganizationId == m.meeting.OrganizationId &&
om.PeopleId == Util.UserPeopleId))
{
return(RedirectShowError("You must be a member of this organization to have access to this page"));
}
else if (Util2.OrgLeadersOnly &&
!DbUtil.Db.OrganizationMembers.Any(om =>
om.OrganizationId == m.meeting.OrganizationId &&
om.PeopleId == Util.UserPeopleId &&
om.MemberType.AttendanceTypeId == CmsData.Codes.AttendTypeCode.Leader))
{
return(RedirectShowError("You must be a leader of this organization to have access to this page"));
}
DbUtil.LogActivity("iPad Meeting for {0}({1:d})".Fmt(m.meeting.OrganizationId, m.meeting.MeetingDate));
return(View(m));
}
public ActionResult iPad(int?id, bool?commitsOnly)
{
if (!id.HasValue)
{
return(RedirectShowError("no id"));
}
var m = new MeetingModel(id.Value, CurrentDatabase);
m.showall = true;
m.CommitsOnly = commitsOnly == true;
if (m.meeting == null)
{
return(RedirectShowError("no meeting"));
}
if (Util2.OrgLeadersOnly &&
!CurrentDatabase.OrganizationMembers.Any(om =>
om.OrganizationId == m.meeting.OrganizationId &&
om.PeopleId == Util.UserPeopleId &&
om.MemberType.AttendanceTypeId == AttendTypeCode.Leader))
{
return(RedirectShowError("You must be a leader of this organization to have access to this page"));
}
DbUtil.LogActivity($"iPad Meeting for {m.meeting.OrganizationId}({m.meeting.MeetingDate:d})");
return(View(m));
}
public async Task <ActionResult <MeetingModel> > Put(string id, [FromBody] Meeting meeting)
{
var meetingModel = await _meetingRepository.GetMeeting(id);
if (meetingModel == null)
{
return(new NotFoundResult());
}
var newMeetingModel = new MeetingModel {
Title = meeting.Title,
Description = meeting.Description,
EventDateTime = meeting.EventDateTime.Value,
Location = meeting.Location,
AttendeeLimit = meeting.AttendeeLimit
};
var updatedMeetingModel = await _meetingRepository.UpdateMeeting(id, newMeetingModel);
var updatedMeeting = new Meeting {
Title = updatedMeetingModel.Title,
Description = updatedMeetingModel.Description,
EventDateTime = updatedMeetingModel.EventDateTime,
Location = updatedMeetingModel.Location,
AttendeeLimit = updatedMeetingModel.AttendeeLimit
};
return(new OkObjectResult(updatedMeeting));
}
public ActionResult CheckInAttendance(int?id, bool?currentMembers)
{
if (!id.HasValue)
{
return(RedirectShowError("no id"));
}
var m = new MeetingModel(id.Value)
{
currmembers = currentMembers ?? false
};
m.showall = true;
if (m.meeting == null)
{
return(RedirectShowError("no meeting"));
}
if (Util2.OrgLeadersOnly &&
!DbUtil.Db.OrganizationMembers.Any(om =>
om.OrganizationId == m.meeting.OrganizationId &&
om.PeopleId == Util.UserPeopleId &&
om.MemberType.AttendanceTypeId == AttendTypeCode.Leader))
{
return(RedirectShowError("You must be a leader of this organization to have access to this page"));
}
DbUtil.LogActivity($"CheckIn attendance for Meeting for {m.meeting.OrganizationId}({m.meeting.MeetingDate:d})");
return(View(m));
}
public ActionResult AddMeeting(MeetingModel model)
{
NameMeetingEvent meeting = new NameMeetingEvent
{
NameEvent = model.NameEvent
};
_context.MeetingEvents.Add(meeting);
_context.SaveChanges();
int a = _context.MeetingEvents.Count();
if (model.HeaderEvent.Count() > 0 && model.NameEvent.Count() > 0)
{
for (int i = 0; i < model.HeaderEvent.Count; i++)
{
MeetingInformation information = new MeetingInformation
{
MeetingID = _context.MeetingEvents.Count(),
Header = model.HeaderEvent[i],
Context = model.ContextEvent[i]
};
_context.MeetingInformations.Add(information);
_context.SaveChanges();
}
}
return(RedirectToAction("GetAllMeeting"));
}
public IActionResult PushAddMeetingToDB(long meetingTypeId, string title, DateTime datestart, DateTime?dateend, TimeSpan hourStart, TimeSpan?hourEnd, long?roomId, string location, string note, long priorityId, string newIdMembers)
{
// TODO
string[] newMembers = new string[0];
if (newIdMembers != null)
{
newMembers = newIdMembers.Split(",");
}
List <EmployeeModel> all = EmployeeController.GetAllEmployees();
List <EmployeeModel> members = new List <EmployeeModel>();
foreach (EmployeeModel employee in all)
{
foreach (string newM in newMembers)
{
if (!string.IsNullOrEmpty(newM))
{
if (employee.Id == long.Parse(newM))
{
members.Add(employee);
}
}
}
}
MeetingModel meetingModel = new MeetingModel(0, meetingTypeId, datestart, dateend, hourStart, hourEnd, HomeController.ActualUser.Id, roomId, location, note, priorityId, title, members);
MeetingDAO.Insert(meetingModel);
return(RedirectToAction("MainPage", "Home"));
}
private void Validate(MeetingModel model)
{
if (model != null && model.DateTime >= model.DueDateTime)
{
ModelState.AddModelError(nameof(model.DueDateTime), "Due date should be greater than Date field");
}
}
public ActionResult Create()
{
ViewData["created"] = false;
var emptyModel = new MeetingModel();
return(PartialView("Diary/Meeting/CreateForm", emptyModel));
}
private void SendEmail_ScheduleMeeting(MeetingModel m, string recipientAddress, string firstName, string lastName)
{
//Using a StringBuilder is much more memory efficient than repeated concatenation.
StringBuilder body = new StringBuilder();
string subject = "New meeting scheduled";
body.AppendLine("<h1>You have a new meeting</h1>");
body.AppendLine("<p>Secheduled with ");
body.AppendLine(firstName);
body.AppendLine(" ");
body.AppendLine(lastName);
body.AppendLine(", on ");
body.AppendLine(m.MeetingDate.DayOfWeek.ToString());
body.AppendLine(" (");
body.AppendLine(m.MeetingDate.ToShortDateString());
body.AppendLine(") at ");
body.AppendLine(m.MeetingTime.ToString().Substring(0, 5));
body.AppendLine(" lasting ");
body.AppendLine(m.MeetingLength.ToString());
body.AppendLine(" minutes.</p>");
body.AppendLine("<br />");
body.AppendLine("<p>Excited to see you there!</p>");
body.AppendLine("<p>~SecureLine</p>");
EmailLogic.SendEmail(recipientAddress, subject, body.ToString());
}
public void sendMeeting(string text)
{
if (!string.IsNullOrWhiteSpace(text))
{
var invite = new MeetingModel
{
//Sender = sender,
Confirmed = false,
Text = text
};
var meetingRepository = new MeetingRepository();
meetingRepository.sendMeeting(invite.MapToMeeting());
//int id = meetRep.sendMeeting(invite.MapToMeeting());
//var test = mjau(receiver);
//int k;
//k = test.Length;
//for (int s = 0; s < test.Length; s++)
//{
// var blog_kat = new Category_Blog
// {
// CategoryId = test[s],
// BlogId = id
// };
//cb_rep.Add(blog_kat);
}
;
}
public async Task <IHttpActionResult> Post(MeetingModel model)
{
try
{
if (ModelState.IsValid)
{
model.Attendees.All(t =>
{
model.Meeting_Attendees_Map.Add(new Meeting_Attendees_MapModel {
AttendeeId = t
});
return(true);
});
var meeting = _mapper.Map <Meeting>(model);
_repository.AddMeeting(meeting);
if (await _repository.SaveChangesAsync())
{
var newModel = _mapper.Map <MeetingModel>(meeting);
return(Ok(newModel));
}
}
return(BadRequest(ModelState));
}
catch (Exception ex)
{
return(InternalServerError(ex));
}
}
public async Task <IHttpActionResult> Put(int id, MeetingModel model)
{
try
{
var meeting = await _repository.GetMeetingAsync(id);
if (meeting == null)
{
return(NotFound());
}
_mapper.Map(model, meeting);
if (await _repository.SaveChangesAsync())
{
return(Ok(_mapper.Map <MeetingModel>(meeting)));
}
else
{
return(InternalServerError());
}
}
catch (Exception ex)
{
return(InternalServerError(ex));
}
}
/// <summary>
/// Создание нового совещания.
/// </summary>
/// <param name="user">Организатор совещания</param>
/// <param name="meetingViewModel">Данные о совещании, возвращенные из представления</param>
/// <returns>Модель совещания, готовая для сохранения в базу данных</returns>
public MeetingModel New(string user, MeetingViewModel meetingViewModel)
{
DateTime now = DateTime.Now;
var notRegisteredParticipants = meetingViewModel.NotRegisteredParticipants;
var participants = new List <string>();
if (notRegisteredParticipants != null)
{
if (meetingViewModel.Participants != null)
{
meetingViewModel.Participants.AddRange(notRegisteredParticipants);
participants = meetingViewModel.Participants;
}
else
{
participants = notRegisteredParticipants;
}
}
else
{
participants = meetingViewModel.Participants;
}
MeetingModel meeting = new MeetingModel
{
Organizer = user,
Topic = meetingViewModel.Topic,
Participants = participants.Aggregate((a, b) => a + ", " + b),
StartTime = now,
LastRegisteredTime = now
};
return(meeting);
}
public ActionResult Index(int id, bool?showall, bool?sortbyname, bool?CurrentMembers, bool?showlarge)
{
var m = new MeetingModel(id)
{
currmembers = CurrentMembers ?? false,
showall = showall == true,
sortbyname = sortbyname == true,
showlarge = showlarge ?? false
};
if (m.meeting == null)
{
return(RedirectShowError("no meeting"));
}
if (Util2.OrgLeadersOnly)
{
var oids = DbUtil.Db.GetLeaderOrgIds(Util.UserPeopleId);
if (!oids.Contains(m.org.OrganizationId))
{
return(NotAllowed("You must be a leader of this organization", m.org.OrganizationName));
}
}
if (m.org.LimitToRole.HasValue())
{
if (!User.IsInRole(m.org.LimitToRole))
{
return(NotAllowed("no privilege to view ", m.org.OrganizationName));
}
}
DbUtil.LogActivity($"Viewing Meeting for {m.meeting.Organization.OrganizationName}");
return(View(m));
}
public async Task <ActionResult> Create([Bind(Include = "MeetingId,Name,Description")] MeetingModel meetingModel)
{
if (ModelState.IsValid)
{
if (this.User.Identity.GetUserId() != null)
{
IOwinContext context = this.HttpContext.GetOwinContext();
var UserManager = context.GetUserManager <ApplicationUserManager>();
ApplicationUser currentUser = UserManager.FindById(User.Identity.GetUserId());
//System.Web.HttpContext.Current.GetOwinContext().GetUserManager<ApplicationUserManager>().FindById(System.Web.HttpContext.Current.User.Identity.GetUserId());
meetingModel.Owner = currentUser;
}
else
{
throw new System.Exception("Nie JEsteś zalogowany");
}
db.MeetingModels.Add(meetingModel);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(meetingModel));
}
public MeetingViewModel(DateTime meetingDate, string meetingTemplate, ObservableCollection <MemberModel> members)
{
DayOfMeeting = meetingDate;
_template = meetingTemplate;
_members = members;
meetingModel = new MeetingModel();
}
public ContentResult Edit(string id, string value)
{
try
{
var i = id.Substring(2).ToInt();
var m = new MeetingModel(i);
switch (id[0])
{
case 'd':
m.meeting.Description = value;
break;
case 'h':
m.meeting.HeadCount = value.ToInt();
break;
case 't':
DbUtil.Db.ExecuteCommand(@"
update dbo.Attend set MeetingDate = {0} where MeetingId = {1};
update dbo.Meetings set MeetingDate = {0} where MeetingId = {1};
", value.ToDate(), m.meeting.MeetingId);
break;
}
DbUtil.Db.SubmitChanges();
return(Content(value));
}
catch (Exception ex)
{
return(Content("error: " + ex.Message));
}
}
// GET: Meeting/AddAttendee
public ActionResult AddAttendee()
{
MeetingModel meetingModel = (MeetingModel)Session["Meeting"];
if (meetingModel != null)
{
IQueryable <UserModel> users = db.Users.Where(a => a.IsActive == true);
List <UserDTO> userList = new List <UserDTO>();
Mapper.Initialize(cfg => cfg.CreateMap <UserModel, UserDTO>());
foreach (UserModel um in users)
{
um.Department = null;
UserDTO newDto = Mapper.Map <UserDTO>(um);
userList.Add(newDto);
}
userList = userList.OrderBy(u => u.Name).ToList();
IQueryable <DepartmentModel> departments = db.Departments.OrderBy(u => u.Name);
string userjson = JsonConvert.SerializeObject(userList);
string deptjson = JsonConvert.SerializeObject(departments.ToList());
ViewBag.Users = userjson;
ViewBag.Departments = deptjson;
return(View());
}
else
{
return(RedirectToAction("Create"));
}
}
private void sendNotification(MeetingModel mm, List <int> userList, string creatorID)
{
try
{
string Title = "New Event";
string message = mm.Title;
foreach (var id in userList)
{
UserModel user = db.Users.Find(id);
if (user != null)
{
string tokenID = user.TokenID.Trim();
tokenID = tokenID.Replace(" ", "");
BLNotification.PushNotification(tokenID, message, "", Title, "");
Log.Error("Notification", context.STR_USER, "userid= " + id + " token id:" + tokenID + " message:" + message + " Title:" + Title);
}
}
//send to creator
var creator = db.Users.Where(c => c.Username == creatorID).FirstOrDefault();
if (creator != null)
{
string tokenID = creator.TokenID.Trim();
tokenID = tokenID.Replace(" ", "");
BLNotification.PushNotification(tokenID, message, "", Title, "");
}
}
catch (Exception ex)
{
Log.Error("Notification", context.STR_USER, "sendNotification", ex);
}
}
public RootDialog(ILocationService locationService, IAuthProvider authProvider)
{
this.locationService = locationService;
this.authProvider = authProvider;
meetingModel = new MeetingModel();
}
private void AssertThatTheCurrentQuestionHasChanged(MeetingModel meeting)
{
MeetingModel meetingModel = meetingAppService.GetMeeting(meeting.Id, facilitatorId);
Assert.False(meetingModel.Questions.ElementAt(0).IsTheCurrent);
Assert.True(meetingModel.Questions.ElementAt(1).IsTheCurrent);
}
public ActionResult GetMeetingsByIds(string ids)
{
JavaScriptSerializer jser = new JavaScriptSerializer();
MeetingModel metModel = new MeetingModel();
int[] idList = jser.Deserialize <int[]>(ids);
UserModel userModel = new UserModel();
user_info userInfo = userModel.GetUserInfo(User.Identity.Name);
List <meeting_info_detail> source = metModel.GetMeetingsDetail(idList).ToList();
var result = source.OrderBy(r => r.mi_start_time).Select(r => new
{
id = r.id,
title = r.mi_title,
start = r.mi_start_time.ToString("yyyy-MM-ddTHH:mm:ss"),
end = r.mi_end_time.ToString("yyyy-MM-ddTHH:mm:ss"),
people = r.mi_people,
memo = r.mi_memo,
position = r.mi_position_id,
creator = r.mi_creator_name,
level = r.mi_level_id,
createTime = r.mi_create_time.ToString("yyyy-MM-ddTHH:mm:ss"),
className = r.mi_creator == userInfo.id ? "fc-event-mine" : "",
editable = r.mi_creator == userInfo.id || userInfo.user_grade_catg.gc_level == 9 ? 1 : 0,
isMine = r.mi_creator == userInfo.id ? 1 : 0
});
return(Json(result, JsonRequestBehavior.AllowGet));
}
public async Task ThenIShouldNotBeTheFacilitator()
{
string content = await context.HttpResponse.Content.ReadAsStringAsync();
MeetingModel meeting = JsonConvert.DeserializeObject <MeetingModel>(content);
Assert.False(meeting.userIsTheFacilitator);
}
public ActionResult MeetingHome()
{
session = new SessionHelper();
MeetingModel objMeetingModel = new MeetingModel();
objMeetingModel.meetings = objMeetingManager.getAllMeetings(Convert.ToInt64(session.UserSession.PIN));
return(View(objMeetingModel));
}
public ActionResult MeetingGrid(int id, bool future)
{
var m = new MeetingModel(id, future);
UpdateModel(m.Pager);
DbUtil.LogActivity("Viewing Meetings for {0}".Fmt(Session["ActiveOrganization"]));
return(View(m));
}
public ActionResult GetMeetingPositions()
{
MeetingModel metModel = new MeetingModel();
List <meeting_position> source = metModel.GetMeetingPositions().ToList();
var result = source.Select(r => new { value = r.id, text = r.mp_name });
return(Json(result, JsonRequestBehavior.AllowGet));
}
public async Task ThenTheCreatedMeetingShouldHasAnId()
{
string content = await context.HttpResponse.Content.ReadAsStringAsync();
MeetingModel meeting = JsonConvert.DeserializeObject <MeetingModel>(content);
Assert.That(meeting.id, Is.Not.EqualTo(Guid.Empty));
}
private void AssertThatTheAnswerWasContabilized(MeetingModel meeting)
{
MeetingModel meetingModel = meetingAppService.GetMeeting(meeting.Id, facilitatorId);
Assert.That(meetingModel.Questions.First().AmountOfGreenAnswers, Is.EqualTo(1));
Assert.That(meetingModel.Questions.First().AmountOfYellowAnswers, Is.EqualTo(1));
Assert.That(meetingModel.Questions.First().AmountOfRedAnswers, Is.EqualTo(1));
}
