/// <summary>
/// Méthode pour sauvegarder une rubrique (save et update)
/// </summary>
/// <param name="rubric"></param>
public void SaveRubric(ref RubricDTO rubric)
{
SqlCommand command = new SqlCommand();
SqlParameter paramNewRubricId = new SqlParameter();
bool isNewRecord = false;
if (rubric.IdRubric.Equals(Common.DTOBase.Int_NullValue))
{
command = GetDbSprocCommand("INSERTRUBRIC");
paramNewRubricId = CreateOutputParameter("@NEWRUBRICID", SqlDbType.Int);
command.Parameters.Add(paramNewRubricId);
isNewRecord = true;
}
else
{
command = GetDbSprocCommand("UPDATERUBRIC");
command.Parameters.Add(CreateParameter("@ID", rubric.IdRubric));
}
command.Parameters.Add(CreateParameter("@NAME", rubric.NameRubric, 10));
// Exécute la commande.
command.Connection.Open();
int nb = command.ExecuteNonQuery();
command.Connection.Close();
if (nb == 1)
{
if (isNewRecord && nb == 1)
{
rubric.IdRubric = (int)paramNewRubricId.Value;
}
}
}
/// <summary>
/// Constructeur complet
/// </summary>
/// <param name="idrubric"></param>
/// <param name="namerubric"></param>
public Rubric(int idrubric, string namerubric) : this()
{
IdRubric = idrubric;
NameRubric = namerubric;
DTO = new RubricDTO();
DTO.IdRubric = idrubric;
DTO.NameRubric = namerubric;
}
/// <summary>
/// Constructeur par défaut
/// </summary>
public Rubric()
{
dal = new DALClient();
ListTopicsByRubric = new List <Topic>();
IdRubric = Int_NullValue;
NameRubric = String_NullValue;
DTO = new RubricDTO();
}
public void EditRubric_NullElement_ShouldThrowException()
{
//arrange
var Rubric = new RubricDTO {
Id = It.IsAny <int>()
};
//act & assert
NUnit.Framework.Assert.Throws <ArgumentOutOfRangeException>(() => rubricService.EditRubric(Rubric));
}
public void UpdataRubric(RubricDTO rubricDTO)
{
if (rubricDTO == null)
{
throw new ValidationException("Пустая рубрика", "");
}
Mapper.Initialize(cfr => cfr.CreateMap <RubricDTO, Rubric>());
Rubric rubric = Mapper.Map <RubricDTO, Rubric>(rubricDTO);
Database.Rubric.Update(rubric);
}
public ActionResult EditRubric(RubricViewModel rubric)
{
Mapper.Initialize(cfg => cfg.CreateMap <RubricViewModel, RubricDTO>()
.ReverseMap());
RubricDTO rubricDTO = Mapper.Map <RubricViewModel, RubricDTO>(rubric);
newsService.UpdataRubric(rubricDTO);
return(RedirectToAction("RubricList"));
}
public DALWSR_Result SaveRubric(RubricDTO rubric, Token tokenSend, CancellationToken cancel)
{
string str = string.Concat(CnxString, ADR_SAVERUBRIC);
WSR_Param p = new WSR_Param()
{
{ "save", rubric }, { "token", tokenSend }
};
WSR_Result r = ConsumeWSR.Call(str, "POST", p, TypeSerializer.Json, cancel);
return(new DALWSR_Result(r));
}
public void CreateRubric_TryToCreateRubric_ShouldRepositoryCreateOnce()
{
var Rubric = new RubricDTO {
Id = It.IsAny <int>()
};
// act
rubricService.CreateRubric(Rubric);
//assert
rubricRepository.Verify(x => x.Create(It.IsAny <Rubric>()));
}
public void RemoveRubric(RubricDTO rubricDTO)
{
if (rubricDTO == null)
{
throw new ArgumentNullException(nameof(rubricDTO));
}
if (Database.Rubrics.Get(rubricDTO.Id) == null)
{
throw new ArgumentOutOfRangeException("Not found rubric");
}
Database.Rubrics.Delete(rubricDTO.Id);
Database.Save();
}
public void CreateRubric(RubricDTO rubricDTO)
{
if (rubricDTO == null)
{
throw new ArgumentNullException(nameof(rubricDTO));
}
if (rubricDTO.Id != 0 && Database.Rubrics.Get(rubricDTO.Id) != null)
{
throw new ArgumentOutOfRangeException("Found duplicate id rubric");
}
Database.Rubrics.Create(Mapper.Map <RubricDTO, Rubric>(rubricDTO));
Database.Save();
}
public override DTOBase PopulateDTO(SqlDataReader reader)
{
RubricDTO r = new RubricDTO();
if (!reader.IsDBNull(Ord_IdRubric))
{
r.IdRubric = Convert.ToInt32(reader.GetDecimal(Ord_IdRubric));
}
if (!reader.IsDBNull(Ord_NameRubric))
{
r.NameRubric = reader.GetString(Ord_NameRubric);
}
r.IsNew = true;
return(r);
}
public void EditRubric_EditRubric_ShoudRepositoryEditOnce()
{//
var Rubric = new RubricDTO {
Id = It.IsAny <int>(), Name = It.IsAny <string>()
};
rubricRepository.Setup(x => x.Get(It.IsAny <int>())).Returns(new Rubric {
Id = It.IsAny <int>(), Name = It.IsAny <string>()
});
//act
rubricService.EditRubric(Rubric);
//assert
rubricRepository.Verify(x => x.Update(It.IsAny <Rubric>()), Times.Once);
}
public ActionResult DeleteRubric(int?id)
{
if (id == null)
{
return(HttpNotFound());
}
RubricDTO rubricDTO = newsService.GetRubric(id);
if (rubricDTO == null)
{
return(HttpNotFound());
}
Mapper.Initialize(cfg => cfg.CreateMap <RubricDTO, RubricViewModel>());
RubricViewModel rubric = Mapper.Map <RubricDTO, RubricViewModel>(rubricDTO);
return(View(rubric));
}
public void EditRubric(RubricDTO rubricDTO)
{
if (rubricDTO == null)
{
throw new ArgumentNullException(nameof(rubricDTO));
}
Rubric rubric = Database.Rubrics.Get(rubricDTO.Id);
if (rubric == null)
{
throw new ArgumentOutOfRangeException("Not found rubric");
}
rubric.Name = rubricDTO.Name;
Database.Rubrics.Update(rubric);
Database.Save();
}
public WSR_Result SaveRubric(WSR_Param param)
{
RubricDTO rubric = null;
object data = null;
WSR_Result result = null;
result = VerifParamType(param, "save", out rubric);
if (result == null)
{
rubric = (RubricDTO)param["save"];
RubricDb db = new RubricDb();
db.SaveRubric(ref rubric);
data = rubric;
return(new WSR_Result(data, true));
}
else
{
return(result);
}
}
/// <summary>
/// Méthode permettant d'obtenir la liste des sujets par rubrique
/// </summary>
public void GetListTopicsByRubric()
{
ListTopicsByRubric.Clear();
DALWSR_Result r1 = dal.GetTopicByRubricAsync(IdRubric, CancellationToken.None);
if (r1.Data != null)
{
Registered reg;
foreach (TopicDTO item in (List <TopicDTO>)r1.Data)
{
DALWSR_Result r2 = dal.GetRubricByIdAsync(item.IdRubric, CancellationToken.None);
RubricDTO rubric = (RubricDTO)r2.Data;
DALWSR_Result r3 = dal.GetUserByIdAsync(item.IdUser, CancellationToken.None);
RegisteredDTO regDto = (RegisteredDTO)r3.Data;
reg = new Registered();
reg.ObjStatus = reg.GetStatus(regDto.StatusUser);
reg.ObjTraining = reg.GetTraining(regDto.TrainingUser);
ListTopicsByRubric.Add(new Topic(item, new Registered(regDto, reg.ObjStatus, reg.ObjTraining), new Rubric(rubric)));
}
}
}
public Rubric()
{
this.Data = new RubricDTO();
}
/// <summary>
/// Constructeur pour mapper dto en Rubric
/// </summary>
/// <param name="dto"></param>
public Rubric(RubricDTO dto) : this()
{
IdRubric = dto.IdRubric;
NameRubric = dto.NameRubric;
DTO = dto;
}
public Rubric(RubricDTO dto)
{
this.Data = dto;
}
