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