public IEnumerable <VmEmployeeDetails> SearchEmployeeRecord([FromBody] VmSearchEmployeeRecord SearchParameters)
{
List <VmEmployeeDetails> SearchEmpResultList = new List <VmEmployeeDetails>();
var DbObj = (from emp in db.Employee
join gn in db.Gender on emp.GenderId equals gn.GenderId
join cn in db.Country on emp.CountryId equals cn.CountryId
join ds in db.District on emp.DistrictId equals ds.DistrictId
join th in db.Thana on emp.ThanaId equals th.ThanaId
where emp.EmployeeAddress.ToString().ToLower().StartsWith(SearchParameters.EmployeeAddress.ToString().ToLower()) || emp.EmployeeMobileNo.ToString().ToLower().StartsWith(SearchParameters.EmployeeMobileNo.ToString().ToLower()) || emp.EmployeeName.ToString().ToLower().StartsWith(SearchParameters.EmployeeName.ToString().ToLower()) || emp.Email.ToString().ToLower().StartsWith(SearchParameters.Email.ToString().ToLower())
select new
{
EmployeeId = emp.EmployeeId,
EmployeeName = emp.EmployeeName,
EmployeeAddress = emp.EmployeeAddress,
EmployeeMobileNo = emp.EmployeeMobileNo,
Email = emp.Email,
GenderId = gn.GenderId,
GenderName = gn.GenderName,
CountryId = cn.CountryId,
CountryName = cn.CountryName,
DistrictId = ds.DistrictId,
DistrictName = ds.DistrictName,
ThanaId = th.ThanaId,
ThanaName = th.ThanaName
}).ToList();
foreach (var data in DbObj)
{
VmEmployeeDetails empRecord = new VmEmployeeDetails();
empRecord.EmployeeId = data.EmployeeId;
empRecord.EmployeeName = data.EmployeeName;
empRecord.EmployeeAddress = data.EmployeeAddress;
empRecord.EmployeeMobileNo = data.EmployeeMobileNo;
empRecord.Email = data.Email;
empRecord.GenderId = data.GenderId;
empRecord.GenderName = data.GenderName;
empRecord.CountryId = data.CountryId;
empRecord.CountryName = data.CountryName;
empRecord.DistrictId = data.DistrictId;
empRecord.DistrictName = data.DistrictName;
empRecord.ThanaId = data.ThanaId;
empRecord.ThanaName = data.ThanaName;
SearchEmpResultList.Add(empRecord);
}
return(SearchEmpResultList);
}
public ActionResult SearchEmployee([FromBody] VmSearchEmployeeRecord vm)
{
//return Json(db.SearchEmployeeRecord(vm));
return(Json(db.SearchEmployeeData(vm)));
}
