public List <ProGroupModel> TagsTbl()
{
var res = new List <ProGroupModel>();
PDBC db = new PDBC("PandaMarketCMS", true);
db.Connect();
DataTable dt = db.Select("SELECT D.id_TE,B.PTname,A.MCName,C.SCName,D.TE_name FROM [tbl_Product_MainCategory] as A inner join [tbl_Product_Type] as B on A.id_PT=B.id_PT inner join [tbl_Product_SubCategory] as C on A.id_MC=C.id_MC inner join [tbl_Product_TagEnums] as D on C.id_SC=D.SubCatId");
db.DC();
for (int i = 0; i < dt.Rows.Count; i++)
{
var model = new ProGroupModel()
{
Num = i + 1,
Id = Convert.ToInt32(dt.Rows[i]["id_TE"]),
Type = dt.Rows[i]["PTname"].ToString(),
Main = dt.Rows[i]["MCName"].ToString(),
Sub = dt.Rows[i]["SCName"].ToString(),
SubK = dt.Rows[i]["TE_name"].ToString(),
};
res.Add(model);
}
return(res);
}
public List <ProGroupModel> SubCatTbl()
{
var res = new List <ProGroupModel>();
PDBC db = new PDBC("PandaMarketCMS", true);
db.Connect();
DataTable dt = db.Select("SELECT C.id_SC,B.PTname,A.MCName,C.ISDelete,C.ISDESABLED,C.SCName FROM [tbl_Product_MainCategory] as A inner join [tbl_Product_Type] as B on A.id_PT=B.id_PT inner join [tbl_Product_SubCategory] as C on A.id_MC=C.id_MC");
db.DC();
for (int i = 0; i < dt.Rows.Count; i++)
{
var model = new ProGroupModel()
{
Num = i + 1,
Id = Convert.ToInt32(dt.Rows[i]["id_SC"]),
IsDeleted = Convert.ToInt32(dt.Rows[i]["ISDelete"]),
IsDisables = Convert.ToInt32(dt.Rows[i]["ISDESABLED"]),
Type = dt.Rows[i]["PTname"].ToString(),
Main = dt.Rows[i]["MCName"].ToString(),
Sub = dt.Rows[i]["SCName"].ToString()
};
res.Add(model);
}
return(res);
}
public List <ProGroupModel> SubCatvValueTbl()
{
var res = new List <ProGroupModel>();
PDBC db = new PDBC("PandaMarketCMS", true);
db.Connect();
DataTable dt = db.Select("SELECT E.id_SCOV,B.PTname,A.MCName,C.SCName,D.SCOKName,E.SCOVValueName FROM [tbl_Product_MainCategory] as A inner join [tbl_Product_Type] as B on A.id_PT=B.id_PT inner join [tbl_Product_SubCategory] as C on A.id_MC=C.id_MC inner join [tbl_Product_SubCategoryOptionKey] as D on C.id_SC=D.id_SC inner join [tbl_Product_SubCategoryOptionValue] as E on D.id_SCOK=E.id_SCOK");
db.DC();
for (int i = 0; i < dt.Rows.Count; i++)
{
var model = new ProGroupModel()
{
Num = i + 1,
Id = Convert.ToInt32(dt.Rows[i]["id_SCOV"]),
Type = dt.Rows[i]["PTname"].ToString(),
Main = dt.Rows[i]["MCName"].ToString(),
Sub = dt.Rows[i]["SCName"].ToString(),
SubK = dt.Rows[i]["SCOKName"].ToString(),
SubVal = dt.Rows[i]["SCOVValueName"].ToString()
};
res.Add(model);
}
return(res);
}
public List <ProGroupModel> TypeTbl()
{
var res = new List <ProGroupModel>();
PDBC db = new PDBC("PandaMarketCMS", true);
db.Connect();
DataTable dt = db.Select("SELECT [id_PT],[PTname],[ISDESABLED],[ISDelete]FROM [tbl_Product_Type]");
db.DC();
for (int i = 0; i < dt.Rows.Count; i++)
{
var model = new ProGroupModel()
{
Num = i + 1,
Id = Convert.ToInt32(dt.Rows[i]["id_PT"]),
IsDeleted = Convert.ToInt32(dt.Rows[i]["ISDelete"]),
IsDisables = Convert.ToInt32(dt.Rows[i]["ISDESABLED"]),
Type = dt.Rows[i]["PTname"].ToString()
};
res.Add(model);
}
return(res);
}
