// // GET: /Attendance/Delete/5 public ActionResult Delete(int AttandenceID) { ViewBag.AttandenceID = AttandenceID; attendance attendance = AttendanceRepository.GetAttendanceByID(AttandenceID); return(PartialView(attendance)); }
/// <summary> /// Add an attendance to the database /// </summary> /// <param name="att"></param> /// <returns></returns> public HttpResponseMessage Post([FromBody] attendance att) { try { using (ebuilderEntities entities = new ebuilderEntities()) { if (DateTime.Compare(DateTime.Today, att.date.Date) < 0) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Attendance for future dates are not allowed")); } if (att.EID == null || att.checkIn == null || att.checkOut == null) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Some fields are empty")); } var entity = entities.attendances.FirstOrDefault(a => a.EID == att.EID && a.date == att.date); if (entity != null) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Attendance the given EID and date already exists.")); } entities.attendances.Add(att); entities.SaveChanges(); var message = Request.CreateResponse(HttpStatusCode.OK, att); message.Headers.Location = new Uri(Request.RequestUri + att.AID.ToString()); return(message); } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, att.ToString(), ex)); } }
public IHttpActionResult SaveFingerprintID(int fingerID, string message, int deviceid, string devicename) { try { using (kernels1_itiEntities DB = new kernels1_itiEntities()) { DATA.attendance attendance = new attendance(); attendance.deviceid = deviceid; attendance.devicename = devicename; attendance.fingerid = fingerID; attendance.message = message; TimeZoneInfo timeZoneInfo = TimeZoneInfo.FindSystemTimeZoneById("India Standard Time"); DateTime timeUtc = DateTime.UtcNow; DateTime result = TimeZoneInfo.ConvertTimeFromUtc(timeUtc, timeZoneInfo); attendance.updatedDate = result; // var status = DB.attendances.ToList().Where(x=>x.deviceid==deviceid).OrderByDescending(x=>x.id).Take(1); var latesttime_fingerId = (from a in DB.attendances where a.fingerid == fingerID select a) .OrderByDescending(x => x.id) .Take(1) .Select(x => x.updatedDate).FirstOrDefault(); var lateststatus_fingerid = (from a in DB.attendances where a.fingerid == fingerID select a) .OrderByDescending(x => x.id) .Take(1) .Select(x => x.status).FirstOrDefault(); DateTime latesttime = Convert.ToDateTime(latesttime_fingerId); if (latesttime.Day == result.Day && lateststatus_fingerid == "IN") { attendance.status = "OUT"; } else if (latesttime.Day < result.Day) { attendance.status = "IN"; } else { attendance.status = "INVALID"; } DB.attendances.Add(attendance); DB.SaveChanges(); } var response = new { Success = true, Message = "attendance saved", }; return(Ok(response)); } catch (Exception Ex) { return(Content(HttpStatusCode.BadRequest, "Error Found")); } }
public ActionResult DeleteConfirmed(int AttandenceID) { attendance attendance = AttendanceRepository.GetAttendanceByID(AttandenceID); int calendarID = attendance.calendarID; AttendanceRepository.DeleteRecord(attendance); return(RedirectToAction("MeetingAttendance", new { calendarID = calendarID })); }
public ActionResult DeleteConfirmed(int id) { attendance attendance = db.attendances.FirstOrDefault(i => i.attendance_id == id); db.attendances.Remove(attendance); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult DeleteConfirmed(int id) { attendance attendance = db.attendance.Find(id); db.attendance.Remove(attendance); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult DeleteConfirmed(int id, int classId, DateTime dt) { attendance attendance = db.attendances.Find(id, classId, dt); db.attendances.Remove(attendance); db.SaveChanges(); return(RedirectToAction("Index")); }
private void btnSave_Click_1(object sender, EventArgs e) { try { foreach (DataGridViewRow cb in grdList.Rows) { if (cb.Cells[3].Value == null) { MessageBox.Show("Please enter attendence for all Employees!!!"); return; } } attendance att = new attendance(); List <attendance> attlstnew = new List <attendance>(); List <attendance> attlstupdt = new List <attendance>(); AttendanceDB docDB = new AttendanceDB(); foreach (DataGridViewRow dgvrw in grdList.Rows) { if (changedval.ContainsKey(dgvrw.Cells[1].Value.ToString())) { if (Initval.ContainsKey(dgvrw.Cells[1].Value.ToString())) { att = new attendance(); att.EmployeeID = dgvrw.Cells[1].Value.ToString(); att.AttendenceStatus = dgvrw.Cells[3].Value.ToString(); attlstupdt.Add(att); } else { att = new attendance(); att.EmployeeID = dgvrw.Cells[1].Value.ToString(); att.AttendenceStatus = dgvrw.Cells[3].Value.ToString(); attlstnew.Add(att); } } } DateTime dt = UpdateTable.getSQLDateTime(); if (Main.itemPriv[2]) { dt = dtpdate.Value; } if (docDB.UpdateAttendance(attlstupdt, attlstnew, empstatuslist, dt)) { MessageBox.Show("Attendance Status Updated"); changedval.Clear(); Initval.Clear(); ListEmployee(); } else { MessageBox.Show("Error Updating Attendance Status"); } } catch (Exception) { MessageBox.Show("Failed Adding / Editing User Data"); } }
public static Boolean insert(attendance newAttendance) { int retVal = 0; using (var db = new ExtremeAppContext()) { db.attendances.Add(newAttendance); retVal = db.SaveChanges(); } return(retVal > 0 ? true : false); }
//Save new attendance private Boolean saveAttendance(member m, Boolean isPaid) //dopuniti kada se popravi baza { var newAttendance = new attendance() { member_id = m.member_id, check_in_time = DateTime.Now, is_staff = false }; return(AttendanceDAO.insert(newAttendance)); }
public HttpResponseMessage AddOrEditMultiple([FromBody] JToken attendanceProxy) { // JToken as a parameter type allows us to accept JSON // We can then deserialise manually and handle errors try { AttendanceProxy ap = attendanceProxy.ToObject <AttendanceProxy>(); // There are no items to add/update so return if (ap.userAttendanceProxies.Length == 0) { return(Request.CreateResponse(HttpStatusCode.OK)); } // Find the event referenced events evt = db.events.Find(ap.eventId); // Unable to find event, return HTTP500 if (evt == null) { return(Request.CreateResponse(HttpStatusCode.BadRequest, string.Format("Event with id:{0} not found", ap.eventId))); } foreach (UserAttendanceProxy uap in ap.userAttendanceProxies) { // Do we add or update? attendance a = db.attendance.FirstOrDefault(x => x.fkevent == ap.eventId && x.fkuser == uap.userId); if (a == null) { // new attendance record attendance newAttendance = new attendance(); newAttendance.fkevent = ap.eventId; newAttendance.fkuser = uap.userId; newAttendance.fkstatus = uap.statusId; db.attendance.Add(newAttendance); } else { // update existing attendance record a.fkstatus = uap.statusId; } } // Commit changes db.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } catch (Exception ex) { return(Request.CreateResponse(HttpStatusCode.InternalServerError, ex.Message)); } }
public ActionResult Edit([Bind(Include = "Training_Course_Instance_ID,Employee_ID,Replied_Going,Actual_Attendance")] attendance attendance) { if (ModelState.IsValid) { db.Entry(attendance).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.Employee_ID = new SelectList(db.employees, "Employee_ID", "Employee_Name", attendance.Employee_ID); ViewBag.Training_Course_Instance_ID = new SelectList(db.training_course_instance, "Training_Course_Instance_ID", "Training_Course_Instance_ID", attendance.Training_Course_Instance_ID); return(View(attendance)); }
public ActionResult Edit([Bind(Include = "attendance_id,student_id,class_id,attendance_attended,attendance_date")] attendance attendance) { if (ModelState.IsValid) { db.Entry(attendance).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.class_id = new SelectList(db.classses, "class_id", "class_level", attendance.class_id); ViewBag.student_id = new SelectList(db.students, "student_id", "student_name", attendance.student_id); return(View(attendance)); }
public ActionResult Edit([Bind(Include = "student_id,class_id,class_date,did_attend")] attendance attendance) { if (ModelState.IsValid) { db.Entry(attendance).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.class_id = new SelectList(db.student_class, "class_id", "getDetails", attendance.class_id); ViewBag.student_id = new SelectList(db.students, "student_id", "email_id", attendance.student_id); return(View(attendance)); }
public void AddAttendance(int memberID, int calendarID) { attendance attd = new attendance(); attd.memberID = memberID; attd.calendarID = calendarID; attd.RollCall = DateTime.Now; attd.EnteredBy = User.Identity.Name.ToString(); attd.DateEntered = DateTime.Now.Date; db.attendances.Add(attd); db.SaveChanges(); AttendanceRepository.AddRecord(attd); }
public ActionResult Edit([Bind(Include = "id,fkevent,fkuser,fkstatus")] attendance attendance) { if (ModelState.IsValid) { db.Entry(attendance).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.fkevent = new SelectList(db.events, "id", "title", attendance.fkevent); ViewBag.fkstatus = new SelectList(db.attendancestatus, "id", "status", attendance.fkstatus); ViewBag.fkuser = new SelectList(db.users, "id", "firstname", attendance.fkuser); return(View(attendance)); }
// GET: attendances/Details/5 public ActionResult Details(int?id, int?classId, DateTime dt) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } attendance attendance = db.attendances.Find(id, classId, dt); if (attendance == null) { return(HttpNotFound()); } return(View(attendance)); }
// GET: Attendances/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } attendance attendance = db.attendance.Find(id); if (attendance == null) { return(HttpNotFound()); } return(View(attendance)); }
// GET: attendances/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } attendance attendance = db.attendances.FirstOrDefault(i => i.attendance_id == id); if (attendance == null) { return(HttpNotFound()); } return(View(attendance)); }
public void addAttendance(int courseid, int stuid) { //check if attendace already stored in db List <attendance> catt = MCDB.attendances.Where(x => DbFunctions.DiffDays(x.date, DateTime.Now) == 0 && x.course_id == courseid && x.user_id == stuid).ToList(); if (catt.Count == 0) { attendance attRec = new attendance(); attRec.course_id = courseid; attRec.user_id = stuid; attRec.date = DateTime.Now.Date; MCDB.attendances.Add(attRec); MCDB.SaveChanges(); } }
// GET: attendances/Edit/5 public ActionResult Edit(int?id, int?classId, DateTime dt) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } attendance attendance = db.attendances.Find(id, classId, dt); if (attendance == null) { return(HttpNotFound()); } ViewBag.class_id = new SelectList(db.student_class, "class_id", "getDetails", attendance.class_id); ViewBag.student_id = new SelectList(db.students, "student_id", "email_id", attendance.student_id); return(View(attendance)); }
// GET: attendances/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } attendance attendance = db.attendances.Find(id); if (attendance == null) { return(HttpNotFound()); } ViewBag.Employee_ID = new SelectList(db.employees, "Employee_ID", "Employee_Name", attendance.Employee_ID); ViewBag.Training_Course_Instance_ID = new SelectList(db.training_course_instance, "Training_Course_Instance_ID", "Training_Course_Instance_ID", attendance.Training_Course_Instance_ID); return(View(attendance)); }
// GET: attendances/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } attendance attendance = db.attendances.FirstOrDefault(i => i.attendance_id == id); if (attendance == null) { return(HttpNotFound()); } ViewBag.class_id = new SelectList(db.classses, "class_id", "class_level", attendance.class_id); ViewBag.student_id = new SelectList(db.students, "student_id", "student_name", attendance.student_id); return(View(attendance)); }
public ActionResult EditSalesRepAttendance([Bind(Include = "Training_Course_Instance_ID,Employee_ID,Replied_Going,Actual_Attendance")] attendance attendance) { if (ModelState.IsValid) { db.Entry(attendance).State = EntityState.Modified; db.SaveChanges(); ViewBag.Success = "Sales rep attendance updated, Please click back to list."; return(View(attendance)); //return RedirectToAction("CaptureSaleRepAttendance",attendance.Training_Course_Instance_ID); } ViewBag.Employee_ID = new SelectList(db.employees, "Employee_ID", "Employee_Name", attendance.Employee_ID); ViewBag.Training_Course_Instance_ID = new SelectList(db.training_course_instance, "Training_Course_Instance_ID", "Training_Course_Instance_ID", attendance.Training_Course_Instance_ID); return(View(attendance)); }
// GET: Attendances/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } attendance attendance = db.attendance.Find(id); if (attendance == null) { return(HttpNotFound()); } ViewBag.fkevent = new SelectList(db.events, "id", "title", attendance.fkevent); ViewBag.fkstatus = new SelectList(db.attendancestatus, "id", "status", attendance.fkstatus); ViewBag.fkuser = new SelectList(db.users, "id", "firstname", attendance.fkuser); return(View(attendance)); }
public ActionResult addOrEdit(user userModel) { using (inventorymgtEntities dbModel = new inventorymgtEntities()) { if (dbModel.users.Any(x => x.email == userModel.email)) { ViewBag.DuplicateMsg = "Your Email is already exist."; return(View("addOrEdit", userModel)); } if (userModel.gender == "Male") { userModel.img_path = "~/image/male.png"; } else if (userModel.gender == "Female") { userModel.img_path = "~/image/female.png"; } dbModel.users.Add(userModel); dbModel.SaveChanges(); attendance atnModel = new attendance(); var initialUser = dbModel.users.Where(x => x.email == userModel.email).FirstOrDefault(); atnModel.user_ = initialUser.regId; atnModel.no_of_days = 0; atnModel.status_ = "false"; atnModel.date_ = DateTime.Now.Date.AddDays(-1).ToString(); //atnModel.date_ = DateTime.Now.ToString("MM-dd-yyyy"); dbModel.attendances.Add(atnModel); dbModel.SaveChanges(); } ViewBag.SuccessMessage = "Registration Successful."; ModelState.Clear(); user user = new user(); return(View("addOrEdit", user)); }
private void userMemberCheckIn() { DateTime today = DateTime.Now; Boolean CheckedInForCurrentDate = AttendanceDAO.isAlreadyCheckedIn(loggedInUser.member_id, today.Day, today.Month, today.Year); if (!CheckedInForCurrentDate) { var user_member = MemberDAO.getById(loggedInUser.member_id); //UBACITI POLJE TrUE za placen dolazak var newAttendance = new attendance() { member_id = user_member.member_id, check_in_time = DateTime.Now, is_staff = true }; AttendanceDAO.insert(newAttendance); } }
public attendanceWithWorkingHours(attendance att) { this.AID = att.AID; this.checkIn = att.checkIn; this.checkOut = att.checkOut; this.date = att.date; this.EID = att.EID; using (ebuilderEntities entities = new ebuilderEntities()) { var emp = entities.employees.FirstOrDefault(e => e.EID == this.EID); this.fName = emp.fName; this.lName = emp.lName; } if (checkIn != null && checkOut != null) { this.workingHours = ((TimeSpan)checkOut).Subtract((TimeSpan)checkIn); } }
// GET: proifle/Details/5 public ActionResult Details(int id) { using (inventorymgtEntities dbModel = new inventorymgtEntities()) { var atndDetails = dbModel.attendances.Where(x => x.user_ == id).FirstOrDefault(); if (atndDetails == null) { attendance atdMdodel = new attendance(); atdMdodel.user_ = id; atdMdodel.status_ = "false"; atdMdodel.no_of_days = 0; atdMdodel.date_ = DateTime.Now.Date.ToString(); dbModel.attendances.Add(atdMdodel); dbModel.SaveChanges(); } return(View(dbModel.users.Where(x => x.regId == id).FirstOrDefault())); } }
public Boolean setdepartureforStudent(int courseid, int studentid, DateTime date) { attendance Attendence = MCDB.attendances.Where(x => DbFunctions.DiffDays(x.date, date.Date) == 0 && x.user_id == studentid && x.course_id == courseid).FirstOrDefault(); if (Attendence.departure_time == null) { Attendence.departure_time = DateTime.Now; Attendence.departure = true; MCDB.SaveChanges(); return(true); } else { Attendence.departure_time = DateTime.Now; Attendence.departure_time = null; Attendence.departure = false; MCDB.SaveChanges(); return(false); } }
private void ApplicationBarIconButton_Click(object sender, EventArgs e) { String name = System.Guid.NewGuid().ToString(); String name2 = System.Guid.NewGuid().ToString(); DateTime date = (DateTime)Date1.Value; DateTime time = (DateTime)Time1.Value; DateTime beginTime = date + time.TimeOfDay; if (beginTime < DateTime.Now) { MessageBox.Show("PUT FUTURE DATE"); return; } RecurrenceInterval recurrence = RecurrenceInterval.None; recur1 = 0; if (radioButton1.IsChecked == true) { recurrence = RecurrenceInterval.Daily; recur1 = 1; } else if (radioButton2.IsChecked == true) { recurrence = RecurrenceInterval.Weekly; recur1 = 2; } else if (radioButton3.IsChecked == true) { recurrence = RecurrenceInterval.Monthly; recur1 = 3; } using (AttendanceDataContext atd = new AttendanceDataContext(strConnectionString)) { atd.CreateDatabase(); attendance a = new attendance(); a.total = 0; a.attend = 0; a.percent = 0; a.time = beginTime; a.recur = recur1; atd.Attendancee.InsertOnSubmit(a); atd.SubmitChanges(); } Reminder reminder1 = new Reminder(name); Reminder reminder2 = new Reminder("new reminder12"); // reminder2[230] = new Reminder(name); reminder1.Title = "Click here to update and check attendance "; reminder1.Content = textBox4.Text; reminder1.BeginTime = beginTime; Uri navigationuri = new Uri("/BunkCounter.xaml", UriKind.Relative); reminder1.NavigationUri = navigationuri; double ab = 0, b = 0, c = 0; //reminder.ExpirationTime = expirationTime; reminder1.RecurrenceType = recurrence; reminder2.Title = "Click here to update and check attendance "; reminder2.Content = textBox4.Text; ScheduledActionService.Add(reminder1); reminder2.NavigationUri = navigationuri; for (int i = 0; i < 5; i++) { DateTime beginTime2 = date + time.TimeOfDay; beginTime2.AddMinutes(1); reminder2.BeginTime =beginTime2; ScheduledActionService.Add(reminder2); ScheduledActionService.LaunchForTest(name, System.TimeSpan.FromMinutes(1)); } //FileStream stream = store.OpenFile("test.txt", FileMode.Create, FileAccess.ReadWrite); //BinaryWriter writer = new BinaryWriter(stream); //writer.Write(ab); //writer.Write(b); //writer.Write(c); //MessageBox.Show("Reminder saved"); //writer.Close(); }