public ActionResult AddCart(string quantity, string productID)
{
int quan = int.Parse(quantity);
int proID = int.Parse(productID);
if (IsLogin())
{
User user = GetUser();
using (var db = new LifeMallDBContext())
{
var cartQuery = db.Cart.Where(m => m.MemberID == user.MemberID && m.ProductID == proID).FirstOrDefault();
if (cartQuery == null)
{
var newCart = new Cart()
{
MemberID = user.MemberID,
ProductID = proID,
Quantity = quan
};
db.Cart.Add(newCart);
}
else
{
cartQuery.Quantity += quan;
}
db.SaveChanges();
}
}
var j = "{\"resp\":0}";
return(Json(j, JsonRequestBehavior.AllowGet));
}
public ActionResult EditProduct(string icon1, string icon2, string productID, string description, string price, string productName)
{
var path = Server.MapPath("~/ProductImage/");
string randomText1 = ByteStrToImage(icon1, path);
string randomText2 = ByteStrToImage(icon2, path);
using (var db = new LifeMallDBContext())
{
int productIDNum = int.Parse(productID);
var productQuery = db.Product.Where(m => m.ProductID == productIDNum).FirstOrDefault();
if (productQuery != null)
{
productQuery.Price = int.Parse(price);
productQuery.ImageUrl1 = "ProductImage/" + randomText1;
productQuery.ImageUrl2 = "ProductImage/" + randomText2;
productQuery.ProductName = productName;
productQuery.Description = description;
db.SaveChanges();
}
}
var j = "{\"resp\":0}";
return(Json(j, JsonRequestBehavior.AllowGet));
}
public ActionResult CheckOut(string receiver, string address, string zipCode, string phone)
{
if (IsLogin())
{
var user = GetUser();
using (var db = new LifeMallDBContext())
{
var cartQuery = db.Cart.Where(m => m.MemberID == user.MemberID).Join
(db.Product,
c => c.ProductID,
s => s.ProductID,
(c, s) => new
{
c.ProductID,
c.Quantity,
s.Price,
}).ToList();
Guid guid = Guid.NewGuid();
var newOrderList = new OrderList()
{
Receiver = receiver,
Address = address,
Phone = phone,
OrderListID = guid,
MemberID = user.MemberID,
ZipCode = zipCode,
OrderDate = DateTime.Now
};
db.OrderList.Add(newOrderList);
foreach (var item in cartQuery)
{
var newOrderDetail = new OrderDetail()
{
OrderListID = guid,
ProductID = item.ProductID,
Quantity = item.Quantity
};
db.OrderDetail.Add(newOrderDetail);
}
// db.Cart.Remove
db.Cart.RemoveRange(db.Cart.Where(m => m.MemberID == user.MemberID));
db.SaveChanges();
}
}
return(RedirectToAction("Index", "Home"));
}
public ActionResult CreateProduct(string icon1, string icon2, string categoryID, string description, string price, string productName)
{
//string[] textArray = icon1.Split(',');
//var byt = textArray.Select(byte.Parse).ToArray();
//Image image = null;
//Bitmap bitmap = null;
//using (StreamWriter sw = new StreamWriter(@"C:\abc.txt")) //小寫TXT
//{
// // Add some text to the file.
// sw.Write("This is the ");
// sw.WriteLine("header for the file.");
// sw.WriteLine("-------------------");
// // Arbitrary objects can also be written to the file.
// sw.Write("The date is: ");
// sw.WriteLine(DateTime.Now);
//}
//using (MemoryStream memoryStream = new MemoryStream(byt))
//{
//memoryStream.Position = 0;
//image = Image.FromStream(memoryStream);
//bitmap = new Bitmap(image);
// image.Save("../ProductImage/"+sCode+".jpg", System.Drawing.Imaging.ImageFormat.Jpeg);
//ByteStrToImage
// GetRandomText
var path = Server.MapPath("~/ProductImage/");
string randomText1 = ByteStrToImage(icon1, path);
string randomText2 = ByteStrToImage(icon2, path);
using (var db = new LifeMallDBContext())
{
var newProduct = new Product()
{
CategoryID = int.Parse(categoryID),
Description = description,
ImageUrl1 = "ProductImage/" + randomText1,
ImageUrl2 = "ProductImage/" + randomText2,
Price = int.Parse(price),
ProductName = productName
};
db.Product.Add(newProduct);
db.SaveChanges();
}
var j = "{\"resp\":0}";
return(Json(j, JsonRequestBehavior.AllowGet));
}
public ActionResult EditCategory(string categoryName, string categoryID)
{
using (var db = new LifeMallDBContext())
{
int cateID = int.Parse(categoryID);
var categoryQuery = db.Category.Where(m => m.CategoryID == cateID).FirstOrDefault();
if (categoryQuery != null)
{
categoryQuery.CategoryName = categoryName;
db.SaveChanges();
}
}
var j = "{\"resp\":0}";
return(Json(j, JsonRequestBehavior.AllowGet));
}
// GET: Create
public ActionResult CreateCategory(string categoryName, string parentID)
{
using (var db = new LifeMallDBContext())
{
var newCategory = new Category()
{
CategoryName = categoryName,
ParentID = int.Parse(parentID)
};
db.Category.Add(newCategory);
db.SaveChanges();
}
var j = "{\"resp\":0}";
return(Json(j, JsonRequestBehavior.AllowGet));
}
public ActionResult RemoveProduct(string productID)
{
using (var db = new LifeMallDBContext())
{
int productIDNum = int.Parse(productID);
var productQuery = db.Product.Where(m => m.ProductID == productIDNum).FirstOrDefault();
if (productQuery != null)
{
db.Product.Remove(productQuery);
db.SaveChanges();
}
}
var j = "{\"resp\":0}";
return(Json(j, JsonRequestBehavior.AllowGet));
}
public ActionResult Register(Member member)
{
var selectList = new List <SelectListItem>()
{
new SelectListItem {
Text = "男", Value = "value-1"
},
new SelectListItem {
Text = "女", Value = "value-2"
},
};
selectList.Where(m => m.Value == member.Sex).First().Selected = true;
ViewBag.SelectList = selectList;
if (ModelState.IsValid == true)
{
member.Sex = selectList.Where(m => m.Value == member.Sex).FirstOrDefault().Text;
using (var db = new LifeMallDBContext())
{
var newMember = new Member()
{
Name = member.Name,
Account = member.Account,
Password = member.Password,
Address = member.Address,
Email = member.Email,
Phone = member.Phone,
Sex = member.Sex,
Birthday = member.Birthday,
CreateDate = DateTime.Now
};
db.Member.Add(newMember);
db.SaveChanges();
}
return(RedirectToAction("Index", "Home"));
}
return(View(member));
}
