public static EmployeeEN SearchEmp(int id) { StringBuilder sql = new StringBuilder(); sql.AppendLine("select * from dbo.Employees"); sql.AppendLine("where id = " + id); DataTable dt = ClassMain.ExecuteComandTable(sql.ToString()); EmployeeEN en = new EmployeeEN(); if (dt.Rows.Count > 0) { DataRow dr = (DataRow)dt.Rows[0]; en.ID = Convert.ToInt32(dr["id"]); en.Emp_id = Convert.ToString(dr["Emp_id"]); en.AccName = Convert.ToString(dr["AccName"]); en.AccNo = Convert.ToString(dr["AccNo"]); en.Firstname = Convert.ToString(dr["Firstname"]); en.Lastname = Convert.ToString(dr["Lastname"]); en.Nickname = Convert.ToString(dr["Nickname"]); en.Phone = Convert.ToString(dr["Phone"]); en.IdenNumber = Convert.ToString(dr["IdenNumber"]); en.Address = Convert.ToString(dr["Address"]); en.Email = Convert.ToString(dr["Email"]); en.salary = (Decimal)dr["salary"]; en.BirthDate = Convert.ToDateTime(Utilities.SetDefaultValue(dr["BirthDate"], DateTime.MinValue)); en.StartWorkDate = Convert.ToDateTime(Utilities.SetDefaultValue(dr["StartWorkDate"], DateTime.MinValue)); en.DeptId = Convert.ToInt16(Utilities.SetDefaultValue(dr["DeptId"], 0)); } return(en); }
private void setControl(EmployeeEN en) { txtFirstName.Text = en.Firstname; txtLastName.Text = en.Lastname; txtNickname.Text = en.Nickname; txtIdenNo.Text = en.IdenNumber; txtAccNo.Text = en.AccNo; txtAccName.Text = en.AccName; txtAddress.Text = en.Address; txtPhone.Text = en.Phone; txtEmail.Text = en.Email; txtStartWotk_Date.Text = Utilities.FormatStringDDMMYYY(en.StartWorkDate); txtBirthDay.Text = Utilities.FormatStringDDMMYYY(en.BirthDate); txtAge.Text = Convert.ToString((DateTime.Now.Date.Year - en.BirthDate.Date.Year)); if (en.DeptId != 0) { ddlDept.SelectedItem.Value = Convert.ToString(en.DeptId); } txtSalary.Text = en.salary.ToString(); }
private void Save() { ResultEN res = new ResultEN(); EmployeeEN en = new EmployeeEN(); switch (mode) { case "add": SetItem(en); res = ClassEmployee.Insert(en); break; case "edit": en = this.Selected; SetItem(en); res = ClassEmployee.Update(en); break; default: break; } //if (mode == "add") //{ // EmployeeEN en = new EmployeeEN(); // SetItem(en); // res = ClassEmployee.Insert(en); //} //else //{ // EmployeeEN en = this.Selected; // SetItem(en); // res = ClassEmployee.Update(en); //} if (res.result) { MessageShow("บันทึกเรียบร้อยแล้ว"); BindGrid(); SetDefult(); this.SelectedItem = null; } }
public static ResultEN Update(EmployeeEN en) { ResultEN res = new ResultEN(); List <ClassFieldValue> fields = new List <ClassFieldValue>(); fields.Add(new ClassFieldValue("UpdatedBy", HttpContext.Current.User.Identity.Name)); fields.Add(new ClassFieldValue("UpdatedDate", DateTime.Now)); SetField(fields, en); List <ClassFieldValue> fieldscon = new List <ClassFieldValue>(); fieldscon.Add(new ClassFieldValue("Emp_id", en.Emp_id)); res = ClassMain.Update(tb_name, fields, fieldscon); return(res); }
private void SetItem(EmployeeEN en) { en.Firstname = txtFirstName.Text; en.Lastname = txtLastName.Text; en.Nickname = txtNickname.Text; en.IdenNumber = txtIdenNo.Text; en.AccNo = txtAccNo.Text; en.AccName = txtAccNo.Text; en.Address = txtAddress.Text; en.StartWorkDate = Utilities.ConvertoDate(txtStartWotk_Date.Text); en.BirthDate = Utilities.ConvertoDate(txtBirthDay.Text); en.Phone = txtPhone.Text; en.Email = txtEmail.Text; // en.position = ""; en.salary = Utilities.ConvertToDecimal(txtSalary.Text); // Convert.ToDecimal( txtSalary.Text); en.DeptId = Convert.ToInt16(ddlDept.SelectedValue); }
public static ResultEN Insert(EmployeeEN en) { ResultEN res = new ResultEN(); // Gen Employee code System.Globalization.CultureInfo cultureinfo = new System.Globalization.CultureInfo("en-US"); string code = "E" + DateTime.Now.Date.Year.ToString(cultureinfo); string runno = GetRunno(); code += runno; List <ClassFieldValue> fields = new List <ClassFieldValue>(); fields.Add(new ClassFieldValue("Emp_id", code)); fields.Add(new ClassFieldValue("CreatedBy", HttpContext.Current.User.Identity.Name)); fields.Add(new ClassFieldValue("CreatedDate", DateTime.Now)); SetField(fields, en); res = ClassMain.Insert(tb_name, fields); return(res); }
protected void datagrid_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "select") { mode = "edit"; btnAdd.Visible = false; ClearText(); string id = Convert.ToString(e.CommandArgument); this.SelectedID = Convert.ToInt32(id); EmployeeEN en = ClassEmployee.SearchEmp(this.SelectedID); this.Selected = en; setControl(en); UC_Position.empid = en.Emp_id; UC_Position.BindPosition_Emp(); divDetail.Visible = true; btnSave.Visible = true; btnDelete.Visible = true; btnCencel.Visible = true; UC_Position.Visible = true; } }
private static List <ClassFieldValue> SetField(List <ClassFieldValue> fields, EmployeeEN en) { fields.Add(new ClassFieldValue("Firstname", en.Firstname)); fields.Add(new ClassFieldValue("Lastname", en.Lastname)); fields.Add(new ClassFieldValue("Nickname", en.Nickname)); fields.Add(new ClassFieldValue("Address", en.Address)); fields.Add(new ClassFieldValue("Phone", en.Phone)); fields.Add(new ClassFieldValue("idenNumber", en.IdenNumber)); fields.Add(new ClassFieldValue("AccNo", en.AccNo)); fields.Add(new ClassFieldValue("AccName", en.AccName)); fields.Add(new ClassFieldValue("StartWorkDate", Utilities.SetDBNull(en.StartWorkDate))); fields.Add(new ClassFieldValue("BirthDate", Utilities.SetDBNull(en.BirthDate))); fields.Add(new ClassFieldValue("salary", en.salary)); fields.Add(new ClassFieldValue("Email", en.Email)); fields.Add(new ClassFieldValue("DeptId", en.DeptId)); return(fields); }