// DELETE: api/Emp/5
public void Delete(int id)
{
tbEmployee emp = empDb.tbEmployees.FirstOrDefault(e => e.e_id == id);
empDb.tbEmployees.Remove(emp);
empDb.SaveChanges();
}
public string Post([FromBody] tbEmployee emp, string Add)
{
try
{
tbEmpGroup tbEmpG = new tbEmpGroup();
if (Add.Equals("Add"))
{
SHA256 sha256 = new SHA256CryptoServiceProvider(); //建立一個SHA256
byte[] source = Encoding.Default.GetBytes(emp.PassWord); //將字串轉為Byte[]
byte[] crypto = sha256.ComputeHash(source); //進行SHA256加密
string result = Convert.ToBase64String(crypto); //把加密後的字串從Byte[]轉為字串
emp.PassWord = result;
_db.tbEmployee.Add(emp);
tbEmpG.EmployeeNo = emp.EmployeeNo;
tbEmpG.GroupID = "";
_db.tbEmpGroup.Add(tbEmpG);
_db.SaveChanges();
}
else
{
return("error");
}
}
catch (Exception ex)
{
return(ex.Message);
}
return("success");
}
// GET: api/Emp/5
public EmployeeCustomClass Get(int id)
{
tbEmployee emp = empDb.tbEmployees.FirstOrDefault(e => e.e_id == id);
EmployeeCustomClass empCustom = new EmployeeCustomClass();
empCustom.EmpId = emp.e_id;
empCustom.EmpName = emp.e_name;
empCustom.DeptName = emp.tbDepartment.d_name;
return(empCustom);
}
// POST: api/Emp
public void Post([FromBody] EmployeeCustomClass emp)
{
Console.WriteLine(emp);
tbDepartment dep = empDb.tbDepartments.FirstOrDefault(e => e.d_name.Equals(emp.DeptName));
tbEmployee newEmp = new tbEmployee();
newEmp.e_name = emp.EmpName;
newEmp.tbDepartment = dep;
//ef
empDb.tbEmployees.Add(newEmp);
empDb.SaveChanges();
}
public string Delete([FromBody] string value)
{
try
{
tbEmployee _tbEmployee = _db.tbEmployee.Where(b => b.EmployeeNo == value).First();
_db.tbEmployee.Remove(_tbEmployee);
_db.SaveChanges();
}
catch (Exception ex)
{
return(ex.Message);
}
return("success");
}
// PUT: api/Emp/5
public void Put(int id, [FromBody] EmployeeCustomClass updateEmp)
{
if (updateEmp != null)
{
tbEmployee emp = empDb.tbEmployees.FirstOrDefault(e => e.e_id == updateEmp.EmpId);
tbDepartment dep = empDb.tbDepartments.FirstOrDefault(e => e.d_name.Equals(updateEmp.DeptName));
emp.e_name = updateEmp.EmpName;
emp.tbDepartment = dep;
empDb.SaveChanges();
}
}
public string Put([FromBody] tbEmployee employee)
{
try
{
tbEmployee tbEmployee = _db.tbEmployee.Where(b => b.EmployeeNo == employee.EmployeeNo).First();
tbEmployee.EmployeeName = employee.EmployeeName;
_db.SaveChanges();
}
catch (Exception ex)
{
return(ex.Message);
}
return("success");
}
private void ViewEmployees_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
try
{
id = int.Parse(GetSelectedCellValue());
result = db.tbEmployees.SingleOrDefault(x => x.ID == id);
txtID.Text = result.ID.ToString();
txtName.Text = result.employeeName;
txtAddress.Text = result.Address;
txtNotes.Text = result.Notes;
txtEmail.Text = result.Email;
txtPhone.Text = result.Phone;
txtSalary.Text = result.Salary.ToString();
txtOccuption.Text = result.Occuption;
img.Source = new BitmapImage(new Uri(result.Image));
}
catch { }
}
