How to save multiple rows into the database in mvc

Mark Tabor

6y1.9k.NET

hi I have a form in which i have two dropdownlist and two textboxes , these dropdownlist having multiselect options as well , Now i want to save multiple rows for them just see below.

you can see i have selected two teachers and two coruses i want to save four rows into the database like first two rows for the first teacher (For two courses ) and last two rows for the second teachers ( for two courses)
how to achieve it , i am sharing my model class as well I have not taken courses and teacher as list insted i took them as normal int type .

public int? Course_Id { get; set; }

public int? Teacher_Id { get; set; }

8 Replies

Know the answer? Post it — somebody with the same question will find it here.

Zulqadar Idrishi6y ago
Hey, here are some steps which may help you-
let's suppose this is a semester details form which you want to submit then there should be the main table like - TblSemesterDetails(AutoID, Semesters, is_on_Substitute, Active, CreationDate, ModificationDate)

and there should be a table to store course, teacher and AutoID(TblSemesterDetails) details like - TblSemCourseTeacher(course,teacher,AutoID)

Now, You need to insert your form data to the main table TblSemesterDetails in this case, and return AutoID of the main table to a variable like - int AutoID=InsertSemesterDetails(semesters, is_on_Substitute, Active, CreationDate, ModificationDate); you can set AutoID as Identity or AutoIncrement so, there is no need to insert it manually.

Now, Split Course and Teachers values and hold into Arrays like -
String[] ArrTeacher=Teacher_Id.Split(',');
String[] ArrCourse=Course_Id.Split(',');

