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