public CActAdd ActAddEvent(int actID, int memberID) { var loginMember = db.tMember.Where(t => t.f會員編號 == memberID).FirstOrDefault(); string[] blackList = { }; if (!string.IsNullOrEmpty(loginMember.f會員黑名單)) { blackList = loginMember.f會員黑名單.Split(','); } var targetAct = db.tActivity.Where(t => t.f活動編號 == actID).FirstOrDefault(); string[] attendGuysID = { }; tMember[] attendGuys = { }; if (!string.IsNullOrEmpty(targetAct.f活動參加的會員編號)) { attendGuysID = targetAct.f活動參加的會員編號.Split(','); attendGuys = new tMember[attendGuysID.Length]; for (int i = 0; i < attendGuys.Length; i++) { if (string.IsNullOrEmpty(attendGuysID[i])) { continue; } int temp = Convert.ToInt32(attendGuysID[i]); attendGuys[i] = db.tMember.Where(t => t.f會員編號 == temp).FirstOrDefault(); } } string[] wantGuysID = { }; tMember[] wantGuys = { }; if (!string.IsNullOrEmpty(targetAct.f活動審核名單)) { wantGuysID = targetAct.f活動審核名單.Split(','); wantGuys = new tMember[wantGuysID.Length]; for (int i = 0; i < wantGuys.Length; i++) { if (string.IsNullOrEmpty(wantGuysID[i])) { continue; } int temp = Convert.ToInt32(wantGuysID[i]); wantGuys[i] = db.tMember.Where(t => t.f會員編號 == temp).FirstOrDefault(); } } CActAdd result = new CActAdd(); result.TargetAct = targetAct; result.AttendGuys = attendGuys; result.BlackList = blackList; result.WantGuys = wantGuys; return(result); }
public ActionResult e修改(int?id) { if (id == null) { RedirectToAction("List"); } dbJoutaEntities db = new dbJoutaEntities(); tMember x = new tMember(); x = db.tMember.FirstOrDefault(m => m.f會員編號 == id); return(View(x)); }
protected void btnUpDate_Click(object sender, EventArgs e) { tMember x = db.tMember.First(t => t.fIdMember == id); x.fAddress = txtAddress.Text; x.fEmail = txtEmail.Text; x.fPhone = txtPhone.Text; x.fName = txtName.Text; //更新 db.SubmitChanges(); lblMsg.Text = "更新資料成功"; lblMsg.Visible = true; Response.Redirect("memberCenter_New.aspx?tab=1&success=1"); }
// GET: tMembers/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tMember tMember = db.tMembers.Find(id); if (tMember == null) { return(HttpNotFound()); } return(View(tMember)); }
// GET: Admin/tMembers/Edit/5 public ActionResult Edit(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tMember tMember = db.tMember.Find(id); if (tMember == null) { return(HttpNotFound()); } return(View(tMember)); }
public ActionResult Add(tActivity p) { tMember Member = (tMember)Session["member"]; //判別登入會員其活動時段是否已占用 var NowMember = db.tMember.Where(t => t.f會員編號 == Member.f會員編號).FirstOrDefault(); if (!string.IsNullOrEmpty(NowMember.f會員已占用時間)) { string[] usedTime = NowMember.f會員已占用時間.Split(','); 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("EatIndex", "Eat", new { msg = "錯誤! 新增的活動與既有活動時間相衝" })); } } } } //添加占用時間 NowMember.f會員已占用時間 += "," + p.f活動開始時間 + "~" + p.f活動結束時間; p.f會員編號 = Member.f會員編號; p.f活動類型 = "飯局"; p.f活動參加的會員編號 = "," + Member.f會員編號; db.tActivity.Add(p); db.SaveChanges(); int ID = db.tActivity.Where(t => t.f會員編號 == Member.f會員編號) .OrderByDescending(t => t.f活動發起日期).Select(t => t.f活動編號).FirstOrDefault(); NowMember.f會員發起的活動編號 += "," + ID; NowMember.f會員參加的活動編號 += "," + ID; HttpPostedFileBase PicFile = Request.Files["PicFile"]; if (PicFile != null) { var NewFileName = Guid.NewGuid() + Path.GetExtension(PicFile.FileName); var NewFilePath = Path.Combine(Server.MapPath("~/Content/images/"), NewFileName); PicFile.SaveAs(NewFilePath); p.f活動團圖 = NewFileName; } db.SaveChanges(); return(RedirectToAction("EatIndex")); }
public ActionResult Signup(tMember items) { FitnessEntities db = new FitnessEntities(); items.fMember_time = DateTime.Now + TimeSpan.FromMinutes(10); string number = randnum(); items.fMember_Num = number; CSendEmail.sendemail(new string[] { items.fMemberEmail }, CSendEmail.getnum(number)); items.fMemberPicture = "https://cdn4.iconfinder.com/data/icons/small-n-flat/24/user-group-512.png"; db.tMember.Add(items); db.SaveChanges(); return(RedirectToAction("../Fitness/Index")); }
protected void picUpload_Click(object sender, EventArgs e) { Boolean fileOk = false; String fileExtension = System.IO.Path.GetExtension(picUpload.FileName).ToLower(); //指定檔路徑,pic是專案下的一個資料夾;~表示當前網頁所在的資料夾 String path = Server.MapPath("~/img/upp/");//物理檔路徑 //檔上傳控制項中如果已經包含檔 if (picUpload.HasFile) { //得到檔的尾碼 //允許檔的尾碼 String[] allowedExtensions = { ".gif", ".png", ".jpeg", ".jpg", ".bmp" }; //看包含的檔是否是被允許的檔的尾碼 for (int i = 0; i < allowedExtensions.Length; i++) { if (fileExtension == allowedExtensions[i]) { fileOk = true; } } } if (fileOk) { try { //檔另存在伺服器的指定目錄下 string photoName = Guid.NewGuid().ToString() + fileExtension; picUpload.PostedFile.SaveAs(path + photoName); Response.Write("<script>alert('檔上傳成功!');</script>"); tMember x = db.tMember.First(t => t.fIdMember == id); x.fPhoto = photoName; db.SubmitChanges(); imgPic2.ImageUrl = imgURL + x.fPhoto; imgPic.ImageUrl = imgURL + x.fPhoto; } catch { Response.Write("<script>alert('檔上傳失敗!');</script>"); } } else { Response.Write("<script>alert('只能上傳gif,png,jpeg,jpg,bmp圖像檔!');</script>"); } }
protected void Page_Load(object sender, EventArgs e) { tMember mb = Session[CDKey.LOGINUSER] as tMember; if (mb != null) { if (mb.fIdentity == 1) { Label1.Text = "新人才能報價"; Label1.Visible = true; Button1.Enabled = false; } } processPageAsk(Label2); }
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 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 Edit([Bind(Include = "Id,password")] tMember tMember) { if (ModelState.IsValid) { #region 密碼加密 tMember.memguid = db.tMember.Where(m => m.Id == tMember.Id).Select(m => m.memguid).FirstOrDefault(); tMember = EditHashPasword(tMember); #endregion db.Entry(tMember).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(tMember)); }
//信箱驗證碼驗證 public string emailValidation(string email, string authCode) { CRegisterModel c = getAccount(email); //宣告驗證後訊息字串 string validationStr = string.Empty; if (c != null) { dbJoutaEntities db = new dbJoutaEntities(); tMember t = db.tMember.FirstOrDefault(k => k.f會員電子郵件 == email && k.f驗證碼 == authCode); t.f驗證碼 = ""; validationStr = "信箱驗證成功,現在可以登入囉~"; } return(validationStr); }
public void ProcessLetterMsg(tMember member, HttpContext context, int page) { List <string> strSender = new List <string>(); string strMsg = ""; var table = from t in db.tLetter where t.fIdReceiver == member.fIdMember && t.fLetterOrChat == 1 orderby t.fSendTime descending select t; int countPage = 0; foreach (var s in table) { countPage++; } countPage = (countPage % 10 == 0 ? countPage / 10 : (countPage / 10) + 1); int i = 0; foreach (tLetter l in table.Skip((page - 1) * 10).Take(10)) { var sender = from g in db.tMember where g.fIdMember == l.fIdSender select g; foreach (tMember s in sender) { strSender.Add(s.fName); } strMsg += "<div class='row'><div class=\"span8 colinoutbolder\">" + "<div class=\"msgtitle\">" + "<h4>來自" + strSender[i] + "的站內信" + "<a href='#' data-letterid='" + l.fIdILetter + "' class='pull-left btn btn-danger colinletterdel'>刪除</a>" + "<div class=\"pull-right\">" + l.fSendTime + "</div>" + ((l.fIsRead == true) ? "" : "<span class='badge pull-right'>新</span>") + "</h4>" + "</div>" + "<div class=\"msgcontent\">" + l.fContent + "</div>" + "</div></div>"; i++; } strMsg += "<div class='row' style='text-align:center;'><div class='pagination pagination-centered paginationletter'><ul>"; for (int g = 1; g <= countPage; g++) { strMsg += "<li" + (g == page ? " class='active'" : "") + "><a href='#'>" + g + "</a></li>"; } strMsg += "</ul></div></div>"; context.Response.Write(strMsg); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { lblMessage.Visible = false; tMember mb = Session[CDKey.LOGINUSER] as tMember; if (mb == null) { lblTitle.Visible = true; lblTitle.Text = "<div class='span3' style='border-radius:25px;background-color:red;margin:0 42%;text-align:center;color:white;'>登入即可發起討論</div>"; FormView1.Visible = false; } processPageforum(Label2); } }
protected void Button1_Click(object sender, EventArgs e) { tMember mb = Session[CDKey.LOGINUSER] as tMember; tAskPrice a = new tAskPrice(); a.fContent = "需求地點:" + ((Master.FindControl("ContentPlaceHolder1").FindControl("space") as HtmlSelect).Value == "0" ?"不拘": (Master.FindControl("ContentPlaceHolder1").FindControl("space") as HtmlSelect).Value) + "<br/>" + Request.Form["descri"].Replace("\r\n", "<br/>"); a.fIdMember = mb.fIdMember; a.fTitle = "找" + Request.Form["date"] + (Master.FindControl("ContentPlaceHolder1").FindControl("servies") as HtmlSelect).Value; a.fWantDay = Convert.ToDateTime(Request.Form["date"]); a.fSendTime = DateTime.Now; db.tAskPrice.InsertOnSubmit(a); db.SubmitChanges(); Response.Redirect("AskPrice.aspx"); }
public static result check_register(string user, string name, string email, string pw, int sex, string phone, string birth, string add, string country, string countryname, string district, string districtname) { CNManagerDataContext db = new CNManagerDataContext(); clsProcess cl = new clsProcess(); var r = new result(); try { var mb = new tMember(); mb.Username = user.Trim(); mb.MemberCode = "MB" + DateTime.Now.ToString("ddMMyyyyHHmmss"); mb.MemberName = name.Trim(); mb.Email = email.Trim().ToLower(); mb.Password = cl.MaHoa(pw.Trim()); mb.Sex = sex == 1 ? true : false; mb.Phone = phone.Trim(); if (birth.Trim() != "") { mb.Birthday = DateTime.Parse(cl.returnDatetime(birth.Trim())); } mb.Address = add.Trim(); if (country != "") { mb.CountryId = int.Parse(country.Trim()); mb.CountryName = countryname; } if (district != "") { mb.DistrictId = int.Parse(district.Trim()); mb.DistrictName = districtname; } mb.BranchTypeId = branchTypeId; mb.Status = 1; mb.JoinCreateAt = DateTime.Now; mb.CreateAt = DateTime.Now; db.tMembers.InsertOnSubmit(mb); db.SubmitChanges(); r._mess = "Đăng kí tài khoản thành công"; r._content = "ok"; } catch (Exception ax) { r._content = "err"; r._mess = ax.Message; } return(r); }
public ActionResult Register(tMember pMember) { if (ModelState.IsValid == false) { return(View()); } var member = db.tMember .Where(m => m.fUserId == pMember.fUserId) .FirstOrDefault(); if (member == null) { //string strConnString = ConfigurationManager.ConnectionStrings["connect"].ConnectionString; //string com_str = $"INSERT INTO [dbo].[tMember] ([fUserId], [fPwd], [fName], [fEmail]) VALUES (@fUserId, @fPwd, @fName, @fEmail);"; //using (SqlConnection con = new SqlConnection(strConnString)) //{ // SqlCommand scom = new SqlCommand(com_str, con); // scom.Parameters.AddWithValue("@fUserId", pMember.fUserId); // scom.Parameters.AddWithValue("@fPwd", pMember.fPwd); // scom.Parameters.AddWithValue("@fName", pMember.fName); // scom.Parameters.AddWithValue("@fEmail", pMember.fEmail); // try // { // con.Open(); // scom.ExecuteNonQuery(); // } // catch (Exception ex) // { // Console.WriteLine(ex.Message); // } // finally // { // con.Close(); // } //} db.tMember.Add(pMember); db.SaveChanges(); return(RedirectToAction("Login")); } ViewBag.Message = "此帳號已有人使用"; return(View(0)); }
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 Register(tMember pMember) { if (ModelState.IsValid == false) { return(View()); } var member = db.tMember.Where(m => m.fUserId == pMember.fUserId).FirstOrDefault(); if (member == null) { db.tMember.Add(pMember); db.SaveChanges(); return(RedirectToAction("Login")); } ViewBag.Message = "此帳號已有人使用,註冊失敗"; return(View()); }
//取得公開資料 public CRegisterModel getAccount_openSource(string email) { CRegisterModel c = new CRegisterModel(); tMember t = db.tMember.FirstOrDefault(k => k.f會員電子郵件 == email); try { c.txtEmail = t.f會員電子郵件; c.txtNickname = t.f會員名稱; } catch (Exception) { //查無資料 c = null; } return(c); }
protected void FormView1_ItemInserting(object sender, FormViewInsertEventArgs e) { if (Request.Form["msg"].Length > 0) { tMember mb = Session[CDKey.LOGINUSER] as tMember; e.Values["fIdTitle"] = Convert.ToInt32(Request["fIdTitle"]); e.Values["fIdMember"] = mb.fIdMember; e.Values["fSendTime"] = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); e.Values["fContent"] = Request.Form["msg"]; } else { lblMsg.Visible = true; lblMsg.Text = "<div class='span2' style='border-radius:25px;background-color:red;margin:0 42%;text-align:center;color:white;'>留言必須填寫</div>"; e.Cancel = true; } }
public ActionResult Register(CMember input)//此處更新 { if (ModelState.IsValid == false) { return(View()); } var member = db.tMember.Where(p => p.fAccount == input.fAccount).FirstOrDefault(); if (member == null) { int index = input.myImage.FileName.IndexOf("."); string extention = input.myImage.FileName.Substring(index, input.myImage.FileName.Length - index); string photoName = Guid.NewGuid().ToString() + extention; input.fImage = "../Content/" + photoName; input.myImage.SaveAs(Server.MapPath("../Content/") + photoName); //此處新增--------------------------- tMember t = new tMember(); t.fMemberId = input.fMemberId; t.fMemberName = input.fMemberName; t.fAccount = input.fAccount; t.fPassword = input.fPassword; t.fEmail = input.fEmail; t.fRoomId = input.fRoomId; t.fPhone = input.fPhone; t.fAge = input.fAge; t.fSex = input.fSex; t.fBirthDate = input.fBirthDate; t.fSalary = input.fSalary; t.fCareer = input.fCareer; t.fImage = input.fImage; t.fLeave = input.fLeave; t.fRole = input.fRole; t.fActivityMessage = input.fActivityMessage; t.fActivityEmail = input.fActivityEmail; //---------------------------------- db.tMember.Add(t); db.SaveChanges(); return(RedirectToAction("LogIn")); } ViewBag.Message = "此帳號已有人使用,請輸入新的帳號"; return(View()); }
public bool insertMember(string name, string birthday, string sex, string phone, string add, string email, string note, int branchtype, out string mess) { mess = ""; bool ok = false; try { var checkPhone = from x in db.tMembers where x.BranchTypeId == branchtype && x.Phone == phone.Trim() select x; if (checkPhone.Count() > 0) { ok = false; mess = "Đã tồn tại số điện thoại " + phone.Trim(); } else { var u = new tMember(); u.MemberCode = phone.Replace(" ", ""); u.MemberName = name; u.Phone = phone; u.Password = cls.Encrypt(phone.Trim().Replace(" ", "")); u.Email = email.Trim(); u.Address = add; u.Note = note; u.Sex = sex == "1"; if (birthday != "") { u.Birthday = DateTime.Parse(cls.returnDatetime(birthday)); } u.BranchTypeId = branchtype; u.CreateAt = DateTime.Now; u.JoinCreateAt = DateTime.Now; u.Status = 1; u.CreateBy = WindowsFormsApplication3.Form1.user_id; db.tMembers.InsertOnSubmit(u); db.SubmitChanges(); ok = true; } } catch (Exception ax) { ok = false; mess = ax.Message; } return(ok); }
public ActionResult ShopCart(tMember member) { if (Session["Member"] == null) { return(RedirectToAction("Login")); } string userName = (Session["Member"] as tMember).userName; var orderDetails = db.tOrderDetails.Where(m => m.userName == userName && m.isApprove == "否").ToList(); var buyAmount = db.tOrderDetails.Where(m => m.isApprove == "否" && m.userName == userName).ToList(); foreach (var item in buyAmount) { total += (int)item.pQty; } Session["Total"] = total; return(View("ShopCart", "_LayoutContent", orderDetails)); }
//更改密碼 public string ChangePassword(string email, string password, string newPassword) { CRegisterModel p = getAccount(email); //確認舊密碼的正確性 if (passwordCheck(p, password)) { p.txtPassword = newPassword; tMember t = db.tMember.FirstOrDefault(k => k.f會員密碼 == p.txtPassword); db.tMember.Add(t); db.SaveChanges(); return("密碼修改成功"); } else { return("原密碼輸入錯誤"); } }
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")); }
protected void Page_Load(object sender, EventArgs e) { tMember mb = Session[CDKey.LOGINUSER] as tMember; if (Page.IsPostBack == false) { var in3Services = from c in db.tCalendar join s in db.tServices on c.fIdServices equals s.fIdServices where c.fIdMember == id && c.fDate < DateTime.Now.Date select new { finName = s.fName, finDate = c.fDate.Value.Month.ToString() + "月" + c.fDate.Value.Day.ToString() + "日", fidSer = s.fIdServices }; DllOverTime.DataSource = in3Services; DllOverTime.DataBind(); var disc = (from d in db.tDiscussion where d.fIdMember == id orderby d.fSendTime descending select new { ftitle = d.fTitle, ftime = d.fSendTime }).Take(3); DLDis.DataSource = disc; DLDis.DataBind(); var discR = (from r in db.tDiscussionReply join d in db.tDiscussion on r.tMember equals d.tMember where r.fIdMember == id orderby r.fSendTime descending select new { ftitle = d.fTitle, ftime = r.fSendTime }).Take(3); DLDisR.DataSource = discR; DLDisR.DataBind(); } }
protected void btnUpDate_Click(object sender, ImageClickEventArgs e) { tStores x = db.tStores.FirstOrDefault(t => t.fIdStores == id); tMember x2 = db.tMember.First(t => t.fIdMember == id); if (x2 != null && x != null) { x2.fAddress = txtAddress.Text; x2.fEmail = txtEmail.Text; x2.fPhone = txtPhone.Text; x2.fName = txtStore.Text; x.fDescription = txtDescription.Text; x.fMobilePhone = txtMobilePhone.Text; db.SubmitChanges(); Response.Write("<script>alert('更新成功');</script>"); } }
public string GetDateLimit(int act_id) { if (Session["member"] != null) { tMember loginMember = (tMember)Session["member"]; var realMember = db.tMember.Where(t => t.f會員編號 == loginMember.f會員編號).FirstOrDefault(); if (!string.IsNullOrEmpty(realMember.f會員已占用時間)) { string[] timeList = realMember.f會員已占用時間.Split(','); //act_id!=0,表示是編輯模式,要先移除該筆活動的占用時間才符合時間限制條件 if (act_id != 0) { var targetAct = db.tActivity.Where(t => t.f活動編號 == act_id).FirstOrDefault(); timeList = timeList.Where(t => t != targetAct.f活動開始時間 + "~" + targetAct.f活動結束時間).ToArray(); } //若無,則為一般開團,直接回傳已佔用的時間陣列 //string totalTime = "["; string totalTime = ""; foreach (string item in timeList) { if (string.IsNullOrEmpty(item)) { continue; } string[] timeRange = item.Split('~'); double limit = Convert.ToInt32((Convert.ToDateTime(timeRange[1]) - Convert.ToDateTime(timeRange[0])) .ToString("dd")); for (double i = 0.0; i <= limit; i++) { totalTime += Convert.ToDateTime(timeRange[0]).AddDays(i).ToString("yyyy-MM-dd") + ","; } } if (totalTime.Length > 2) { totalTime = totalTime.Substring(0, totalTime.Length - 1); } //totalTime += "]"; return(totalTime); } } return(null); }
public long SaveMember(tMember tMember) { mmEntities.tMembers.AddOrUpdate(tMember); mmEntities.SaveChanges(); return tMember.MemberId; }