public List <Productpicture> GetProductVideoPath(string id) { List <Productpicture> listpictures = new List <Productpicture>(); Productpicture objpictures = null; try { db.OpenConn(); SqlCommand cmd = new SqlCommand("select * from ProductPictures where ProductID=@ProductID", db.conn); cmd.Parameters.AddWithValue("@ProductID", id); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { objpictures = new Productpicture(); objpictures.PicturePath = dr["PicturePath"].ToString(); objpictures.ProductPictureID = long.Parse(dr["ProductPictureID"].ToString()); objpictures.ProductID = long.Parse(dr["ProductID"].ToString()); objpictures.VideoPath = dr["VideoPath"].ToString(); listpictures.Add(objpictures); } dr.Close(); db.CloseConn(); } catch (Exception ex) { db.CloseConn(); throw ex; } return(listpictures); }
public List <Productpicture> PictureAvailability(long pid) { List <Productpicture> lstpic = new List <Productpicture>(); Productpicture pp; try { db.OpenConn(); SqlCommand cmd = new SqlCommand("select P.ProductName,PP.PicturePath,PP.ProductPictureID from Products P, ProductPictures PP where P.ProductID=PP.ProductID AND PP.ProductID=@ProductID", db.conn); cmd.Parameters.AddWithValue("@ProductID", pid); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { pp = new Productpicture(); pp.PicturePath = dr["PicturePath"].ToString(); pp.ProductName = dr["ProductName"].ToString(); pp.ProductPictureID = long.Parse(dr["ProductPictureID"].ToString()); lstpic.Add(pp); } dr.Close(); db.CloseConn(); } catch (Exception ex) { db.CloseConn(); throw ex; } return(lstpic); }
public List <Productpicture> GetProductPicture(long id) { List <Productpicture> listproductpictures = new List <Productpicture>(); Productpicture objproductpictures = null; try { db.OpenConn(); SqlCommand cmd = new SqlCommand("select PicturePath,ProductID from ProductPictures where ProductID=" + id, db.conn); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { objproductpictures = new Productpicture(); //objproductpictures.ProductPictureID = int.Parse(dr["ProductPictureID"].ToString()); objproductpictures.PicturePath = dr["PicturePath"].ToString(); // objproductpictures.ProductID objproductpictures.ProductID = int.Parse(dr["ProductID"].ToString()); listproductpictures.Add(objproductpictures); } dr.Close(); db.CloseConn(); } catch (Exception ex) { db.CloseConn(); throw ex; } return(listproductpictures); }
protected void DatalistThumb_ItemCommand(object source, DataListCommandEventArgs e) { if (e.CommandName == "Remove") { Productpicture objpp = new Productpicture(); long ptid = long.Parse(e.CommandArgument.ToString()); HiddenField obj = (HiddenField)e.Item.FindControl("hdnproductid"); long ppid = long.Parse(obj.Value); objpp.DeleteProductImages(ppid, ptid); BindData(); } }
public List <OrderDetails> GetOrderDetailsByOrderID(string paramOrderID) { Orders objorders = new Orders(); List <Orders> lstorders = new List <Orders>(); List <OrderDetails> lstOrderDetails = new List <OrderDetails>(); OrderDetails objOrderDetails = new OrderDetails(); try { db.OpenConn(); SqlCommand cmd = new SqlCommand(@"select * from OrderDetails od inner join Products p on p.ProductID=od.ProductID where od.orderid=" + paramOrderID + "", db.conn); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { objOrderDetails = new OrderDetails(); objOrderDetails.OrderDetailsID = long.Parse(dr["OrderDetailsID"].ToString()); objOrderDetails.OrderID = long.Parse(dr["OrderID"].ToString()); objOrderDetails.ProductID = long.Parse(dr["ProductID"].ToString()); objOrderDetails.Quantity = int.Parse(dr["Quantity"].ToString()); objOrderDetails.Price = float.Parse(dr["SaleRate"].ToString()); objOrderDetails.DeliveryCharges = 0; // float.Parse(dr["DeliveryCharges"].ToString()); objOrderDetails.Amount = objOrderDetails.Quantity * objOrderDetails.Price; objOrderDetails.ProductName = dr["ProductName"].ToString(); List <Productpicture> lstPP = new List <Productpicture>(); lstPP = new Productpicture().GetProductPicture(objOrderDetails.ProductID); string path = "/Images/noimage_icon.jpg"; foreach (Productpicture item in lstPP) { if (item.PicturePath != "") { path = item.PicturePath.Replace("~", ""); } } objOrderDetails.PicturePath = path; lstOrderDetails.Add(objOrderDetails); } dr.Close(); db.CloseConn(); } catch (Exception ex) { db.CloseConn(); throw ex; } return(lstOrderDetails); }
public List <Productpicture> GetPlantThumbPictures(long id) { List <Productpicture> listpictures = new List <Productpicture>(); Productpicture objpictures = null; try { db.OpenConn(); SqlCommand cmd = new SqlCommand("select top 4 PT.PictureThumbPath from PicturesThumbnails PT inner join ProductPictures PP on PT.ProductPictureID=PP.ProductPictureID where ProductID=@ProductID", db.conn); cmd.Parameters.AddWithValue("@ProductID", id); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { objpictures = new Productpicture(); // objpictures.PicturePath = dr["PicturePath"].ToString(); //string ppath = objpictures.PicturePath; //if (ppath == "") //{ // objpictures.PicturePath = "~/Images/noimage_icon.jpg"; //} objpictures.PictureThumbPath = dr["PictureThumbPath"].ToString(); //string pthumbpath=objpictures.PictureThumbPath; //if (pthumbpath == "") //{ // objpictures.PictureThumbPath = "~/Images/noimage_icon.jpg"; //} listpictures.Add(objpictures); } dr.Close(); db.CloseConn(); } catch (Exception ex) { db.CloseConn(); throw ex; } return(listpictures); }
protected void btnsave_Click(object sender, EventArgs e) { Productpicture objpp = new Productpicture(); string newpath = ""; if (Session["id"] != null && Session["id"].ToString() != "") { long ID = long.Parse(Session["id"].ToString()); //String imgpath = File1.FileName; //string FullImage = File1.FileName; lblmsg.Text = ""; if (Session["up1"] != null && Session["up1"].ToString() != "") { if (Session["up1"] != null && Session["up1"].ToString() != "") { uploadpath = Session["up1"].ToString(); if (btnsave.Text == "Save") { //string filename = Path.GetFileName(AjaxFileUpload1.PostedFile.FileName); //AjaxFileUpload1.SaveAs(Server.MapPath(Session["path"].ToString())); objpp.ProductID = long.Parse(Session["id"].ToString()); long poid = objpp.ProductID; objpp.PicturePath = uploadpath; objpp.PictureThumbPath = uploadpath; List <Productpicture> lstppictur = objpp.GetPicture(poid); long ppictureid = 0; if (lstppictur.Count >= 1) { ppictureid = objpp.GetPPictures(poid); } else { ppictureid = objpp.SaveProductPicture(); } objpp.SaveProductPictureThumbnails(ppictureid); } else { // AjaxFileUpload1.SaveAs(Server.MapPath(Session["path"].ToString())); objpp.ProductID = long.Parse(Session["id"].ToString()); objpp.PicturePath = uploadpath; objpp.PictureThumbPath = uploadpath; string path = uploadpath; objpp.UpdateProductPictures(); long ppid = objpp.GetPictureID(objpp.ProductID); List <Productpicture> lstpic = objpp.GetPictureThumbnails(ppid); if (lstpic.Count > 0) { objpp.UpdateProductThumbnail(ppid, path); } else { objpp.SaveProductPictureThumbnails(ppid); } } } if (Session["up2"] != null && Session["up2"].ToString() != "") { uploadpath2 = Session["up2"].ToString(); if (btnsave.Text == "Save") { //string filename = Path.GetFileName(AjaxFileUpload1.PostedFile.FileName); //AjaxFileUpload1.SaveAs(Server.MapPath(Session["path"].ToString())); objpp.ProductID = long.Parse(Session["id"].ToString()); long poid = objpp.ProductID; objpp.PicturePath = uploadpath2; objpp.PictureThumbPath = uploadpath2; List <Productpicture> lstppictur = objpp.GetPicture(poid); long ppictureid = 0; if (lstppictur.Count >= 1) { ppictureid = objpp.GetPPictures(poid); } else { ppictureid = objpp.SaveProductPicture(); } objpp.SaveProductPictureThumbnails(ppictureid); } else { // AjaxFileUpload1.SaveAs(Server.MapPath(Session["path"].ToString())); objpp.ProductID = long.Parse(Session["id"].ToString()); objpp.PicturePath = uploadpath2; objpp.PictureThumbPath = uploadpath2; string path = uploadpath2; objpp.UpdateProductPictures(); long ppid = objpp.GetPictureID(objpp.ProductID); List <Productpicture> lstpic = objpp.GetPictureThumbnails(ppid); if (lstpic.Count > 0) { objpp.UpdateProductThumbnail(ppid, path); } else { objpp.SaveProductPictureThumbnails(ppid); } } } if (Session["up3"] != null && Session["up3"].ToString() != "") { uploadpath3 = Session["up3"].ToString(); if (btnsave.Text == "Save") { //string filename = Path.GetFileName(AjaxFileUpload1.PostedFile.FileName); //AjaxFileUpload1.SaveAs(Server.MapPath(Session["path"].ToString())); objpp.ProductID = long.Parse(Session["id"].ToString()); long poid = objpp.ProductID; objpp.PicturePath = uploadpath3; objpp.PictureThumbPath = uploadpath3; List <Productpicture> lstppictur = objpp.GetPicture(poid); long ppictureid = 0; if (lstppictur.Count >= 1) { ppictureid = objpp.GetPPictures(poid); } else { ppictureid = objpp.SaveProductPicture(); } objpp.SaveProductPictureThumbnails(ppictureid); } else { // AjaxFileUpload1.SaveAs(Server.MapPath(Session["path"].ToString())); objpp.ProductID = long.Parse(Session["id"].ToString()); objpp.PicturePath = uploadpath3; objpp.PictureThumbPath = uploadpath3; string path = uploadpath3; objpp.UpdateProductPictures(); long ppid = objpp.GetPictureID(objpp.ProductID); List <Productpicture> lstpic = objpp.GetPictureThumbnails(ppid); if (lstpic.Count > 0) { objpp.UpdateProductThumbnail(ppid, path); } else { objpp.SaveProductPictureThumbnails(ppid); } } } if (Session["up4"] != null && Session["up4"].ToString() != "") { uploadpath4 = Session["up4"].ToString(); if (btnsave.Text == "Save") { //string filename = Path.GetFileName(AjaxFileUpload1.PostedFile.FileName); //AjaxFileUpload1.SaveAs(Server.MapPath(Session["path"].ToString())); objpp.ProductID = long.Parse(Session["id"].ToString()); long poid = objpp.ProductID; objpp.PicturePath = uploadpath4; objpp.PictureThumbPath = uploadpath4; List <Productpicture> lstppictur = objpp.GetPicture(poid); long ppictureid = 0; if (lstppictur.Count >= 1) { ppictureid = objpp.GetPPictures(poid); } else { ppictureid = objpp.SaveProductPicture(); } objpp.SaveProductPictureThumbnails(ppictureid); } else { // AjaxFileUpload1.SaveAs(Server.MapPath(Session["path"].ToString())); objpp.ProductID = long.Parse(Session["id"].ToString()); objpp.PicturePath = uploadpath4; objpp.PictureThumbPath = uploadpath4; string path = uploadpath4; objpp.UpdateProductPictures(); long ppid = objpp.GetPictureID(objpp.ProductID); List <Productpicture> lstpic = objpp.GetPictureThumbnails(ppid); if (lstpic.Count > 0) { objpp.UpdateProductThumbnail(ppid, path); } else { objpp.SaveProductPictureThumbnails(ppid); } } } if (Session["up5"] != null && Session["up5"].ToString() != "") { uploadpath5 = Session["up5"].ToString(); if (btnsave.Text == "Save") { //string filename = Path.GetFileName(AjaxFileUpload1.PostedFile.FileName); //AjaxFileUpload1.SaveAs(Server.MapPath(Session["path"].ToString())); objpp.ProductID = long.Parse(Session["id"].ToString()); long poid = objpp.ProductID; objpp.PicturePath = uploadpath5; objpp.PictureThumbPath = uploadpath5; List <Productpicture> lstppictur = objpp.GetPicture(poid); long ppictureid = 0; if (lstppictur.Count >= 1) { ppictureid = objpp.GetPPictures(poid); } else { ppictureid = objpp.SaveProductPicture(); } objpp.SaveProductPictureThumbnails(ppictureid); } else { // AjaxFileUpload1.SaveAs(Server.MapPath(Session["path"].ToString())); objpp.ProductID = long.Parse(Session["id"].ToString()); objpp.PicturePath = uploadpath5; objpp.PictureThumbPath = uploadpath5; string path = uploadpath5; objpp.UpdateProductPictures(); long ppid = objpp.GetPictureID(objpp.ProductID); List <Productpicture> lstpic = objpp.GetPictureThumbnails(ppid); if (lstpic.Count > 0) { objpp.UpdateProductThumbnail(ppid, path); } else { objpp.SaveProductPictureThumbnails(ppid); } } } if (Session["up6"] != null && Session["up6"].ToString() != "") { uploadpath6 = Session["up6"].ToString(); if (btnsave.Text == "Save") { //string filename = Path.GetFileName(AjaxFileUpload1.PostedFile.FileName); //AjaxFileUpload1.SaveAs(Server.MapPath(Session["path"].ToString())); objpp.ProductID = long.Parse(Session["id"].ToString()); long poid = objpp.ProductID; objpp.PicturePath = uploadpath6; objpp.PictureThumbPath = uploadpath6; List <Productpicture> lstppictur = objpp.GetPicture(poid); long ppictureid = 0; if (lstppictur.Count >= 1) { ppictureid = objpp.GetPPictures(poid); } else { ppictureid = objpp.SaveProductPicture(); } objpp.SaveProductPictureThumbnails(ppictureid); } else { // AjaxFileUpload1.SaveAs(Server.MapPath(Session["path"].ToString())); objpp.ProductID = long.Parse(Session["id"].ToString()); objpp.PicturePath = uploadpath6; objpp.PictureThumbPath = uploadpath6; string path = uploadpath6; objpp.UpdateProductPictures(); long ppid = objpp.GetPictureID(objpp.ProductID); List <Productpicture> lstpic = objpp.GetPictureThumbnails(ppid); if (lstpic.Count > 0) { objpp.UpdateProductThumbnail(ppid, path); } else { objpp.SaveProductPictureThumbnails(ppid); } } } uploadpath = ""; uploadpath2 = ""; uploadpath3 = ""; uploadpath4 = ""; uploadpath5 = ""; uploadpath6 = ""; Session["up1"] = null; Session["up2"] = null; Session["up3"] = null; Session["up4"] = null; Session["up5"] = null; Session["up6"] = null; BindData(); Response.Redirect("Product.aspx"); } else { lblmsg.ForeColor = System.Drawing.Color.Red; lblmsg.Text = "Please select image before you save"; } } else { lblmsg.ForeColor = System.Drawing.Color.Red; lblmsg.Text = "Please select image before you savedasdsa"; } }
protected void AjaxFileUpload1_UploadComplete(object sender, AjaxFileUploadEventArgs e) { if (Session["id"] != null && Session["id"].ToString() != "") { long ID = long.Parse(Session["id"].ToString()); Productpicture objpp = new Productpicture(); string filename = Session["id"].ToString() + "_" + System.IO.Path.GetFileName(e.FileName); //System.Drawing.Image image = System.Drawing.Image.FromStream(filename, true, true); // yourImage = resizeImage(yourImage, new Size(50, 50)); string strUploadPath = "~/Images/"; string filepath = strUploadPath + filename; AjaxFileUpload1.SaveAs(Server.MapPath(strUploadPath + filename)); objpp.PicturePath = filepath; objpp.ProductID = ID; if (Session["up1"] == null) { Session["up1"] = filepath; } else if (Session["up1"] == "") { Session["up1"] = filepath; } else if (Session["up2"] == null) { Session["up2"] = filepath; } else if (Session["up2"] == "") { Session["up2"] = filepath; } else if (Session["up3"] == null) { Session["up3"] = filepath; } else if (Session["up3"] == "") { Session["up3"] = filepath; } else if (Session["up4"] == null) { Session["up4"] = filepath; } else if (Session["up4"] == "") { Session["up4"] = filepath; } else if (Session["up5"] == null) { Session["up5"] = filepath; } else if (Session["up5"] == "") { Session["up5"] = filepath; } else if (Session["up6"] == null) { Session["up6"] = filepath; } else if (Session["up6"] == "") { Session["up6"] = filepath; } } }
public List <Productpicture> GetPlantPictures(long id) { List <Productpicture> listpictures = new List <Productpicture>(); Productpicture objpictures = null; try { db.OpenConn(); float rate = 0; //string sqlquery = "select PicturePath from ProductPictures where ProductID=@ProductID"; string sqlquery = "select p.ProductName,p.Price,pp.PicturePath from ProductPictures pp inner join Products p on pp.ProductID=p.ProductID where pp.ProductID=@ProductID"; SqlCommand cmd = new SqlCommand(sqlquery, db.conn); cmd.Parameters.AddWithValue("@ProductID", id); SqlDataReader dr = cmd.ExecuteReader(); string countrycode = ""; string value = ""; string symbol = ""; //if (HttpContext.Current.Session["Country"] != null) //{ // countrycode = HttpContext.Current.Session["Country"].ToString(); //} //if (countrycode != "" && countrycode != "INR") //{ // value = objutilities.GetCurrencyRate("1", "INR", countrycode); // symbol = objutilities.GetCurrencySymbol(countrycode); //} //else //{ // symbol = objutilities.GetCurrencySymbol("INR"); //} while (dr.Read()) { objpictures = new Productpicture(); objpictures.PicturePath = dr["PicturePath"].ToString(); objpictures.ProductName = dr["ProductName"].ToString(); double price = 0; if (countrycode != "" && countrycode != "INR") { price = double.Parse(value) * double.Parse(dr["Price"].ToString()); } else { price = double.Parse(dr["Price"].ToString()); } //int myInt = (int)Math.Ceiling(double.Parse(price.ToString())); //objpictures.CountryPrice = symbol + " " + myInt.ToString("0.00"); rate = float.Parse(dr["Price"].ToString()); objpictures.Price = rate; string ppath = objpictures.PicturePath; if (ppath == "") { objpictures.PicturePath = "~/Images/noimage_icon.jpg"; } //objpictures.PictureThumbPath = dr["PictureThumbPath"].ToString(); //string pthumbpath=objpictures.PictureThumbPath; //if (pthumbpath == "") //{ // objpictures.PictureThumbPath = "~/Images/noimage_icon.jpg"; //} listpictures.Add(objpictures); } dr.Close(); db.CloseConn(); } catch (Exception ex) { db.CloseConn(); throw ex; } return(listpictures); }