public ActionResult Login(Login lg) { if (ModelState.IsValid) { using (DBWatchEntities dbwatch = new DBWatchEntities()) { var user = dbwatch.Customers.Where(a => a.CusName.Equals(lg.username) && a.Password.Equals(lg.password)).FirstOrDefault(); var admin = dbwatch.Admins.Where(a => a.username.Equals(lg.username) && a.password.Equals(lg.password)).FirstOrDefault(); if (user != null) { //luu hien thi ten tren web Session["userName"] = user.CusName.ToString(); Session["fullName"] = user.FullName.ToString(); return(Redirect(lg.uri)); //return Redirect("JavaScript: history.go(-1)"); } else if (admin != null) { Session["userName"] = admin.username.ToString(); Session["userID"] = admin.id; return(RedirectToAction("AdminPage", "Home")); } else { ModelState.AddModelError("", "Username or Password is wrong!"); } } } return(View()); }
// GET: Report public ActionResult Reports() { using (DBWatchEntities db = new DBWatchEntities()) { var orderDetails = db.OrderDetail.Include(o => o.Order).Include(o => o.Product); return(View()); } }
public ActionResult Register(Customer cus) { if (ModelState.IsValid) { using (DBWatchEntities dbwatch = new DBWatchEntities()) { dbwatch.Customers.Add(cus); dbwatch.SaveChanges(); } ModelState.Clear(); ViewBag.Message = cus.CusName + " successfully registered."; } return(View("Register")); }
public ActionResult ViewOrder(string cusName) { using (DBWatchEntities db = new DBWatchEntities()) { var list = (from I in db.OrderDetail where I.Order.Customer.CusName == cusName orderby I.Order.Date select new { I.Order.OrderID, I.Product.ProName, I.Quantity, I.Price }).ToList(); //string query = "SELECT * FROM [Order] O JOIN OrderDetail I ON O.OrderID = I.OrderID JOIN Product P ON P.ProID = I.ProID JOIN Customer C ON C.CusName = O.CusName WHERE C.[CusName] ='" + cusName.ToString() + "' ORDER BY O.[Date]"; //string query = "SELECT * FROM [Order] O Where O.CusName = '"+cusName+"'"; //var historyOrder = db.Orders.SqlQuery(query).ToList(); //ViewBag.list = list; return(View(list)); } }
public ActionResult CreateBrand(Brand newBrand) { try { dbwatch = new DBWatchEntities(); Brand brand = new Brand(); brand.BrandName = brand.BrandName; brand.Description = brand.Description; //Add data in sql dbwatch.Brands.Add(newBrand); //Save changes dbwatch.SaveChanges(); } catch (Exception ex) { throw ex; } return(RedirectToAction("viewBrand", "Admin")); }
public ActionResult Login(Login lg) { if (ModelState.IsValid) { using (DBWatchEntities dbwatch = new DBWatchEntities()) { var admin = dbwatch.Admin.Where(a => a.username.Equals(lg.username) && a.password.Equals(lg.password)).FirstOrDefault(); if (admin != null) { //luu hien thi ten tren web Session["userName"] = admin.username.ToString(); return(RedirectToAction("Index", "AdminBrands")); //return Redirect("JavaScript: history.go(-1)");\ } else { ViewBag.Message = "Username or Password is invalid."; } } } return(View()); }
//report public ActionResult XuatReport(String id) { LocalReport lr = new LocalReport(); string path = Path.Combine(Server.MapPath("~/Report"), "Report.rdlc"); if (System.IO.File.Exists(path)) { lr.ReportPath = path; } else { return(View()); } List <OrderDetail> cm = new List <OrderDetail>(); using (DBWatchEntities db = new DBWatchEntities()) { //var list = (from I in db.OrderDetail // where I.Order.Customer.CusName == id // orderby I.Order.Date // select new { I.Order.OrderID, I.Product.ProName, I.Quantity, I.Price }).FirstOrDefault(); // var a = list.ToString(); cm = db.OrderDetail.ToList(); ReportDataSource rd = new ReportDataSource("MyDataSet", cm); lr.DataSources.Add(rd); string reportType = id; string mineType; string encoding; string fileNameExtension; string deviceInfo = "<DeviceInfo>" + "<OutputFormat>" + id + "</OutputFormat>" + "<PageWidth>8.5in</PageWidth>" + "<PageHeight>11in</PageHeight>" + "<MarginTop>0.5in</MarginTop>" + "<MarginLeft>1in</MarginLeft>" + "<MarginRight>1in</MarginRight>" + "<MarginBottom>0.5in</MarginBottom>" + "</DeviceInfo>" ; Warning[] warnings; string[] streams; byte[] rendereBytes; rendereBytes = lr.Render ( reportType, deviceInfo, out mineType, out encoding, out fileNameExtension, out streams, out warnings ); return(File(rendereBytes, mineType)); } }