public EmployeeData SearchByNameEmployee(EmployeeDataContext instanceDataModel)
{
EmployeeData employeeData;
string queryUpdate;
if (ValedationClass.IsValidCompareToStrings(instanceDataModel.language.ToString(), Constants.LAN_EN) == true)
{
queryUpdate = Constants.SelectQuery
+ " WHERE [employNameEN] = N'" + instanceDataModel.employeeName.Trim() + "'";
}
else
{
queryUpdate = Constants.SelectQuery
+ " WHERE [employeeNameAR] = N'" + instanceDataModel.employeeName.Trim() + "'";
}
DataTable dtEmployee = GetanythingThroughQuery(queryUpdate);
employeeData = CustOneEmployee(dtEmployee, 0);
return(employeeData);
}