public static void insert_final_cart(final_cart_model final)
{
My_Connection conn = new My_Connection();
SqlParameter[] p = new SqlParameter[5];
p[0] = new SqlParameter("@product_id", final.product_id);
p[1] = new SqlParameter("@session_id", final.session_id);
p[2] = new SqlParameter("@user_name", final.user_name);
p[3] = new SqlParameter("@quantity", final.quantity);
p[4] = new SqlParameter("@total", final.total);
p[5] = new SqlParameter("@purchase_date", final.purchase_date);
conn.insert("sp_final_cart_insert", p);
}
public List <final_cart_model> select_all()
{
List <final_cart_model> li = new List <final_cart_model>();
My_Connection conn = new My_Connection();
DataSet ds = conn.select_all("sp_final_cart_select_all");
for (int i = 0; i <= ds.Tables[0].Rows.Count - 1; i++)
{
DataRow dr = ds.Tables[0].Rows[i];
final_cart_model final = new final_cart_model();
final.product_id = int.Parse(dr["product_id"].ToString());
final.session_id = int.Parse(dr["session_id"].ToString());
final.user_name = dr["user_name"].ToString();
final.quantity = int.Parse(dr["quantity"].ToString());
final.total = int.Parse(dr["total"].ToString());
final.purchase_date = DateTime.Parse(dr["purchase_date"].ToString());
li.Add(final);
}
return(li);
}
