public async Task <IActionResult> Edit(string id, [Bind("HolydayId,Description,Date")] Holyday holyday)
{
if (id != holyday.HolydayId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(holyday);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!HolydayExists(holyday.HolydayId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(holyday));
}
public async Task <IActionResult> Create([Bind("HolydayId,Description,Date")] Holyday holyday)
{
if (ModelState.IsValid)
{
_context.Add(holyday);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(holyday));
}
public List <Holyday> GetHolydayCA()
{
DataSet ds = new DataSet();
List <Holyday> listH = new List <Holyday>();
string query = "exec spS_Holyday";
ds = con.ObtenerConsulta(query);
foreach (DataRow DR in ds.Tables[0].Rows)
{
Holyday uc = new Holyday();
uc.Description = DR["Description"].ToString();
uc.Date = Convert.ToDateTime(DR["NoDeptos"].ToString());
listH.Add(uc);
}
return(listH);
}
