public Items GetTemplateItems(string templateID, string pricelevel , string currency, string uOFm) { Items items = new Items(); try { using (SqlConnection conn = new SqlConnection(connString)) using (SqlCommand comm = new SqlCommand("usp_GetTemplateItems", conn)) { comm.CommandType = CommandType.StoredProcedure; comm.Parameters.Clear(); comm.Parameters.Add(new SqlParameter("@TemplateID", templateID)); conn.Open(); using (SqlDataReader dr = comm.ExecuteReader()) { while (dr.Read()) { Item i = null; decimal qty; i = ItemData.Instance.GetItem(pricelevel, currency , dr["Item no"].ToString(), uOFm); qty = Convert.ToDecimal(dr["Qty"]); if (i != null) { if (qty > 0) { i.Qty = qty; } if (items != null) { items.Add(i); } } } } } } catch (Exception ex) { log.Error(ex); throw; } return items; }
public Items GetKitComponents(string kitItemNo) { Items items = new Items(); try { using (SqlConnection conn = new SqlConnection(connString)) using (SqlCommand comm = new SqlCommand("usp_GetKitComponents", conn)) { comm.CommandType = CommandType.StoredProcedure; comm.Parameters.Clear(); comm.Parameters.Add(new SqlParameter("@Kit", kitItemNo)); conn.Open(); using (SqlDataReader dr = comm.ExecuteReader()) { while (dr.Read()) { if (dr.HasRows) { Item item = new Item(); item.ItemNo = dr["Component Item No"].ToString(); item.Uofm = dr["U of M"].ToString(); item.Qty = Convert.ToDecimal(dr["Qty"].ToString()); item.ItemType = (ItemType)Convert.ToInt32(dr["Item Type"]); items.Add(item); } } } } } catch (Exception ex) { log.Error(ex); throw; } return items; }
public Items GetAssessmentItems(string assessmentNo , Transaction_Type sopType) { Items items = new Items(); try { using (SqlConnection conn = new SqlConnection(connString)) using (SqlCommand comm = new SqlCommand("usp_GetAssessmentItems", conn)) { comm.CommandType = CommandType.StoredProcedure; comm.Parameters.Clear(); comm.Parameters.Add(new SqlParameter("@SOPType", (int)sopType)); comm.Parameters.Add(new SqlParameter("@Assessment_No", assessmentNo)); conn.Open(); using (SqlDataReader dr = comm.ExecuteReader()) { while (dr.Read()) { Item i = new Item(); i.ItemNo = dr["Item Number"].ToString(); i.ItemDescription = dr["Item Description"].ToString(); i.Qty = Convert.ToDecimal(dr["Quantity"].ToString()); i.Unitprice = Convert.ToDecimal(dr["Unit Price"].ToString()); i.ItemClass = dr["Item Class"].ToString(); i.Uofm = dr["U of M"].ToString(); i.MarkDown = Convert.ToDecimal(dr["Markdown"]); items.Add(i); } } } } catch (Exception ex) { log.Error(ex); throw; } return items; }
public Items GetItems(string level, string currency , string uOfM) { Items items = new Items(); try { using (SqlConnection conn = new SqlConnection(connString)) using (SqlCommand comm = new SqlCommand("usp_GetItemsByLevel", conn)) { comm.CommandType = CommandType.StoredProcedure; comm.Parameters.Clear(); comm.Parameters.Add(new SqlParameter("@UofM", uOfM)); comm.Parameters.Add(new SqlParameter("@Currency", currency)); comm.Parameters.Add(new SqlParameter("@Level", level)); conn.Open(); using (SqlDataReader dr = comm.ExecuteReader()) { while (dr.Read()) { Item item = new Item(); item.ItemNo = dr["Item Number"].ToString(); item.ItemDescription = dr["Item Description"].ToString(); item.ItemClass = dr["Item Class Code"].ToString(); item.Uofm = dr["U of M"].ToString(); item.Unitprice = Convert.ToDecimal(dr["Unit Price"].ToString()); item.ItemType = (ItemType)Convert.ToInt32(dr["Item Type"].ToString()); items.Add(item); } } } } catch (Exception ex) { log.Error(ex); throw ex; } return items; }
private Items getKitComponents(Item itemKit) { Items items = new Items(); Items pricedItems = new Items(); if (transaction != null) { if (itemKit.ItemType == ItemType.Kit) { items = ItemAdapter.Instance.GetKitComponents(itemKit.ItemNo); foreach (Item item in items) { Item pricedItem; pricedItem = ItemAdapter.Instance.GetItem (transaction.PriceLevel, transaction.CurrencyID , item.ItemNo, item.Uofm); if (pricedItem != null) { //set qty equals qty of the component //in the kit multiplied by the qty of the kit pricedItem.Qty = item.Qty * itemKit.Qty; pricedItem.ComponentOf = itemKit.ItemNo; pricedItems.Add(pricedItem); } } } } return pricedItems; }