public IHttpActionResult PutOrderTable(int id, OrderTable orderTable) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != orderTable.OrderId) { return(BadRequest()); } db.Entry(orderTable).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!OrderTableExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public void getCourse() { baseCrawler.GotoMainPage(); baseCrawler.LoginPage(); Guid univid = Guid.Parse("dbac5470-14db-4492-80b0-d8e8d9d85c3e"); foreach (string key in baseCrawler.CourseList.Keys) { string coursename = baseCrawler.CourseList[key]; var course = (from crs in db.Courses where crs.CourseName == coursename select crs).FirstOrDefault(); if (course == null) { LMS.Models.Cours cose = new Cours(); cose.CourseId = Guid.NewGuid(); cose.CourseName = baseCrawler.CourseList[key]; cose.CourseDescription = baseCrawler.CourseList[key]; cose.CourseCreateDate = DateTime.Now; db.Courses.Add(cose); LMS.Models.CourseUniversity courseUnv = new CourseUniversity(); courseUnv.UniversityId = univid; courseUnv.CourseId = cose.CourseId; courseUnv.Id = Guid.NewGuid(); db.CourseUniversities.Add(courseUnv); db.SaveChanges(); } } }
public IHttpActionResult PutWishlist(int id, Wishlist wishlist) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != wishlist.WishListId) { return(BadRequest()); } db.Entry(wishlist).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!WishlistExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public ActionResult DeleteStudentConfirmed(int id) { Student user = db.Students.Find(id); db.Students.Remove(user); db.SaveChanges(); return(RedirectToAction("RegistrationList")); }
public ActionResult Create([Bind(Include = "CourseId,CourseName,CourseDescription,IsActive")] Course course) { if (ModelState.IsValid) { db.Courses.Add(course); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(course)); }
public ActionResult Create([Bind(Include = "EmpId,FirstName,LastName")] EmpDetail empDetail) { if (ModelState.IsValid) { db.EmpDetails.Add(empDetail); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(empDetail)); }
public ActionResult Create([Bind(Include = "Role_Id,Role_Name,Descriptions")] Role role) { if (ModelState.IsValid) { db.Roles.Add(role); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(role)); }
public ActionResult Create([Bind(Include = "Author_Id,Author_Name,Author_Description")] Author author) { if (ModelState.IsValid) { db.Authors.Add(author); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(author)); }
public ActionResult Create([Bind(Include = "BookID,ISBN,Title,DateofPublication")] Book book) { if (ModelState.IsValid) { db.Books.Add(book); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(book)); }
public ActionResult Create([Bind(Include = "JobID,JobName")] Job job) { if (ModelState.IsValid) { db.Jobs.Add(job); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(job)); }
public ActionResult Create([Bind(Include = "Category_Id,Category_Name,Category_Description")] category category) { if (ModelState.IsValid) { db.categories.Add(category); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(category)); }
public ActionResult Create([Bind(Include = "UserID,FirstName,LastName,UserName,Email,Phone")] LibUser libUser) { if (ModelState.IsValid) { db.LibUsers.Add(libUser); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(libUser)); }
public ActionResult Create([Bind(Include = "id,name,password,enrollment,email,contact,address")] Student student) { if (ModelState.IsValid) { db.Students.Add(student); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(student)); }
public ActionResult Create([Bind(Include = "UserID,FirstName,LastName,IsManager,Email,JobID,ReportsToID")] Employee employee) { if (ModelState.IsValid) { db.Employees.Add(employee); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(employee)); }
public ActionResult Create([Bind(Include = "Staff_Id,First_Name,Last_Name,Phone_No,Email,Username,Pass,Role_Id")] Staff staff) { if (ModelState.IsValid) { db.Staffs.Add(staff); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.Role_Id = new SelectList(db.Roles, "Role_Id", "Role_Name", staff.Role_Id); return(View(staff)); }
public ActionResult Create([Bind(Include = "Stock_Id,Book_Name,Qty,Available")] stock stock) { if (ModelState.IsValid) { db.stocks.Add(stock); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.Book_Name = new SelectList(db.Books, "Book_Id", "Book_Name", stock.Book_Name); return(View(stock)); }
public ActionResult Create([Bind(Include = "UserId,FirstName,LastName")] UserDetail userDetail) { if (ModelState.IsValid) { db.UserDetails.Add(userDetail); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.UserId = new SelectList(db.AspNetUsers, "Id", "Email", userDetail.UserId); return(View(userDetail)); }
public ActionResult Create([Bind(Include = "Member_Id,First_Name,Last_Name,Phone_No,Email,User_No,Pass,Role_Id")] Member_Details member_Details) { if (ModelState.IsValid) { db.Member_Details.Add(member_Details); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.Role_Id = new SelectList(db.Roles, "Role_Id", "Role_Name", member_Details.Role_Id); return(View(member_Details)); }
public ActionResult Create([Bind(Include = "UserID,FirstName,LastName,JobID,ManagerID,Email")] Manager manager) { if (ModelState.IsValid) { db.Managers.Add(manager); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.UserID = new SelectList(db.AspNetUsers, "Id", "Email", manager.UserID); return(View(manager)); }
public ActionResult SaveRules(AutoResponderModel objRules) { var autoResponsder = new AutoRespondingRule(); autoResponsder.ConditionType = objRules.ConditionType; autoResponsder.MatchingText = objRules.MatchingText; autoResponsder.TextType = objRules.TextType; db.AutoRespondingRules.Add(autoResponsder); db.SaveChanges(); return(Json(autoResponsder.id, JsonRequestBehavior.AllowGet)); }
public ActionResult Create([Bind(Include = "Book_Id,Book_Name,Category_Id,Author_Id,Publication_Year")] Book book) { if (ModelState.IsValid) { db.Books.Add(book); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.Author_Id = new SelectList(db.Authors, "Author_Id", "Author_Name", book.Author_Id); ViewBag.Category_Id = new SelectList(db.categories, "Category_Id", "Category_Name", book.Category_Id); return(View(book)); }
public ActionResult Create([Bind(Include = "EntryId,UserEntryId,MetalType,PlaceOfPurchase,DateOfPurchase,AmountOfPurchase")] Entry entry) { if (ModelState.IsValid) { db.Entries.Add(entry); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.MetalType = new SelectList(db.Metals, "MetalId", "Metal_Name", entry.MetalType); ViewBag.UserEntryId = new SelectList(db.UserDetails, "UserId", "FirstName", entry.UserEntryId); return(View(entry)); }
public ActionResult Create([Bind(Include = "LessonViewId,EmpId,LessonId,DateViewed")] LessonView lessonView) { if (ModelState.IsValid) { db.LessonViews.Add(lessonView); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.EmpId = new SelectList(db.EmpDetails, "EmpId", "FirstName", lessonView.EmpId); ViewBag.LessonId = new SelectList(db.Lessons, "LessonId", "LessonTitle", lessonView.LessonId); return(View(lessonView)); }
public ActionResult Create([Bind(Include = "Borrower_Id,Book_Id,Borrower_From,Borrower_To,Issue_By")] Borrower_Details borrower_Details) { if (ModelState.IsValid) { db.Borrower_Details.Add(borrower_Details); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.Book_Id = new SelectList(db.Books, "Book_Id", "Book_Name", borrower_Details.Book_Id); ViewBag.Issue_By = new SelectList(db.Staffs, "Staff_Id", "First_Name", borrower_Details.Issue_By); return(View(borrower_Details)); }
public ActionResult Create([Bind(Include = "OnLoanID,UserID,BookID,DateIssued,DateDueForReturn,ActualDateReturned")] BookOnLoan bookOnLoan) { if (ModelState.IsValid) { db.BookOnLoans.Add(bookOnLoan); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.BookID = new SelectList(db.Books, "BookID", "ISBN", bookOnLoan.BookID); ViewBag.UserID = new SelectList(db.LibUsers, "UserID", "FirstName", bookOnLoan.UserID); return(View(bookOnLoan)); }
public ActionResult Create([Bind(Include = "CourseCompletionID,UserID,CourseID,DateCompleted")] CourseCompletion courseCompletion) { if (ModelState.IsValid) { db.CourseCompletions.Add(courseCompletion); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.CourseID = new SelectList(db.Courses, "CourseID", "CourseName", courseCompletion.CourseID); ViewBag.UserID = new SelectList(db.UserDetails, "UserID", "FirstName", courseCompletion.UserID); return(View(courseCompletion)); }
public ActionResult Create(ProdiverUnviersityModel universityviewmodel) { University university = new University(); if (ModelState.IsValid) { university = (from unv in db.Universities where unv.UniversityId == universityviewmodel.UniversityId select unv).FirstOrDefault(); if (universityviewmodel.UniversityId != new Guid()) { university.UniversityName = universityviewmodel.UniversityName; universityviewmodel.UniversityDescription = universityviewmodel.UniversityDescription; db.Entry(university).State = EntityState.Modified; } else { university = new University(); university.UniversityId = Guid.NewGuid(); university.UniversityName = universityviewmodel.UniversityName; university.UniversityDescription = universityviewmodel.UniversityDescription; db.Universities.Add(university); } var CUS = db.CourseUniversityLMS.Where(ee => ee.UniversityId == university.UniversityId).ToList(); if (CUS != null && CUS.Any()) { db.CourseUniversityLMS.RemoveRange(CUS); } if (university.UniversityId != null && universityviewmodel.ProviderId.Any()) { foreach (var item in universityviewmodel.ProviderId) { db.CourseUniversityLMS.Add(new CourseUniversityLM() { ProviderId = item ?? Guid.Empty, UniversityId = university.UniversityId }); } } UpdateViewBag(university.UniversityId); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(universityviewmodel)); }
public JsonResult UpdateFaq(Guid FaqId, string FaqAnswer) { var faq = (from fq in db.FAQs where fq.FAQId == FaqId select fq).FirstOrDefault(); if (faq != null) { faq.Answer = FaqAnswer; } db.SaveChanges(); string serializedstring = JsonConvert.SerializeObject("Question Updated Successfully"); return(Json(serializedstring)); }
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 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()); } }