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