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");
}
