private static void SetModelData(EmployeeModel model) { model.DeptList = DeptDAO.QueryAll(); model.EmployeeList = EmployeeDAO.QueryAll(); model.EmpDeptList = EmployeeDAO.QueryAllInfo(); model.Datas = EmployeeDAO.QueryAllDicInfo(); }
protected void Page_Load(object sender, EventArgs e) { User currentUser = (User)Session["currentUser"]; if (currentUser != null) { Boolean superuser = false; foreach (string s in currentUser.getRoles()) { if (s.Equals("superuser")) { superuser = true; } } if (superuser) { if (!IsPostBack) { DeptDAO depdao = new DeptDAO(); List <Department> deps = depdao.getAllDepartment(); foreach (Department d in deps) { if (d.getDeptName().ToLower().Equals("hr")) { lblDept.Items.Add(new ListItem("Human Resource", d.getDeptName())); } else { lblDept.Items.Add(new ListItem(System.Globalization.CultureInfo.CurrentCulture.TextInfo.ToTitleCase(d.getDeptName().ToLower()), d.getDeptName())); } } UserDAO udao = new UserDAO(); ArrayList sups = udao.get_supervisors(); foreach (User supervisor in sups) { ddlSup.Items.Add(supervisor.getName()); } } else { txtPassword.Attributes["value"] = txtPassword.Text; txtPassword2.Attributes["value"] = txtPassword2.Text; } } else { Response.Redirect("errorPage.aspx"); } } else { Response.Redirect("login.aspx"); } }
public ActionResult Modify(DeptModel model) { try { DeptDAO.Modify(model.Dept); model.Message = "修改部门信息成功"; } catch (Exception ex) { model.Message = ex.Message; } return(View("ToModify", model)); }
public ActionResult Modify(EmployeeModel model) { try { EmployeeDAO.Modify(model.Employee); model.Message = "修改员工信息成功."; } catch (Exception ex) { model.Message = ex.Message; } model.DeptList = DeptDAO.QueryAll(); return(View("ToModify", model)); }
public ActionResult Index() { DeptModel model = new DeptModel(); try { model.DeptList = DeptDAO.QueryAll(); } catch (Exception ex) { model.DeptList = new List <TblDept>(); model.Message = ex.Message; } return(View(model)); }
public ActionResult Delete(DeptModel model) { try { DeptDAO.Delete(model.Dept.DeptId); model.Message = "删除部门信息成功"; } catch (Exception ex) { model.Message = ex.Message; } model.DeptList = DeptDAO.QueryAll(); return(View("Index", model)); }
public ActionResult Add(DeptModel model) { try { DeptDAO.Add(model.Dept); model.Message = "保存部门信息成功"; } catch (Exception ex) { model.Message = ex.Message; } model.DeptList = DeptDAO.QueryAll(); return(View("Index", model)); }
protected void Page_Load(object sender, EventArgs e) { User currentUser = (User)Session["currentUser"]; if (currentUser == null) { Response.Redirect("login.aspx"); } Boolean super = false; Boolean cc = false; foreach (string role in currentUser.getRoles()) { if (role.Equals("superuser")) { super = true; } if (role.Equals("content creator")) { cc = true; } } if (!cc) { if (!super) { Response.Redirect("errorPage.aspx"); } } if (!IsPostBack) { DeptDAO depdao = new DeptDAO(); List <Department> deps = depdao.getAllDepartment(); foreach (Department d in deps) { if (d.getDeptName().ToLower().Equals("hr")) { ddlDept.Items.Add(new ListItem("Human Resource", d.getDeptName())); } else { ddlDept.Items.Add(new ListItem(System.Globalization.CultureInfo.CurrentCulture.TextInfo.ToTitleCase(d.getDeptName().ToLower()), d.getDeptName())); } //ddlDept.Items.Add(new ListItem(System.Globalization.CultureInfo.CurrentCulture.TextInfo.ToTitleCase(d.getDeptName().ToLower()), d.getDeptName())); } } }
protected void Page_Load(object sender, EventArgs e) { if (Session["currentUser"] == null) { Response.Redirect("Login.aspx"); } else { User currentUser = (User)Session["currentUser"]; Boolean authenticate = authenticateAccess(currentUser); if (!authenticate) { Response.Redirect("errorPage.aspx"); } else { if (!IsPostBack) { DeptDAO depdao = new DeptDAO(); List <Department> deps = depdao.getAllDepartment(); foreach (Department d in deps) { if (d.getDeptName().ToLower().Equals("hr")) { lblDept.Items.Add(new ListItem("Human Resource", d.getDeptName())); } else { lblDept.Items.Add(new ListItem(System.Globalization.CultureInfo.CurrentCulture.TextInfo.ToTitleCase(d.getDeptName().ToLower()), d.getDeptName())); } //lblDept.Items.Add(new ListItem(System.Globalization.CultureInfo.CurrentCulture.TextInfo.ToTitleCase(d.getDeptName().ToLower()), d.getDeptName())); } string id = Request.QueryString["id"]; int id_num = Convert.ToInt32(id); ContactDAO adao = new ContactDAO(); a = adao.getContactById(id_num); txtName.Text = a.name; lblDept.SelectedValue = a.department; txtEmail.Text = a.email; txtRemarks.Text = a.remarks; } } } }
public ActionResult ToModify(DeptModel model) { try { model.Dept = DeptDAO.QueryByKey(model.Dept); if (model.Dept == null) { model.Message = "修改的数据不存在。"; model.DeptList = DeptDAO.QueryAll(); return(View("Index", model)); } return(View(model)); } catch (Exception ex) { model.Message = ex.Message; model.DeptList = DeptDAO.QueryAll(); return(View("Index", model)); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { DeptDAO depdao = new DeptDAO(); List <Department> deps = depdao.getAllDepartment(); foreach (Department d in deps) { lblDept.Items.Add(new ListItem(System.Globalization.CultureInfo.CurrentCulture.TextInfo.ToTitleCase(d.getDeptName().ToLower()), d.getDeptName())); } UserDAO udao = new UserDAO(); ArrayList sups = udao.get_supervisors(); foreach (User supervisor in sups) { ddlSup.Items.Add(supervisor.getName()); } } else { txtPassword.Attributes["value"] = txtPassword.Text; txtPassword2.Attributes["value"] = txtPassword2.Text; } }
protected void Page_Load(object sender, EventArgs e) { if (Session["currentUser"] == null) { Response.Redirect("Login.aspx"); } else { if (!IsPostBack) { User currentUser = (User)Session["currentUser"]; TNFDAO tnfDAO = new TNFDAO(); UserDAO userDAO = new UserDAO(); NotificationDAO notificationDAO = new NotificationDAO(); int notificationID = Convert.ToInt32(Request.QueryString["n"]); Notification currentNotification = notificationDAO.getNotificationByID(notificationID); if (currentNotification == null || !currentNotification.getUserIDTo().Equals(currentUser.getUserID())) { Response.Redirect("errorPage.aspx"); } TNF currentTNF = tnfDAO.getIndividualTNFByID(currentNotification.getUserIDFrom(), currentNotification.getTNFID()); User applicant = userDAO.getUserByID(currentNotification.getUserIDFrom()); Course courseApplied = tnfDAO.getCourseFromTNF(currentNotification.getTNFID()); Lesson lessonApplied = tnfDAO.getLessonFromTNF(currentNotification.getTNFID()); TNFData tnfData = tnfDAO.getIndividualTNFDataByID(currentNotification.getTNFID()); Workflow currentWorkflow = currentTNF.getWorkflow(); int probationPeriod = currentWorkflow.getProbationPeriod(); TimeSpan ts = currentTNF.getApplicationDate().Subtract(applicant.getStartDate()); //show warning if overseas, probation, > 10000 if (courseApplied.getPrice() > 10000) { warningPanelPrice.Visible = true; lblWarningPrice.Visible = true; lblWarningPrice.Text = "This course is over $10,000"; } if (courseApplied.getOverseas().ToLower().Equals("y")) { warningPanelOverseas.Visible = true; lblWarningOverseas.Visible = true; lblWarningOverseas.Text = "This course is an overseas course"; } if (ts.TotalDays < probationPeriod) { warningPanelProbation.Visible = true; lblWarningProbation.Visible = true; probationDate.Enabled = true; lblWarningProbation.Text = "Applicant is under probation"; } //setting user information nameOfStaffOutput.Text = applicant.getName(); employeeNumberOutput.Text = applicant.getUserID(); emailOutput.Text = applicant.getEmail(); designationOutput.Text = applicant.getJobTitle(); departmentOutput.Text = applicant.getDepartment(); //setting course and lesson information courseOutput.Text = courseApplied.getCourseName(); startDate.Text = lessonApplied.getStartDate().ToString("d MMM yyyy"); endDate.Text = lessonApplied.getEndDate().ToString("d MMM yyyy"); startTime.Text = lessonApplied.getStartTime().ToString(); endTime.Text = lessonApplied.getEndTime().ToString(); venueOutput.Text = lessonApplied.getVenue(); instructorOutput.Text = lessonApplied.getInstructor(); string internalOrExternal = courseApplied.getInternalOrExternal(); if (internalOrExternal.ToLower().Equals("internal")) { inhouse.Checked = true; external.Checked = false; lblExternal.Visible = false; externalCourseProviderOutput.Visible = false; } else { inhouse.Checked = false; external.Checked = true; lblExternal.Visible = true; externalCourseProviderOutput.Visible = true; externalCourseProviderOutput.Text = courseApplied.getCourseProvider(); } courseFeeOutput.Text = "$" + courseApplied.getPrice(); //setting tnf data information string prepareForNewJobRole = tnfData.getPrepareForNewJobRole(); if (prepareForNewJobRole.Equals("y")) { objectiveInput1.Checked = true; objectiveElaborate1.Text = tnfData.getPrepareForNewJobRoleText(); completeDateOutput1.Text = tnfData.getPrepareForNewJobRoleCompletionDate().Value.ToString("MM-dd-yyyy"); } else { objectiveInput1.Checked = false; objectiveElaborate1.Text = "-"; completeDateOutput1.Text = "-"; } string shareKnowledge = tnfData.getShareKnowledge(); if (shareKnowledge.Equals("y")) { objectiveInput2.Checked = true; objectiveElaborate2.Text = tnfData.getShareKnowledgeText(); completeDateOutput2.Text = tnfData.getShareKnowledgeCompletionDate().Value.ToString("MM-dd-yyyy"); } else { objectiveInput2.Checked = false; objectiveElaborate2.Text = "-"; completeDateOutput2.Text = "-"; } string otherObjectives = tnfData.getOtherObjectives(); if (otherObjectives.Equals("y")) { objectiveInput3.Checked = true; objectiveElaborate3.Text = tnfData.getOtherObjectivesText(); completionDateOutput3.Text = tnfData.getOtherObjectivesCompletionDate().Value.ToString("MM-dd-yyyy"); } else { objectiveInput3.Checked = false; objectiveElaborate3.Text = "-"; completionDateOutput3.Text = "-"; } //all HR will view HR approval section if (currentUser.getJobCategory().Equals("hr")) { hrApprovalView.Visible = true; BondDAO bondDAO = new BondDAO(); DeptDAO deptDAO = new DeptDAO(); Bonds checkBond = bondDAO.getBondByTNFIDandUserID(currentTNF.getTNFID(), applicant.getUserID()); Department currentDept = deptDAO.getDeptByName(applicant.getDepartment()); lbl_HR.Text = "Is HR"; rfv_trainingCost.Enabled = true; rfv_mspBondDuration.Enabled = true; if (checkBond != null) { rbtnBond.Checked = true; rbtnMSP.Enabled = false; rbtnNA.Enabled = false; mspBondDuration.Text = string.Empty; mspBondDuration.Enabled = true; } else { rbtnBond.Checked = false; rbtnBond.Enabled = false; } costcentre.Text = currentDept.getCostCentre().ToString(); double balance = currentDept.getActualBudget() - courseApplied.getPrice(); trainingBudgetBal.Text = balance.ToString(); trainingBudgetDate.Text = DateTime.Now.ToString("MM/dd/yyyy"); } else { lbl_HR.Text = "Is not HR"; rfv_trainingCost.Enabled = false; rfv_mspBondDuration.Enabled = false; } } } }
public long SaveDepartment(DeptDTO ObjDeptDTO) { IDeptDAO _IDeptDAO = new DeptDAO(); return(_IDeptDAO.SaveDepartment(ObjDeptDTO)); }
public List <DeptDTO> GetDepartment(int DeptId) { IDeptDAO _IDeptDAO = new DeptDAO(); return(_IDeptDAO.GetDepartment(DeptId)); }
public List <DeptDTO> GetDeptList() { IDeptDAO _IDeptDAO = new DeptDAO(); return(_IDeptDAO.GetDeptList()); }
public ActionResult ToModify(EmployeeModel model) { model.Employee = EmployeeDAO.QueryByKey(model.Employee); model.DeptList = DeptDAO.QueryAll(); return(View(model)); }
protected void Page_Load(object sender, EventArgs e) { //hp = new Dictionary<string, string>(); if (Session["currentUser"] == null) { Response.Redirect("Login.aspx"); } else { User currentUser = (User)Session["currentUser"]; Boolean superuser = false; foreach (string s in currentUser.getRoles()) { if (s.Equals("superuser")) { superuser = true; } } if (!superuser) { Response.Redirect("errorPage.aspx"); } if (!IsPostBack) { UserDAO udao = new UserDAO(); string userID = Request.QueryString["userID"]; if (userID == null || userID.Equals("")) { Response.Redirect("errorPage.aspx"); } User toChange = udao.getUserByID(userID); ArrayList roles = udao.getRolesByID(userID); txtUsername.Text = toChange.getUserID(); txtName.Text = toChange.getName(); txtAddress.Text = toChange.getAddress(); txtContactNo.Text = toChange.getContact(); //txtDept.Text = toChange.getDepartment(); DeptDAO depdao = new DeptDAO(); List <Department> deps = depdao.getAllDepartment(); foreach (Department d in deps) { if (d.getDeptName().ToLower().Equals("hr")) { lblDept.Items.Add(new ListItem("Human Resource", d.getDeptName())); } else { lblDept.Items.Add(new ListItem(System.Globalization.CultureInfo.CurrentCulture.TextInfo.ToTitleCase(d.getDeptName().ToLower()), d.getDeptName())); } } lblDept.SelectedValue = toChange.getDepartment(); // find supervisor List <User> allSupervisorForDept = udao.getAllUsersByDept(toChange.getDepartment()); ddlSup.Items.Add(new ListItem("--select--", "none")); foreach (User u in allSupervisorForDept) { ddlSup.Items.Add(new ListItem(u.getName(), u.getName())); } foreach (ListItem li in ddlSup.Items) { string supid = toChange.getSupervisor(); User u = udao.getUserByID(supid); if (u == null) { u = udao.getUserByID("admin"); } if (li.Text.Equals(u.getName())) { ddlSup.SelectedValue = li.Text; } } txtJobTitle.Text = toChange.getJobTitle(); txtEmail.Text = toChange.getEmail(); foreach (ListItem item in cblRoles.Items) { foreach (string s in roles) { if (item.Value.Equals(s)) { item.Selected = true; } } } } } }