无法使用jQuery Ajax在ASP.NET MVC 5中插入数据库中

Question

我无法弄清楚我的代码中有什么错误。我已经仔细检查了一下，并试图将数据插入SQL Server数据库中。但是，每次在提交表单时显示"内部服务器错误"。请帮助我找出。谢谢

这是我的代码..

数据库表：

CREATE TABLE [dbo].[Doctor] 
(
    [DoctorID]        INT IDENTITY (1, 1) NOT NULL,
    [DoctorCardID]    AS ('DOC' + RIGHT('000' + CONVERT (VARCHAR (3), [DoctorID]), (3))),
    [DoctorName]      VARCHAR(50)  NOT NULL,
    [Gender]          VARCHAR(20)  NOT NULL,
    [ContactNumber]   VARCHAR(11)  NOT NULL,
    [DoctorAvatar]    VARCHAR(500) NULL,
    [Dob]             DATE         NULL,
    [Address]         VARCHAR(50)  NULL,
    [City]            VARCHAR(50)  NULL,
    [ZipCode]         NCHAR(10)    NULL,
    [QualificationID] INT          NULL,
    [SpecialityID]    INT          NULL,
    [JoiningDate]     DATETIME     NOT NULL,
    [AddeddDate]      DATE         NULL,
    [IsActive]        BIT          DEFAULT ((1)) NULL,
    PRIMARY KEY CLUSTERED ([DoctorID] ASC),
    FOREIGN KEY ([QualificationID]) 
        REFERENCES [dbo].[Qualification] ([QualificationID]),
    FOREIGN KEY ([SpecialityID]) 
        REFERENCES [dbo].[Speciality] ([SpecialityID])
);

jQuery和Ajax代码：

$('#doctor-submit').click(function(e) {
                e.preventDefault();
                var data = JSON.stringify({
                        DoctorName: $('#DoctorName').val(),
                        Gender: $('#Gender').val(),
                        ContactNumber: $('#ContactNumber').val(),
                        Dob: $('#Dob').val(),
                        Address: $('#Address').val(),
                        City: $('#City').val(),
                        ZipCode: $('#ZipCode').val(),
                        QualificationID: $('#QualificationID').val(),
                        SpecialityID: $('#SpecialityID').val(),
                        JoiningDate: $('#JoiningDate').val(),
                        AddeddDate: $('#AddeddDate').val(),
                        IsActive: $('#IsActive').val()
                });
                $.ajax({
                    url: "@Url.Action("Create", "Doctor")",
                    type: "POST",
                    data: data,
                    processData : false,
                    contentType: "application/json; charset=utf-8",
                    dataType:"json",
                    cache:false,
                    success: function (response) {
                        $('#show-success').show();
                    }
                });
            });

asp.net MVC表格：

