public async Task RunUpdate() { var query = await _context.SimpleTable.Where(s => s.Id == 1).FirstOrDefaultAsync(); //var counter = 1 ; query.Value += 1; _context.SimpleTable.Update(query); await _context.SaveChangesAsync(); }
public async Task <IActionResult> Index(IFormFile postedFile) { if (postedFile != null) { try { string fileExtension = Path.GetExtension(postedFile.FileName); if (fileExtension != ".csv") { ViewBag.Message = "Please select CSV file"; return(View()); } var employees = new List <Employee>(); using (var sreader = new StreamReader(postedFile.OpenReadStream())) { //First line is header. If header is not passed in csv then we can neglect the below line. string[] headers = sreader.ReadLine().Split(','); //Loop through the records while (!sreader.EndOfStream) { string[] rows = sreader.ReadLine().Split(','); employees.Add(new Employee { // Id = int.Parse(rows[0].ToString()), Name = rows[0].ToString(), JobRole = rows[1].ToString() }); } foreach (var employee in employees) { // var defEmp = _context.Employee.AsNoTracking().FirstOrDefault(e => e.Name == employee.Name); var defEmp = _context.Employee.Where(e => e.Name == employee.Name).FirstOrDefault(); if (defEmp != null) { defEmp.Name = employee.Name; defEmp.JobRole = employee.JobRole; // _context.Employee.Update(employee); } else { _context.Employee.Add(employee); } } await _context.SaveChangesAsync(); } return(View("View", employees)); } catch (Exception ex) { ViewBag.Message = ex.Message; } } else { ViewBag.Message = "Please select the file first to upload."; } return(View()); }