public ActionResult ViewItems() { TropicalServerEntities1 tc = new TropicalServerEntities1(); var model = (from i in tc.tblItems join d in tc.tblItemTypes on i.ItemType equals d.ItemTypeNumber select new joinedTbl { id = i.ItemID, itemnum = i.ItemNumber, desc = i.ItemDescription, upc = i.ItemUPC, shelflife = i.ItemShelfLife, returnAllowed = i.ItemReturnAllowedFlag, itemType = i.ItemType, units = i.ItemUnits, weight = i.ItemWeights, priceGroup = i.ItemPriceGroup, prodGroup = i.ItemProductGroup, promoGroup = i.ItemPromoGroup, preprice = i.PrePrice, itemtypedesc = d.ItemTypeDescription }).ToList(); return(View(model)); }
//[ActionName("login")] //[HttpPost] public ActionResult Login() { TropicalServerEntities1 tc = new TropicalServerEntities1(); var model = tc.tblUserLogins.ToList(); return(View()); }
public ActionResult Login(string user, string pass) { TropicalServerEntities1 tc = new TropicalServerEntities1(); var model = tc.tblUserLogins.Where(a => a.UserID == user && a.Password == pass); System.Diagnostics.Debug.WriteLine("user {0} pass {1}", user, pass); if (model.Count() == 1) { return(RedirectToAction("About")); } else { return(RedirectToAction("Login")); } }