public ActionResult Create(Attendance attendance) { if (ModelState.IsValid) { db.Attendances.AddObject(attendance); db.SaveChanges(); return RedirectToAction("Index"); } ViewBag.EmployeeId = new SelectList(db.Employees, "EmployeeId", "Name", attendance.EmployeeId); return View(attendance); }
public ActionResult Edit(Attendance attendance) { if (ModelState.IsValid) { db.Attendances.Attach(attendance); db.ObjectStateManager.ChangeObjectState(attendance, EntityState.Modified); db.SaveChanges(); return RedirectToAction("Index"); } ViewBag.EmployeeId = new SelectList(db.Employees, "EmployeeId", "Name", attendance.EmployeeId); return View(attendance); }
/// <summary> /// Create a new Attendance object. /// </summary> /// <param name="id">Initial value of the Id property.</param> /// <param name="date">Initial value of the Date property.</param> /// <param name="employeeId">Initial value of the EmployeeId property.</param> /// <param name="status">Initial value of the Status property.</param> public static Attendance CreateAttendance(global::System.Int32 id, global::System.DateTime date, global::System.Int32 employeeId, global::System.String status) { Attendance attendance = new Attendance(); attendance.Id = id; attendance.Date = date; attendance.EmployeeId = employeeId; attendance.Status = status; return attendance; }
public ActionResult Update(FormCollection collection) { int id = Int32.Parse(Session["LogedUserId"].ToString()); var leaveRequests = db.LeaveRequests.Include(c => c.Employee).Where(c => c.Employee.ManagerId == id); foreach (LeaveRequest leaveRequest in leaveRequests) { string status = (string)collection.Get("status" + leaveRequest.Id); Console.WriteLine("Status" + status); System.Diagnostics.Debug.WriteLine("Status :" + status); if (status != null) { if (status.Equals("No")) { leaveRequest.Status = "Disapproved"; } else if (status.Equals("Yes")) { leaveRequest.Status = "Approved"; for (DateTime d = leaveRequest.FromDate; d <= leaveRequest.ToDate; d=d.AddDays(1)) { Attendance att = new Attendance(); att.EmployeeId = leaveRequest.Employee_Id; if(leaveRequest.TypeOfLeave.Contains("Sick")){ Leave leave = db.Leaves.Where(l => l.EmployeeId == att.EmployeeId).FirstOrDefault(); if (leave.SickLeaves > 0) { att.Status = "SickLeave"; } leave.SickLeaves--; } else if(leaveRequest.TypeOfLeave.Contains("casual")){ Leave leave = db.Leaves.Where(l => l.EmployeeId == att.EmployeeId).FirstOrDefault(); if (leave.CasualLeaves > 0) { att.Status = "CasualLeave"; } leave.CasualLeaves--; } else if (leaveRequest.TypeOfLeave.Contains("Optional")) { Leave leave = db.Leaves.Where(l => l.EmployeeId == att.EmployeeId).FirstOrDefault(); if (leave.CasualLeaves > 0) { att.Status = "OptionalLeave"; } leave.OptionalHolidays--; } else { att.Status = "Absent"; } att.Date = d; db.Attendances.AddObject(att); } } } //AMSEntities newCtx = new AMSEntities(); //newCtx.LeaveRequests.Attach(leaveRequest); //newCtx.ObjectStateManager.ChangeObjectState(leaveRequest, EntityState.Modified); } db.SaveChanges(); return RedirectToAction("Index"); }
/// <summary> /// Deprecated Method for adding a new object to the Attendances EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddToAttendances(Attendance attendance) { base.AddObject("Attendances", attendance); }