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 company_master_modal select_id(int company_id) { My_Connection conn = new My_Connection(); SqlParameter [] p = new SqlParameter[1]; p[0] = new SqlParameter("@company_id", company_id); DataSet ds = conn.select_id("sp_company_master_select_id", p); if (ds.Tables[0].Rows.Count == 0) { return(null); } else { DataRow dr = ds.Tables[0].Rows[0]; company_master_modal company = new company_master_modal(); company.company_id = int.Parse(dr["company_id"].ToString()); company.company_name = dr["company_name"].ToString(); company.company_status = Boolean.Parse(dr["company_status"].ToString()); return(company); } }
public static product_images_model select_id(int product_image_id) { My_Connection conn = new My_Connection(); SqlParameter[] p = new SqlParameter[1]; p[0] = new SqlParameter("@product_image_id", product_image_id); DataSet ds = conn.select_id("sp_product_images_select_id", p); if (ds.Tables[0].Rows.Count == 0) { return(null); } else { DataRow dr = ds.Tables[0].Rows[0]; product_images_model product_image = new product_images_model(); product_image.product_image_id = int.Parse(dr["product_image_id"].ToString()); product_image.product_secondary_image = dr["product_secondary_image"].ToString(); product_image.product_image_status = Boolean.Parse(dr["product_image_status"].ToString()); return(product_image); } }
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 List <seller_registration_model> selectAll() { List <seller_registration_model> li = new List <seller_registration_model>(); My_Connection con = new My_Connection(); DataSet ds = con.select_all("sp_seller_registration_select_all"); for (int i = 0; i <= ds.Tables[0].Rows.Count - 1; i++) { DataRow dr = ds.Tables[0].Rows[i]; seller_registration_model seller = new seller_registration_model(); seller.seller_id = int.Parse(dr["seller_id"].ToString()); seller.seller_company_name = dr["seller_company_name"].ToString(); seller.seller_company_address = dr["seller_company_address"].ToString(); seller.seller_company_contact_1 = dr["seller_company_contact_1"].ToString(); seller.seller_company_contact_2 = dr["seller_company_contact_2"].ToString(); seller.seller_company_email = dr["seller_company_email"].ToString(); seller.seller_company_logo = dr["seller_company_logo"].ToString(); seller.seller_company_website = dr["seller_company_website"].ToString(); seller.seller_company_cst_no = dr["seller_company_cst_no"].ToString(); seller.seller_status = dr["seller_status"].ToString(); seller.user_name = dr["user_name"].ToString(); seller.password = dr["password"].ToString(); li.Add(seller); } return(li); }
public static seller_registration_model login_seller(string username, string password) { My_Connection con = new My_Connection(); SqlParameter[] p = new SqlParameter[2]; p[0] = new SqlParameter("@username", username); p[1] = new SqlParameter("@password", password); DataSet ds = con.select_id("sp_seller_registration_check", p); if (ds.Tables[0].Rows.Count == 0) { return(null); } else { DataRow dr = ds.Tables[0].Rows[0]; seller_registration_model srm = new seller_registration_model(); srm.user_name = dr["user_name"].ToString(); srm.password = dr["password"].ToString(); return(srm); } }
public static void delete(int final_id) { My_Connection conn = new My_Connection(); SqlParameter[] p = new SqlParameter[1]; p[0] = new SqlParameter("@cart_id", final_id); conn.select_id("sp_final_cart_delete", p); }
public static void delete(int company_id) { My_Connection conn = new My_Connection(); SqlParameter [] p = new SqlParameter[1]; p[0] = new SqlParameter("@company_id", company_id); conn.delete("sp_company_master_delete", p); }
public static void delete(int seller_review_id) { My_Connection con = new My_Connection(); SqlParameter[] p = new SqlParameter[1]; p[0] = new SqlParameter("@seller_review_id", seller_review_id); con.delete("sp_seller_review_delete", p); }
public static void delete(int product_id) { My_Connection conn = new My_Connection(); SqlParameter[] p = new SqlParameter[1]; p[0] = new SqlParameter("@id", product_id); conn.select_id("sp_product_delete", p); }
public static void select_id(int seller_id) { My_Connection con = new My_Connection(); SqlParameter[] p = new SqlParameter[1]; p[0] = new SqlParameter("@seller_id", seller_id); con.select_id("sp_seller_registration_select_id", p); }
public static void delete(int order_id) { My_Connection conn = new My_Connection(); SqlParameter[] p = new SqlParameter[1]; p[0] = new SqlParameter("@order_master_id", order_id); conn.select_id("sp_order_master_delete", p); }
public static void delete_product_images(int product_image_id) { My_Connection conn = new My_Connection(); SqlParameter[] p = new SqlParameter[1]; p[0] = new SqlParameter("@product_image_id", product_image_id); conn.delete("sp_product_images_delete", p); }
public static void delete(int menu_id) { My_Connection conn = new My_Connection(); SqlParameter[] p = new SqlParameter[1]; p[0] = new SqlParameter("@menu_category_id", menu_id); conn.delete("sp_menu_category_delete", p); }
public static void select_id(int dummy_id) { My_Connection conn = new My_Connection(); SqlParameter[] p = new SqlParameter[1]; p[0] = new SqlParameter("@cart_id", dummy_id); conn.select_id("sp_dummy_cart_select_id", p); }
public static void delete(int product_review_id) { My_Connection con = new My_Connection(); SqlParameter[] p = new SqlParameter[1]; p[0] = new SqlParameter("@product_review_id", product_review_id); con.delete("sp_product_review_delete", p); }
public static void insert_menu_category(menu_category_model menu) { My_Connection conn = new My_Connection(); SqlParameter[] p = new SqlParameter[2]; p[0] = new SqlParameter("@name", menu.menu_category_name); p[1] = new SqlParameter("@status", menu.menu_category_status); conn.insert("sp_menu_category_insert", p); }
public static void insert_company(company_master_modal company) { My_Connection conn = new My_Connection(); SqlParameter[] p = new SqlParameter[2]; p[0] = new SqlParameter("@company_name", company.company_name); p[1] = new SqlParameter("@company_status", company.company_status); conn.insert("sp_company_master_insert", p); }
public static void insert_category(category_master_model category) { My_Connection conn = new My_Connection(); SqlParameter[] p = new SqlParameter[3]; p[0] = new SqlParameter("@Menu_category_id", category.menu_category_id); p[1] = new SqlParameter("@category_name", category.category_name); p[2] = new SqlParameter("@category_status", category.category_status); conn.insert("sp_category_master_insert", p); }
public static void update(company_master_modal company) { My_Connection conn = new My_Connection(); SqlParameter [] p = new SqlParameter[3]; p[0] = new SqlParameter("@company_name", company.company_name); p[1] = new SqlParameter("@company_status", company.company_status); p[2] = new SqlParameter("@company_id", company.company_id); conn.update("sp_company_master_update", p); }
public static void insert_images(product_images_model insert_image) { My_Connection conn = new My_Connection(); SqlParameter[] p = new SqlParameter[3]; p[0] = new SqlParameter("@product_id", insert_image.product_id); p[1] = new SqlParameter("@product_secondary_image", insert_image.product_secondary_image); p[2] = new SqlParameter("@product_image_status", insert_image.product_image_status); conn.insert("sp_product_images_insert", p); }
public static void update(menu_category_model menu) { My_Connection conn = new My_Connection(); SqlParameter[] p = new SqlParameter[3]; p[0] = new SqlParameter("@menu_category_id", menu.menu_category_id); p[1] = new SqlParameter("@menu_category_name", menu.menu_category_name); p[2] = new SqlParameter("@menu_category_status", menu.menu_category_status); conn.update("sp_menu_category_update", p); }
public static void insert_order_master(order_master_model order) { My_Connection conn = new My_Connection(); SqlParameter [] p = new SqlParameter[4]; p[0] = new SqlParameter("@session_id", order.session_id); p[1] = new SqlParameter("@order_no", order.order_no); p[2] = new SqlParameter("@order_date", order.order_date); p[3] = new SqlParameter("@order_status", order.order_status); conn.insert("sp_order_master_insert", p); }
public static void update(category_master_model category) { My_Connection conn = new My_Connection(); SqlParameter[] p = new SqlParameter[3]; //p[0] = new SqlParameter("@f_key", category.menu_category_id); p[0] = new SqlParameter("@category_master_id", category.category_master_id); p[1] = new SqlParameter("@category_name", category.category_name); p[2] = new SqlParameter("@category_status", category.category_status); conn.update("sp_category_master_update", p); }
public static void insert_product_review(product_review_model product_review) { My_Connection con = new My_Connection(); SqlParameter[] p = new SqlParameter[4]; p[0] = new SqlParameter("@product_id", product_review.product_id); p[1] = new SqlParameter("@product_review_description", product_review.product_review_description); p[2] = new SqlParameter("@product_review_date_time", product_review.product_review_date_time); p[3] = new SqlParameter("@reviwer_name", product_review.reviwer_name); con.insert("sp_product_review_insert", p); }
public static void update_product_images(product_images_model pim) { My_Connection conn = new My_Connection(); SqlParameter[] p = new SqlParameter[3]; p[0] = new SqlParameter("@product_image_id", pim.product_image_id); p[1] = new SqlParameter("@product_secondary_image", pim.product_secondary_image); p[2] = new SqlParameter("@product_images_status", pim.product_image_status); conn.update("sp_product_images_update", p); }
public static void update(seller_review_model seller_review) { My_Connection con = new My_Connection(); SqlParameter[] p = new SqlParameter[5]; p[0] = new SqlParameter("@seller_review_id", seller_review.seller_review_id); p[1] = new SqlParameter("@seller_id", seller_review.seller_id); p[2] = new SqlParameter("@seller_review_description", seller_review.seller_review_description); p[3] = new SqlParameter("@seller_review_date_time", seller_review.seller_review_date_time); p[4] = new SqlParameter("@reviwer_name", seller_review.reviwer_name); con.update("sp_seller_review_update", p); }
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 static void update(order_master_model order) { My_Connection conn = new My_Connection(); SqlParameter[] p = new SqlParameter[5]; p[0] = new SqlParameter("@order_master_id", order.order_master_id); p[1] = new SqlParameter("@session_id", order.session_id); p[2] = new SqlParameter("@order_no", order.order_no); p[3] = new SqlParameter("@order_date", order.order_master_id); p[4] = new SqlParameter("@order_status", order.order_status); conn.update("sp_order_category_update", p); }
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); }