<form id="DoctorForm" enctype="multipart/form-data">
    @Html.AntiForgeryToken()
    <div class="form-horizontal">
        <h4>Doctor</h4>
        <hr />
        @Html.ValidationSummary(true, "", new { @class = "text-danger" })
        <div class="row">
            <div class="col-md-6">
                <div class="form-group">
                    @Html.LabelFor(model => model.DoctorName, htmlAttributes: new { @class = "control-label col-md-4" })
                    <div class="col-md-8">
                        @Html.EditorFor(model => model.DoctorName, new { htmlAttributes = new { @class = "form-control", @id = "DoctorName" } })
                        @Html.ValidationMessageFor(model => model.DoctorName, "", new { @class = "text-danger" })
                    </div>
                </div>
                <div class="form-group">
                    @Html.LabelFor(model => model.Gender, htmlAttributes: new { @class = "control-label col-md-4" })
                    <div class="col-md-8">
                        @Html.EditorFor(model => model.Gender, new { htmlAttributes = new { @class = "form-control", @id = "Gender" } })
                        @Html.ValidationMessageFor(model => model.Gender, "", new { @class = "text-danger" })
                    </div>
                </div>
                <div class="form-group">
                    @Html.LabelFor(model => model.ContactNumber, htmlAttributes: new { @class = "control-label col-md-4" })
                    <div class="col-md-8">
                        @Html.EditorFor(model => model.ContactNumber, new { htmlAttributes = new { @class = "form-control", @id = "ContactNumber" } })
                        @Html.ValidationMessageFor(model => model.ContactNumber, "", new { @class = "text-danger" })
                    </div>
                </div>
                <div class="form-group">
                    @Html.LabelFor(model => model.Dob, htmlAttributes: new { @class = "control-label col-md-4" })
                    <div class="col-md-8">
                        @Html.EditorFor(model => model.Dob, new { htmlAttributes = new { @class = "form-control", @id = "Dob" } })
                        @Html.ValidationMessageFor(model => model.Dob, "", new { @class = "text-danger" })
                    </div>
                </div>
                <div class="form-group">
                    @Html.LabelFor(model => model.Address, htmlAttributes: new { @class = "control-label col-md-4" })
                    <div class="col-md-8">
                        @Html.EditorFor(model => model.Address, new { htmlAttributes = new { @class = "form-control", @id = "Address" } })
                        @Html.ValidationMessageFor(model => model.Address, "", new { @class = "text-danger" })
                    </div>
                </div>
                <div class="form-group">
                    @Html.LabelFor(model => model.City, htmlAttributes: new { @class = "control-label col-md-4" })
                    <div class="col-md-8">
                        @Html.EditorFor(model => model.City, new { htmlAttributes = new { @class = "form-control", @id = "City" } })
                        @Html.ValidationMessageFor(model => model.City, "", new { @class = "text-danger" })
                    </div>
                </div>
                <div class="form-group">
                    @Html.LabelFor(model => model.ZipCode, htmlAttributes: new { @class = "control-label col-md-4" })
                    <div class="col-md-8">
                        @Html.EditorFor(model => model.ZipCode, new { htmlAttributes = new { @class = "form-control", @id = "ZipCode" } })
                        @Html.ValidationMessageFor(model => model.ZipCode, "", new { @class = "text-danger" })
                    </div>
                </div>
                <div class="form-group">
                    @Html.LabelFor(model => model.QualificationID, "QualificationID", htmlAttributes: new { @class = "control-label col-md-4" })
                    <div class="col-md-8">
                        @Html.DropDownList("QualificationID", null, htmlAttributes: new { @class = "form-control", @id = "QualificationID" })
                        @Html.ValidationMessageFor(model => model.QualificationID, "", new { @class = "text-danger" })
                    </div>
                </div>
                <div class="form-group">
                    @Html.LabelFor(model => model.SpecialityID, "SpecialityID", htmlAttributes: new { @class = "control-label col-md-4" })
                    <div class="col-md-8">
                        @Html.DropDownList("SpecialityID", null, htmlAttributes: new { @class = "form-control", @id = "SpecialityID" })
                        @Html.ValidationMessageFor(model => model.SpecialityID, "", new { @class = "text-danger" })
                    </div>
                </div>
                <div class="form-group">
                    @Html.LabelFor(model => model.JoiningDate, htmlAttributes: new { @class = "control-label col-md-4" })
                    <div class="col-md-8">
                        @Html.EditorFor(model => model.JoiningDate, new { htmlAttributes = new { @class = "form-control", @id = "JoiningDate" } })
                        @Html.ValidationMessageFor(model => model.JoiningDate, "", new { @class = "text-danger" })
                    </div>
                </div>
                <div class="form-group">
                    @Html.LabelFor(model => model.AddeddDate, htmlAttributes: new { @class = "control-label col-md-4" })
                    <div class="col-md-8">
                        @Html.EditorFor(model => model.AddeddDate, new { htmlAttributes = new { @class = "form-control", @id = "AddeddDate" } })
                        @Html.ValidationMessageFor(model => model.AddeddDate, "", new { @class = "text-danger" })
                    </div>
                </div>
                <div class="form-group">
                    @Html.LabelFor(model => model.IsActive, htmlAttributes: new { @class = "control-label col-md-4" })
                    <div class="col-md-8">
                        <div class="checkbox">
                            @Html.EditorFor(model => model.IsActive, new { @id = "IsActive" })
                            @Html.ValidationMessageFor(model => model.IsActive, "", new { @class = "text-danger" })
                        </div>
                    </div>
                </div>
                <div class="form-group">
                    <div class="col-md-offset-2 col-md-10">
                        <input id="doctor-submit" type="submit" value="Create" class="btn btn-default" />
                    </div>
                </div>
            </div>
            <div class="col-md-3">
                <div class="form-group">
                    <div class="col-md-12">
                        <img src="~/Content/images/man.jpg" id="processImage" class="process-image img-responsive" />
                        <div class="upload-box">
                            <input id="imageFile" name="ImageUpload" type="file" accept="image/jpeg, image/png" alt="Photo" class="image-file" />
                            <div class="upload-icon">
                                <i class="menu-icon fa fa-upload"></i> Upload
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
</form>
<div id="show-success" class="success-save alert alert-block alert-success">
    <button type="button" class="close" data-dismiss="alert">
        <i class="ace-icon fa fa-times"></i>
    </button>
    <p>
        <strong>
            <i class="ace-icon fa fa-check"></i>
            Well done!
        </strong>
        Doctor Save successfully!
    </p>
</div>
<div>
    @Html.ActionLink("Back to List", "Index")
</div>

控制器代码：

[HttpPost]
[ValidateAntiForgeryToken]
public ActionResult Create( Doctor doctor)
{
    if (ModelState.IsValid)
    {
        if (doctor.ImageUpload != null)
        {
            string filename = Path.GetFileNameWithoutExtension(doctor.ImageUpload.FileName);
            string extension = Path.GetExtension(doctor.ImageUpload.FileName);
            filename = filename + DateTime.Now.ToString("yymmssfff") + extension;
            doctor.DoctorAvatar = "~/Content/images/DoctorsImg/" + filename;
            doctor.ImageUpload.SaveAs(Path.Combine(Server.MapPath("~/Content/images/DoctorsImg"), filename));
        }
        db.Doctors.Add(doctor);
        db.SaveChanges();
        return RedirectToAction("Index", "Doctor");
    }
    ViewBag.QualificationID = new SelectList(db.Qualifications, "QualificationID", "QualificationName", doctor.QualificationID);
    ViewBag.SpecialityID = new SelectList(db.Specialities, "SpecialityID", "SpecialityTag", doctor.SpecialityID);
    return Json(new { success = true });
}

Answer 1

我认为问题在于 valiantiforgerytoken 您没有提交表单。您正在提出AJAX请求，因此反伪造令牌验证失败。删除此并重试。