예제 #1
0
 void IService1.DeleteEmployee(int employeeID) // DeleteEmployee
 {
     try
     {
         using (VinylRecordsShopEntities context = new VinylRecordsShopEntities())
         {
             tblEmployee employeeToDelete = (from r in context.tblEmployees where r.EmployeeID == employeeID select r).First();
             context.tblEmployees.Remove(employeeToDelete);
             context.SaveChanges();
         }
     }
     catch (Exception ex)
     {
         System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
     }
 }
예제 #2
0
 // ADD , EDIT I DELETE ZA EMPLOYEE
 vwEmployee IService1.AddEmployee(vwEmployee employee) // AddEmployee
 {
     try
     {
         using (VinylRecordsShopEntities context = new VinylRecordsShopEntities())
         {
             if (employee.EmployeeID == 0)
             {   // ZA ADD
                 tblEmployee newEmployee = new tblEmployee();
                 newEmployee.BossID           = employee.BossID;
                 newEmployee.EmployeeName     = employee.EmployeeName;
                 newEmployee.EmployeeLastName = employee.EmployeeLastName;
                 newEmployee.BirthDate        = employee.BirthDate;
                 newEmployee.Address          = employee.Address;
                 newEmployee.City             = employee.City;
                 newEmployee.Mobile           = employee.Mobile;
                 newEmployee.JobDescription   = employee.JobDescription;
                 context.tblEmployees.Add(newEmployee);
                 context.SaveChanges();
                 employee.EmployeeID = newEmployee.EmployeeID;
                 return(employee);
             }
             else
             {   // ZA EDIT
                 tblEmployee employeeToEdit = (from r in context.tblEmployees where r.EmployeeID == employee.EmployeeID select r).First();
                 employeeToEdit.BossID           = employee.BossID;
                 employeeToEdit.EmployeeName     = employee.EmployeeName;
                 employeeToEdit.EmployeeLastName = employee.EmployeeLastName;
                 employeeToEdit.BirthDate        = employee.BirthDate;
                 employeeToEdit.Address          = employee.Address;
                 employeeToEdit.City             = employee.City;
                 employeeToEdit.Mobile           = employee.Mobile;
                 employeeToEdit.JobDescription   = employee.JobDescription;
                 //employeeToEdit.EmployeeID = employee.EmployeeID;
                 context.Entry(employeeToEdit).State = EntityState.Modified;
                 context.SaveChanges();
                 return(employee);
             }
         }
     }
     catch (Exception ex)
     {
         System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
         return(null);
     }
 }