public int Insert()
{
RNGCryptoServiceProvider rng = new RNGCryptoServiceProvider();
byte[] saltbyte = new byte[8];
rng.GetBytes(saltbyte);
string salt = Convert.ToBase64String(saltbyte);
SHA512Managed hashing = new SHA512Managed();
string pwd = Password + salt;
byte[] hashWithSalt = hashing.ComputeHash(Encoding.UTF8.GetBytes(pwd));
string finalHash = Convert.ToBase64String(hashWithSalt);
string DBConnect = ConfigurationManager.ConnectionStrings["MyDB"].ConnectionString;
SqlConnection myConn = new SqlConnection(DBConnect);
string sqlStmt = "INSERT INTO Room (RoomId, RoomPassword, RoomPasswordHash, CRTime, Host, Attendees) \nVALUES (@paraId, @paraPassword, @paraRoomPasswordHash, @paraCRTime, @paraHost, @paraAttendees)";
SqlCommand sqlCmd = new SqlCommand(sqlStmt, myConn);
sqlCmd.Parameters.AddWithValue("@paraId", Id);
sqlCmd.Parameters.AddWithValue("@paraPassword", salt);
sqlCmd.Parameters.AddWithValue("@paraRoomPasswordHash", finalHash);
sqlCmd.Parameters.AddWithValue("@paraCRTime", CRTime);
sqlCmd.Parameters.AddWithValue("@paraHost", Host);
sqlCmd.Parameters.AddWithValue("@paraAttendees", Attendees.ToString());
myConn.Open();
int result = sqlCmd.ExecuteNonQuery();
myConn.Close();
return(result);
}
public SessionAttendee AddAttendeeSession(AddAttendeeAtSession cmd, Seminar seminar)
{
if (Status != SessionStatus.Running)
{
throw new DomainException($"Can't add attendee at {Status} session");
}
var registered = seminar.RegisteredAttendees.Any(x => x.Id == cmd.Id);
if (!registered)
{
throw new DomainException($"Attendee {cmd.Id} not registered at seminar");
}
var attendeeToAdd = new SessionAttendee
{
Id = cmd.Id,
SessionId = cmd.SessionId,
AttendeeStartTime = DateTime.Now,
};
Attendees.Add(attendeeToAdd);
return(attendeeToAdd);
}
public async Task GetAttendees()
{
if (IsBusy)
{
return;
}
try
{
IsBusy = true;
Attendees.Clear();
var items = await AzureMobileService.Instance.GetAttendees();
foreach (var item in items)
{
Attendees.Add(item);
}
}
catch (Exception e)
{
LogHelper.Instance.AddLog(e);
}
finally
{
IsBusy = false;
}
}
public async Task <IActionResult> AddPlayer(int?id, int?TeamId)
{
AppUser user = await CurrentUser;
var TTournament = await _context.Tournament.Include(u => u.Teams)
.ThenInclude(u => u.Attendees)
.FirstOrDefaultAsync(u => u.TournamentId == id.Value);
var teamsTest = TTournament.Teams.FirstOrDefault(u => u.TeamId == TeamId.Value);
var UserInATeam = TTournament.Teams.Any(i => i.Attendees.Any(u => u.UserID == user.Id) == true);
string error = null;
if (!UserInATeam)
{
var Attendee = new Attendees(
"standard",
user.UserName,
user.Id
);
teamsTest.Attendees.Add(Attendee);
_context.SaveChanges();
}
else
{
error = "Error-PlayerIsInTournament";
}
// display message? succes or not?
return(RedirectToAction("Details", new { id = id, error = error }));
}
public Attendance AddAttendance(Member member, AttendanceRegisterType attendanceRegisterType)
{
var attendance = new Attendance(member, this, attendanceRegisterType);
Attendees.Add(attendance);
return(attendance);
}
public IActionResult Join(Attendees NewLink, int evid)
{
NewLink.User = dbContext.Users.FirstOrDefault(u => u.UserId == HttpContext.Session.GetInt32("Validator"));
NewLink.Event = dbContext.Events
.Include(attn => attn.Attendees).ThenInclude(at => at.User)
.FirstOrDefault(e => e.EventId == evid);
Console.WriteLine(ModelState.IsValid);
if (ModelState.IsValid)
{
if (
!NewLink.Event.Attendees
.Any(u => u.UserId == NewLink.User.UserId)
)
{
Attendees somenewAttendee = new Attendees()
{
UserId = NewLink.User.UserId,
EventId = evid,
User = NewLink.User,
Event = NewLink.Event
};
dbContext.UserEventLinks.Add(somenewAttendee);
dbContext.SaveChanges();
}
}
return(RedirectToAction("ViewEvent", new{ SpecificEvent = NewLink.Event, eventId = evid }));
}
private async Task GetAttendees(LessonInfo selectedLessonInfo)
{
ResponseResult attendeesResult =
await _bmsService.GetUsersByLessonId(selectedLessonInfo.Id.ToString());
if (!HasErrorMsg(attendeesResult.Status, attendeesResult.Message))
{
List <UserInfo> attendees = attendeesResult.Data as List <UserInfo>;
if (attendees != null)
{
List <UserInfo> globalUserInfos = IoC.Get <List <UserInfo> >();
globalUserInfos.Clear();
Attendees.Clear();
attendees.ForEach(attendee =>
{
Attendees.Add(attendee);
globalUserInfos.Add(attendee);
});
AttendeesCount = string.Format($"(共{Attendees.Count}人)");
var masterUser =
Attendees.FirstOrDefault(userInfo => userInfo.UserId == CurLessonDetail?.MasterUserId);
if (masterUser != null)
{
masterUser.IsTeacher = true;
}
}
}
}
public ActionResult DeleteConfirmed(int id)
{
Attendees attendees = db.Attendees.Find(id);
db.Attendees.Remove(attendees);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public bool IsUserAttending(string userId)
{
if (Attendees == null || Attendees.Count <= 0)
{
return(false);
}
return(Attendees.Any(x => x.UserId == userId));
}
public bool Register(Student attendee)
{
if (Attendees.Contains(attendee))
{
return(false);
}
Attendees.Add(attendee);
return(true);
}
public SessionDTO SessionResponse()
=> new SessionDTO
{
Title = Title,
Description = Description,
Attendees = Attendees.Select(a => new AttendeeDTO
{
UserName = a.Attendee.UserName, EmailAddress = a.Attendee.EmailAddress
})
};
public AttendeesViewModel(Attendees attendees)
{
_attendees = attendees;
UpdateMinutes = new List <int> {
1, 2, 3, 5, 10, 15, 20, 30, 60
};
_selectedUpdateMin = attendees.UpdateMinutes;
_selectedBackColor = attendees.BackColor;
}
public ActionResult Edit([Bind(Include = "AttendeeId,SignUpDateTime,FirstName,LastName,Email,ContactNumber")] Attendees attendees)
{
if (ModelState.IsValid)
{
db.Entry(attendees).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(attendees));
}
public void SeatHostHimself()
{
var host = new Attendee("Host");
foreach (var seatedAttendee in Attendees)
{
host.PotencialHapinnes.Add(seatedAttendee.Name, 0);
seatedAttendee.PotencialHapinnes.Add("Host", 0);
}
Attendees.Add(host);
}
public Attendance AddSpeaker(Member member)
{
var memberCheck = Attendees.FirstOrDefault(x => x.MemberId == member.Id);
if (memberCheck == null)
{
memberCheck = AddAttendance(member, AttendanceRegisterType.CurrentEvent);
}
memberCheck.SetSpeaker();
return(memberCheck);
}
public ActionResult Create([Bind(Include = "AttendeeId,SignUpDateTime,FirstName,LastName,Email,ContactNumber")] Attendees attendees)
{
if (ModelState.IsValid)
{
attendees.SignUpDateTime = DateTime.Now;
db.Attendees.Add(attendees);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(attendees));
}
public IActionResult UNRVSP(int Id)
{
int curId = (int)HttpContext.Session.GetInt32("user_id");
Attendees thisAttendant = _context.attendees.SingleOrDefault(x => x.Wedding_Id == Id && x.User_Id == curId);
if (thisAttendant != null)
{
_context.attendees.Remove(thisAttendant);
_context.SaveChanges();
}
return(RedirectToAction("Dashboard"));
}
public ActionResult Add([FromBody] Attendees a)
{
try
{
rep.Insert(a);
return(Ok());
}
catch (Exception)
{
throw;
}
}
public ActionResult Edit([Bind(Include = "AttendeesId,MeetingId,PersonId")] Attendees attendees)
{
if (ModelState.IsValid)
{
_db.Entry(attendees).State = EntityState.Modified;
_db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MeetingId = new SelectList(_db.Meetings, "MeetingId", "MeetingDescription", attendees.MeetingId);
ViewBag.PersonId = new SelectList(_db.Persons, "PersonId", "FirstName", attendees.PersonId);
return(View(attendees));
}
private void addAttendeeButton_Click(object sender, EventArgs e)
{
TextBox attendeeEmailTextBox = new TextBox();
Label attendeeLabel = new Label();
ComboBox rsvpComboBox = new ComboBox();
Button deleteAttendeeButton = new Button();
GroupBox attendeeGroupBox = new GroupBox();
if (attendeePanel.Controls.Count <= 5)
{
attendeeGroupBox.Size = new Size(attendeePanel.Width, 50);
attendeeGroupBox.Name = "attendeeGroupBox" + numOfAttendees.ToString();
attendeeLabel.Location = new Point(25, attendeeGroupBox.Size.Height / 2);
attendeeLabel.Text = "Email: ";
attendeeLabel.Name = "attendeeLabel" + numOfAttendees.ToString();
attendeeLabel.Size = new Size(50, 21);
attendeeEmailTextBox.Location = new Point(attendeeLabel.Right, attendeeGroupBox.Size.Height / 2);
attendeeEmailTextBox.Name = "attendeeEmailTextbox" + numOfAttendees.ToString();
List <string> rsvp = new List <string>()
{
"False", "True"
};
rsvpComboBox.DataSource = rsvp;
rsvpComboBox.Location = new Point(attendeeEmailTextBox.Location.X + 105, attendeeGroupBox.Size.Height / 2);
rsvpComboBox.Name = "rsvpComboBox" + numOfAttendees.ToString();
rsvpComboBox.Size = new Size(60, 21);
deleteAttendeeButton.Text = "Delete";
deleteAttendeeButton.Location = new Point(rsvpComboBox.Right + 4, attendeeGroupBox.Size.Height / 2);
deleteAttendeeButton.Name = "deleteAttendeeButton" + numOfAttendees.ToString();
deleteAttendeeButton.Size = new Size(46, 23);
Attendees.Add(attendeeEmailTextBox);
AttendeesRsvp.Add(rsvpComboBox);
numOfAttendees++;
attendeeGroupBox.Controls.Add(attendeeLabel);
attendeeGroupBox.Controls.Add(attendeeEmailTextBox);
attendeeGroupBox.Controls.Add(rsvpComboBox);
attendeeGroupBox.Controls.Add(deleteAttendeeButton);
attendeePanel.Controls.Add(attendeeGroupBox);
RepositionAttendees();
deleteAttendeeButton.Click += new EventHandler(deleteAttendeeButton_Click);
}
}
public async Task RemoveScheduleAsync(SessionPlace sessionPlace)
{
foreach (var attendee in await Attendees.EnsureAsync())
{
foreach (var schedule in await attendee.CurrentSchedules.EnsureAsync())
{
if (schedule.SessionPlace == sessionPlace)
{
await Community.AddFactAsync(new ScheduleRemove(schedule));
}
}
}
}
public override CalendarPrototype Clone()
{
var copy = (CalendarEvent)base.Clone();
// this allows us have another list, but same attendees there
var copiedAttendees = (Attendee[])Attendees.Clone();
copy.Attendees = copiedAttendees;
// we also would like to copy priority
copy.Priority = (Priority)Priority.Clone();
return(copy);
}
public IActionResult RVSP(int Id)
{
int curId = (int)HttpContext.Session.GetInt32("user_id");
Wedding thisWed = _context.wedding.Include(x => x.Attendee).ThenInclude(x => x.user).SingleOrDefault(x => x.Id == Id);
Attendees newAttendant = new Attendees()
{
User_Id = curId,
Wedding_Id = Id
};
_context.attendees.Add(newAttendant);
_context.SaveChanges();
return(RedirectToAction("Dashboard"));
}
// GET: Attendees/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Attendees attendees = db.Attendees.Find(id);
if (attendees == null)
{
return(HttpNotFound());
}
return(View(attendees));
}
public Attendance Attended(Member member, AttendanceRegisterType attendanceRegisterType)
{
var memberCheck = Attendees.FirstOrDefault(x => x.MemberId == member.Id);
if (memberCheck != null)
{
memberCheck.Attend();
}
else
{
memberCheck = AddAttendance(member, attendanceRegisterType);
memberCheck.Attend();
}
return(memberCheck);
}
public ActionResult ClockOut(Attendees attendees)
{
if (attendees.CurrentAttendance != null)
{
foreach (var attendee in attendees.CurrentAttendance.Where(a => a.Selected))
{
// Clock out
var attendance = context.Attendances.FirstOrDefault(a => a.Id == attendee.Id && !a.EndDateTime.HasValue);
attendance.EndDateTime = DateTime.Now;
}
context.SaveChanges();
}
return(RedirectToAction("Index"));
}
public async Task <IActionResult> OnGet()
{
Attendees = await _apiClient.GetAllAttendeesAsync();
if (Attendees == null)
{
return(NotFound());
}
Conferences = (await _apiClient.GetAllConferencesAsync())
.Where(c => Attendees.SelectMany(a => a.Sessions)
.Any(s => s.ConferenceId == c.ID));
return(Page());
}
private void AddAttendee(object obj)
{
var user = new User {
Id = Id, Name = Name, MailID = MailID
};
if (_meetingManager.Add(user))
{
Attendees.Add(user);
}
else
{
MessageBox.Show("Attendee already present");
}
}
private void AddFromFile_Clicked(object sender, RoutedEventArgs e)
{
Attendees attendees = new Attendees();
OpenFileDialog openFileDialog = new OpenFileDialog();
openFileDialog.Filter = "CSV files (*.csv)|*.csv| All files(*.*)|*.*";
openFileDialog.InitialDirectory = @"D:\projects\ConferenceSolution\ConferenceProgram\bin\Debug\netcoreapp3.1\Data";
//openFileDialog.ShowDialog();
MessageBox.Show(openFileDialog.FileName.ToString());
if (openFileDialog.ShowDialog() == true)
{
attendees.ReadFromFile(openFileDialog.FileName);
MessageBox.Show("file succesfully");
}
}
public override CalendarProptotype Clone()
{
var copy = (CalendarEvent)base.Clone();
// це дозволить нам мати список із посиланнями на тих же відвідувачів
var copiedAttendees = (Attendee[])Attendees.Clone();
copy.Attendees = copiedAttendees;
//copy.Attendees = copiedAttendees;
// Також скопіюємо приоритет
//. ....
copy.Priority = Priority.Clone();
return(copy);
}
