質問編集履歴

コード\(View/Controller/Model\)を追加。

2016/08/17 08:22

投稿

_Mar85

スコア13

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -35,3 +35,401 @@
 .NetFramework:4.5
 ツール：Visual Studio2015 Community
+すみません。問題を解決できないのでコードを追加しました。
+例えば、項目"Price"は任意項目ですが、未入力状態でsaveしようとすると、何もエラーも表示されず、DB更新もされない状態です。
+DB更新処理はEntity Framework4.5利用。
+データベースはコードファーストで作成しました。
+```javascript
+View
+<script type="text/javascript">
+function Quotation_save() {
+     // Step 1: Read View Data and Create JSON Object
+        // Creating SalesSub Json Object
+         var quotationsub = {
+             "QuotationId": "", "Line": "", "Grade": "", "Commodity": "", "Size": "", "metrictons": "",
+             "PC": "", "Price_detail": "", "Ideaprice_Offer_Bid_detail": "", "FOB_CFR_CIF_CIP_detail": ""
+         };
+        // Creating SalesMain Json Object
+         var quotationmain = {
+             "QuotationId": "", "Customer": "", "Tender_Nontender": "", "SPOT_REPEAT": "", "TotalVolume": "",
+             "Price": "", "Ideaprice_Offer_Bid": "", "FOB_CFR_CIF_CIP": "", "PaymentTerm": "", "ShippingSchedule": "",
+             "Usage": "", "LoadingPort": "", "DischargingPort": "", "Country": "", "PreferredSupplier": "", "Remarks": "", "MailRecipient_To": "", "MailRecipient_Cc": "", "MailSender": "", "RegisterDate": "", "QuotationSubs": []
+         };
+        // Set Sales Main Value
+        quotationmain.QuotationId = $("#QuotationId").val();
+        quotationmain.Customer = $("#Customer").val();
+        quotationmain.Tender_Nontender = $("#Tender_Nontender").val();
+        quotationmain.SPOT_REPEAT = $("#SPOT_REPEAT").val();
+        quotationmain.TotalVolume = $("#TotalVolume").val();
+        quotationmain.Price = $("#Price").val();
+        quotationmain.Ideaprice_Offer_Bid = $("#Ideaprice_Offer_Bid").val();
+        quotationmain.FOB_CFR_CIF_CIP = $("#FOB_CFR_CIF_CIP").val();
+        quotationmain.PaymentTerm = $("#PaymentTerm").val();
+        quotationmain.ShippingSchedule = $("#ShippingSchedule").val();
+        quotationmain.Usage = $("#Usage").val();
+        quotationmain.LoadingPort = $("#LoadingPort").val();
+        quotationmain.DischargingPort = $("#DischargingPort").val();
+        quotationmain.Country = $("#Country").val();
+        quotationmain.PreferredSupplier = $("#PreferredSupplier").val();
+        quotationmain.Remarks = $("#Remarks").val();
+        quotationmain.MailRecipient_To = $("#MailRecipient_To").val();
+        quotationmain.MailRecipient_Cc = $("#MailRecipient_Cc").val();
+        quotationmain.MailSender = $("#MailSender").val();
+        quotationmain.RegisterDate = $("#RegisterDate").val();
+        // Getting Table Data from where we will fetch Sales Sub Record
+        var oTable = $('.tbl').dataTable().fnGetData();
+        for (var i = 0; i < oTable.length; i++)
+        {
+            // IF This view is for edit then it will read SalesId from Hidden field
+            if ($('h2').text() == "Edit")
+            {
+                quotationsub.QuotationId = $('#QuotationId').val();
+            }
+            else
+            {
+                quotationsub.QuotationId = 0;
+            }
+        }
+        // Step 1: Ends Here
+        // Set 2: Ajax Post
+        // Here i have used ajax post for saving/updating information
+        $.ajax({
+            url: '/QuotationMains/Create',
+            data: JSON.stringify(quotationmain),
+            type: 'POST',
+            contentType: 'application/json;',
+            dataType: 'json',
+            success: function (result) {
+                if (result.Success == "1") {
+                    window.location.href = "/QuotationMains/index";
+                }
+                else {
+                    alert(result.ex);
+                }
+            }
+        });
+    }
+</script>
+@using (Html.BeginForm())
+{
+    @Html.ValidationSummary(true)
+    <fieldset>
+        <legend>Header</legend>
+        @if (Model != null)
+        {
+            <input type="hidden" id="QuotationId" name="SalesId" value="@Model.QuotationId" />
+        }
+        <div class="form-horizontal">
+            <hr />
+            @Html.ValidationSummary(true, "", new { @class = "text-danger" })
+            <div class="form-group">
+                @Html.LabelFor(model => model.Customer, htmlAttributes: new { @class = "control-label col-md-2" })
+                <div class="col-md-10">
+                    @Html.EditorFor(model => model.Customer, new { htmlAttributes = new { @class = "form-control" } })
+                    @Html.ValidationMessageFor(model => model.Customer, "", new { @class = "text-danger" })
+                </div>
+            </div>
+            <div class="form-group">
+                @Html.LabelFor(model => model.TotalVolume, htmlAttributes: new { @class = "control-label col-md-2" })
+                <div class="col-md-10">
+                    @Html.EditorFor(model => model.TotalVolume, new { htmlAttributes = new { @class = "form-control" } })
+                    @Html.ValidationMessageFor(model => model.TotalVolume, "", new { @class = "text-danger" })
+                </div>
+            </div>
+            <div class="form-group">
+                @Html.LabelFor(model => model.Price, htmlAttributes: new { @class = "control-label col-md-2" })
+                <div class="col-md-10">
+                    @Html.EditorFor(model => model.Price, new { htmlAttributes = new { @class = "form-control" } })
+                    @Html.ValidationMessageFor(model => model.Price, "", new { @class = "text-danger" })
+                </div>
+            </div>
+     </div>
+    </fieldset>
+<input type="button" value="Save" onclick="Quotation_save()" />
+}
+```
+```C#
+controller
+[HttpPost]
+        public JsonResult Create(QuotationMain quotationmain)
+        {
+            try
+            {
+                if (ModelState.IsValid)
+                {
+                    if (quotationmain.QuotationId > 0)
+                    {
+                        var CurrentquotationSUb = db.QuotationSubs.Where(p => p.QuotationId == quotationmain.QuotationId);
+                        foreach (QuotationSub ss in CurrentquotationSUb)
+                            db.QuotationSubs.Remove(ss);
+                        foreach (QuotationSub ss in quotationmain.QuotationSubs)
+                            db.QuotationSubs.Add(ss);
+                        db.Entry(quotationmain).State = EntityState.Modified;
+                    }
+                    //Perform Save
+                    else
+                    {
+                        db.QuotatinoMains.Add(quotationmain);
+                    }
+                    db.SaveChanges();
+                    return Json(new { Success = 1, QuotationId = quotationmain.QuotationId, ex = "" });
+                }
+                else
+                {
+                    return Json(new { Success = 1, ex = "ModelState is Invalid" });
+                }
+            }
+            catch (Exception ex)
+            {
+                return Json(new { Success = 0, ex = ex.ToString() });
+            }
+        }
+```
+```C#
+model
+public class QuotationMain
+    {
+        [Key]
+        public int QuotationId { get; set; }
+        [Required]
+        [Display(Name = "Customer", ResourceType = typeof(Quotation3.ModelResource))]
+        public string Customer { get; set; }
+        [Display(Name = "TotalVolume", ResourceType = typeof(Quotation3.ModelResource))]
+        public int? TotalVolume { get; set; }
+        [Display(Name = "Price", ResourceType = typeof(Quotation3.ModelResource))]
+        public int? Price { get; set; }
+        [Required]
+        [EmailAddress]
+        [Display(Name = "MailRecipient_To", ResourceType = typeof(Quotation3.ModelResource))]
+        public string MailRecipient_To { get; set; }
+}
+```