public static List <INV07_UnitOfMeasure> getUnitofMeasure() { var lstOfUnits = new List <INV07_UnitOfMeasure>(); var result = SqlHelper.ExecuteDataset(_myConnection, CommandType.Text, "SELECT UnitOfMeasure, UomDescription FROM INV07_UnitOfMeasure").Tables[0].AsEnumerable(); foreach (var item in result) { INV07_UnitOfMeasure source = new INV07_UnitOfMeasure(); source.UnitOfMeasure = Convert.ToString(item["UnitOfMeasure"]); source.UomDescription = Convert.ToString(item["UomDescription"]); lstOfUnits.Add(source); } return(lstOfUnits); }
private void LoadComboForHeight() { DataSet ds = ProjectDAL.LoadComboForHeight(Convert.ToString(Session["PRJID"])); List <Setup25_FenceTypes> lstFenceTypes = new List <Setup25_FenceTypes>(); foreach (var record in ds.Tables[0].AsEnumerable()) { Setup25_FenceTypes source = new Setup25_FenceTypes(); source.FenceTypeID = Convert.ToInt32(record["FenceTypeID"]); source.FenceType = Convert.ToString(record["FenceType"]); lstFenceTypes.Add(source); } ViewBag.FenceTypes = new SelectList(lstFenceTypes, "FenceTypeID", "FenceType"); List <Setup26_FenceHts> lstFenceHts = new List <Setup26_FenceHts>(); foreach (var record in ds.Tables[1].AsEnumerable()) { Setup26_FenceHts source = new Setup26_FenceHts(); source.FenceHtID = Convert.ToInt32(record["FenceHtID"]); source.FenceHtFt = Convert.ToDecimal(record["FenceHtFt"]); source.FenceHtIn = Convert.ToInt32(record["FenceHtIn"]); lstFenceHts.Add(source); } ViewBag.FenceHts = new SelectList(lstFenceHts, "FenceHtID", "FenceHtFt"); List <Setup27_FootageRanges> lstFootageRanges = new List <Setup27_FootageRanges>(); foreach (var record in ds.Tables[2].AsEnumerable()) { Setup27_FootageRanges source = new Setup27_FootageRanges(); source.FtRangeID = Convert.ToInt32(record["FtRangeID"]); source.FtRange = Convert.ToString(record["FtRange"]); lstFootageRanges.Add(source); } ViewBag.FootageRanges = new SelectList(lstFootageRanges, "FtRangeID", "FtRange"); List <Setup30_DigTypes> lstDigTypes = new List <Setup30_DigTypes>(); foreach (var record in ds.Tables[3].AsEnumerable()) { Setup30_DigTypes source = new Setup30_DigTypes(); source.DigTypeID = Convert.ToInt32(record["DigTypeID"]); source.DigType = Convert.ToString(record["DigType"]); lstDigTypes.Add(source); } ViewBag.DigTypes = new SelectList(lstDigTypes, "DigTypeID", "DigType"); List <Setup96_TaxCalcTypes> lstTaxCalc = new List <Setup96_TaxCalcTypes>(); foreach (var record in ds.Tables[4].AsEnumerable()) { Setup96_TaxCalcTypes source = new Setup96_TaxCalcTypes(); source.TaxCalcTypeID = Convert.ToInt32(record["TaxCalcTypeID"]); source.TaxCalcType = Convert.ToString(record["TaxCalcType"]); lstTaxCalc.Add(source); } ViewBag.TaxCalcTypes = new SelectList(lstTaxCalc, "TaxCalcTypeID", "TaxCalcType"); List <INV07_UnitOfMeasure> lstUOM = new List <INV07_UnitOfMeasure>(); foreach (var record in ds.Tables[5].AsEnumerable()) { INV07_UnitOfMeasure source = new INV07_UnitOfMeasure(); source.UnitOfMeasure = Convert.ToString(record["UnitOfMeasure"]); source.UomDescription = Convert.ToString(record["UomDescription"]); lstUOM.Add(source); } ViewBag.UOMTypes = new SelectList(lstUOM, "UnitOfMeasure", "UomDescription"); List <BID10A_BiTypes> lstBiTypes = new List <BID10A_BiTypes>(); foreach (var record in ds.Tables[6].AsEnumerable()) { BID10A_BiTypes source = new BID10A_BiTypes(); source.BITypeId = Convert.ToInt32(record["BITypeId"]); source.BITypeName = Convert.ToString(record["BITypeName"]); lstBiTypes.Add(source); } ViewBag.BiTypes = new SelectList(lstBiTypes, "BITypeId", "BITypeName"); List <RelatedBIDS> lstRelatedBids = new List <RelatedBIDS>(); foreach (var record in ds.Tables[7].AsEnumerable()) { lstRelatedBids.Add(new RelatedBIDS { BIDID = Convert.ToInt32(record["BIDID"]) }); } ViewBag.RelatedBIs = new SelectList(lstRelatedBids, "BIDID", "BIDID"); }