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