Greetings all, Brief Description: I am working on an Inventory Management system, which focuses on tracking items by S/N, shipments In/Out, & service history. I am building this via Visual Studio in C# MVC ASP.NET. I currently have a working system, with the basic CRUD as well as some more advanced Logic CRUD. The part I am bogged down on now is the process of taking multiple lines of user entered data from a View/Form and then writing that to a table. I have done extensive searches on G00gle, SO, CodeProject, MSDN, etc. All have viable examples, but none that quite fit my scenario. Everything seems to be related to pulling data already in a table to write it to a view, whereas I want to do just the opposite. Here is the Scenario: One of my Views is a page that allows a user to create a new Transfer. This is an Inbound/Outbound shipment, which will list the units/items that are Inbound/Outbound. The user will enter certain specific information as well as create a listing of all the items currently associated with that shipment number. On this form, I have built a dynamic feature that will allow a user to add lines to the form on the fly. Once the user has entered all the items, I want to gather all of the item information and then write it to a table in the DB. To my understanding, this needs to be done with a List, but this is where I am stuck. The Code Blocks: **-- RXDoc Data Table** ``` public class RXDoc { public int Id { get; set; } [ForeignKey("TransferId")] [Display(Name = "TRK #")] public ItemTransfer? ItemTransfer { get; set; } public int TransferId { get; set; } //public string TransferNumber { get; set; } // This STRING to be set as the MT# in the EXCEL SHEET cellR1->U2 //[Required] [ForeignKey("ClientId")] [Display(Name = "Client")] public Client? Client { get; set; } public int ClientId { get; set; } //public string ClientName { get; set; } // This STRING to be set as the CLIENT NAME (CONSIGNEE/RECIPIENT) in EXCEL SHEET cellN3->V3 //// TO address of RECIPIENT/CONSIGNEE public string? AddressLine1 { get; set; } public string? AddressLine2 { get; set; } public string? AddressLine3 { get; set; } public string? AddressLine4 { get; set; } public string? AddressLine5 { get; set; } [Display(Name = "Ship Date")] [DataType(DataType.Date)] public DateTime? ShipDate { get; set; } // date of creation [Display(Name = "Our Ref#")] public string? OurRefNum { get; set; } [Display(Name = "Ship Via")] public string? CourierName { get; set; } [Display(Name = "TRK #")] public string? CourierTrkNum { get; set; } [Display(Name = "PO #")] public string? PONumber { get; set; } [Display(Name = "Ref #")] public string? ClientRefNum { get; set; } [Display(Name = "# Items Shipped")] public int? TotalItems { get; set; } [Display(Name = "# Units Shipped")] public int? TotalUnits { get; set; } // The total units released i.e. # of pallets in shipment [Display(Name = "Unit Type")] public string? UnitType { get; set; } // PAL, CRT, BOX, CON, SKD, UNIT, etc. [Display(Name = "Shipped by")] public string? ShipperName { get; set; } [Display(Name = "Received by")] public string? DriverName { get; set; } [Display(Name = "Release Date")] public string? ReleaseDate { get; set; } // date of shipment leaving facility public int? BoxNumber { get; set; } public int? Qty { get; set; } public string? PartNumber { get; set; } public string? Description { get; set; } public string? SerialNumber { get; set; } public string? Notes { get; set; } } ``` **-- RXCreateVM Model** ``` public class RXCreateVM { public int Id { get; set; } [ForeignKey("TransferId")] [Display(Name = "TRK #")] public ItemTransfer? ItemTransfer { get; set; } public int TransferId { get; set; } public string TransferNumber { get; set; } // This STRING to be set as the MT# in the EXCEL SHEET cellR1->U2 //[Required] [ForeignKey("ClientId")] [Display(Name = "Client")] public Client? Client { get; set; } public int ClientId { get; set; } public string ClientName { get; set; } // This STRING to be set as the CLIENT NAME (CONSIGNEE/RECIPIENT) in EXCEL SHEET cellN3->V3 //// TO address of RECIPIENT/CONSIGNEE public string? AddressLine1 { get; set; } public string? AddressLine2 { get; set; } public string? AddressLine3 { get; set; } public string? AddressLine4 { get; set; } public string? AddressLine5 { get; set; } [Display(Name = "Ship Date")] [DataType(DataType.Date)] public DateTime? ShipDate { get; set; } // date of creation [Display(Name = "Our Ref#")] public string? OurRefNum { get; set; } [Display(Name = "Ship Via")] public string? CourierName { get; set; } [Display(Name = "TRK #")] public string? CourierTrkNum { get; set; } [Display(Name = "PO #")] public string? PONumber { get; set; } [Display(Name = "Ref #")] public string? ClientRefNum { get; set; } [Display(Name = "# Items Shipped")] public int? TotalItems { get; set; } [Display(Name = "# Units Shipped")] public int? TotalUnits { get; set; } // The total units released i.e. # of pallets in shipment [Display(Name = "Unit Type")] public string? UnitType { get; set; } // PAL, CRT, BOX, CON, SKD, UNIT, etc. [Display(Name = "Shipped by")] public string? ShipperName { get; set; } [Display(Name = "Received by")] public string? DriverName { get; set; } [Display(Name = "Release Date")] public string? ReleaseDate { get; set; } // date of shipment leaving facility public int? Qty { get; set; } public int? BoxNumber { get; set; } public string? PartNumber { get; set; } public string? Description { get; set; } public string? SerialNumber { get; set; } public string? Notes { get; set; } public List RXList { get; set; } public Client Clients { get; set; } } ``` **-- RXCreate View** The javascript codeblock, at the bottom, handles the dynamic add/remove of the rows in the View ``` @model RXCreateVM @{ ViewData["Title"] = "Create"; }

