Add/Edit/Delete Screens inside a partial View.
Question
All replies
-
User1312693872 posted
Hi,teenajohn1989
I'm not sure why you create two assets that have the same keys, one staffname often have it's specific id. So that it will be easy to locate and edit it.
May be you have other specific keys to locate?
To edit or delete, you can use ajax, refer to the samples in this link, if you have any problem, welcome to share it.
http://binaryintellect.net/articles/16ecfe49-98df-4305-b53f-2438d836f0d0.aspx
A simple example:
<td> <button type="button" id="edit1">edit</button> | <a asp-page="./Delete">Delete</a> </td> .... <input asp-for="StaffAssets.StaffID" type="hidden" value='@TempData["StaffID"]' />Ajax in main razor view:
$("#edit1").click(function () { $.ajax({ type: "Get", url: "/?handler=EditAssets", dataType: "json", data: { "StaffID": $("#StaffAssets_StaffID").val() }, contentType: "application/json; charset=utf-8", success: function () { } }) });Best Regards,
Jerry Cai
-
User1312693872 posted
Hi,teenajohn1989
Sorry for the delay, you can use modal to finish the edit or delete, it will be more clear:
<div id="displayStaffAssets"> <p> <input type="button" class="btn-success" id="OnClickCreateStaffAsset" value="Create New" /> </p> @if (Model.ShowStaffAssets != null) { <table class="table" border="1" style="width:750px;"> <thead style="background-color:#DC3545"> <tr> <th>@Html.DisplayNameFor(model => model.ShowStaffAssets[0].StaffAssetName)</th> <th>@Html.DisplayNameFor(model => model.ShowStaffAssets[0].IssuedQty)</th> <th>@Html.DisplayNameFor(model => model.ShowStaffAssets[0].IssuedDate)</th> <th></th> </tr> </thead> <tbody> @foreach (var item in Model.ShowStaffAssets) { <tr> <td>@Html.DisplayFor(modelItem => item.StaffAssetName)</td> <td>@Html.DisplayFor(modelItem => item.IssuedQty)</td> <td>@Html.DisplayFor(modelItem => item.IssuedDate)</td> <td> <a data-toggle="modal" data-target="#myModal_@item.StaffAssetName">|Edit</a> <a asp-page="./Delete">Delete</a> <div id="myModal_@item.StaffAssetName" class="modal fade" role="dialog"> <div class="modal-dialog"> <!-- Modal content--> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal">×</button> </div> <div class="modal-body"> <form method="post" asp-page-handler="EditAssetsDetails"> <input asp-for="StaffAssets.StaffID" type="hidden" value='@TempData["StaffID"]' /> <input asp-for="StaffAssets.EmpID" type="hidden" value='@TempData["EmpID"]' /> <!-- Asset Name --> <div class="form-group"> <label asp-for="StaffAssets.StaffAssetName" class="control-label-staff"></label> <input asp-for="StaffAssets.StaffAssetName" value="@item.StaffAssetName" class="form-control-staff"/> <br /> <span asp-validation-for="StaffAssets.StaffAssetName" class="text-danger" style="margin-left:210px;"></span> </div> <!-- Issued Quantity --> <div class="form-group"> <label asp-for="StaffAssets.IssuedQty" class="control-label-staff"></label> <input asp-for="StaffAssets.IssuedQty" value="@item.IssuedQty" class="form-control-staff" /><br /> <span asp-validation-for="StaffAssets.IssuedQty" class="text-danger" style="margin-left:210px;"></span> </div> <!-- Issued Date--> <div class="form-group"> <label asp-for="StaffAssets.IssuedDate" class="control-label-staff"></label> <input asp-for="StaffAssets.IssuedDate" value="@item.IssuedDate" class="form-control-staff" /><br /> <span asp-validation-for="StaffAssets.IssuedDate" class="text-danger" style="margin-left:210px;"></span> </div> <div style="float:right"> <input type='submit' class='btn btn-success' value='Edit' /> </div> </form> </div> </div> </div> </div> </td> </tr> } </tbody> </table> } </div>And the Edit method:
public async Task<IActionResult> OnPostEditAssetsDetailsAsync(int current = 3) { ShowAssetName = new SelectList(_context.Assets, "assetname", "assetname"); if (ModelState.GetFieldValidationState("StaffAssets") == ModelValidationState.Valid) { var staffassets = await _context.StaffAssets.FindAsync(StaffAssets.StaffID, StaffAssets.EmpID, StaffAssets.StaffAssetName); if (await TryUpdateModelAsync<StaffAssets>( staffassets, "StaffAssets", s => s.StaffAssetName, s => s.IssuedQty, s => s.IssuedDate)) { await _context.SaveChangesAsync(); } await _context.SaveChangesAsync(); //when add works, then +1 ,means next tab currentTab = current; TempData["EmpID"] = StaffAssets.EmpID; TempData["StaffID"] = StaffAssets.StaffID; ShowStaffAssets = _context.StaffAssets.Where(c => c.StaffID == StaffAssets.StaffID).OrderBy(c => c.StaffAssetName).AsNoTracking().ToList(); return Page(); } else { var errors = ModelState.Values.SelectMany(v => v.Errors); return Page(); } }Result:
Best Regards,
Jerry Cai
-
User-190697402 posted
Hi Jerry Cai,
Thank you so much for explaining me this clearly.
I have few issue with this method also.
1)In the modal Asset name should be displayed in a selectlist
2)Date is not displaying in the modal.
3)when im submitting the form,its throwing following error.
In my table,these three fields are defined as PK,But not in my model class,i have not specified it using [Key] annotation.Is that the problem.
4)And if there are more than two records, the modal for third one is not popping up.
Could you please help me .
-
User1312693872 posted
Hi,teenajohn1989
I copied your code and everything works well:
And this could be a new problem, I suggest you try to open a new thread and attach related details, because I can't reproduce your problem now.
Best Regards,
Jerry Cai
-
User-190697402 posted
Hi Jerry Cai,
Jerry Cai
If you have any questions, feel free to share it, I'm happy to assist you.Thank you so much for the kind response.
I have changed the dateformat in my model class as you said.
Now my date format in Add Asset is showing like this.
and when i click on Add the following error is getting
when i revert the dateformat to dd/MM/yyyy,it wont show up the date in edit screen.I choose one date and try to update it,but its throwing error
As you said earlier i have changed my modelbuilder function,copying my code here
modelBuilder.Entity("Contractor_HRMS.Models.StaffAssets", b => { b.Property<int>("StaffID") .ValueGeneratedOnAdd() .HasColumnType("int") .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn); b.Property<string>("EmpID") .HasColumnType("nvarchar(100)") .HasMaxLength(100); b.Property<DateTime>("IssuedDate") .HasColumnType("datetime2"); b.Property<string>("IssuedQty") .IsRequired() .HasColumnType("nvarchar(10)") .HasMaxLength(10); b.Property<string>("LastModifiedBy") .HasColumnType("nvarchar(max)"); b.Property<DateTime?>("LastModifiedTimestamp") .HasColumnType("datetime2"); b.Property<DateTime?>("ReturnDate") .HasColumnType("datetime2"); b.Property<string>("ReturnQty") .IsRequired() .HasColumnType("nvarchar(10)") .HasMaxLength(10); b.Property<string>("StaffAssetName") .IsRequired() .HasColumnType("nvarchar(100)") .HasMaxLength(100); b.HasKey("StaffID,EmpID,StaffAssetName"); b.ToTable("StaffAssets"); });And my StaffAssets Table structure is
CREATE TABLE StaffAssets ( StaffID INT NOT NULL, EmpID VARCHAR(100) NOT NULL, StaffAssetName varchar(100) NOT NULL, IssuedQty varchar(10), IssuedDate datetime, ReturnQty varchar(10), ReturnDate datetime, LastModifiedBy varchar(255), LastModifiedTimestamp datetime ) ALTER TABLE StaffAssets ADD PRIMARY KEY (StaffID,EmpID,StaffAssetName);
Could you please revert me on this.
-
User-190697402 posted
Hi Jerry Cai,
I did the same, i commented it out and checked, still got the same issue and this is my function name for modelbuilder
protected override void BuildModel(ModelBuilder modelBuilder){ }
I have one doubt,can you see the highlighted code,do we need to pass the Key as an array of values.
-
User1312693872 posted
Hi,teenajohn1989
You said you 'updated my ApplicationDbContextModelSnapshot.cs file like this', but how do you update the database by changing the code
in 'ApplicationDbContextModelSnapshot.cs '? IMHO, any changes in snapshot will not be applied, it just used for checking. You can click
'View->SQL Server Object Exploer->...->dbo.StaffAssets->View Designer' to check your table design, this is mine:
And my code in DbContext, to generate the database:
public class ApplicationDbContext : DbContext { public ApplicationDbContext(DbContextOptions<ApplicationDbContext> options) : base(options) { } public DbSet<StaffDetails> StaffDetails { get; set; } public DbSet<TypeOfEmployee> TypeOfEmployees { get; set; } public DbSet<EmploymentType> EmploymentTypes { get; set; } public DbSet<StaffBioData> StaffBioDatas { get; set; } public DbSet<TypeofBio> TypeofBios { get; set; } public DbSet<StaffAssets> StaffAssets { get; set; } public DbSet<Asset> Assets { get; set; } protected override void OnModelCreating(ModelBuilder modelBuilder) { modelBuilder.Entity<StaffDetails>().ToTable("StaffDetails"); modelBuilder.Entity<TypeOfEmployee>().ToTable("TypeOfEmployee"); modelBuilder.Entity<EmploymentType>().ToTable("EmploymentType"); modelBuilder.Entity<StaffBioData>().ToTable("StaffBioData"); modelBuilder.Entity<TypeofBio>().ToTable("TypeofBio"); modelBuilder.Entity<Asset>().ToTable("Asset"); modelBuilder.Entity<StaffAssets>() .HasKey(c => new { c.StaffID, c.EmpID, c.StaffAssetName }); // to create three keys } }After Add-Migration, Update-Database:
Then my snapshots will be generated, you can't change the code in it if you want to modify your database, it will not be applied:
modelBuilder.Entity("Case11101.Models.StaffAssets", b => { b.Property<int>("StaffID") .HasColumnType("int"); b.Property<string>("EmpID") .HasMaxLength(100) .HasColumnType("nvarchar(100)"); b.Property<string>("StaffAssetName") .HasMaxLength(100) .HasColumnType("nvarchar(100)"); b.Property<DateTime>("IssuedDate") .HasColumnType("datetime2"); b.Property<string>("IssuedQty") .IsRequired() .HasMaxLength(10) .HasColumnType("nvarchar(10)"); b.Property<string>("LastModifiedBy") .HasColumnType("nvarchar(max)"); b.Property<DateTime?>("LastModifiedTimestamp") .HasColumnType("datetime2"); b.Property<DateTime?>("ReturnDate") .HasColumnType("datetime2"); b.Property<string>("ReturnQty") .HasMaxLength(10) .HasColumnType("nvarchar(10)"); b.HasKey("StaffID", "EmpID", "StaffAssetName"); // this is the difference, in yours, it will not be three keys. b.ToTable("StaffAssets"); });Try to modify your database as mine, and I believe any error will disappear.
Best Regards,
Jerry Cai
-
User-190697402 posted
Hi Jerry Cai,
Thanks for the reply.
I have created the StaffAssets table manually by running this code in the sql management studio
CREATE TABLE StaffAssets ( StaffID INT NOT NULL, EmpID VARCHAR(100) NOT NULL, StaffAssetName VARCHAR(100) NOT NULL, IssuedQty VARCHAR(10), IssuedDate DATETIME, ReturnQty VARCHAR(10), ReturnDate DATETIME, LastModifiedBy VARCHAR(255), LastModifiedTimestamp DATETIME ) ALTER TABLE StaffAssets ADD CONSTRAINT PK_StaffAssets PRIMARY KEY (StaffID,EmpID,StaffAssetName);After that i run the commands Add-Migration and Update-Database in Nuget Package Manager Console.
But Still the code ModelBuilder functionality looks like this.
modelBuilder.Entity("Contractor_HRMS.Models.StaffAssets", b => { b.Property<int>("StaffID") .ValueGeneratedOnAdd() .HasColumnType("int") .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn); b.Property<string>("EmpID") .HasColumnType("nvarchar(100)") .HasMaxLength(100); b.Property<DateTime>("IssuedDate") .HasColumnType("datetime2"); b.Property<string>("IssuedQty") .IsRequired() .HasColumnType("nvarchar(10)") .HasMaxLength(10); b.Property<string>("LastModifiedBy") .HasColumnType("nvarchar(max)"); b.Property<DateTime?>("LastModifiedTimestamp") .HasColumnType("datetime2"); b.Property<DateTime?>("ReturnDate") .HasColumnType("datetime2"); b.Property<string>("ReturnQty") .IsRequired() .HasColumnType("nvarchar(10)") .HasMaxLength(10); b.Property<string>("StaffAssetName") .IsRequired() .HasColumnType("nvarchar(100)") .HasMaxLength(100); b.HasKey("StaffID"); b.ToTable("StaffAssets"); });I checked the table through sql explorer ,Its like
But Still its showing the same error
-
User1312693872 posted
Hi,teenajohn1989
It seems your way to create the database is different from mine, this should be the reason why you always can't run the code that works
normally at my side. You still have just one key even you modified the designer because in snapshoot , it tells you it just has one key named
staffid. But Now I'm glad to see you have solved this problem.
My method just give you a reference, you should modify your code according to your design.
About the new problem, you may missed 'await _context.SaveChangesAsync();'
public async Task<IActionResult> OnPostEditAssetsDetailsAsync(int current = 3) { ShowAssetName = new SelectList(_context.Assets, "assetname", "assetname"); if (ModelState.GetFieldValidationState("StaffAssets") == ModelValidationState.Valid) { var staffassets = await _context.StaffAssets.FirstOrDefaultAsync(c => c.StaffID == StaffAssets.StaffID && c.EmpID == StaffAssets.EmpID && c.StaffAssetName == StaffAssets.StaffAssetName); if (await TryUpdateModelAsync<StaffAssets>( staffassets, "StaffAssets", s => s.StaffAssetName, s => s.IssuedQty, s => s.IssuedDate)) { await _context.SaveChangesAsync(); } await _context.SaveChangesAsync(); // this line will be used to save when worked. //when add works, then +1 ,means next tab currentTab = current; TempData["EmpID"] = StaffAssets.EmpID; TempData["StaffID"] = StaffAssets.StaffID; ShowStaffAssets = _context.StaffAssets.Where(c => c.StaffID == StaffAssets.StaffID).OrderBy(c => c.StaffAssetName).AsNoTracking().ToList(); return Page(); } else { var errors = ModelState.Values.SelectMany(v => v.Errors); return Page(); } }Result:
Best Regards,
Jerry Cai
-
User-190697402 posted
Hi Jerry Cai,
Set a break point to check
var staffassets = await _context.StaffAssets.FirstOrDefaultAsync(c => c.StaffID == StaffAssets.StaffID && c.EmpID == StaffAssets.EmpID && c.StaffAssetName == StaffAssets.StaffAssetName);
My Select query works as expected
SELECT TOP(1) [s].[StaffID], [s].[EmpID], [s].[IssuedDate], [s].[IssuedQty], [s].[LastModifiedBy], [s].[LastModifiedTimestamp], [s].[ReturnDate], [s].[ReturnQty], [s].[StaffAssetName] FROM [StaffAssets] AS [s] WHERE (([s].[StaffID] = @__StaffAssets_StaffID_0) AND ([s].[EmpID] = @__StaffAssets_EmpID_1)) AND ([s].[StaffAssetName] = @__StaffAssets_StaffAssetName_2)
But my update query is like this
UPDATE [StaffAssets] SET [IssuedDate] = @p0, [IssuedQty] = @p1 WHERE [StaffID] = @p2;
this is causing the issue.Can i use direct query to update the field
