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