public async Task <IActionResult> Edit(int id, [Bind("Id,ItemType,Value")] LookUpData lookUpData) { if (id != lookUpData.Id) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(lookUpData); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!LookUpDataExists(lookUpData.Id)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(lookUpData)); }
public async Task <IActionResult> Create([Bind("Id,ItemType,Value")] LookUpData lookUpData) { if (ModelState.IsValid) { _context.Add(lookUpData); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(lookUpData)); }
public IHttpActionResult PostLookupData(LookUpData lookUpData) { string connectionString = @"Data Source=NIBLP535;Initial Catalog=GetixAdminDb;Integrated Security=True"; using (SqlConnection con = new SqlConnection(connectionString)) { var commandStr = "INSERT INTO " + lookUpData.projectTableName + "("; foreach (var columnData in lookUpData.columnDetails) { commandStr += columnData.ColumnName + ","; } commandStr = commandStr.TrimEnd(','); commandStr += ")" + "VALUES" + "("; foreach (var columnData in lookUpData.columnDetails) { commandStr += "'" + columnData.ColumnData + "',"; } commandStr = commandStr.TrimEnd(','); commandStr += ")"; try { using (SqlCommand command = new SqlCommand(commandStr, con)) { con.Open(); command.ExecuteNonQuery(); con.Close(); } } catch (Exception ex) { throw; } } return(Ok()); }