public static ItemImageCollection GetbyUser(string CreatedUser)
{
ItemImageCollection collection = new ItemImageCollection();
ItemImage obj;
using (var reader = SqlHelper.ExecuteReader("tblItemImage_GetAll_byUser", new SqlParameter("@CreatedUser", CreatedUser)))
{
while (reader.Read())
{
obj = GetItemFromReader(reader);
collection.Add(obj);
}
}
return(collection);
}
public static ItemImageCollection GetbyItemCode(string ItemCode)
{
ItemImageCollection collection = new ItemImageCollection();
ItemImage obj;
using (var reader = SqlHelper.ExecuteReader("tblItemImage_GetByItemCode", new SqlParameter("@ItemCode", ItemCode)))
{
while (reader.Read())
{
obj = GetItemFromReader(reader);
collection.Add(obj);
}
}
return(collection);
}
public static ItemImageCollection GetAllItem()
{
ItemImageCollection collection = new ItemImageCollection();
using (var reader = SqlHelper.ExecuteReader("tblItemImage_GetAll", null))
{
while (reader.Read())
{
ItemImage obj = new ItemImage();
obj = GetItemFromReader(reader);
collection.Add(obj);
}
}
return(collection);
}