HelloI have a screen which has 2 parts 1 part relates to one table and the other part relates to another table which has an ID field in commonMy models are as belowpublic class iwdheader Key public string iwdno get set public NullableltDateTimegt iwddt get set public string iwdreferenceno get set public string iwdsentby get set public string iwdremarks get set public string ecgcbranchcd get set public string iwdaddr

Save data to multiple Tables using Single Model (ViewModel) in ASP.Net MVC

bistgene...

SOLVED CLOSED ACTIVE ANSWERED
User: bistgeneral
Posted: on Dec 21, 2022 03:04 AM
Forum: ASP.Net MVC
Answer: 1
Views: 2454
Sample Code: Download

Hello,

I have a screen which has 2 parts, 1 part relates to one table and the other part relates to another table which has an ID field in common.

My models are as below

public class iwd_header
{
    [Key]
    public string iwd_no { get; set; }
    public Nullable<DateTime> iwd_dt { get; set; }
    public string iwd_reference_no { get; set; }
    public string iwd_sent_by { get; set; }
    public string iwd_remarks { get; set; }
    public string ecgc_branch_cd { get; set; }
    public string iwd_address { get; set; }
    public Nullable<DateTime> ent_dt { get; set; }
    public Nullable<DateTime> Ltr_dt { get; set; }
    public string chq_no { get; set; }
    public Nullable<DateTime> chq_dt { get; set; }
    public decimal chq_amt { get; set; }
}

public class iwd_dtl
{
    public string Iwd_Item_No { get; set; }
    public string Iwd_Doc_Type { get; set; }
    public string Iwd_Status { get; set; }
    public string Iwd_Dept { get; set; }
    public string Comments { get; set; }
    public string Iwd_No { get; set; }
    public string Region { get; set; }
    public string Doc_Language { get; set; }
    public string Dispatch_Mode { get; set; }
}

I have created a viewmodel to show the form to user.

public class InwardVM
{
    public List<iwd_header> iwd_header { get; set; }
    public List<iwd_dtl> Iwd_Dtl { get; set; }
}

Now I want to save data when the user clicks on Save button.

I have no idea how to write the action method in controller to take data from this viewmodel and insert into respective tables.

Kindly guide.

Regards

Download FREE API for Word, Excel and PDF in ASP.Net

dharmend...

0 4

Reply
ANSWER
User: dharmendr
Replied: on Dec 22, 2022 12:14 AM
Report

Hi bistgeneral,

Refer below code.

Model

public class ProductTypeViewModel
{
    public ProductInfo ProductModel { get; set; }
    public ProductType TypeModel { get; set; }
}

public class ProductType
{
    public int TypeID { get; set; }
    public string TypeName { get; set; }
}

public class ProductInfo
{
    public string ProName { get; set; }
    public int ProID { get; set; }
}

Controller

public class HomeController : Controller
{
    // GET: Home
    public ActionResult Index()
    {
        ProductTypeViewModel productViewModel = new ProductTypeViewModel();
        return View(productViewModel);
    }

    [HttpPost]
    public ActionResult Index(ProductTypeViewModel productViewModel)
    {
        ProductType type = productViewModel.TypeModel;
        //Insert type.

        ProductInfo infor = productViewModel.ProductModel;
        //Insert the Product.

        return View(productViewModel);
    }
}

View

@model Multiple_Table_Insert_ViewModel.Models.ProductTypeViewModel
@{
    Layout = null;
}

<!DOCTYPE html>

<html>
<head>
    <meta name="viewport" content="width=device-width" />
    <title>Index</title>
    <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.2/css/bootstrap.min.css" />
</head>
<body>
    @using (Html.BeginForm("Index", "Home", FormMethod.Post))
    {
        <div class="form-horizontal">
            <div class="form-group">
                @Html.LabelFor(model => model.ProductModel.ProID, new { @class = "control-label col-md-2" })
                <div class="col-md-10">
                    @Html.TextBoxFor(model => model.ProductModel.ProID, "", new { @class = "form-control" })
                </div>
            </div>
            <div class="form-group">
                @Html.LabelFor(model => model.ProductModel.ProName, new { @class = "control-label col-md-2" })
                <div class="col-md-10">
                    @Html.TextBoxFor(model => model.ProductModel.ProName, "", new { @class = "form-control" })
                </div>
            </div>
            <div class="form-group">
                @Html.LabelFor(model => model.TypeModel.TypeID, new { @class = "control-label col-md-2" })
                <div class="col-md-10">
                    @Html.TextBoxFor(model => model.TypeModel.TypeID, "", new { @class = "form-control" })
                </div>
            </div>
            <div class="form-group">
                @Html.LabelFor(model => model.TypeModel.TypeName, new { @class = "control-label col-md-2" })
                <div class="col-md-10">
                    @Html.TextBoxFor(model => model.TypeModel.TypeName, "", new { @class = "form-control" })
                </div>
            </div>
            <div class="form-group">
                <div class="col-md-offset-2 col-md-10">
                    <input type="submit" value="Insert" class="btn btn-default" />
                </div>
            </div>
        </div>
    }
</body>
</html>

Screenshot

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Save data to multiple Tables using Single Model (ViewModel) in ASP.Net MVC

Company

Explore

Follow us

Contact Us