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); }