public string AddUser(UserModel user)
{
string status = "";
string query = "select max(user_id) from users";
DataTable dt1 = new DataTable();
SQLiteCommand cmd;
try
{
dbConn.Open();
if (IsNewUser(user.Email))
{
using (cmd = new SQLiteCommand(query, dbConn))
{
using (SQLiteDataReader dr = cmd.ExecuteReader())
{
dt1.Load(dr);
// Calculate new user_id
user.UserId = Convert.ToInt32(dt1.Rows[0].ItemArray[0].ToString()) + 1;
}
}
query = "insert into users values (" + user.UserId + ", '" + user.Type.ToString() +
"', '" + user.Email + "', '" + user.Password + "', '" + user.Status.ToString() + "', '" + user.FirstName + "', '" + user.LastName + "')";
cmd = new SQLiteCommand(query, dbConn);
cmd.ExecuteNonQuery();
status = "User information has been sent to administrators for approval";
}
else
{
status = "The given email address is already in use by another user";
}
dbConn.Close();
}
catch (SQLiteException ex)
{
Console.Write(ex.ToString());
status = ex.ToString();
dbConn.Close();
}
return status;
}
public ActionResult Register(RegisterViewModel model)
{
if (!ModelState.IsValid)
{
return View(model);
}
UserModel userModel = new UserModel(model);
string status = userModel.AddUser();
ViewData["StatusMessage"] = status;
model.PopulateUserTypes();
return View(model);
//if (ModelState.IsValid)
//{
// var user = new ApplicationUser { UserName = model.Email, Email = model.Email };
// var result = await UserManager.CreateAsync(user, model.Password);
// if (result.Succeeded)
// {
// await SignInManager.SignInAsync(user, isPersistent:false, rememberBrowser:false);
// // For more information on how to enable account confirmation and password reset please visit http://go.microsoft.com/fwlink/?LinkID=320771
// // Send an email with this link
// // string code = await UserManager.GenerateEmailConfirmationTokenAsync(user.Id);
// // var callbackUrl = Url.Action("ConfirmEmail", "Account", new { userId = user.Id, code = code }, protocol: Request.Url.Scheme);
// // await UserManager.SendEmailAsync(user.Id, "Confirm your account", "Please confirm your account by clicking <a href=\"" + callbackUrl + "\">here</a>");
// return RedirectToAction("Index", "Home");
// }
// AddErrors(result);
//}
//// If we got this far, something failed, redisplay form
//return View(model);
}
public List<UserModel> GetUsers()
{
string query;
SQLiteCommand cmd;
UserModel userModel;
List<UserModel> Users = new List<UserModel>();
try
{
dbConn.Open();
query = "select * from users";
DataTable dt = new DataTable();
using (cmd = new SQLiteCommand(query, dbConn))
{
using (SQLiteDataReader dr = cmd.ExecuteReader())
{
// Load the reader data into the DataTable
dt.Load(dr);
// While there are rows in the returned data create EventModels and add them to the EventModel list
for (int i = 0; i < dt.Rows.Count; i++)
{
userModel = new UserModel(dt.Rows[i]);
Users.Add(userModel);
}
}
}
dbConn.Close();
}
catch (SQLiteException ex)
{
Console.Write(ex.ToString());
dbConn.Close();
}
return Users;
}