public EmployeeMaster GetEmployeeById(int employeeID)
{
List <EmployeeMaster> EmployeeList = new List <EmployeeMaster>();
// List<IBSparameter> parameters = new List<IBSparameter>();
try
{
if (DBProvider == ProviderName.SqlClient)
{
IBSparameter Userparameter = new IBSparameter();
Userparameter.ParameterName = "@UserAccount";
Userparameter.DataType = DbType.String;
Userparameter.Value = LoggedInUser;
Userparameter.Direction = ParameterDirection.Input;
parameters.Add(Userparameter);
IBSparameter EmployeeIDParameter = new IBSparameter();
EmployeeIDParameter.ParameterName = "@EmployeeID";
EmployeeIDParameter.DataType = DbType.String;
EmployeeIDParameter.Value = employeeID;
EmployeeIDParameter.Direction = ParameterDirection.Input;
parameters.Add(EmployeeIDParameter);
}
DataSet dsEmployee = null;
dsEmployee = GetDataSet("ERP_Get_CompanyByID", parameters);
var CompanyCollection = from EmployeeMaster in dsEmployee.Tables[0].AsEnumerable()
select new EmployeeMaster
{
EmployeeId = EmployeeMaster.Field <int>("EmployeeID"),
LastName = EmployeeMaster.Field <String>("LastName"),
FirstName = EmployeeMaster.Field <String>("FirstName"),
Region = EmployeeMaster.Field <String>("Region"),
City = EmployeeMaster.Field <String>("City"),
Address = EmployeeMaster.Field <String>("Address"),
PostalCode = EmployeeMaster.Field <String>("PostalCode"),
};
EmployeeList = CompanyCollection.ToList <EmployeeMaster>();
}
catch (Exception ex)
{
//Logger.Error("CategoriesDAL.GetCategoryById(" + LoggedInUser + "," + CompanyCode + "," + categoryId + ")", ex);
}
return(EmployeeList[0]);
}
public List <EmployeeMaster> BindEMPCode_Autocomplete(EmployeeMaster objEmployee)
{
List <EmployeeMaster> EmployeeList = new List <EmployeeMaster>();
// List<IBSparameter> parameters = new List<IBSparameter>();
try
{
if (DBProvider == ProviderName.SqlClient)
{
IBSparameter Userparameter = new IBSparameter();
Userparameter.ParameterName = "@UserAccount";
Userparameter.DataType = DbType.String;
Userparameter.Value = LoggedInUser;
Userparameter.Direction = ParameterDirection.Input;
parameters.Add(Userparameter);
IBSparameter EmployeeIDParameter = new IBSparameter();
EmployeeIDParameter.ParameterName = "@EMPCode";
EmployeeIDParameter.DataType = DbType.String;
EmployeeIDParameter.Value = objEmployee.EmpCode;
EmployeeIDParameter.Direction = ParameterDirection.Input;
parameters.Add(EmployeeIDParameter);
}
DataSet dsEmployee = null;
dsEmployee = GetDataSet("ERP_AutoComplete_BindEMPCode", parameters);
var CompanyCollection = from EmployeeMaster in dsEmployee.Tables[0].AsEnumerable()
select new EmployeeMaster
{
EmpCode = EmployeeMaster.Field <string>("EmpCode"),
};
EmployeeList = CompanyCollection.ToList <EmployeeMaster>();
}
catch (Exception ex)
{
//Logger.Error("CategoriesDAL.GetCategoryById(" + LoggedInUser + "," + CompanyCode + "," + categoryId + ")", ex);
}
return(EmployeeList);
}