public ContentResult AddAll(FormCollection form) { // add new attendance row for all employees JObject json = new JObject(); json["error"] = false; json["message"] = ""; string[] keys = new string[] { "v" }; int count = 0; if (this.HasValues(form, keys)) { if (!this.CheckLogin(AccountType.Applicant) && ((Employee)this.GetAccount().Profile).Department.Type == DepartmentType.HumanResources) { try { DBHandler db = new DBHandler(); using (DataTable dt = db.Execute <DataTable>( CRUD.READ, "SELECT Profile FROM Account WHERE Type = " + ((int)AccountType.Employee) + " OR Type = " + ((int)AccountType.DepartmentHead))) { foreach (DataRow row in dt.Rows) { Employee emp = new Employee(Int32.Parse(row["Profile"].ToString())); Attendance at = new Attendance(); try { at = new Attendance().Find(emp.EmployeeID, DateTime.Now, recursive: false, byPrimary: false); } catch (Exception e) { at.Absent = 0; at.Late = 0; at.Leave = emp.GetNumLeaves(DateTime.Now); at.Overtime = 0; at.Present = 0; at.Undertime = 0; at.Date = DateTime.Now; at.Employee = emp; if (String.IsNullOrEmpty(form.GetValue("v").AttemptedValue)) { throw new Exception("Form is incomplete"); } at.TotalWorkingDays = Int32.Parse(form.GetValue("v").AttemptedValue); at.Create(); count++; } } json["message"] = "Successfully create Attendance rows for " + count + " employees"; } } catch (Exception e) { json["error"] = true; json["message"] = e.Message; } } else { json["error"] = true; json["message"] = "You are not authorized to continue"; } } else { json["error"] = true; json["message"] = "Form is incomplete"; } return(Content(json.ToString(), "application/json")); }
public ContentResult AddAttendance(FormCollection form) { // add new attendance row for an employee JObject json = new JObject(); json["error"] = false; json["message"] = ""; string[] keys = new string[] { "id", "v" }; if (this.HasValues(form, keys)) { if (!this.CheckLogin(AccountType.Applicant) && ((Employee)this.GetAccount().Profile).Department.Type == DepartmentType.HumanResources) { try { if (String.IsNullOrEmpty(form.GetValue("id").AttemptedValue)) { throw new Exception("Form is incomplete"); } Employee emp = new Employee(Int32.Parse(form.GetValue("id").AttemptedValue), true); Attendance at = new Attendance(); try { at = new Attendance().Find(emp.EmployeeID, DateTime.Now, recursive: false, byPrimary: false); } catch (Exception e) { at.Absent = 0; at.Late = 0; at.Overtime = 0; at.Present = 0; at.Undertime = 0; at.Date = DateTime.Now; at.Employee = emp; at.Leave = emp.GetNumLeaves(DateTime.Now); if (String.IsNullOrEmpty(form.GetValue("v").AttemptedValue)) { throw new Exception("Form is incomplete"); } at.TotalWorkingDays = Int32.Parse(form.GetValue("v").AttemptedValue); at.Create(); json["message"] = "Successfully created Attendance row for: <b>" + emp.Profile.FirstName + " " + emp.Profile.LastName + "</b>"; } } catch (Exception e) { json["error"] = true; json["message"] = e.Message; } } else { json["error"] = true; json["message"] = "You are not authorized to continue"; } } else { json["error"] = true; json["message"] = "Form is incomplete"; } return(Content(json.ToString(), "application/json")); }