Beispiel #1
0
        public async Task <IActionResult> Edit(int id, Byte[] RowVersion, [Bind("ID,ProgramName,ProgramDescription,ProgramJoinCode,ProgramSupervisorID")] Models.Program program)
        {
            var programToUpdate = await _context.Programs.SingleOrDefaultAsync(p => p.ID == id);

            if (programToUpdate == null)
            {
                return(NotFound());
            }

            if (await TryUpdateModelAsync <Models.Program>(programToUpdate, "",
                                                           p => p.ProgramName, p => p.ProgramDescription, p => p.ProgramJoinCode, p => p.ProgramSupervisorID))
            {
                try
                {
                    _context.Entry(programToUpdate).Property("RowVersion").OriginalValue = RowVersion;
                    await _context.SaveChangesAsync();

                    return(RedirectToAction(nameof(Index)));
                }
                catch (DbUpdateConcurrencyException dex)
                {
                    var exceptionEntry = dex.Entries.Single();
                    var clientValues   = (Models.Program)exceptionEntry.Entity;
                    var databaseEntry  = exceptionEntry.GetDatabaseValues();
                    if (databaseEntry == null)
                    {
                        ModelState.AddModelError("",
                                                 "Unable to save changes. The Program was deleted by another user.");
                    }
                    else
                    {
                        var databaseValues = (Models.Program)databaseEntry.ToObject();
                        if (databaseValues.ProgramName != clientValues.ProgramName)
                        {
                            ModelState.AddModelError("ProgramName", "Current value: "
                                                     + databaseValues.ProgramName);
                        }
                        if (databaseValues.ProgramDescription != clientValues.ProgramDescription)
                        {
                            ModelState.AddModelError("ProgramDescription", "Current value: "
                                                     + databaseValues.ProgramDescription);
                        }
                        if (databaseValues.ProgramJoinCode != clientValues.ProgramJoinCode)
                        {
                            ModelState.AddModelError("ProgramJoinCode", "Current value: "
                                                     + databaseValues.ProgramJoinCode);
                        }
                        if (databaseValues.ProgramSupervisorID != clientValues.ProgramSupervisorID)
                        {
                            ProgramSupervisor databaseAssignment = await _context.ProgramSupervisors.SingleOrDefaultAsync(i => i.ID == databaseValues.ProgramSupervisorID);

                            ModelState.AddModelError("ProgramSupervisorID", $"Current value: {databaseAssignment?.Supervisor}");
                        }
                        ModelState.AddModelError(string.Empty, "The record you attempted to edit "
                                                 + "was modified by another user after you received your values. The "
                                                 + "edit operation was canceled and the current values in the database "
                                                 + "have been displayed. If you still want to save your version of this record, click "
                                                 + "the Save button again. Otherwise click the 'Back to List' hyperlink.");
                        programToUpdate.RowVersion = (byte[])databaseValues.RowVersion;
                        ModelState.Remove("RowVersion");
                    }
                }
                catch (DbUpdateException dex)
                {
                    if (dex.InnerException.Message.Contains("IX_Programs_ProgramJoinCode"))
                    {
                        ModelState.AddModelError("Email", "Unable to save changes. Remember, you cannot have duplicate Program Join Codes.");
                    }
                    else
                    {
                        ModelState.AddModelError("", "Unable to save changes. Try again, and if the problem persists see your system administrator.");
                    }
                }
            }
            ViewData["ProgramSupervisorID"] = new SelectList(_context.ProgramSupervisors, "ID", "Supervisor", program.ProgramSupervisorID);
            return(View(program));
        }
Beispiel #2
0
        public async Task <IActionResult> Edit(int id, Byte[] RowVersion, [Bind("ID,FirstName,LastName,Email,Phone,NotificationOptIn")] Parent parent)
        {
            var parentToUpdate = await _context.Parents.SingleOrDefaultAsync(p => p.ID == id);

            if (parentToUpdate == null)
            {
                return(NotFound());
            }

            if (await TryUpdateModelAsync <Parent>(parentToUpdate, "",
                                                   p => p.FirstName, p => p.LastName, p => p.Email, p => p.Phone, p => p.NotificationOptIn))
            {
                try
                {
                    _context.Entry(parentToUpdate).Property("RowVersion").OriginalValue = RowVersion;
                    await _context.SaveChangesAsync();

                    return(RedirectToAction(nameof(Index)));
                }
                catch (DbUpdateConcurrencyException dex)
                {
                    var exceptionEntry = dex.Entries.Single();
                    var clientValues   = (Parent)exceptionEntry.Entity;
                    var databaseEntry  = exceptionEntry.GetDatabaseValues();
                    if (databaseEntry == null)
                    {
                        ModelState.AddModelError("",
                                                 "Unable to save changes. The Parent was deleted by another user.");
                    }
                    else
                    {
                        var databaseValues = (Parent)databaseEntry.ToObject();
                        if (databaseValues.FirstName != clientValues.FirstName)
                        {
                            ModelState.AddModelError("FirstName", "Current value: "
                                                     + databaseValues.FirstName);
                        }
                        if (databaseValues.LastName != clientValues.LastName)
                        {
                            ModelState.AddModelError("LastName", "Current value: "
                                                     + databaseValues.LastName);
                        }
                        if (databaseValues.Email != clientValues.Email)
                        {
                            ModelState.AddModelError("Email", "Current value: "
                                                     + databaseValues.Email);
                        }
                        if (databaseValues.Phone != clientValues.Phone)
                        {
                            ModelState.AddModelError("Phone", "Current value: "
                                                     + String.Format("{0:(###) ###-####}", databaseValues.Phone));
                        }
                        ModelState.AddModelError(string.Empty, "The record you attempted to edit "
                                                 + "was modified by another user after you received your values. The "
                                                 + "edit operation was canceled and the current values in the database "
                                                 + "have been displayed. If you still want to save your version of this record, click "
                                                 + "the Save button again. Otherwise click the 'Back to List' hyperlink.");
                        parentToUpdate.RowVersion = (byte[])databaseValues.RowVersion;
                        ModelState.Remove("RowVersion");
                    }
                }
                catch (DbUpdateException dex)
                {
                    if (dex.InnerException.Message.Contains("IX_Parents_Email"))
                    {
                        ModelState.AddModelError("Email", "Unable to save changes. Remember, you cannot have duplicate Email Addresses.");
                    }
                    else
                    {
                        ModelState.AddModelError("", "Unable to save changes. Try again, and if the problem persists see your system admin.");
                    }
                }
            }
            return(View(parent));
        }