public ActionResult ExternalLoginConfirmation(RegisterExternalLoginModel model, string returnUrl)
{
string provider = null;
string providerUserId = null;
if (User.Identity.IsAuthenticated || !OAuthWebSecurity.TryDeserializeProviderUserId(model.ExternalLoginData, out provider, out providerUserId))
{
return(RedirectToAction("Manage"));
}
if (ModelState.IsValid)
{
// Insert a new user into the database
using (SurveyEntities db = new SurveyEntities())
{
UserProfile user = db.UserProfiles.FirstOrDefault(u => u.UserName.ToLower() == model.UserName.ToLower());
// Check if user already exists
if (user == null)
{
// Insert name into the profile table
db.UserProfiles.Add(new UserProfile {
UserName = model.UserName
});
db.SaveChanges();
OAuthWebSecurity.CreateOrUpdateAccount(provider, providerUserId, model.UserName);
OAuthWebSecurity.Login(provider, providerUserId, createPersistentCookie: false);
return(RedirectToLocal(returnUrl));
}
else
{
ModelState.AddModelError("UserName", "User name already exists. Please enter a different user name.");
}
}
}
ViewBag.ProviderDisplayName = OAuthWebSecurity.GetOAuthClientData(provider).DisplayName;
ViewBag.ReturnUrl = returnUrl;
return(View(model));
}
public ActionResult ResetPassword(string id)
{
//varify reset password link
//rediecrt to reset password page
//find account accociadted with the link
//check the uniquecode from db
using (SurveyEntities db = new SurveyEntities())
{
var user = db.Users.Where(a => a.ResetPassword == id).FirstOrDefault(); //find the account associated with this id
if (user != null) //id is reset password code and we match it with the db reset pass code and if found user associated with this id
{
ResetPasswordModel mod = new ResetPasswordModel();
mod.ResetCode = id; //so valide id when submit rest password form
return(View(mod)); // here code for the user can see the rset password view
}
else
{
return(HttpNotFound());// error for invalid link
}
}
}
public void InsertTest()
{
using (SurveyEntities dc = new SurveyEntities())
{
//get a question and answer
tblAnswer answer = dc.tblAnswers.FirstOrDefault(a => a.Text == "Kelly Kapoor");
tblQuestion question = dc.tblQuestions.FirstOrDefault(r => r.Text == "Who sprouts mung beans in their desk drawers?");
//set properties
tblResponse response = new tblResponse();
response.Id = Guid.NewGuid();
response.QuestionId = question.Id;
response.AnswerId = answer.Id;
dc.tblResponses.Add(response);
int results = dc.SaveChanges();
Assert.IsTrue(results > 0);
}
}
public static List <Answer> Load()
{
try
{
List <Answer> answers = new List <Answer>();
using (SurveyEntities dc = new SurveyEntities())
{
dc.tblAnswers
.ToList()
.ForEach(a => answers.Add(new Answer
{
Id = a.Id,
Text = a.Answer
}));
}
return(answers);
}
catch (Exception ex)
{
throw ex;
}
}
//varify account
public ActionResult VarifyAccount(string id)
{
bool Status = false;
using (SurveyEntities db = new SurveyEntities())
{
db.Configuration.ValidateOnSaveEnabled = false;//avoid conform password not match save changes
var v = db.Users.Where(a => a.ActivationCode == new Guid(id).ToString()).FirstOrDefault();
if (v != null)
{
v.IsEmailVarify = true;
db.SaveChanges();
Status = true;
}
else
{
ViewBag.Message = "Invlid Request";
}
}
ViewBag.Status = Status;
return(View());
}
public SimpleMembershipInitializer()
{
Database.SetInitializer <SurveyEntities>(null);
try
{
using (var context = new SurveyEntities())
{
if (!context.Database.Exists())
{
// Create the SimpleMembership database without Entity Framework migration schema
((IObjectContextAdapter)context).ObjectContext.CreateDatabase();
}
}
WebSecurity.InitializeDatabaseConnection("SurveyEntities", "UserProfile", "UserId", "UserName", autoCreateTables: true);
}
catch (Exception ex)
{
throw new InvalidOperationException("The ASP.NET Simple Membership database could not be initialized. For more information, please see http://go.microsoft.com/fwlink/?LinkId=256588", ex);
}
}
public void LoadQuestions()
{
try
{
using (SurveyEntities dc = new SurveyEntities())
{
//Foreach question in the database question q new question and add it to the question list
dc.tblQuestions.OrderBy(q => q.Text).ToList().ForEach(q => this.Add(new Question {
Id = q.Id, Text = q.Text
}));
foreach (Question q in this)
{
q.LoadAnswers();
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public static Question LoadByActivationCode(string code)
{
using (SurveyEntities dc = new SurveyEntities())
{
try
{
var join =
from q in dc.tblQuestions
join a in dc.tblActivations
on q.Id equals a.QuestionId
where a.ActivationCode == code
select new { Id = q.Id };
Question question = LoadById(join.FirstOrDefault().Id);
question.Answers = AnswerManager.Load(question.Id);
return(LoadById(join.FirstOrDefault().Id));
}
catch (Exception ex)
{
throw ex;
}
}
}
public int Update()
{
try
{
using (SurveyEntities dc = new SurveyEntities())
{
//If the Id is set, get the result in the table where it matches
if (this.Id != Guid.Empty)
{
tblActivation activation = dc.tblActivations.Where(a => a.Id == this.Id).FirstOrDefault();
//If a row was retrieved, change
if (activation != null)
{
activation.ActivationCode = this.ActivationCode;
activation.EndDate = this.EndDate;
activation.StartDate = this.StartDate;
activation.QuestionId = this.QuestionId;
return(dc.SaveChanges());
}
else
{
throw new Exception("Could not find Activation row with this ID");
}
}
else
{
throw new Exception("Id not set on Activation");
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public void LoadQuestionById()
{
try
{
using (SurveyEntities dc = new SurveyEntities())
{
//If the Id is set, get the result in the table where it matches
if (this.Id != Guid.Empty)
{
tblQuestion question = dc.tblQuestions.FirstOrDefault(q => q.Id == this.Id);
//If q row was retrieved, change
if (question != null)
{
this.Id = question.Id;
this.Text = question.Text;
//Load the answers
this.LoadAnswers();
}
else
{
throw new Exception("Could not find Question row with this ID");
}
}
else
{
throw new Exception("Id not set on Question");
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public static int Update(Activation activation, bool rollback = false)
{
try
{
using (SurveyEntities dc = new SurveyEntities())
{
DbContextTransaction transaction = null;
if (rollback)
{
transaction = dc.Database.BeginTransaction();
}
tblActivation updaterow = dc.tblActivations.FirstOrDefault(q => q.Id == activation.Id);
if (updaterow != null)
{
updaterow.QuestionId = activation.QuestionId;
updaterow.StartDate = activation.StartDate;
updaterow.EndDate = activation.EndDate;
updaterow.ActivationCode = activation.ActivationCode;
}
else
{
throw new Exception("Row was not found");
}
if (rollback)
{
transaction.Rollback();
}
return(dc.SaveChanges());
}
}
catch (Exception ex)
{
throw ex;
}
}
public static Activation GetActivation(Guid questionId)
{
try
{
using (SurveyEntities dc = new SurveyEntities())
{
tblActivation row = new tblActivation();
row = dc.tblActivations.FirstOrDefault(q => q.QuestionId == questionId);
if (row == null)
{
return(null);
}
Activation activation = new Activation {
Id = row.Id, QuestionId = row.QuestionId, StartDate = row.StartDate, EndDate = row.EndDate, ActivationCode = row.ActivationCode
};
return(activation);
}
}
catch (Exception ex)
{
throw ex;
}
}
public static List <Question> Load()
{
try
{
List <Question> questions = new List <Question>();
using (SurveyEntities dc = new SurveyEntities())
{
dc.tblQuestions
.ToList()
.ForEach(q => questions.Add(new Question
{
Id = q.Id,
Text = q.Question,
Answers = AnswerManager.Load(q.Id),
Activator = ActivationManager.GetActivation(q.Id)
}));
}
return(questions);
}
catch (Exception ex)
{
throw ex;
}
}
// GET: Base
public BaseController()
{
db = new SurveyEntities();
}
public SurveyEntities Init()
{
return dbContext ?? (dbContext = new SurveyEntities());
}
public ContractController(SurveyEntities _db, IPropertiesRepo repo)
{
this.db = _db;
this.PropertiesRepo = repo;
}
public UnitOfWork()
{
_context = new SurveyEntities();
}
//contructor
public GenericType(SurveyEntities context)
{
Context = context;
Dbset = context.Set <TEntity>();
}
