public static void insert_seller_review(seller_review_model seller_review) { My_Connection con = new My_Connection(); SqlParameter[] p = new SqlParameter[4]; p[0] = new SqlParameter("@seller_id", seller_review.seller_id); p[1] = new SqlParameter("@seller_review_description", seller_review.seller_review_description); p[2] = new SqlParameter("@seller_review_date_time", seller_review.seller_review_date_time); p[3] = new SqlParameter("@reviwer_name", seller_review.reviwer_name); con.insert("sp_seller_review_insert", p); }
public static List <seller_review_model> selectAll() { List <seller_review_model> li = new List <seller_review_model>(); My_Connection con = new My_Connection(); DataSet ds = con.select_all("sp_seller_review_select_all"); for (int i = 0; i <= ds.Tables[0].Rows.Count - 1; i++) { DataRow dr = ds.Tables[0].Rows[i]; seller_review_model seller_review = new seller_review_model(); seller_review.seller_id = int.Parse(dr["seller_id"].ToString()); seller_review.seller_review_description = dr["seller_review_description"].ToString(); seller_review.seller_review_date_time = DateTime.Parse(dr["seller_review_date_time"].ToString()); seller_review.reviwer_name = dr["reviwer_name"].ToString(); li.Add(seller_review); } return(li); }