//------------------------------------------------------------------------------------------------------------------------------------------
public List <DTO.InventoryDTO> SelectAllInventoryByDataReader()
{
List <DTO.InventoryDTO> list = new List <DTO.InventoryDTO>();
string strCmd = "select_all_inventory";
SqlDataReader rd = _DataProvicer.ExecuteQueryWithDataReader(strCmd, CommandType.StoredProcedure);
if (rd.HasRows)
{
while (rd.Read())
{
DTO.InventoryDTO dto = new DTO.InventoryDTO
{
InventoryID = rd.GetString(0),
BookID = rd.GetString(1),
Index = rd.GetString(2),
Status = rd.GetInt32(3),
};
list.Add(dto);
}
}
return(list);
}
//------------------------------------------------------------------------------------------------------------------------------------------
public DTO.InventoryDTO SearchInventoryByInventoryID(string id)
{
string strCmd = "e_select_inventory_by_inventory_id";
SqlParameter ID = new SqlParameter("@InventoryID", id);
SqlDataReader rd = _DataProvicer.ExecuteQueryWithDataReader(strCmd, CommandType.StoredProcedure, ID);
if (rd.HasRows)
{
if (rd.Read())
{
DTO.InventoryDTO dto = new DTO.InventoryDTO
{
InventoryID = rd.GetString(0),
BookID = rd.GetString(1),
Index = rd.GetString(2),
Status = rd.GetInt32(3)
};
return(dto);
}
}
return(null);
}
public bool UpdateInventory(string id, int status)
{
DTO.InventoryDTO dto = this.SearchInventoryByInventoryID(id);
return(dao.UpdateInventory(dto, status));
}