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);
}
