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);
}
