public async Task <IActionResult> DeleteAdmin(int id) { var people = await _context.People.FindAsync(id); _context.People.Remove(people); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(AdminTable))); }
public async Task <IActionResult> Create([Bind("Id,Name,Password,Role,Tel,Email")] People people) { if (ModelState.IsValid) { _context.Add(people); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(people)); }
public async Task <IActionResult> DeleteAdmin(int id) { if (HttpContext.Session.GetString("Session_Role") == veryrole) { var people = await _context.People.FindAsync(id); _context.People.Remove(people); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(AdminTable))); } else { return(RedirectToAction("Index", "Home")); } }
public async Task <IActionResult> AddAttendance([FromBody] List <Attendance> attendance) { var result = attendance.Count(); var attendance_record = _context.Attendance.Where(e => e.EmployeeId == attendance[0].EmployeeId); var date = attendance_record.Select(a => a.Date.ToShortDateString()).ToList(); var empId = attendance[0].EmployeeId; foreach (var a in attendance) { var input_date = a.Date.AddDays(1).Date; if (date.Contains(input_date.ToShortDateString())) { Debug.WriteLine($"This part run {input_date}"); var update_row = await attendance_record.FirstAsync(r => r.Date.Date == input_date); update_row.Status = a.Status; await _context.SaveChangesAsync(); } else { a.Date = a.Date.AddDays(1); _context.Add(a); await _context.SaveChangesAsync(); } } return(Json(result)); }
public async Task <IActionResult> AddAttendance([FromBody] List <Attendance> attendance) { var result = attendance.Count(); var date_in_context = await _context.Attendance.Select(a => a.Date.ToShortDateString()).ToListAsync(); foreach (var a in attendance) { if (date_in_context.Contains(a.Date.AddDays(1).ToShortDateString())) { DateTime dt; var date = DateTime.TryParse(a.Date.AddDays(1).ToShortDateString(), out dt); Debug.WriteLine("This date is already exists"); Debug.WriteLine($"Record {date} {a.Status} {a.EmployeeId}"); var exist_record = await _context.Attendance.FirstAsync(r => r.EmployeeId == a.EmployeeId && r.Date == dt); exist_record.Status = a.Status; Debug.WriteLine($"Existing record {exist_record.EmployeeId} {exist_record.Date} {exist_record.Status}"); } else { a.Date = a.Date.AddDays(1); _context.Add(a); } await _context.SaveChangesAsync(); a.Date = a.Date.AddDays(1); } return(Json(result)); }
public async Task <IActionResult> AddAttendance([FromBody] List <Attendance> attendance) { var result = attendance.Count(); foreach (var a in attendance) { _context.Add(a); await _context.SaveChangesAsync(); } return(Json(result)); }