New INCOMING Shipment

Ship Date

Transfer #

Our REF #

Ship VIA

TRK #

Client PO #

Client REF #

BOX	QTY	P/N	DESCRIPTION	S/N	NOTES

@section Scripts { } ``` **-- Controller** ``` public async Task RXDOC() { var prefixR = "R"; var transfersList = await _context.ItemTransfers.Include(q => q.Client).Where(x => x.TrackingNumber.StartsWith(prefixR)).OrderByDescending(x => x.TrackingNumber).ToListAsync(); var model = new RXTransferVM { TotalShipments = transfersList.Count, RXTransferList = mapper.Map>(transfersList) }; ViewData["ClientId"] = new SelectList(_context.Clients.OrderBy(c => c.Name), "Id", "Name"); ViewData["TransferId"] = new SelectList(_context.ItemTransfers.Where(x => x.TrackingNumber.StartsWith(prefixR)).OrderByDescending(t => t.TrackingNumber), "Id", "TrackingNumber"); return View(model); } public async Task RXCreate() { var prefixR = "R"; var transfersList = await _context.ItemTransfers.Include(q => q.Client).Where(x => x.TrackingNumber.StartsWith(prefixR)).OrderByDescending(x => x.TrackingNumber).ToListAsync(); ViewData["ClientId"] = new SelectList(_context.Clients.OrderBy(c => c.Name), "Id", "Name"); ViewData["TransferId"] = new SelectList(_context.ItemTransfers.Where(x => x.TrackingNumber.StartsWith(prefixR)).OrderByDescending(t => t.TrackingNumber), "Id", "TrackingNumber"); return View(); } [HttpPost] public async Task RXCreate(List rxdocVM) { var prefixR = "R"; var transfersList = await _context.ItemTransfers.Include(q => q.Client).Where(x => x.TrackingNumber.StartsWith(prefixR)).OrderByDescending(x => x.TrackingNumber).ToListAsync(); //var clientName = await _context.Clients.FindAsync(rxdocVM.ClientId); var itemsList = new List(); var newTransfer = mapper.Map(rxdocVM); _context.RXDocs.Add(newTransfer); await _context.SaveChangesAsync(); return RedirectToAction(nameof(Index)); //ViewData["ClientId"] = new SelectList(_context.Clients.OrderBy(c => c.Name), "Id", "Name"); //ViewData["TransferId"] = new SelectList(_context.ItemTransfers.Where(x => x.TrackingNumber.StartsWith(prefixR)).OrderByDescending(t => t.TrackingNumber), "Id", "TrackingNumber"); //return View(); } ``` At this point, the code works, but will only add the first row to the DB table, even if other rows are filled in. I have attempted different variations of examples I have found on SO, MSDN, CodeProject, and other sites... all of which illustrate using a List<>. This is the point where I am getting stuck. The last attempt I made at using the List resulted in various 'not working' scenarios. Here is a sample block that I tried: ``` [HttpPost] public async Task RXCreate(RXDoc rxdocVM) { var prefixR = "R"; var transfersList = await _context.ItemTransfers.Include(q => q.Client).Where(x => x.TrackingNumber.StartsWith(prefixR)).OrderByDescending(x => x.TrackingNumber).ToListAsync(); var clientName = await _context.Clients.FindAsync(rxdocVM.ClientId); if (clientName == null) { return View(); } if (ModelState.IsValid) { Console.WriteLine("State: VALID!"); var model = new RXCreateVM { ClientName = clientName.Name, AddressLine1 = rxdocVM.AddressLine1, AddressLine2 = rxdocVM.AddressLine2, AddressLine3 = rxdocVM.AddressLine3, AddressLine4 = rxdocVM.AddressLine4, AddressLine5 = rxdocVM.AddressLine5, ShipDate = rxdocVM.ShipDate, OurRefNum = rxdocVM.OurRefNum, CourierName = rxdocVM.CourierName, CourierTrkNum = rxdocVM.CourierTrkNum, PONumber = rxdocVM.PONumber, ClientRefNum = rxdocVM.ClientRefNum, TotalItems = rxdocVM.TotalItems, TotalUnits = rxdocVM.TotalUnits, UnitType = rxdocVM.UnitType, ShipperName = rxdocVM.ShipperName, DriverName = rxdocVM.DriverName, ReleaseDate = rxdocVM.ReleaseDate, Qty = rxdocVM.Qty, BoxNumber = rxdocVM.BoxNumber, PartNumber = rxdocVM.PartNumber, Description = rxdocVM.Description, SerialNumber = rxdocVM.SerialNumber, Notes = rxdocVM.Notes, RXList = mapper.Map>(rxdocVM) }; var newTransfer = mapper.Map(rxdocVM); _context.RXDocs.Add(newTransfer); await _context.SaveChangesAsync(); return RedirectToAction(nameof(Index)); } ViewData["ClientId"] = new SelectList(_context.Clients.OrderBy(c => c.Name), "Id", "Name"); ViewData["TransferId"] = new SelectList(_context.ItemTransfers.Where(x => x.TrackingNumber.StartsWith(prefixR)).OrderByDescending(t => t.TrackingNumber), "Id", "TrackingNumber"); return View(); } ``` With the above attempt, I get mapping errors, which I assume is because I am calling the method with the Table reference but using the VM as the model. Do I need to restructure the Post Method by declaring it with List of the Table RXDoc or List of the Model RXCreateVM? Does this also mean that I need to change the View's @model statement to use a List of RXCreateVM or List of RXDoc table? This is where I am stuck; trying to figure out how to get the dynamically added rows to be scooped up by the controller once the Save button is clicked. _NOTE_: I know that some of the data fields are not shown in the View, because I have made them Nullable for testing purposes so I don't have to type in all that info each time I test/debug, which is often. (i.e. _The address lines, etc. All other pertinent info is Required and, I think, accounted for_) Any help/insight would be greatly appreciated. Regards, FriQ

friqenstein

C# MVC ASP.NET: Write Multiple Lines from Form to DB Table

Join Our Newsletter. No Spam, Only the good stuff.