public ActionResult Create([Bind(Include = "CategoryID,CategoryName,Description,Picture,ImageFile")] Categories categories) { if (ModelState.IsValid) { string fileName = Path.GetFileNameWithoutExtension(categories.ImageFile.FileName); string extension = Path.GetExtension(categories.ImageFile.FileName); if (imgProvider.Validate(categories.ImageFile) != null) { ViewBag.Error = imgProvider.Validate(categories.ImageFile); return(View("Create")); } fileName = fileName + DateTime.Now.ToString("yymmssfff") + extension; categories.Picture = fileName; db.Categories.Add(categories); if (db.SaveChanges() > 0) { SaveImage(categories.ImageFile, fileName, ftpChild); ftp.Add(fileName, ftpChild, categories.ImageFile); TempData["Notice_Create_Success"] = true; } ModelState.Clear(); return(RedirectToAction("Index")); } return(View(categories)); }
public ActionResult Create([Bind(Include = "ProductID,ProductName,UnitPrice,OldUnitPrice,Thumbnail,ShortDescription,Description,Specification,UnitsInStock,UnitsOnOrder,SupplierID,CategoryID,SaleID,Discontinued,ImageFile")] Products products) { if (ModelState.IsValid) { string fileName = Path.GetFileNameWithoutExtension(products.ImageFile.FileName); string extension = Path.GetExtension(products.ImageFile.FileName); if (imgProvider.Validate(products.ImageFile) != null) { ViewBag.Error = imgProvider.Validate(products.ImageFile); return(View("Create")); } products.Thumbnail = fileName + DateTime.Now.ToString("yymmssfff") + extension; db.Products.Add(products); products.UnitsInStock = 0; products.UnitsOnOrder = 0; if (db.SaveChanges() > 0) { SaveImage(products.ImageFile, products.Thumbnail, ftpChild); ftp.Add(products.Thumbnail, ftpChild, products.ImageFile); TempData["Notice_Create_Success"] = true; } return(RedirectToAction("Index")); } ViewBag.CategoryID = new SelectList(db.Categories, "CategoryID", "CategoryName", products.CategoryID); ViewBag.SaleID = new SelectList(db.Sale, "SaleID", "SaleName"); ViewBag.SupplierID = new SelectList(db.Suppliers, "SupplierID", "CompanyName", products.SupplierID); return(View(products)); }
public ActionResult Create([Bind(Include = "PaymentID,PaymentName")] Payments payments) { if (ModelState.IsValid) { db.Payments.Add(payments); db.SaveChanges(); TempData["Notice_Create_Success"] = true; return(RedirectToAction("Index")); } return(View(payments)); }
public ActionResult Create([Bind(Include = "BlogCategoryID,BlogCategoryName")] BlogCategories blogCategories) { if (ModelState.IsValid) { db.BlogCategories.Add(blogCategories); db.SaveChanges(); TempData["Notice_Create_Success"] = true; return(RedirectToAction("Index")); } return(View(blogCategories)); }
public ActionResult Create([Bind(Include = "SupplierID,CompanyName,ContactName,Address,Phone,Email")] Suppliers suppliers) { if (ModelState.IsValid) { db.Suppliers.Add(suppliers); db.SaveChanges(); TempData["Notice_Create_Success"] = true; return(RedirectToAction("Index")); } return(View(suppliers)); }
public ActionResult Ship(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } else { var order = db.Orders.Find(id); order.Status = 1; order.ShippedDate = DateTime.Now; db.SaveChanges(); } return(RedirectToAction("Index")); }
public bool Insert(BlogComments blogComment) { blogComment.CommentingDate = DateTime.Now; db.BlogComments.Add(blogComment); if (db.SaveChanges() > 0) { return(true); } return(false); }
public bool Insert(Feedbacks feedback) { feedback.FeedBackDate = DateTime.Now; db.Feedbacks.Add(feedback); if (db.SaveChanges() > 0) { return(true); } return(false); }
public bool Insert(OrderDetails detail) { db.OrderDetails.Add(detail); if (db.SaveChanges() > 0) { return(true); } else { return(false); } }
public ActionResult Create([Bind(Include = "BlogID,BlogName,Username,Content,BlogCategoryID,WritingDate,ImageFile")] Blogs blogs) { if (ModelState.IsValid) { var check = db.Users.SingleOrDefault(u => u.Username == blogs.Username); if (check != null) { string fileName = Path.GetFileNameWithoutExtension(blogs.ImageFile.FileName); string extension = Path.GetExtension(blogs.ImageFile.FileName); if (imgProvider.Validate(blogs.ImageFile) != null) { ViewBag.Error = imgProvider.Validate(blogs.ImageFile); return(View(blogs)); } blogs.Thumbnail = fileName + DateTime.Now.ToString("yymmssfff") + extension; var user = (UserLogin)Session[Common.CommonConstants.USER_SESSION]; blogs.Username = user.Username; db.Blogs.Add(blogs); if (db.SaveChanges() > 0) { SaveImage(blogs.ImageFile, blogs.Thumbnail, ftpChild); ftp.Add(blogs.Thumbnail, ftpChild, blogs.ImageFile); TempData["Notice_Create_Success"] = true; } return(RedirectToAction("Index")); } else { ViewBag.NotifyUser = "******"; ViewBag.BlogCategoryID = new SelectList(db.BlogCategories, "BlogCategoryID", "BlogCategoryName"); return(View("Create")); } } ViewBag.BlogCategoryID = new SelectList(db.BlogCategories, "BlogCategoryID", "BlogCategoryName", blogs.BlogCategoryID); return(View(blogs)); }
public bool UpdateUnitOnOder(int productID, int quantity) { var product = db.Products.Find(productID); product.UnitsOnOrder += quantity; if (db.SaveChanges() > 0) { return(true); } else { return(false); } }
public ActionResult Import([Bind(Include = "ImportationID,ProductID,Username,ImportDate,UnitPrice,Quantity")] Importation importation) { if (ModelState.IsValid) { var product = db.Products.Single(p => p.ProductID == importation.ProductID); product.UnitsInStock += importation.Quantity; db.Importation.Add(importation); db.SaveChanges(); TempData["Notice_Save_Success"] = true; return(RedirectToAction("Index")); } return(RedirectToAction("Create", new { id = importation.ProductID })); }
public ActionResult Create([Bind(Include = "SaleID,SaleName,Content,StartDate,EndDate,Picture,Code,Discount,ImageFile")] Sale sale) { if (ModelState.IsValid) { if (db.Sale.FirstOrDefault(s => s.Code == sale.Code) != null) { ViewBag.Error = "Code has been exist"; return(View(sale)); } if (sale.StartDate > sale.EndDate) { ViewBag.NotiDate = "The start date must be before the end date."; return(View(sale)); } string fileName = Path.GetFileNameWithoutExtension(sale.ImageFile.FileName); string extension = Path.GetExtension(sale.ImageFile.FileName); if (imgProvider.Validate(sale.ImageFile) != null) { ViewBag.Error = imgProvider.Validate(sale.ImageFile); return(View(sale)); } sale.Picture = fileName + DateTime.Now.ToString("yymmssfff") + extension; db.Sale.Add(sale); if (db.SaveChanges() > 0) { ftp.Add(sale.Picture, ftpChild, sale.ImageFile); TempData["Notice_Create_Success"] = true; } return(RedirectToAction("Index")); } return(View(sale)); }
public ActionResult DeleteConfirmed(int id) { try { Feedbacks feedbacks = db.Feedbacks.Find(id); db.Feedbacks.Remove(feedbacks); db.SaveChanges(); TempData["Notice_Delete_Success"] = true; } catch (Exception) { TempData["Notice_Delete_Fail"] = true; } return(RedirectToAction("Index")); }
public ActionResult Export([Bind(Include = "ExportationID,ProductID,Username,ExportDate,UnitPrice,Quantity")] Exportation exportation) { if (ModelState.IsValid) { var product = db.Products.Single(p => p.ProductID == exportation.ProductID); if (exportation.Quantity > product.UnitsInStock) { TempData["Error"] = "Quantity must be less than unit in stock"; return(RedirectToAction("Create", new { id = product.ProductID })); } else { product.UnitsInStock -= exportation.Quantity; db.Exportation.Add(exportation); db.SaveChanges(); TempData["Notice_Save_Success"] = true; return(RedirectToAction("Index")); } } return(RedirectToAction("Create", new { id = exportation.ProductID })); }
public ActionResult Change(Profile profile, string imgOld_User) { if (ModelState.IsValid) { bool isAgeValid = true; if ((DateTime.Now.Year - profile.Birthday.Value.Year) == 16) { if ((DateTime.Now.Month - profile.Birthday.Value.Month) == 0) { if ((DateTime.Now.Day - profile.Birthday.Value.Day) > 0) { isAgeValid = false; } } else if ((DateTime.Now.Month - profile.Birthday.Value.Month) > 0) { isAgeValid = false; } } else if ((DateTime.Now.Year - profile.Birthday.Value.Year) < 16) { isAgeValid = false; } if (!isAgeValid) { TempData["Error"] = "Age must greater than 16 years old"; return(RedirectToAction("Index")); } var user = db.Users.Find(profile.Username); user.FirtName = profile.FirtName; user.LastName = profile.LastName; user.Gender = profile.Gender; user.Birthday = profile.Birthday; user.Phone = profile.Phone; user.Email = profile.Email; user.Address = profile.Address; user.Status = user.Status; string uploadFolderPath = Server.MapPath("~/public/uploadedFiles/userPictures/"); if (profile.ImageFile != null) { string fileName = Path.GetFileNameWithoutExtension(profile.ImageFile.FileName); string extension = Path.GetExtension(profile.ImageFile.FileName); if (imgProvider.Validate(profile.ImageFile) != null) { TempData["Error"] = imgProvider.Validate(profile.ImageFile); return(RedirectToAction("Index")); } user.Picture = fileName + DateTime.Now.ToString("yymmssfff") + extension; ftp.Update(user.Picture, ftpChild, profile.ImageFile, imgOld_User); } if (db.SaveChanges() > 0) { TempData["Notice_Save_Success"] = true; var userSession = new Models.UserLogin(); userSession.Username = user.Username; userSession.FirtName = user.FirtName; userSession.LastName = user.LastName; userSession.Gender = user.Gender; userSession.Birthday = user.Birthday; userSession.Phone = user.Phone; userSession.Email = user.Email; userSession.Address = user.Address; userSession.Role = user.Role; userSession.Status = user.Status; userSession.Picture = ftp.Get(user.Picture, ftpChild); Session.Add(Common.CommonConstants.USER_SESSION, userSession); } return(RedirectToAction("Index")); } return(RedirectToAction("Index")); }
public ActionResult Index(UserRegister users) { if (db.Users.Find(users.Username) != null) { TempData["ErrorMess"] = "Username already exists"; return(View(users)); } if (users.Username.Length < 6 || users.Username.Length > 50) { TempData["ErrorMess"] = "Username must be between 6 to 50 characters."; return(View(users)); } bool isExist = db.Users.ToList().Exists(model => model.Email.Equals(users.Email, StringComparison.OrdinalIgnoreCase)); if (isExist) { TempData["ErrorMess"] = "Email already exists"; return(View(users)); } bool isAgeValid = true; if ((DateTime.Now.Year - users.Birthday.Value.Year) == 16) { if ((DateTime.Now.Month - users.Birthday.Value.Month) == 0) { if ((DateTime.Now.Day - users.Birthday.Value.Day) > 0) { isAgeValid = false; } } else if ((DateTime.Now.Month - users.Birthday.Value.Month) > 0) { isAgeValid = false; } } else if ((DateTime.Now.Year - users.Birthday.Value.Year) < 16) { isAgeValid = false; } if (!isAgeValid) { TempData["ErrorMess"] = "Age must greater than 16 years old"; return(View(users)); } if (users.Password.Length < 8 || users.Password.Length > 50) { TempData["ErrorMess"] = "Password must be between 8 to 50 characters"; return(View(users)); } string fileName = Path.GetFileNameWithoutExtension(users.ImageFile.FileName); string extension = Path.GetExtension(users.ImageFile.FileName); if (imgProvider.Validate(users.ImageFile) != null) { TempData["ErrorMess"] = imgProvider.Validate(users.ImageFile); return(View(users)); } users.Picture = fileName + DateTime.Now.ToString("yymmssfff") + extension; ScryptEncoder encoder = new ScryptEncoder(); users.Password = encoder.Encode(users.Password); var custumner = new Users(); custumner.Username = users.Username; custumner.Password = users.Password; custumner.FirtName = users.FirtName; custumner.LastName = users.LastName; custumner.Gender = users.Gender; custumner.Birthday = users.Birthday; custumner.Phone = users.Phone; custumner.Email = users.Email; custumner.Address = users.Address; custumner.Picture = users.Picture; custumner.Role = 2; custumner.Status = true; db.Users.Add(custumner); if (db.SaveChanges() > 0) { ftp.Add(users.Picture, "imgUsers", users.ImageFile); TempData["SuccessMess"] = "Register successfully"; } return(View());; }
public ActionResult Create([Bind(Include = "Username,FirtName,LastName,Password,Gender,Birthday,Phone,Email,Address,Picture,Role,Status,ImageFile")] Users users) { if (ModelState.IsValid) { if (db.Users.Find(users.Username) != null) { ViewBag.Error = "Username already exists"; return(View("Create")); } if (users.Username.Length < 6 || users.Username.Length > 50) { ViewBag.Error = "Username must be between 6 to 50 characters."; return(View("Create")); } bool isExist = db.Users.ToList().Exists(model => model.Email.Equals(users.Email, StringComparison.OrdinalIgnoreCase)); if (isExist) { ViewBag.Error = "Email already exists"; return(View("Create")); } bool isAgeValid = true; if ((DateTime.Now.Year - users.Birthday.Value.Year) == 16) { if ((DateTime.Now.Month - users.Birthday.Value.Month) == 0) { if ((DateTime.Now.Day - users.Birthday.Value.Day) > 0) { isAgeValid = false; } } else if ((DateTime.Now.Month - users.Birthday.Value.Month) > 0) { isAgeValid = false; } } else if ((DateTime.Now.Year - users.Birthday.Value.Year) < 16) { isAgeValid = false; } if (!isAgeValid) { ViewBag.Error = "Age must greater than 16 years old"; return(View("Create")); } if (users.Password.Length < 8 || users.Password.Length > 50) { ViewBag.Error = "Password must be between 8 to 50 characters"; return(View("Create")); } string fileName = Path.GetFileNameWithoutExtension(users.ImageFile.FileName); string extension = Path.GetExtension(users.ImageFile.FileName); if (imgProvider.Validate(users.ImageFile) != null) { ViewBag.Error = imgProvider.Validate(users.ImageFile); return(View("Create")); } users.Picture = fileName + DateTime.Now.ToString("yymmssfff") + extension; ScryptEncoder encoder = new ScryptEncoder(); users.Password = encoder.Encode(users.Password); db.Users.Add(users); if (db.SaveChanges() > 0) { ftp.Add(users.Picture, ftpChild, users.ImageFile); TempData["Notice_Create_Success"] = true; } return(RedirectToAction("Index")); } return(View(users)); }
public long Insert(Orders order) { db.Orders.Add(order); db.SaveChanges(); return(order.OrderID); }