protected void btnCart_Click(object sender, EventArgs e)
{
if (hdnProductDetailId.Value != "")
{
tblProductDetail objProductDetail = new tblProductDetail();
if (objProductDetail.LoadByPrimaryKey(Convert.ToInt32(hdnProductDetailId.Value)))
{
if (objProductDetail.AppQuantity > 0 & objProductDetail.AppQuantity >= Convert.ToInt32(txtQty.Text))
{
objCommon = new clsCommon();
objCommon.AddToCart(hdnPKID.Value, hdnProductColorId.Value, ddlSize.SelectedValue, Convert.ToInt32(txtQty.Text), hdnPriceDiscount.Value);
objCommon = null;
txtQty.Text = "1";
SetCartProductCount();
ViewCart.LoadProduct();
}
else
{
DInfo.ShowMessage("Product out of stock.", Enums.MessageType.Error);
}
}
else
{
DInfo.ShowMessage("Product out of stock.", Enums.MessageType.Error);
}
objProductDetail = null;
}
else
{
DInfo.ShowMessage("Product out of stock.", Enums.MessageType.Error);
}
}
protected void btnClick_Click(object sender, EventArgs e)
{
if (hdnProductDetailID.Value != "")
{
tblProductDetail objProductDetail = new tblProductDetail();
if (objProductDetail.LoadByPrimaryKey(Convert.ToInt32(hdnProductDetailID.Value)))
{
if (objProductDetail.AppQuantity > 0)
{
objCommon = new clsCommon();
objCommon.AddToCart(hdnPKID.Value, hdnProductColorId.Value, hdnProductDetailID.Value, 1);
//objCommon.AddToCart(hdnPKID.Value, objProductDetail.s_AppProductColorID, objProductDetail.s_AppSizeID, 1, hdnPriceDiscount.Value);
objCommon = null;
//txtQty.Text = "1";
SetCartProductCount();
ViewCart.LoadProduct();
}
else
{
DInfoSearch.ShowMessage("Product out of stock.", Enums.MessageType.Error);
}
}
else
{
DInfoSearch.ShowMessage("Product out of stock.", Enums.MessageType.Error);
}
objProductDetail = null;
}
else
{
// DInfo.ShowMessage("Product out of stock.", Enums.MessageType.Error);
}
}
public bool addCartExpress()
{
if (hdnProductDetailId.Value != "")
{
tblProductDetail objProductDetail = new tblProductDetail();
if (objProductDetail.LoadByPrimaryKey(Convert.ToInt32(hdnProductDetailId.Value)))
{
if (objProductDetail.AppQuantity > 0)
{
objCommon = new clsCommon();
objCommon.AddToCart(hdnPKID.Value, hdnProductColorId.Value, ddlSize.SelectedValue, Convert.ToInt32(txtQty.Text), hdnPriceDiscount.Value);
objCommon = null;
txtQty.Text = "1";
}
else
{
DInfo.ShowMessage("Product out of stock.", Enums.MessageType.Error);
return(false);
}
}
else
{
DInfo.ShowMessage("Product out of stock.", Enums.MessageType.Error);
return(false);
}
objProductDetail = null;
return(true);
}
return(false);
}
public static string AddToCart(string strpID)
{
tblProductDetail objProductDetail = new tblProductDetail();
DataTable objDataTable = objProductDetail.LoadProductIDs(strpID);
if (objDataTable.Rows.Count > 0)
{
if (Convert.ToInt32(objDataTable.Rows[0][tblProductDetail.ColumnNames.AppQuantity].ToString()) > 0)
{
clsCommon objCommon = new clsCommon();
objCommon.AddToCart(objDataTable.Rows[0][tblProductColor.ColumnNames.AppProductID].ToString(), objDataTable.Rows[0][tblProductDetail.ColumnNames.AppProductColorID].ToString(), strpID, 1, "0");
//objCommon.AddToCart(objDataTable.Rows[0][tblProductColor.ColumnNames.AppProductID].ToString(), objDataTable.Rows[0][tblProductDetail.ColumnNames.AppProductColorID].ToString(), e.CommandArgument.ToString());
objCommon = null;
DataTable dtCart = new DataTable();
if ((HttpContext.Current.Session[appFunctions.Session.Cart.ToString()] != null))
{
dtCart = (DataTable)HttpContext.Current.Session[appFunctions.Session.Cart.ToString()];
}
//ViewCart.LoadProduct("0");
}
else
{
//DInfo.ShowMessage("Product out of stock.", Enums.MessageType.Error);
}
}
else
{
// DInfo.ShowMessage("Product out of stock.", Enums.MessageType.Error);
}
return("");
}
protected void btnSetExportData_Click(object sender, EventArgs e)
{
objProductDetail = new tblProductDetail();
objDataTable = objProductDetail.GetReportSKUNOWise(txtSKUNO.Text);
objProductDetail = null;
ExpFile.SetFileName("SKUWiseProduct");
ExpFile.SetExportData(objDataTable);
}
protected void btnSetExportData_Click(object sender, EventArgs e)
{
if (txtQuantity.Text != "")
{
objProductDetail = new tblProductDetail();
objDataTable = objProductDetail.GetReportQtyWise(txtQuantity.Text);
objProductDetail = null;
ExpFile.SetFileName("QuantityWiseProduct");
ExpFile.SetExportData(objDataTable);
}
}
private void LoadDataGrid(bool IsResetPageIndex, bool IsSort)
{
if (txtQuantity.Text != "")
{
objProductDetail = new tblProductDetail();
objDataTable = objProductDetail.GetReportQtyWise(txtQuantity.Text);
//'Reset PageIndex of gridviews
if (IsResetPageIndex)
{
if (dgvGridView.PageCount > 0)
{
dgvGridView.PageIndex = 0;
}
}
dgvGridView.DataSource = null;
dgvGridView.DataBind();
lblCount.Text = 0.ToString();
//'Check for data into datatable
if (objDataTable.Rows.Count <= 0)
{
DInfo.ShowMessage("No data found", Enums.MessageType.Information);
btnExportExcel.Visible = false;
return;
}
else
{
btnExportExcel.Visible = true;
if (ddlPerPage.SelectedItem.Text.ToLower() == "all")
{
dgvGridView.AllowPaging = false;
}
else
{
dgvGridView.AllowPaging = true;
dgvGridView.PageSize = Convert.ToInt32(ddlPerPage.SelectedItem.Text);
}
lblCount.Text = objDataTable.Rows.Count.ToString();
objDataTable = SortDatatable(objDataTable, ViewState["SortColumn"].ToString(), (appFunctions.Enum_SortOrderBy)ViewState["SortOrder"], IsSort);
dgvGridView.DataSource = objDataTable;
dgvGridView.DataBind();
}
objProductDetail = null;
}
else
{
dgvGridView.DataSource = null;
dgvGridView.DataBind();
lblCount.Text = 0.ToString();
btnExportExcel.Visible = false;
}
}
public ActionResult ShippingDetails(RdplForm.Models.CustDetail result)
{
RahmanDbEntities db = new RahmanDbEntities();
{
tblCustDetail objcustdt = new tblCustDetail();
objcustdt.CustName = result.CustName;
objcustdt.Address = result.Address;
objcustdt.MobileNo = result.MobileNO;
// For total Amount Calculation
List <CartItems> cartId = (List <CartItems>)Session["cart"];
var total_Amount = 0;
foreach (var item in cartId)
{
//tblProductDetail prodDetail = new tblProductDetail();
var Amount = db.tblProductDetails.Where(c => c.ProductId == item.ProductId).FirstOrDefault();
total_Amount = total_Amount + (Amount.Price) * (item.Quantity);
}
objcustdt.Total_Amount = total_Amount;
db.tblCustDetails.Add(objcustdt);
db.SaveChanges();
ViewBag.Success = " Order placed Successfully ";
tblProductDetail prodDetails = new tblProductDetail();
List <CartItems> cartIds = (List <CartItems>)Session["cart"];
foreach (var item in cartIds)
{
CustOrderDetail orddt = new CustOrderDetail();
orddt.Order_Id = objcustdt.CustId;
orddt.Quntity = item.Quantity;
orddt.Product_Id = item.ProductId;
db.CustOrderDetails.Add(orddt);
}
db.SaveChanges();
ModelState.Clear();
}
return(View());
}
protected void dgvGridView_RowCommand(object sender, System.Web.UI.WebControls.GridViewCommandEventArgs e)
{
if (!string.IsNullOrEmpty(e.CommandArgument.ToString()))
{
if (e.CommandName == "IsActive")
{
objProduct = new tblProduct();
if (objProduct.LoadByPrimaryKey(Convert.ToInt32(e.CommandArgument.ToString())))
{
if (objProduct.AppIsActive == true)
{
objProduct.AppIsActive = false;
}
else if (objProduct.AppIsActive == false)
{
objProduct.AppIsActive = true;
}
objProduct.Save();
LoadDataGrid(false, false);
}
objProduct = null;
}
else if (e.CommandName == "QtyEdit")
{
hdnPkId.Value = e.CommandArgument.ToString();
tblProductDetail objProductDetail = new tblProductDetail();
objDataTable = objProductDetail.GetProductWiseProductDetail(e.CommandArgument.ToString());
objProductDetail = null;
if (objDataTable.Rows.Count > 0)
{
dgvProductQtyGridView.DataSource = objDataTable;
dgvProductQtyGridView.DataBind();
MPEProductQty.Show();
}
else
{
DInfo.ShowMessage("Insert Data First in Product.", Enums.MessageType.Error);
}
}
}
}
protected void ddlSize_SelectedIndexChanged(object sender, EventArgs e)
{
tblProductDetail objDetail = new tblProductDetail();
objDataTable = objDetail.GetProductDetail(ddlSize.SelectedValue);
if (objDataTable.Rows.Count > 0)
{
SpanPrice.InnerHtml = Session[appFunctions.Session.CurrencyImage.ToString()].ToString() + "" + Math.Round(Convert.ToDecimal(Session[appFunctions.Session.CurrencyInRupee.ToString()].ToString()) * Convert.ToDecimal(objDataTable.Rows[0][tblProductDetail.ColumnNames.AppPrice].ToString()), 0).ToString();
SpanMRP.InnerHtml = "Selling Price : " + Session[appFunctions.Session.CurrencyImage.ToString()].ToString() + "" + Math.Round(Convert.ToDecimal(Session[appFunctions.Session.CurrencyInRupee.ToString()].ToString()) * Convert.ToDecimal(objDataTable.Rows[0][tblProductDetail.ColumnNames.AppMRP].ToString()), 0).ToString();
decimal decPrice = Convert.ToDecimal(objDataTable.Rows[0][tblProductDetail.ColumnNames.AppPrice].ToString());
decimal decMRP = Convert.ToDecimal(objDataTable.Rows[0][tblProductDetail.ColumnNames.AppMRP].ToString());;
if (objDataTable.Rows[0]["appMRP1"].ToString() != "0.00")
{
SpanMRP2.InnerHtml = "MRP : " + Session[appFunctions.Session.CurrencyImage.ToString()].ToString() + "" + Math.Round(Convert.ToDecimal(Session[appFunctions.Session.CurrencyInRupee.ToString()].ToString()) * Convert.ToDecimal(objDataTable.Rows[0]["appMRP1"].ToString()), 0).ToString();
decMRP = Convert.ToDecimal(objDataTable.Rows[0]["appMRP1"].ToString());
SpanMRP2.Style.Add("text-decoration", "line-through");
SpanMRP.Style.Add("text-decoration", "line-through");
}
else
{
SpanMRP.InnerHtml = "MRP : " + Session[appFunctions.Session.CurrencyImage.ToString()].ToString() + "" + Math.Round(Convert.ToDecimal(Session[appFunctions.Session.CurrencyInRupee.ToString()].ToString()) * Convert.ToDecimal(objDataTable.Rows[0][tblProductDetail.ColumnNames.AppMRP].ToString()), 0).ToString();
SpanMRP2.Visible = false;
SpanMRP.Style.Add("text-decoration", "line-through");
}
int iPercentage = Convert.ToInt32(Math.Round((100 - ((decPrice * 100) / decMRP)), 0));
if (iPercentage != 0)
{
divProductOff.Style.Add("visibility", "visible");
lblDiscount.Text = iPercentage.ToString() + "%";
lblSaveRupee.Text = "(You are saving " + Session[appFunctions.Session.CurrencyImage.ToString()].ToString() + Math.Round(Convert.ToDecimal(Session[appFunctions.Session.CurrencyInRupee.ToString()].ToString()) * (decMRP - decPrice), 0).ToString() + ")";
}
else
{
divProductOff.Style.Add("visibility", "hidden");
lblDiscount.Text = "";
lblSaveRupee.Text = "";
}
}
objDetail = null;
}
protected void dgvColor_RowDataBound(object sender, GridViewRowEventArgs e)
{
DataControlRowType itemType = e.Row.RowType;
switch (itemType)
{
case DataControlRowType.DataRow:
string strID = dgvColor.DataKeys[e.Row.RowIndex].Values[0].ToString();
Repeater RepImg = (Repeater)e.Row.FindControl("RepImg");
tblProductImage objProductImage = new tblProductImage();
objDataTable = objProductImage.LoadGridData(strID);
RepImg.DataSource = objDataTable;
RepImg.DataBind();
objProductImage = null;
System.Web.UI.HtmlControls.HtmlGenericControl divSize = (System.Web.UI.HtmlControls.HtmlGenericControl)e.Row.FindControl("divSize");
GridView dgvsize = (GridView)e.Row.FindControl("dgvSize");
tblProductDetail objProductDetail = new tblProductDetail();
objDataTable = objProductDetail.LoadGridData(hdnPKID.Value, strID);
dgvsize.DataSource = null;
dgvsize.DataBind();
if (objDataTable.Rows.Count > 0)
{
divSize.Style.Add("display", "block");
dgvsize.DataSource = objDataTable;
dgvsize.DataBind();
}
else
{
divSize.Style.Add("display", "none");
}
objProductDetail = null;
break;
}
}
protected void btnUpdateQty_Click(object sender, EventArgs e)
{
foreach (GridViewRow row in dgvProductQtyGridView.Rows)
{
int intProductDetailID = Convert.ToInt32(dgvProductQtyGridView.DataKeys[row.RowIndex][0].ToString());
TextBox txtQuantity = (TextBox)row.FindControl("txtQuantity");
if (txtQuantity != null)
{
if (txtQuantity.Text != "")
{
tblProductDetail objProductDetail = new tblProductDetail();
if (objProductDetail.LoadByPrimaryKey(intProductDetailID))
{
objProductDetail.s_AppQuantity = txtQuantity.Text;
objProductDetail.Save();
}
objProductDetail = null;
}
}
}
DInfo.ShowMessage("Quantity is updated successfully.", Enums.MessageType.Successfull);
}
public void rpNewProduct_ItemCommand(Object Sender, RepeaterCommandEventArgs e)
{
if (e.CommandName == "Add To Cart")
{
if (e.CommandArgument.ToString() != "")
{
tblProductDetail objProductDetail = new tblProductDetail();
objDataTable = objProductDetail.LoadProductIDs(e.CommandArgument.ToString());
if (objDataTable.Rows.Count > 0)
{
if (Convert.ToInt32(objDataTable.Rows[0][tblProductDetail.ColumnNames.AppQuantity].ToString()) > 0)
{
objCommon = new clsCommon();
//objCommon.AddToCart(objDataTable.Rows[0][tblProductColor.ColumnNames.AppProductID].ToString(), objDataTable.Rows[0][tblProductDetail.ColumnNames.AppProductColorID].ToString(), e.CommandArgument.ToString());
objCommon.AddToCart(objDataTable.Rows[0][tblProductColor.ColumnNames.AppProductID].ToString(), objDataTable.Rows[0][tblProductDetail.ColumnNames.AppProductColorID].ToString(), e.CommandArgument.ToString(), 1);
objCommon = null;
SetCartProductCount();
ViewCart.LoadProduct();
}
else
{
DInfo.ShowMessage("Product out of stock.", Enums.MessageType.Error);
}
}
else
{
DInfo.ShowMessage("Product out of stock.", Enums.MessageType.Error);
}
objProductDetail = null;
}
else
{
DInfo.ShowMessage("Product out of stock.", Enums.MessageType.Error);
}
}
}
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);
}
public Boolean UpdateCart()
{
Boolean IsUpdate = true;
string StrMsg = "";
DataTable dtCart = new DataTable();
if ((HttpContext.Current.Session[appFunctions.Session.Cart.ToString()] != null))
{
dtCart = (DataTable)HttpContext.Current.Session[appFunctions.Session.Cart.ToString()];
}
foreach (GridViewRow row in dgvCart.Rows)
{
string strID = dgvCart.DataKeys[row.RowIndex].Values[0].ToString();
TextBox txt = (TextBox)row.FindControl("txtQty");
if (txt.Text != "" && txt.Text != "0")
{
DataRow[] dr = dtCart.Select(tblProductDetail.ColumnNames.AppProductDetailID.ToString() + "=" + strID);
if (dr.Length > 0)
{
tblProductDetail objProductDetail = new tblProductDetail();
if (objProductDetail.LoadByPrimaryKey(Convert.ToInt32(strID)))
{
if (objProductDetail.AppQuantity > 0)
{
int iQty = Convert.ToInt32(txt.Text);
if (objProductDetail.AppQuantity >= iQty)
{
dr[0]["appQty"] = iQty.ToString();
decimal appRealDiscountPrice = Convert.ToDecimal(dr[0]["appRealDiscountPrice"]);
decimal appTotalDiscount = Convert.ToDecimal(Convert.ToDecimal(dr[0]["appQty"]) * appRealDiscountPrice);
dr[0]["appDiscountPrice"] = appTotalDiscount;
dr[0]["appTotalPrice"] = ((Convert.ToDecimal(dr[0]["appRealPrice"].ToString()) * Convert.ToDecimal(dr[0]["appQty"])) - appTotalDiscount).ToString();
dr[0][tblProductDetail.ColumnNames.AppPrice] = (Convert.ToDecimal(dr[0]["appRealPrice"].ToString()) * Convert.ToDecimal(dr[0]["appQty"])).ToString();
//if (strCouponDiscount == "0")
//decimal appRealDiscountPrice = Convert.ToDecimal(dr[0]["appRealDiscountPrice"]);
//decimal appTotalDiscount = Convert.ToDecimal(iQty * appRealDiscountPrice);
//dr[0]["appDiscountPrice"] = appTotalDiscount;
//if (hdnIsInDeal.Value == "0")
//{
// dr[0]["appTotalPrice"] = (Convert.ToDecimal(dr[0]["appPrice"].ToString()) * iQty - (appTotalDiscount)).ToString();
//}
//else
//{
// dr[0]["appTotalPrice"] = (Convert.ToDecimal(dr[0]["appRealPrice"].ToString()) * iQty - (appTotalDiscount)).ToString();
//}
// dr[0]["appTotalPrice"] = (Convert.ToDecimal(dr[0]["appRealPrice"].ToString()) * iQty).ToString();
dtCart.AcceptChanges();
}
else
{
StrMsg = dr[0][tblProduct.ColumnNames.AppProductName].ToString() + " product only " + objProductDetail.s_AppQuantity + " Quantity avaliable ";
}
}
else
{
StrMsg = dr[0][tblProduct.ColumnNames.AppProductName].ToString() + " Product out of stock.";
}
}
objProductDetail = null;
}
}
else
{
LoadProduct();
if (txt.Text == "0")
{
DInfo.ShowMessage("Quantity must be non zero", Enums.MessageType.Error);
}
else
{
DInfo.ShowMessage("Quantity must be entered in product", Enums.MessageType.Error);
}
return(false);
}
}
if (IsUpdate)
{
HttpContext.Current.Session[appFunctions.Session.Cart.ToString()] = dtCart;
}
if (StrMsg != "")
{
DInfo.ShowMessage(StrMsg, Enums.MessageType.Error);
return(false);
}
return(true);
}
public Boolean SaveLeadData()
{
DataTable objDataTable = new DataTable();
if (Session[appFunctions.Session.LeadDataTable.ToString()] != null)
{
objDataTable = (DataTable)Session[appFunctions.Session.LeadDataTable.ToString()];
}
if (objDataTable.Rows.Count <= 0)
{
DInfo.ShowMessage("Some Error Occure Try again!.", Enums.MessageType.Error);
return(false);
}
objCommon = new clsCommon();
foreach (DataRow row in objDataTable.Rows)
{
tblProduct objProduct = new tblProduct();
objProduct.Where.AppProductName.Value = row[Enums.Enums_ProductHeader.Product_Name.ToString().Replace("_", " ").Trim().ToLower()].ToString();
objProduct.Query.Load();
if (objProduct.RowCount <= 0)
{
objProduct.AddNew();
}
objProduct.s_AppProductName = row[Enums.Enums_ProductHeader.Product_Name.ToString().Replace("_", " ").Trim().ToLower()].ToString();
objProduct.s_AppProductCode = row[Enums.Enums_ProductHeader.Product_Code.ToString().Replace("_", " ").Trim().ToLower()].ToString();
objProduct.s_AppDescription = row[Enums.Enums_ProductHeader.Description.ToString().Replace("_", " ").Trim().ToLower()].ToString();
//objProduct.s_AppProductTag = row[Enums.Enums_ProductHeader.Description.ToString().Replace("_", " ").Trim().ToLower()].ToString();
objProduct.s_AppMetaKeyWord = row[Enums.Enums_ProductHeader.Meta_KeyWord.ToString().Replace("_", " ").Trim().ToLower()].ToString();
objProduct.s_AppMetaDescription = row[Enums.Enums_ProductHeader.Meta_Description.ToString().Replace("_", " ").Trim().ToLower()].ToString();
objProduct.AppIsFeatured = false;
objProduct.AppIsNewArrival = false;
objProduct.AppIsBestSeller = false;
objProduct.AppIsColor = true;
objProduct.AppIsSize = true;
objProduct.Save();
//Color Add or Modify
string strColorId = GetColorId(row[Enums.Enums_ProductHeader.Color_Name.ToString().Replace("_", " ").Trim().ToLower()].ToString());
tblProductColor objProductColor = new tblProductColor();
objProductColor.Where.AppProductID.Value = objProduct.s_AppProductID;
objProductColor.Where.AppColorID.Value = strColorId;
objProductColor.Query.Load();
if (objProductColor.RowCount <= 0)
{
objProductColor.AddNew();
objProductColor.AppDisplayOrder = objCommon.GetNextDisplayOrder("tblProductColor", tblProductColor.ColumnNames.AppDisplayOrder, tblProductColor.ColumnNames.AppProductID + "=" + objProduct.s_AppProductID);
}
objProductColor.s_AppColorID = strColorId;
objProductColor.s_AppProductID = objProduct.s_AppProductID;
if (objProductColor.AppDisplayOrder == 1)
{
objProductColor.AppIsDefault = true;
}
else
{
objProductColor.AppIsDefault = false;
}
objProductColor.AppIsActive = true;
objProductColor.Save();
//Size Add or Modify
string strSizeId = GetSizeId(row[Enums.Enums_ProductHeader.Size.ToString().Replace("_", " ").Trim().ToLower()].ToString());
tblProductDetail objProductDetail = new tblProductDetail();
objProductDetail.Where.AppProductColorID.Value = objProductColor.s_AppProductColorID;
objProductDetail.Where.AppSizeID.Value = strSizeId;
objProductDetail.Query.Load();
if (objProductDetail.RowCount <= 0)
{
objProductDetail.AddNew();
}
objProductDetail.s_AppProductColorID = objProductColor.s_AppProductColorID;
//objProductDetail.s_AppSellerPrice = row[Enums.Enums_ProductHeader.Seller_Price.ToString().Replace("_", " ").Trim().ToLower()].ToString();
objProductDetail.s_AppMRP = row[Enums.Enums_ProductHeader.MRP.ToString().Replace("_", " ").Trim().ToLower()].ToString();
objProductDetail.s_AppPrice = row[Enums.Enums_ProductHeader.Price.ToString().Replace("_", " ").Trim().ToLower()].ToString();
objProductDetail.s_AppQuantity = row[Enums.Enums_ProductHeader.Quantity.ToString().Replace("_", " ").Trim().ToLower()].ToString();
objProductDetail.AppSKUNo = row[Enums.Enums_ProductHeader.SKU_No.ToString().Replace("_", " ").Trim().ToLower()].ToString();
objProductDetail.s_AppSizeID = strSizeId;
objProductDetail.AppIsDefault = false;
tblProductDetail objTempmg = new tblProductDetail();
objTempmg.Where.AppProductColorID.Value = strSizeId;
objTempmg.Query.Load();
if (objTempmg.RowCount <= 0)
{
objProductDetail.AppIsDefault = true;
}
objTempmg = null;
objProductDetail.Save();
objProductDetail = null;
string StrFolder = "Uploads/Product/" + objProduct.s_AppProductID + "/";
string strImgName = objProduct.s_AppProductName.Trim().Replace(" ", "_") + "_" + row[Enums.Enums_ProductHeader.Color_Name.ToString().Replace("_", " ").Trim().ToLower()].ToString().Replace(" ", "_");
if (!(System.IO.Directory.Exists(Server.MapPath("~/admin/" + StrFolder))))
{
System.IO.Directory.CreateDirectory(Server.MapPath("~/admin/" + StrFolder));
}
for (int i = 1; i <= 4; i++)
{
string ImgPath = row[Enums.Enums_ProductHeader.Image.ToString().Replace("_", " ").Trim().ToLower() + " " + i.ToString()].ToString();
try
{
System.Drawing.Bitmap upBmp = (System.Drawing.Bitmap)System.Drawing.Image.FromFile(ImgPath);
if (row[Enums.Enums_ProductHeader.Image.ToString().Replace("_", " ").Trim().ToLower() + " " + i.ToString()].ToString() != "")
{
tblProductImage objProductImg = new tblProductImage();
objProductImg.AddNew();
objProductImg.s_AppProductColorID = objProductColor.s_AppProductColorID;
objProductImg.AppDisplayOrder = objCommon.GetNextDisplayOrder("tblProductImage", tblProductImage.ColumnNames.AppDisplayOrder, tblProductImage.ColumnNames.AppProductColorID + "=" + objProductColor.s_AppProductColorID);
string strError = "";
string Time = Convert.ToString(DateTime.Now.Month) + Convert.ToString(DateTime.Now.Day) + Convert.ToString(DateTime.Now.Year) + Convert.ToString(DateTime.Now.Hour) + Convert.ToString(DateTime.Now.Minute) + Convert.ToString(DateTime.Now.Second) + Convert.ToString(DateTime.Now.Millisecond);
string strPath = objCommon.ResizeDirectImagesFile(ImgPath, strImgName + "_" + Time + "_Thumb", 0, ref strError, StrFolder, 0, 91);
if (strError == "")
{
objProductImg.s_AppThumbImage = strPath;
}
strError = "";
strPath = objCommon.ResizeDirectImagesFile(ImgPath, strImgName + "_" + Time + "_Normal", 0, ref strError, StrFolder, 0, 300);
if (strError == "")
{
objProductImg.s_AppNormalImage = strPath;
}
strError = "";
strPath = objCommon.ResizeDirectImagesFile(ImgPath, strImgName + "_" + Time + "_Large", 0, ref strError, StrFolder, 0, 900);
if (strError == "")
{
objProductImg.s_AppLargeImage = strPath;
}
strError = "";
strPath = objCommon.ResizeDirectImagesFile(ImgPath, strImgName + "_" + Time + "_Small", 0, ref strError, StrFolder, 0, 210);
if (strError == "")
{
objProductImg.s_AppSmallImage = strPath;
}
objProductImg.AppIsActive = true;
objProductImg.AppIsDefault = false;
if (objProductImg.AppDisplayOrder == 1)
{
objProductImg.AppIsActive = true;
objProductImg.AppIsDefault = true;
}
objProductImg.Save();
objProductImg = null;
}
}
catch (Exception ex)
{
}
}
objProductColor = null;
objProduct = null;
//objlead.s_appcampaignid = row["appcampaignid"].tostring();
}
objCommon = null;
objDataTable = null;
return(true);
}
