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