public ActionResult OtherMemberProfile(int omid) //傳其他會員ID { MemberCaseCount cc = new MemberCaseCount(); var acc = cc.casecount(omid); Member m = new Member(); var q = db.Member.Find(omid); var regionname = db.Region.Find(q.RegionID).RegionName; var cityname = db.City.Find(db.Region.Find(q.RegionID).CityID).CityName; Memberview mp = new Memberview(); mp.MemberID = q.MemberID; mp.LastName = q.LastName; mp.FirstName = q.FirstName; mp.Birthday = q.Birthday; mp.Email = q.Email; mp.CityName = cityname; mp.RegionName = regionname; mp.Address = q.Address; mp.Title = db.MemberStage.Find(q.Stage).Title; mp.NickName = q.NickName; mp.Phone = q.Phone; mp.Photo = q.Photo; mp.sumpoint = acc[0]; mp.casecount = acc[1]; mp.GDcasecount = acc[2]; mp.MPcasecount = acc[3]; mp.GDcasegive = acc[4]; mp.GDcaseneed = acc[5]; mp.MPcasegive = acc[6]; mp.MPcaseneed = acc[7]; var msk = db.MPSCList.Where(p => p.MemberID == omid).Select(p => p.MPSubClassID).ToList(); List <string> myskillname = new List <string>(); foreach (var a in msk) { var mk = db.MPSubClass.Where(p => p.MPSubClassID == a).Select(p => p.MPSubClass1).First(); myskillname.Add(mk); } ViewBag.Myskill = myskillname; return(View(mp)); }
public ActionResult MemberProfile() { MemberCaseCount cc = new MemberCaseCount(); int mid = (int)Session["MEMBERID"]; var acc = cc.casecount(mid); //int mid = 13; Member m = new Member(); var q = db.Member.Find(mid); var regionname = db.Region.Find(q.RegionID).RegionName; var cityname = db.City.Find(db.Region.Find(q.RegionID).CityID).CityName; Memberview mp = new Memberview(); mp.MemberID = q.MemberID; mp.LastName = q.LastName; mp.FirstName = q.FirstName; mp.Birthday = q.Birthday; mp.Email = q.Email; mp.CityName = cityname; mp.RegionName = regionname; mp.Address = q.Address; mp.Title = db.MemberStage.Find(q.Stage).Title; mp.NickName = q.NickName; mp.Phone = q.Phone; mp.Photo = q.Photo; mp.sumpoint = acc[0]; mp.casecount = acc[1]; mp.GDcasecount = acc[2]; mp.MPcasecount = acc[3]; mp.GDcasegive = acc[4]; mp.GDcaseneed = acc[5]; mp.MPcasegive = acc[6]; mp.MPcaseneed = acc[7]; //===全部專長 var sk = db.MPSubClass; ViewBag.skill = sk; //=============== //我的專長轉中文======= var msk = db.MPSCList.Where(p => p.MemberID == mid).Select(p => p.MPSubClassID).ToList(); //轉中文 List <string> myskillname = new List <string>(); foreach (var a in msk) { var mk = db.MPSubClass.Where(p => p.MPSubClassID == a).Select(p => p.MPSubClass1).First(); myskillname.Add(mk); } ViewBag.Myskill = myskillname; //======================== return(View(mp)); //allcasecount.Add(sumpoint); //0 //allcasecount.Add(casecount); //1 //allcasecount.Add(GDcasecount); //2 //allcasecount.Add(MPcasecount); //3 //allcasecount.Add(GDcasegive); //4 //allcasecount.Add(GDcaseneed); //5 //allcasecount.Add(MPcasegive); //6 //allcasecount.Add(MPcaseneed); //7 }
public ActionResult OtherMember() { MemberCaseCount mcc = new MemberCaseCount(); int mid = (int)Session["MEMBERID"]; var q = db.Member.Where(p => p.MemberID != mid).OrderBy(o => o.MemberID).ToList(); //除我之外 其他會員ID所有資料 var allmem = q.ToList(); //所有除了我之外的會員所有資料 var allmemid = q.Select(p => p.MemberID).ToList(); //所有其他會員的ID List <Memberview> mvlist = new List <Memberview>(); //=======會員專長 //var msk = db.MPSCList.Where(p => p.MemberID == mid).Select(p => p.MPSubClassID); //轉中文 //List<string> myskillname = new List<string>(); //foreach (var a in msk) //{ // var mk = db.MPSubClass.Where(p => p.MPSubClassID == a).Select(p => p.MPSubClass1).First(); // myskillname.Add(mk); //} //ViewBag.Myskill = myskillname; //============= for (int i = 0; i < allmem.Count; i++) { Memberview mv = new Memberview(); int memid = allmem[i].MemberID; mv.MemberID = memid; mv.NickName = allmem[i].NickName; mv.Stage = allmem[i].Stage; mv.Photo = allmem[i].Photo; mv.Email = allmem[i].Email; //mv.MPSubClass1 = "無"; var q12 = db.MPSCList.Where(o => o.MemberID == memid).ToList(); string mpsub = ""; foreach (var a in q12) { string asd = db.MPSubClass.Find(a.MPSubClassID).MPSubClass1; if (mpsub == "") { mpsub = asd; } else { mpsub = mpsub + "," + asd; } } if (mpsub == "") { mv.MPSubClass1 = "無"; } else { mv.MPSubClass1 = mpsub; } mv.casecount = mcc.casecount(allmemid[i])[1]; mv.sumpoint = mcc.casecount(allmemid[i])[0]; mv.GDcasecount = mcc.casecount(allmemid[i])[2]; mv.MPcasecount = mcc.casecount(allmemid[i])[3]; mv.GDcasegive = mcc.casecount(allmemid[i])[4]; mv.GDcaseneed = mcc.casecount(allmemid[i])[5]; mv.MPcasegive = mcc.casecount(allmemid[i])[6]; mv.MPcaseneed = mcc.casecount(allmemid[i])[7]; mvlist.Add(mv); } ViewBag.othermember = mvlist; return(View()); }
public ActionResult GoodsRead(int id) //caseid { CaseGoods cg = new CaseGoods(); if (id == 0) { id = (int)Session["CaseID"]; } var q = db.Cases.Find(id); if (Session["MEMBERID"] != null) { ViewBag.mid = q.MemberID; } cg.NickName = db.Member.Find(q.MemberID).NickName; cg.CaseID = q.CaseID; cg.StatusID = q.StatusID; 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.GdsName = g.GdsName; cg.GdsCount = g.GdsCount; cg.GdsPoint = g.GdsPoint; cg.GdsDeadline = g.GdsDeadline; 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 pcount = db.Picture.Where(m => m.CaseID == id).Count(); if (pcount > 0) { var pimg = db.Picture.Where(m => m.CaseID == id).FirstOrDefault(); cg.ImageID = pimg.ImageID; } //===============讀出這個case所有留言的會員資料 留言視窗使用 List <ContentViewModel> cv = new List <ContentViewModel>(); var allmember = (from m in db.Content where m.CaseID == q.CaseID orderby m.MessageDateTime descending select m).ToList(); foreach (var c in allmember) { ContentViewModel cvm = new ContentViewModel(); cvm.CaseID = q.CaseID; cvm.MemberID = c.MemberID; cvm.NickName = db.Member.Find(c.MemberID).NickName; cvm.Photo = db.Member.Find(c.MemberID).Photo; cvm.MessageContent = c.MessageContent; cvm.MessageDateTime = c.MessageDateTime; cvm.AuthorRepeat = c.AuthorRepeat; cv.Add(cvm); } ViewBag.ContentData = cv; MemberCaseCount mcc = new MemberCaseCount(); MemberSimpleProfile msp = new MemberSimpleProfile(); int memberid = q.MemberID; msp.CaseID = q.CaseID; msp.MemberID = q.MemberID; msp.Email = db.Member.Find(q.MemberID).Email; msp.NickName = db.Member.Find(q.MemberID).NickName; msp.Photo = db.Member.Find(q.MemberID).Photo; msp.sumpoint = mcc.casecount(memberid)[0]; ViewBag.MSP = msp; var msk = db.MPSCList.Where(p => p.MemberID == memberid).Select(p => p.MPSubClassID).ToList(); //轉中文 List <string> myskillname = new List <string>(); foreach (var a in msk) { var mk = db.MPSubClass.Where(p => p.MPSubClassID == a).Select(p => p.MPSubClass1).First(); myskillname.Add(mk); } ViewBag.Myskill = myskillname; return(View(cg)); }