public static T_CMS_Master_EmploymentTypeCollection GetbyUser(string CreatedUser)
{
T_CMS_Master_EmploymentTypeCollection collection = new T_CMS_Master_EmploymentTypeCollection();
T_CMS_Master_EmploymentType obj;
using (var reader = SqlHelper.ExecuteReaderService(ModuleConfig.MyConnection, "T_CMS_Master_EmploymentType_GetAll_byUser", new SqlParameter("@CreatedUser", CreatedUser)))
{
while (reader.Read())
{
obj = GetItemFromReader(reader);
collection.Add(obj);
}
}
return(collection);
}
public static T_CMS_Master_EmploymentTypeCollection Search(SearchFilter SearchKey)
{
T_CMS_Master_EmploymentTypeCollection collection = new T_CMS_Master_EmploymentTypeCollection();
using (var reader = SqlHelper.ExecuteReaderService(ModuleConfig.MyConnection, "T_CMS_Master_EmploymentType_Search", SearchFilterManager.SqlSearchParamNoCompany(SearchKey)))
{
while (reader.Read())
{
T_CMS_Master_EmploymentType obj = new T_CMS_Master_EmploymentType();
obj = GetItemFromReader(reader);
collection.Add(obj);
}
}
return(collection);
}
public static T_CMS_Master_EmploymentTypeCollection GetAllItem()
{
T_CMS_Master_EmploymentTypeCollection collection = new T_CMS_Master_EmploymentTypeCollection();
using (var reader = SqlHelper.ExecuteReaderService(ModuleConfig.MyConnection, "T_CMS_Master_EmploymentType_GetAll", null))
{
while (reader.Read())
{
T_CMS_Master_EmploymentType obj = new T_CMS_Master_EmploymentType();
obj = GetItemFromReader(reader);
collection.Add(obj);
}
}
return(collection);
}
public static T_CMS_Master_EmploymentTypeCollection GetAllItemByEnity(int EntityID)
{
T_CMS_Master_EmploymentTypeCollection collection = new T_CMS_Master_EmploymentTypeCollection();
var sqlParams = new SqlParameter[1];
sqlParams[0] = new SqlParameter("@EntityID", EntityID);
using (var reader = SqlHelper.ExecuteReaderService(ModuleConfig.MyConnection, "T_CMS_Master_EmploymentType_GetAllByEntityID", sqlParams))
{
while (reader.Read())
{
T_CMS_Master_EmploymentType obj = new T_CMS_Master_EmploymentType();
obj = GetItemFromReader(reader);
collection.Add(obj);
}
}
return(collection);
}