public HttpResponseMessage putBookCount(int id, int count)
{
try
{
using (LMSEntities entities = new LMSEntities())
{
var entity = entities.Books.First(e => e.BookId == id);
if (entity == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Book with id =" + id.ToString() + "is not found to update"));
}
else
{
entity.AvailableNumber += count;
entity.Quantity += count;
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, entity));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public ActionResult AddTeacher(tbl_teacher t, Email e)
{
try
{
LMSEntities DB = new LMSEntities();
Teacher teacher = new Teacher();
teacher.Name = t.Name;
teacher.Email = t.Email;
e.Email1 = t.Email;
teacher.Designation = t.Designation;
DB.tbl_teacher.Add(t);
DB.Emails.Add(e);
DB.SaveChanges();
return(RedirectToAction("Teacher"));
}
catch
{
return(View());
}
}
public HttpResponseMessage putBook(int id, [FromBody] Book book)
{
try
{
using (LMSEntities entities = new LMSEntities())
{
var entity = entities.Books.First(e => e.BookId == id);
if (entity == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Book with id =" + id.ToString() + "is not found to update"));
}
else
{
entity.BookName = book.BookName;
entity.Author = book.Author;
entity.Genre = book.Genre;
entity.AvailableNumber = book.AvailableNumber;
entity.Quantity = book.Quantity;
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, entity));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public HttpResponseMessage Delete(int id)
{
try
{
using (LMSEntities entities = new LMSEntities())
{
var entity = entities.Books.First(e => e.BookId == id);
if (entity == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound,
"Book with Id = " + id.ToString() + " not found to delete"));
}
else
{
entities.Books.Remove(entity);
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public User FindUser(string userName, string passwordHash)
{
using (LMSEntities context = new LMSEntities())
{
return(context.Users.FirstOrDefault(x => x.UserName == userName && x.PasswordHash == passwordHash));
}
}
public ActionResult AddIssuedbook(Issued_Books v)
{
try
{
IssuedBooksVM m = new IssuedBooksVM();
m.Number = v.Number;
m.Email = v.Email;
m.Issue_date = v.Issue_date;
m.Return_date = v.Return_date;
m.Due_date = v.Due_date;
v.Fine = Fine(v.Return_date, v.Due_date);
m.Fine = v.Fine;
m.Status = v.Status;
LMSEntities db = new LMSEntities();
db.Issued_Books.Add(v);
db.SaveChanges();
return(RedirectToAction("IssuedBooks"));
}
catch
{
return(View());
}
}
public IEnumerable <Book> GetBooks()
{
using (LMSEntities entities = new LMSEntities())
{
return(entities.Books.ToList());
}
}
public ActionResult AddAllBooks(All_Books b)
{
try
{
using (LMSEntities db = new LMSEntities())
{
AllBooks bk = new AllBooks();
bk.Name = b.Name;
bk.Number = b.Number;
bk.Price = b.Price;
bk.Author = b.Author;
bk.Edition = b.Edition;
bk.Status = b.Status;
db.All_Books.Add(b);
db.SaveChanges();
}
return(RedirectToAction("AllBooks"));
}
catch
{
return(View());
}
}
public UserDisplayDto CreateUser(UserRegisterDto user)
{
User createdUser = new User
{
FirstName = user.FirstName,
LastName = user.LastName,
Email = user.Email,
PasswordHash = Util.HashHelper.GetMD5HashData(user.Password),
UserName = user.UserName,
CreatedOn = DateTime.Now
};
LMSEntities context = new LMSEntities();
UserRepository userRepository = new UserRepository(context);
createdUser = userRepository.Add(createdUser);
UserDisplayDto displayUser = new UserDisplayDto
{
UserName = user.UserName,
FirstName = user.FirstName,
LastName = user.LastName,
Email = user.Email,
};
return(displayUser);
}
public async Task <ActionResult> Register(RegisterViewModel 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)
{
UserDetail newUserDeets = new UserDetail();
newUserDeets.UserId = user.Id;
newUserDeets.FirstName = model.FirstName;
newUserDeets.LastName = model.LastName;
LMSEntities db = new LMSEntities();
db.UserDetails.Add(newUserDeets);
db.SaveChanges();
var 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 this link: <a href=\"" + callbackUrl + "\">link</a>");
ViewBag.Link = callbackUrl;
UserManager.AddToRole(user.Id, "employee");
return(View("DisplayEmail"));
}
AddErrors(result);
}
// If we got this far, something failed, redisplay form
return(View(model));
}
public ActionResult AllBooks()
{
using (LMSEntities db = new LMSEntities())
{
return(View(db.All_Books.ToList()));
}
}
public JsonResult getCategories()
{
using (_LMSEntities = new LMSEntities())
{
return(Json(_LMSEntities.Categories.Select(c => new { CategoryName = c.CategoryName, CategoryID = c.CategoryID }).ToArray(),
JsonRequestBehavior.AllowGet));
}
}
public User FindUser(string userName, string password)
{
var passwordHash = Util.HashHelper.GetMD5HashData(password);
LMSEntities context = new LMSEntities();
UserRepository userRepository = new UserRepository(context);
return(userRepository.FindUser(userName, passwordHash));
}
public IHttpActionResult Test()
{
using (LMSEntities context = new LMSEntities())
{
var students = context.Students.ToList();
return(Ok(students));
}
}
public static void DelAuthor(string Id)
{
using (LMSEntities dbe = new LMSEntities())
{
Author author = dbe.Authors.Where(o => o.Id.Equals(Id)).SingleOrDefault();
dbe.Authors.Remove(author);
dbe.SaveChanges();
}
}
public ActionResult ShowData()
{
List <Author> authors = new List <Author>();
using (LMSEntities dbe = new LMSEntities())
{
authors = dbe.Authors.ToList();
}
return(View(authors));
}
public ActionResult Editst(int id, Student t)
{
LMSEntities db = new LMSEntities();
db.tbl_student.Find(id).Name = t.Name;
db.tbl_student.Find(id).Email = t.Email;
db.tbl_student.Find(id).Registration_Number = t.Registration_Number;
db.SaveChanges();
return(RedirectToAction("Student"));
}
public bool checkLogin(String userName, String password)
{
dbContext = new LMSEntities();
if (dbContext.Users.Any(x => x.UserName == userName && x.Password == password))
{
return(true);
}
else
{
return(false);
}
}
public ActionResult Teacher(string searchby, string search)
{
using (LMSEntities db = new LMSEntities())
{
if (searchby == "Name")
{
return(View(db.tbl_teacher.Where(x => x.Name.Contains(search) || search == null).ToList()));
}
else
{
return(View(db.tbl_teacher.Where(x => x.Designation.Contains(search) || search == null).ToList()));
}
}
}
public ActionResult IssuedBooks(string searchby, string search)
{
using (LMSEntities db = new LMSEntities())
{
if (searchby == "Number")
{
return(View(db.Issued_Books.Where(x => x.Number.Contains(search) || search == null).ToList()));
}
else
{
return(View(db.Issued_Books.Where(x => x.Email.Contains(search) || search == null).ToList()));
}
}
}
public ActionResult Student(string searchby, string search)
{
using (LMSEntities db = new LMSEntities())
{
if (searchby == "Name")
{
return(View(db.tbl_student.Where(x => x.Name.Contains(search) || search == null).ToList()));
}
else
{
return(View(db.tbl_student.Where(x => x.Registration_Number.Contains(search) || search == null).ToList()));
}
}
}
public ActionResult Deletest(int id)
{
LMSEntities db = new LMSEntities();
foreach (tbl_student t1 in db.tbl_student)
{
if (t1.ID == id)
{
db.tbl_student.Remove(t1);
}
}
db.SaveChanges();
return(RedirectToAction("Student"));
}
// GET: Admin/Delete/5
public ActionResult Delete(int id)
{
LMSEntities db = new LMSEntities();
foreach (tbl_teacher t1 in db.tbl_teacher)
{
if (t1.ID == id)
{
db.tbl_teacher.Remove(t1);
}
}
db.SaveChanges();
return(RedirectToAction("Teacher"));
}
public IHttpActionResult LeadMonitor(string userID)
{
List <InstantLead> leadList = new List <InstantLead>();
using (var context = new LMSEntities())
{
context.Configuration.LazyLoadingEnabled = false;
var query = from a in context.InstantLeads
join b in context.InstantLeadTypes on a.TypeID equals b.TypeID
where a.OriginatorID == userID
select new { InstantLead = a, InstantLeadTypes = b };
foreach (var item in query)
{
InstantLead lead = item.InstantLead;
lead.InstantLeadName = item.InstantLeadTypes.Name;
try {
if (lead.Closed == 1)
{
lead.RemainHours = 0;
lead.PercentRemain = 0;
}
else
{
TimeSpan _ts = DateTime.Now.Subtract((DateTime)lead.CreateDate);
lead.RemainHours = (int)item.InstantLeadTypes.SLA - (int)_ts.TotalHours;
if ((int)item.InstantLeadTypes.SLA > 0)
{
lead.PercentRemain = ((double)lead.RemainHours / (int)item.InstantLeadTypes.SLA) * 100;
if (lead.PercentRemain > 0)
{
lead.PercentRemain = 100 - lead.PercentRemain;
}
}
else
{
lead.PercentRemain = 0;
}
}
}
catch
{
}
leadList.Add(lead);
}
}
return(Json(leadList));
}
public static AuthorEntity DetailAuthor(string Id)
{
AuthorEntity authorEntity = new Entity.AuthorEntity();
using (LMSEntities dbe = new LMSEntities())
{
Author author = dbe.Authors.Where(o => o.Id.Equals(Id)).Single();
authorEntity.Id = author.Id;
authorEntity.FirstName = author.FirstName;
authorEntity.LastName = author.LastName;
authorEntity.Phone = author.Phone;
authorEntity.Email = author.Email;
authorEntity.Qualification = author.Qualification;
}
return(authorEntity);
}
public HttpResponseMessage Post([FromBody] Book book)
{
try
{
using (LMSEntities entities = new LMSEntities())
{
entities.Books.Add(book);
entities.SaveChanges();
var message = Request.CreateResponse(HttpStatusCode.Created, book);
return(message);
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
// GET: Admin/Edit/5
public ActionResult Edit(int id)
{
Teacher t = new Teacher();
LMSEntities db = new LMSEntities();
foreach (tbl_teacher T in db.tbl_teacher)
{
if (T.ID == id)
{
t.Name = T.Name;
t.Email = T.Email;
t.Designation = T.Designation;
break;
}
}
return(View(t));
}
public ActionResult Editst(int id)
{
Student st = new Student();
LMSEntities db = new LMSEntities();
foreach (tbl_student ST in db.tbl_student)
{
if (ST.ID == id)
{
st.Name = ST.Name;
st.Email = ST.Email;
st.Registration_Number = ST.Registration_Number;
break;
}
}
return(View(st));
}
public ActionResult Edit(int id, Teacher t)
{
{
LMSEntities db = new LMSEntities();
db.tbl_teacher.Find(id).Name = t.Name;
db.tbl_teacher.Find(id).Email = t.Email;
db.tbl_teacher.Find(id).Designation = t.Designation;
db.SaveChanges();
return(RedirectToAction("Teacher"));
}
/*catch
* {
* return View();
* }*/
}
public async Task <ActionResult> Register(RegisterViewModel userViewModel, params string[] selectedRoles)
{
if (ModelState.IsValid)
{
var user = new ApplicationUser {
UserName = userViewModel.Email, Email = userViewModel.Email, EmailConfirmed = true
};
var adminresult = await UserManager.CreateAsync(user, userViewModel.Password);
//Add User to the selected Roles
if (adminresult.Succeeded)
{
var result = await UserManager.AddToRolesAsync(user.Id, "Employee");
if (!result.Succeeded)
{
ModelState.AddModelError("", result.Errors.First());
ViewBag.RoleId = new SelectList(await RoleManager.Roles.ToListAsync(), "Name", "Name");
return(View());
}
UserDetail deets = new UserDetail()
{
UserID = user.Id,
FirstName = userViewModel.FirstName,
LastName = userViewModel.LastName
};
LMSEntities ctx = new LMSEntities();
ctx.UserDetails.Add(deets);
ctx.SaveChanges();
}
else
{
ModelState.AddModelError("", adminresult.Errors.First());
ViewBag.RoleId = new SelectList(RoleManager.Roles, "Name", "Name");
return(View());
}
return(RedirectToAction("Login"));
}
ViewBag.RoleId = new SelectList(RoleManager.Roles, "Name", "Name");
return(View());
}
