public DigitalLiteracy Update(DigitalLiteracy obj, int?Ano, int?Nseq, AuthUser authUser)
{
obj.Chapa = authUser.Chapa;
var sql = "UPDATE CTJ_DIGITALLITERACY SET DATA=@Data, DESCRIPTION=@Description WHERE CHAPA=@Chapa AND ANO=@Ano AND NSEQ=@Nseq;";
int nRowUpdated = Db.Database.ExecuteSqlCommand(sql, new[] { new SqlParameter("@Chapa", obj.Chapa), new SqlParameter("@Ano", obj.Ano), new SqlParameter("@Nseq", obj.Nseq), new SqlParameter("@Data", obj.Data), new SqlParameter("@Description", obj.Description) });
return(obj);
}
public DigitalLiteracy Remove(DigitalLiteracy obj, AuthUser authUser)
{
obj.Chapa = authUser.Chapa;
obj.Ano = authUser.ContextoAno;
var sql = "DELETE FROM CTJ_DIGITALLITERACY WHERE ANO=@Ano AND CHAPA=@Chapa AND NSEQ=@Nseq";
int nRowDeleted = Db.Database.ExecuteSqlCommand(sql, new[] { new SqlParameter("@Ano", obj.Ano), new SqlParameter("@Chapa", obj.Chapa), new SqlParameter("@Nseq", obj.Nseq) });
return(obj);
}
public DigitalLiteracy Save(DigitalLiteracy obj, AuthUser authUser)
{
obj.Ano = authUser.ContextoAno;
obj.Chapa = authUser.Chapa;
//obj.Nseq = GetDigitalLiteracyByAnoAndChapa(authUser).Count() + 1; //TODO: ajustar objeto Observed
//obj.Nseq = GetDigitalLiteracyByAnoAndChapa(authUser).Max(x => x.Nseq); //TODO: ajustar objeto Observed
if (obj.Nseq == null)
{
obj.Nseq = 1;
}
else
{
obj.Nseq = obj.Nseq + 1;
}
var sql = "INSERT INTO CTJ_DIGITALLITERACY (CHAPA, ANO, NSEQ, DATA, DESCRIPTION) VALUES(@Chapa, @Ano, @Nseq, @Data, @Description)";
int nRowInserted = Db.Database.ExecuteSqlCommand(sql, new[] { new SqlParameter("@Chapa", obj.Chapa), new SqlParameter("@Ano", obj.Ano), new SqlParameter("@Nseq", obj.Nseq), new SqlParameter("@Data", obj.Data), new SqlParameter("@Description", obj.Description) });
return(obj);
}
public DigitalLiteracy Remove(DigitalLiteracy obj, AuthUser authUser)
{
return(_selfEvaluationRepository.Remove(obj, authUser));
}
public DigitalLiteracy Save(DigitalLiteracy obj, AuthUser authUser)
{
return(obj.Nseq != null?_selfEvaluationRepository.Update(obj, obj.Ano, obj.Nseq, authUser) : _selfEvaluationRepository.Save(obj, authUser));
}
public DigitalLiteracy Remove(DigitalLiteracy obj, AuthUser authUser)
{
return(_selfEvaluationService.Remove(obj, authUser));
}
