public void saveforgotpasswordattribute(string userName, int questionid, int question2id, int question3id, string hintanswer1, string hintanswer2, string hintanswer3) { using (aicpdataEntities db = new aicpdataEntities()) { var userData = db.users.Where(x => string.Equals(x.UserName, userName) && x.questionid == questionid /*&& x.hintquestion2id == question2id && x.hintquestion3id == question3id && string.Equals(x.hintanswer, hintanswer1) && string.Equals(x.hintanswer, hintanswer2) && string.Equals(x.hintanswer, hintanswer3)*/).FirstOrDefault(); userData.IsForgotPassword = true; db.SaveChanges(); } }
public void RecoverDataattribute(string password, int id) { using (aicpdataEntities db = new aicpdataEntities()) { var data = db.users.Where(x => x.UserID == id).FirstOrDefault(); data.Password = password; // var data1 = db.users.Where(x => string.Equals(x.Password, password) && x.Password == confirmpassword).FirstOrDefault(); // var data1= db.users.Where(x => (x.Password.Equals(password) && x.Password.Equals(confirmpassword))).FirstOrDefault(); //var usres = db.users; //var test2 = db.users.FirstOrDefault(); //var test1 = db.users.FirstOrDefault(x => x.Password == password); //var data1= db.users.FirstOrDefault(x => x.Password == password && x.Password == confirmpassword) ; // db.users.Add(data1); //objModel.objUserInitials.UserName = data.FirstName + " " + (!string.IsNullOrEmpty(data.MiddleName) ? data.MiddleName : string.Empty) + " " + data.LastName; // return data; // data.IsForgotPassword = true; // db.Entry(password).CurrentValues.SetValues(confirmpassword); db.SaveChanges(); } }
public void editprofileDAL(int id, string firstname, string lastname, string middlename, string emailid, string address1, string address2, string city, string state, string cntry) { using (aicpdataEntities db = new aicpdataEntities()) { var data = db.userdetails.Where(x => x.UserID == id).FirstOrDefault(); data.FirstName = firstname; data.LastName = lastname; data.MiddleName = middlename; data.EmailID = emailid; //data.Zipcode = Convert.ToInt32(zipcode); //data.MobileContact =Convert.ToInt32( mcontact); data.Address1 = address1; data.Address2 = address2; data.City = city; data.State = state; data.Country = cntry; //data.WorkContact = wcontact; //data.category = catgory; //data.subcategory = scategory; // data.Password = password; // var data1 = db.users.Where(x => string.Equals(x.Password, password) && x.Password == confirmpassword).FirstOrDefault(); // var data1= db.users.Where(x => (x.Password.Equals(password) && x.Password.Equals(confirmpassword))).FirstOrDefault(); //var usres = db.users; //var test2 = db.users.FirstOrDefault(); //var test1 = db.users.FirstOrDefault(x => x.Password == password); //var data1= db.users.FirstOrDefault(x => x.Password == password && x.Password == confirmpassword) ; // db.users.Add(data1); //objModel.objUserInitials.UserName = data.FirstName + " " + (!string.IsNullOrEmpty(data.MiddleName) ? data.MiddleName : string.Empty) + " " + data.LastName; // return data; // data.IsForgotPassword = true; // db.Entry(password).CurrentValues.SetValues(confirmpassword); db.SaveChanges(); } }
public void CreateNewUser(userdetail userDetail, user user) { // string resultMessage = "successfully created user record"; // var x = (AICPDAL.ViewModel.UserVM) userDetails; //var userInformation = userDetails; using (aicpdataEntities db = new aicpdataEntities()) { //user userInfoNew = new user(); //userInfo.UserID = user.UserID; //userInfoNew.UserName = user.UserName; //userInfoNew.Password = user.Password; //userInfoNew.questionid = user.questionid; //userInfoNew.hintanswer = user.hintanswer; //userInfoNew.createddate = System.DateTime.Now; //userInfoNew.modifieddate = System.DateTime.Now; //userInfoNew.IsForgotPassword = false; //userInfoNew.hintquestion2id = user.hintquestion2id; //userInfoNew.hintanswer2 = user.hintanswer2; //userInfoNew.hintquestion3id = user.hintquestion3id; //userInfoNew.hintanswer3 = user.hintanswer3; //userInfoNew.UserName = user.UserName; db.users.Add(user); db.SaveChanges(); userDetail.UserID = user.UserID; //userdetail userDetailInfo = new userdetail(); //userDetailInfo.UserID = user.UserID; //userDetailInfo.Address1 = userDetail.Address1; //userDetailInfo.Address2 = userDetail.Address2; //// userDetail.category = "software"; //userDetailInfo.categoryid = userDetail.categoryid; //userDetailInfo.City = userDetail.City; //userDetailInfo.companyname = userDetail.companyname; //userDetailInfo.Country = userDetail.Country; //userDetailInfo.createddate = System.DateTime.Now; //userDetailInfo.EmailID = userDetail.EmailID; //userDetailInfo.FirstName = userDetail.FirstName; //userDetailInfo.LastName = userDetail.LastName; //userDetailInfo.MiddleName = userDetail.MiddleName; //userDetailInfo.MobileContact = userDetail.MobileContact; //userDetailInfo.State = userDetail.State; //userDetailInfo.subcategoryid = userDetail.subcategoryid; //userDetailInfo.Zipcode = userDetail.Zipcode; //userDetailInfo.WorkContact = userDetail.WorkContact; //userDetailInfo.MobileContact = userDetail.MobileContact; // userDetail.FirstName = userDetails. db.userdetails.Add(userDetail); db.SaveChanges(); } // public SelectList GetResumeGuideLines() //{ // using (aicpdataEntities db = new aicpdataEntities()) // { // var guidelines = db.resumeguidelines.Select(x => x.Guideline).ToList(); // //ViewBag.ResumeGuideLines = guidelines; // return guidelines; // } }