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