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;
// }
}
