//no use
//public ActionResult Delete(int id)
//{
// SingleApartmentEntities db = new SingleApartmentEntities();
// Information information = db.Information.FirstOrDefault(p => p.InformationID == id);
// if (information != null)
// {
// //db.Information.Remove(information);
// db.SaveChanges();
// }
// return RedirectToAction("List");
//}
//public ActionResult Create()
//{
// return View();
//}
//[HttpPost]
//public ActionResult Create(Information info)
//{
// SingleApartmentEntities db = new SingleApartmentEntities();
// db.Information.Add(info);
// db.SaveChanges();
// return RedirectToAction("List");
//}
public ActionResult UserCategoryList(int page = 1)
{
try
{
//int memberID = 1;
//todo:
CMember member = Session[CDictionary.welcome] as CMember;
int memberID = member.fMemberId; //(int)Session["MemberID"];
int pageSize = 4;
SingleApartmentEntities db = new SingleApartmentEntities();
int currentpage = page < 1 ? 1 : page;
IEnumerable <MemberInformationCategory> table = from p in db.MemberInformationCategory
where p.MemberID == memberID
orderby p.MemberCategoryID
select p;
List <CMemberInformationCategory> list = new List <CMemberInformationCategory>();
foreach (MemberInformationCategory d in table)
{
list.Add(new CMemberInformationCategory()
{
mEntity = d
});
}
var pagelist = list.ToPagedList(currentpage, pageSize);
return(View(pagelist));
}
catch
{
return(RedirectToAction("UserCategoryList"));
}
}
//BackList =========================================
//InfoCategoryList ==================================
public ActionResult InfoCategoryList(int page = 1)
{
int pageSize = 4;
SingleApartmentEntities db = new SingleApartmentEntities();
try
{
int currentpage = page < 1 ? 1 : page;
IEnumerable <InformationCategory> table = from p in db.InformationCategory
select p;
//List<CInformationCategory> list = new List<CInformationCategory>().ToPagedList(currentpage,pageSize).ToList();
List <CInformationCategory> list = new List <CInformationCategory>();
foreach (InformationCategory d in table)
{
list.Add(new CInformationCategory()
{
infoCategory_entity = d
});
}
var pagelist = list.ToPagedList(currentpage, pageSize);
return(View(pagelist));
}
catch
{
return(View());
}
}
//結帳畫面{12.6)
public ActionResult CheckOut()
{
var user = Session[CDictionary.welcome] as CMember;
if (user == null)
{
return(RedirectToAction("Login", "Member"));
}
SingleApartmentEntities db = new SingleApartmentEntities();
ViewBag.MemberID = user.fMemberId;
CUser theUser = new CUser()
{
tMember = db.tMember.Where(r => r.fMemberId == user.fMemberId).FirstOrDefault()
};
List <CAddtoSessionView> list = Session[CDictionary.PRODUCTS_IN_CART] as List <CAddtoSessionView>;
if (list == null || list.Count == 0)
{
return(RedirectToAction("ShowProductInCart"));
}
List <COrderDetailsViewModel> orderlist = theUser.SearchProductInCart(list);
return(View(orderlist));
}
//更改單一商品(數量)
public JsonResult ChangeONEProductQuantity(string ProductID, string Quantity)
{
SingleApartmentEntities db = new SingleApartmentEntities();
Product prod = db.Product.FirstOrDefault(p => p.ProductID.ToString() == ProductID);
if (prod != null)
{
List <CAddtoSessionView> list = Session[CDictionary.PRODUCTS_IN_CART] as List <CAddtoSessionView>;
if (list != null && list.Count != 0)
{
int Sum = 0;
for (int i = 0; i < list.Count; i++) //foreach沒有辦法去修改自己本身的陣列
{
if (list[i].txtProductID.ToString() == ProductID)
{
if (int.TryParse(Quantity, out int qty))
{
list[i].txtQuantity = qty;
Sum += list[i].txtQuantity * prod.UnitPrice;
}
}
else
{
Sum += list[i].txtQuantity * db.Product.AsEnumerable().FirstOrDefault(p => p.ProductID == list[i].txtProductID).UnitPrice;
}
}
return(Json(new { ans = "成功", sum = Sum }));
}
}
return(Json(new{ ans = "發生錯誤" }));
}
public string GetInformationCategory()
{
try
{
SingleApartmentEntities db = new SingleApartmentEntities();
IEnumerable <InformationCategory> info = from p in db.InformationCategory select p;
string result = "";
if (info != null)
{
result = "[";
foreach (var c in info)
{
if (result != "[")
{
result += ","; //務必加 ,
}
//組JSON字串
result = result + "{" + $"\"ID\":{c.InformationCategoryID},\"NAME\":\"{c.InformationCategoryName}\"" + "}";
}
result += "]";
}
return(result);
}
catch
{
return("");
}
}
public ActionResult Edit(Information p_info)
{
try
{
SingleApartmentEntities db = new SingleApartmentEntities();
Information info = db.Information.FirstOrDefault(p => p.InformationID == p_info.InformationID);
if (info != null)
{
//挑選了 "請選擇"項目
if (p_info.MemberCategoryID == 999)
{
info.MemberCategoryID = null;
}
else
{
info.MemberCategoryID = p_info.MemberCategoryID;
}
//優先等級
info.Priority = p_info.Priority;
db.SaveChanges();
}
return(RedirectToAction("List"));
}
catch
{
return(RedirectToAction("List"));
}
}
// GET: Delete 將暫存的單一活動session清除 12/4修改
public ActionResult Delete(int id)
{
SingleApartmentEntities db = new SingleApartmentEntities();
var clear = Session["txtfJoinedID"];
clear = id;
Activity ac = db.Activity.FirstOrDefault(p => p.ActivityID == id);
if (ac != null)
{
CActivityCart t = new CActivityCart();
List <CActivityCart> list = Session[CDictionary.Cart_Key] as List <CActivityCart>;
if (list != null)
{
for (int i = 0; i < list.Count; i++) //foreach沒有辦法去修改自己本身的陣列
{
if (list[i].fJoinedId == id)
{
list.Remove(list[i]);
}
}
}
}
return(RedirectToAction("CartView"));
}
public string GetNewActivityNotify()
{
//todo:
//int memberID = 1;
CMember member = Session[CDictionary.welcome] as CMember;
string result = "0";
try
{
if (member != null)
{
int memberID = member.fMemberId;
SingleApartmentEntities db = new SingleApartmentEntities();
IEnumerable <Information> ac = db.Information.AsEnumerable()
.Where(p => p.MemberID == memberID && p.InformationDate.ToString("yyyy-MM-dd") == DateTime.Today.ToString("yyyy-MM-dd") && p.Status != "User_Deleted" && p.Status != "Admin_Deleted");
result = ac.Count().ToString();
}
return(result);
}
catch
{
return(result);
}
}
public ActionResult Addtosession(CAddtoSessionView input)//第二步
{
SingleApartmentEntities db = new SingleApartmentEntities();
Product prod = db.Product.FirstOrDefault(p => p.ProductID == input.txtProductID);
if (prod != null)
{
COrderDetailsViewModel codv = new COrderDetailsViewModel();
codv.entity = new OrderDetails();
codv.entity.Order = new Order();
codv.entity.ProductID = prod.ProductID;
codv.ProductName = prod.ProductName;
codv.ProductPrice = prod.UnitPrice;
codv.entity.Quantity = input.txtQuantity;
codv.entity.Order.OrderDate = DateTime.Now;
List <COrderDetailsViewModel> list = Session[CDictionary.PRODUCTS_IN_CART] as List <COrderDetailsViewModel>;
if (list == null)
{
list = new List <COrderDetailsViewModel>();
Session[CDictionary.PRODUCTS_IN_CART] = list;
}
list.Add(codv);
}
return(RedirectToAction("ShowProductInCart"));
}
public ActionResult AddToCart_Session(CShoppingCart ac)
{
SingleApartmentEntities db = new SingleApartmentEntities();
Activity table = db.Activity.FirstOrDefault(p => p.ActivityID == ac.txtfId);
if (table != null)
{
tActivityCart tb = new tActivityCart();
tb.fJoinedId = table.ActivityID;
//tb.SubCategoryDetailID = table.SubCategoryDetailID;
tb.fAvtivityName = table.ActivityName;
tb.fStartTime = table.StartTime;
tb.fEndTime = table.EndTime;
tb.fLocation = table.MeetingPoint;
tb.fPeopleCount = table.PeopleCount;
//tb.Note = table.Note;
tb.fNote = table.Status;
List <tActivityCart> list = Session[CDictionary.Cart_Key] as List <tActivityCart>;
if (list == null)
{
list = new List <tActivityCart>();
Session[CDictionary.Cart_Key] = list;
}
list.Add(tb);
}
//CActivity CA = new CActivity() { entity = table };
//return View(CA);
return(RedirectToAction("List"));
}
public string GetUserCategory()
{
//todo:
int memberID = 1;
//CMember member = Session[CDictionary.welcome] as CMember;
//int memberID = member.fMemberId;
SingleApartmentEntities db = new SingleApartmentEntities();
IEnumerable <MemberInformationCategory> info = from p in db.MemberInformationCategory
where p.MemberID == memberID
select p;
string result = "";
if (info != null)
{
result = "[";
foreach (var c in info)
{
if (result != "[")
{
result += ","; //務必加 ,
}
//組JSON字串
result = result + "{" + $"\"ID\":{c.MemberCategoryID},\"NAME\":\"{c.MemberCategoryName}\"" + "}";
}
result += "]";
}
return(result);
}
//====================================================================
//團購商品新增(ok)
public ActionResult Create(int id)
{
SingleApartmentEntities db = new SingleApartmentEntities();
Product prod = new Product();
Activity AV = db.Activity.Where(p => p.ActivityID == id).FirstOrDefault();
prod.ActivityID = AV.ActivityID;
prod.Stock = AV.PeopleCount;
//=====================================================================
//下拉式選單
var PROsubNamelist = (from p in db.ProductSubCategory
select p.ProductSubCategoryName).ToList();
SelectList SUBNamelist = new SelectList(PROsubNamelist, "Name");
ViewBag.SUBNAME = SUBNamelist;
//=====================================================================
CProductViewModel cprod = new CProductViewModel()
{
entity = prod
}; //抓一筆資料
return(View(cprod));
}
//刪除單一商品(11/27新增)
public ActionResult RemoveONEShowProductInCart(int input)
{
SingleApartmentEntities db = new SingleApartmentEntities();
var a = Session["txtProductID"];
a = input;
Product prod = db.Product.FirstOrDefault(p => p.ProductID == input);
if (prod != null)
{
COrderDetailsViewModel codv = new COrderDetailsViewModel();
List <COrderDetailsViewModel> list = Session[CDictionary.PRODUCTS_IN_CART] as List <COrderDetailsViewModel>;
if (list != null)
{
for (int i = 0; i < list.Count; i++) //foreach沒有辦法去修改自己本身的陣列
{
if (list[i].ProductID == input)
{
list.Remove(list[i]);
}
}
}
}
return(RedirectToAction("ShowProductInCart"));
}
//顯示購物車內容
public ActionResult ShowProductInCart()
{
var user = Session[CDictionary.welcome] as CMember;
if (user == null)
{
return(RedirectToAction("Login", "Member"));
}
SingleApartmentEntities db = new SingleApartmentEntities();
ViewBag.MemberID = user.fMemberId;
CUser theUser = new CUser()
{
tMember = db.tMember.Where(r => r.fMemberId == user.fMemberId).FirstOrDefault()
};
List <CAddtoSessionView> list = Session[CDictionary.PRODUCTS_IN_CART] as List <CAddtoSessionView>;
if (list != null && list.Count != 0)
{
return(View(theUser.SearchProductInCart(list)));
}
else
{
return(View());
}
}
public ActionResult CategoryEdit(MemberInformationCategory p_info)
{ //TODO: FormCollection collection==>不要用
try
{
//todo:
//int memberID = 1;
//todo:
CMember member = Session[CDictionary.welcome] as CMember;
int memberID = member.fMemberId; //(int)Session["MemberID"];
SingleApartmentEntities db = new SingleApartmentEntities();
MemberInformationCategory info = db.MemberInformationCategory.FirstOrDefault(p => p.MemberCategoryID == p_info.MemberCategoryID && p.MemberID == memberID);
if (info != null)
{
info.MemberCategoryName = p_info.MemberCategoryName;
db.SaveChanges();
}
return(RedirectToAction("UserCategoryList"));
}
catch
{
//return View();
return(RedirectToAction("UserCategoryList"));
}
}
public string SendMail(string strHtml)
{
string htmlBody = strHtml.ToString();
SingleApartmentEntities entity = new SingleApartmentEntities();
try
{
//string sMemberEmail = "";
MailMessage mail = new MailMessage();
//string email = "dddd";
mail.From = new MailAddress("*****@*****.**");
//多收信人, 使用,隔開, 而不是;喔
#region 活動建立後媒合訊息發送
List <int> MemberIDList = new List <int>();
List <string> MemberMemberEmailList = new List <string>();
tMember tMember = new tMember();
var membermessage = from mbmsg in entity.tMember
select new { MbID = mbmsg.fMemberId, MbEmail = mbmsg.fEmail };
foreach (var m in membermessage)
{
MemberIDList.Add(m.MbID);
MemberMemberEmailList.Add(m.MbEmail);
}
for (int me = 0; me < MemberIDList.Count; me++)
{
//if(MemberfActivityMessageList[me] == "TRUE")
//{
mail.To.Add(MemberMemberEmailList[me]);
//}
}
#endregion
//mail.To.Add("[email protected],[email protected]");
mail.To.Add("*****@*****.**");//new MailAddress("*****@*****.**")
mail.Subject = "窩居公寓:新活動通知!";
//mail.Date = DateTime.Now;
mail.Body = htmlBody;
//mail.Body = $@"<h1 style='text-align:center;color:#ff0000'>iTicket 訂購成功</h1>{email}";
mail.IsBodyHtml = true;
mail.Priority = MailPriority.High;
using (SmtpClient SmtpServer = new SmtpClient("smtp.gmail.com"))
{
SmtpServer.Port = 587;
SmtpServer.Credentials = new NetworkCredential("*****@*****.**", "wojuwoju");
SmtpServer.EnableSsl = true;
SmtpServer.Send(mail);
}
return("true");
}
catch (Exception ex)
{
return(ex.Message);
}
}
public void update_read_yn(int id)
{
SingleApartmentEntities db = new SingleApartmentEntities();
Information information = db.Information.FirstOrDefault(p => p.InformationID == id);
if (information != null)
{
information.Read_YN = "Y";
db.SaveChanges();
}
}
public ActionResult CreatAllProduct(HttpPostedFileBase imgPhoto, Product p, string SUBNAME)
{
/*新增照片*/
SingleApartmentEntities db = new SingleApartmentEntities();
//======================================================
imgPhoto.SaveAs("c:\\temp\\111.jpg");
FileStream fs = new FileStream("c:\\temp\\111.jpg", FileMode.Open, FileAccess.Read);
int length = (int)fs.Length;
byte[] image = new byte[length];
fs.Read(image, 0, length);
fs.Close();
//=====================================================
//下拉式選單抓id
int SUBID = (from S in db.ProductSubCategory
where S.ProductSubCategoryName == SUBNAME
select S.ProductSubCategoryID).FirstOrDefault();
var PROID = (from P in db.Product
where P.ProductSubCategoryID == SUBID
select P.ProductSubCategoryID).FirstOrDefault();
p.Discontinued = "N";
p.ProductSubCategoryID = PROID;
db.Product.Add(p);
//-----------------------
ProductPictures prodpic = new ProductPictures();
prodpic.ProductID = p.ProductID;
//prodpic.ProductPictureID = 2;
prodpic.ProductPicture = image;
db.ProductPictures.Add(prodpic);
db.SaveChanges();
//======================================================
return(RedirectToAction("Home", "Product"));
}
public void update_status(int id)
{
SingleApartmentEntities db = new SingleApartmentEntities();
Information information = db.Information.FirstOrDefault(p => p.InformationID == id);
if (information != null)
{
information.Status = "User_Deleted";
db.SaveChanges();
}
//return RedirectToAction("List");
}
// GET: Delete
public ActionResult Deleteacdb(int id)
{
SingleApartmentEntities db = new SingleApartmentEntities();
Activity table = db.Activity.FirstOrDefault(p => p.ActivityID == id);
if (table != null)
{
db.Activity.Remove(table);
db.SaveChanges();
}
return(RedirectToAction("List"));
}
public ActionResult DeleteFavorite(string MemberID, string ProductID)
{
SingleApartmentEntities db = new SingleApartmentEntities();
var fa = db.FavoriteList.Where(r => r.MemberID.ToString() == MemberID && r.ProductID.ToString() == ProductID).FirstOrDefault();
if (fa != null)
{
db.FavoriteList.Remove(fa);
db.SaveChanges();
}
return(RedirectToAction("Favoritelist", new { MemberID = int.Parse(MemberID) }));
}
//新訊息 已讀/未讀分類
public JsonResult GetActivityNotify_ReadYN()
{
//todo:
//int memberID = 1;
CMember member = Session[CDictionary.welcome] as CMember;
try
{
if (member != null)
{
List <InformationContent> list = new List <InformationContent>();
int memberID = member.fMemberId;
SingleApartmentEntities db = new SingleApartmentEntities();
IEnumerable <Information> ac = null;
ac = db.Information.AsEnumerable().Where(p => p.MemberID == memberID && p.Status != "User_Deleted" && p.Status != "Admin_Deleted");
list.Add(new InformationContent()
{
ContentID = 900, ContentName = ac.Count().ToString()
});
ac = db.Information.AsEnumerable().Where(p => p.Read_YN == "Y" && p.MemberID == memberID && p.Status != "User_Deleted" && p.Status != "Admin_Deleted");
list.Add(new InformationContent()
{
ContentID = 100, ContentName = ac.Count().ToString()
});
ac = db.Information.AsEnumerable().Where(p => p.Read_YN == "N" && p.MemberID == memberID && p.Status != "User_Deleted" && p.Status != "Admin_Deleted");
list.Add(new InformationContent()
{
ContentID = 200, ContentName = ac.Count().ToString()
});
List <string> str = new List <string>();
foreach (var item in list)
{
string i = JsonConvert.SerializeObject(item);
str.Add(i);
}
var ans = JsonConvert.SerializeObject(str);
return(Json(ans));
}
else
{
return(Json("fail"));
}
}
catch
{
return(Json("fail"));
}
}
//產生訂單
public ActionResult MakeOrderIntoDB(int RtnCode, string RtnMsg, string CustomField1, string CustomField2)
{
SingleApartmentEntities db = new SingleApartmentEntities();
string cusID = CustomField1;
string OrderID = CustomField2;
db.Order.Where(r => r.OrderID.ToString() == OrderID).FirstOrDefault().PayStatus = "付款完成";
db.Order.Where(r => r.OrderID.ToString() == OrderID).FirstOrDefault().SendingStatus = "出貨中";
db.Order.Where(r => r.OrderID.ToString() == OrderID).FirstOrDefault().ArrivedDate = DateTime.Now.AddDays(7);
db.SaveChanges();
return(RedirectToAction("OrderList"));
}
//=====================================================================
//修改(還未加入商品圖片修改)
public ActionResult Edit(int id)
{
SingleApartmentEntities db = new SingleApartmentEntities();
Product prod = db.Product.FirstOrDefault(p => p.ProductID == id);
if (prod == null)
{
return(RedirectToAction("ProductList"));
}
return(View(prod));
}
public ActionResult ShowProductInCart(int MemberID)//第四步
{
int totalPrice = 0;
SingleApartmentEntities DB = new SingleApartmentEntities();
List <COrderDetailsViewModel> list = Session[CDictionary.PRODUCTS_IN_CART] as List <COrderDetailsViewModel>;
Order od = new Order();
//抓出多筆資料
foreach (var item in list)
{
OrderDetails ODD = new OrderDetails();
ODD.ProductName = DB.Product.Where(p => p.ProductID == item.ProductID).FirstOrDefault().ProductName;
ODD.Quantity = item.Quantity;
ODD.ProductID = item.ProductID;
ODD.UnitPrice = DB.Product.Where(p => p.ProductID == item.ProductID).FirstOrDefault().UnitPrice;
totalPrice += item.Quantity * (DB.Product.Where(p => p.ProductID == item.ProductID).FirstOrDefault().UnitPrice);
od.OrderDetails.Add(ODD);
}
//訂單日期
od.OrderDate = DateTime.Now;
//到貨日期
od.ArrivedDate = DateTime.Now.AddDays(7);
//總金額
od.TotalAmount = totalPrice;
od.OrderStatusID = 1;
od.SendingStatus = "配送中";
od.PayStatus = "尚未付款";
od.MemberID = MemberID;//到時候要改成使用者的memberID
DB.Order.Add(od);
DB.SaveChanges();
return(RedirectToAction("Home"));
}
//=====================================================================
////刪除
public ActionResult Delete(int id)
{
SingleApartmentEntities db = new SingleApartmentEntities();
Product prod = db.Product.FirstOrDefault(p => p.ProductID == id);
if (prod != null)
{
db.Product.Remove(prod);
db.SaveChanges();
}
return(RedirectToAction("ProductList"));
}
public ActionResult PartialONEOrder(string MemberID, int OrderID)
{
SingleApartmentEntities db = new SingleApartmentEntities();
CUser theUser = new CUser()
{
tMember = db.tMember.Where(r => r.fMemberId.ToString() == MemberID).FirstOrDefault()
};
var result = theUser.SearchOrder(OrderID);
ViewData.Model = result;
ViewBag.MemberID = MemberID;
return(PartialView("_PartialONEOrder"));
}
// GET: Product
#region index.html
public ActionResult Home()
{
SingleApartmentEntities db = new SingleApartmentEntities();
List <CProductViewModel> list = new List <CProductViewModel>();
foreach (var item in db.Product.Where(r => r.Discontinued == "N" && r.Stock >= 0))
{
list.Add(new CProductViewModel()
{
entity = item
});
}
return(View(list));
}
public ActionResult PartialOrders(string MemberID, int page = 1, int pageSize = 6)
{
SingleApartmentEntities db = new SingleApartmentEntities();
CUser theUser = new CUser()
{
tMember = db.tMember.Where(r => r.fMemberId.ToString() == MemberID).FirstOrDefault()
};
int currentPage = page < 1 ? 1 : page;
var lt = theUser.SearchOrders();
var result = lt.OrderByDescending(r => r.OrderDate).ToPagedList(currentPage, pageSize);
ViewData.Model = result;
ViewBag.MemberID = MemberID;
return(PartialView("_PartialOrders"));
}
//==========================================================
//商城後台上架商品
public ActionResult CreatAllProduct()
{
SingleApartmentEntities db = new SingleApartmentEntities();
//=====================================================================
//下拉式選單
var PROsubNamelist = (from p in db.ProductSubCategory
select p.ProductSubCategoryName).ToList();
SelectList SUBNamelist = new SelectList(PROsubNamelist, "Name");
ViewBag.SUBNAME = SUBNamelist;
//====================================================================
return(View());
}
