public ActionResult ReaderList()
{
MyDataBaseEntities dc = new MyDataBaseEntities();
var readerList = dc.Reader.ToList();
return(View(readerList));
}
public ActionResult Registration(User user)
{
bool Status = false;
string message = "";
//Model validation
if (ModelState.IsValid)
{
var emailIsExist = IsEmailExist(user.EmailID);
if (emailIsExist)
{
ModelState.AddModelError("EmailExists", "Email already exists.");
return(View());
}
//Password Hashing
user.Password = Crypto.Hash(user.Password);
user.ConfirmPassword = Crypto.Hash(user.ConfirmPassword);
//save to DB
using (MyDataBaseEntities dc = new MyDataBaseEntities())
{
{
dc.Users.Add(user);
dc.SaveChanges();
}
}
}
else
{
message = "Invalid Request";
}
ViewBag.Message = message;
ViewBag.Status = Status;
return(View(user));
}
public bool IsEmailExist(string emailID)
{
using (MyDataBaseEntities dc = new MyDataBaseEntities())
{
var v = dc.Users.Where(a => a.EmailID == emailID).ToList();
return(v.Count > 0 ? true : false);
}
}
public void DeleteStudent(int id)
{
var db = new MyDataBaseEntities();
var student = db.Student.Find(id);
db.Student.Remove(student);
db.SaveChanges();
}
public bool isEmailExist(string emailID)
{
using (MyDataBaseEntities ds = new MyDataBaseEntities())
{
var v = ds.Users.Where(a => a.EmailId == emailID).FirstOrDefault();
return(v != null);
}
}
public ActionResult MostData()
{
using (MyDataBaseEntities Bd = new MyDataBaseEntities())
{
var Datos = Bd.pacientes.OrderBy(X => X.Nombre).ToList();
return(Json(new { data = Datos }, JsonRequestBehavior.AllowGet));
}
}
//check for email in db already exist
public bool IsEmailExist(string email)
{
using (MyDataBaseEntities dc = new MyDataBaseEntities())
{
var activeEmail = dc.Users.Where(a => a.EmailID == email).FirstOrDefault();
return(activeEmail != null);
}
}
public JsonResult GetLastContact()
{
Contact c = null;
using(MyDataBaseEntities dc = new MyDataBaseEntities())
{
c = dc.Contacts.OrderBy(a => a.ContactID).Take(1).FirstOrDefault();
}
return new JsonResult { Data = c, JsonRequestBehavior = JsonRequestBehavior.AllowGet };
}
public ActionResult DeleteReader(int id)
{
MyDataBaseEntities dc = new MyDataBaseEntities();
var readerId = dc.Reader.Find(id);
dc.Reader.Remove(readerId);
dc.SaveChanges();
return(RedirectToAction("ReaderList", "Reader"));
}
public ActionResult AddOrEdit(Emp empModel)
{
using (MyDataBaseEntities dbmodel = new MyDataBaseEntities())
{
dbmodel.Emps.Add(empModel);
dbmodel.SaveChanges();
}
ModelState.Clear();
ViewBag.SuccessMessage = "Regestration Successfully";
return(View(" AddOrEdit", new Emp()));
}
public void UpdateStudent(int id, string name, DateTime birthday, int class_id)
{
var db = new MyDataBaseEntities();
var student = db.Student.Find(id);
student.Name = name;
student.Birthday = birthday;
student.Class_id = class_id;
db.Entry(student).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
public ActionResult ReaderDetails(int id)
{
MyDataBaseEntities dc = new MyDataBaseEntities();
var readingLogList = dc.ReadingLog.Where(a => a.ReaderId == id).ToList();
if (readingLogList != null)
{
Session["ReaderName"] = readingLogList[0].ReaderName;
Session["ReaderId"] = readingLogList[0].ReaderId;
}
return(View(readingLogList));
}
public ActionResult BookList()
{
using (MyDataBaseEntities dc = new MyDataBaseEntities())
{
int Id = Convert.ToInt32(Session["ReaderId"]);
var readingLogList = dc.ReadingLog.Where(a => a.ReaderId == Id).ToList();
//var BookList = (readingLogList.Select(a => a.BookName)).ToList();
//dc.ReadingLog.Where(a => a.ReaderId == readingLog.ReaderId).Select(a =>a.BookName).ToList();
//return Redirect(ReaderDetails);
//Console.Write(BookList);
return(View("BookList", readingLogList));
}
}
public ActionResult Registration([Bind(Exclude = "IsEmailVerified, ActivationCode")] User user)
{
bool Status = false;
string message = "";
//Modelvalidation
if (ModelState.IsValid)
{
#region //Email is already Exist or not
var isExist = IsEmailExist(user.EmailID);
if (isExist)
{
ModelState.AddModelError("EmailExist", "Email already exist");
return(View(user));
}
#endregion
#region Generate Activation Code
user.ActivationCode = Guid.NewGuid();
#endregion
#region Password Hashing
user.Password = Crypto.Hash(user.Password);
user.ConfirmPassword = Crypto.Hash(user.ConfirmPassword);
#endregion
user.IsEmailVerified = false;
#region Sava data to Database
using (MyDataBaseEntities dc = new MyDataBaseEntities())
{
dc.Users.Add(user);
dc.SaveChanges();
//Send Email to User
sendVerificationLinkEmail(user.EmailID, user.ActivationCode.ToString());
message = "Registration successfully done. Account activation link has been sent" +
" to your email id:" + user.EmailID;
Status = true;
}
#endregion
}
else
{
message = "Invalid Request";
}
ViewBag.Message = message;
ViewBag.Status = Status;
return(View(user));
}
public void CreateStudent(string code, string name, DateTime birthday, int class_id)
{
var student = new Student();
student.Code = code;
student.Name = name;
student.Birthday = birthday;
student.Class_id = class_id;
var db = new MyDataBaseEntities();
db.Student.Add(student);
db.SaveChanges();
}
public ActionResult DeleteReader(Reader reader, int id)
{
string readerName = " ";
MyDataBaseEntities dc = new MyDataBaseEntities();
var reader_data = dc.Reader.Where(a => a.ReaderId == id).FirstOrDefault();
if (reader_data != null)
{
readerName = reader_data.ReaderName;
ViewBag.readerId = id;
ViewBag.readerName = readerName;
}
return(View());
}
public ActionResult Reader(Reader reader)
{
MyDataBaseEntities dc = new MyDataBaseEntities();
var model = dc.ReadingLog.ToList();
try
{
dc.Reader.Add(reader);
dc.SaveChanges();
}
catch (DbUpdateException ex)
{
Console.WriteLine(ex.InnerException.Message);
}
return(RedirectToAction("ReaderList", "Reader"));
}
public ActionResult Login(UserLogin login, string ReturnUrl)
{
string message = "";
using (MyDataBaseEntities dc = new MyDataBaseEntities())
{
var v = dc.Users.Where(a => a.EmailId == login.EmailID).FirstOrDefault();
if (v != null)
{
if (string.Compare(Crypto.Mash(login.Password), v.Password) == 0)
{
int timeout = login.RememberMe ? 525600 : 20; //525600 min = 1 year
var ticket = new FormsAuthenticationTicket(login.EmailID, login.RememberMe, timeout);
string encrypted = FormsAuthentication.Encrypt(ticket);
var cookie = new HttpCookie(FormsAuthentication.FormsCookieName, encrypted);
cookie.Expires = DateTime.Now.AddMinutes(timeout);
cookie.HttpOnly = true;
Response.Cookies.Add(cookie);
if (Url.IsLocalUrl(ReturnUrl))
{
return(Redirect(ReturnUrl));
}
else
{
return(RedirectToAction("Index", "Home"));
}
}
else
{
message = "Invalid Credentials provided";
}
}
else
{
message = "Invalid Credentials provided";
}
}
ViewBag.Message = message;
return(View());
}
public ActionResult Login(User userModel)
{
//log.Info("msg");
using (MyDataBaseEntities dbmodel = new MyDataBaseEntities())
{
User user1 = (from u in dbmodel.User where u.UserName.Equals(userModel.UserName) select u).FirstOrDefault();
if (user1 == null)
{
log.Info(userModel.UserName + " does not exist");
ViewBag.Error = "Username does not exist";
return(View("Add", new User()));
}
else
{
var crypt = new SHA256Managed();
var hash = new StringBuilder();
userModel.Password += user1.Salt;
byte[] crypto = crypt.ComputeHash(Encoding.UTF8.GetBytes(userModel.Password));
foreach (byte theByte in crypto)
{
hash.Append(theByte.ToString("x2"));
}
userModel.Password = hash.ToString();
if (user1.Password == userModel.Password)
{
log.Info(user1.UserName + " authentified");
ViewBag.SuccessMessage = "authentified";
return(View("Add", new User()));
}
else
{
log.Info(user1.UserName + " login with incorrect password");
ViewBag.Error = " incorrect password , try again ";
return(View("Add", new User()));
}
}
}
}
public ActionResult VerifyAccount(string id)
{
bool Status = false;
using (MyDataBaseEntities dc = new MyDataBaseEntities())
{
dc.Configuration.ValidateOnSaveEnabled = false; //This is the line i have added here to avoid confirm password does not match issue on save changes
var v = dc.Users.Where(a => a.ActivationCode == new Guid(id)).FirstOrDefault();
if (v != null)
{
v.IsEmailVerified = true;
dc.SaveChanges();
Status = true;
}
else
{
ViewBag.Message = "Invalid Request";
}
}
ViewBag.Status = Status;
return(View());
}
public ActionResult Add(User usermodel)
{
using (MyDataBaseEntities dbmodel = new MyDataBaseEntities())
{
if (dbmodel.User.Any(x => x.UserName == usermodel.UserName))
{
log.Info(usermodel.UserName + " already exists");
ViewBag.DuplicateMessage = "Username already exists";
return(View("Add", new User()));
}
RNGCryptoServiceProvider rng = new RNGCryptoServiceProvider();
byte[] sel = new byte[4];
rng.GetBytes(sel);
usermodel.Salt = Convert.ToBase64String(sel);
usermodel.Password += usermodel.Salt;
//hachage Password
var crypt = new SHA256Managed();
var hash = new StringBuilder();
byte[] crypto = crypt.ComputeHash(Encoding.UTF8.GetBytes(usermodel.Password));
foreach (byte theByte in crypto)
{
hash.Append(theByte.ToString("x2"));
}
//change password to hash password
usermodel.Password = hash.ToString();
usermodel.ConfirmPassword = usermodel.Password;
dbmodel.User.Add(usermodel);
dbmodel.SaveChanges();
log.Info(usermodel.UserName + " Success Registration");
ViewBag.SuccessMessage = "Success Registration";
return(View(new User()));
}
}
public ActionResult Create(ReadingLog readingLog)
{
string bookName = readingLog.BookName;
string authorName = readingLog.Author;
readingLog.ClockIn = DateTime.Now;
readingLog.ClockOut = DateTime.Now;
readingLog.ReaderId = Convert.ToInt32(Session["ReaderId"]);
readingLog.ReaderName = Convert.ToString(Session["ReaderName"]);
int Id = Convert.ToInt32(Session["ReaderId"]);
using (MyDataBaseEntities dc = new MyDataBaseEntities())
{
dc.ReadingLog.Add(readingLog);
dc.SaveChanges();
var readingLogList = dc.ReadingLog.Where(a => a.ReaderId == Id).ToList();
//var BookList = (readingLogList.Select(a => a.BookName)).ToList();
//dc.ReadingLog.Where(a => a.ReaderId == readingLog.ReaderId).Select(a =>a.BookName).ToList();
//return Redirect(ReaderDetails);
//Console.Write(BookList);
return(View("BookList", readingLogList));
}
}
public Class[] GetClasses()
{
var db = new MyDataBaseEntities();
return(db.Class.ToArray());
}
public Student GetStudent(int id)
{
var db = new MyDataBaseEntities();
return(db.Student.Find(id));
}
public Student[] GetStudents()
{
var db = new MyDataBaseEntities();
return(db.Student.ToArray());
}
