English 中文(简体)
如何通过MVC 3 插入 And EF Code-first
原标题:how to do batch insert through MVC 3 And EF code-first

I am trying to build a employee attendance sheet.
Here is my AttendanceModel

public class AttendanceModel 
{
    //Primary Key and auto-generated field for this model
    public int AttendanceID { get; set; }

    public DateTime AttendanceDate { get; set; }

    //Present/Absent status
    public bool Status { get; set;}

    //Primary key of Employee Model
    public int EmployeeID { get; set; }

    //Reference to Employee Model
    public Employee Employee { get; set; }

}

Now I want this model to make a View containing employeeId(Hidden field) , Name of Employee and a checkbox for attendance.
My problem is (Edited on 3rd day)

  1. Should i have to use a different ViewModel for this view
  2. How to insert the information from view to the entity and ultimately to databse as it require more than one row to be inserted in the database (i.e Batch Processing)
  3. I am also not getting how to retrieve the information from the view to do processing

Any suggestion is appreciable. :)
Thanks in Advance !!!
*EDIT (What i have tried) * 1. I have created another class AttendanceViewModel containing all the field of AttendanceModel except the reference to Employee model class. then in view I render it. In the controller the argument is IEnumerable<AttendanceViewModel> and from it populate the Attendance Model. Here is the code.

public ActionResult Index()
    {            
        var EmployeeAttendance = from s in new EmployeeDBContext().Employees
                                select new AttendanceViewModel
                                {
                                    EmployeeID = s.EmployeeID
                                };
        return View(EmployeeAttendance.ToList());
    }

主计长为节省记录而采取的行动

 [HttpPost]
    public ActionResult SaveAttendance(IEnumerable<AttendanceViewModel> attendancess)    // argument of SaveAttendance is always `null`
    {

            if (ModelState.IsValid)
            {
                var _context = new EmployeeDBContext();

                foreach (var a in attendancess)
                {
                    var newAttendance = new AttendanceModel
                    {
                        EmployeeID = a.EmployeeID,
                        AttendanceStatus = a.Status
                    };

                    _context.Attendance.Add(newAttendance);

                }
                _context.SaveChanges();
            }
           //Rest of code

但是,其并非工作理由总是null:

最佳回答

如果您寄出更多资料,以控制您将不得不将价值设定为隐蔽的输入领域,如雇员。 同上。 或者,通过在届会中添加标语,你可以同时存储额外财产。

你们必须使用“<代码>List<int>”;在GisModel使用“制片”财产。 并鉴于您确定了雇员的价值 检查箱值。

<input type="checkbox" name="CheckedEmpIds" value="@Model.Employee.Id" />

当你提交表格时,可以让被检查的雇员女佣采取行动。

问题回答

暂无回答




相关问题
what is wrong with this mysql code

$db_user="root"; $db_host="localhost"; $db_password="root"; $db_name = "fayer"; $conn = mysqli_connect($db_host,$db_user,$db_password,$db_name) or die ("couldn t connect to server"); // perform query ...

Users asking for denormalized database

I am in the early stages of developing a database-driven system and the largest part of the system revolves around an inheritance type of relationship. There is a parent entity with about 10 columns ...

Easiest way to deal with sample data in Java web apps?

I m writing a Java web app in my free time to learn more about development. I m using the Stripes framework and eventually intend to use hibernate and MySQL For the moment, whilst creating the pages ...

join across databases with nhibernate

I am trying to join two tables that reside in two different databases. Every time, I try to join I get the following error: An association from the table xxx refers to an unmapped class. If the ...

How can I know if such value exists in database? (ADO.NET)

For example, I have a table, and there is a column named Tags . I want to know if value programming exists in this column. How can I do this in ADO.NET? I did this: OleDbCommand cmd = new ...

Convert date to string upon saving a doctrine record

I m trying to migrate one of my PHP projects to Doctrine. I ve never used it before so there are a few things I don t understand. In my current code, I have a class similar to this: class ...

热门标签