public EmployeeService(EMPLOYEE item) { _item = item; }
private void InitialDataPopup() { var cmd = new DepartmentService(); var list = cmd.GetALL(); foreach (var item in list) { ddlDepartment.Items.Add(new ListItem(item.DEPARTMENT_NAME, item.DEPARTMENT_ID.ToString())); } if (ViewState["empId"] != null) { var cmdEmp = new EmployeeService(); _employee = cmdEmp.Select(Convert.ToInt32(ViewState["empId"].ToString())); if (_employee != null) { popTxtEmployeeCode.Text = _employee.EMPLOYEE_CODE; txtName.Text = _employee.EMPLOYEE_NAME; txtLastName.Text = _employee.EMPLOYEE_SURNAME; ddlDepartment.SelectedValue = _employee.DEPARTMENT_ID.ToString(); flag.Text = "Edit"; } var cmdFunc = new ZoneDetailService(); DataSouceRoleFunction = cmdFunc.GetALLInclude(_employee.EMPLOYEE_ID); } else { DataSouceRoleFunction = new List<ZONE_DETAIL>(); } DataSouceRoleFunction.AddRange(DataSouceNewRoleFunction); gridZone.DataSource = DataSouceRoleFunction; gridZone.DataBind(); }
public List<EMPLOYEE> GetALL(EMPLOYEE item) { using (var ctx = new SPWEntities()) { var list = ctx.EMPLOYEE.Where(x => x.EMPLOYEE_CODE.Contains(item.EMPLOYEE_CODE) && x.SYE_DEL == true).ToList(); return list; } }
protected void btnSave_Click(object sender, EventArgs e) { var obj = new EMPLOYEE(); obj.DEPARTMENT_ID = Convert.ToInt32(ddlDepartment.SelectedValue); obj.EMPLOYEE_CODE = popTxtEmployeeCode.Text; obj.EMPLOYEE_NAME = txtName.Text; obj.EMPLOYEE_SURNAME = txtLastName.Text; var cmd = new EmployeeService(obj); if (flag.Text.Equals("Add")) { obj.Action = ActionEnum.Create; obj.CREATE_DATE = DateTime.Now; obj.CREATE_EMPLOYEE_ID = 0; obj.UPDATE_DATE = DateTime.Now; obj.UPDATE_EMPLOYEE_ID = 0; obj.SYE_DEL = true; cmd.Add(); } else { obj.Action = ActionEnum.Update; obj.EMPLOYEE_ID = Convert.ToInt32(ViewState["empId"].ToString()); obj.UPDATE_DATE = DateTime.Now; obj.UPDATE_EMPLOYEE_ID = 0; obj.SYE_DEL = true; cmd.Edit(); } ViewState["empId"] = null; Response.Redirect("SearchEmployee.aspx"); }