public dynamic AgregarCecoPrograma(CecoUpdateRequest request)
{
return(ProgramasOperations.AgregarCecoAPrograma(_factory, _connectionDB, request));
}
public dynamic ActualizarCeco(CecoUpdateRequest request)
{
return(ProgramasOperations.ActualizarCeco(_factory, _connectionDB, request));
}
public dynamic ActualizarCeco([FromBody] CecoUpdateRequest request)
{
return(_dataModelRepository.ActualizarCeco(request));
}
public dynamic AgregarCecoAPrograma(CecoUpdateRequest request)
{
return(_dataModelRepository.AgregarCecoPrograma(request));
}
public static dynamic AgregarCecoAPrograma(IContextFactory factory, IOptions <ConnectionDB> connection, CecoUpdateRequest cecoRequest)
{
using (Aldeas_Context db = factory.Create(connection))
{
var nuevo = new DbCecos()
{
idPrograma = cecoRequest.IdPrograma,
Nombre = cecoRequest.Nombre,
CodigoCeco = cecoRequest.CodigoCeco,
idFinanciador = cecoRequest.IdFinanciador,
Estado = true,
FacilityNav = cecoRequest.FacilityNav,
NombreSubCentro = cecoRequest.NombreSubCentro,
SubCentro = cecoRequest.SubCentro
};
db.TbProgramasCecos.Add(nuevo);
db.SaveChanges();
}
return(new { id = 0, status = "OK", code = 200 });
}
public static dynamic ActualizarCeco(IContextFactory factory, IOptions <ConnectionDB> connection, CecoUpdateRequest cecoRequest)
{
ProgramasResponse retorno = new ProgramasResponse();
using (Aldeas_Context db = factory.Create(connection))
{
var data = from pro in db.TbProgramasCecos
where pro.id == cecoRequest.Id
select pro;
if (data.Any())
{
data.First().Estado = cecoRequest.Estado;
data.First().NombreSubCentro = cecoRequest.NombreSubCentro;
data.First().FacilityNav = cecoRequest.FacilityNav;
data.First().fecha_actualizacion = DateTime.Now;
var others = from pro in db.TbProgramasCecos
where pro.CodigoCeco == data.First().CodigoCeco
select pro;
others.ToList().ForEach(x => x.Nombre = cecoRequest.Nombre);
db.SaveChanges();
}
}
return(new { id = 0, status = "OK", code = 200 });
}
