public void product_load(int idofcom = 0, int cat = 0)
{
con.Open();
SqlCommand cmd;
if (cat == 0 && idofcom != 0)
{
cmd = new SqlCommand("get_prod", con);
SqlParameter paramID = new SqlParameter()
{
ParameterName = "@id",
Value = idofcom
};
cmd.Parameters.Add(paramID);
}
else if (cat != 0 && idofcom != 0)
{
cmd = new SqlCommand("get_prod;2 '" + idofcom + "' ,' " + cat + "'", con);
}
else if (cat == 0 && idofcom == 0)
{
cmd = new SqlCommand("get_prod;4", con);
}
else
{
cmd = new SqlCommand("get_prod;3 '" + cat + "'", con);
}
SqlDataReader red = cmd.ExecuteReader();
while (red.Read())
{
dataproduct pro = new dataproduct();
pro.pic = (byte[])red["Product_Pic"];
pro.price = Convert.ToDouble(red["Product_Price"]);
pro.des = (string)red["Descriptions"];
pro.count = (int)red["num_of_product"];
if (cat == 0)
{
pro.cat = (int)red["Cat_ID"];
}
product[(string)red["Product_Name"]] = pro;
}
red.Close();
con.Close();
}
public void product_load(int cat = 0)
{
Dictionary <string, dataproduct> companypro = new Dictionary <string, dataproduct>();
string name = accountName.InnerText;
SqlCommand cmd = new SqlCommand("select companyID from CompanyData where companyName ='" + name + "'", con);
con.Open();
int id = (int)cmd.ExecuteScalar();
SqlCommand cmd1;
if (cat == 0)
{
cmd1 = new SqlCommand("get_prod '" + id + "'", con);
}
else
{
cmd1 = new SqlCommand("get_prod;2 '" + id + "' ,' " + cat + "'", con);
}
SqlDataReader red = cmd1.ExecuteReader();
while (red.Read())
{
dataproduct pro = new dataproduct();
pro.pic = (byte[])red["Product_Pic"];
pro.price = Convert.ToDouble(red["Product_Price"]);
pro.des = (string)red["Descriptions"];
pro.count = (int)red["num_of_product"];
if (cat == 0)
{
pro.cat = (int)red["Cat_ID"];
}
companypro[(string)red["Product_Name"]] = pro;
}
con.Close();
string add = "";
foreach (var key in companypro.Keys)
{
if (cat == 1)
{
add += @" <div class='d-inline-block bg-white bo-1' data-toggle='tooltip' data-placement='top' title='price:" + companypro[key].price;
}
if (cat != 1 && companypro[key].cat == 1)
{
add += @" <div class='d-inline-block bg-white bo-1 lapp' data-toggle='tooltip' data-placement='top' title='price:" + companypro[key].price;
}
if (companypro[key].cat == 1 || cat == 1)
{
add += @"'>
<img src='data:image/png;base64," + Convert.ToBase64String(companypro[key].pic) +
@"' class='d-block lapt' /> <div class='d-block'>
<h6 class='d-inline-block align-top'>" + key + @"</h6>
</div> </div>";
}
else
{
add += @" <div class='d-inline-block bg-white bo-1 'data-toggle='tooltip' data-placement='top' title='price:" + companypro[key].price + @"'>
<img src='data:image/png;base64," + Convert.ToBase64String(companypro[key].pic) +
@"' class='d-block ' /> <div class='d-block'>
<h6 class='d-inline-block align-top'>" + key + @"</h6>
</div> </div>";
}
}
adds.InnerHtml = add;
}
