Duplicating 2 columns in a database

Question

I am struggling to duplicate data from one column to the next. I want foodId and MenuItemId to be the same. Is there a way to add a code in the Controller to have both columns to have the same value? This is how it looks like currently:

FoodId   | MenuItemId | Rating
---------+------------+------
1        | NULL       |   5
1        | NULL       |   4
2        | NULL       |   5
1        | NULL       |   5

I would like my end result to look like this:

FoodId   | MenuItemId | Rating
---------+------------+------
  1      |     1      |   5
  1      |     1      |   4
  2      |     2      |   5
  1      |     1      |   5

This is my controller:

public IActionResult Create()
{
    var listOfNumbers = new List<int>() { 1, 2, 3, 4, 5 };
    var listOfRatings = listOfNumbers.Select(x => new { Id = x, Value = x.ToString() });

    ViewData["Rating"] = new SelectList(listOfRatings, "Id", "Value");
    ViewData["FoodId"] = new SelectList(_context.MenuItems, "Id", "Name");

    return View();
}
    
[HttpPost]
[ValidateAntiForgeryToken]
public async Task<IActionResult> Create([Bind("Id,Title,FoodReview,Rating,Date,FoodId,MenuItemId,UserId")] Reviews reviews)
{
    if (ModelState.IsValid)
    {
        var userId = _userManager.GetUserId(HttpContext.User);

        reviews.UserId = userId;
        reviews.Date = DateTime.Now;

        _context.Add(reviews);

        await _context.SaveChangesAsync();

        return RedirectToAction("Index");
    }

    var listOfNumbers = new List<int>() { 1, 2, 3, 4, 5 };
    var listOfRatings = listOfNumbers.Select(x => new { Id = x, Value = x.ToString() });

    ViewData["Rating"] = new SelectList(listOfRatings, "Id", "Value", reviews.Rating);
    ViewData["FoodId"] = new SelectList(_context.MenuItems, "Id", "Name", reviews.FoodId);

    return View(reviews);
}

its a mistake thats too late to fix, however, having the same data in the other column will solve the problem. — Jackson Parker, Oct 09 '21 at 16:11
Shouldn't you just fix this with a simple sql query on the server? — JHBonarius, Oct 09 '21 at 19:16
it will be easier to have the columns duplicated than to fix it on the server — Jackson Parker, Oct 09 '21 at 19:32

Serge · Answer 1 · 2021-10-10T05:18:38.933

0

you can link these properties using getter setter

public class Review
{
public int Id {get; set;}

,,,,, another properties

public int MenuItemId
{
get {return FoodId}
set { FoodId=value}
}

public int FoodId {get; set;}

}

or on the contrary , what you like more

edited Oct 10 '21 at 05:18

answered Oct 10 '21 at 05:11

Serge

40,935
4
18
45

Duplicating 2 columns in a database

1 Answers1