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