public static SelectList GetSelectList(int selectedValue = -1) { var db = new Models.SinExDatabaseContext(); List <Object> PackageTypeSizeSelectList = new List <Object>(); var PackageTypeSizeList = db.PackageTypeSizes.ToList(); foreach (PackageTypeSize x in PackageTypeSizeList) { string name = x.PackageType.Type + " - " + x.Size; int value = x.PackageTypeSizeID; PackageTypeSizeSelectList.Add(new { Text = name, Value = value.ToString() }); } if (selectedValue == -1) { return(new SelectList(PackageTypeSizeSelectList, "Value", "Text")); } else { return(new SelectList(PackageTypeSizeSelectList, "Value", "Text", selectedValue)); } }
public int GetCurrentShippingAccountId() { var db = new Models.SinExDatabaseContext(); return(db.ShippingAccounts.Where(s => s.UserName == User.Identity.Name).Select(s => s.ShippingAccountId).Single()); }