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);
}
