private void LoadPixcelCode() { string str = ""; if (hdnPKID.Value != "") { tblPixcelCode objPixelCode = new tblPixcelCode(); objDataTable = objPixelCode.GetPixcelCode(hdnPKID.Value); if (objDataTable.Rows.Count > 0) { str += "<script>"; foreach (DataRow row in objDataTable.Rows) { DataRow[] dr = objDataTable.Select(); if (dr.Length > 0) { str += row[tblPixcelCode.ColumnNames.AppName].ToString() + ","; } } str += "</script>"; str = str.TrimEnd(','); Page.Controls.Add(new LiteralControl(str)); } objPixelCode = null; } }
private bool Delete(int intPKID) { bool retval = false; objProduct = new tblProduct(); if (objProduct.IsProductInOrder(intPKID.ToString())) { return(retval); } if (objProduct.LoadByPrimaryKey(intPKID)) { tblPixcelCode objPixelCode = new tblPixcelCode(); objPixelCode.Where.AppProductId.Value = intPKID; objPixelCode.Query.Load(); if (objPixelCode.RowCount > 0) { objPixelCode.DeleteAll(); objPixelCode.Save(); } objPixelCode = null; tblProductSubCategory objProductSubCategory = new tblProductSubCategory(); objProductSubCategory.Where.AppProductID.Value = intPKID; objProductSubCategory.Query.Load(); if (objProductSubCategory.RowCount > 0) { objProductSubCategory.DeleteAll(); objProductSubCategory.Save(); } objProductSubCategory = null; tblRelatedProduct objRelatedProduct = new tblRelatedProduct(); objRelatedProduct.Where.AppProductID.Value = intPKID; objRelatedProduct.Query.Load(); if (objRelatedProduct.RowCount > 0) { objRelatedProduct.DeleteAll(); objRelatedProduct.Save(); } objRelatedProduct = null; tblProductProperty objProductProperty = new tblProductProperty(); objProductProperty.Where.AppProductID.Value = intPKID; objProductProperty.Query.Load(); if (objProductProperty.RowCount > 0) { objProductProperty.DeleteAll(); objProductProperty.Save(); } objProductProperty = null; tblProductColor objProductColor = new tblProductColor(); objProductColor.Where.AppProductID.Value = intPKID; objProductColor.Query.Load(); if (objProductColor.RowCount > 0) { while (!(objProductColor.EOF)) { tblProductDetail objProductDetail = new tblProductDetail(); objProductDetail.Where.AppProductColorID.Value = objProductColor.AppProductColorID; objProductDetail.Query.Load(); if (objProductDetail.RowCount > 0) { objProductDetail.DeleteAll(); objProductDetail.Save(); } objProductDetail = null; tblProductImage objProductImage = new tblProductImage(); objProductImage.Where.AppProductColorID.Value = objProductColor.AppProductColorID; objProductImage.Query.Load(); if (objProductImage.RowCount > 0) { //while(! objProductImage.EOF ) //{ // if (System.IO.File.Exists(Server.MapPath(objProductImage.s_AppLargeImage ))) // { // System.IO.File.Delete(Server.MapPath(objProductImage.s_AppLargeImage)); // } // if (System.IO.File.Exists(Server.MapPath(objProductImage.s_AppNormalImage))) // { // System.IO.File.Delete(Server.MapPath(objProductImage.s_AppNormalImage)); // } // if (System.IO.File.Exists(Server.MapPath(objProductImage.s_AppSmallImage))) // { // System.IO.File.Delete(Server.MapPath(objProductImage.s_AppSmallImage)); // } // if (System.IO.File.Exists(Server.MapPath(objProductImage.s_AppThumbImage))) // { // System.IO.File.Delete(Server.MapPath(objProductImage.s_AppLargeImage)); // } // objProductImage.MoveNext(); //} objProductImage.DeleteAll(); objProductImage.Save(); } objProductImage = null; objProductColor.MoveNext(); } objProductColor.DeleteAll(); objProductColor.Save(); } objProductColor = null; string StrFolder = "Uploads/Product/" + objProduct.s_AppProductID + "/"; if (System.IO.Directory.Exists(Server.MapPath("~/admin/" + StrFolder))) { System.IO.Directory.Delete(Server.MapPath("~/admin/" + StrFolder), true); } objProduct.MarkAsDeleted(); objProduct.Save(); } retval = true; objProduct = null; return(retval); }