public ActionResult Create(Category category)
{
context = new ShopLaptionDbContextDataContext();
if (ModelState.IsValid)
{
var check_name = context.Categories.Any(a => a.Name.Equals(category.Name));
if (check_name)
{
ModelState.AddModelError("", "Thương hiệu này đã tồn tại !");
return(View());
}
else
{
category.CreatedBy = Session[CommonConstants.NAME_SESSION].ToString();
category.CreatedDate = DateTime.Now;
category.Name.ToUpper();
context.Categories.InsertOnSubmit(category);
context.SubmitChanges();
return(RedirectToAction("Index"));
}
}
return(RedirectToAction("Index"));
}
public ActionResult XacNhanDonHang(string MaHD)
{
context = new ShopLaptionDbContextDataContext();
var dh = context.Orders.SingleOrDefault(x => x.MaDH.Equals(MaHD));
dh.TinhTrang = true;
context.SubmitChanges();
return(RedirectToAction("Index"));
}
public ActionResult Delete(string MaHD)
{
try
{
context = new ShopLaptionDbContextDataContext();
var hd = context.Orders.FirstOrDefault(x => x.MaDH == MaHD);
var cthd = context.OrderDetails.FirstOrDefault(x => x.MaDH == MaHD);
context.Orders.DeleteOnSubmit(hd);
context.SubmitChanges();
context.OrderDetails.DeleteOnSubmit(cthd);
context.SubmitChanges();
return(RedirectToAction("Index"));
}
catch (Exception)
{
return(RedirectToAction("Index"));
}
}
public ActionResult Delete(long ID)
{
try
{
context = new ShopLaptionDbContextDataContext();
var category = context.Categories.FirstOrDefault(x => x.ID == ID);
context.Categories.DeleteOnSubmit(category);
context.SubmitChanges();
return(RedirectToAction("Index"));
}
catch (Exception)
{
return(RedirectToAction("Index"));
}
}
public ActionResult Edit(User account)
{
context = new ShopLaptionDbContextDataContext();
if (ModelState.IsValid)
{
var user = context.Users.SingleOrDefault(x => x.ID == account.ID);
user.Name = account.Name;
user.Address = account.Address;
user.Email = account.Email;
user.Phone = account.Phone;
user.ModifiedDate = DateTime.Now;
user.ModifiedBy = Session[CommonConstants.NAME_SESSION].ToString();
context.SubmitChanges();
return(RedirectToAction("Index"));
}
return(View("Index"));
}
public ActionResult Create(User user)
{
context = new ShopLaptionDbContextDataContext();
if (ModelState.IsValid)
{
var check_user = context.Users.Any(a => a.UserName.Equals(user.UserName));
var check_email = context.Users.Any(a => a.Email.Equals(user.Email));
var res_val = new MyValidate();
if (check_user)
{
ModelState.AddModelError("", "Tài khoản đã tồn tại !");
return(View());
}
else if (check_email)
{
ModelState.AddModelError("", "Email đã tồn tại !");
return(View());
}
else if (res_val.isEmail(user.Email) == false)
{
ModelState.AddModelError("", "Email không đúng định dạng !");
return(View());
}
else if (res_val.IsValidPhone(user.Phone) == false)
{
ModelState.AddModelError("", "Số điện thoại không đúng !");
return(View());
}
else
{
user.CreatedBy = Session[CommonConstants.NAME_SESSION].ToString();
user.CreatedDate = DateTime.Now;
context.Users.InsertOnSubmit(user);
context.SubmitChanges();
return(RedirectToAction("Index"));
}
}
return(RedirectToAction("Index"));
}
public ActionResult Delete(long ID)
{
try
{
context = new ShopLaptionDbContextDataContext();
//if (Session[CommonConstants.PERMISSION_SESSION == 1])
//{
//}
var user = context.Users.FirstOrDefault(x => x.ID == ID);
context.Users.DeleteOnSubmit(user);
context.SubmitChanges();
return(RedirectToAction("Index"));
}
catch (Exception)
{
return(RedirectToAction("Index"));
}
}
public ActionResult Edit(Order order)
{
context = new ShopLaptionDbContextDataContext();
try
{
if (ModelState.IsValid)
{
var hd = context.Orders.SingleOrDefault(x => x.MaDH.Equals(order.MaDH));
hd.DiaChi = order.DiaChi;
hd.GhiChu = order.GhiChu;
context.SubmitChanges();
}
return(RedirectToAction("Index"));
}
catch (Exception)
{
ModelState.AddModelError("", "Chỉnh sửa thất bại !");
return(View());
}
}
public ActionResult Edit(Product product, HttpPostedFileBase image)
{
SetViewbag();
context = new ShopLaptionDbContextDataContext();
if (ModelState.IsValid)
{
var proc = context.Products.SingleOrDefault(x => x.ID == product.ID);
if (image != null && image.ContentLength > 0)
{
string filename = System.IO.Path.GetFileName(image.FileName);
string urlname = Server.MapPath("~/Assets/Image/Product/General/" + filename);
image.SaveAs(urlname);
proc.Image = "~/Assets/Image/Product/General/" + filename;
}
proc.Name = product.Name;
proc.Code = product.Code;
proc.Brand = product.Brand;
proc.Description = product.Description;
proc.Price = product.Price;
proc.Quantity = product.Quantity;
proc.Screen = product.Screen;
proc.CPU = product.CPU;
proc.RAM = product.RAM;
proc.Card = product.Card;
proc.Disk = product.Disk;
proc.ModifiedDate = DateTime.Now;
proc.ModifiedBy = Session[CommonConstants.NAME_SESSION].ToString();
context.SubmitChanges();
return(RedirectToAction("Index"));
}
return(View(product));
}
public ActionResult Create(Product product, HttpPostedFileBase image)
{
context = new ShopLaptionDbContextDataContext();
if (image != null && image.ContentLength > 0)
{
//product.ImageByte = new byte[image.ContentLength];
//image.InputStream.Read(product.ImageByte, 0, image.ContentLength);
string filename = System.IO.Path.GetFileName(image.FileName);
string urlname = Server.MapPath("~/Assets/Image/Product/General/" + filename);
image.SaveAs(urlname);
product.Image = "~/Assets/Image/Product/General/" + filename;
}
if (ModelState.IsValid)
{
var check_product_code = context.Products.Any(a => a.Code.Equals(product.Code));
if (check_product_code)
{
ModelState.AddModelError("", "Mã sản phẩm đã tồn tại !");
return(View());
}
else
{
product.CreatedBy = Session[CommonConstants.NAME_SESSION].ToString();
product.CreatedDate = DateTime.Now;
product.Name.ToUpper();
context.Products.InsertOnSubmit(product);
context.SubmitChanges();
return(RedirectToAction("Index"));
}
}
SetViewbag();
return(View(product));
}
public ActionResult DatHang(FormCollection collection)
{
context = new ShopLaptionDbContextDataContext();
SetViewbag();
SetListOrder();
ViewBag.TongTien = TongTien();
var res = new MyValidate();
Order order = new Order();
List <GioHang> gioHangs = GetOrders();
order.MaDH = "HD" + DateTime.Now.ToString("yyyyMMddHHmmsss");
order.TenKH = collection["tenKH"];
order.Sdt = collection["sdt"];
order.DiaChi = collection["diachi"];
order.NgayDat = DateTime.Now;
order.GhiChu = collection["ghichu"];
order.TinhTrang = false;
//bool v = res.IsValidPhone(order.Sdt);
if (String.IsNullOrEmpty(order.TenKH))
{
ViewData["err1"] = "Vui lòng nhập họ tên của bạn !";
}
else if (String.IsNullOrEmpty(order.Sdt))
{
ViewData["err2"] = "Vui lòng nhập số điện thoại liên lạc !";
}
else if (res.IsValidPhone(order.Sdt) == false)
{
ViewData["err3"] = "Số điện thoại bạn nhập không đúng định dạng!";
}
else if (String.IsNullOrEmpty(order.DiaChi))
{
ViewData["err4"] = "Vui lòng nhập địa chỉ giao hàng !";
}
else
{
context.Orders.InsertOnSubmit(order);
context.SubmitChanges();
foreach (var item in gioHangs)
{
OrderDetail orderDetail = new OrderDetail();
orderDetail.MaDH = order.MaDH;
orderDetail.MaSP = item.masp;
orderDetail.TenSP = item.tensp;
orderDetail.Soluong = item.sl;
orderDetail.DonGia = (decimal)item.gia;
orderDetail.Tong = (decimal)TongTien();
var pro = context.Products.SingleOrDefault(x => x.Code == orderDetail.MaSP);
pro.Quantity = pro.Quantity - orderDetail.Soluong;
context.OrderDetails.InsertOnSubmit(orderDetail);
context.SubmitChanges();
}
context.SubmitChanges();
Session["order"] = null;
return(RedirectToAction("XacNhanDonHang", "Card"));
}
return(View());
}