/// <summary>
/// This is a sample specific finder method for Entity1.
/// If you want to delete or rename the method think about changing the xml in the BDC model file as well.
/// </summary>
/// <param name="id"></param>
/// <returns>Entity1</returns>
public static EntityEmployeeData ReadItem(string PersonalNumber)
{
EmployeeBasic basicInfo = null;
EmployeeDetail detailedInfo = null;
EntityEmployeeData ret = new EntityEmployeeData();
SharePointLogger logger = new SharePointLogger();
TestConfigTh config = new TestConfigTh();
TestLicense license = new TestLicense();
using (EmployeeRepositorySAPDotNet rep = new EmployeeRepositorySAPDotNet(config, logger, license))
{
List <EmployeeBasic> empList = rep.getEmployeeBasicList();
foreach (EmployeeBasic emp in empList)
{
if (emp.PersonalNumber.ToLower().Trim().Equals(PersonalNumber.ToLower().Trim()))
{
basicInfo = emp;
}
}
if (basicInfo != null)
{
detailedInfo = rep.getEmployeeDetailedInfo(PersonalNumber);
}
}
if (basicInfo != null)
{
ret = new EntityEmployeeData(basicInfo, detailedInfo);
}
return(ret);
}
public List <EmployeeBasic> getEmployeeBasicList(string surname, string lastname, string job, string organisation)
{
string surnameSearch = surname.Equals(string.Empty) ? "*" : surname;
string lastnameSearch = lastname.Equals(string.Empty) ? "*" : lastname;
string jobSearch = job.Equals(string.Empty) ? "*" : job;
string organisationSearch = organisation.Equals(string.Empty) ? "*" : organisation;
List <EmployeeBasic> result = new List <EmployeeBasic>();
RfcDestination destination = (RfcDestination)(TestConfigSAPDotNet.getConnectionObject());
try
{
RfcRepository repo = destination.Repository;
IRfcFunction employeeList = repo.CreateFunction(Constants.BAPI_EMPLOYEE_GETLIST);
// employeeList.SetValue(Constants.SEARCH_DATE, DateTime.Now.ToShortDateString());
employeeList.SetValue(Constants.JOB_SEARK, jobSearch);
employeeList.SetValue(Constants.ORG_SEARK, organisationSearch);
employeeList.SetValue(Constants.SUR_NAME_SEARK, surnameSearch);
employeeList.SetValue(Constants.LST_NAME_SEARK, lastnameSearch);
employeeList.Invoke(destination);
IRfcTable employees = employeeList.GetTable(Constants.EMPLOYEE_LIST);
for (int cuIndex = 0; cuIndex < employees.RowCount; cuIndex++)
{
employees.CurrentIndex = cuIndex;
var PERNR = employees.GetString(Constants.PERNR);
var ENAME = employees.GetString(Constants.ENAME);
var ORG_ID = employees.GetString(Constants.ORG_ID);
var ORG_TEXT = employees.GetString(Constants.ORG_TEXT);
var JOB_ID = employees.GetString(Constants.JOB_ID);
var JOB_TEXT = employees.GetString(Constants.JOB_TEXT);
EmployeeBasic empBasic = new EmployeeBasic()
{
Name = ENAME,
JobID = JOB_ID,
JobName = JOB_TEXT,
OrganisationID = ORG_TEXT,
OrganisationName = ORG_TEXT,
PersonalNumber = PERNR
};
result.Add(empBasic);
}
}
catch (Exception ex)
{
_loggingManager.ThrowException(ex, DOTNETSAPErrorSeverity.High);
}
finally
{
}
return(result);
}
public EntityEmployeeData(EmployeeBasic empBasic)
{
PersonalNumber = empBasic.PersonalNumber;
Name = empBasic.Name;
OrganisationID = empBasic.OrganisationID;
OrganisationName = empBasic.OrganisationName;
JobID = empBasic.JobID;
JobName = empBasic.JobName;
}
public EntityEmployeeData(EmployeeBasic empBasic, EmployeeDetail empDetail)
{
PersonalNumber = empBasic.PersonalNumber;
Name = empBasic.Name;
OrganisationID = empBasic.OrganisationID;
OrganisationName = empBasic.OrganisationName;
JobID = empBasic.JobID;
JobName = empBasic.JobName;
NamePrefix = empDetail.NamePrefix;
FirstName = empDetail.FirstName;
LastName = empDetail.LastName;
Language = empDetail.Language;
Nationality = empDetail.Nationality;
DateOfBith = empDetail.DateOfBith;
PlaceOfBith = empDetail.PlaceOfBith;
Gender = empDetail.Gender;
Country = empDetail.Country;
}
public List <EmployeeBasic> getEmployeeBasicList(string surname, string lastname, string job, string organisation)
{
string surnameSearch = surname.Equals(string.Empty) ? "*" : surname;
string lastnameSearch = lastname.Equals(string.Empty) ? "*" : lastname;
string jobSearch = job.Equals(string.Empty) ? "*" : job;
string organisationSearch = organisation.Equals(string.Empty) ? "*" : organisation;
List <EmployeeBasic> result = new List <EmployeeBasic>();
var connection = new R3Connection(_configManager.getConnectionString());
try
{
connection.Open();
var function = connection.CreateFunction(Constants.BAPI_EMPLOYEE_GETLIST);
function.Exports[Constants.SEARCH_DATE].ParamValue = DateTime.Now.ToShortDateString();
function.Exports[Constants.JOB_SEARK].ParamValue = jobSearch;
function.Exports[Constants.JOB_SEARK].ParamValue = jobSearch;
function.Exports[Constants.ORG_SEARK].ParamValue = organisationSearch;
function.Exports[Constants.SUR_NAME_SEARK].ParamValue = surnameSearch;
function.Exports[Constants.LST_NAME_SEARK].ParamValue = lastnameSearch;
function.Execute();
var table = function.Tables[Constants.EMPLOYEE_LIST];
if (table != null && table.Rows.Count > 0)
{
foreach (RFCStructure row in table.Rows)
{
var PERNR = (string)row[Constants.PERNR];
var ENAME = (string)row[Constants.ENAME];
var ORG_ID = (string)row[Constants.ORG_ID];
var ORG_TEXT = (string)row[Constants.ORG_TEXT];
var JOB_ID = (string)row[Constants.JOB_ID];
var JOB_TEXT = (string)row[Constants.JOB_TEXT];
EmployeeBasic empBasic = new EmployeeBasic()
{
Name = ENAME,
JobID = JOB_ID,
JobName = JOB_TEXT,
OrganisationID = ORG_TEXT,
OrganisationName = ORG_TEXT,
PersonalNumber = PERNR
};
result.Add(empBasic);
}
}
}
catch (Exception ex)
{
_loggingManager.ThrowException(ex, DOTNETSAPErrorSeverity.High);
}
finally
{
if (connection != null && connection.Ping())
{
connection.Close();
}
}
return(result);
}
public ActionResult Update(EmployeeBasic request)
{
return(Ok());
}