private void loadAttribute(int attributeID) { AttributeBL attributeBL = new AttributeBL(); eshopBE.Attribute attribute = attributeBL.GetAttribute(attributeID); txtName.Text = attribute.Name; lblAttributeID.Value = attribute.AttributeID.ToString(); Page.Title = attribute.Name + " | Admin panel"; chkIsDescription.Checked = attribute.IsDescription; loadValues(); }
protected void btnSaveAttribute_Click(object sender, EventArgs e) { eshopBE.Attribute attribute = new eshopBE.Attribute(); attribute.Name = txtName.Text; attribute.IsDescription = chkIsDescription.Checked; if (lblAttributeID.Value != string.Empty) attribute.AttributeID = int.Parse(lblAttributeID.Value); AttributeBL attributeBL = new AttributeBL(); attributeBL.SaveAttribute(attribute); Response.Redirect("/administrator/attributes.aspx"); }
protected void btnSaveAttribute_Click(object sender, EventArgs e) { eshopBE.Attribute attribute = new eshopBE.Attribute(); attribute.Name = txtName.Text; attribute.IsDescription = chkIsDescription.Checked; if (lblAttributeID.Value != string.Empty) { attribute.AttributeID = int.Parse(lblAttributeID.Value); } AttributeBL attributeBL = new AttributeBL(); attributeBL.SaveAttribute(attribute); Response.Redirect("/" + ConfigurationManager.AppSettings["webshopAdminUrl"] + "/attributes.aspx"); }
protected void btnSaveAttribute_Click(object sender, EventArgs e) { eshopBE.Attribute attribute = new eshopBE.Attribute(); attribute.Name = txtName.Text; attribute.IsDescription = chkIsDescription.Checked; if (lblAttributeID.Value != string.Empty) { attribute.AttributeID = int.Parse(lblAttributeID.Value); } AttributeBL attributeBL = new AttributeBL(); attributeBL.SaveAttribute(attribute); Response.Redirect("/administrator/attributes.aspx"); }
private int addAttribute(int categoryID, string attributeName) { AttributeBL attributeBL = new AttributeBL(); eshopBE.Attribute attribute = new eshopBE.Attribute(); attribute.Name = attributeName; attribute.Filter = false; int attributeID = attributeBL.SaveAttribute(attribute); CategoryBL categoryBL = new CategoryBL(); attributeBL.SaveAttributeForCategory(categoryID, attributeID); return attributeID; }
private List<eshopBE.Attribute> GetAttributesList(int attributeID, string name, int categoryID) { List<eshopBE.Attribute> attributesList = null; eshopBE.Attribute attribute; using (SqlConnection objConn = new SqlConnection(WebConfigurationManager.ConnectionStrings["eshopConnectionString"].ConnectionString)) { using (SqlCommand objComm = new SqlCommand("SELECT attribute.attributeID, name, isDescription FROM attribute")) { try { objConn.Open(); objComm.Connection = objConn; if (attributeID > 0) { objComm.CommandText += " WHERE attributeID=@attributeID"; objComm.Parameters.Add("@attributeID", SqlDbType.Int).Value = attributeID; } else if (name != string.Empty) { objComm.CommandText += " WHERE name=@name"; objComm.Parameters.Add("@name", SqlDbType.NVarChar, 50).Value = name; } else if (categoryID > 0) { objComm.CommandText += " INNER JOIN categoryAttribute ON attribute.attributeID=categoryAttribute.attributeID WHERE categoryID=@categoryID"; objComm.Parameters.Add("@categoryID", SqlDbType.Int).Value = categoryID; } objComm.CommandText += " ORDER BY name"; using (SqlDataReader reader = objComm.ExecuteReader()) { if (reader.HasRows) attributesList = new List<eshopBE.Attribute>(); while (reader.Read()) { attribute = new eshopBE.Attribute(); attribute.AttributeID = reader.GetInt32(0); attribute.Name = reader.GetString(1); attribute.IsDescription = Convert.IsDBNull(reader[2]) == false ? reader.GetBoolean(2) : false; attribute.Filter = false; //attribute.Values = GetAttributeValues(attribute.AttributeID); attributesList.Add(attribute); } } } catch (SqlException ex) { ErrorLog.LogError(ex); throw new DLException("Error while loading attributes list", ex); } } } return attributesList; }
public List<eshopBE.Attribute> GetAttributeListForFilter(string categoryUrl) { List<eshopBE.Attribute> attributes = null; eshopBE.Attribute attribute = null; using (SqlConnection objConn = new SqlConnection(WebConfigurationManager.ConnectionStrings["eshopConnectionString"].ConnectionString)) { using (SqlCommand objComm = new SqlCommand("SELECT attribute.attributeID, attribute.name FROM attribute INNER JOIN categoryAttribute ON attribute.attributeID=categoryAttribute.attributeID INNER JOIN category ON categoryAttribute.categoryID=category.categoryID WHERE category.url=@categoryUrl AND filter=1 ORDER BY attribute.name", objConn)) { objConn.Open(); objComm.Parameters.Add("@categoryUrl", SqlDbType.NVarChar, 50).Value = categoryUrl; using (SqlDataReader reader = objComm.ExecuteReader()) { if (reader.HasRows) attributes = new List<eshopBE.Attribute>(); while (reader.Read()) { attribute = new eshopBE.Attribute(); attribute.AttributeID = reader.GetInt32(0); attribute.Name = reader.GetString(1); attribute.Filter = true; attribute.Values = GetAttributeValuesForFilter(attribute.AttributeID); attributes.Add(attribute); } } } } return attributes; }