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