// GET: MyCaseCenter/MyGood
public ActionResult Index() //我的物品瀏覽
{
Session["CaseID"] = null;
if (Session["MEMBERID"] == null)
{
Session["MEMBERID"] = 12;//先寫死
}
int memberid = (int)Session["MEMBERID"];
List <CaseGood> cgs = new List <CaseGood>();
var q = (from o in db.Cases
join c in db.Goods on o.CaseID equals c.CaseID
where o.MemberID == memberid
orderby o.StartDateTime
select o).ToList();
List <OrderCount> oco = new List <OrderCount>();
foreach (var a in q)
{
OrderCount ocou = new OrderCount();
ocou.CaseID = a.CaseID;
ocou.CaseTitle = a.CaseTitle;
ocou.Cou = db.Orders.Where(o => o.CaseID == a.CaseID).Count();
oco.Add(ocou);
CaseGood cg = new CaseGood();
cg.CaseID = a.CaseID;
cg.CaseTitle = a.CaseTitle;
cg.StartDateTime = a.StartDateTime;
int caseid = a.CaseID;
int stasid = a.StatusID;
cg.StatusName = db.CaseStatus.Find(stasid).StatusName;
var q2 = db.Goods.Where(m => m.CaseID == caseid).Select(m => m);
foreach (var x in q2)
{
cg.GdsName = x.GdsName;
cg.GdsPoint = x.GdsPoint;
cg.GdsCount = x.GdsCount;
}
cgs.Add(cg);
}
//MemberCaseCount mcc = new MemberCaseCount();
//var t = mcc.casecount(memberid);
int ccount = db.Cases.Where(o => o.MemberID == memberid).Count();
ViewBag.allcase = ccount;
ViewBag.GDcase = q.Count();
ViewBag.Count = oco;
return(View(cgs));
}
public ActionResult EditGood(int id) //CaseID 修改的頁面 先讀取單筆
{
CaseGood cg = new CaseGood();
var q = db.Cases.Find(id);
cg.CaseID = q.CaseID;
Session["CaseID"] = q.CaseID;
cg.CaseTitle = q.CaseTitle;
cg.CaseContent = q.CaseContent;
cg.StartDateTime = q.StartDateTime;
cg.Location = q.Location; //地址還不完整!!!!!!!
cg.Contact = q.Contact;
cg.StatusName = db.CaseStatus.Find(q.StatusID).StatusName; //狀態
var g = db.Goods.Where(m => m.CaseID == q.CaseID).First();
cg.GdsID = g.GdsID;
cg.GdsName = g.GdsName;
cg.GdsCount = g.GdsCount;
cg.GdsPoint = g.GdsPoint;
var sub = db.GdsSubClass.Find(g.GdsSubClassID);
cg.GdsSubClass1 = sub.GdsSubClass1; //小分類
cg.GdsClass = db.GoodsClass.Find(sub.GdsClassID).GdsClass; //大分類
var re = db.Region.Find(q.RegionID);
cg.RegionName = re.RegionName; //區
cg.CityName = db.City.Find(re.CityID).CityName; //縣市
int count = db.Picture.Where(o => o.CaseID == id).Count();
if (count > 0)
{
var pimg = db.Picture.Where(m => m.CaseID == id).FirstOrDefault();
cg.ImageID = pimg.ImageID;
}
Goods goods = db.Goods.Find(g.GdsID);
GdsSubClass subclass = db.GdsSubClass.Find(g.GdsSubClassID);
ViewBag.GdsSubClassID = new SelectList(db.GdsSubClass.Where(o => o.GdsClassID == subclass.GdsClassID), "GdsSubClassID", "GdsSubClass1", goods.GdsSubClassID);
ViewBag.GdsClassID = new SelectList(db.GoodsClass, "GdsClassID", "GdsClass", subclass.GdsClassID);
Cases _case = db.Cases.Find(id);
Region region = db.Region.Find(q.RegionID);
ViewBag.RegionID = new SelectList(db.Region.Where(o => o.CityID == region.CityID), "RegionID", "RegionName", _case.RegionID);
ViewBag.CityID = new SelectList(db.City, "CityID", "CityName", region.CityID);
ViewBag.count = count;
return(View(cg));
}
public ActionResult EditGood(CaseGood goodv, IEnumerable <HttpPostedFileBase> files)
{
if (files != null)
{
foreach (var file in files)
{
if (file != null)
{
var imagesSize = file.ContentLength;
byte[] imageByte = new byte[imagesSize];
file.InputStream.Read(imageByte, 0, imagesSize);
db.Picture.Add(new Picture {
CaseID = goodv.CaseID, Images = imageByte
});
db.SaveChanges();
TempData["message"] = "上傳成功";
}
else
{
TempData["message"] = "請先選檔案";
}
}
}
var c = db.Cases.Find(goodv.CaseID);
c.CaseTitle = goodv.CaseTitle;
c.CaseContent = goodv.CaseContent;
c.Contact = goodv.Contact;
c.Location = goodv.Location;
c.RegionID = goodv.RegionID;
var g = db.Goods.Find(goodv.GdsID);
//g.GdsName = goodv.GdsName;
g.GdsCount = goodv.GdsCount;
g.GdsPoint = 0;
g.GdsSubClassID = goodv.GdsSubClassID;
db.SaveChanges();
return(RedirectToAction("LoadGood"));
}
public ActionResult LoadGood(int id = 0)//CaseID 完整資訊 單筆 //還需要部份檢視 秀多張圖
{
CaseGood cg = new CaseGood();
if (id == 0)
{
id = (int)Session["CaseID"];
}
var q = db.Cases.Find(id);
cg.CaseID = q.CaseID;
Session["CaseID"] = q.CaseID;
cg.CaseTitle = q.CaseTitle;
cg.CaseContent = q.CaseContent;
cg.StartDateTime = q.StartDateTime;
cg.Location = q.Location; //地址還不完整!!!!!!!
cg.Contact = q.Contact;
cg.StatusID = q.StatusID;
cg.StatusName = db.CaseStatus.Find(q.StatusID).StatusName; //狀態
var g = db.Goods.Where(m => m.CaseID == q.CaseID).First();
cg.GdsName = g.GdsName;
cg.GdsCount = g.GdsCount;
cg.GdsPoint = g.GdsPoint;
var sub = db.GdsSubClass.Find(g.GdsSubClassID);
cg.GdsSubClass1 = sub.GdsSubClass1; //小分類
cg.GdsClass = db.GoodsClass.Find(sub.GdsClassID).GdsClass; //大分類
var re = db.Region.Find(q.RegionID);
cg.RegionName = re.RegionName; //區
cg.CityName = db.City.Find(re.CityID).CityName; //縣市
int count = db.Picture.Where(o => o.CaseID == id).Count();
if (count > 0)
{
var pimg = db.Picture.Where(m => m.CaseID == id).FirstOrDefault();
cg.ImageID = pimg.ImageID;
}
List <ContentViewModel> che = new List <ContentViewModel>();
var q3 = db.Content.Where(o => o.CaseID == id).OrderByDescending(o => o.MessageDateTime).ToList();
foreach (var a in q3)
{
ContentViewModel _order = new ContentViewModel();
int mem = a.MemberID;
var mb = db.Member.Find(mem);
_order.MessageContent = a.MessageContent;
_order.ContentID = a.ContentID;
_order.MessageDateTime = a.MessageDateTime;
_order.AuthorRepeat = a.AuthorRepeat;
_order.NickName = mb.NickName;
_order.MemberID = mem;
_order.Birthday = mb.Birthday;
_order.Phone = mb.Phone;
_order.Address = mb.Address;
var reg = db.Region.Find(mb.RegionID);
_order.RegionName = reg.RegionName;
_order.CityName = db.City.Where(o => o.CityID == reg.CityID).First().CityName;
string mpclassname = "";
var mpl = db.MPSCList.Where(o => o.MemberID == mem).ToList(); //每個會員的多個小專長ID
foreach (var b in mpl)
{
string MPSub = db.MPSubClass.Find(b.MPSubClassID).MPSubClass1;
mpclassname = mpclassname + MPSub + " ";
}
_order.MPSubClass1 = mpclassname;
che.Add(_order);
}
ViewBag.ContentMember = che;
return(View(cg));
}
