public List <ListDetailProduct> LoadAll_TonKho()
{
try
{
List <ListDetailProduct> list = new List <ListDetailProduct>();
SqlConnection con = new SqlConnection();
con = Connection.Connect.GetConnect();
SqlCommand cmd = new SqlCommand("nhapkho_danhsach_sanpham", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@BranchId", user.BranchId));
cmd.Connection = con;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
foreach (DataRow rowItem in dt.Rows)
{
ListDetailProduct item = new ListDetailProduct();
item.id = int.Parse(rowItem["id"].ToString());
item.product_name = rowItem["product_name"].ToString();
item.TYPE = rowItem["TYPE"].ToString();
item.unit_name = rowItem["unit_name"].ToString();
item.code = rowItem["code"].ToString();
item.isactive = bool.Parse(rowItem["isactive"].ToString());
item.soluong = int.Parse(rowItem["soluong"].ToString());
list.Add(item);
}
return(list);
}
catch (Exception e)
{
return(null);
}
}
public List <ListDetailProduct> Hienthithongtinchitiet_sp_ds_gia(int id)
{
try
{
List <ListDetailProduct> list = new List <ListDetailProduct>();
SqlConnection con = new SqlConnection();
con = Connection.Connect.GetConnect();
SqlCommand cmd = new SqlCommand("danhsach_gia_theoid_sp", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@id", id));
cmd.Connection = con;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
foreach (DataRow rowItem in dt.Rows)
{
ListDetailProduct item = new ListDetailProduct();
item.id = int.Parse(rowItem["id"].ToString());
item.id_gia = (string.IsNullOrEmpty(rowItem["id_gia"].ToString()) ? 0 : int.Parse(rowItem["id_gia"].ToString()));
item.gia_nhap = float.Parse(rowItem["gia_nhap"].ToString());
item.gia_xuat = float.Parse(rowItem["gia_xuat"].ToString());
item.name_display = rowItem["name_display"].ToString();
list.Add(item);
}
return(list);
}
catch (Exception e)
{
return(null);
}
}
public List <ListDetailProduct> Hienthithongtinchitiet_sp_ds_anh(int id)
{
try
{
List <ListDetailProduct> list = new List <ListDetailProduct>();
SqlConnection con = new SqlConnection();
con = Connection.Connect.GetConnect();
SqlCommand cmd = new SqlCommand("ds_anh_theoid_sp", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@id", id));
cmd.Connection = con;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
foreach (DataRow rowItem in dt.Rows)
{
ListDetailProduct item = new ListDetailProduct();
item.id = int.Parse(rowItem["id"].ToString());
item.id_img = (string.IsNullOrEmpty(rowItem["id_img"].ToString()) ? 0 : int.Parse(rowItem["id_img"].ToString()));
item.url_img = rowItem["url_img"].ToString();
item.path_img = rowItem["path_img"].ToString();
item.des_img = rowItem["des_img"].ToString();
list.Add(item);
}
return(list);
}
catch (Exception e)
{
return(null);
}
}
public List <ListDetailProduct> GetListProductsDetail(int id)
{
try
{
List <ListDetailProduct> list = new List <ListDetailProduct>();
SqlConnection con = new SqlConnection();
con = Connection.Connect.GetConnect();
SqlCommand cmd = new SqlCommand("chitiet_sanpham", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@id", id));
cmd.Parameters.Add(new SqlParameter("@type_product", SystemMessageConst.Key.Product_Service));
cmd.Connection = con;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
foreach (DataRow rowItem in dt.Rows)
{
ListDetailProduct item = new ListDetailProduct();
item.id = int.Parse(rowItem["id"].ToString());
item.product_name = rowItem["product_name"].ToString();
item.quantity = int.Parse(rowItem["quantity"].ToString());
list.Add(item);
}
return(list);
}
catch (Exception e)
{
return(null);
}
}
public List <ListDetailProduct> Hienthithongtinchitiet_sp_thongsokt(int id)
{
try
{
List <ListDetailProduct> list = new List <ListDetailProduct>();
SqlConnection con = new SqlConnection();
con = Connection.Connect.GetConnect();
SqlCommand cmd = new SqlCommand("hienthithongtinchitiet_sp", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@id", id));
cmd.Connection = con;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
foreach (DataRow rowItem in dt.Rows)
{
ListDetailProduct item = new ListDetailProduct();
item.id = int.Parse(rowItem["id"].ToString());
item.id_attr = int.Parse(rowItem["id_attr"].ToString());
item.id_config_attr = int.Parse(rowItem["id_config_attr"].ToString());
item.attr_name = rowItem["attr_name"].ToString();
item.descripton_attr = rowItem["descripton_attr"].ToString();
list.Add(item);
}
return(list);
}
catch (Exception e)
{
return(null);
}
}
