//For Updating Attribute
public int DALUpdateAttribute(AttributeBLL at)
{
using (SqlConnection con = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]))
{
try
{
SqlParameter[] par = new SqlParameter[6];
par[0] = new SqlParameter("@attributeId", at.attributeId);
par[1] = new SqlParameter("@attributeName", at.attributeName);
par[2] = new SqlParameter("@attributeValue", at.attributeValue);
par[3] = new SqlParameter("@attributeType", at.attributeType);
par[4] = new SqlParameter("@categoryId", at.categoryId);
par[5] = new SqlParameter("@Status", 100);
par[5].Direction = ParameterDirection.Output;
SqlHelper.ExecuteNonQuery(con, CommandType.StoredProcedure, "spAttributeUpdate", par);
status = (int)par[5].Value;
}
catch (Exception ex)
{
throw ex;
}
finally
{
con.Close();
}
}
return(status);
}
protected void SubmitButton_Click(object sender, EventArgs e)
{
AttributeInfo attribute = new AttributeInfo();
attribute.ID = RequestHelper.GetQueryString <int>("ID");
attribute.Name = this.Name.Text;
attribute.AttributeClassID = RequestHelper.GetQueryString <int>("AttributeClassID");
attribute.InputType = Convert.ToInt32(this.InputType.Text);
attribute.InputValue = this.InputValue.Text;
string message = ShopLanguage.ReadLanguage("AddOK");
if (attribute.ID == -2147483648)
{
base.CheckAdminPower("AddAttribute", PowerCheckType.Single);
int id = AttributeBLL.AddAttribute(attribute);
AdminLogBLL.AddAdminLog(ShopLanguage.ReadLanguage("AddRecord"), ShopLanguage.ReadLanguage("Attribute"), id);
}
else
{
base.CheckAdminPower("UpdateAttribute", PowerCheckType.Single);
AttributeBLL.UpdateAttribute(attribute);
AdminLogBLL.AddAdminLog(ShopLanguage.ReadLanguage("UpdateRecord"), ShopLanguage.ReadLanguage("Attribute"), attribute.ID);
message = ShopLanguage.ReadLanguage("UpdateOK");
}
ScriptHelper.Alert(message, RequestHelper.RawUrl);
}
private void GetAttribute()
{
AttributeBLL pcBll = new AttributeBLL();
IList <PNK_Attribute> lstAll = pcBll.GetListTree(LangInt, string.Empty, null, int.MinValue, int.MinValue, string.Empty, 1, true, string.Empty, 1, 9999, out total);
IList <PNK_Attribute> lst = lstAll.Where(m => m.ParentId == 0).ToList();
PopulateTreeView(lstAll, lst, 0, null);
}
protected void Page_Load(object sender, EventArgs e)
{
base.ClearCache();
int queryString = RequestHelper.GetQueryString <int>("AttributeClassID");
int productID = RequestHelper.GetQueryString <int>("ProductID");
this.attributeList = AttributeBLL.JoinAttribute(queryString, productID);
}
protected void DeleteButton_Click(object sender, EventArgs e)
{
base.CheckAdminPower("DeleteAttribute", PowerCheckType.Single);
string intsForm = RequestHelper.GetIntsForm("SelectID");
if (intsForm != string.Empty)
{
AttributeBLL.DeleteAttribute(intsForm);
AdminLogBLL.AddAdminLog(ShopLanguage.ReadLanguage("DeleteRecord"), ShopLanguage.ReadLanguage("Attribute"), intsForm);
ScriptHelper.Alert(ShopLanguage.ReadLanguage("DeleteOK"), RequestHelper.RawUrl);
}
}
public static void Init()
{
string connectionString = ConfigurationManager.ConnectionStrings["LiteCommerce"].ConnectionString;
//TODO : Khởi tạo các BLL Khi cần sử dụng
CatalogBLL.Initialize(connectionString);
EmployeeBLL.Initialize(connectionString);
CountryBLL.Initialize(connectionString);
AttributeBLL.Initialize(connectionString);
ProductAttributeBLL.Initialize(connectionString);
UserAccountBLL.Initialize(connectionString);
OrderBLL.Initialize(connectionString);
}
public ActionResult Attribute(string CategoryID, string ProductID, string Type = "")
{
/// Danh sach name attribute
List <DomainModels.Attribute> getAttribute = new List <DomainModels.Attribute>();
getAttribute = AttributeBLL.getAll(Convert.ToInt32(CategoryID));
// Lấy danh sách tất cả các Attribute theo ProductID
List <ProductAttribute> getAll = ProductAttributeBLL.getAll(Convert.ToInt32(ProductID));
if (Type.Equals("Update"))
{
if (getAll.Count == 0)
{
Type = "Add";
}
else if (getAll != null)
{
ProductAttributeModel editProductAttributeModel = new ProductAttributeModel()
{
ProductID = Convert.ToInt32(ProductID),
ListProductAttributes = getAll
};
ViewBag.Type = "Update";
ViewBag.ProductID = ProductID;
return(View(editProductAttributeModel));
}
}
if (Type.Equals("Add"))
{
List <DomainModels.ProductAttribute> getNameAttribute = new List <DomainModels.ProductAttribute>();
foreach (var attribute in getAttribute)
{
getNameAttribute.Add(new DomainModels.ProductAttribute()
{
AttributeName = attribute.AttributeName
});
}
ProductAttributeModel addProductAttribute = new ProductAttributeModel()
{
ProductID = Convert.ToInt32(ProductID),
ListProductAttributes = getNameAttribute
};
ViewBag.Type = "Add";
ViewBag.ProductID = ProductID;
return(View(addProductAttribute));
}
return(View());
}
protected void HanderAttribute(ProductInfo product)
{
if (product.ID > 0)
{
AttributeRecordBLL.DeleteAttributeRecordByProductID(product.ID.ToString());
}
List <AttributeInfo> list = AttributeBLL.ReadAttributeListByClassID(product.AttributeClassID);
foreach (AttributeInfo info in list)
{
AttributeRecordInfo attributeRecord = new AttributeRecordInfo();
attributeRecord.AttributeID = info.ID;
attributeRecord.ProductID = product.ID;
attributeRecord.Value = RequestHelper.GetForm <string>(info.ID.ToString() + "Value");
AttributeRecordBLL.AddAttributeRecord(attributeRecord);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!this.Page.IsPostBack)
{
base.CheckAdminPower("ReadAttribute", PowerCheckType.Single);
this.AttributeClass.DataSource = AttributeClassBLL.ReadAttributeClassCacheList();
this.AttributeClass.DataTextField = "Name";
this.AttributeClass.DataValueField = "ID";
this.AttributeClass.DataBind();
this.InputType.DataSource = EnumHelper.ReadEnumList <InputType>();
this.InputType.DataTextField = "ChineseName";
this.InputType.DataValueField = "Value";
this.InputType.DataBind();
this.InputType.Items[0].Selected = true;
string queryString = RequestHelper.GetQueryString <string>("Action");
int id = RequestHelper.GetQueryString <int>("ID");
if ((queryString != string.Empty) && (id > 0))
{
if (queryString == "Up")
{
AttributeBLL.ChangeAttributeOrder(ChangeAction.Up, id);
}
else
{
AttributeBLL.ChangeAttributeOrder(ChangeAction.Down, id);
}
}
if (id != -2147483648)
{
AttributeInfo info = AttributeBLL.ReadAttributeCache(id);
this.Name.Text = info.Name;
this.InputType.Text = info.InputType.ToString();
this.InputValue.Text = info.InputValue;
}
this.attributeClassIDAspx = RequestHelper.GetQueryString <int>("AttributeClassID");
this.AttributeClass.SelectedValue = this.attributeClassIDAspx.ToString();
base.BindControl(AttributeBLL.ReadAttributeListByClassID(this.attributeClassIDAspx), this.RecordList);
}
}
//Gets Selected category
public DataTable DALGetSelectedAttribute(AttributeBLL at)
{
using (SqlConnection con = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]))
{
try
{
SqlParameter[] par = new SqlParameter[1];
par[0] = new SqlParameter("@attributeId", at.attributeId);
ds = SqlHelper.ExecuteDataset(con, CommandType.StoredProcedure, "spAttributeSelectById", par);
}
catch (Exception ex)
{
throw ex;
}
finally
{
con.Close();
}
}
return(ds.Tables[0]);
}
public DataTable BLLShowAttributeByCategoryId(AttributeBLL ic)
{
return dtAttribute = attributeDALObj.DALShowAttributeByCategoryId(ic);
}
public DataTable BLLGetCategoryWiseAttribute(AttributeBLL ic)
{
return dtAttribute = attributeDALObj.DALGetCategoryWiseAttribute(ic);
}
public DataTable BLLGetSelectedRecord(AttributeBLL at)
{
return dtAttribute = attributeDALObj.DALGetSelectedAttribute(at);
}
public int BLLUpdateCategoryAttribute(AttributeBLL at)
{
return status = attributeDALObj.DALUpdateAttribute(at);
}
public int BLLInsertCategoryAttribute(AttributeBLL at)
{
return status = attributeDALObj.DALInsertAttribute(at);
}
