public void ActualizarStatus(ConceptStatusLogViewModel oConceptStatusLogViewModel)
{
using (var scope = new TransactionScope())
{
concepts oconcepts = oRepositorio.FindById(oConceptStatusLogViewModel.concept_id);
oconcepts.concept_status_id = oConceptStatusLogViewModel.concept_status_id;
oRepositorio.Update(oconcepts);
concepts_status_logs oconcepts_status_logs = new concepts_status_logs();
oconcepts_status_logs.concept_status_log_id = 0;
oconcepts_status_logs.concept_id = oConceptStatusLogViewModel.concept_id;
oconcepts_status_logs.reason_reject_id = oConceptStatusLogViewModel.reason_reject_id == 0 ? null : oConceptStatusLogViewModel.reason_reject_id;
oconcepts_status_logs.concept_status_id = oConceptStatusLogViewModel.concept_status_id;
oconcepts_status_logs.date_created = DateTime.Now;
oconcepts_status_logs.user_id_created = oConceptStatusLogViewModel.user_id_created;
oconcepts_status_logs.description = oConceptStatusLogViewModel.description;
oRepositorioConceptStatusLog.Add(oconcepts_status_logs);
if (oConceptStatusLogViewModel.speakers != null && oConceptStatusLogViewModel.speakers.Count > 0)
{
foreach (int user_id in oConceptStatusLogViewModel.speakers)
{
concept_debate_speakers oconcept_debate_speakers = new concept_debate_speakers();
oconcept_debate_speakers.concept_id = oConceptStatusLogViewModel.concept_id;
oconcept_debate_speakers.user_id = user_id;
oconcept_debate_speakers.date_created = DateTime.Now;
oconcept_debate_speakers.user_id_created = oConceptStatusLogViewModel.user_id_created;
oRepositorioConceptDebateSpeaker.Add(oconcept_debate_speakers);
}
}
oUnitOfWork.SaveChanges();
scope.Complete();
}
}
public void Modificar(ConceptViewModel pConceptViewModel)
{
using (var scope = new TransactionScope())
{
concepts oconcepts = oRepositorio.FindById(pConceptViewModel.concept_id);
oconcepts.concept = pConceptViewModel.concept;
oconcepts.summary = pConceptViewModel.summary;
oconcepts.pdf_path = pConceptViewModel.pdf_path;
oconcepts.user_id_modified = pConceptViewModel.user_id_modified;
oconcepts.concept_status_id = pConceptViewModel.concept_status_id;
// oconcepts.tags = oRepositorioTag.TagsByfilters(pConceptViewModel.tag_ids);
oconcepts.date_modified = DateTime.Now;
oRepositorio.Update(oconcepts);
//oconcepts.tags = oRepositorioTag.TagsByfilters(pConceptViewModel.tag_ids);
// oconcepts = oRepositorio.Add(oconcepts);
oRepositorioConceptTag.DeleleMultiple(oconcepts.concept_id);
foreach (int tag_id in pConceptViewModel.tag_ids)
{
concepts_tags oconcepts_tags = new concepts_tags
{
concept_id = oconcepts.concept_id,
tag_id = tag_id,
date_created = DateTime.Now,
user_id_created = pConceptViewModel.user_id_created
};
oRepositorioConceptTag.Add(oconcepts_tags);
}
oUnitOfWork.SaveChanges();
scope.Complete();
}
}
public void Leido(ConceptStatusLogViewModel oConceptStatusLogViewModel)
{
if (oRepositorioConceptStatusLog.VerificarLeido(oConceptStatusLogViewModel.concept_id, oConceptStatusLogViewModel.user_id_created.Value))
{
return;
}
using (var scope = new TransactionScope())
{
concepts_status_logs oconcepts_status_logs = new concepts_status_logs();
oconcepts_status_logs.concept_status_log_id = 0;
oconcepts_status_logs.concept_id = oConceptStatusLogViewModel.concept_id;
oconcepts_status_logs.concept_status_id = 4;
oconcepts_status_logs.date_created = DateTime.Now;
oconcepts_status_logs.user_id_created = oConceptStatusLogViewModel.user_id_created;
oRepositorioConceptStatusLog.Add(oconcepts_status_logs);
int NumeroCalificaciones = oRepositorio.NumeroCalificaciones(oConceptStatusLogViewModel.concept_id);
int concept_status_id = 4;
if (NumeroCalificaciones == 0)
{
concepts oconcepts = oRepositorio.FindById(oConceptStatusLogViewModel.concept_id);
oconcepts.concept_status_id = concept_status_id;
oRepositorio.Update(oconcepts);
}
oUnitOfWork.SaveChanges();
scope.Complete();
}
}
public void Eliminar(int id)
{
concepts oConcept = new concepts
{
concept_id = id,
};
oRepositorio.Delete(oConcept);
oUnitOfWork.SaveChanges();
}
public void Calificar(ConceptStatusLogViewModel oConceptStatusLogViewModel)
{
using (var scope = new TransactionScope())
{
concepts_status_logs oconcepts_status_logs = new concepts_status_logs();
oconcepts_status_logs.concept_status_log_id = 0;
oconcepts_status_logs.concept_id = oConceptStatusLogViewModel.concept_id;
oconcepts_status_logs.concept_status_id = 5;
oconcepts_status_logs.date_created = DateTime.Now;
oconcepts_status_logs.user_id_created = oConceptStatusLogViewModel.user_id_created;
oconcepts_status_logs.qualification = oConceptStatusLogViewModel.qualification;
oRepositorioConceptStatusLog.Add(oconcepts_status_logs);
oUnitOfWork.SaveChanges();
List <ConceptStatusLogViewModel> calificaciones = oRepositorioConceptStatusLog.ObtenerCalificaciones(oConceptStatusLogViewModel.concept_id);
int NumeroPonentes = oRepositorio.NumeroPonentes(oConceptStatusLogViewModel.concept_id);
int NumeroCalificaciones = calificaciones != null?calificaciones.Count() : 0;
int concept_status_id = 5;
if (NumeroPonentes == NumeroCalificaciones)
{
concept_status_id = 6;
}
concepts oconcepts = oRepositorio.FindById(oConceptStatusLogViewModel.concept_id);
oconcepts.concept_status_id = concept_status_id;
oconcepts.certification_path = oConceptStatusLogViewModel.certification_path;
if (NumeroCalificaciones > 0)
{
double qualification = calificaciones.Select(a => a.qualification).ToList().Average();
oconcepts.qualification = Math.Round(qualification, 2);
}
oRepositorio.Update(oconcepts);
oUnitOfWork.SaveChanges();
scope.Complete();
}
}
public void Agregar(ConceptViewModel pConceptViewModel)
{
using (var scope = new TransactionScope())
{
concepts oconcepts = new concepts
{
concept_id = 0,
concept = pConceptViewModel.concept,
summary = pConceptViewModel.summary,
draft_law_id = pConceptViewModel.draft_law_id,
investigator_id = pConceptViewModel.investigator_id,
bibliography = pConceptViewModel.bibliography,
date_created = DateTime.Now,
user_id_created = pConceptViewModel.user_id_created,
concept_status_id = 1,
pdf_path = pConceptViewModel.pdf_path,
hash = Guid.NewGuid()
};
//oconcepts.tags = oRepositorioTag.TagsByfilters(pConceptViewModel.tag_ids);
oconcepts = oRepositorio.Add(oconcepts);
//oUnitOfWork.SaveChanges();
foreach (int tag_id in pConceptViewModel.tag_ids)
{
concepts_tags oconcepts_tags = new concepts_tags
{
concept_id = oconcepts.concept_id,
tag_id = tag_id,
date_created = DateTime.Now,
user_id_created = pConceptViewModel.user_id_created
};
oRepositorioConceptTag.Add(oconcepts_tags);
}
oUnitOfWork.SaveChanges();
scope.Complete();
pConceptViewModel.concept_id = oconcepts.concept_id;
}
}
