public ProcessResult <PlanArea> EliminarPlanArea(int pId_PlanArea)
{
ProcessResult <PlanArea> resultado = new ProcessResult <PlanArea>();
try
{
DA_PlanArea objDA = new DA_PlanArea();
PlanArea planArea = new PlanArea()
{
Id_PlanArea = pId_PlanArea,
Estado = "ELIMINADO",
FechaModificacion = DateTime.Now
};
objDA.EliminarPlanArea(planArea);
resultado.IsProcess = true;
}
catch (Exception e)
{
resultado.IsSuccess = false;
resultado.IsProcess = false;
resultado.Message = e.Message;
resultado.Exception = new ApplicationLayerException <BL_PlanArea>(e);
}
return(resultado);
}
public bool ActualizarPlanArea(PlanArea planArea)
{
using (DB_INNOVASCHOOLSEntities contexto = new DB_INNOVASCHOOLSEntities())
{
PlanArea objeto = (from x in contexto.PlanArea
where x.Id_PlanArea == planArea.Id_PlanArea
select x).FirstOrDefault();
objeto.Nombre = planArea.Nombre;
objeto.Objetivos = planArea.Objetivos;
objeto.Criterios = planArea.Criterios;
objeto.Requisitos = planArea.Requisitos;
objeto.Estado = planArea.Estado;
objeto.Documento = planArea.Documento;
objeto.FechaModificacion = planArea.FechaModificacion;
if (contexto.SaveChanges() > 0)
{
return(true);
}
else
{
return(false);
}
}
}
public ProcessResult <PlanArea> InsertarPlanArea(PlanArea planArea)
{
ProcessResult <PlanArea> resultado = new ProcessResult <PlanArea>();
try
{
DA_PlanArea objDA = new DA_PlanArea();
if (objDA.ObtenerPlanAreaExiste((int)planArea.Id_PeriodoAcademico, (int)planArea.Id_Area, (int)planArea.Id_PlanEstudio, (int)planArea.Id_Grado) == 0)
{
planArea.Estado = "REGISTRADO";
planArea.FechaCreacion = DateTime.Now;
objDA.InsertarPlanArea(planArea);
resultado.IsProcess = true;
}
else
{
resultado.Message = "El Plan de estudio existe para el siguiente: Periodo, Area Curricular o Grado";
resultado.IsProcess = false;
}
}
catch (Exception e)
{
resultado.IsSuccess = false;
resultado.IsProcess = false;
resultado.Message = e.Message;
resultado.Exception = new ApplicationLayerException <BL_PlanArea>(e);
}
return(resultado);
}
public async Task Update([FromBody] PlanAreaServiceModel model)
{
PlanArea planArea = await _planAreaService.GetByIdAsync(model.Id);
ValidateUser(planArea.Plan.UserId);
await _planAreaService.UpdateAsync(model);
}
public async Task UpdateAsync(PlanAreaServiceModel model)
{
PlanArea planArea = await _planAreaObjectService.GetByIdAsync <PlanArea>(model.Id);
if (planArea == null)
{
throw new DomainServicesException("Plan Area not found.");
}
planArea.Name = model.Name;
await _planAreaObjectService.UpdateAsync(planArea);
}
public ActionResult SubirArchivo(PlanArea planArea)
{
var model = new ResultadoDocumentoImportarModel();
try
{
var file = Request.Files[0];
var fileName = Path.GetFileName(file.FileName.ToString().Replace(' ', '_'));
}
catch (Exception e)
{
}
return(PartialView(model));
}
/// <summary>
///
/// </summary>
/// <param name="planArea"></param>
/// <returns></returns>
public JsonResult Registrar(PlanArea planArea, string contenidoArchivo)
{
ProcessResult <PlanArea> resultado = new ProcessResult <PlanArea>();
var bl_PlanArea = new BL_PlanArea();
if (!string.IsNullOrEmpty(contenidoArchivo))
{
var extencion = planArea.Documento.Split('.').LastOrDefault();
planArea.Documento = WebConfigurationManager.AppSettings["DirectorioPlanArea"] + Guid.NewGuid().ToString() + "." + extencion;
contenidoArchivo = contenidoArchivo.Split(new string[] { "base64," }, StringSplitOptions.None).LastOrDefault();
}
if (planArea.Id_PlanArea == 0)
{
resultado = bl_PlanArea.InsertarPlanArea(planArea);
if (resultado.IsSuccess)
{
if (!string.IsNullOrEmpty(contenidoArchivo))
{
System.IO.File.WriteAllBytes(planArea.Documento, Convert.FromBase64String(contenidoArchivo));
}
}
}
else
{
if (!string.IsNullOrEmpty(planArea.Documento))
{
var planAreaActual = bl_PlanArea.ObtenerPlanArea(planArea.Id_PlanArea);
if (!string.IsNullOrEmpty(planAreaActual.Result.DOCUMENTO_PLANAREA) && !string.IsNullOrEmpty(contenidoArchivo))
{
System.IO.File.Delete(planAreaActual.Result.DOCUMENTO_PLANAREA);
}
}
resultado = bl_PlanArea.ActualizarPlanArea(planArea);
if (resultado.IsSuccess)
{
if (!string.IsNullOrEmpty(contenidoArchivo))
{
System.IO.File.WriteAllBytes(planArea.Documento, Convert.FromBase64String(contenidoArchivo));
}
}
}
return(Json(resultado));
}
public PlanArea InsertarPlanArea(PlanArea planArea)
{
using (DB_INNOVASCHOOLSEntities contexto = new DB_INNOVASCHOOLSEntities())
{
PlanArea objeto = contexto.PlanArea.Add(planArea);
if (contexto.SaveChanges() > 0)
{
return(objeto);
}
else
{
return(null);
}
}
}
/// <summary>
///
/// </summary>
/// <param name="planArea"></param>
/// <returns></returns>
public JsonResult Registrar(PlanArea planArea)
{
ProcessResult <PlanArea> resultado = new ProcessResult <PlanArea>();
var bl_PlanArea = new BL_PlanArea();
if (planArea.Id_PlanArea == 0)
{
resultado = bl_PlanArea.InsertarPlanArea(planArea);
}
else
{
resultado = bl_PlanArea.ActualizarPlanArea(planArea);
}
return(Json(resultado));
}
private async Task <Plan> CreatePlanCoreAsync(PlanServiceModel model, string newPlanId = null)
{
var plan = new Plan(model.Name, model.UserId)
{
IsTemplate = model.IsTemplate
};
if (!string.IsNullOrEmpty(newPlanId))
{
plan.Id = newPlanId;
}
await _planObjectService.CreateAsync(plan);
foreach (PlanAreaServiceModel planArea in model.PlanAreas)
{
PlanArea area = new PlanArea
{
Name = planArea.Name,
Plan = plan,
PlanId = plan.Id,
UserId = plan.UserId
};
await _planAreaObjectService.CreateAsync(area);
foreach (AreaTopicServiceModel areaTopic in planArea.AreaTopics)
{
await _topicObjectService.CreateAsync(new AreaTopic
{
Name = areaTopic.Name,
StartDate = areaTopic.StartDate != null ? DateTime.ParseExact(areaTopic.StartDate, "yyyy-MM-dd",
CultureInfo.CurrentCulture) : (DateTime?)null,
EndDate = areaTopic.EndDate != null
? DateTime.ParseExact(areaTopic.EndDate, "yyyy-MM-dd", CultureInfo.CurrentCulture)
: (DateTime?)null,
Source = areaTopic.Source,
Description = areaTopic.Description,
PlanArea = area,
PlanAreaId = area.Id,
UserId = areaTopic.UserId,
PlanId = areaTopic.PlanId
});
}
}
return(plan);
}
public async Task UpdateAsync(PlanAreaServiceModel model)
{
using (_unitOfWork)
{
PlanArea planArea = await _planAreaReadRepository.GetByIdAsync(model.Id);
if (planArea == null)
{
throw new DomainServicesException("Plan Area not found.");
}
planArea.Name = model.Name;
await _unitOfWork.CommitAsync();
}
}
public async Task DeleteAsync(string id)
{
PlanArea planArea = await _planAreaReadRepository.GetByIdAsync(id);
if (planArea == null)
{
throw new DomainServicesException("Plan Area not found.");
}
foreach (AreaTopic areaTopic in _topicService.GetBy(planArea))
{
await _topicService.DeleteAsync(areaTopic.Id);
}
await _planAreaWriteRepository.DeleteAsync(planArea);
await _planAreaWriteRepository.SaveChangesAsync();
}
public async Task DeleteAsync(string id)
{
PlanArea planArea = await _planAreaObjectService.GetByIdAsync <PlanArea>(id);
if (planArea == null)
{
throw new DomainServicesException("Plan Area not found.");
}
foreach (AreaTopic areaTopic in _topicService.GetBy(planArea))
{
await _topicService.DeleteAsync(areaTopic.Id);
}
await _planAreaObjectService.DeleteAsync(planArea);
}
public async Task <PlanAreaServiceModel> CreatePlanAreaAsync(CreatePlanAreaServiceModel model)
{
PlanArea planArea = new PlanArea
{
Name = model.Name,
PlanId = model.PlanId,
UserId = model.UserId
};
await _planAreaObjectService.CreateAsync(planArea);
return(new PlanAreaServiceModel
{
Id = planArea.Id,
Name = planArea.Name,
PlanId = planArea.PlanId,
AreaTopics = Array.Empty <AreaTopicServiceModel>()
});
}
public async Task <PlanResponseModel> CreatePlanAsync(PlanServiceModel model)
{
using (_unitOfWork)
{
var plan = new Plan(model.Name, model.UserId);
await _planWriteRepository.CreateAsync(plan);
foreach (PlanAreaServiceModel planArea in model.PlanAreas)
{
PlanArea area = new PlanArea
{
Name = planArea.Name,
Plan = plan,
PlanId = plan.Id
};
await _planAreaRepository.CreateAsync(area);
foreach (AreaTopicServiceModel areaTopic in planArea.AreaTopics)
{
await _areaTopicRepository.CreateAsync(new AreaTopic
{
Name = areaTopic.Name,
StartDate = DateTime.ParseExact(areaTopic.StartDate, "yyyy-MM-dd",
CultureInfo.CurrentCulture),
EndDate = DateTime.ParseExact(areaTopic.EndDate, "yyyy-MM-dd", CultureInfo.CurrentCulture),
Source = areaTopic.Source,
Description = areaTopic.Description,
PlanArea = area,
PlanAreaId = area.Id
});
}
}
await _unitOfWork.CommitAsync();
return(new PlanResponseModel
{
Name = plan.Name,
Id = plan.Id
});
}
}
public async Task<PlanAreaServiceModel> CreatePlanAreaAsync(CreatePlanAreaServiceModel model)
{
PlanArea planArea = new PlanArea
{
Name = model.Name,
PlanId = model.PlanId
};
await _planAreaWriteRepository.CreateAsync(planArea);
await _planAreaWriteRepository.SaveChangesAsync();
return new PlanAreaServiceModel
{
Id = planArea.Id,
Name = planArea.Name,
PlanId = planArea.PlanId,
AreaTopics = Array.Empty<AreaTopicServiceModel>()
};
}
public bool EliminarPlanArea(PlanArea planArea)
{
using (DB_INNOVASCHOOLSEntities contexto = new DB_INNOVASCHOOLSEntities())
{
PlanArea objeto = (from x in contexto.PlanArea
where x.Id_PlanArea == planArea.Id_PlanArea
select x).FirstOrDefault();
objeto.Id_PlanArea = planArea.Id_PlanArea;
objeto.Estado = planArea.Estado;
if (contexto.SaveChanges() > 0)
{
return(true);
}
else
{
return(false);
}
}
}
public ProcessResult <PlanArea> ActualizarPlanArea(PlanArea planArea)
{
ProcessResult <PlanArea> resultado = new ProcessResult <PlanArea>();
try
{
DA_PlanArea objDA = new DA_PlanArea();
planArea.Estado = "REGISTRADO";
planArea.FechaModificacion = DateTime.Now;
objDA.ActualizarPlanArea(planArea);
resultado.IsProcess = true;
}
catch (Exception e)
{
resultado.IsSuccess = false;
resultado.IsProcess = false;
resultado.Message = e.Message;
resultado.Exception = new ApplicationLayerException <BL_PlanArea>(e);
}
return(resultado);
}
public IQueryable <AreaTopic> GetBy(PlanArea planArea)
{
return(_areaTopicReadRepository.GetAll().Where(topic => topic.PlanAreaId == planArea.Id));
}
public List <AreaTopic> GetBy(PlanArea planArea)
{
return(_topicObjectService.GetTopicsByAreaId(planArea.Id));
}
