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 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 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(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 update(product_review_model product_review)
{
My_Connection con = new My_Connection();
SqlParameter[] p = new SqlParameter[5];
p[0] = new SqlParameter("@product_review_id", product_review.product_review_id);
p[1] = new SqlParameter("@product_id", product_review.product_id);
p[2] = new SqlParameter("@product_review_description", product_review.product_review_description);
p[3] = new SqlParameter("@product_review_date_time", product_review.product_review_date_time);
p[4] = new SqlParameter("@reviwer_name", product_review.reviwer_name);
con.update("sp_product_review_update", 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 update(seller_registration_model seller)
{
My_Connection con = new My_Connection();
SqlParameter[] p = new SqlParameter[12];
p[0] = new SqlParameter("@seller_id", seller.seller_id);
p[1] = new SqlParameter("@seller_company_name", seller.seller_company_name);
p[2] = new SqlParameter("@seller_company_address", seller.seller_company_address);
p[3] = new SqlParameter("@seller_company_contact_1", seller.seller_company_contact_1);
p[4] = new SqlParameter("@seller_company_contact_2", seller.seller_company_contact_2);
p[5] = new SqlParameter("@seller_company_email", seller.seller_company_email);
p[6] = new SqlParameter("@seller_company_logo", seller.seller_company_logo);
p[7] = new SqlParameter("@seller_company_website", seller.seller_company_website);
p[8] = new SqlParameter("@seller_company_cst_no", seller.seller_company_cst_no);
p[9] = new SqlParameter("@seller_status", seller.seller_status);
p[10] = new SqlParameter("@user_name", seller.user_name);
p[11] = new SqlParameter("@password", seller.password);
con.update("sp_seller_registration_update", p);
}
public static void update(product_model product)
{
My_Connection conn = new My_Connection();
SqlParameter[] p = new SqlParameter[16];
p[0] = new SqlParameter("@id", product.product_id);
p[1] = new SqlParameter("@company_id", product.company_id);
p[2] = new SqlParameter("@sub_category_id", product.sub_category_id);
p[3] = new SqlParameter("@seller_id", product.seller_id);
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.update("sp_product_update", p);
}