public async Task <int> Create(DateTestDTO DTO)
{
using SqlConnection conn = new SqlConnection(_connectionString);
return(await conn.ExecuteScalarAsync <int>(@"INSERT INTO [testing].[DateTest]([Date1], [DateTime1], [DateTime2])
VALUES(@Date1, @DateTime1, @DateTime2)",
new { DTO.Date1, DTO.DateTime1, DTO.DateTime2 }));
}
public async Task <int> Update(DateTestDTO DTO)
{
using SqlConnection conn = new SqlConnection(_connectionString);
return(await conn.ExecuteScalarAsync <int>(@"UPDATE [testing].[DateTest]
SET [Date1] = @Date1,
[DateTime1] = @DateTime1,
[DateTime2] = @DateTime2
WHERE [Id] = @Id",
new { DTO.Id, DTO.Date1, DTO.DateTime1, DTO.DateTime2 }));
}
public async Task <IActionResult> EditDate(DateTestDTO model)
{
await _dateTest.Update(model);
return(RedirectToAction("Index"));
}
public IActionResult AddEditDate(DateTestDTO model)
{
return(View(model));
}
