// 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 { } }