public ActionResult Create(AttendenceViewModel viewModel) { if (ModelState.IsValid) { try { Attendence attendence = Mapper.Map <Attendence>(viewModel); attendence.Id = Guid.NewGuid(); attendence.CompanyId = CompanyCookie.CompId; _dbContext.Attendences.Add(attendence); _dbContext.SaveChanges(); Salary salary = new Salary(); salary.CompanyId = CompanyCookie.CompId; salary.Date = viewModel.Date; _dbContext.Salary.Add(salary); _dbContext.SaveChanges(); TempData["MessageToClientSuccess"] = "Attendence Date SuccessFully Created"; } catch (Exception ex) { // Log4NetHelper.Log(String.Format("Cannot Create Deparment {0} ", viewModel.Id), LogLevel.ERROR, "Department", viewModel.Id, User.Identity.Name, ex); var msg = new ModelStateException(ex); TempData["MessageToClientError"] = msg; } return(RedirectToAction("Index")); } ViewBag.CompanyId = new SelectList(_dbContext.Companyies, "Id", "CompanyName"); return(View(viewModel)); }
public void Index_CalledWithLogInUser_ReturnGigsAndAttendances() { var gig1 = new Gig(_user.Id, "-", DateTime.Now.AddDays(1), _genre.Id); var gig2 = new Gig(_user.Id, "-", DateTime.Now.AddDays(1), _genre.Id); var gigs = new List <Gig>(); gigs.Add(gig1); gigs.Add(gig2); _context.Gigs.AddRange(gigs); _context.SaveChanges(); _context.Entry(gig1).Reload(); var attendance = new Attendence() { AttendeeId = _user.Id, GigId = gig1.Id }; _context.Attendences.Add(attendance); _context.SaveChanges(); var result = _controller.Index(); (result.ViewData.Model as GigsViewModel).Attendences.Should().HaveCount(1); (result.ViewData.Model as GigsViewModel).upcomingGigs.Should().HaveCount(2); }
public DataTable GetDatatableAttendence(DO_Attendence objAttendence, Attendence flag) { //For Retriving Record For Attendence DataTable dt = new DataTable(); SqlConnection conn = new SqlConnection(); SQLManager co = new SQLManager(); conn = co.GetConnection(); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = new SqlCommand("Scrl_AddEditDelAttendence", conn); da.SelectCommand.CommandType = CommandType.StoredProcedure; da.SelectCommand.Parameters.Add("@FlagNo", SqlDbType.Int).Value = flag; da.SelectCommand.Parameters.Add("@RegistrationId", SqlDbType.BigInt).Value = objAttendence.RegistrationId; da.SelectCommand.Parameters.Add("@CourseId", SqlDbType.BigInt).Value = objAttendence.CourseId; da.SelectCommand.Parameters.Add("@ClassId", SqlDbType.BigInt).Value = objAttendence.ClassId; da.SelectCommand.Parameters.Add("@SubjectId", SqlDbType.BigInt).Value = objAttendence.Subjectid; da.SelectCommand.Parameters.Add("@AddedBy", SqlDbType.BigInt).Value = objAttendence.AddedBy; da.SelectCommand.Parameters.Add("@UserTypeId", SqlDbType.BigInt).Value = objAttendence.UserTypeID; da.SelectCommand.Parameters.Add("@AttendenceDate", SqlDbType.DateTime).Value = objAttendence.AttendenceDate; da.SelectCommand.Parameters.Add("@yearPaseed", SqlDbType.BigInt).Value = objAttendence.YearPassed; da.SelectCommand.Parameters.Add("@MonthPassed", SqlDbType.BigInt).Value = objAttendence.MonthPassed; da.Fill(dt); co.CloseConnection(conn); return(dt); }
public async Task <IActionResult> Edit(int id, [Bind("Id,date,attendenceState,Notes,NewRegisteredStudentId")] Attendence attendence) { if (id != attendence.Id) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(attendence); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!AttendenceExists(attendence.Id)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } ViewData["NewRegisteredStudentId"] = new SelectList(_context.NewRegisteredStudent, "Id", "CallingProgram", attendence.NewRegisteredStudentId); return(View(attendence)); }
public JsonResult SubmitAttendence(MyModelWithList details) { try { foreach (var s in details.MyList) { var csid = db.ClassSections.Include("Class").Include("Section").Single(i => i.Class.ClassId == s.ClassId && i.Section.SectionId == s.SectionId); Attendence at = new Attendence(); at.AttendenceId = 0; at.ClassSectionId = csid.ClassSectionId; at.StudentId = s.StudentId; at.Status = s.Status.ToString(); at.Date = s.Date; db.Attendence.Add(at); db.SaveChanges(); } return(Json("Successfully Submit", JsonRequestBehavior.AllowGet)); } catch (Exception e) { ViewBag.ERROR = e.Message.ToString(); return(Json(e.Message.ToString())); } }
public JsonResult studentPay(string sId, string groupId, string amount) { int sid = int.Parse(sId); int grpID = int.Parse(groupId); double sum = float.Parse(amount); using (FastAndEasyEntities db = new FastAndEasyEntities()) { int? levelId = db.Groups.Where(g => g.Id == grpID).FirstOrDefault().Level; double?cost = db.Levels.Where(l => l.Id == levelId).FirstOrDefault().Price; var x = sum / cost; for (int i = 1; i <= x; i++) { Attendence a = new Attendence(); a.Student = sid; db.Attendences.Add(a); db.SaveChanges(); ModelState.Clear(); } return(Json("success", JsonRequestBehavior.AllowGet)); } }
public IHttpActionResult PutAttendence(int id, Attendence attendence) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != attendence.Id) { return(BadRequest()); } db.Entry(attendence).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!AttendenceExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
// GET: /Attendence/Details/5 public ActionResult Details(int?id) { try { if (Session["Email"] == null) { return(View("Login")); } if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Attendence attendenceregister = db.Attendence.Find(id); if (attendenceregister == null) { return(HttpNotFound()); } return(View(attendenceregister)); } catch (Exception e) { ViewBag.ERROR = e.Message.ToString(); return(View("ErrorPage")); } }
public static Attendence GetAttendenceByID(int id) { Attendence attendence = new Attendence(); SqlAttendenceProvider sqlAttendenceProvider = new SqlAttendenceProvider(); attendence = sqlAttendenceProvider.GetAttendenceByID(id); return attendence; }
public ActionResult createajax(string[] number1, string[] leave1, string[] reason1, string[] arrid1) { //return Content(number+" "+leave); bool[] checkbool = new bool[reason1.Length]; for (int i = 0; i < arrid1.Length; i++) { if (arrid1[i] == "1") { checkbool[i] = true; } else { checkbool[i] = false; } } Attendence at = new Attendence(); for (int i = 0; i < number1.Length; i++) { at.atten_leave_type_id = Convert.ToInt32(leave1[i]); at.atten_emp_id = Convert.ToInt32(number1[i]); at.atten_status = checkbool[i]; at.atten_reason = reason1[i]; at.atten_date = Convert.ToDateTime(DateTime.Now.ToShortDateString()); db.Attendences.Add(at); db.SaveChanges(); } return(Content(number1.Length.ToString())); }
public ActionResult GiveAttend(int id) { Attendence at = Atservice.Get(id); ; if (at.Date.ToString("dd.MM.yyy") == DateTime.Now.ToString("dd.MM.yyy")) { at.Attend = 0; Atservice.Update(at); } else { if (at.Attend == 0) { at.Attend = 1; at.AttendCounter++; at.Date = DateTime.Now; } else if (at.Attend == 1) { at.Attend = 0; at.AttendCounter--; } Atservice.Update(at); } return(RedirectToAction("Attendence", new { id = Convert.ToInt32(Session["AtID"]) })); }
public static void PostListOfAttendenceState(List <AttendenceViewModel> attendenceViewModel) { using (var context = new FinalSchool()) { var CN = attendenceViewModel[0].CourseName; var courseAtt = context.Courses.FirstOrDefault(x => x.Name == CN); var te = attendenceViewModel[0].TeacherSNN; Teacher teacher = context.Teachers.FirstOrDefault(x => x.TeacherId == te); var session = new Session { CourseId = courseAtt.CourseId, StartDate = DateTime.Now, TeacherId = teacher.TeacherId, }; context.Sessions.Add(session); context.SaveChanges(); foreach (var item in attendenceViewModel) { var attendence = new Attendence() { StudentId = item.StudentSNN, IsAttended = item.IsAttended, SessionId = session.SessionId, }; context.Attendences.Add(attendence); } context.SaveChanges(); } }
public static void ChangeAttendenceState(AttendenceViewModel attendenceViewModel) { using (var context = new FinalSchool()) { var studentAtt = context.Students.FirstOrDefault(x => x.StudentId == attendenceViewModel.StudentSNN); var courseAtt = context.Courses.FirstOrDefault(x => x.Name == attendenceViewModel.CourseName); var teacher = context.Teachers.FirstOrDefault(x => x.FName == attendenceViewModel.TeacherName); var session = new Session { Course = courseAtt, CourseId = courseAtt.CourseId, StartDate = DateTime.Now, Teacher = teacher, TeacherId = teacher.TeacherId, }; context.Sessions.Add(session); context.SaveChanges(); var attendence = new Attendence() { Student = studentAtt, StudentId = studentAtt.StudentId, IsAttended = attendenceViewModel.IsAttended, Session = session, SessionId = session.SessionId, }; context.Attendences.Add(attendence); context.SaveChanges(); } }
public bool updateAttendence(FormCollection collection, int id, Attendence atd) { try { string attendence = collection["present"]; atd.time_in_ = TimeSpan.Parse(collection["timeIn"]); atd.time_out = TimeSpan.Parse(collection["timeOut"]); if (attendence == "present") { atd.present = 1; atd.absent = 0; } else { atd.absent = 1; atd.present = 0; } db.SaveChanges(); return(true); } catch (Exception) { return(false); } }
// GET: Attendences/Edit/5 public ActionResult Edit(int id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Attendence attendence = db.GetAttendence(id); if (attendence == null) { return(HttpNotFound()); } ViewBag.StudentID = new SelectList((from student in db.GetStudent() select new { StudentID = student.StudentID, StudentName = student.FirstName + " " + student.LastName }), "StudentID", "StudentName", attendence.StudentID); ViewBag.TimetableID = new SelectList((from timetable in db.GetModuleTimetable() select new { TimetableID = timetable.TimeTableId, TimetableValue = timetable.ModuleName + " " + timetable.Day + " " + timetable.ClassStartTime + " " + timetable.ClassEndTime }), "TimetableID", "TimetableValue", attendence.TimetableID); return(View(attendence)); }
public IHttpActionResult PostParticipant(Attendence item /*, HttpPostedFileBase file*/) { //Dictionary<string, object> dict = new Dictionary<string, object>(); // string str = files(file); // item.Img = str; try { var httpRequest = HttpContext.Current.Request; item = repository.Add(item); repository.Save(); //var response = Request.CreateResponse<Attendence>(HttpStatusCode.Created, item); //string uri = Url.Link("DefaultApi", new { id = item.Id }); //response.Headers.Location = new Uri(uri); //return Ok(); var data = repository.GetAll(); if (data == null) { return(NotFound()); } return(Ok(data)); } catch { return(InternalServerError()); } }
public void MyCalendar_CalledCorrectly_ReturnListOfGigs() { var genre = _context.Genres.First(); var gig1 = new Gig(_user.Id, "-", DateTime.Now.AddDays(1), genre.Id); _context.Gigs.Add(gig1); var attendence1 = new Attendence { GigId = gig1.Id, AttendeeId = _user.Id }; _context.Attendences.Add(attendence1); _context.SaveChanges(); var gig2 = new Gig(_user.Id, "-", DateTime.Now.AddDays(2), genre.Id); _context.Gigs.Add(gig2); var attendence2 = new Attendence { GigId = gig2.Id, AttendeeId = _user.Id }; _context.Attendences.Add(attendence2); _context.SaveChanges(); var result = _controller.MyCalendar() as ViewResult; var viewModel = result.ViewData.Model as GigsViewModel; var list = viewModel.upcomingGigs; list.Should().HaveCount(2); }
public IHttpActionResult Attend(AttedenceDto dto) { #region Avoid Duplicate Attendence var attenderId = User.Identity.GetUserId(); var passedparam2 = dto.passedParam2; // just playing with passed param var passedparam3 = dto.passedParam3; // just playing with passed param //var attenderId = "50cbfce6-8cf3-4e17-a885-81375da81a43"; //for testing var isDuplicate = dbContext.Attendences.Any(a => a.AttenderId == attenderId && a.GigId == dto.GigId); if (isDuplicate) { return(BadRequest("You have already Attended This Gig")); } #endregion var attendence = new Attendence() { GigId = dto.GigId, AttenderId = User.Identity.GetUserId() //AttenderId = "52f143fb-381c-484c-af5e-ffcb562a51b7" //"50cbfce6-8cf3-4e17-a885-81375da81a43" }; dbContext.Attendences.Add(attendence); dbContext.SaveChanges(); return(Ok()); }
public async Task UpdateAttendance(string id, string name, System.DateTime date) { System.Console.WriteLine("Update Attedence: id:{0} date:{1}", id, date); var client = new HttpClient(); var attendence = new Attendence { Date = date.ToString("MMddyy"), Id = id, Name = name }; var url = CreateAttendenceApiUrl + id; var settings = new JsonSerializerSettings(); settings.ContractResolver = new LowercaseContractResolver(); var json = JsonConvert.SerializeObject(attendence, Formatting.Indented, settings); System.Console.WriteLine("updating :" + json); var result = await client.PostAsync(url, new StringContent(json, System.Text.Encoding.UTF8, "application/json")); System.Console.WriteLine(result.StatusCode); if (result.StatusCode != HttpStatusCode.OK) { throw new System.Exception("Error:" + result.RequestMessage); } await Task.FromResult(0); }
public ActionResult CheckAttend(Attendence att) { var user = db.user.SingleOrDefault(c => c.id == att.user_id); Appointments_ app = db.Appointments_.SingleOrDefault(c => c.id == att.app_id); if (user.count >= 3) { user.block = true; app.state = "blocked"; } else { if (att.check.Equals("0")) { app.state = "unatt"; user.count = user.count + 1; } else if (att.check.Equals("1")) { app.state = "att"; } } db.SaveChanges(); return(RedirectToAction("CheckAttend")); }
public ActionResult AddStudentToSection(StudentSection sec) { if (ModelState.IsValid) { STCservice.Insert(sec); Student ats = Stservice.Get(sec.StuId); Section sc = Sservice.Get(sec.SecId); Attendence ast = new Attendence(); ast.StudentId = ats.StuId; ast.SecId = sc.SecId; ast.Attend = 0; ast.AttendCounter = 0; int val = Convert.ToInt32(sc.CourseId); ast.CourseId = val; ast.Date = DateTime.Now; Atservice.Insert(ast); Grade gr = new Grade(); gr.SecId = sc.SecId; gr.StuId = ats.StuId; gr.grade = 0; grservice.Insert(gr); return(RedirectToAction("Index")); } else { return(View(sec)); } }
//Actions performed on log out public async Task <ActionResult> LogOut() { using (HttpClient httpclient = new HttpClient()) { Attendence attendence = new Attendence { Date = DateTime.Now.Date, Emp_Id = Session["id"].ToString(), LogOutTime = DateTime.Now.ToShortTimeString(), LogInTime = Session["LoginTime"].ToString() }; UriBuilder builder2 = new UriBuilder(ConfigurationManager.AppSettings["baseUrl"]); var json2 = JsonConvert.SerializeObject(attendence); var content2 = new StringContent(json2, Encoding.UTF8, "application/json"); var resultpost2 = await httpclient.PostAsync(builder2.Uri + "/UpdateAttendence", content2); if (resultpost2.IsSuccessStatusCode) { Session["username"] = null; Session["token"] = null; Session["role"] = null; Session["firstname"] = null; Session["dept"] = null; Session["id"] = null; Session["LoginTime"] = null; return(RedirectToAction("Index", "Home")); } else { return(RedirectToAction("Index", "LoggedIn")); } } }
public async Task <List <AttendenceInfoDto> > GetAttendenceInfoForInstructor(string lectureCode) { List <int> completedWeeks = await _attendenceRepository.GetCompletedAttendenceWeekInfo(lectureCode); List <AttendenceInfoDto> attendenceInfos = new List <AttendenceInfoDto>(); AttendenceImage attendenceImage; string image_url; for (int i = 1; i <= 14; i++) { Attendence attendence = new Attendence(); attendence.week = i; attendence.status = completedWeeks.Contains(i) ? AttendenceConstants.COMPLETED : AttendenceConstants.NOT_COMPLETED; attendenceImage = await _attendenceImageRepository.GetAttendenceImage(lectureCode, attendence.week); image_url = attendenceImage != null ? attendenceImage.image_url : null; attendenceInfos.Add(new AttendenceInfoDto(attendence, image_url)); } return(attendenceInfos); }
public JsonResult editAttendance(string id, string aDate, string presence) { int x = int.Parse(id); if (Request.IsAjaxRequest()) { FastAndEasyEntities db = new FastAndEasyEntities(); Attendence a = new Attendence(); a = db.Attendences.Find(x); a.Date = DateTime.Parse(aDate); if (presence == "-") { a.Reasonable = "No"; db.Entry(a).Property(at => at.Reasonable).IsModified = true; } a.Present = presence; db.Entry(a).Property(at => at.Date).IsModified = true; db.Entry(a).Property(at => at.Present).IsModified = true; db.SaveChanges(); ModelState.Clear(); return(new JsonResult { Data = " ", JsonRequestBehavior = JsonRequestBehavior.AllowGet }); } return(new JsonResult { Data = "error", JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }
// By Default int is expected in url not in body // so decorate it with [FromBody] // To avoid this, use DTOs public IHttpActionResult Attend(AttendeceDto dto) { var userId = User.Identity.GetUserId(); // Now we can use GetAttendence here & Delete method //if (_context.Attendences.Any( // a => a.AttendeeId == userId // && a.GigId == dto.GigId) // ) // return BadRequest("The attendence already exists"); if (_unitOfWork.Attendences.GetAttendence(userId, dto.GigId) != null) { return(BadRequest("The attendence already exists")); } Attendence attendence = new Attendence { GigId = dto.GigId, AttendeeId = userId }; _unitOfWork.Attendences.Add(attendence); _unitOfWork.Complete(); return(Ok()); }
public int Delete(int id) { Attendence f = this.context.Attendence.SingleOrDefault(x => x.AttId == id); this.context.Attendence.Remove(f); return(this.context.SaveChanges()); }
public ActionResult DeleteConfirmed(int id) { Attendence attendence = _dbContext.Attendences.Find(id); _dbContext.Attendences.Remove(attendence); _dbContext.SaveChanges(); return(RedirectToAction("Index")); }
// GET: Attendence/Delete/5 public ActionResult Delete(Attendence staffId) { var del = payroll.Attendences.Where(x => x.id == staffId.id).FirstOrDefault(); payroll.Attendences.Remove(del); payroll.SaveChanges(); return(RedirectToAction("Attendence")); }
public ActionResult Index() { int ab = Convert.ToInt32(Session["id"]); int bc = Convert.ToInt32(Session["Designation"]); if (ab != 0 && bc == 1) { //return View(db.Attendences.ToList()); System.DateTime todaydate = new System.DateTime(System.DateTime.Today.Ticks); DateTime date = Convert.ToDateTime(todaydate.ToString("dd/MM/yyyy")); //var Atteendancedate = db.Attendences.Where(y => y.AttendenceDate == date).FirstOrDefault(); List <Attendence> list = new List <Attendence>(); var attendanceinfo = db.Attendences.ToList(); foreach (var row in attendanceinfo) { DateTime att = Convert.ToDateTime(row.AttendenceDate); //var Atteendancedate = db.Attendences.Where(y => y.AttendenceDate == date).FirstOrDefault(); // sample s = new sample(); if (att == date) { Attendence a = new Attendence(); a.ClientId = Convert.ToInt32(row.ClientId); // a.Client.ClietName = db.Clients.FirstOrDefault(x => x.ClientId == a.ClientId).ClietName; a.EmployeeId = Convert.ToInt32(row.EmployeeId); a.FromTime = Convert.ToDateTime(row.FromTime); a.AttendenceStatus = Convert.ToBoolean(row.AttendenceStatus); a.AttendenceDate = Convert.ToDateTime(row.AttendenceDate); //Attendence.Add(a); //db.Attendences.Add(a); // list.Add(a); if (row.ClientId == null) { int empid = Convert.ToInt32(row.EmployeeId); Employee v = db.Employees.FirstOrDefault(y => y.EmployeeId == empid); a.Employee = v; // a.Employee.EmployeeName = v.EmployeeName; list.Add(a); } else { Client client = db.Clients.FirstOrDefault(x => x.ClientId == a.ClientId); a.Client = client; list.Add(a); } } } ViewBag.list = list; return(View()); } else { FormsAuthentication.SignOut(); return(RedirectToAction("Login", "Login")); } }
public IActionResult leave(int EventId) { int? _userId = HttpContext.Session.GetInt32("UserId"); Attendence leave = dbContext.Attendences.FirstOrDefault(a => a.EventId == EventId && a.UserId == (int)_userId); dbContext.Attendences.Remove(leave); dbContext.SaveChanges(); return(RedirectToAction("success")); }
public ActionResult Edit([Bind(Include = "AttendenceID,StudentID,TimetableID,Date,Condition")] Attendence attendence) { if (ModelState.IsValid) { db.UpdateAttendence(attendence); return(RedirectToAction("Index")); } return(View(attendence)); }
protected void btnLogin_Click(object sender, EventArgs e) { Attendence attendence = new Attendence(); attendence.UserID = ddlAccountingUser.SelectedValue; attendence.InOutTime = DateTime.Parse(txtInOutTime.Text); attendence.ExtraField1 = ""; attendence.ExtraFileld2 = ""; int resutl = AttendenceManager.InsertAttendence(attendence); }
protected void btnLogin_Click(object sender, EventArgs e) { Attendence attendence = new Attendence(); attendence.UserID = ddlAccountingUser.SelectedValue; attendence.InOutTime = DateTime.Parse(txtInOutTime.Text); int resutl = AttendenceManager.InsertAttendence(attendence); showAttendenceGrid(); btnViewReport_Click(this, new EventArgs()); }
protected void btnAdd_Click(object sender, EventArgs e) { Attendence attendence = new Attendence(); attendence.UserID = Int32.Parse(ddlUser.SelectedValue); attendence.InOutTime = txtInOutTime.Text; attendence.ExtraField1 = txtExtraField1.Text; attendence.ExtraFileld2 = txtExtraFileld2.Text; int resutl = AttendenceManager.InsertAttendence(attendence); Response.Redirect("AdminAttendenceDisplay.aspx"); }
protected void btnUpdate_Click(object sender, EventArgs e) { Attendence attendence = new Attendence(); attendence = AttendenceManager.GetAttendenceByID(Int32.Parse(Request.QueryString["attendenceID"])); Attendence tempAttendence = new Attendence(); tempAttendence.AttendenceID = attendence.AttendenceID; tempAttendence.UserID = Int32.Parse(ddlUser.SelectedValue); tempAttendence.InOutTime = txtInOutTime.Text; tempAttendence.ExtraField1 = txtExtraField1.Text; tempAttendence.ExtraFileld2 = txtExtraFileld2.Text; bool result = AttendenceManager.UpdateAttendence(tempAttendence); Response.Redirect("AdminAttendenceDisplay.aspx"); }
private void showAttendenceData() { Attendence attendence = new Attendence(); attendence = AttendenceManager.GetAttendenceByID(Int32.Parse(Request.QueryString["attendenceID"])); ddlUser.SelectedValue = attendence.UserID.ToString(); txtInOutTime.Text = attendence.InOutTime; txtExtraField1.Text = attendence.ExtraField1; txtExtraFileld2.Text = attendence.ExtraFileld2; }
protected void btnViewReport_Click(object sender, EventArgs e) { List<Attendence> attendences = new List<Attendence>(); List<Attendence> attendencesTimeDuration = new List<Attendence>(); attendences = AttendenceManager.GetAllAttendencesByUserID(ddlEmployee.SelectedValue); for (int i = 1; i < attendences.Count; i++) { if (((attendences[i].InOutTime.Subtract(attendences[i - 1].InOutTime).Days * 24 * 60) + (attendences[i].InOutTime.Subtract(attendences[i - 1].InOutTime).Hours * 60) + attendences[i].InOutTime.Subtract(attendences[i - 1].InOutTime).Minutes) < 1) { attendences.RemoveAt(i); i--; } } for (int i = 0; i < attendences.Count; i++) { Attendence newItem = new Attendence(); newItem = attendences[i]; newItem.InTime = attendences[i].InOutTime; while (true) { if (attendences.Count > ++i) { if (((attendences[i].InOutTime.Subtract(newItem.InTime).Days * 24 * 60) + (attendences[i].InOutTime.Subtract(newItem.InTime).Hours * 60) + attendences[i].InOutTime.Subtract(newItem.InTime).Minutes) > 1) { if (newItem.InTime.Date == attendences[i].InOutTime.Date) { newItem.OutTime = attendences[i].InOutTime; } else { newItem.OutTime = DateTime.Parse(newItem.InTime.ToShortDateString() + " 06:00:00 PM"); i--; } break; } } else { break; } } if (newItem.OutTime < DateTime.Parse("21 Feb 2012")) newItem.OutTime = DateTime.Parse(newItem.InTime.ToShortDateString() + " 06:00:00 PM"); newItem.Duration = (newItem.OutTime.Subtract(newItem.InTime).Hours * 60 * 60) + (newItem.OutTime.Subtract(newItem.InTime).Minutes * 60) +newItem.OutTime.Subtract(newItem.InTime).Seconds; //newItem.DurationDisplay = (newItem.OutTime - newItem.InTime).Hours.ToString() + " hour(s) : " + (newItem.OutTime - newItem.InTime).Minutes.ToString() + " Min(s)"; newItem.DurationDisplay = ((newItem.OutTime.Subtract(newItem.InTime).Days * 24 ) + (newItem.OutTime.Subtract(newItem.InTime).Hours)).ToString() +" hour(s) " + newItem.OutTime.Subtract(newItem.InTime).Minutes.ToString() + " Min"; attendencesTimeDuration.Add(newItem); } gvAttendencePerEmployee.DataSource = attendences; gvAttendencePerEmployee.DataBind(); int lastLateDuration = attendencesTimeDuration[0].Duration; int lastIndex = 0; attendencesTimeDuration[0].DateDisplay = attendencesTimeDuration[0].InTime.ToString("dd MMM yyyy"); for (int i = 1; i < attendencesTimeDuration.Count; i++) { if (attendencesTimeDuration[i - 1].InTime.ToShortDateString() != attendencesTimeDuration[i].InTime.ToShortDateString()) { lastIndex = i; attendencesTimeDuration[i].DateDisplay = attendencesTimeDuration[i].InTime.ToString("dd MMM yyyy"); lastIndex = i; } else { attendencesTimeDuration[lastIndex].Duration += attendencesTimeDuration[i].Duration; attendencesTimeDuration[i].DateDisplay = ""; } } for (int i = 0; i < attendencesTimeDuration.Count; i++) { if (attendencesTimeDuration[i].DateDisplay != "") { attendencesTimeDuration[i].DateDisplay += "-- [" + (attendencesTimeDuration[i].Duration / (60 * 60)).ToString() + " Hour(s) " + ((attendencesTimeDuration[i].Duration % (60 * 60)) / 60).ToString() + " Min(s)]"; } } gvAttendenceDuration.DataSource = attendencesTimeDuration; gvAttendenceDuration.DataBind(); }
public static int InsertAttendence(Attendence attendence) { SqlAttendenceProvider sqlAttendenceProvider = new SqlAttendenceProvider(); return sqlAttendenceProvider.InsertAttendence(attendence); }
public static bool UpdateAttendence(Attendence attendence) { SqlAttendenceProvider sqlAttendenceProvider = new SqlAttendenceProvider(); return sqlAttendenceProvider.UpdateAttendence(attendence); }
public Attendence GetAttendenceFromReader(IDataReader reader) { try { Attendence attendence = new Attendence ( (int)reader["AttendenceID"], reader["UserID"].ToString(), (DateTime)reader["InOutTime"] ); try { attendence.UserName = reader["UserName"].ToString(); } catch(Exception ex) { } try { attendence.ID = reader["EmployeeID"].ToString(); } catch (Exception ex) { } return attendence; } catch(Exception ex) { return null; } }
public int InsertAttendence(Attendence attendence) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("COMN_InsertAttendence", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@AttendenceID", SqlDbType.Int).Direction = ParameterDirection.Output; cmd.Parameters.AddWithValue("@UserID", attendence.UserID ); cmd.Parameters.Add("@InOutTime", SqlDbType.DateTime).Value = attendence.InOutTime; connection.Open(); int result = cmd.ExecuteNonQuery(); return (int)cmd.Parameters["@AttendenceID"].Value; } }
public bool UpdateAttendence(Attendence attendence) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("COMN_UpdateAttendence", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@AttendenceID", SqlDbType.Int).Value = attendence.AttendenceID; cmd.Parameters.AddWithValue("@UserID", attendence.UserID); cmd.Parameters.Add("@InOutTime", SqlDbType.DateTime).Value = attendence.InOutTime; connection.Open(); int result = cmd.ExecuteNonQuery(); return result == 1; } }