How to save items of field list table in database in controller post method?

Question

0.00/5 (No votes)

See more:

I am working student issue book form.in that i am getting values,i have field list table in which i added multiple books of a particular student,when i am submitting it is saving only single book.In database i have create multiple columns to save book id's of each book in each column.how to solve this.
here is my controller post method

What I have tried:

[HttpPost]
public ActionResult Create(Student_Issue_Book Student_Issue_BookObj)
{
var rollNoRecord = db.Student_Issue_Book.FirstOrDefault(a => a.Delete_Flag == false && a.Issue_Return_Id == Student_Issue_BookObj.Issue_Return_Id );
if (rollNoRecord == null)
{
Student_Issue_BookObj.Last_Updated_By = CurrentUserID;
Student_Issue_BookObj.Last_Updated_Date = DateTime.Now.ToUniversalTime();
Student_Issue_BookObj.Created_By = CurrentUserID;
Student_Issue_BookObj.Creation_Date = DateTime.Now.ToUniversalTime();
// ViewBag.EMPLOYEE_ID = new SelectList(db.Student_Registration, "Registration_Id", "Student_First_Name");
if (_CRUDrepository.CreateNewObject(Student_Issue_BookObj))
{
return RedirectToAction("Index");
}
}
FillViewBag();

ModelState.AddModelError("", "This book is not there in library.");
return View();
}

Posted 13-Mar-16 21:20pm

Hussain Javed

Updated 9-Apr-16 21:35pm

Add a Solution

Comments

[no name] 14-Mar-16 3:40am

In code snippet where did you set bookids for a student?

Hussain Javed 14-Mar-16 4:33am

by using this code i am able to store only one book id in database,how to save multiple book id's in database.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maheshbhushan_Kshirsagar · Answer 1 · 2016-04-09T21:35:00

For posting multiple or list of books your Model should hold list.

What i mean is use collections for Model

e.g.

C#

public class Book
    {
        public int ID { get; set; }
        public string Name { get; set; }
    }


    public class BookViewModel
    {
        List<Book> Books { get; set; }
    }

i.e your model =BookViewModel