public static T_LMS_Master_AnnualLeaveCollection Search(SearchFilter SearchKey)
{
T_LMS_Master_AnnualLeaveCollection collection = new T_LMS_Master_AnnualLeaveCollection();
using (var reader = SqlHelper.ExecuteReaderService(ModuleConfig.MyConnection, "T_LMS_Master_AnnualLeave_Search", SearchFilterManager.SqlSearchParamNoCompany(SearchKey)))
{
while (reader.Read())
{
T_LMS_Master_AnnualLeave obj = new T_LMS_Master_AnnualLeave();
obj = GetItemFromReader(reader);
collection.Add(obj);
}
}
return(collection);
}
public static T_LMS_Master_AnnualLeaveCollection GetbyUser(string CreatedUser)
{
T_LMS_Master_AnnualLeaveCollection collection = new T_LMS_Master_AnnualLeaveCollection();
T_LMS_Master_AnnualLeave obj;
using (var reader = SqlHelper.ExecuteReaderService(ModuleConfig.MyConnection, "T_LMS_Master_AnnualLeave_GetAll_byUser", new SqlParameter("@CreatedUser", CreatedUser)))
{
while (reader.Read())
{
obj = GetItemFromReader(reader);
collection.Add(obj);
}
}
return(collection);
}
public static T_LMS_Master_AnnualLeaveCollection GetAllItem()
{
T_LMS_Master_AnnualLeaveCollection collection = new T_LMS_Master_AnnualLeaveCollection();
using (var reader = SqlHelper.ExecuteReaderService(ModuleConfig.MyConnection, "T_LMS_Master_AnnualLeave_GetAll", null))
{
while (reader.Read())
{
T_LMS_Master_AnnualLeave obj = new T_LMS_Master_AnnualLeave();
obj = GetItemFromReader(reader);
collection.Add(obj);
}
}
return(collection);
}