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