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());
}
