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