//Registration of user
public IHttpActionResult accRegForm(accountClass obj)
{
TBL_SIGNUP tbObj = new TBL_SIGNUP();
if (ModelState.IsValid)
{
tbObj.NAME = obj.NAME;
tbObj.EMAIL = obj.EMAIL;
tbObj.USERNAME = obj.USERNAME;
tbObj.PASSWORD = Crypto.Hash(obj.PASSWORD);
tbObj.PHONE_NO = obj.PHONE_NO;
tbObj.POINTS = 5;
dbObj.TBL_SIGNUP.Add(tbObj);
dbObj.SaveChanges();
var roles = new TBL_USERROLE();
roles.ROLE = "User";
roles.USERNAME = obj.USERNAME;
dbObj.TBL_USERROLE.Add(roles);
dbObj.SaveChanges();
return(Ok());
}
ModelState.Clear();
return(BadRequest());
}
public IEnumerable <UserDetails> FetchNames()
{
TBL_SIGNUP tbObj = new TBL_SIGNUP();
var result = (
from obj in dbObj.TBL_SIGNUP
orderby obj.POINTS descending
select obj).Take(8);
return(result.ToList().Select(Mapper.Map <TBL_SIGNUP, UserDetails>));
}
public ActionResult login(TBL_SIGNUP userModel)
{
using (managementEntities db = new managementEntities())
{
var userdetails = db.TBL_SIGNUP.Where(a => a.USER_NAME == userModel.USER_NAME && a.PASSWORD == userModel.PASSWORD).FirstOrDefault();
if (userdetails != null)
{
return(RedirectToAction("bookregister", "book"));
}
else
{
ViewBag.message = true;
ViewBag.errormessage = "username and password is invalid";
return(View(userModel));
}
}
}
