public ActionResult RecordAttend(int id, int peopleId, bool present) { if (!Authenticate()) { return(Content("not authorized")); } DbUtil.LogActivity($"iphone attend(mt:{id} person:{peopleId} {present})"); Attend.RecordAttendance(peopleId, id, present); CurrentDatabase.UpdateMeetingCounters(id); return(new EmptyResult()); }
public ActionResult RecordVisit(int id, int peopleId) { if (!Authenticate()) { return(Content("not authorized")); } Attend.RecordAttendance(peopleId, id, true); DbUtil.Db.UpdateMeetingCounters(id); var meeting = DbUtil.Db.Meetings.Single(mm => mm.MeetingId == id); return(new RollListResult(meeting)); }
public ActionResult MarkRegistered(int PeopleId, int MeetingId, int?CommitId) { try { Attend.MarkRegistered(CurrentDatabase, PeopleId, MeetingId, CommitId); } catch (Exception ex) { return(Content(ex.Message)); } return(new EmptyResult()); }
public ActionResult RsvpForm([Bind(Include = "CId,Name,CEmail,CPhone,Status")] Attend attend) { if (string.IsNullOrEmpty(attend.Name)) { ModelState.AddModelError("Name", "Please enter Name"); } if (!string.IsNullOrEmpty(attend.CEmail)) { string emailRegex = @"^([a-zA-Z0-9_\-\.]+)@((\[[0-9]{1,3}" + @"\.[0-9]{1,3}\.[0-9]{1,3}\.)|(([a-zA-Z0-9\-]+\" + @".)+))([a-zA-Z]{2,4}|[0-9]{1,3})(\]?)$"; Regex re = new Regex(emailRegex); if (!re.IsMatch(attend.CEmail)) { ModelState.AddModelError("CEmail", "Email is not valid"); } } else { ModelState.AddModelError("CEmail", "Email is required"); } if (!string.IsNullOrEmpty(attend.CPhone)) { string phoneRegex = @"^\(?([0-9]{3})\)?[-. ]?([0-9]{3})[-. ]?([0-9]{4})$"; Regex re = new Regex(phoneRegex); if (!re.IsMatch(attend.CPhone)) { ModelState.AddModelError("CPhone", "Mobile No. is not valid"); } } else { ModelState.AddModelError("CPhone", "Mobile No. is required"); } //if (string.IsNullOrEmpty(attend.CPhone)) //{ // ModelState.AddModelError("CPhone", "Please enter Phone"); //} if (ModelState.IsValid) { db.Attends.Add(attend); db.SaveChanges(); return(RedirectToAction("Example")); } else { return(View()); } }
public ActionResult MarkRegistered(int meetingid, int peopleid, int?CommitId) { var ret = AuthenticateDeveloper(); if (ret.StartsWith("!")) { return(Content(ret.Substring(1))); } DbUtil.LogActivity($"APIMeeting MarkRegistered {meetingid}, {peopleid}"); Attend.MarkRegistered(CurrentDatabase, peopleid, meetingid, CommitId); return(Content("ok")); }
public async Task <IHttpActionResult> GetAttend(int id, int Classroom_Id) { Attend attend = await db.Attends .Where((a) => a.Cls_Id == Classroom_Id && a.Att_Id == id) .FirstOrDefaultAsync(); if (attend == null) { return(NotFound()); } return(Ok(attend)); }
public ContentResult RecordAttend2(int PeopleId, int OrgId, bool Present, DateTime hour, string kiosk) { if (!Authenticate()) { return(Content("not authorized")); } DbUtil.LogActivity($"checkin {PeopleId}, {OrgId}, {(Present ? "attend" : "unattend")}"); Attend.RecordAttend(DbUtil.Db, PeopleId, OrgId, Present, hour); var r = new ContentResult(); r.Content = "success"; return(r); }
// GET: Attends/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Attend attend = db.Attends.Find(id); if (attend == null) { return(HttpNotFound()); } return(View(attend)); }
//onclick for lvStudents //needs some control protected void lvSelectBtn_Click(object sender, EventArgs e) { Button btn = (Button)sender; int StuID = Convert.ToInt32(btn.Attributes["CustomProp"]); int ClassID = Convert.ToInt32(Session["ClassID"]); Attend item = new Attend(); item.Stu_ID = StuID; item.Class_ID = ClassID; item.Att_Interactions = 0; db.Attends.Add(item); db.SaveChanges(); grdAttend.DataBind(); }
public ContentResult EditCommitment(string id, string value) { var a = id.Substring(1).Split('_').Select(vv => vv.ToInt()).ToArray(); var c = value.ToInt2(); if (c == 99) { c = null; } Attend.MarkRegistered(DbUtil.Db, a[1], a[0], c); var desc = CmsData.Codes.AttendCommitmentCode.Lookup(c ?? 99); return(Content(desc)); }
public ActionResult Create(Attend attend) { using (SqlConnection sqlcon = new SqlConnection(connectionString)) { sqlcon.Open(); string query = "INSERT INTO Attend VALUES (@Name,@Date,@Attendance)"; SqlCommand sqlcmd = new SqlCommand(query, sqlcon); sqlcmd.Parameters.AddWithValue("@Name", attend.Name); sqlcmd.Parameters.AddWithValue("@Date", attend.Date); sqlcmd.Parameters.AddWithValue("@Attendance", attend.Attendance); sqlcmd.ExecuteNonQuery(); } return(RedirectToAction("Index")); }
public void RecordAttend(int PeopleId, int OrgId, bool Present, int thisday) { var db = CurrentDatabase; var q = from o in db.Organizations where o.OrganizationId == OrgId let p = db.People.Single(pp => pp.PeopleId == PeopleId) select new { MeetingId = db.GetTodaysMeetingId(OrgId, thisday), MeetingTime = db.GetTodaysMeetingHours(OrgId, thisday).First().Hour, o.Location, OrgEntryPoint = o.EntryPointId, p.EntryPointId }; var info = q.Single(); var meeting = db.Meetings.SingleOrDefault(m => m.MeetingId == info.MeetingId); if (info.EntryPointId == null) { var p = db.LoadPersonById(PeopleId); if (info.OrgEntryPoint > 0) { p.EntryPointId = info.OrgEntryPoint; } } if (meeting == null) { var acr = (from s in db.OrgSchedules where s.OrganizationId == OrgId where s.SchedTime.Value.TimeOfDay == info.MeetingTime.Value.TimeOfDay where s.SchedDay == thisday select s.AttendCreditId).SingleOrDefault(); meeting = new Meeting { OrganizationId = OrgId, MeetingDate = info.MeetingTime, CreatedDate = Util.Now, CreatedBy = CurrentDatabase.UserId1, GroupMeetingFlag = false, Location = info.Location, AttendCreditId = acr, NoAutoAbsents = !db.Setting("AttendanceAutoAbsents") }; db.Meetings.InsertOnSubmit(meeting); db.SubmitChanges(); } Attend.RecordAttendance(PeopleId, meeting.MeetingId, Present); db.UpdateMeetingCounters(meeting.MeetingId); }
public async Task <IActionResult> Create(int guestReservationId, List <Gift> gifts) { if (ModelState.IsValid) { var allGifts = await _repository.GetGiftsByGuestReservationId(guestReservationId); foreach (var gift in allGifts) { _repository.Delete <Gift>(gift); } await _repository.SavaAll(); foreach (var gift in gifts) { _repository.Add <Gift>(gift); } await _repository.SavaAll(); var guest = await _repository.GetGuestReservation(guestReservationId); if (!await _repository.GetCheckGuidHaveWorkInTheDay(guest.MGuideId.Value, guest.ReservationDate)) { var contract = await _repository.GetGuideContractByGuideId(guest.MGuideId.Value); var attend = new Attend() { GuideContractId = contract.Id, TheWork = "وجهاء", WorkingHours = contract.DailyWorkingHours, GuideId = guest.MGuideId.Value, AttendDate = guest.ReservationDate }; _repository.Add <Attend>(attend); await _repository.SavaAll(); } return(RedirectToAction("NotablesByReservation", "Notables", new { guestReservationId = guestReservationId }).WithSuccess("success", "تم الحفظ بنجاخ")); } ViewData["ItemOfProducts"] = await _repository.GetItemOfProducts(); ViewBag.guestReservationId = guestReservationId; var JobNotablesNormal = await _repository.GetJobNotablesNormal(guestReservationId); var JobNotablesNotNormal = await _repository.GetJobNotablesNotNormal(guestReservationId); await _repository.GetJobNotablesNormal(guestReservationId); ViewBag.notableNormal = JobNotablesNormal.Count(); ViewBag.notableNotNormal = JobNotablesNotNormal.Count(); return(View(gifts)); }
public IActionResult unRSVP(int activityyID) { int?IdinSession = HttpContext.Session.GetInt32("userid"); if (IdinSession == null) { return(RedirectToAction("Index")); } Attend unrsvp = _context.Attends .FirstOrDefault(a => a.ActivityyID == activityyID && a.UserID == (int)IdinSession); _context.Remove(unrsvp); _context.SaveChanges(); return(RedirectToAction("Dashboard")); }
// GET: Attends/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Attend attend = db.Attends.Find(id); if (attend == null) { return(HttpNotFound()); } ViewBag.StudentId = new SelectList(db.Students, "Id", "Name", attend.StudentId); return(View(attend)); }
public ActionResult RecordAttend(string data) { // Authenticate first if (!Auth()) { return(BaseMessage.createErrorReturn("Authentication failed, please try again", BaseMessage.API_ERROR_INVALID_CREDENTIALS)); } BaseMessage dataIn = BaseMessage.createFromString(data); CheckInAttend cia = JsonConvert.DeserializeObject <CheckInAttend>(dataIn.data); var meeting = DbUtil.Db.Meetings.SingleOrDefault(m => m.OrganizationId == cia.orgID && m.MeetingDate == cia.datetime); if (meeting == null) { meeting = new Meeting { OrganizationId = cia.orgID, MeetingDate = cia.datetime, CreatedDate = Util.Now, CreatedBy = Util.UserPeopleId ?? 0, GroupMeetingFlag = false, }; DbUtil.Db.Meetings.InsertOnSubmit(meeting); DbUtil.Db.SubmitChanges(); var acr = (from s in DbUtil.Db.OrgSchedules where s.OrganizationId == cia.orgID where s.SchedTime.Value.TimeOfDay == cia.datetime.TimeOfDay where s.SchedDay == (int)cia.datetime.DayOfWeek select s.AttendCreditId).SingleOrDefault(); meeting.AttendCreditId = acr; } Attend.RecordAttendance(cia.peopleID, meeting.MeetingId, cia.present); DbUtil.Db.UpdateMeetingCounters(cia.orgID); DbUtil.LogActivity($"Check-In Record Attend Org ID:{meeting.OrganizationId} People ID:{cia.peopleID} User ID:{Util.UserPeopleId} Attended:{cia.present}"); BaseMessage br = new BaseMessage(); br.setNoError(); br.count = 1; return(br); }
public void UpdateCommitments() { var commitments = (from m in Meetings() where m.iscommitted select m.MeetingDate).ToList(); if (Commit == null) { Commit = new DateTime[] { }; } var decommits = from currcommit in commitments join newcommit in Commit on currcommit equals newcommit into j from newcommit in j.DefaultIfEmpty(DateTime.MinValue) where newcommit == DateTime.MinValue select currcommit; var commits = from newcommit in Commit join currcommit in commitments on newcommit equals currcommit into j from currcommit in j.DefaultIfEmpty(DateTime.MinValue) where currcommit == DateTime.MinValue select newcommit; int?mid = null; foreach (var currcommit in decommits) { mid = Attend.MarkRegistered(DbUtil.Db, OrgId, PeopleId, currcommit, AttendCommitmentCode.Regrets); } foreach (var newcommit in commits) { mid = Attend.MarkRegistered(DbUtil.Db, OrgId, PeopleId, newcommit, AttendCommitmentCode.Attending); } if (mid.HasValue) { var slots = FetchSlots(); Meeting.AddEditExtraData(DbUtil.Db, mid.Value, "Description", slots.First().Description); } var om = DbUtil.Db.OrganizationMembers.SingleOrDefault(mm => mm.PeopleId == PeopleId && mm.OrganizationId == OrgId); if (om == null) { OrganizationMember.InsertOrgMembers(DbUtil.Db, OrgId, PeopleId, MemberTypeCode.Member, DateTime.Now, null, false); } }
public IActionResult RSVP(int activityyId) { int?IdinSession = HttpContext.Session.GetInt32("userid"); if (IdinSession == null) { return(RedirectToAction("Index")); } Attend rsvp = new Attend(); rsvp.ActivityyID = activityyId; rsvp.UserID = (int)IdinSession; _context.Add(rsvp); _context.SaveChanges(); return(RedirectToAction("Dashboard")); }
public void AddToSmallGroup(CMSDataContext Db, OrganizationMember om, PythonModel pe) { if (om == null) { return; } if (pe != null) { pe.instance.AddToSmallGroup(SmallGroup, om); } om.AddToGroup(Db, SmallGroup); if (MeetingTime.HasValue) { Attend.MarkRegistered(Db, om.OrganizationId, om.PeopleId, MeetingTime.Value, 1); } }
public ActionResult Edit(Attend attend) { using (SqlConnection sqlcon = new SqlConnection(connectionString)) { sqlcon.Open(); string query = "UPDATE Attend SET Name = @Name, Date = @Date, Attendance = @Attendance where EmpID = @EmpID"; SqlCommand sqlcmd = new SqlCommand(query, sqlcon); sqlcmd.Parameters.AddWithValue("@EmpID", attend.EmpID); sqlcmd.Parameters.AddWithValue("@Name", attend.Name); sqlcmd.Parameters.AddWithValue("@Date", attend.Date); sqlcmd.Parameters.AddWithValue("@Attendance", attend.Attendance); sqlcmd.ExecuteNonQuery(); } return(RedirectToAction("Index")); }
public async Task <IActionResult> Create([Bind("Id,EmployeeId,EmployeeContractId,GuideId,GuideContractId,AttendDate,TheWork,AppUserId,WorkingHours")] Attend attend) { if (ModelState.IsValid) { _context.Add(attend); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["AppUserId"] = new SelectList(_context.Users, "Id", "Id", attend.AppUserId); ViewData["EmployeeId"] = new SelectList(_context.Employees, "Id", "Email", attend.EmployeeId); ViewData["EmployeeContractId"] = new SelectList(_context.EmployeeContracts, "Id", "Id", attend.EmployeeContractId); ViewData["GuideId"] = new SelectList(_context.MGuides, "Id", "Name", attend.GuideId); ViewData["GuideContractId"] = new SelectList(_context.GuideContracts, "Id", "Id", attend.GuideContractId); return(View(attend)); }
public ContentResult EditCommitment(string id, string value) { var a = id.Substring(1).Split('_').Select(vv => vv.ToInt()).ToArray(); var c = value.ToInt2(); if (c == 99) { c = null; } Attend.MarkRegistered(CurrentDatabase, a[1], a[0], c); var desc = AttendCommitmentCode.Lookup(c ?? 99); DbUtil.LogActivity($"EditCommitment {desc} id={id}"); return(Content(desc)); }
public void RecentAttendCount_Should_Work() { var code = "RecentAttendCount( Days=2, Org=36[App Testing Org] ) = 1"; var org = 36; var pid = 2; var dt = DateTime.Today.AddHours(-10); Attend.RecordAttend(db, pid, org, true, dt); db.SubmitChanges(); var qb = db.PeopleQuery2(code); var count = qb.Count(); db.ExecuteCommand("DELETE dbo.attend where OrganizationId = {0} AND MeetingDate = {1}", org, dt); db.ExecuteCommand("DELETE dbo.meetings where OrganizationId = {0} AND MeetingDate = {1}", org, dt); count.ShouldBe(1); }
private void btnSignSelected_Click(object sender, EventArgs e) { this.SuspendLayout(); { foreach (DataGridViewRow dgvrow in dataGridViewX1.Rows) { Attend attend = dgvrow.Tag as Attend; for (int i = 3; i <= 12; i++) { Wish wish = dgvrow.Cells[i].Tag as Wish; if (attend.RefSubjectID == wish.RefSubjectID) { dgvrow.Cells[i].Style.ForeColor = Color.Red; } } } } this.ResumeLayout(); }
public ActionResult Create([Bind(Include = "CId,Name,CEmail,CPhone,Status")] Attend attend) { if (string.IsNullOrEmpty(attend.Name)) { ModelState.AddModelError("Name", "Please enter Name"); } if (ModelState.IsValid) { db.Attends.Add(attend); db.SaveChanges(); return(RedirectToAction("Index")); } else { return(View()); } }
public async Task <IHttpActionResult> DeleteAttend(int id, int classroom_Id) { Attend attend = await db.Attends.FindAsync(id); if (attend == null) { return(NotFound()); } //if requested attend is not in the given class if (db.Attends.AsNoTracking().Where((a) => a.Att_Id == id).FirstOrDefault().Cls_Id != classroom_Id) { return(BadRequest("invalid attend id for the given class in user")); } db.Attends.Remove(attend); await db.SaveChangesAsync(); return(Ok(attend)); }
private JsonResult AddRegistered(int id, SearchAddModel m, int origin) { if (id > 0) { var meeting = DbUtil.Db.Meetings.SingleOrDefault(me => me.MeetingId == id); foreach (var p in m.List) { var isnew = p.IsNew; AddPerson(p, m.List, origin, m.EntryPointId); if (isnew) { p.person.CampusId = meeting.Organization.CampusId; } Attend.MarkRegistered(DbUtil.Db, p.PeopleId.Value, id, 1); } DbUtil.Db.SubmitChanges(); DbUtil.Db.UpdateMeetingCounters(meeting.MeetingId); } return(Json(new { close = true, how = "addselected" })); }
public void RecentVisitNumberOrgs() { var code = "RecentVisitNumberOrgs( VisitNumber='2', Days=2, Org=36[App Testing Org] ) = 1"; var org = 36; var pid = 2; var dt1 = DateTime.Today.AddHours(-10); var dt2 = dt1.AddDays(-1); Attend.RecordAttend(db, pid, org, true, dt1); Attend.RecordAttend(db, pid, org, true, dt2); db.SubmitChanges(); var qb = db.PeopleQuery2(code); var count = qb.Count(); db.ExecuteCommand("DELETE dbo.attend where OrganizationId = {0} AND MeetingDate IN ({1}, {2})", org, dt1, dt2); db.ExecuteCommand("DELETE dbo.meetings where OrganizationId = {0} AND MeetingDate IN ({1}, {2})", org, dt1, dt2); count.ShouldBe(1); }
public ActionResult RecordAttend(string data) { // Authenticate first if (!Auth()) { return(CheckInMessage.createErrorReturn("Authentication failed, please try again", CheckInMessage.API_ERROR_INVALID_CREDENTIALS)); } CheckInMessage dataIn = CheckInMessage.createFromString(data); CheckInAttend cia = JsonConvert.DeserializeObject <CheckInAttend>(dataIn.data); Meeting meeting = CurrentDatabase.Meetings.SingleOrDefault(m => m.OrganizationId == cia.orgID && m.MeetingDate == cia.datetime); if (meeting == null) { int meetingID = CurrentDatabase.CreateMeeting(cia.orgID, cia.datetime); meeting = CurrentDatabase.Meetings.SingleOrDefault(m => m.MeetingId == meetingID); } Attend.RecordAttend(CurrentDatabase, cia.peopleID, cia.orgID, cia.present, cia.datetime); CurrentDatabase.UpdateMeetingCounters(cia.orgID); DbUtil.LogActivity($"Check-In Record Attend Org ID:{cia.orgID} People ID:{cia.peopleID} User ID:{CurrentDatabase.UserPeopleId} Attended:{cia.present}"); // Check Entry Point and replace if Check-In Person person = CurrentDatabase.People.FirstOrDefault(p => p.PeopleId == cia.peopleID); if (person != null && person.EntryPoint != null && person.EntryPoint.Code != null && person.EntryPoint.Code == "CHECKIN" && meeting != null) { person.EntryPoint = meeting.Organization.EntryPoint; CurrentDatabase.SubmitChanges(); } CheckInMessage br = new CheckInMessage(); br.setNoError(); br.count = 1; return(br); }
public IActionResult RSVP(bool IsRSVPed, int weddingId, int userId, Attend newAttend) { Attend existingRSVP = db.Attends .FirstOrDefault(attend => attend.WeddingId == weddingId && attend.UserId == userId); if (existingRSVP == null) { db.Attends.Add(newAttend); db.SaveChanges(); } else if (existingRSVP != null) { existingRSVP.IsRSVPed = IsRSVPed; existingRSVP.UpdatedAt = DateTime.Now; db.Attends.Update(existingRSVP); db.SaveChanges(); } return(RedirectToAction("Dashboard")); }
/// <summary> /// Create a new Attend object. /// </summary> /// <param name="attendID">Initial value of AttendID.</param> public static Attend CreateAttend(int attendID) { Attend attend = new Attend(); attend.AttendID = attendID; return attend; }
public void AddAttend(int id) { TrainResultListViewData viewData = new TrainResultListViewData(); Classes classes = (from c in CQGJ.Classes where c.ClassID == id select c).First(); viewData.Classes = classes; List<int> ListID = (from s in CQGJ.Student where s.Classes.ClassID == id select s.User.UserID).ToList(); passport.CQGJPassport cqgjp = new CQGJ.passport.CQGJPassport(); viewData.UserList = new List<CQGJ.passport.User>(); for (int i = 0; i < ListID.Count; ++i) { ListID[i] = ToPassportUserID(ListID[i]); CQGJ.passport.User user = cqgjp.GetCQGJUser(ListID[i]); viewData.UserList.Add(user); } //班级课程 viewData.CourseList = (from cs in CQGJ.Course where cs.Classes.ClassID == id select cs).ToList(); if (GetString("flag") != "") { Course course = viewData.CourseList.First(); for (int i = 0; i < ListID.Count; i++) { int temp = 0; if (GetString("user-" + i.ToString()) == "on") { temp = 1; } int x = ListID[i]; Student student = (from s in CQGJ.Student from cs in CQGJ.Course where cs.CourseID == course.CourseID && cs.Classes == s.Classes && s.User.UserID == x select s).First(); var result = (from cr in CQGJ.CourseResult from s in CQGJ.Student where cr.Course.CourseID == course.CourseID && cr.Student.StudentID == student.StudentID select cr); Attend attend = new Attend(); if (result.Count() <= 0) { CourseResult r = new CourseResult(); r.Course = course; r.Student = student; r.Mark = temp.ToString(); CQGJ.AddToCourseResult(r); CQGJ.SaveChanges(); attend.CourseResult = r; } else { attend.CourseResult = result.First(); } attend.Status = temp; attend.AttendTime = DateTime.Now; CQGJ.AddToAttend(attend); CQGJ.SaveChanges(); } RedirectToAction("attendlist"); } RenderView("AddAttend", viewData); }
/// <summary> /// There are no comments for Attend in the schema. /// </summary> public void AddToAttend(Attend attend) { base.AddObject("Attend", attend); }