public ProductTempFormatInfo GettempKey(int pf_id)
{
ProductTempFormatInfo info = new ProductTempFormatInfo();
IDataReader reader = db.GetTempKey(pf_id).CreateDataReader();
while (reader.Read())
{
info = ProductTempFormatInfo.Populate(reader);
}
return(info);
}
public List <ProductTempFormatInfo> UpdateSortingWithCategory(int pc_id, int sorting)
{
List <ProductTempFormatInfo> infos = new List <ProductTempFormatInfo>();
IDataReader reader = db.UpdateSorting(pc_id, sorting).CreateDataReader();
while (reader.Read())
{
infos.Add(ProductTempFormatInfo.Populate(reader));
}
return(infos);
}
public List <ProductTempFormatInfo> GetallWithCategory(int pc_id)
{
List <ProductTempFormatInfo> infos = new List <ProductTempFormatInfo>();
IDataReader reader = db.GetDataByCategory(pc_id).CreateDataReader();
while (reader.Read())
{
infos.Add(ProductTempFormatInfo.Populate(reader));
}
return(infos);
}
public int GetCategorySortingDesc(int pc_id)
{
ProductTempFormatInfo info = new ProductTempFormatInfo();
IDataReader reader = db.GetCategorySortingDESC(pc_id).CreateDataReader();
if (reader.Read())
{
info = ProductTempFormatInfo.Populate(reader);
return(info.pf_sorting + 1);
}
return(1);
}
