/// <summary>
/// Guarda la postulación de un caso de éxito.
/// </summary>
/// <param name="successStoryPostulate">Postulación del caso de éxito a guardar.</param>
/// <returns>true si se realizó el guardado, de lo contrario false.</returns>
public bool Save(SuccessStoryPostulate successStoryPostulate)
{
Database dataBase = DatabaseFactory.CreateDatabase(CONNECTION_NAME);
DbCommand dbCommand = dataBase.GetStoredProcCommand(GX_SUCCESS_STORY_POSTULATE);
dataBase.AddInParameter(dbCommand, "@Action", DbType.Int32, DataBaseActionEnum.Insert);
dataBase.AddInParameter(dbCommand, "@UserId", DbType.Int32, successStoryPostulate.UserId);
dataBase.AddInParameter(dbCommand, "@CategoryId", DbType.Int32, successStoryPostulate.CategoryId);
dataBase.AddInParameter(dbCommand, "@ResponsibleNames", DbType.String, successStoryPostulate.ResponsibleNames);
dataBase.AddInParameter(dbCommand, "@ResponsibleEmail", DbType.String, successStoryPostulate.ResponsibleEmail);
dataBase.AddInParameter(dbCommand, "@ResponsibleJobTitle", DbType.String, successStoryPostulate.ResponsibleJobTitle);
dataBase.AddInParameter(dbCommand, "@ResponsibleOrganization", DbType.String, successStoryPostulate.ResponsibleOrganization);
dataBase.AddInParameter(dbCommand, "@CityId", DbType.Int32, successStoryPostulate.CityId);
dataBase.AddInParameter(dbCommand, "@ResponsibleEntities", DbType.String, successStoryPostulate.ResponsibleEntities);
dataBase.AddInParameter(dbCommand, "@Name", DbType.String, successStoryPostulate.Name);
dataBase.AddInParameter(dbCommand, "@CreationDate", DbType.DateTime, successStoryPostulate.CreationDate);
dataBase.AddInParameter(dbCommand, "@Description", DbType.String, successStoryPostulate.Description);
dataBase.AddInParameter(dbCommand, "@ConcreteProblems", DbType.String, successStoryPostulate.ConcreteProblems);
dataBase.AddInParameter(dbCommand, "@InnovativeUrbanSolution", DbType.String, successStoryPostulate.InnovativeUrbanSolution);
dataBase.AddInParameter(dbCommand, "@IdsTag", DbType.String, successStoryPostulate.IdsTag);
dataBase.AddInParameter(dbCommand, "@Documents", DbType.String, successStoryPostulate.Documents);
dataBase.AddInParameter(dbCommand, "@State", DbType.Byte, successStoryPostulate.State);
dataBase.AddInParameter(dbCommand, "@LanguageId", DbType.Int32, successStoryPostulate.LanguageId);
return((int)dataBase.ExecuteScalar(dbCommand) == 0 ? false : true);
}
public void Test_Verificar_Llamado_Del_Metodo_GetById_En_Repositorio()
{
this.successStoryPostulateRepository.Setup(it => it.GetById(It.IsAny <int>(), It.IsAny <int>())).Verifiable();
SuccessStoryPostulate actualSuccessStoryPostulate = this.successStoryPostulateBussiness.GetById(0, 0);
this.successStoryPostulateRepository.Verify(it => it.GetById(It.IsAny <int>(), It.IsAny <int>()));
}
public ActionResult Detail(int id, int?mod, int?sectionId)
{
SuccessStoryPostulateFacade successStoryPostulateFacade = new SuccessStoryPostulateFacade();
TagFacade tagFacade = new TagFacade();
ModulRepository modul = new ModulRepository(SessionCustom);
modul.Entity.ModulId = mod;
modul.Entity.LanguageId = this.CurrentLanguage.LanguageId;
modul.Load();
this.ViewBag.SectionId = sectionId;
SuccessStoryPostulate successStoryPostulate = successStoryPostulateFacade.GetById(id, (int)this.CurrentLanguage.LanguageId);
successStoryPostulate.State = (byte)SuccessStoryPostulateStateEnum.Pending;
successStoryPostulateFacade.Update(successStoryPostulate);
return(this.View(new DetailModel
{
SuccessStoryPostulate = successStoryPostulate,
TagsText = string.Join(", ", tagFacade.GetBySuccessStoryPostulate(id).Select(t => t.Name)),
UserPrincipal = this.CustomUser,
ColModul = CustomMemberShipProvider.GetModuls(this.CustomUser.UserId, this.SessionCustom, HttpContext),
Module = modul.Entity,
CurrentLanguage = this.CurrentLanguage,
}));
}
public void Test_Consultar_Una_Postulacion_De_Casos_De_Exito_No_Retorna_Registro()
{
SuccessStoryPostulate expectedSuccessStoryPostulate = new SuccessStoryPostulate();
this.successStoryPostulateRepository.Setup(it => it.GetById(It.IsAny <int>(), It.IsAny <int>())).Returns(expectedSuccessStoryPostulate);
SuccessStoryPostulate actualSuccessStoryPostulate = this.successStoryPostulateBussiness.GetById(0, 0);
Assert.AreSame(expectedSuccessStoryPostulate, actualSuccessStoryPostulate);
}
public ActionResult Reject(int id, int?mod, int?sectionId)
{
SuccessStoryPostulateFacade successStoryPostulateFacade = new SuccessStoryPostulateFacade();
SuccessStoryPostulate successStoryPostulate = successStoryPostulateFacade.GetById(id, (int)this.CurrentLanguage.LanguageId);
successStoryPostulate.State = (byte)SuccessStoryPostulateStateEnum.Rejected;
successStoryPostulateFacade.Update(successStoryPostulate);
this.SendUserNotification(successStoryPostulate.UserId, successStoryPostulate.Name);
return(this.RedirectToAction("List", new { mod = mod, sectionId = sectionId }));
}
/// <summary>
/// Consulta la postulación de un caso de éxito.
/// </summary>
/// <param name="id">Id de la postulación del caso de éxito a consultar</param>
/// <param name="languageId">Id del lenguaje</param>
/// <returns>La postulación del caso de éxito.</returns>
public SuccessStoryPostulate GetById(int id, int languageId)
{
Database dataBase = DatabaseFactory.CreateDatabase(CONNECTION_NAME);
SuccessStoryPostulate successStoryPostulate = new SuccessStoryPostulate();
DbCommand dbCommand = dataBase.GetStoredProcCommand(GX_SUCCESS_STORY_POSTULATE);
dataBase.AddInParameter(dbCommand, "@Action", DbType.Int32, DataBaseActionEnum.SelectByPrimaryKey);
dataBase.AddInParameter(dbCommand, "@Id", System.Data.DbType.Int32, id);
dataBase.AddInParameter(dbCommand, "@LanguageId", System.Data.DbType.Int32, languageId);
using (IDataReader dataReader = dataBase.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
successStoryPostulate = new SuccessStoryPostulate(dataReader);
}
}
return(successStoryPostulate);
}
/// <summary>
/// Guarda la postulación de un caso de éxito.
/// </summary>
/// <param name="successStoryPostulate">Postulación del caso de éxito a guardar.</param>
/// <returns>true si se realizó el guardado, de lo contrario false.</returns>
public bool Save(SuccessStoryPostulate successStoryPostulate)
{
return(this.successStoryPostulateRepository.Save(successStoryPostulate));
}
/// <summary>
/// Guarda la postulación de un caso de éxito.
/// </summary>
/// <param name="successStoryPostulate">Postulación del caso de éxito a guardar.</param>
/// <returns>true si se realizó el guardado, de lo contrario false.</returns>
public bool Save(SuccessStoryPostulate successStoryPostulate)
{
ISuccessStoryPostulateBussiness successStoryPostulateBussiness = new SuccessStoryPostulateBussiness(new SuccessStoryPostulateBroker());
return(successStoryPostulateBussiness.Save(successStoryPostulate));
}
