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()); }