//註冊新會員
public void Register(CRegisterModel newMember)
{
//sql新增 isAdmin預設為0
tMember t = new tMember();
t.f會員電子郵件 = newMember.txtEmail;
t.f會員帳號 = newMember.txtEmail;
t.f會員名稱 = newMember.txtNickname;
t.f會員密碼 = newMember.txtPassword;
t.f驗證碼 = newMember.fActivationCode;
t.isAdmin = false;
db.tMember.Add(t);
db.SaveChanges();
}
public ActionResult ResetPassword(CReset c)
{
var message = "";
if (ModelState.IsValid)
{
using (dbJoutaEntities db = new dbJoutaEntities())
{
var user = db.tMember.Where(a => a.f重置驗證碼 == c.resetCode).FirstOrDefault();
if (user != null)
{
user.f會員密碼 = c.newPassword;
user.f重置驗證碼 = "";
db.Configuration.ValidateOnSaveEnabled = false;
db.SaveChanges();
message = "新密碼重置成功!";
}
}
}
else
{
if (c.newPassword == null)
{
message = "內容必填";
}
else
{
message = "格式錯誤";
}
}
ViewBag.Message = message;
return(View());
}
public ActionResult e修改(tMember p)
{
dbJoutaEntities db = new dbJoutaEntities();
tMember A = db.tMember.FirstOrDefault(m => m.f會員編號 == p.f會員編號);
if (A != null)
{
A.f會員名稱 = p.f會員名稱;
A.f會員評分 = p.f會員評分;
A.f會員稱號 = p.f會員稱號;
A.f會員大頭貼 = p.f會員大頭貼;
A.f會員帳號 = p.f會員帳號;
A.f會員密碼 = p.f會員密碼;
A.f會員電子郵件 = p.f會員電子郵件;
A.f會員手機 = p.f會員手機;
A.f會員電話 = p.f會員電話;
A.f會員生日 = p.f會員生日;
A.f會員自我介紹 = p.f會員自我介紹;
A.f會員暱稱 = p.f會員暱稱;
A.f會員性別 = p.f會員性別;
A.f會員興趣 = p.f會員興趣;
db.SaveChanges();
}
return(RedirectToAction("List"));
}
public ActionResult ForgetPassword(string Email)
{
string message = "";
//bool status = false;
using (dbJoutaEntities db = new dbJoutaEntities())
{
var account = db.tMember.Where(a => a.f會員電子郵件 == Email).FirstOrDefault();
if (account != null)
{
string resetCode = Guid.NewGuid().ToString();
sendResetPasswordMail(account.f會員電子郵件, resetCode);
account.f重置驗證碼 = resetCode;
db.Configuration.ValidateOnSaveEnabled = false;
db.SaveChanges();
message = "重置密碼連結已經發送至您指定信箱，請前往設置!";
}
else
{
if (Email == "")
{
message = "請填入信箱";
}
else
{
message = "該信箱不存在!!";
}
}
}
ViewBag.Msg = message;
return(View());
}
public ActionResult r回覆(C回覆 y, tComment p)
{
send(y);
//ViewBag.kk = "傳送成功";
dbJoutaEntities db = new dbJoutaEntities();
tComment A = db.tComment.FirstOrDefault(m => m.fID == p.fID);
if (A != null)
{
A.f意見狀態 = "已回覆";
db.SaveChanges();
}
return(RedirectToAction("List"));
}
public ActionResult LikeIt(int?id)
{
var article = from t in (new dbJoutaEntities()).tActivity
where t.f活動類型 == "文章" && t.f活動編號 == id
select t;
dbJoutaEntities db = new dbJoutaEntities();
var target = db.tActivity.Where(t => t.f活動編號 == id).FirstOrDefault();
target.f活動讚數 += 1;
db.SaveChanges();
return(RedirectToAction("BlogContent", new { id = id }));
}
public ActionResult Save()
{
tMember y = (tMember)Session["member"];
var x = db.tMember.Where(a => a.f會員編號 == y.f會員編號).FirstOrDefault();
x.f會員名稱 = Request.Form["txtName"];
x.f會員暱稱 = Request.Form["txtNickName"];
x.f會員生日 = Request.Form["txtBirth"];
x.f會員興趣 = Request.Form["txtHobby"];
x.f會員自我介紹 = Request.Form["txtIntro"];
db.SaveChanges();
ViewBag.msg = "資料修改成功";
return(RedirectToAction("ProfileIndex"));
}
public ActionResult Create(CBlog p)
{
HttpPostedFileBase blogPhoto = Request.Files["blogPhoto"];
if (p.blogPhoto != null)
{
string photName = Guid.NewGuid().ToString() + Path.GetExtension(p.blogPhoto.FileName);
var path = Path.Combine(Server.MapPath("~/Content/images/"), photName);
p.blogPhoto.SaveAs(path);
p.f活動團圖 = photName;
}
tActivity article = new tActivity();
article.f活動類型 = "文章";
article.f活動標題 = p.txtTitle;
article.f活動地點 = p.txtLocation;
article.f活動內容 = p.txtContent;
article.f活動團圖 = p.f活動團圖;
article.fQRcode網址 = p.QRcode;
article.fQRcodeImage = p.QRcodeImage;
article.f活動發起日期 = (DateTime.Now).ToString("yyyy-MM-dd HH:mm:ss");
article.f活動地區 = p.f活動地區;
article.f活動瀏覽次數 = 0;
article.f活動讚數 = 0;
var LoginMember = (tMember)Session["member"];
article.f會員編號 = LoginMember.f會員編號;
if (article != null)
{
dbJoutaEntities db = new dbJoutaEntities();
db.tActivity.Add(article);
db.SaveChanges();
return(RedirectToAction("index"));
}
else
{
return(RedirectToAction("index"));
}
}
public ActionResult d刪除(int?id)
{
if (id == null)
{
RedirectToAction("List");
}
tComment x = new tComment();
dbJoutaEntities db = new dbJoutaEntities();
x = db.tComment.FirstOrDefault(m => m.fID == id);
db.tComment.Remove(x);
db.SaveChanges();
return(RedirectToAction("List"));
}
public ActionResult BlogContent(int?id)
{
var article = from t in (new dbJoutaEntities()).tActivity
where t.f活動類型 == "文章" && t.f活動編號 == id
select t;
dbJoutaEntities db = new dbJoutaEntities();
var target = db.tActivity.Where(t => t.f活動編號 == id).FirstOrDefault();
target.f活動瀏覽次數 += 1;
db.SaveChanges();
return(View(article.FirstOrDefault()));
}
public ActionResult d刪除(int?id)
{
if (id == null)
{
RedirectToAction("List");
}
tActivity x = new tActivity();
dbJoutaEntities db = new dbJoutaEntities();
x = db.tActivity.FirstOrDefault(m => m.f活動編號 == id);
db.tActivity.Remove(x);
db.SaveChanges();
return(RedirectToAction("List"));
}
public ActionResult UploadImg(tMember t)
{
dbJoutaEntities db = new dbJoutaEntities();
var x = db.tMember.Where(a => a.f會員編號 == t.f會員編號).FirstOrDefault();
HttpPostedFileBase avaPhoto = Request.Files["f會員大頭貼"];
if (avaPhoto != null)
{
string photName = Guid.NewGuid().ToString() + Path.GetExtension(avaPhoto.FileName);
var path = Path.Combine(Server.MapPath("~/Content/images/"), photName);
avaPhoto.SaveAs(path);
x.f會員大頭貼 = photName;
}
db.SaveChanges();
return(RedirectToAction("ProfileIndex"));
}
public ActionResult d刪除(int?id)
{
if (id == null)
{
RedirectToAction("List");
}
tMember x = new tMember();
dbJoutaEntities db = new dbJoutaEntities();
var y = db.tActivity.Where(m => m.f會員編號 == id).ToList();
db.tActivity.RemoveRange(y);
x = db.tMember.FirstOrDefault(m => m.f會員編號 == id);
db.tMember.Remove(x);
db.SaveChanges();
return(RedirectToAction("List"));
}
public ActionResult New(C回覆 y)
{
dbJoutaEntities db = new dbJoutaEntities();
tComment x = new tComment();
x.f標題 = Request.Form["f標題"];
x.f意見 = Request.Form["f意見"];
x.f性別 = Request.Form["f性別"];
x.f意見類型 = Request.Form["f意見類型"];
x.f聯絡人 = Request.Form["f聯絡人"];
x.f電子郵件 = Request.Form["f電子郵件"];
x.f電話 = Request.Form["f電話"];
x.f意見時間 = DateTime.Now.ToString();
x.f意見狀態 = "未回覆";
db.tComment.Add(x);
db.SaveChanges();
string message = "傳送成功";
ViewBag.ll = message;
return(View());
}
public ActionResult AddComment(CBlogComment p)
{
var ct = DateTime.Now;
var CurrentTime = ct.ToString();
var coomment = new tBlogComment()
{
f活動編號 = p.f活動編號,
fBlogComment = p.Content,
fCreateDate = CurrentTime,
};
db.tBlogComment.Add(coomment);
db.SaveChanges();
return(RedirectToAction("BlogContent", new { id = p.f活動編號 }));
}
public string FeelGood(int memberID, int actID)
{
tActivity theTarget = db.tActivity.FirstOrDefault(x => x.f活動編號 == actID);
int index = -1;
if (!string.IsNullOrEmpty(theTarget.f活動按過讚的會員編號))
{
var past = theTarget.f活動按過讚的會員編號.Split(','); //將按過讚得會員編號 字串 切割 成陣列
index = Array.IndexOf(past, memberID.ToString()); //透過查詢值在陣列內的索引值(不存在則回傳-1)
//查看是否會員編號包含在陣列內
}
if (index == -1)//陣列起始為0，因此只要pos>=0則表示該編號已存在，反之index=-1表示該編號不存在，可執行
{
theTarget.f活動讚數 = (theTarget.f活動讚數 + 1);
theTarget.f活動按過讚的會員編號 += "," + memberID;
db.SaveChanges();
return(null);
}
else
{
return("0");
}
}
public ActionResult Edit(tActivity p)
{
tMember Member = (tMember)Session["member"];
tActivity targetAct = db.tActivity.Where(t => t.f活動編號 == p.f活動編號).FirstOrDefault();
var NowMember = db.tMember.Where(t => t.f會員編號 == Member.f會員編號).FirstOrDefault();
string[] usedTime = { };
if (!string.IsNullOrEmpty(NowMember.f會員已占用時間))
{
usedTime = NowMember.f會員已占用時間.Split(',');
//先移除登入會員原本這筆活動的活動時段
usedTime = usedTime.Where(t => t != targetAct.f活動開始時間 + "~" + targetAct.f活動結束時間).ToArray();
//再判別修改的活動時段是否已占用
string[] used;
foreach (var item in usedTime)
{
if (!string.IsNullOrEmpty(item))
{
used = item.Split('~'); //used[0] 已佔用的開始時間，used[1] 已佔用的結束時間
if (string.Compare(p.f活動開始時間, used[1]) > 0 || string.Compare(used[0], p.f活動結束時間) > 0)
{
}
else
{
return(RedirectToAction("TravelIndex", "Travel", new { msg = "錯誤! 修改的活動時間與既有活動時間相衝" }));
}
}
}
}
//時間過關
//因為活動時段變更所以要剔除所有參加者(不是每個人都想參加新時段)
//撈出所有參加會員的編號，並讓他們退團
if (!string.IsNullOrEmpty(targetAct.f活動參加的會員編號))
{
string[] DeleteList = targetAct.f活動參加的會員編號.Split(',');
foreach (var item in DeleteList)
{
if (!string.IsNullOrEmpty(item))
{
//移除活動編號
tMember Delete = db.tMember.Where(t => t.f會員編號.ToString() == item).FirstOrDefault();
Delete.f會員參加的活動編號 =
string.Join(",", Delete.f會員參加的活動編號.Split(',').Where(t => t != targetAct.f活動編號.ToString()));
//移除占用時間
string[] usedTime2 = Delete.f會員已占用時間.Split(',');
Delete.f會員已占用時間 =
string.Join(",", usedTime2.Where(t => t != targetAct.f活動開始時間 + "~" + targetAct.f活動結束時間));
}
}
}
//修改變更項目
//使用刪除舊活動過後的占用時間加上新的活動時間
NowMember.f會員已占用時間 = string.Join(",", usedTime) + "," + p.f活動開始時間 + "~" + p.f活動結束時間;
NowMember.f會員參加的活動編號 += "," + targetAct.f活動編號; //因為被剔除了，所以重新添加
tActivity Temp = new tActivity();
targetAct.f活動內容 = Request.Form["f活動內容2"]; //配合文字編輯器，待改良;
targetAct.f活動參加的會員編號 = NowMember.f會員編號.ToString();
targetAct.f活動地區 = p.f活動地區;
targetAct.f活動招募截止時間 = p.f活動招募截止時間;
targetAct.f活動標題 = p.f活動標題;
targetAct.f活動結束時間 = p.f活動結束時間;
targetAct.f活動開始時間 = p.f活動開始時間;
targetAct.f活動預算 = p.f活動預算;
targetAct.f活動經度 = p.f活動經度;
targetAct.f活動緯度 = p.f活動緯度;
targetAct.f活動審核名單 = null;
HttpPostedFileBase PicFile = Request.Files["PicFile2"];
if (PicFile != null)
{
var NewFileName = Guid.NewGuid() + Path.GetExtension(PicFile.FileName);
var NewFilePath = Path.Combine(Server.MapPath("~/Content/images/"), NewFileName);
PicFile.SaveAs(NewFilePath);
targetAct.f活動團圖 = NewFileName;
}
db.SaveChanges();
return(RedirectToAction("TravelIndex"));
}