public void UpdateProductById(int id, EditProductView formData) { var product = _db.Products.Find(id); if (product == null) { return; } product.Name = formData.Name; product.ImportAt = formData.ImportAt; product.Price = formData.Price; product.Stock = formData.Stock; product.UpdatedAt = DateTime.Now; try { _db.Products.Attach(product); _db.Entry(product).State = EntityState.Modified; _db.SaveChanges(); } catch (Exception e) { throw e; } }
public virtual void Delete(TEntity entityToDelete) { if (_context.Entry(entityToDelete).State == EntityState.Detached) { _dbSet.Attach(entityToDelete); } _dbSet.Remove(entityToDelete); }
public async Task <IActionResult> PutExam(int id, Exam exam) { if (id != exam.Id) { return(BadRequest()); } _context.Entry(exam).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!ExamExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task <IActionResult> PutCurrency(string id, Currency currency) { if (id != currency.Id) { return(BadRequest()); } _context.Entry(currency).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!CurrencyExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public ActionResult Edit([Bind(Include = "id,program_code,program_title,course_code,course_title,course_hours,section_number,have_final_exam,final_exam_note,room_request,exam_length,weekday,time,room,teacher_name,proctor,is_deleted,created_by,created_on,modified_by,modified_on")] special_arrangement special_arrangement) { if (ModelState.IsValid) { db.Entry(special_arrangement).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(special_arrangement)); }
public ActionResult Edit([Bind(Include = "ClassRoom1,NameTeacher")] ClassRoom classRoom) { if (ModelState.IsValid) { db.Entry(classRoom).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(classRoom)); }
public ActionResult Edit([Bind(Include = "ExamSubject1,Id")] ExamSubject examSubject) { if (ModelState.IsValid) { db.Entry(examSubject).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(examSubject)); }
public ActionResult Edit([Bind(Include = "ID,Name,Email,Cell,NameOfClass,Subject")] AllTheTeacher allTheTeacher) { if (ModelState.IsValid) { db.Entry(allTheTeacher).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(allTheTeacher)); }
public ActionResult Edit([Bind(Include = "ID,Roll,Name,Email,Cell")] ClassOneStudent classOneStudent) { if (ModelState.IsValid) { db.Entry(classOneStudent).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(classOneStudent)); }
public ActionResult Edit([Bind(Include = "ID,Roll,SBA,Final,Total,GPA,Grade")] Bengali bengali) { if (ModelState.IsValid) { db.Entry(bengali).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(bengali)); }
public ActionResult Edit([Bind(Include = "FacultyName,Phone")] Faculty faculty) { if (ModelState.IsValid) { db.Entry(faculty).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(faculty)); }
public ActionResult Edit([Bind(Include = "id,user01,passwork,email,phone,1")] User user) { if (ModelState.IsValid) { db.Entry(user).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(user)); }
public ActionResult Edit([Bind(Include = "ID,CourseName,CourseTeacher,CourseOfClass,Division")] AllTheCourse allTheCourse) { if (ModelState.IsValid) { db.Entry(allTheCourse).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(allTheCourse)); }
public ActionResult Edit([Bind(Include = "ID,Year,NameOfClass,Subject,Roll,Name,SBA,Final,Total,GPA,Grade")] AllTheResult allTheResult) { if (ModelState.IsValid) { db.Entry(allTheResult).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(allTheResult)); }
public ActionResult Edit([Bind(Include = "id,employee_id,first_name,middle_name,last_name,gender,birthdate,e_mail,mobile_number,work_number,is_deleted,created_by,created_on,modified_by,modified_on")] faculty faculty) { if (ModelState.IsValid) { db.Entry(faculty).State = EntityState.Modified; faculty.modified_on = DateTime.Now; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(faculty)); }
public ActionResult Edit([Bind(Include = "id,program_code,title,is_deleted,created_by,created_on,modified_by,modified_on")] program program) { if (ModelState.IsValid) { db.Entry(program).State = EntityState.Modified; program.modified_on = DateTime.Now; db.SaveChanges(); return RedirectToAction("Index"); } return View(program); }
public ActionResult Edit([Bind(Include = "id,type,is_deleted,created_by,created_on,modified_by,modified_on")] room_type room_type) { if (ModelState.IsValid) { db.Entry(room_type).State = EntityState.Modified; room_type.modified_on = DateTime.Now; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(room_type)); }
public async Task <ActionResult> Edit([Bind(Include = "Id,Name,ParentId")] Category category) { if (ModelState.IsValid) { db.Entry(category).State = EntityState.Modified; await db.SaveChangesAsync(); return(RedirectToAction("Index")); } ViewBag.ParentId = new SelectList(db.Categories, "Id", "Name", category.ParentId); return(View(category)); }
public ActionResult Edit([Bind(Include = "id,name,capacity,room_type_id,is_deleted,created_by,created_on,modified_by,modified_on")] room room) { if (ModelState.IsValid) { db.Entry(room).State = EntityState.Modified; room.modified_on = DateTime.Now; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.room_type_id = new SelectList(db.room_type, "id", "type", room.room_type_id); return(View(room)); }
public virtual (bool success, string message) Insert(TEntity exam) { _db.Entry(exam).State = EntityState.Added; try { _db.SaveChanges(); } catch (DbUpdateException e) { return(false, e.InnerException?.Message ?? e.Message); } return(true, string.Empty); }
public ActionResult Edit([Bind(Include = "ExamId,StartTime,ExamDate,ExamDuration,ExamSubject,ClassRoom,FacultyName")] ExamDetail examDetail) { if (ModelState.IsValid) { db.Entry(examDetail).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ClassRoom = new SelectList(db.ClassRooms, "ClassRoom1", "NameTeacher", examDetail.ClassRoom); ViewBag.ExamSubject = new SelectList(db.ExamSubjects, "ExamSubject1", "Id", examDetail.ExamSubject); ViewBag.FacultyName = new SelectList(db.Faculties, "FacultyName", "FacultyName", examDetail.FacultyName); return(View(examDetail)); }
public ActionResult EditAppointment(Appointment appointment) { var checkModification = db.Appointments.AsNoTracking().Where(x => x.ExamId == appointment.ExamId).FirstOrDefault().Student; if (checkModification == null) { db.Entry(appointment).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index", new { msg = "Вы успешно записались." })); } else { return(RedirectToAction("Index", new { msg = "Данное время занято. Выберите другое время." })); } }
public ActionResult Edit([Bind(Include = "id,section_number,program_id,course_id,student_enrolled,faculty_id,is_deleted,created_by,created_on,modified_by,modified_on,class_weekday,class_start_time,room_id")] section section) { if (ModelState.IsValid) { db.Entry(section).State = EntityState.Modified; if (section.is_deleted == false) { // set related course deleted = false; var tempC = db.courses.Where(e => e.id == section.course_id); if (tempC.ToList().Count > 0) { foreach (var item in tempC) { item.is_deleted = false; } } // set related course - exam deleted = false; var tempCE = db.course_exam.Where(e => e.course_id == section.course_id); if (tempCE.ToList().Count > 0) { foreach (var item in tempCE) { item.is_deleted = false; } } } section.student_enrolled = 30; section.modified_on = DateTime.Now; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.course_id = new SelectList(db.courses.Where(c => c.is_deleted == false || c.id == section.course_id).OrderBy(o => o.code), "id", "courseDropdown", section.course_id); ViewBag.faculty_id = new SelectList(db.faculties.Where(c => c.is_deleted == false), "id", "last_name", section.faculty_id); ViewBag.program_id = new SelectList(db.programs.Where(c => c.is_deleted == false), "id", "title", section.program_id); ViewBag.room_id = new SelectList(db.rooms.Where(c => c.is_deleted == false).OrderBy(o => o.name), "id", "name", section.room_id); var weekDays = Enum.GetValues(typeof(DayOfWeek)).Cast <DayOfWeek>() .Select(dow => new { Value = (int)dow - 1, Text = dow.ToString() }) .ToList(); ViewBag.class_weekday = new SelectList(weekDays, "Value", "Text", section.class_weekday); return(View(section)); }
public ActionResult Edit(Exam exam) { try { if (ModelState.IsValid) { db.Entry(exam).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(exam)); } catch { return(View()); } }
public ActionResult Edit([Bind(Include = "id, subject, startTime, examDate, duration, classRoom, faculty, status")] TableExam exam) { try { // TODO: Add update logic here if (ModelState.IsValid) { db.Entry(exam).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(RedirectToAction("Index")); } catch { return(View(exam)); } }
public ActionResult Edit([Bind(Include = "id,version_number,program_code,program_title,course_code,course_title,course_hours,section_number,have_final_exam,final_exam_note,room_request,exam_length,weekday,time,room,teacher_name,proctor,is_deleted,created_by,created_on,modified_by,modified_on")] exam_timetable exam_timetable) { if (ModelState.IsValid) { db.Entry(exam_timetable).State = EntityState.Modified; //if (exam_timetable.is_deleted != false) //{ // var tempSchedule = db.exam_timetable.Where(e => e.version_number == exam_timetable.version_number); // foreach (var exam in tempSchedule) // { // exam.is_deleted = true; // } //} exam_timetable.modified_on = DateTime.Now; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(exam_timetable)); }
public void Edit(Result _Result) { Db.Entry(_Result).State = EntityState.Modified; Db.SaveChanges(); }
public ActionResult Edit([Bind(Include = "id,course_id,have_final_exam,exam_length,required_room_type_id,final_exam_note,is_deleted,created_by,created_on,modified_by,modified_on")] course_exam course_exam) { if (ModelState.IsValid) { db.Entry(course_exam).State = EntityState.Modified; if (course_exam.is_deleted == true) { // set all related course to deleted = true var tempC = db.courses.Where(e => e.id == course_exam.course_id); if (tempC.ToList().Count > 0) { foreach (var item in tempC) { item.is_deleted = true; } } // set all related sections deleted = true var tempS = db.sections.Where(e => e.course_id == course_exam.course_id); if (tempS.ToList().Count > 0) { foreach (var item in tempS) { item.is_deleted = true; } } } else { // set all related course to deleted = false var tempC = db.courses.Where(e => e.id == course_exam.course_id); if (tempC.ToList().Count > 0) { foreach (var item in tempC) { item.is_deleted = false; } } // set all related sections deleted = false var tempS = db.sections.Where(e => e.course_id == course_exam.course_id); if (tempS.ToList().Count > 0) { foreach (var item in tempS) { item.is_deleted = false; } } } course_exam.modified_on = DateTime.Now; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.required_room_type_id = new SelectList(db.room_type.Where(c => c.is_deleted == false), "id", "type", course_exam.required_room_type_id); ViewBag.course_id = new SelectList(db.courses.Where(c => c.is_deleted == false || c.id == course_exam.course_id).OrderBy(o => o.code), "id", "courseDropdown", course_exam.course_id); return(View(course_exam)); }
public void Edit(User _User) { Db.Entry(_User).State = EntityState.Modified; Db.SaveChanges(); }
public void Edit(Subject _Subject) { Db.Entry(_Subject).State = EntityState.Modified; Db.SaveChanges(); }