public ReturnDSLoaiSP LoadDSSP_Theoid_LoaiSP(int id_cate)
{
try
{
ReturnDSLoaiSP loaisp = new ReturnDSLoaiSP();
var tt = db.tbl_LoaiSP.FirstOrDefault(m => m.id == id_cate);
loaisp.id = id_cate;
loaisp.category_name = tt.category_name;
loaisp.description = tt.description;
List <ThongtinSP> lstSP = new List <ThongtinSP>();
SqlConnection con = new SqlConnection();
con = CS.Data.Connection.Connect.GetConnect();
SqlCommand cmd = new SqlCommand("LoadDSSP_Theoid_LoaiSP", con);
cmd.Parameters.Add(new SqlParameter("@id_cate", id_cate));
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = con;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
foreach (DataRow rowItem in dt.Rows)
{
ThongtinSP item_chil = new ThongtinSP();
item_chil.id = int.Parse(rowItem["id"].ToString());
item_chil.id_cate = int.Parse(rowItem["id_cate"].ToString());
item_chil.id_cate_detail = int.Parse(rowItem["id_cate_detail"].ToString());
item_chil.name = rowItem["name"].ToString();
item_chil.code = rowItem["code"].ToString();
item_chil.description = rowItem["description"].ToString();
item_chil.path_img = rowItem["path_img"].ToString();
item_chil.description_img = rowItem["description_img"].ToString();
item_chil.gia_xuat = float.Parse(rowItem["gia_xuat"].ToString());
lstSP.Add(item_chil);
}
loaisp.LstSP = lstSP;
return(loaisp);
}
catch (Exception e)
{
return(null);
}
}
public List <ReturnDSLoaiSP> BS_LoadLoaiSanPham()
{
try
{
List <ReturnDSLoaiSP> list = new List <ReturnDSLoaiSP>();
var getAll = db.tbl_LoaiSP.Where(m => m.isactive == true).ToList();
if (getAll.Count > 0)
{
foreach (var item in getAll)
{
ReturnDSLoaiSP loaisp = new ReturnDSLoaiSP();
int id_cate = 0;
id_cate = item.id;
List <ThongtinSP> lstSP = new List <ThongtinSP>();
loaisp.category_name = item.category_name;
loaisp.id = item.id;
loaisp.description = item.description;
SqlConnection con = new SqlConnection();
con = CS.Data.Connection.Connect.GetConnect();
SqlCommand cmd = new SqlCommand("LoadProductByCategory", con);
cmd.Parameters.Add(new SqlParameter("@id_cate", id_cate));
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = con;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
foreach (DataRow rowItem in dt.Rows)
{
ThongtinSP item_chil = new ThongtinSP();
item_chil.id = int.Parse(rowItem["id"].ToString());
item_chil.id_cate = int.Parse(rowItem["id_cate"].ToString());
item_chil.id_cate_detail = int.Parse(rowItem["id_cate_detail"].ToString());
item_chil.name = rowItem["name"].ToString();
item_chil.code = rowItem["code"].ToString();
item_chil.description = rowItem["description"].ToString();
item_chil.path_img = rowItem["path_img"].ToString();
item_chil.description_img = rowItem["description_img"].ToString();
item_chil.gia_xuat = float.Parse(rowItem["gia_xuat"].ToString());
lstSP.Add(item_chil);
}
loaisp.LstSP = lstSP;
list.Add(loaisp);
}
}
return(list);
}
catch (Exception e)
{
return(null);
}
}