public void GetProductVariableValueByProductVariableID(int ProductVariableID, string username, string password)
{
var rs = new ResponseClass();
if (Login(username, password))
{
var ProductVariableValue = ProductVariableValueController.GetByProductVariableID(ProductVariableID);
if (ProductVariableValue.Count > 0)
{
rs.Code = APIUtils.GetResponseCode(APIUtils.ResponseCode.SUCCESS);
rs.Status = APIUtils.ResponseMessage.Success.ToString();
rs.ProductVariableValue = ProductVariableValue;
}
else
{
rs.Code = APIUtils.GetResponseCode(APIUtils.ResponseCode.NotFound);
rs.Status = APIUtils.ResponseMessage.Error.ToString();
rs.Message = APIUtils.OBJ_DNTEXIST;
}
}
else
{
rs.Code = APIUtils.GetResponseCode(APIUtils.ResponseCode.FAILED);
rs.Status = APIUtils.ResponseMessage.Fail.ToString();
}
Context.Response.ContentType = "application/json";
Context.Response.Write(JsonConvert.SerializeObject(rs, Formatting.Indented));
Context.Response.Flush();
Context.Response.End();
}
public void pagingall(List <tbl_ProductVariable> acs)
{
int PageSize = 30;
StringBuilder html = new StringBuilder();
html.Append("<div class='row'>");
if (acs.Count > 0)
{
int TotalItems = acs.Count;
if (TotalItems % PageSize == 0)
{
PageCount = TotalItems / PageSize;
}
else
{
PageCount = TotalItems / PageSize + 1;
}
Int32 Page = GetIntFromQueryString("Page");
if (Page == -1)
{
Page = 1;
}
int FromRow = (Page - 1) * PageSize;
int ToRow = Page * PageSize - 1;
if (ToRow >= TotalItems)
{
ToRow = TotalItems - 1;
}
for (int i = FromRow; i < ToRow + 1; i++)
{
var item = acs[i];
html.Append("<div class='col-md-3 product-item'>");
html.Append(" <div><img src='" + Thumbnail.getURL(item.Image, Thumbnail.Size.Large) + "'></div>");
if (!string.IsNullOrEmpty(item.Image))
{
html.Append(" <div><a href='" + Thumbnail.getURL(item.Image, Thumbnail.Size.Source) + "' download class='btn download-btn h45-btn'><i class='fa fa-cloud-download'></i> Tải hình này</a></div>");
}
var value = ProductVariableValueController.GetByProductVariableID(item.ID);
if (value != null)
{
foreach (var temp in value)
{
html.Append("<h3>" + temp.VariableName + ": " + temp.VariableValue + "</h3>");
}
}
html.Append(" <p>Mã: " + item.SKU + "</p>");
html.Append(" <p>Giá sỉ: " + string.Format("{0:N0}", item.Regular_Price) + "</p>");
html.Append(" <p>Kho: " + PJUtils.StockStatusBySKU(1, item.SKU) + " (" + PJUtils.TotalProductQuantityInstock(1, item.SKU) + " cái)</p>");
html.Append("</div>");
}
}
ltrList.Text = html.ToString();
}
public void LoadData()
{
List <tbl_ProductVariableValue> a = new List <tbl_ProductVariableValue>();
int productvariableid = Request.QueryString["productvariableid"].ToInt(0);
if (productvariableid > 0)
{
var pv = ProductVariableController.GetByID(productvariableid);
if (pv != null)
{
ltrBack.Text = "<a href=\"/thuoc-tinh-san-pham?id=" + pv.ProductID + "\" class=\"btn primary-btn h45-btn\">Trở về</a>";
lblCategoryName.Text = "Giá trị thuộc tính sản phẩm";
ltrAddnew.Text = "<a href=\"/them-gia-tri-thuoc-tinh?productvariableid=" + productvariableid + "\" class=\"h45-btn btn\" style=\"background-color: #ff3f4c\">Thêm mới</a>";
}
a = ProductVariableValueController.GetByProductVariableID(productvariableid);
pagingall(a);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
DateTime currentDate = DateTime.Now;
int AgentID = 0;
string username = Request.Cookies["usernameLoginSystem"].Value;
if (!string.IsNullOrEmpty(username))
{
var a = AccountController.GetByUsername(username);
if (a != null)
{
AgentID = Convert.ToInt32(a.AgentID);
string phone = hdfPhone.Value;
if (!string.IsNullOrEmpty(phone))
{
var cust = CustomerController.GetByPhone(phone);
if (cust != null)
{
#region Tạo đơn hàng đổi tra
int custID = cust.ID;
string totalprice = hdfTotalPrice.Value;
string totalquantity = hdfTotalQuantity.Value;
string totalrefund = hdfTotalRefund.Value;
var agent = AgentController.GetByID(AgentID);
string agentName = "";
if (agent != null)
{
agentName = agent.AgentName;
}
//insert ddlstatus, refundnote
int status = ddlRefundStatus.SelectedValue.ToInt();
string RefundsNote = txtRefundsNote.Text;
int rID = RefundGoodController.Insert(AgentID, totalprice, status, custID, Convert.ToInt32(totalquantity),
totalrefund, agentName, cust.CustomerName, cust.CustomerPhone, currentDate, username, RefundsNote);
#endregion
if (rID > 0)
{
string listString = hdfListProduct.Value;
string[] items = listString.Split('|');
if (items.Length - 1 > 0)
{
for (int i = 0; i < items.Length - 1; i++)
{
#region Tạo chi tiết đơn hàng đổi tra
string[] element = items[i].Split(';');
var sku = element[0];
var orderID = element[1].ToInt(0);
var orderDetailID = element[2];
var ProductName = element[3];
var GiavonPerProduct = Convert.ToDouble(element[5]);
var SoldPricePerProduct = Convert.ToDouble(element[6]);
var DiscountPricePerProduct = Convert.ToDouble(element[7]);
var quantity = Convert.ToDouble(element[10]);
var quantityMax = Convert.ToDouble(element[8]);
var ProductType = element[4].ToInt(1);
var RefundType = element[9].ToInt(1);
var RefundFeePerProduct = Convert.ToDouble(element[11]);
var TotalPriceRow = element[12];
var PriceNotFeeRefund = SoldPricePerProduct * quantity;
var rdTotalRefundFee = RefundFeePerProduct * quantity;
int rdID = RefundGoodDetailController.Insert(rID, AgentID, orderID, ProductName, custID, sku, quantity,
quantityMax, PriceNotFeeRefund.ToString(), ProductType, true, RefundType, RefundFeePerProduct.ToString(),
rdTotalRefundFee.ToString(), GiavonPerProduct.ToString(), DiscountPricePerProduct.ToString(), SoldPricePerProduct.ToString(),
TotalPriceRow, currentDate, username);
#endregion
#region Cập nhật stock
if (rdID > 0)
{
if (RefundType < 3)
{
int typeRe = 0;
string note = "";
if (RefundType == 1)
{
note = "Đổi size";
typeRe = 8;
}
else if (RefundType == 2)
{
note = "Đổi sản phẩm";
typeRe = 9;
}
if (ProductType == 1)
{
var product = ProductController.GetBySKU(sku);
if (product != null)
{
int productID = product.ID;
string ProductImageOrigin = "";
var ProductImage = ProductImageController.GetFirstByProductID(product.ID);
if (ProductImage != null)
{
ProductImageOrigin = ProductImage.ProductImage;
}
StockManagerController.Insert(
new tbl_StockManager {
AgentID = AgentID,
ProductID = productID,
ProductVariableID = 0,
Quantity = quantity,
QuantityCurrent = 0,
Type = 1,
NoteID = note,
OrderID = orderID,
Status = typeRe,
SKU = sku,
CreatedDate = currentDate,
CreatedBy = username,
MoveProID = 0,
ParentID = productID,
});
}
}
else
{
string ProductVariableName = "";
string ProductVariableValue = "";
string ProductVariable = "";
int parentID = 0;
string parentSKU = "";
string ProductImageOrigin = "";
int ID = 0;
var productvariable = ProductVariableController.GetBySKU(sku);
if (productvariable != null)
{
ID = productvariable.ID;
ProductImageOrigin = productvariable.Image;
parentSKU = productvariable.ParentSKU;
var variables = ProductVariableValueController.GetByProductVariableID(productvariable.ID);
if (variables.Count > 0)
{
foreach (var v in variables)
{
ProductVariable += v.VariableName.Trim() + ":" + v.VariableValue.Trim() + "|";
ProductVariableName += v.VariableName + "|";
ProductVariableValue += v.VariableValue + "|";
}
}
}
if (!string.IsNullOrEmpty(parentSKU))
{
var product = ProductController.GetBySKU(parentSKU);
if (product != null)
{
parentID = product.ID;
}
}
StockManagerController.Insert(
new tbl_StockManager {
AgentID = AgentID,
ProductID = 0,
ProductVariableID = ID,
Quantity = quantity,
QuantityCurrent = 0,
Type = 1,
NoteID = note,
OrderID = orderID,
Status = typeRe,
SKU = sku,
CreatedDate = currentDate,
CreatedBy = username,
MoveProID = 0,
ParentID = parentID,
});
}
}
}
#endregion
}
RefundGoodController.updateQuantityCOGS(rID);
PJUtils.ShowMessageBoxSwAlertCallFunction("Tạo đơn hàng đổi trả thành công", "s", true, "redirectTo(" + rID + ")", Page);
}
}
}
}
}
}
}
public static string getProduct(string textsearch, int typeinout)
{
List <ProductGetOut> ps = new List <ProductGetOut>();
string username = HttpContext.Current.Request.Cookies["userLoginSystem"].Value;
var acc = AccountController.GetByUsername(username);
if (acc != null)
{
int AgentID = Convert.ToInt32(acc.AgentID);
if (typeinout == 1)
{
var products = ProductController.GetByTextSearchIsHidden(textsearch.Trim(), false);
if (products.Count > 0)
{
foreach (var item in products)
{
var productvariable = ProductVariableController.GetProductID(item.ID);
if (productvariable.Count > 0)
{
foreach (var pv in productvariable)
{
string SKU = pv.SKU.Trim().ToUpper();
var check = StockManagerController.GetBySKU(AgentID, SKU);
if (check.Count > 0)
{
double total = PJUtils.TotalProductQuantityInstock(AgentID, SKU);
if (total > 0)
{
var variables = ProductVariableValueController.GetByProductVariableID(pv.ID);
if (variables.Count > 0)
{
string variablename = "";
string variablevalue = "";
string variable = "";
foreach (var v in variables)
{
variable += v.VariableName.Trim() + ":" + v.VariableValue.Trim() + "|";
variablename += v.VariableName.Trim() + "|";
variablevalue += v.VariableValue.Trim() + "|";
}
ProductGetOut p = new ProductGetOut();
p.ID = pv.ID;
p.ProductName = item.ProductTitle;
p.ProductVariable = variable;
p.ProductVariableName = variablename;
p.ProductVariableValue = variablevalue;
p.ProductType = 2;
p.ProductImage = "<img src=\"" + pv.Image + "\" alt=\"\" style=\"width: 50px\" />";
p.ProductImageOrigin = pv.Image;
p.QuantityInstock = total;
p.QuantityInstockString = string.Format("{0:N0}", total);
p.SKU = SKU;
int supplierID = 0;
if (pv.SupplierID != null)
{
supplierID = pv.SupplierID.ToString().ToInt(0);
}
p.SupplierID = supplierID;
string supplierName = "";
if (!string.IsNullOrEmpty(pv.SupplierName))
{
supplierName = pv.SupplierName;
}
p.SupplierName = supplierName;
ps.Add(p);
}
}
}
}
}
else
{
string SKU = item.ProductSKU.Trim().ToUpper();
var check = StockManagerController.GetBySKU(AgentID, SKU);
if (check.Count > 0)
{
double total = PJUtils.TotalProductQuantityInstock(AgentID, SKU);
if (total > 0)
{
string variablename = "";
string variablevalue = "";
string variable = "";
ProductGetOut p = new ProductGetOut();
p.ID = item.ID;
p.ProductName = item.ProductTitle;
p.ProductVariable = variable;
p.ProductVariableName = variablename;
p.ProductVariableValue = variablevalue;
p.ProductType = 1;
var img = ProductImageController.GetFirstByProductID(item.ID);
if (img != null)
{
p.ProductImage = "<img src=\"" + img.ProductImage + "\" alt=\"\" style=\"width: 50px\" />";
p.ProductImageOrigin = img.ProductImage;
}
else
{
p.ProductImage = "";
p.ProductImageOrigin = "";
}
p.QuantityInstock = total;
p.QuantityInstockString = string.Format("{0:N0}", total);
p.SKU = SKU;
int supplierID = 0;
if (item.SupplierID != null)
{
supplierID = item.SupplierID.ToString().ToInt(0);
}
p.SupplierID = supplierID;
string supplierName = "";
if (!string.IsNullOrEmpty(item.SupplierName))
{
supplierName = item.SupplierName;
}
p.SupplierName = supplierName;
ps.Add(p);
}
}
}
}
}
}
else
{
var products = ProductController.GetBySKU(textsearch);
if (products != null)
{
var productvariable = ProductVariableController.GetProductID(products.ID);
if (productvariable.Count > 0)
{
foreach (var pv in productvariable)
{
string SKU = pv.SKU.Trim().ToUpper();
var check = StockManagerController.GetBySKU(AgentID, SKU);
if (check.Count > 0)
{
double total = PJUtils.TotalProductQuantityInstock(AgentID, SKU);
if (total > 0)
{
var variables = ProductVariableValueController.GetByProductVariableID(pv.ID);
if (variables.Count > 0)
{
string variablename = "";
string variablevalue = "";
string variable = "";
foreach (var v in variables)
{
variable += v.VariableName.Trim() + ":" + v.VariableValue.Trim() + "|";
variablename += v.VariableName.Trim() + "|";
variablevalue += v.VariableValue.Trim() + "|";
}
ProductGetOut p = new ProductGetOut();
p.ID = pv.ID;
p.ProductName = products.ProductTitle;
p.ProductVariable = variable;
p.ProductVariableName = variablename;
p.ProductVariableValue = variablevalue;
p.ProductType = 2;
p.ProductImage = "<img src=\"" + pv.Image + "\" alt=\"\" style=\"width: 50px\" />";
p.ProductImageOrigin = pv.Image;
p.QuantityInstock = total;
p.QuantityInstockString = string.Format("{0:N0}", total);
p.SKU = SKU;
int supplierID = 0;
if (pv.SupplierID != null)
{
supplierID = pv.SupplierID.ToString().ToInt(0);
}
p.SupplierID = supplierID;
string supplierName = "";
if (!string.IsNullOrEmpty(pv.SupplierName))
{
supplierName = pv.SupplierName;
}
p.SupplierName = supplierName;
ps.Add(p);
}
}
}
}
}
else
{
string SKU = products.ProductSKU.Trim().ToUpper();
var check = StockManagerController.GetBySKU(AgentID, SKU);
if (check.Count > 0)
{
double total = PJUtils.TotalProductQuantityInstock(AgentID, SKU);
if (total > 0)
{
string variablename = "";
string variablevalue = "";
string variable = "";
ProductGetOut p = new ProductGetOut();
p.ID = products.ID;
p.ProductName = products.ProductTitle;
p.ProductVariable = variable;
p.ProductVariableName = variablename;
p.ProductVariableValue = variablevalue;
p.ProductType = 1;
var img = ProductImageController.GetFirstByProductID(products.ID);
if (img != null)
{
p.ProductImage = "<img src=\"" + img.ProductImage + "\" alt=\"\" style=\"width: 50px\" />";
p.ProductImageOrigin = img.ProductImage;
}
else
{
p.ProductImage = "";
p.ProductImageOrigin = "";
}
p.SKU = SKU;
p.QuantityInstock = total;
p.QuantityInstockString = string.Format("{0:N0}", total);
int supplierID = 0;
if (products.SupplierID != null)
{
supplierID = products.SupplierID.ToString().ToInt(0);
}
p.SupplierID = supplierID;
string supplierName = "";
if (!string.IsNullOrEmpty(products.SupplierName))
{
supplierName = products.SupplierName;
}
p.SupplierName = supplierName;
ps.Add(p);
}
}
}
}
else
{
var productvariable = ProductVariableController.GetAllBySKU(textsearch);
if (productvariable != null)
{
foreach (var value in productvariable)
{
string SKU = value.SKU.Trim().ToUpper();
var check = StockManagerController.GetBySKU(AgentID, SKU);
if (check.Count > 0)
{
double total = PJUtils.TotalProductQuantityInstock(AgentID, SKU);
if (total > 0)
{
var variables = ProductVariableValueController.GetByProductVariableID(value.ID);
if (variables.Count > 0)
{
string variablename = "";
string variablevalue = "";
string variable = "";
foreach (var v in variables)
{
variable += v.VariableName + ":" + v.VariableValue + "|";
variablename += v.VariableName + "|";
variablevalue += v.VariableValue + "|";
}
ProductGetOut p = new ProductGetOut();
p.ID = value.ID;
var product = ProductController.GetByID(Convert.ToInt32(value.ProductID));
if (product != null)
{
p.ProductName = product.ProductTitle;
}
p.ProductVariable = variable;
p.ProductVariableName = variablename;
p.ProductVariableValue = variablevalue;
p.ProductType = 2;
p.ProductImage = "<img src=\"" + value.Image + "\" alt=\"\" style=\"width:50px;\" />";
p.ProductImageOrigin = value.Image;
p.SKU = value.SKU.Trim().ToUpper();
p.QuantityInstock = total;
p.QuantityInstockString = string.Format("{0:N0}", total);
int supplierID = 0;
if (value.SupplierID != null)
{
supplierID = value.SupplierID.ToString().ToInt(0);
}
p.SupplierID = supplierID;
string supplierName = "";
if (!string.IsNullOrEmpty(value.SupplierName))
{
supplierName = value.SupplierName;
}
p.SupplierName = supplierName;
ps.Add(p);
}
}
}
}
}
}
}
}
JavaScriptSerializer serializer = new JavaScriptSerializer();
return(serializer.Serialize(ps));
}
/// <summary>
/// Tải thông tin của biến thể
/// </summary>
/// <param name="productID"></param>
private void _loadProductVariationInfo(int productID)
{
var html = new StringBuilder();
var variations = ProductVariableController
.GetProductID(productID)
.OrderByDescending(o => o.ID);
var index = variations.Count();
foreach (var item in variations)
{
string VariableSKU = item.SKU;
double RegularPrice = Convert.ToDouble(item.Regular_Price);
double RetailPrice = Convert.ToDouble(item.RetailPrice);
double CostOfGood = Convert.ToDouble(item.CostOfGood);
int MinimumInventoryLevel = Convert.ToInt32(item.MinimumInventoryLevel);
int MaximumInventoryLevel = Convert.ToInt32(item.MaximumInventoryLevel);
string VariableImage = Thumbnail.getURL(item.Image, Thumbnail.Size.Source);
string deleteVariableImage = "<a href='javascript:;' onclick='deleteImageVariable($(this))' class='btn-delete hide'><i class='fa fa-times' aria-hidden='true'></i> Xóa hình</a>";
if (!string.IsNullOrEmpty(item.Image))
{
deleteVariableImage = "<a href='javascript:;' onclick='deleteImageVariable($(this))' class='btn-delete'><i class='fa fa-times' aria-hidden='true'></i> Xóa hình</a>";
}
var value = ProductVariableValueController.GetByProductVariableID(item.ID);
string selectVariable = "";
string variableID = "";
string variableName = "";
string variableValueID = "";
string variableValueName = "";
string dataVariableValue = "";
string labelVariableValue = "";
if (value != null)
{
foreach (var temp in value)
{
selectVariable += "<div class='row margin-bottom-15'><div class='col-md-5'>" + temp.VariableName + "</div><div class='col-md-7'>" + _getSelectVariable(temp.VariableName, temp.VariableValue) + "</div></div>";
variableID += VariableController.GetByName(temp.VariableName.ToString()).ID.ToString() + "|";
variableName += temp.VariableName.ToString() + "|";
variableValueID += temp.VariableValueID.ToString() + "|";
variableValueName += temp.VariableValue.ToString() + "|";
dataVariableValue += VariableController.GetByName(temp.VariableName.ToString()).ID.ToString() + ":" + temp.VariableValueID.ToString() + "|";
labelVariableValue += temp.VariableName.ToString() + ": " + temp.VariableValue.ToString() + " - ";
}
}
html.AppendLine(String.Format("<div class='item-var-gen'"));
html.AppendLine(String.Format(" data-index='{0}'", index));
html.AppendLine(String.Format(" data-product-variation-id='{0}'", item.ID));
html.AppendLine(String.Format(" data-name-id='{0}'", variableID));
html.AppendLine(String.Format(" data-value-id='{0}'", variableValueID));
html.AppendLine(String.Format(" data-name-text='{0}'", variableName));
html.AppendLine(String.Format(" data-value-text='{0}'", variableValueName));
html.AppendLine(String.Format(" data-name-value='{0}'", dataVariableValue));
html.AppendLine(String.Format(">"));
html.AppendLine(String.Format(" <div class='col-md-12'>"));
html.AppendLine(String.Format(" <div class='col-md-10 variable-label' onclick='showVariableContent($(this))'>"));
html.AppendLine(String.Format(" <strong>#{0}</strong> - {1} {2}", index, labelVariableValue, VariableSKU));
html.AppendLine(String.Format(" </div>"));
html.AppendLine(String.Format(" <div class='col-md-2 variable-removal'>"));
html.AppendLine(String.Format(" <a href='javascript:;' onclick='deleteVariableItem($(this))' class='btn primary-btn fw-btn not-fullwidth'>"));
html.AppendLine(String.Format(" <i class='fa fa-times' aria-hidden='true'></i>"));
html.AppendLine(String.Format(" </a>"));
html.AppendLine(String.Format(" </div>"));
html.AppendLine(String.Format(" </div>"));
html.AppendLine(String.Format(" <div class='col-md-12 variable-content'>"));
html.AppendLine(String.Format(" <div class='row'>"));
html.AppendLine(String.Format(" <div class='col-md-2'>"));
html.AppendLine(String.Format(" <input type='file' class='productVariableImage upload-btn' onchange='onChangeVariationImage(this,$(this));' name='{0}'><img class='imgpreview' onclick='openUploadImage($(this))' data-file-name='{1}' src='{1}'>{2}", VariableSKU, VariableImage, deleteVariableImage));
html.AppendLine(String.Format(" </div>"));
html.AppendLine(String.Format(" <div class='col-md-5'>"));
html.AppendLine(String.Format(" {0}", selectVariable));
html.AppendLine(String.Format(" <div class='row margin-bottom-15'>"));
html.AppendLine(String.Format(" <div class='col-md-5'>Mã sản phẩm</div>"));
html.AppendLine(String.Format(" <div class='col-md-7'><input type='text' disabled class='form-control productvariablesku sku-input' value='{0}' disabled='disabled' readonly></div>", VariableSKU));
html.AppendLine(String.Format(" </div>"));
html.AppendLine(String.Format(" </div>"));
html.AppendLine(String.Format(" <div class='col-md-5'>"));
html.AppendLine(String.Format(" <div class='row margin-bottom-15'>"));
html.AppendLine(String.Format(" <div class='col-md-5'>Giá sỉ</div>"));
html.AppendLine(String.Format(" <div class='col-md-7'><input class='form-control regularprice' type='number' value='{0}'> </div>", RegularPrice));
html.AppendLine(String.Format(" </div>"));
html.AppendLine(String.Format(" <div class='row margin-bottom-15 cost-of-goods'>"));
html.AppendLine(String.Format(" <div class='col-md-5'>Giá vốn</div>"));
html.AppendLine(String.Format(" <div class='col-md-7'><input class='form-control costofgood cost-price' type='number' value='{0}'></div>", CostOfGood));
html.AppendLine(String.Format(" </div>"));
html.AppendLine(String.Format(" <div class='row margin-bottom-15'>"));
html.AppendLine(String.Format(" <div class='col-md-5'>Giá bán lẻ</div>"));
html.AppendLine(String.Format(" <div class='col-md-7'><input class='form-control retailprice' type='number' value='{0}'></div>", RetailPrice));
html.AppendLine(String.Format(" </div>"));
html.AppendLine(String.Format(" </div>"));
html.AppendLine(String.Format(" </div>"));
html.AppendLine(String.Format(" </div>"));
html.AppendLine(String.Format("</div>"));
index--;
}
if (variations.Count() > 0)
{
ltrVariables.Text = html.ToString();
}
}
public void pagingall(List <tbl_ProductVariable> acs)
{
string productname = ViewState["ProductName"].ToString();
int PageSize = 15;
StringBuilder html = new StringBuilder();
if (acs.Count > 0)
{
int TotalItems = acs.Count;
if (TotalItems % PageSize == 0)
{
PageCount = TotalItems / PageSize;
}
else
{
PageCount = TotalItems / PageSize + 1;
}
Int32 Page = GetIntFromQueryString("Page");
if (Page == -1)
{
Page = 1;
}
int FromRow = (Page - 1) * PageSize;
int ToRow = Page * PageSize - 1;
if (ToRow >= TotalItems)
{
ToRow = TotalItems - 1;
}
for (int i = FromRow; i < ToRow + 1; i++)
{
var item = acs[i];
html.Append("<tr>");
if (!string.IsNullOrEmpty(item.Image))
{
html.Append(" <td><img src=\"" + item.Image + "\"/></td>");
}
else
{
html.Append(" <td><img src=\"/App_Themes/Ann/image/placeholder.png\"/></td>");
}
string date = string.Format("{0:dd/MM/yyyy}", item.CreatedDate);
string ishidden = "";
if (item.IsHidden != null)
{
bool IsHidden = Convert.ToBoolean(item.IsHidden);
ishidden = PJUtils.IsHiddenStatus(IsHidden);
}
else
{
ishidden = PJUtils.IsHiddenStatus(false);
}
var value = ProductVariableValueController.GetByProductVariableID(item.ID);
if (value != null)
{
html.Append(" <td>");
string list = "";
foreach (var temp in value)
{
html.Append("" + temp.VariableName + ": " + temp.VariableValue + "</br>" + "");
list += temp.VariableName + "|";
}
html.Append("</td>");
hdfSearch.Value = list;
}
html.Append(" <td>" + item.SKU + "</td>");
html.Append(" <td>" + string.Format("{0:N0}", item.Regular_Price) + "</td>");
int k = Convert.ToInt32(ViewState["role"]);
if (k == 0)
{
html.Append(" <td>" + string.Format("{0:N0}", item.CostOfGood) + "</td>");
}
html.Append(" <td>" + string.Format("{0:N0}", item.RetailPrice) + "</td>");
html.Append(" <td>" + PJUtils.TotalProductQuantityInstock(1, item.SKU) + "</td>");
html.Append(" <td>" + PJUtils.StockStatusBySKU(1, item.SKU) + "</td>");
html.Append(" <td>" + date + "</td>");
html.Append(" <td>" + ishidden + "</td>");
html.Append(" <td>");
html.Append(" <a href=\"/thong-tin-thuoc-tinh-san-pham.aspx?id=" + item.ID + "\" title=\"Xem chi tiết\" class=\"btn primary-btn h45-btn\"><i class=\"fa fa-info-circle\" aria-hidden=\"true\"></i></a>");
html.Append(" <a href=\"/gia-tri-thuoc-tinh-san-pham.aspx?productvariableid=" + item.ID + "\" title=\"Xem thuộc tính\" class=\"btn primary-btn h45-btn\"><i class=\"fa fa-file-text-o\" aria-hidden=\"true\"></i></a>");
html.Append(" </td>");
html.Append("</tr>");
}
}
ltrList.Text = html.ToString();
}
public void LoadData()
{
int id = Request.QueryString["id"].ToInt(0);
if (id > 0)
{
var p = ProductController.GetByID(id);
if (p == null)
{
PJUtils.ShowMessageBoxSwAlertError("Không tìm thấy sản phẩm " + id, "e", true, "/tat-ca-san-pham", Page);
}
else
{
ViewState["ID"] = id;
ViewState["cateID"] = p.CategoryID;
ViewState["SKU"] = p.ProductSKU;
hdfParentID.Value = p.CategoryID.ToString();
hdfsetStyle.Value = p.ProductStyle.ToString();
ltrBack.Text = "<a href=\"/xem-san-pham?id=" + p.ID + "\" class=\"btn primary-btn fw-btn not-fullwidth\">Trở về</a>";
txtProductTitle.Text = p.ProductTitle;
pContent.Content = p.ProductContent;
txtProductSKU.Text = p.ProductSKU;
pRegular_Price.Text = p.Regular_Price.ToString();
pCostOfGood.Text = p.CostOfGood.ToString();
pRetailPrice.Text = p.Retail_Price.ToString();
chkIsHidden.Checked = Convert.ToBoolean(p.IsHidden);
ddlSupplier.SelectedValue = p.SupplierID.ToString();
ddlCategory.SelectedValue = p.CategoryID.ToString();
txtMaterials.Text = p.Materials;
pMinimumInventoryLevel.Text = p.MinimumInventoryLevel.ToString();
pMaximumInventoryLevel.Text = p.MaximumInventoryLevel.ToString();
if (p.ProductImage != null)
{
ListProductThumbnail.Value = p.ProductImage;
ProductThumbnail.ImageUrl = p.ProductImage;
}
var image = ProductImageController.GetByProductID(id);
imageGallery.Text = "<ul class=\"image-gallery\">";
if (image != null)
{
foreach (var img in image)
{
imageGallery.Text += "<li><img src='" + img.ProductImage + "' /><a href='javascript:;' data-image-id='" + img.ID + "' onclick='deleteImageGallery($(this))' class='btn-delete'><i class=\"fa fa-times\" aria-hidden=\"true\"></i> Xóa hình</a></li>";
}
}
imageGallery.Text += "</ul>";
// Lấy tất cả biến thể ra
List <tbl_ProductVariable> a = new List <tbl_ProductVariable>();
a = ProductVariableController.GetProductID(p.ID);
if (a.Count > 0)
{
StringBuilder html = new StringBuilder();
int t = 1;
foreach (var item in a)
{
string VariableSKU = item.SKU;
double RegularPrice = Convert.ToDouble(item.Regular_Price);
double RetailPrice = Convert.ToDouble(item.RetailPrice);
double CostOfGood = Convert.ToDouble(item.CostOfGood);
int MinimumInventoryLevel = Convert.ToInt32(item.MinimumInventoryLevel);
int MaximumInventoryLevel = Convert.ToInt32(item.MaximumInventoryLevel);
string VariableImage = "/App_Themes/Ann/image/placeholder.png";
string deleteVariableImage = "<a href='javascript:;' onclick='deleteImageVariable($(this))' class='btn-delete hide'><i class=\"fa fa-times\" aria-hidden=\"true\"></i> Xóa hình</a>";
if (!string.IsNullOrEmpty(item.Image))
{
VariableImage = item.Image;
deleteVariableImage = "<a href='javascript:;' onclick='deleteImageVariable($(this))' class='btn-delete'><i class=\"fa fa-times\" aria-hidden=\"true\"></i> Xóa hình</a>";
}
var value = ProductVariableValueController.GetByProductVariableID(item.ID);
string selectVariable = "";
string variableID = "";
string variableName = "";
string variableValueID = "";
string variableValueName = "";
string dataVariableValue = "";
string labelVariableValue = "";
if (value != null)
{
foreach (var temp in value)
{
selectVariable += "<div class='row margin-bottom-15'><div class='col-md-5'>" + temp.VariableName + "</div><div class='col-md-7'>" + getSelectVariable(temp.VariableName, temp.VariableValue) + "</div></div>";
variableID += VariableController.GetByName(temp.VariableName.ToString()).ID.ToString() + "|";
variableName += temp.VariableName.ToString() + "|";
variableValueID += temp.VariableValueID.ToString() + "|";
variableValueName += temp.VariableValue.ToString() + "|";
dataVariableValue += VariableController.GetByName(temp.VariableName.ToString()).ID.ToString() + ":" + temp.VariableValueID.ToString() + "|";
labelVariableValue += temp.VariableName.ToString() + ": " + temp.VariableValue.ToString() + " - ";
}
}
html.AppendLine(String.Format("<div class='item-var-gen' data-name-id='{0}' data-value-id='{1}' data-name-text='{2}' data-value-text='{3}' data-name-value='{4}'>", variableID, variableValueID, variableName, variableValueName, dataVariableValue));
html.AppendLine(String.Format(" <div class='col-md-12 variable-label' onclick='showVariableContent($(this))'>"));
html.AppendLine(String.Format(" <strong>#{0}</strong> - {1} {2}", t, labelVariableValue, VariableSKU));
html.AppendLine(String.Format(" </div>"));
html.AppendLine(String.Format(" <div class='col-md-12 variable-content'>"));
html.AppendLine(String.Format(" <div class='row'>"));
html.AppendLine(String.Format(" <div class='col-md-2'>"));
html.AppendLine(String.Format(" <input type='file' class='productVariableImage upload-btn' onchange='imagepreview(this,$(this));' name='{0}'><img class='imgpreview' onclick='openUploadImage($(this))' data-file-name='{1}' src='{1}'>{2}", dataVariableValue, VariableImage, deleteVariableImage));
html.AppendLine(String.Format(" </div>"));
html.AppendLine(String.Format(" <div class='col-md-5'>"));
html.AppendLine(String.Format(" {0}", selectVariable));
html.AppendLine(String.Format(" <div class='row margin-bottom-15'>"));
html.AppendLine(String.Format(" <div class='col-md-5'>Mã sản phẩm</div>"));
html.AppendLine(String.Format(" <div class='col-md-7'><input type='text' disabled class='form-control productvariablesku sku-input' value='{0}'></div>", VariableSKU));
html.AppendLine(String.Format(" </div>"));
html.AppendLine(String.Format(" </div>"));
html.AppendLine(String.Format(" <div class='col-md-5'>"));
html.AppendLine(String.Format(" <div class='row margin-bottom-15'>"));
html.AppendLine(String.Format(" <div class='col-md-5'>Giá sỉ</div>"));
html.AppendLine(String.Format(" <div class='col-md-7'><input class='form-control regularprice' type='text' value='{0}'> </div>", RegularPrice));
html.AppendLine(String.Format(" </div>"));
html.AppendLine(String.Format(" <div class='row margin-bottom-15 cost-of-goods'>"));
html.AppendLine(String.Format(" <div class='col-md-5'>Giá vốn</div>"));
html.AppendLine(String.Format(" <div class='col-md-7'><input class='form-control costofgood cost-price' type='text' value='{0}'></div>", CostOfGood));
html.AppendLine(String.Format(" </div>"));
html.AppendLine(String.Format(" <div class='row margin-bottom-15'>"));
html.AppendLine(String.Format(" <div class='col-md-5'>Giá bán lẻ</div>"));
html.AppendLine(String.Format(" <div class='col-md-7'><input class='form-control retailprice' type='text' value='{0}'></div>", RetailPrice));
html.AppendLine(String.Format(" </div>"));
html.AppendLine(String.Format(" <div class='row margin-bottom-15'>"));
html.AppendLine(String.Format(" <div class='col-md-5'>Tồn kho ít nhất</div>"));
html.AppendLine(String.Format(" <div class='col-md-7'><input class='form-control minimum' type='text' value='{0}'></div>", MinimumInventoryLevel));
html.AppendLine(String.Format(" </div>"));
html.AppendLine(String.Format(" <div class='row margin-bottom-15'>"));
html.AppendLine(String.Format(" <div class='col-md-5'>Tồn kho nhiều nhất</div>"));
html.AppendLine(String.Format(" <div class='col-md-7'><input class='form-control maximum' type='text' value='{0}'></div>", MaximumInventoryLevel));
html.AppendLine(String.Format(" </div>"));
html.AppendLine(String.Format(" </div>"));
html.AppendLine(String.Format(" </div>"));
html.AppendLine(String.Format(" </div>"));
html.AppendLine(String.Format("</div>"));
t++;
}
ltrVariables.Text = html.ToString();
}
}
}
}
public void pagingall(List <tbl_ProductVariable> acs, int userRole)
{
int PageSize = 40;
StringBuilder html = new StringBuilder();
if (acs.Count > 0)
{
int TotalItems = acs.Count;
if (TotalItems % PageSize == 0)
{
PageCount = TotalItems / PageSize;
}
else
{
PageCount = TotalItems / PageSize + 1;
}
Int32 Page = GetIntFromQueryString("Page");
if (Page == -1)
{
Page = 1;
}
int FromRow = (Page - 1) * PageSize;
int ToRow = Page * PageSize - 1;
if (ToRow >= TotalItems)
{
ToRow = TotalItems - 1;
}
html.Append("<tr>");
html.Append(" <th class='image-column'>Ảnh</th>");
html.Append(" <th class='variable-column'>Thuộc tính</th>");
html.Append(" <th class='sku-column'>Mã</th>");
html.Append(" <th class='wholesale-price-column'>Giá sỉ</th>");
if (userRole == 0)
{
html.Append(" <th class='cost-price-column'>Giá vốn</th>");
}
html.Append(" <th class='retail-price-column'>Giá lẻ</th>");
html.Append(" <th class='stock-column'>Kho</th>");
html.Append(" <th class='stock-status-column'>Trạng thái</th>");
html.Append(" <th class='date-column'>Ngày tạo</th>");
html.Append(" <th class='hide-column'>Ẩn</th>");
html.Append(" <th class='action-column'>Thao tác</th>");
html.Append("</tr>");
for (int i = FromRow; i < ToRow + 1; i++)
{
var item = acs[i];
var stock2 = StockManagerController.getQuantityStock2BySKU(item.SKU);
html.Append("<tr>");
html.Append(" <td><img src='" + Thumbnail.getURL(item.Image, Thumbnail.Size.Small) + "'></td>");
string date = string.Format("{0:dd/MM/yyyy}", item.CreatedDate);
string ishidden = "";
if (item.IsHidden != null)
{
bool IsHidden = Convert.ToBoolean(item.IsHidden);
ishidden = PJUtils.IsHiddenStatus(IsHidden);
}
else
{
ishidden = PJUtils.IsHiddenStatus(false);
}
var value = ProductVariableValueController.GetByProductVariableID(item.ID);
if (value != null)
{
html.Append(" <td>");
string list = "";
foreach (var temp in value)
{
html.Append("" + temp.VariableName + ": " + temp.VariableValue + "</br>" + "");
list += temp.VariableName + "|";
}
html.Append("</td>");
}
html.Append(" <td>" + item.SKU + "</td>");
html.Append(" <td>" + string.Format("{0:N0}", item.Regular_Price) + "</td>");
if (userRole == 0)
{
html.Append(" <td>" + string.Format("{0:N0}", item.CostOfGood) + "</td>");
}
html.Append(" <td>" + string.Format("{0:N0}", item.RetailPrice) + "</td>");
if (stock2.HasValue)
{
html.Append(String.Format(" <td>{0:N0}<br>(Kho 2: {1:N0})</td>", PJUtils.TotalProductQuantityInstock(1, item.SKU), stock2.Value));
}
else
{
html.Append(" <td>" + PJUtils.TotalProductQuantityInstock(1, item.SKU) + "</td>");
}
html.Append(" <td>" + PJUtils.StockStatusBySKU(1, item.SKU) + "</td>");
html.Append(" <td>" + date + "</td>");
html.Append(" <td>" + ishidden + "</td>");
html.Append(" <td>");
html.Append(" <a href=\"/thong-tin-thuoc-tinh-san-pham?id=" + item.ID + "\" title=\"Xem chi tiết\" class=\"btn primary-btn h45-btn\"><i class=\"fa fa-info-circle\" aria-hidden=\"true\"></i></a>");
html.Append(" <a href=\"/gia-tri-thuoc-tinh-san-pham?productvariableid=" + item.ID + "\" title=\"Xem thuộc tính\" class=\"btn primary-btn h45-btn\"><i class=\"fa fa-file-text-o\" aria-hidden=\"true\"></i></a>");
html.Append(" </td>");
html.Append("</tr>");
}
}
ltrList.Text = html.ToString();
}
public void pagingall(List <tbl_ProductVariable> acs)
{
int PageSize = 40;
StringBuilder html = new StringBuilder();
if (acs.Count > 0)
{
int TotalItems = acs.Count;
if (TotalItems % PageSize == 0)
{
PageCount = TotalItems / PageSize;
}
else
{
PageCount = TotalItems / PageSize + 1;
}
Int32 Page = GetIntFromQueryString("Page");
if (Page == -1)
{
Page = 1;
}
int FromRow = (Page - 1) * PageSize;
int ToRow = Page * PageSize - 1;
if (ToRow >= TotalItems)
{
ToRow = TotalItems - 1;
}
html.Append("<tr>");
html.Append(" <th class='image-column'>Ảnh</th>");
html.Append(" <th class='variable-column'>Thuộc tính</th>");
html.Append(" <th class='wholesale-price-column'>Giá sỉ</th>");
html.Append(" <th class='stock-column'>Kho</th>");
html.Append("</tr>");
for (int i = FromRow; i < ToRow + 1; i++)
{
var item = acs[i];
html.Append("<tr>");
html.Append(" <td><img src='" + Thumbnail.getURL(item.Image, Thumbnail.Size.Small) + "'></td>");
html.Append("<td>");
html.Append("<strong>" + item.SKU + "</strong><br><br>");
var value = ProductVariableValueController.GetByProductVariableID(item.ID);
if (value != null)
{
string list = "";
foreach (var temp in value)
{
html.Append("" + temp.VariableName + ": " + temp.VariableValue + "</br>" + "");
list += temp.VariableName + "|";
}
html.Append("<br>" + PJUtils.StockStatusBySKU(1, item.SKU));
}
html.Append("</td>");
html.Append(" <td>" + string.Format("{0:N0}", item.Regular_Price) + "</td>");
html.Append(" <td>" + PJUtils.TotalProductQuantityInstock(1, item.SKU) + "</td>");
html.Append("</tr>");
}
}
ltrList.Text = html.ToString();
}
