public ActionResult Register(RegisterViewModel registerdata) { if (ModelState.IsValid) { //帳號是否已經存在 if (memberservice.CheckAccountExisted(registerdata.Account)) { //密碼加密 registerdata.Password = memberservice.HashPassword(registerdata.Password); //寫入會員資料表 int rowcount = memberservice.AddMember(registerdata); if (rowcount != 1) { ViewBag.Error = "新增會員失敗"; return(View()); } //查詢會員資料 MemberLoginModel logindata = memberservice.GetMemberLoginData(registerdata.Account, registerdata.Password); //會員資料寫入Session if (logindata != null) { //Session["Login"] = string.Format("{0}_{1}_{2}", logindata.Member_ID, logindata.NickName, logindata.Role); //物件序列化成JSON //Session[SessionManager.SessionKey.SessionKeyName.MemberLogin] = JsonConvert.SerializeObject(logindata); //呼叫方法寫入Session LoginSession relatedSession = new LoginSession(); relatedSession.WriteLoginSession(logindata); } if (Session[SessionManager.SessionKey.SessionKeyName.MemberLogin] != null) { //轉導頁面到留言板 return(RedirectToAction("GetMessage", "GuestBook")); } } } ViewBag.Error = "已經有此帳號,請重新輸入帳號。"; return(View()); }
//protected void CheckCity_ServerValidate(object source, ServerValidateEventArgs args) //{ // if (city.SelectedIndex == 0) // { // args.IsValid = false; // } // else // args.IsValid = true; // } //protected void CheckHobbies_ServerValidate(object source, ServerValidateEventArgs args) //{ // args.IsValid = false; // for (int i = 0; i < hobbies.Items.Count; i++) // { // if (hobbies.Items[i].Selected == true) // { // args.IsValid = true; // break; // } // } //} protected void submit_Click(object sender, EventArgs e) { // בדיקה שהאימייל לא קיים //string strFind = "SELECT COUNT(MemberFname) FROM Members WHERE MemberEmail= '" + email.Text + "'"; //object obj = Connect.GetObject(strFind); //if (int.Parse(obj.ToString()) == 0) //{ // קבלת המשתנים string MemFname = fname.Text; string MemLname = lname.Text; string MemEmail = email.Text; string MemPass = pass.Text; string MemDate = birthDate.Text; DateTime d = DateTime.Parse(MemDate); string MemGender = gender.SelectedItem.Text; int MemCity = city.SelectedIndex; string MemPhone = DdlPhoneAreaCode.SelectedItem.Text + phoneNumber.Text; string MemAddress = adress.Text; string MemHobbies = ""; for (int i = 0; i < hobbies.Items.Count; i++) { if (i != hobbies.Items.Count - 1) { MemHobbies += hobbies.Items[i].Value + ","; } } if (MemHobbies[MemHobbies.Length - 1] == ',') { MemHobbies = MemHobbies.Substring(0, MemHobbies.Length - 1); } string MemPic = ""; if (imgupld.HasFile == false) { if (MemGender == "Male") { MemPic = "~/Images/man.jpg"; } else { MemPic = "~/Images/Woman.jpg"; } } else { MemPic = "~/Images/" + imgupld.FileName; imgupld.SaveAs(Server.MapPath("images//" + imgupld.FileName)); } string MemComment = comments.Text; Members member = new Members(); member.MemberFname = MemFname; member.MemberLname = MemLname; member.MemberEmail = MemEmail; member.MemberPass = MemPass; member.MemberDate = d; member.MemberGender = MemGender; member.CityId = MemCity; member.MemberPhone = MemPhone; member.MemberAddress = MemAddress; member.MemberHobbies = MemHobbies; member.MemberPicture = MemPic; member.MemberComment = MemComment; if (!MembersService.IsEmailExist(member)) { MembersService.AddMember(member); Response.Redirect("ShowMembers.aspx"); } else { RegisterMsg.Text = "The email is already exist in the system"; } // שאילתא של הכנסת נתונים //string strSql = "INSERT INTO Members(MemberFname,MemberLname,MemberEmail,MemberPass,MemberGender,CityId,MemberAddress,MemberHobbies,MemberDate,MemberPicture,MemberPhone,MemberComment)VALUES('" + MemFname.Trim() + "','" + MemLname.Trim() + "','" + MemEmail.Trim() + "','" + MemPass.Trim() + "','" + MemGender.Trim() + "'," + MemCity + ",'" + MemAddress.Trim() + "','" + MemHobbies.Trim() + "','" + d.ToString("yyyy/MM/dd") + "','" + MemPic.Trim() + "','" + MemPhone.Trim() + "','" + MemComment.Trim() + "')"; //Connect.InsertUpdateDelete(strSql); //RegisterMsg.Text = "You registered successfully!"; //Response.Redirect("ShowMembers.aspx"); //// בניית טבלה //Table ShowMembers = new Table(); //TableRow FirstRow = new TableRow(); //TableCell FirstId = new TableCell(); //FirstId.Text = "Id"; //FirstRow.Controls.Add(FirstId); //TableCell FirstFname = new TableCell(); //FirstFname.Text = "First Name"; //FirstRow.Controls.Add(FirstFname); //TableCell FirstLname = new TableCell(); //FirstLname.Text = "Last Name"; //FirstRow.Controls.Add(FirstLname); //TableCell FirstEmail = new TableCell(); //FirstEmail.Text = "Email"; //FirstRow.Controls.Add(FirstEmail); //TableCell FirstPass = new TableCell(); //FirstPass.Text = "Pass"; //FirstRow.Controls.Add(FirstPass); //TableCell FirstGender = new TableCell(); //FirstGender.Text = "Gender"; //FirstRow.Controls.Add(FirstGender); //TableCell FirstCity = new TableCell(); //FirstCity.Text = "City"; //FirstRow.Controls.Add(FirstCity); //TableCell FirstAddress = new TableCell(); //FirstAddress.Text = "Address"; //FirstRow.Controls.Add(FirstAddress); //TableCell FirstHobbies = new TableCell(); //FirstHobbies.Text = "Hobbies"; //FirstRow.Controls.Add(FirstHobbies); //TableCell FirstDate = new TableCell(); //FirstDate.Text = "Birt hDate"; //FirstRow.Controls.Add(FirstDate); //TableCell FirstPic = new TableCell(); //FirstPic.Text = "Picture"; //FirstRow.Controls.Add(FirstPic); //TableCell FirstPhone = new TableCell(); //FirstPhone.Text = "Phone"; //FirstRow.Controls.Add(FirstPhone); ////TableCell FirstComment = new TableCell(); ////FirstComment.Text ="Comment"; ////FirstRow.Controls.Add(FirstComment); //ShowMembers.Controls.Add(FirstRow); //ShowMembers.ForeColor = Color.White; //string SqlShow = "SELECT * FROM Members"; //DataSet ds = new DataSet(); //ds = Connect.GetDataSet(SqlShow, "Members"); //for (int i = 0; i < ds.Tables["Members"].Rows.Count; i++) //{ // TableRow tr = new TableRow(); // TableCell tcId = new TableCell(); // tcId.Text = ds.Tables["Members"].Rows[i]["MemberId"].ToString(); // tr.Controls.Add(tcId); // TableCell tcFname = new TableCell(); // tcFname.Text = ds.Tables["Members"].Rows[i]["MemberFname"].ToString(); // tr.Controls.Add(tcFname); // TableCell tcLname = new TableCell(); // tcLname.Text = ds.Tables["Members"].Rows[i]["MemberLname"].ToString(); // tr.Controls.Add(tcLname); // TableCell tcEmail = new TableCell(); // tcEmail.Text = ds.Tables["Members"].Rows[i]["MemberEmail"].ToString(); // tr.Controls.Add(tcEmail); // TableCell tcPass = new TableCell(); // tcPass.Text = ds.Tables["Members"].Rows[i]["MemberPass"].ToString(); // tr.Controls.Add(tcPass); // TableCell tcGender = new TableCell(); // tcGender.Text = ds.Tables["Members"].Rows[i]["MemberGender"].ToString(); // tr.Controls.Add(tcGender); // TableCell tcCity = new TableCell(); // string SqlCity = "SELECT CityName FROM Cities WHERE CityId = " + ds.Tables["Members"].Rows[i]["CityId"] + ""; // DataSet dscity = new DataSet(); // dscity = Connect.GetDataSet(SqlCity, "Cities"); // tcCity.Text = dscity.Tables["Cities"].Rows[0]["CityName"].ToString(); // //tcCity.Text = ds.Tables["Members"].Rows[i]["CityId"].ToString(); // tr.Controls.Add(tcCity); // TableCell tcAddress = new TableCell(); // tcAddress.Text = ds.Tables["Members"].Rows[i]["MemberAddress"].ToString(); // tr.Controls.Add(tcAddress); // TableCell tcHobbies = new TableCell(); // tcHobbies.Text = ds.Tables["Members"].Rows[i]["MemberHobbies"].ToString(); // tr.Controls.Add(tcHobbies); // TableCell tcDate = new TableCell(); // tcDate.Text = ds.Tables["Members"].Rows[i]["MemberDate"].ToString(); // tr.Controls.Add(tcDate); // TableCell tcPic = new TableCell(); // tcPic.Text = ds.Tables["Members"].Rows[i]["MemberPicture"].ToString(); // tr.Controls.Add(tcPic); // TableCell tcPhone = new TableCell(); // tcPhone.Text = ds.Tables["Members"].Rows[i]["MemberPhone"].ToString(); // tr.Controls.Add(tcPhone); // //TableCell tcComment = new TableCell(); // //tcComment.Text = ds.Tables["Members"].Rows[i]["MemberComment"].ToString(); // //tr.Controls.Add(tcComment); // ShowMembers.Controls.Add(tr); //} //PnlShowMembers.Controls.Add(ShowMembers); //} //else //{ // RegisterMsg.Text = "The email is already exist in the system"; //} }