public static bool Login(string Username, string Password) { using (NORTHWNDEntities1 db = new NORTHWNDEntities1()) { return(db.Customers1.Any(user => user.UserName.Equals(Username, StringComparison.OrdinalIgnoreCase) && user.PassWord.Equals(Password, StringComparison.OrdinalIgnoreCase))); } }
public HttpResponseMessage Get() { using (NORTHWNDEntities1 db = new NORTHWNDEntities1()) { return(Request.CreateResponse(HttpStatusCode.OK, db.Customers1.ToList())); } }
private static List <SelectListItem> GetCategories() { NORTHWNDEntities1 entities = new NORTHWNDEntities1(); Products pr = new Products(); pr.ProductId = new[] { new SelectListItem { Text = "Select Value", Value = "0" } }; pr.Categories = new List <SelectListItem>(); pr.Categories.Add(new SelectListItem() { Text = "Select A Value", Value = "0" }); IEnumerable <SelectListItem> V = (new SelectList(new NORTHWNDEntities1().Categories, "CategoryId", "CategoryName")); foreach (var i in V) { pr.Categories.Add(i); } //List<SelectListItem> productList = (from p in entities.Products.AsEnumerable() // select new SelectListItem // { // Text = p.ProductName, // Value = p.ProductID.ToString() // // }).ToList(); //productList.Insert(0,new SelectListItem { Text="Select Product",Value=""}); return(pr.Categories); }
private static List <SelectListItem> GetSuppliers() { NORTHWNDEntities1 entities = new NORTHWNDEntities1(); Products pr = new Products(); pr.Suppliers = new List <SelectListItem>(); pr.Suppliers.Add(new SelectListItem() { Text = "Select A Value", Value = "0" }); IEnumerable <SelectListItem> sup = (new SelectList(new NORTHWNDEntities1().Suppliers, "SupplierId", "CompanyName")); foreach (var i in sup) { pr.Suppliers.Add(i); } //List<SelectListItem> productList = (from p in entities.Products.AsEnumerable() // select new SelectListItem // { // Text = p.ProductName, // Value = p.ProductID.ToString() // // }).ToList(); //productList.Insert(0,new SelectListItem { Text="Select Product",Value=""}); return(pr.Suppliers); }
public ActionResult View3(Products pr) { NORTHWNDEntities1 entities = new NORTHWNDEntities1(); if (pr.categoryId == 0 && pr.SupplierId == 0) { var pro = entities.UspSelectProduct().ToList(); pr.UspSelectProductName1 = pro; } else if (pr.SupplierId == 0 && pr.categoryId != 0) { var pro = entities.UspSelectProductCategory(pr.categoryId).ToList(); pr.UspSelectProductName1 = pro; } else if (pr.categoryId == 0 && pr.SupplierId != 0) { var pro = entities.UspSelectProductSupplier(pr.SupplierId).ToList(); pr.UspSelectProductName1 = pro; } else if (pr.categoryId != 0 && pr.SupplierId != 0) { var pro = entities.UspSelectProductSupplierCategory(pr.categoryId, pr.SupplierId).ToList(); pr.UspSelectProductName = pro; } //List<SelectListItem> CategoriesList = GetCategories(); //SelectListItem selectedItem = productList.Find(p => p.Value == ProductId.ToString()); //var product = new NORTHWNDEntities().Categories; //Category cat=product.Find(CategoryId); //ViewBag.Message = "ProductName:" + cat.CategoryName; // ViewBag.Message += "ID:" + cat.CategoryID; //ViewBag.Message += "SupplierId" + cat.Description; //ViewBag.Message += "CategoryId" + pro.CategoryID; //ViewBag.Message += "UnitPrice" + pro.UnitPrice; //ViewBag.Message += "Quantityperunit" + pro.QuantityPerUnit; pr.Categories = GetCategories(); pr.Suppliers = GetSuppliers(); return(View(pr)); }