Now, Use For Loop to insert one by one like below -
for(int i=0;i {
   var teacherid=ArrTeacher[i];
for(int j=0;j {
//Now insert the teacher and course details to TblSemCourseTeacher table
     InsertTblSemCourseTeacher(ArrCourse[j],teacherid,AutoID); //Inserting One Row EachTime
   }
}

So, like this you can insert row with relation each time and it will be an efficient way as well.
0
Mark Tabor6y ago
Hi when i am making my Teacher_ID and Courses_ID as List and List of Courses i am getting the below error message

when I make them like public int[] Teachers{get;set;}
then i am getting below error messages

My Model class is below
[Table("Teacher_courses")]
public class Teacher_courses
{
[Key]
[Display(Name = " ID")]
public int Id { get; set; }
[Display(Name = "Teacher Name")]
[ForeignKey("Teacher_Id")]
public virtual Registration regs { get; set; }
[Display(Name = "Teacher Name")]
// [Required(ErrorMessage = "Semester selection is required field!")]
public int? Teacher_Id { get; set; }


//[Display(Name = "Course Name")]
// [ForeignKey("Course_Id")]
public virtual Courses course { get; set; }
[Display(Name = "Teacher Name")]
// [Required(ErrorMessage = "Semester selection is required field!")]
public List Course_Id { get; set; }
[Display(Name = "Semester Name")]
[ForeignKey("Semester_Id")]
public virtual Semesters semesterName { get; set; }
[Display(Name = "Semester Name")]
// [Required(ErrorMessage = "Semester selection is required field!")]
public int? Semester_Id { get; set; }
public Boolean is_on_Substitute { get; set; }
public Boolean Active { get; set; }
[Display(Name = "Creation Date")]
[DataType(DataType.Date)]
[DisplayFormat(DataFormatString = "{0:yyyy-MM-dd}", ApplyFormatInEditMode = true)]
public DateTime? Course_Assignment_date { get; set; }
[Display(Name = "Modification Date")]
[DataType(DataType.Date)]
[DisplayFormat(DataFormatString = "{0:yyyy-MM-dd}", ApplyFormatInEditMode = true)]
public DateTime? Date_Modified { get; set; }
public string Added_By { get; set; }
}
My Contorller is :
public ActionResult Index(string sortOrder, string currentFilter, string SearchString, int? page)
{
ViewBag.Course_Id = _ITeacherCoruses.PopulateCourses();
ViewBag.Teacher_Id = _ITeacherCoruses.PopulateTeachers();
ViewBag.Semester_Id = _ITeacherCoruses.PopulateSemsters();
// ViewBag.Teacher_Id = new SelectList(db.Registration, "User_Id", "FirstName");
ViewBag.CurrentSort = sortOrder;
ViewBag.NameSortParm = String.IsNullOrEmpty(sortOrder) ? "name_desc" : "";
ViewBag.DateSortParm = sortOrder == "Date" ? "date_desc" : "Date";
if (SearchString != null)
{
page = 1;
}
else
{
SearchString = currentFilter;
}
ViewBag.CurrentFilter = SearchString;
var dept = from s in db.Teacher_courses
select s;
if (!String.IsNullOrEmpty(SearchString))
{
dept = dept.Where(s => s.course.Course_Name.Contains(SearchString));
// || s.FirstMidName.Contains(searchString));
}
switch (sortOrder)
{
case "name_desc":
dept = dept.OrderByDescending(s => s.course.Course_Name);
break;
case "Date":
dept = dept.OrderBy(s => s.Course_Assignment_date);
break;
case "date_desc":
dept = dept.OrderByDescending(s => s.Course_Assignment_date);
break;
default:
dept = dept.OrderBy(s => s.course.Course_Name);
break;
}
int pageSize = 5;
int pageNumber = (page ?? 1);
// var teacher_courses = db.Teacher_courses.Include(t => t.course).Include(t => t.regs).Include(t => t.semesterName).OrderBy(t=>t.Teacher_Id);
dept = dept.Include(t => t.course).Include(t => t.regs).Include(t => t.semesterName).OrderBy(t => t.Teacher_Id);
return View(dept.ToPagedList(pageNumber, pageSize));
// return View(teacher_courses.ToList());
}
// GET: Teacher_courses/Details/5
public ActionResult Details(int? id)
{
if (id == null)
{
return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
}
Teacher_courses teacher_courses = db.Teacher_courses.Find(id);
if (teacher_courses == null)
{
return HttpNotFound();
}
return View(teacher_courses);
}

// GET: Teacher_courses/Create
public ActionResult Create()

{
ViewBag.Course_Id = _ITeacherCoruses.PopulateCourses();
// ViewBag.Course_Id = new SelectList(db.Courses, "Course_Id", "Course_Name");
//ViewBag.Teacher_Id = new SelectList(db.Registration, "User_Id", "FirstName");
ViewBag.Teacher_Id = _ITeacherCoruses.PopulateTeachers();
ViewBag.Semester_Id = _ITeacherCoruses.PopulateSemsters();
// ViewBag.Semester_Id = new SelectList(db.Semesters, "Semester_Id", "Semester_Title");
return View();
}

// POST: Teacher_courses/Create
// To protect from overposting attacks, please enable the specific properties you want to bind to, for
// more details see https://go.microsoft.com/fwlink/?LinkId=317598.
[HttpPost]
[ValidateAntiForgeryToken]
public ActionResult Create([Bind(Include = "Id,Teacher_Id,Course_Id,Semester_Id,is_on_Substitute,Active,Course_Assignment_date,Date_Modified,Added_By")] Teacher_courses teacher_courses)
{
var Course_Teacher = db.Teacher_courses.ToList().Where(x => x.Course_Id == teacher_courses.Course_Id && x.Teacher_Id==teacher_courses.Teacher_Id).FirstOrDefault();
if (Course_Teacher != null)
{
ModelState.AddModelError("", errorMessage: "course Already Associated with this teacher!");
}
else
{

ViewData["UserName"] = _ILogin.GetUserNamebyUserID(Convert.ToInt32(Session["UserID"]));
if (ModelState.IsValid)
{
teacher_courses.Added_By = ViewData["UserName"].ToString();
db.Teacher_courses.Add(teacher_courses);
if (db.SaveChanges() > 0)
{
TempData["MessageRegistration"] = "Course Assigned Successfully!";
return RedirectToAction("Index");
}
return RedirectToAction("Create");
}
}
ViewBag.Course_Id = _ITeacherCoruses.PopulateCourses();
// ViewBag.Course_Id = new SelectList(db.Courses, "Course_Id", "Course_Name", teacher_courses.Course_Id);
// ViewBag.Teacher_Id = new SelectList(db.Registration, "User_Id", "FirstName", teacher_courses.Teacher_Id);
ViewBag.Teacher_Id = _ITeacherCoruses.PopulateTeachers();
ViewBag.Semester_Id = _ITeacherCoruses.PopulateSemsters();
// ViewBag.Semester_Id = new SelectList(db.Semesters, "Semester_Id", "Semester_Title", teacher_courses.Semester_Id);
return View(teacher_courses);
}
// GET: Teacher_courses/Edit/5
public ActionResult Edit(int? id)
{
if (id == null)
{
return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
}
Teacher_courses teacher_courses = db.Teacher_courses.Find(id);
if (teacher_courses == null)
{
return HttpNotFound();
}
ViewBag.Course_Id = _ITeacherCoruses.PopulateCourses();
// ViewBag.Course_Id = new SelectList(db.Courses, "Course_Id", "Course_Name", teacher_courses.Course_Id);
// ViewBag.Teacher_Id = new SelectList(db.Registration, "User_Id", "FirstName", teacher_courses.Teacher_Id);
ViewBag.Teacher_Id = _ITeacherCoruses.PopulateTeachers();
ViewBag.Semester_Id = _ITeacherCoruses.PopulateSemsters();
//ViewBag.Semester_Id = new SelectList(db.Semesters, "Semester_Id", "Semester_Title", teacher_courses.Semester_Id);
return View(teacher_courses);
}
// POST: Teacher_courses/Edit/5
// To protect from overposting attacks, please enable the specific properties you want to bind to, for
// more details see https://go.microsoft.com/fwlink/?LinkId=317598.
[HttpPost]
[ValidateAntiForgeryToken]
public ActionResult Edit([Bind(Include = "Id,Teacher_Id,Course_Id,Semester_Id,is_on_Substitute,Active,Course_Assignment_date,Date_Modified,Added_By")] Teacher_courses teacher_courses)
{
if (ModelState.IsValid)
{
db.Entry(teacher_courses).State = EntityState.Modified;
if (db.SaveChanges() > 0)
{
TempData["UpdatedMessage"] = "Updated Successfully";
}
//db.SaveChanges();
return RedirectToAction("Index");
}
ViewBag.Course_Id = _ITeacherCoruses.PopulateCourses();
// ViewBag.Course_Id = new SelectList(db.Courses, "Course_Id", "Course_Name", teacher_courses.Course_Id);
// ViewBag.Teacher_Id = new SelectList(db.Registration, "User_Id", "FirstName", teacher_courses.Teacher_Id);
ViewBag.Teacher_Id = _ITeacherCoruses.PopulateTeachers();
ViewBag.Semester_Id = _ITeacherCoruses.PopulateSemsters();
// ViewBag.Semester_Id = new SelectList(db.Semesters, "Semester_Id", "Semester_Title", teacher_courses.Semester_Id);
return View(teacher_courses);
}

// GET: Teacher_courses/Delete/5
public ActionResult Delete(int? id)
{
if (id == null)
{
return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
}
Teacher_courses teacher_courses = db.Teacher_courses.Find(id);
if (teacher_courses == null)
{
return HttpNotFound();
}
return View(teacher_courses);
}

// POST: Teacher_courses/Delete/5
[HttpPost, ActionName("Delete")]
[ValidateAntiForgeryToken]
public ActionResult DeleteConfirmed(int id)
{
Teacher_courses teacher_courses = db.Teacher_courses.Find(id);
db.Teacher_courses.Remove(teacher_courses);
if (db.SaveChanges() > 0)
{
TempData["DeleteDepartment"] = "The Selected Courses has been Un-Assigned to the teacher successfully!";
}
// db.SaveChanges();
return RedirectToAction("Index");
}

protected override void Dispose(bool disposing)
{
if (disposing)
{
db.Dispose();
}
base.Dispose(disposing);
}
0
Mark Tabor6y ago
I have removed the foreign key relationship from database level but i am getting below error message

My Model class is below

public class Teacher_courses
{
[Key]
[Display(Name = " ID")]
public int Id { get; set; }
[Display(Name = "Teacher Name")]
[ForeignKey("Teacher_Id")]
public virtual Registration regs { get; set; }
[Display(Name = "Teacher Name")]
// [Required(ErrorMessage = "Semester selection is required field!")]
public List Teacher_Id { get; set; }
[Display(Name = "Course Name")]
[ForeignKey("Course_Id")]
public virtual Courses course { get; set; }
[Display(Name = "Teacher Name")]
// [Required(ErrorMessage = "Semester selection is required field!")]
public List Course_Id { get; set; }
[Display(Name = "Semester Name")]
[ForeignKey("Semester_Id")]
public virtual Semesters semesterName { get; set; }
[Display(Name = "Semester Name")]
// [Required(ErrorMessage = "Semester selection is required field!")]
public int? Semester_Id { get; set; }
public Boolean is_on_Substitute { get; set; }
public Boolean Active { get; set; }
[Display(Name = "Creation Date")]
[DataType(DataType.Date)]
[DisplayFormat(DataFormatString = "{0:yyyy-MM-dd}", ApplyFormatInEditMode = true)]
public DateTime? Course_Assignment_date { get; set; }
[Display(Name = "Modification Date")]
[DataType(DataType.Date)]
[DisplayFormat(DataFormatString = "{0:yyyy-MM-dd}", ApplyFormatInEditMode = true)]
public DateTime? Date_Modified { get; set; }
public string Added_By { get; set; }
}
0
Veerendra Annigere6y ago
Your Model should be like this.
public class YourMainModel
    {
        public List TeachersList { get; set; }
        public List CoursesList { get; set; }
        public int semesterId { get; set; }
        public bool isOnSubtitle { get; set; }
        public DateTime CreatedDate { get; set; }
        public DateTime ModifiedDate { get; set; }
    }

public class Teachers
    {
        public int TeacherId { get; set; }
    }

public class Courses
    {
        public int CoursesId { get; set; }
    }
0
Mark Tabor6y ago
when i make it array then it give this below error
"
The ForeignKeyAttribute on property 'course' on type 'CMS_Monitoring.Models.Teacher_courses' is not valid. The foreign key name 'Course_Id' was not found on the dependent type 'CMS_Monitoring.Models.Teacher_courses'. The Name value should be a comma separated list of foreign key property names.
0
Ashutosh Gupta6y ago
you can pass array into controller

[HttpPost]
public void Save(int[] teacherids)
{
// add your loop here. and save one by one.
}
0
Mark Tabor6y ago
i am already having foreign key there but i do not know how to save them one by one as in my model i am having teacher-id and course-id as int type not array type so how to send the array of courses and teachers to the controller , and how to apply the looping to saving the four rows
0
Ashutosh Gupta6y ago
Mark,

first make sure you make foreign key as teacher + course Id together, so that same teacher id can used for other coures.

then when you select teacher and course from dropdown, you can use selectedItem to split(',') and save one by one into data base.
+1