internal MEMBER GetById(int id) { MEMBER member = new MEMBER(); using (con = new SqlConnection(connectionString)) { string sqlQuery = @"SELECT TMEMBER.*, TSTATE.NAME AS STATE_NAME FROM TMEMBER INNER JOIN TSTATE ON TSTATE.ID = TMEMBER.STATE_ID WHERE TMEMBER.ID=@ID"; using (SqlCommand cmd = new SqlCommand(sqlQuery, con)) { con.Open(); cmd.Parameters.AddWithValue("@ID", id); SqlDataReader reader = cmd.ExecuteReader(); if (reader.Read()) { member.ID = (int)reader["ID"]; member.NAME = (string)reader["NAME"]; member.TITLE = (string)reader["TITLE"]; member.DESCRIPTION = (string)reader["DESCRIPTION"]; member.IMAGE = (string)reader["IMAGE"]; member.TWITTER = (string)reader["TWITTER"]; member.INSTAGRAM = (string)reader["INSTAGRAM"]; member.FACEBOOK = (string)reader["FACEBOOK"]; member.STATE_ID = (int)reader["STATE_ID"]; member.STATE_NAME = (string)reader["STATE_NAME"]; } con.Close(); } } return(member); }
internal void Insert(MEMBER member) { using (con = new SqlConnection(connectionString)) { string sqlQuery = $@"INSERT INTO TMEMBER (NAME, TITLE, DESCRIPTION, IMAGE, TWITTER, INSTAGRAM, FACEBOOK, STATE_ID) VALUES (@NAME, @TITLE, @DESCRIPTION, @IMAGE, @TWITTER, @INSTAGRAM, @FACEBOOK, @STATE_ID)"; using (SqlCommand cmd = new SqlCommand(sqlQuery, con)) { con.Open(); cmd.Parameters.AddWithValue("@NAME", member.NAME); cmd.Parameters.AddWithValue("@TITLE", member.TITLE); cmd.Parameters.AddWithValue("@DESCRIPTION", member.DESCRIPTION); cmd.Parameters.AddWithValue("@IMAGE", member.IMAGE); cmd.Parameters.AddWithValue("@TWITTER", member.TWITTER); cmd.Parameters.AddWithValue("@INSTAGRAM", member.INSTAGRAM); cmd.Parameters.AddWithValue("@FACEBOOK", member.FACEBOOK); cmd.Parameters.AddWithValue("@STATE_ID", member.STATE_ID); cmd.ExecuteNonQuery(); con.Close(); } } }
internal void Update(MEMBER member) { using (con = new SqlConnection(connectionString)) { string sqlQuery = $@"UPDATE TMEMBER SET NAME=@NAME, TITLE=@TITLE, DESCRIPTION=@DESCRIPTION, IMAGE=@IMAGE, TWITTER=@TWITTER, INSTAGRAM=@INSTAGRAM, FACEBOOK=@FACEBOOK, STATE_ID=@STATE_ID WHERE TMEMBER.ID = @ID"; using (SqlCommand cmd = new SqlCommand(sqlQuery, con)) { con.Open(); cmd.Parameters.AddWithValue("@NAME", member.NAME); cmd.Parameters.AddWithValue("@TITLE", member.TITLE); cmd.Parameters.AddWithValue("@DESCRIPTION", member.DESCRIPTION); cmd.Parameters.AddWithValue("@IMAGE", member.IMAGE); cmd.Parameters.AddWithValue("@TWITTER", member.TWITTER); cmd.Parameters.AddWithValue("@INSTAGRAM", member.INSTAGRAM); cmd.Parameters.AddWithValue("@FACEBOOK", member.FACEBOOK); cmd.Parameters.AddWithValue("@STATE_ID", member.STATE_ID); cmd.Parameters.AddWithValue("@ID", member.ID); cmd.ExecuteNonQuery(); con.Close(); } } }
public ActionResult MemberCreate(MemberCreateModel fc) { try { MEMBER newMember = new MEMBER(); newMember.FNAME = fc.FName; newMember.LNAME = fc.LName; newMember.AGENCY_ID = fc.Agency_ID; newMember.PHONE = fc.Phone; newMember.EMAIL = fc.Email; newMember.RSSFEED = fc.RSS_Feed; newMember.EMERGENCY_CONTACT_NAME = fc.Emergency_ContactName; newMember.EMERGENCY_CONTACT_PHONE = fc.Emergency_ContactPhone; newMember.ROLE_ID = fc.Role_ID; newMember.USERNAME = fc.UserName; STNServiceCaller serviceCaller = STNServiceCaller.Instance; var request = new RestRequest(Method.POST); request.Resource = "Members/{pass}/addMember"; request.AddParameter("pass", fc.Password, ParameterType.UrlSegment); request.RequestFormat = DataFormat.Xml; request.AddHeader("Content-Type", "application/xml"); STNWebSerializer serializer = new STNWebSerializer(); request.AddParameter("application/xml", serializer.Serialize <MEMBER>(newMember), ParameterType.RequestBody); MEMBER createdMember = serviceCaller.Execute <MEMBER>(request); return(RedirectToAction("MemberDE", new { id = createdMember.MEMBER_ID })); } catch (Exception e) { return(View("../Shared/Error", e)); } }
public bool UpdateMember(MEMBER member) { string sql = @"sp_member_UPDATE"; string sql_phone = @"sp_memAndPhone_UPDATE"; string sql_del = @"sp_memAndPhone_DELETE"; using (TransactionScope ts = new TransactionScope()) { object[] obj_mem = { "@MFname", member.MFname, "@MLname", member.MLname, "@MAddress", member.MAddress, "@MSex", member.MSex, "@MemID", member.MemID }; Db.Update(sql, obj_mem); object[] obj_del = { "@MemID", member.MemID }; Db.Delete(sql_del, obj_del); if (member.MEMBER_PHONE.Count == 0) { return(false); } else { foreach (var ls in member.MEMBER_PHONE) { object[] obj = { "@MemID", member.MemID, "@Phone", ls.Phone }; try { Db.Insert(sql_phone, obj); } catch { return(false); } } } ts.Complete(); return(true); } }
/// <summary> /// /// </summary> /// <param name="emp"></param> /// <returns></returns> public int Create(MEMBER obj) { try { Guid userGuid = System.Guid.NewGuid(); byte[] dataAndGuid = ASCIIEncoding.ASCII.GetBytes(obj.mempwd + userGuid.ToString()); SHA512 sha512 = new SHA512CryptoServiceProvider(); string resultSha512 = Convert.ToBase64String(sha512.ComputeHash(dataAndGuid)); //obj.mempwd = resultSha512; obj.memguid = userGuid.ToString(); obj.FAVORITESHOPLIST = null; obj.MEMBERLIST = null; using (AllShowEntities db = new AllShowEntities()) { db.MEMBER.Add(obj); db.SaveChanges(); return(obj.memno);//db.SaveChanges(); } } catch (DbEntityValidationException) { throw; } catch (Exception) { throw; } }
private MEMBER ReadMember(DbDataReader dataReader) { if (dataReader == null || dataReader["ID"] == null) { return(null); } var output = new MEMBER(); for (var i = 0; i < dataReader.FieldCount; i++) { string fieldName = dataReader.GetName(i).ToUpper(); switch (fieldName) { case "ID": int intValue; if (int.TryParse(dataReader[fieldName]?.ToString(), out intValue)) { output.GetType().GetProperty(fieldName).SetValue(output, intValue, null); } break; case "NAME": output.GetType().GetProperty(fieldName).SetValue(output, dataReader[fieldName]?.ToString(), null); break; default: break; } } return(output); }
public bool SP_InsertFriendship(MEMBER member1, MEMBER member2) { bool output = false; DbNonQueryResponse dbData = null; string methodName = MethodBase.GetCurrentMethod().GetName(); var sw = Stopwatch.StartNew(); try { string commandText = $"CALL SP_INSERT_FRIENDSHIP({member1.ID}, {member2.ID});"; dbData = this._dbContext.ExecuteNonQuery(commandText, null, $"{methodName}"); if (dbData?.Success ?? false) { output = true; } return(output); } catch (Exception ex) { LogEngine.MemberLogger.WriteToLog(LogLevels.Error, $"DAL.Exception: {JsonConvert.SerializeObject(ex)}"); return(output = false); } finally { sw.Stop(); LogEngine.MemberLogger.WriteToLog(LogLevels.Debug, $"DAL.{methodName}(AFFECTED_ROWS={dbData?.AffectedRows ?? 0}) in {sw.ElapsedMilliseconds}ms"); } }
//call for who the member logged in is private string GetLoggedInMember() { STNServiceCaller serviceCaller = STNServiceCaller.Instance; var request = new RestRequest(); request.Resource = "/Members?username={userName}"; request.RootElement = "Member"; request.AddParameter("userName", User.Identity.Name, ParameterType.UrlSegment); MEMBER thisMember = serviceCaller.Execute <MEMBER>(request); int loggedInMember = Convert.ToInt32(thisMember.ROLE_ID); string Role = string.Empty; switch (loggedInMember) { case 1: Role = "Admin"; break; case 2: Role = "Manager"; break; case 3: Role = "Field"; break; default: Role = "error"; break; } return(Role); }
public ActionResult DeleteMember(int id) { MEMBER member = memberDA.GetById(id); try { if (ModelState.IsValid) { memberDA.Delete(id); if (System.IO.File.Exists(Server.MapPath("~/Content/images/members/" + member.IMAGE))) { System.IO.File.Delete(Server.MapPath("~/Content/images/members/" + member.IMAGE)); } return(RedirectToAction("Members", "Admin")); } else { ViewBag.Error = "Try Again."; return(View("MemberDelete", member)); } } catch (Exception ex) { ViewBag.Error = "Try Again."; return(View("MemberDelete", member)); } }
private void EditMemberButton_Click(object sender, RoutedEventArgs e) { Button editMemberButton = sender as Button; MEMBER editMember = editMemberButton.Tag as MEMBER; HomeScreen.GetHomeScreenInstance().GetDialogs("MemberAddDialog", editMember, "Xem/Chỉnh sửa Thành viên"); }
public ActionResult SetPassWord(RePassword rePassword) { if (ModelState.IsValid) { IQueryable <Models.MEMBER> querySql = from d in db.MEMBERS where d.MEMBERNAME == User.Identity.Name select d; List <Models.MEMBER> query = querySql.ToList(); MEMBER member = query.First(); if (member.PASSWORDS != rePassword.OldPassword) { ModelState.AddModelError("OldPassword", "密码错误"); } else { db.Database.ExecuteSqlCommand("update MEMBERS set PASSWORDS='" + rePassword.NewPassword + "' where MEMBERNAME='" + member.MEMBERNAME + "'"); db.SaveChanges(); AuthenticationManager.SignOut(DefaultAuthenticationTypes.ApplicationCookie); for (int i = 0; i < this.Request.Cookies.Count; i++) { this.Response.Cookies[this.Request.Cookies[i].Name].Expires = DateTime.Now.AddDays(-1); } return(Content("<script>alert('更改成功,请重新登录!');window.location.href='/Home/MainPage';</script>")); } } return(View(rePassword)); }
public ActionResult Validate([Bind(Include = "CellPhone")] MEMBER member) { var numberPhone = member.CellPhone; var data = _db.MEMBERs.Where(s => s.CellPhone.Equals(numberPhone)).ToList(); if (data.Any()) { _id = data.FirstOrDefault().AccountID; System.Diagnostics.Debug.WriteLine("MY ID IS" + _id); Session["Acc"] = data.FirstOrDefault().AccountID; return(RedirectToAction("OTP")); } else { ViewBag.error = "Account not found"; return(RedirectToAction("Login")); } }
public JsonResult Save(int?id, string data, bool isadd) { if (isadd == true) { JavaScriptSerializer serialzer = new JavaScriptSerializer(); MEMBER member = serialzer.Deserialize <MEMBER>(data); member.MATKHAU = md5(member.MATKHAU); _connect.MEMBERs.Add(member); _connect.SaveChanges(); } else { MEMBER mb = _connect.MEMBERs.SingleOrDefault(p => p.ID == id); JavaScriptSerializer serialzer = new JavaScriptSerializer(); MEMBER members = serialzer.Deserialize <MEMBER>(data); mb.TEN = members.TEN; mb.MATKHAU = md5(members.MATKHAU); mb.ANH = members.ANH; mb.EMAIL = members.EMAIL; mb.QUYEN = members.QUYEN; mb.SDT = members.SDT; mb.STATUS = members.STATUS; _connect.SaveChanges(); } return(Json(new { status = true }, JsonRequestBehavior.AllowGet)); }
protected void BtnLogin_Click(object sender, EventArgs e) { MEMBER user = GetMemberByLoginname(User_Name.Text, Password1.Text); if (user != null) { CURRENTMEMBER = user; IsUser = CURRENTMEMBER.TYPEMEMBERID == 1; IsDepartmentEmployee = CURRENTMEMBER.TYPEMEMBERID == 2; IsFirmResponsible = CURRENTMEMBER.TYPEMEMBERID == 3; IsAdmin = CURRENTMEMBER.TYPEMEMBERID == 4; if (txt_Checkbox.Checked)//Beni unutma kısmında ki checkedbox'ın işaretli olup olmadığına baktık. { Response.Cookies["Reservastion-user"].Value = CURRENTMEMBER.ID.ToString(); Response.Cookies["Reservastion-user"].Expires = DateTime.Now.AddDays(365); } else { Response.Cookies["Reservastion-user"].Expires = DateTime.Now.AddDays(-1); } Response.Redirect("/Default.aspx"); } else { MessageBox("Giriş Başarısız."); } }
protected void btnSave_Click(object sender, EventArgs e) { if (ValidateNewPassword()) { MEMBER mem = DALMember.GetByID(MEMBERID); if (mem != null) { if (mem.ISACTIVE) { mem.PASSWORD = Functions.MD5(txtPasword.Text); mem.PASSWORDRESETCODE = Guid.NewGuid().ToString(); DALMember.Update(mem); Functions.SetLoginUser(ONLINEUSER, mem); DALMailQueue.SendPasswordMail(mem.EMAIL, mem.FULLNAME, txtPasword.Text); Response.Redirect("/AdminMainPage?Reset=" + mem.PASSWORDRESETCODE + ""); } else { NotificationAdd(NotificationType.error, "Kullanıcınız pasif durumdadır. Sistem yöneticisi ile iletişime geciniz."); } } else { NotificationAdd(NotificationType.error, "Kayıt Bulunamadı"); } } }
//Sets Username and Password to send with request public bool setAuthentication(String username, String password) { client.Authenticator = new HttpBasicAuthenticator(username, password); //Check login RestRequest request = new RestRequest(); request.Resource = ConfigurationManager.AppSettings["STNServicesLoginEndpoint"]; request.RootElement = "boolean"; CurrentUser = _instance.Execute <MEMBER>(request); if (CurrentUser != null) { //get the role if ((CurrentUser.ROLE_ID != null) || (CurrentUser.ROLE_ID != 0)) { request = new RestRequest(); request.Resource = "/Roles/{roleId}"; request.RootElement = "ROLE"; request.AddParameter("roleId", CurrentUser.ROLE_ID, ParameterType.UrlSegment); CurrentRole = _instance.Execute <ROLE>(request); } } else { clearAuthentication(); } return(CurrentUser != null); }
public override MembershipUser GetUser(string username, bool userIsOnline) { MembershipUser memUser = null; try { if (username.Length == 0) { return(null); } STNServiceCaller serviceCaller = STNServiceCaller.Instance; var request = new RestRequest(); request.Resource = "/Members?username={userName}"; request.RootElement = "Member"; request.AddParameter("userName", username, ParameterType.UrlSegment); MEMBER thisMember = serviceCaller.Execute <MEMBER>(request); if (thisMember != null) { memUser = new MembershipUser("STNServicesMembershipProvider", thisMember.USERNAME, null, thisMember.EMAIL, string.Empty, string.Empty, true, false, DateTime.Now, DateTime.Now, DateTime.Now, DateTime.Now, DateTime.Now); } } catch { } return(memUser); }
protected void btnSaveFirmDepartmentMember_Click(object sender, EventArgs e)//Yeni çalışan ekle kısmını yaptım kayıt yapıyor seçilen kısıma.. { if (ValidateRecord()) { Guid id = Guid.NewGuid(); MEMBER member = null; using (db = new novartz_stajyer1Entities()) { member = new MEMBER { NAME = txtmdlName.Text, SURNAME = txtmdlSurname.Text, LOGINNAME = txtmdlMail.Text, BIRDDATE = Convert.ToDateTime(txtmdlBirtday.Text), PHONE = txtmdlPhone.Text, PASWORD = txtmdlPassword.Text, GENDER = Convert.ToBoolean(drpmdlGender.SelectedValue == "1"),//Bayan ise true olarak çalışıyor TYPEMEMBERID = Convert.ToByte(drpmdltypmember.SelectedValue), CANLOGIN = true, ID = id }; db.MEMBER.Add(member); db.SaveChanges(); }; if (drpmdltypmember.SelectedValue == "3") { FIRMRESPONSIBLE rsp = null; using (db = new novartz_stajyer1Entities()) { Guid id3 = Guid.NewGuid(); rsp = new FIRMRESPONSIBLE { ID = id3, FIRMID = Guid.Parse(DrpFirm.SelectedValue), MEMBERID = id }; db.FIRMRESPONSIBLE.Add(rsp); db.SaveChanges(); } } FIRMDEPARTMENTMEMBER rec = null; using (db = new novartz_stajyer1Entities()) { Guid id2 = Guid.NewGuid(); rec = new FIRMDEPARTMENTMEMBER { ID = id2, FIRMDEPARTMENTID = Guid.Parse(DrpDepartment.SelectedValue), ISACTIVE = dropmdlcd.SelectedValue == "1", MEMBERID = id }; db.FIRMDEPARTMENTMEMBER.Add(rec); db.SaveChanges(); }; MessageBox("İşleminiz Başarılı"); } }
public JsonResult Delete(int id) { MEMBER member = _connect.MEMBERs.SingleOrDefault(p => p.ID == id); _connect.MEMBERs.Remove(member); _connect.SaveChanges(); return(Json(new { status = true }, JsonRequestBehavior.AllowGet)); }
public ActionResult DeleteConfirmed(int id) { MEMBER mEMBER = db.MEMBERs.Find(id); db.MEMBERs.Remove(mEMBER); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Details(int id) { try { STNServiceCaller serviceCaller = STNServiceCaller.Instance; var request = new RestRequest(); request.Resource = "HWMs/{entityId}"; request.RootElement = "HWM"; request.AddParameter("entityId", id, ParameterType.UrlSegment); HWM aHWM = serviceCaller.Execute <HWM>(request); //see if this hwm has a peak summary or approval (field can't delete then) if (aHWM.PEAK_SUMMARY_ID.HasValue || aHWM.APPROVAL_ID.HasValue) { ViewData["ManagerOnly"] = "true"; } //get Site number request = new RestRequest(); request.Resource = "Sites/{entityId}"; request.RootElement = "SITE"; request.AddParameter("entityId", aHWM.SITE_ID, ParameterType.UrlSegment); ViewData["SiteNo"] = serviceCaller.Execute <SITE>(request).SITE_NO; //get member logged in's role request = new RestRequest(); request.Resource = "/Members?username={userName}"; request.RootElement = "MEMBER"; request.AddParameter("userName", User.Identity.Name, ParameterType.UrlSegment); MEMBER thisMember = serviceCaller.Execute <MEMBER>(request); if (thisMember.ROLE_ID == 1) { ViewData["Role"] = "Admin"; } if (thisMember.ROLE_ID == 2) { ViewData["Role"] = "Manager"; } if (thisMember.ROLE_ID == 3) { ViewData["Role"] = "Field"; } //Get peak summary info request = new RestRequest(); request.Resource = "/PeakSummaries/{entityId}"; request.RootElement = "ArrayOfPEAK_SUMMARY"; request.AddParameter("entityId", aHWM.PEAK_SUMMARY_ID, ParameterType.UrlSegment); ViewData["PeakSummary"] = serviceCaller.Execute <PEAK_SUMMARY>(request); return(View(aHWM)); } catch (Exception e) { return(View("../Shared/Error", e)); } }
private void Member_Delete_btn_Click(object sender, EventArgs e) { id = (int)(MD_Grid.CurrentRow.Cells[0].Value); MEMBER memData = data.MEMBERS.Find(id); data.MEMBERS.Remove(memData); data.SaveChanges(); load_comboBoxes(); }
public async Task <ActionResult> DeleteConfirmed(short id) { MEMBER mEMBER = await db.MEMBER.FindAsync(id); db.MEMBER.Remove(mEMBER); await db.SaveChangesAsync(); return(RedirectToAction("Index")); }
public ActionResult EditMember(MEMBER model) { if (Session["MEmail"] != null && Session["MemID"] != null) { var resolveRequest = HttpContext.Request; resolveRequest.InputStream.Seek(0, SeekOrigin.Begin); string jsonString = new StreamReader(resolveRequest.InputStream).ReadToEnd(); if (jsonString != null) { List <string> phones = new List <string>(); dynamic jArr2 = Newtonsoft.Json.JsonConvert.DeserializeObject(jsonString); try { foreach (dynamic item in jArr2) { string type = item.name.Value.ToString(); switch (type) { case "email": model.MEmail = item.value.Value; break; case "inputFName": model.MFname = item.value.Value; break; case "inputLName": model.MLname = item.value.Value; break; case "address": model.MAddress = item.value.Value; break; case "optradio": model.MSex = item.value.Value; break; case "mobilePhone[]": model.MEMBER_PHONE.Add(new MEMBER_PHONE() { Phone = item.value.Value }); break; // phones.Add(item.value.Value); break; } model.MemID = Session["MemID"].ToString(); } if (_memRepository.UpdateMember(model)) { var objUser = db.MEMBER.Where(m => m.MEmail == model.MEmail && m.MPassword == model.MPassword).FirstOrDefault(); if (objUser != null) { Session["MemID"] = objUser.MemID; Session["MEmail"] = objUser.MEmail; } return(RedirectToAction("Index", "Shipping")); } } catch { return(Json(new { success = false }, JsonRequestBehavior.AllowGet)); } } return(View()); } return(RedirectToAction("Index", "Shipping")); }
// // GET: /ObjPointsDetails/1 public ActionResult ObjPointDetails(int id) { try { STNServiceCaller serviceCaller = STNServiceCaller.Instance; var request = new RestRequest(); request.Resource = "/ObjectivePoints/{entityId}"; request.RootElement = "OBJECTIVE_POINT"; request.AddParameter("entityId", id, ParameterType.UrlSegment); OBJECTIVE_POINT anObjPoint = serviceCaller.Execute <OBJECTIVE_POINT>(request); //get any opMeasurements that have this op attached request = new RestRequest(); request.Resource = "ObjectivePoints/{objectivePointId}/OPMeasurements"; request.RootElement = "ArrayOfOP_MEASUREMENTS"; request.AddParameter("objectivePointId", id, ParameterType.UrlSegment); List <OP_MEASUREMENTS> OPopMeasList = serviceCaller.Execute <List <OP_MEASUREMENTS> >(request); if (OPopMeasList.Count >= 1) { ViewData["OPMeas_Linked"] = "true"; } request = new RestRequest(); request.Resource = "Sites/{entityId}"; request.RootElement = "SITE"; request.AddParameter("entityId", anObjPoint.SITE_ID, ParameterType.UrlSegment); ViewData["SiteNo"] = serviceCaller.Execute <SITE>(request).SITE_NO; //get member logged in's role request = new RestRequest(); request.Resource = "/Members?username={userName}"; request.RootElement = "MEMBER"; request.AddParameter("userName", User.Identity.Name, ParameterType.UrlSegment); MEMBER thisMember = serviceCaller.Execute <MEMBER>(request); if (thisMember.ROLE_ID == 1) { ViewData["Role"] = "Admin"; } if (thisMember.ROLE_ID == 2) { ViewData["Role"] = "Manager"; } if (thisMember.ROLE_ID == 3) { ViewData["Role"] = "Field"; } return(View("../ObjPoints/ObjPointDetails", anObjPoint)); } catch (Exception e) { return(View("../Shared/Error", e)); } }
public async Task <ActionResult> Create([Bind(Include = "MEMBER_ID,NATIONAL_ID,USERNAME,PASSWORD,FNAME,LNAME,SEX,BIRTH_DATE,ADDRESS,E_MAIL,PHONE,CREDIT_CARD,URL_IMG,RE_ENTER")] MEMBER mEMBER) { if (db.MEMBER.Where(a => a.USERNAME.Equals(mEMBER.USERNAME)).Count() != 0) { Response.Write("<script> alert('This username was used.')</script>"); return(View(mEMBER)); } if (db.MEMBER.Where(a => a.NATIONAL_ID.Equals(mEMBER.NATIONAL_ID)).Count() != 0) { Response.Write("<script> alert('This national id was used.')</script>"); return(View(mEMBER)); } if (mEMBER.NATIONAL_ID.ToString().Length != 13) { Response.Write("<script> alert('National ID incorrect.')</script>"); return(View(mEMBER)); } if (mEMBER.PASSWORD != mEMBER.RE_ENTER) { Response.Write("<script> alert('Password and Re-Enter not match.')</script>"); return(View(mEMBER)); } if (mEMBER.BIRTH_DATE > DateTime.Today) { Response.Write("<script> alert('Birthday incorrext.')</script>"); return(View(mEMBER)); } if (ModelState.IsValid) { mEMBER.MEMBER_ID = (short)(db.MEMBER.Count() + 1); //string[] date = mEMBER.B_DATE.Split('-'); //mEMBER.B_DATE = date[1] + '/' + date[0] + '/' + date[2]; //mEMBER.BIRTH_DATE = Convert.ToDateTime(mEMBER.B_DATE); db.MEMBER.Add(mEMBER); if (mEMBER.URL_IMG == null) { mEMBER.URL_IMG = "http://downloadicons.net/sites/default/files/user-icon-2722.png"; } Session["img"] = mEMBER.URL_IMG; db.MEMBER.Add(mEMBER); await db.SaveChangesAsync(); return(RedirectToAction("Login", "Home")); } return(View(mEMBER)); }
public ClaimsIdentity CreateIdentity(MEMBER member, string authenticationType) { ClaimsIdentity _identity = new ClaimsIdentity(DefaultAuthenticationTypes.ApplicationCookie); _identity.AddClaim(new Claim(ClaimTypes.Name, member.MEMBERNAME)); _identity.AddClaim(new Claim(ClaimTypes.NameIdentifier, member.MEMBERID)); //_identity.AddClaim(new Claim(ClaimTypes.NameIdentifier, member.PASSWORDS)); //_identity.AddClaim(new Claim("http://schemas.microsoft.com/accesscontrolservice/2010/07/claims/identityprovider", "ASP.NET Identity")); return(_identity); }
public bool MEMBERControl(string mail) { MEMBER sonuc = null; using (db = new novartz_stajyer1Entities()) { sonuc = db.MEMBER.SingleOrDefault(u => u.LOGINNAME == mail); } return(sonuc != null); }
public MEMBER GetMemberByLoginname(string loginname, string password) { MEMBER rec = null; using (db = new novartz_stajyer1Entities()) { rec = db.MEMBER.Where(a => a.LOGINNAME == loginname && a.PASWORD == password).FirstOrDefault(); } return(rec); }