public async Task <IActionResult> Edit(int id, [Bind("ID,Name,Description")] CustomerCat customerCat)
{
if (id != customerCat.ID)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(customerCat);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!CustomerCatExists(customerCat.ID))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(customerCat));
}
/// <summary>
/// Получение данных по ИД заказчика
/// </summary>
/// <param name="id">ИД заказчика</param>
public void GetData(string id)
{
string sqlstr = $"SELECT * FROM CUSTOMER_CATALOG WHERE CUSTOMER_ID = {id}";
using (OracleConnection connection = BaseRepo.GetDBConnection())
{
customerCat = connection.QueryFirstOrDefault <CustomerCat>(sqlstr, null);
}
}
public async Task <IActionResult> Create([Bind("ID,Name,Description")] CustomerCat customerCat)
{
if (ModelState.IsValid)
{
_context.Add(customerCat);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(customerCat));
}
/// <summary>
/// Конструктор создания модели Customer_catalog
/// </summary>
/// <param name="interfaceMng"></param>
public CCatalEngine(TL4EngineInterfaceMngRepo interfaceMng)
{
this.customerCat = new CustomerCat();
}
