public bool Equals(EvaluatedCustomOptions other) { if (ReferenceEquals(null, other)) { return(false); } if (ReferenceEquals(this, other)) { return(true); } return(other.CustomOptionId == CustomOptionId && other.OptionId == OptionId && Equals(other.CustomOptionTitle, CustomOptionTitle) && Equals(other.OptionTitle, OptionTitle) && other.OptionPriceBc == OptionPriceBc && Equals(other.OptionPriceType, OptionPriceType)); }
public static IList <EvaluatedCustomOptions> DeserializeFromXml(string xml) { if (xml == null || string.IsNullOrEmpty(xml.Trim())) { return(null); } var res = new List <EvaluatedCustomOptions>(); var doc = new XmlDocument(); doc.LoadXml(xml); foreach (XmlElement xel in doc.GetElementsByTagName("Option")) { var xelm = xel.GetElementsByTagName("OptionId")[0]; if (int.Parse(xelm.InnerText) < 0) { continue; } var evco = new EvaluatedCustomOptions(); xelm = xel.GetElementsByTagName("CustomOptionId")[0]; evco.CustomOptionId = int.Parse(xelm.InnerText); xelm = xel.GetElementsByTagName("OptionId")[0]; evco.OptionId = int.Parse(xelm.InnerText); xelm = xel.GetElementsByTagName("OptionTitle")[0]; evco.OptionTitle = xelm.InnerText; xelm = xel.GetElementsByTagName("CustomOptionTitle")[0]; evco.CustomOptionTitle = xelm.InnerText; xelm = xel.GetElementsByTagName("OptionPriceBC")[0]; evco.OptionPriceBc = decimal.Parse(xelm.InnerText, CultureInfo.InvariantCulture); xelm = xel.GetElementsByTagName("OptionPriceType")[0]; evco.OptionPriceType = (OptionPriceType)Enum.Parse(typeof(OptionPriceType), xelm.InnerText); res.Add(evco); } return(res); }
public static IList<OrderItem> GetOrderItems(int orderId) { var result = new List<OrderItem>(); using (var da = new SQLDataAccess()) { da.cmd.CommandText = "[Order].[sp_GetOrderItems]"; da.cmd.CommandType = CommandType.StoredProcedure; da.cmd.Parameters.Clear(); da.cmd.Parameters.AddWithValue("@OrderID", orderId); da.cn.Open(); using (SqlDataReader reader = da.cmd.ExecuteReader()) while (reader.Read()) { result.Add(GetOrderItemFromReader(reader)); } da.cmd.CommandText = "[Order].[sp_GetSelectedOptionsByOrderItemId]"; da.cmd.CommandType = CommandType.StoredProcedure; foreach (OrderItem orditm in result) { da.cmd.Parameters.Clear(); da.cmd.Parameters.AddWithValue("@OrderItemId", orditm.OrderItemID); var evlist = new List<EvaluatedCustomOptions>(); using (var reader = da.cmd.ExecuteReader()) while (reader.Read()) { var ev = new EvaluatedCustomOptions { CustomOptionId = SQLDataHelper.GetInt(reader, "CustomOptionId"), CustomOptionTitle = SQLDataHelper.GetString(reader, "CustomOptionTitle"), OptionId = SQLDataHelper.GetInt(reader, "OptionId"), OptionPriceBc = SQLDataHelper.GetFloat(reader, "OptionPriceBC"), OptionPriceType = (OptionPriceType)SQLDataHelper.GetInt(reader, "OptionPriceType"), OptionTitle = SQLDataHelper.GetString(reader, "OptionTitle") }; evlist.Add(ev); } orditm.SelectedOptions = evlist; } da.cnClose(); } return result; }
public static IList<EvaluatedCustomOptions> DeserializeFromXml(string xml) { if (xml == null || string.IsNullOrEmpty(xml.Trim())) { return null; } var res = new List<EvaluatedCustomOptions>(); var doc = new XmlDocument(); doc.LoadXml(xml); foreach (XmlElement xel in doc.GetElementsByTagName("Option")) { var xelm = xel.GetElementsByTagName("OptionId")[0]; if (int.Parse(xelm.InnerText) < 0) { continue; } var evco = new EvaluatedCustomOptions(); xelm = xel.GetElementsByTagName("CustomOptionId")[0]; evco.CustomOptionId = int.Parse(xelm.InnerText); xelm = xel.GetElementsByTagName("OptionId")[0]; evco.OptionId = int.Parse(xelm.InnerText); xelm = xel.GetElementsByTagName("OptionTitle")[0]; evco.OptionTitle = xelm.InnerText; xelm = xel.GetElementsByTagName("CustomOptionTitle")[0]; evco.CustomOptionTitle = xelm.InnerText; xelm = xel.GetElementsByTagName("OptionPriceBC")[0]; evco.OptionPriceBc = float.Parse(xelm.InnerText, CultureInfo.InvariantCulture); xelm = xel.GetElementsByTagName("OptionPriceType")[0]; evco.OptionPriceType = (OptionPriceType)Enum.Parse(typeof(OptionPriceType), xelm.InnerText); res.Add(evco); } return res; }
public bool Equals(EvaluatedCustomOptions other) { if (ReferenceEquals(null, other)) return false; if (ReferenceEquals(this, other)) return true; return other.CustomOptionId == CustomOptionId && other.OptionId == OptionId && Equals(other.CustomOptionTitle, CustomOptionTitle) && Equals(other.OptionTitle, OptionTitle) && other.OptionPriceBc == OptionPriceBc && Equals(other.OptionPriceType, OptionPriceType); }