public static void DeQuyCongTu(int el, int final, string r, List <Variable> listObject)
{
var currentElement = listObject[el];
var name = currentElement.VariableName;
var childrens = currentElement.Value;
foreach (var item in childrens)
{
var variableID = VariableValueController.GetByID(Convert.ToInt32(item.Value)).VariableID;
string rprev = r;
int leng = el + 1;
var skutext = VariableValueController.GetByID(Convert.ToInt32(item.Value)) != null?
VariableValueController.GetByID(Convert.ToInt32(item.Value)).SKUText : "";
if (leng < final)
{
rprev += variableID + "*" + name + ":" + item.Value + "," + item.Name + "," + skutext + "-";
DeQuyCongTu(leng, listObject.Count, rprev, listObject);
}
else
{
string a = r;
a += variableID + "*" + name + ":" + item.Value + "," + item.Name + "," + skutext + "|";
htmlAll += a;
}
}
}
/// <summary>
/// Khởi tạo HTML danh mục biến thể
/// </summary>
/// <param name="Name"></param>
/// <param name="Value"></param>
/// <returns>HTM DropDownList</returns>
private string _getSelectVariable(string Name, string Value)
{
var variableName = VariableController.GetByName(Name);
var html = new StringBuilder();
if (variableName != null)
{
html.AppendLine("<select name='ddlVariableValue'");
html.AppendLine(" class='form-control select2'");
html.AppendLine(" style='width: 100%'");
html.AppendLine(String.Format(" data-name-id='{0}'", variableName.ID));
html.AppendLine(String.Format(" data-name-text='{0}'", variableName.VariableName));
html.AppendLine(" onchange='onChangeVariationValue($(this))'");
html.AppendLine(">");
html.AppendLine(" <option data-sku-text='' value=''>Chọn giá trị</option>");
var variableValue = VariableValueController.GetByVariableID(variableName.ID);
foreach (var item in variableValue)
{
var isSelected = item.VariableValue == Value;
html.AppendLine(String.Format(" <option data-sku-text='{0}' value='{1}' {2}>{3}</option>", item.SKUText, item.ID, (isSelected ? "selected='selected'" : String.Empty), item.VariableValue));
}
html.AppendLine("</select>");
}
return(html.ToString());
}
public static string getSelectVariable(string Name, string Value)
{
var variablename = VariableController.GetByName(Name);
string html = "";
if (variablename != null)
{
html += "<select name='ddlVariableValue' id='ddlVariableValue' data-name-id='" + variablename.ID + "' data-name-text='" + variablename.VariableName + "' class='form-control' onchange='changeVariable($(this))'>";
html += "<option data-sku-text='' value=''>Chọn giá trị</option>";
var variablevalue = VariableValueController.GetByVariableID(variablename.ID);
foreach (var p in variablevalue)
{
if (p.VariableValue == Value)
{
html += "<option data-sku-text='" + p.SKUText + "' selected='selected' value='" + p.ID + "'>" + p.VariableValue + "</option>";
}
else
{
html += "<option data-sku-text='" + p.SKUText + "' value='" + p.ID + "'>" + p.VariableValue + "</option>";
}
}
html += "</select>";
}
return(html);
}
void BindValue(int variableID)
{
ddlVariableValue.Items.Clear();
ddlVariableValue.Items.Insert(0, new ListItem("-- Chọn --", "0"));
if (variableID > 0)
{
ddlVariableValue.DataSource = VariableValueController.GetByVariableIDIsHidden(variableID, false);
ddlVariableValue.DataBind();
}
}
public void UpdateVariableValue()
{
var v = VariableValueController.GetAll("");
foreach (var item in v)
{
string value = LeoUtils.ConvertToUnSign(item.VariableValue.Trim().ToLower());
VariableValueController.UpdateVariableValueText(item.ID, value);
}
}
public void LoadData()
{
int id = Request.QueryString["id"].ToInt(0);
List <tbl_VariableValue> a = new List <tbl_VariableValue>();
a = VariableValueController.GetByVariableID(id);
if (a != null)
{
ltrBack.Text = "<a href=\"/quan-ly-danh-muc-thuoc-tinh\" class=\"btn primary-btn h45-btn\">Trở về</a>";
ltrAddnew.Text = "<a href=\"/them-moi-thuoc-tinh?id=" + id + "\" class=\"h45-btn btn\" style=\"background-color: #ff3f4c\">Thêm mới</a>";
pagingall(a);
}
}
public void UpdateProductID()
{
DateTime currentDate = DateTime.Now;
var product = ProductVariableController.GetAll("");
foreach (var p in product)
{
var pr = ProductController.GetBySKU(p.ParentSKU);
if (pr != null)
{
ProductVariableController.UpdateProductID(p.ID, pr.ID);
}
string color = "";
string size = "";
if (!string.IsNullOrEmpty(p.color))
{
color = p.color;
}
if (!string.IsNullOrEmpty(p.size))
{
size = p.size;
}
if (!string.IsNullOrEmpty(color))
{
var vcolor = VariableValueController.GetByVariableID(1);
foreach (var c in vcolor)
{
if (color == c.VariableValueText)
{
ProductVariableValueController.Insert(p.ID, p.SKU, c.ID, c.VariableName, c.VariableValue, false, currentDate, "admin");
}
}
}
if (!string.IsNullOrEmpty(size))
{
var vsize = VariableValueController.GetByVariableID(2);
foreach (var s in vsize)
{
if (size == s.VariableValueText)
{
ProductVariableValueController.Insert(p.ID, p.SKU, s.ID, s.VariableName, s.VariableValue, false, currentDate, "admin");
}
}
}
}
}
protected void btnLogin_Click(object sender, EventArgs e)
{
string username = Request.Cookies["usernameLoginSystem"].Value;
int id = ViewState["ID"].ToString().ToInt(0);
if (id > 0)
{
var d = VariableValueController.GetByID(id);
if (d != null)
{
int variID = Convert.ToInt32(d.VariableID);
string variName = d.VariableName;
VariableValueController.Update(id, variID, variName, txtVariableValue.Text, chkIsHidden.Checked, DateTime.Now, username, txtSKUText.Text);
PJUtils.ShowMessageBoxSwAlert("Cập nhật thành công", "s", true, Page);
}
}
}
public void LoadData()
{
int id = Request.QueryString["id"].ToInt(0);
if (id > 0)
{
var d = VariableValueController.GetByID(id);
if (d != null)
{
ViewState["ID"] = id;
txtVariableValue.Text = d.VariableValue;
txtSKUText.Text = d.SKUText;
int ID = Convert.ToInt32(d.VariableID);
chkIsHidden.Checked = Convert.ToBoolean(d.IsHidden);
ltrBack.Text = "<a href=\"/quan-ly-thuoc-tinh-san-pham?id=" + ID + "\" class=\"btn primary-btn fw-btn not-fullwidth\">Trở về</a>";
}
}
}
public void BindVariableValue(int VariableID)
{
ddlVariableValue.Items.Clear();
ddlVariableValue.Items.Insert(0, new ListItem("Chọn giá trị", "0"));
if (VariableID > 0)
{
var variableValue = VariableValueController.GetByVariableID(VariableID);
if (variableValue.Count > 0)
{
foreach (var p in variableValue)
{
ListItem listitem = new ListItem(p.VariableValue, p.ID.ToString());
ddlVariableValue.Items.Add(listitem);
}
}
ddlVariableValue.DataBind();
}
}
public void LoadData()
{
int id = Request.QueryString["id"].ToInt(0);
if (id > 0)
{
var pvv = ProductVariableValueController.GetByID(id);
if (pvv != null)
{
ViewState["ID"] = id;
int productvariableid = Convert.ToInt32(pvv.ProductVariableID);
if (productvariableid > 0)
{
int variableID = 0;
var variablevalue = VariableValueController.GetByID(Convert.ToInt32(pvv.VariableValueID));
if (variablevalue != null)
{
variableID = Convert.ToInt32(variablevalue.VariableID);
}
ddlVariable.SelectedValue = variableID.ToString();
var vv = VariableValueController.GetByVariableIDIsHidden(Convert.ToInt32(variableID), false);
ddlVariableValue.Items.Clear();
ddlVariableValue.Items.Insert(0, new ListItem("-- Chọn --", "0"));
ddlVariableValue.DataSource = vv;
ddlVariableValue.DataBind();
ddlVariableValue.SelectedValue = pvv.VariableValueID.ToString();
chkIsHidden.Checked = Convert.ToBoolean(pvv.IsHidden);
var pv = ProductVariableController.GetByID(productvariableid);
if (pv != null)
{
ViewState["productvariableid"] = productvariableid;
ViewState["ProductvariableSKU"] = pv.SKU;
ltrBack.Text = "<a href=\"/gia-tri-thuoc-tinh-san-pham?productvariableid=" + productvariableid + "\" class=\"btn primary-btn fw-btn not-fullwidth\">Trở về</a>";
}
}
}
}
}
protected void btnLogin_Click(object sender, EventArgs e)
{
DateTime currentDate = DateTime.Now;
string username = Request.Cookies["usernameLoginSystem"].Value;
int id = Convert.ToInt32(ViewState["ID"]);
if (id != 0)
{
var variname = VariableController.GetByID(id);
if (variname != null)
{
var acc = AccountController.GetByUsername(username);
if (acc != null)
{
if (acc.RoleID == 0)
{
int ID = id;
string variableName = variname.VariableName.Trim();
string VariableValue = txtVariableValue.Text.Trim();
string SKUText = txtSKUText.Text.Trim();
var check = VariableValueController.GetByValueAndSKUText(id, VariableValue, SKUText);
if (check != null)
{
lblError.Text = "Tên thuộc tính hoặc SKUText đã tồn tại vui lòng chọn tên khác.";
lblError.Visible = true;
}
else
{
lblError.Visible = false;
VariableValueController.Insert(ID, variableName, VariableValue, false, currentDate, username, SKUText);
PJUtils.ShowMessageBoxSwAlert("Thêm thuộc tính thành công", "s", true, Page);
Response.Redirect("quan-ly-thuoc-tinh-san-pham?id=" + id);
}
}
}
}
}
}
