protected void Submit_Click(object sender, EventArgs e) { if (txtProductID.Text.Length > 0) { CMEDShopProduct product = new CMEDShopProduct { product_id = long.Parse(txtProductID.Text), product_title = txtTitle.Text, category_id = long.Parse(lstCategory.SelectedValue), supplier_id = long.Parse(lstSupplier.SelectedValue), product_price = double.Parse(txtProductPrice.Text), product_status = lstProductStatus.SelectedValue, short_description = FreeTextBox3.Text, long_description = FreeTextBox1.Text, thumb_pic_url = txtThumbNail.Text, full_pic_url = txtMainPhoto.Text, year = Int32.Parse(lstProductYear.SelectedValue), location = lstLocation.SelectedValue, topic = lstTopic.SelectedValue, active = chkActive.Enabled, updated_by = (string)Session["adminemail"], }; controller.UpdateCMEDShopProduct(product); } }
public void UpdateCMEDShopProduct(CMEDShopProduct product) { DB db = new DB(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "UpdateCMEDShopProduct"; cmd.Parameters.AddWithValue("@product_id", product.product_id); cmd.Parameters.AddWithValue("@product_title", product.product_title); cmd.Parameters.AddWithValue("@category_id", product.category_id); cmd.Parameters.AddWithValue("@supplier_id", product.supplier_id); cmd.Parameters.AddWithValue("@product_price", product.product_price); cmd.Parameters.AddWithValue("@product_status", product.product_status); cmd.Parameters.AddWithValue("@short_description", product.short_description); cmd.Parameters.AddWithValue("@long_description", product.long_description); cmd.Parameters.AddWithValue("@thumb_pic_url", product.thumb_pic_url); cmd.Parameters.AddWithValue("@full_pic_url", product.full_pic_url); cmd.Parameters.AddWithValue("@year", product.year); cmd.Parameters.AddWithValue("@location", product.location); cmd.Parameters.AddWithValue("@topic", product.topic); cmd.Parameters.AddWithValue("@active", product.active); cmd.Parameters.AddWithValue("@updated_by", product.updated_by); db.Execute(cmd); return; }
public List<CMEDShopProduct> getCMEDShopProductsByCategoryLocation(long category_id, long location_id) { DB db = new DB(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "GetCMEDShopProductsByCategoryLocation"; cmd.Parameters.AddWithValue("@category_id", category_id); cmd.Parameters.AddWithValue("@location_id", location_id); DataTable dt = db.Execute(cmd); List<CMEDShopProduct> Products = new List<CMEDShopProduct>(); foreach (DataRow dr in dt.Rows) { CMEDShopProduct product = new CMEDShopProduct { product_id = long.Parse(dr["product_id"].ToString()), product_title = dr["product_title"].ToString(), supplier_id = long.Parse(dr["supplier_id"].ToString()), category_id = long.Parse(dr["category_id"].ToString()), product_price = double.Parse(dr["product_price"].ToString()), product_status = dr["product_status"].ToString(), short_description = dr["short_description"].ToString(), long_description = dr["long_description"].ToString(), thumb_pic_url = dr["thumb_pic_url"].ToString(), full_pic_url = dr["full_pic_url"].ToString(), year = Int32.Parse(dr["year"].ToString()), sort = Int32.Parse(dr["sort"].ToString()), location = dr["location"].ToString(), topic = dr["topic"].ToString(), is_bundle = dr["is_bundle"].ToString(), preview_url = dr["preview_url"].ToString(), purchase_url = dr["Purchase_url"].ToString(), active = bool.Parse(dr["active"].ToString()), date_created = DateTime.Parse(dr["date_created"].ToString()), created_by = dr["created_by"].ToString(), date_updated = DateTime.Parse(dr["date_updated"].ToString()), updated_by = dr["updated_by"].ToString(), supplier_name = dr["supplier_name"].ToString(), category_name = dr["category_name"].ToString(), pdf_available = Boolean.Parse(dr["pdf_available"].ToString()), pdf_url = dr["pdf_url"].ToString(), }; Products.Add(product); } return Products; }
public List<CMEDShopProduct> getCMEDShopProductsByCategoryLocationSlides(long category_id, long location_id) { DB db = new DB(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "GetCMEDShopProductsByCategoryLocationSlides"; cmd.Parameters.AddWithValue("@category_id", category_id); cmd.Parameters.AddWithValue("@location_id", location_id); DataTable dt = db.Execute(cmd); List<CMEDShopProduct> Products = new List<CMEDShopProduct>(); foreach (DataRow dr in dt.Rows) { CMEDShopProduct product = new CMEDShopProduct { product_id = long.Parse(dr["product_id"].ToString()), product_title = dr["product_title"].ToString(), sort = Int32.Parse(dr["sort"].ToString()), pdf_available = Boolean.Parse(dr["pdf_available"].ToString()), pdf_url = dr["pdf_url"].ToString(), }; Products.Add(product); } return Products; }
public CMEDShopProduct GetCMEDShopProduct(long product_id) { DB db = new DB(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "GetCMEDShopProduct"; cmd.Parameters.AddWithValue("@product_id", product_id); DataTable dt = db.Execute(cmd); DataRow dr = dt.Rows[0]; CMEDShopProduct product = new CMEDShopProduct { product_id = long.Parse(dr["product_id"].ToString()), product_title = dr["product_title"].ToString(), supplier_id = long.Parse(dr["supplier_id"].ToString()), category_id = long.Parse(dr["category_id"].ToString()), product_price = double.Parse(dr["product_price"].ToString()), product_status = dr["product_status"].ToString(), short_description = dr["short_description"].ToString(), long_description = dr["long_description"].ToString(), thumb_pic_url = dr["thumb_pic_url"].ToString(), full_pic_url = dr["full_pic_url"].ToString(), year = Int32.Parse(dr["year"].ToString()), location = dr["location"].ToString(), topic = dr["topic"].ToString(), is_bundle = dr["is_bundle"].ToString(), preview_url = dr["preview_url"].ToString(), purchase_url = dr["Purchase_url"].ToString(), active = bool.Parse(dr["active"].ToString()), date_created = DateTime.Parse(dr["date_created"].ToString()), created_by = dr["created_by"].ToString(), date_updated = DateTime.Parse(dr["date_updated"].ToString()), updated_by = dr["updated_by"].ToString(), supplier_name = dr["supplier_name"].ToString(), category_name = dr["category_name"].ToString(), }; return product; }