public static List <product_model> select_all()
{
List <product_model> li = new List <product_model>();
My_Connection conn = new My_Connection();
DataSet ds = conn.select_all("sp_product_select_all");
for (int i = 0; i <= ds.Tables[0].Rows.Count - 1; i++)
{
DataRow dr = ds.Tables[0].Rows[i];
product_model product = new product_model();
product.product_id = int.Parse(dr["product_id"].ToString());
product.company_id = int.Parse(dr["company_id"].ToString());
product.seller_id = int.Parse(dr["seller_id"].ToString());
product.product_name = dr["product_name"].ToString();
product.product_code = dr["product_code"].ToString();
product.product_price = float.Parse(dr["product_price"].ToString());
product.product_short_description = dr["product_short_description"].ToString();
product.product_warranty = int.Parse(dr["product_warranty"].ToString());
product.product_specification = dr["product_specification"].ToString();
product.product_stock = int.Parse(dr["product_stock"].ToString());
product.product_replacement_days = int.Parse(dr["product_replacement_days"].ToString());
product.product_delivery_days = int.Parse(dr["product_delivery_days"].ToString());
product.product_total_no_of_ratings = int.Parse(dr["product_total_no_of_ratings"].ToString());
product.product_avg_rating = float.Parse(dr["product_avg_rating"].ToString());
product.product_main_image = dr["product_main_image"].ToString();
product.product_status = Boolean.Parse(dr["product_status"].ToString());
li.Add(product);
}
return(li);
}
public static product_model select_id(int product_id)
{
My_Connection conn = new My_Connection();
SqlParameter[] p = new SqlParameter[1];
p[0] = new SqlParameter("@id", product_id);
DataSet ds = conn.select_id("sp_product_select_id", p);
if (ds.Tables[0].Rows.Count == 0)
{
return(null);
}
else
{
DataRow dr = ds.Tables[0].Rows[0];
product_model product = new product_model();
product.product_id = int.Parse(dr["product_id"].ToString());
product.product_name = dr["product_name"].ToString();
product.product_code = dr["product_code"].ToString();
product.product_price = int.Parse(dr["product_price"].ToString());
product.product_short_description = dr["product_short_description"].ToString();
product.product_warranty = int.Parse(dr["product_warranty"].ToString());
product.product_stock = int.Parse(dr["product_stock"].ToString());
product.product_main_image = dr["product_main_image"].ToString();
product.product_status = Boolean.Parse(dr["product_status"].ToString());
return(product);
}
}
public static void insert_product(product_model product)
{
My_Connection conn = new My_Connection();
SqlParameter [] p = new SqlParameter[16];
p[0] = new SqlParameter("@company_id", product.company_id);
p[1] = new SqlParameter("@sub_category_id", product.sub_category_id);
p[2] = new SqlParameter("@seller_id", product.seller_id);
p[3] = new SqlParameter("@product_name", product.product_name);
p[4] = new SqlParameter("@product_code", product.product_code);
p[5] = new SqlParameter("@product_price", product.product_price);
p[6] = new SqlParameter("@product_short_description", product.product_short_description);
p[7] = new SqlParameter("@product_warranty", product.product_warranty);
p[8] = new SqlParameter("@product_specification", product.product_specification);
p[9] = new SqlParameter("@product_stock", product.product_stock);
p[10] = new SqlParameter("@product_replacement_days", product.product_replacement_days);
p[11] = new SqlParameter("@product_delivery_days", product.product_delivery_days);
p[12] = new SqlParameter("@product_total_no_of_ratings", product.product_total_no_of_ratings);
p[13] = new SqlParameter("@product_avg_rating", product.product_avg_rating);
p[14] = new SqlParameter("@product_main_image", product.product_main_image);
p[15] = new SqlParameter("@product_status", product.product_status);
conn.insert("sp_product_insert", p);
}
