public ActionResult Register(UAccount account)
{
if (ModelState.IsValid)
{
using (OurDbContext db = new OurDbContext())
{
db.uAccount.Add(account);
db.SaveChanges();
}
ModelState.Clear();
ViewBag.Message = account.Username + " sucessfully registered!";
}
return(View());
}
public ActionResult Login(UAccount user)
{
using (OurDbContext db = new OurDbContext())
{
var usr = db.uAccount.Where(u => u.Username == user.Username && u.Password == user.Password).FirstOrDefault();
if (usr != null)
{
Session["UserId"] = usr.UserID.ToString();
Session["Username"] = usr.Username.ToString();
return(RedirectToAction("LoggedIn"));
}
else
{
ModelState.AddModelError("", "Wrong usernae or password");
}
}
return(View());
}
public ActionResult Index(IndexViewModel Model)
{
using (SqlConnection dbConn = new SqlConnection())
{
dbConn.ConnectionString = Configuration.DB;
//dbConn.ConnectionString = ConfigurationManager.ConnectionStrings["Bloometa_DB"].ConnectionString;
dbConn.Open();
SqlCommand RetrieveAccount =
new SqlCommand(@"
SELECT TOP(20)
[AccID], [Network], [Username], [Added]
FROM UAccounts
WHERE
[Removed] = 0
ORDER BY [Added] DESC", dbConn);
using (SqlDataReader results = RetrieveAccount.ExecuteReader())
{
Model.Recent = new List <UAccount>();
if (results.HasRows)
{
while (results.Read())
{
UAccount Account = new UAccount();
Account.AccID = (Guid)results["AccID"];
Account.Network = (string)results["Network"];
Account.Username = (string)results["Username"];
Account.Added = (DateTime)results["Added"];
Account.Network =
Char.ToUpper(Account.Network[0]) + Account.Network.Substring(1);
Model.Recent.Add(Account);
}
}
}
}
return(View(Model));
}
