public int AddEmployee(Employee EmpObj) { try { ORD.EmployeeDBDataContext DC = new ORD.EmployeeDBDataContext(); var Query = DC.SpInsertEmployee(EmpObj.FirstName, EmpObj.LastName); var IdentityValue = Query.SingleOrDefault().ID; return (int)IdentityValue; } catch (Exception ex) { throw; } }
public Employee AddEmployeeReturnValue(Employee EmpObj) { try { ORD.EmployeeDBDataContext DC = new ORD.EmployeeDBDataContext(); var Query = DC.SpInsertEmployee(EmpObj.FirstName, EmpObj.LastName); var QueryReturn = DC.Employees.Where(LE => LE.EmployeeID == Query.SingleOrDefault().ID) .Select(LE=> new Employee() {FirstName=LE.FirstName,LastName=LE.LastName,EmployeeID=(int)LE.EmployeeID}).SingleOrDefault(); return QueryReturn; } catch (Exception ex) { throw; } }