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