public static CustomList <ItemGroupDeptMaping> GetAllDept(Int32 entityID)
{
ConnectionManager conManager = new ConnectionManager(ConnectionName.HR);
CustomList <ItemGroupDeptMaping> HouseKeepingValueCollection = new CustomList <ItemGroupDeptMaping>();
IDataReader reader = null;
String sql = "select HKID DeptID,HKName Department from HouseKeepingValue Where EntityID=" + entityID;
try
{
conManager.OpenDataReader(sql, out reader);
while (reader.Read())
{
ItemGroupDeptMaping newHouseKeepingValue = new ItemGroupDeptMaping();
newHouseKeepingValue.SetDataDept(reader);
HouseKeepingValueCollection.Add(newHouseKeepingValue);
}
return(HouseKeepingValueCollection);
}
catch (Exception ex)
{
throw (ex);
}
finally
{
if (reader != null && !reader.IsClosed)
{
reader.Close();
}
}
}
public static CustomList <ItemGroupDeptMaping> GetAllItemGroupDeptMaping(String itemGroupID)
{
ConnectionManager conManager = new ConnectionManager(ConnectionName.HR);
CustomList <ItemGroupDeptMaping> ItemGroupDeptMapingCollection = new CustomList <ItemGroupDeptMaping>();
IDataReader reader = null;
String sql = "select *from ItemGroupDeptMaping Where ItemGroupID=" + itemGroupID;
try
{
conManager.OpenDataReader(sql, out reader);
while (reader.Read())
{
ItemGroupDeptMaping newItemGroupDeptMaping = new ItemGroupDeptMaping();
newItemGroupDeptMaping.SetData(reader);
ItemGroupDeptMapingCollection.Add(newItemGroupDeptMaping);
}
return(ItemGroupDeptMapingCollection);
}
catch (Exception ex)
{
throw (ex);
}
finally
{
if (reader != null && !reader.IsClosed)
{
reader.Close();
}
}
}
public static CustomList<ItemGroupDeptMaping> GetAllItemGroupDeptMaping(String itemGroupID)
{
ConnectionManager conManager = new ConnectionManager(ConnectionName.HR);
CustomList<ItemGroupDeptMaping> ItemGroupDeptMapingCollection = new CustomList<ItemGroupDeptMaping>();
IDataReader reader = null;
String sql = "select *from ItemGroupDeptMaping Where ItemGroupID=" + itemGroupID;
try
{
conManager.OpenDataReader(sql, out reader);
while (reader.Read())
{
ItemGroupDeptMaping newItemGroupDeptMaping = new ItemGroupDeptMaping();
newItemGroupDeptMaping.SetData(reader);
ItemGroupDeptMapingCollection.Add(newItemGroupDeptMaping);
}
return ItemGroupDeptMapingCollection;
}
catch(Exception ex)
{
throw (ex);
}
finally
{
if (reader != null && !reader.IsClosed)
reader.Close();
}
}
public static CustomList<ItemGroupDeptMaping> GetAllDept(Int32 entityID)
{
ConnectionManager conManager = new ConnectionManager(ConnectionName.HR);
CustomList<ItemGroupDeptMaping> HouseKeepingValueCollection = new CustomList<ItemGroupDeptMaping>();
IDataReader reader = null;
String sql = "select HKID DeptID,HKName Department from HouseKeepingValue Where EntityID=" + entityID;
try
{
conManager.OpenDataReader(sql, out reader);
while (reader.Read())
{
ItemGroupDeptMaping newHouseKeepingValue = new ItemGroupDeptMaping();
newHouseKeepingValue.SetDataDept(reader);
HouseKeepingValueCollection.Add(newHouseKeepingValue);
}
return HouseKeepingValueCollection;
}
catch (Exception ex)
{
throw (ex);
}
finally
{
if (reader != null && !reader.IsClosed)
reader.Close();
}
}
