public List <GroupDTO> GetGroups(int stageId)
{
List <GroupDTO> groupList = new List <GroupDTO>();
var groups = _dbContext.StageGroups.Where(x => x.StageId == stageId);
foreach (var grp in groups)
{
GroupDTO grpItem = new GroupDTO();
grpItem.Name = grp.GroupName;
grpItem.GroupId = grp.Id;
grpItem.Sequence = grp.Sequence;
var groupCheckList = GetCheckList(grpItem.GroupId);
grpItem.GroupCheckList = new List <CheckListDTO>();
foreach (var checkList in groupCheckList)
{
CheckListDTO checkListItem = new CheckListDTO();
checkListItem.CheckListId = checkList.Id;
checkListItem.Name = checkList.Name;
checkListItem.Points = checkList.Points;
grpItem.GroupCheckList.Add(checkListItem);
}
groupList.Add(grpItem);
}
return(groupList);
}
public CheckListDTO ObterCheckList(CheckListDTO dto)
{
try
{
ComandText = "stp_AUTO_ORDEM_SERVICO_CHECKLIST_OBTERPORPK";
AddParameter("@OS_ID", dto.OrderServiceID);
MySqlDataReader dr = ExecuteReader();
dto = new CheckListDTO();
if (dr.Read())
{
dto.OrderServiceID = int.Parse(dr[0].ToString());
dto.FuncionarioID = dr[1].ToString();
dto.HasMacaco = dr[2].ToString() == "1" ? true : false;
dto.HasChaveRoda = dr[3].ToString() == "1" ? true : false;
dto.HasManivela = dr[4].ToString() == "1" ? true : false;
dto.HasSocorro = dr[5].ToString() == "1" ? true : false;
dto.HasPiscaFrontalLE = dr[6].ToString() == "1" ? true : false;
dto.HasPiscaFrontalLD = dr[7].ToString() == "1" ? true : false;
dto.HasPiscaTraseiroLE = dr[8].ToString() == "1" ? true : false;
dto.HasPiscaTraseiroLD = dr[9].ToString() == "1" ? true : false;
dto.HasStopLE = dr[10].ToString() == "1" ? true : false;
dto.HasStopLD = dr[11].ToString() == "1" ? true : false;
dto.HasFarolLE = dr[12].ToString() == "1" ? true : false;
dto.HasFarolLD = dr[13].ToString() == "1" ? true : false;
dto.HasSimboloFrontal = dr[14].ToString() == "1" ? true : false;
dto.HasSimboloTraseiro = dr[15].ToString() == "1" ? true : false;
dto.HasRetrovisorLE = dr[16].ToString() == "1" ? true : false;
dto.HasRetrovisorLD = dr[17].ToString() == "1" ? true : false;
dto.HasRadio = dr[18].ToString() == "1" ? true : false;
dto.HasTapeteFrontalLE = dr[19].ToString() == "1" ? true : false;
dto.HasTapeteFrontalLD = dr[20].ToString() == "1" ? true : false;
dto.HasTapeteTraseiroLE = dr[21].ToString() == "1" ? true : false;
dto.HasTapeteTraseiroLD = dr[23].ToString() == "1" ? true : false;
dto.HasTapeteTraseiroMeio = dr[24].ToString() == "1" ? true : false;
dto.HasIsqueiro = dr[25].ToString() == "1" ? true : false;
dto.HasElevadorFrontalLE = dr[26].ToString() == "1" ? true : false;
dto.HasElevadorFrontalLD = dr[27].ToString() == "1" ? true : false;
dto.HasElevadorTraseiroLE = dr[28].ToString() == "1" ? true : false;
dto.HasElevadorTraseiroLD = dr[29].ToString() == "1" ? true : false;
dto.HasColete = dr[30].ToString() == "1" ? true : false;
dto.HasTriangulo = dr[31].ToString() == "1" ? true : false;
dto.NivelCombustivel = dr[32].ToString();
}
}
catch (Exception ex)
{
dto.MensagemErro = ex.Message.Replace("'", string.Empty);
}
finally
{
FecharConexao();
}
return(dto);
}
private void SaveChekList(CheckListDTO dto)
{
try
{
ComandText = "stp_AUTO_ORDEM_SERVICO_CHECKLIST_ADICIONAR";
AddParameter("@ORDER_ID", dto.OrderServiceID);
AddParameter("@TECHNICIAN", dto.FuncionarioID);
AddParameter("@HAS_MACACO", dto.HasMacaco == true ? 1 : 0);
AddParameter("@HAS_CHAVE", dto.HasChaveRoda == true ? 1 : 0);
AddParameter("@HAS_MANIVELA", dto.HasManivela == true ? 1 : 0);
AddParameter("@HAS_PNEU", dto.HasSocorro == true ? 1 : 0);
AddParameter("@HAS_PISFLE", dto.HasPiscaFrontalLE == true ? 1 : 0);
AddParameter("@HAS_PISFLD", dto.HasPiscaFrontalLD == true ? 1 : 0);
AddParameter("@HAS_PISTLE", dto.HasPiscaTraseiroLE == true ? 1 : 0);
AddParameter("@HAS_PISTLD", dto.HasPiscaTraseiroLD == true ? 1 : 0);
AddParameter("@HAS_STOPLE", dto.HasStopLE == true ? 1 : 0);
AddParameter("@HAS_STOPLD", dto.HasStopLD == true ? 1 : 0);
AddParameter("@HAS_FAROLLE", dto.HasFarolLE == true ? 1 : 0);
AddParameter("@HAS_FAROLLD", dto.HasFarolLD == true ? 1 : 0);
AddParameter("@HAS_SYMBOLF", dto.HasSimboloFrontal == true ? 1 : 0);
AddParameter("@HAS_SYMBOLT", dto.HasSimboloTraseiro == true ? 1 : 0);
AddParameter("@HAS_RETRO_LE", dto.HasRetrovisorLE == true ? 1 : 0);
AddParameter("@HAS_RETRO_LD", dto.HasRetrovisorLD == true ? 1 : 0);
AddParameter("@HAS_RETRO_IN", dto.HasRetrovisorInterior == true ? 1 : 0);
AddParameter("@HAS_RADIO", dto.HasRadio == true ? 1 : 0);
AddParameter("@HAS_TAPFLE", dto.HasTapeteFrontalLE == true ? 1 : 0);
AddParameter("@HAS_TAPFLD", dto.HasTapeteFrontalLD == true ? 1 : 0);
AddParameter("@HAS_TAPTLE", dto.HasTapeteTraseiroLE == true ? 1 : 0);
AddParameter("@HAS_TAPTLD", dto.HasTapeteTraseiroLD == true ? 1 : 0);
AddParameter("@HAS_TAPTMEI", dto.HasTapeteTraseiroMeio == true ? 1 : 0);
AddParameter("@HAS_ISQUEIRO", dto.HasIsqueiro == true ? 1 : 0);
AddParameter("@HAS_ELEVADORFLE", dto.HasElevadorFrontalLE == true ? 1 : 0);
AddParameter("@HAS_ELEVADORFLD", dto.HasElevadorFrontalLD == true ? 1 : 0);
AddParameter("@HAS_ELEVADORTLE", dto.HasElevadorTraseiroLE == true ? 1 : 0);
AddParameter("@HAS_ELEVADORTLD", dto.HasElevadorTraseiroLD == true ? 1 : 0);
AddParameter("@HAS_COLETE", dto.HasColete == true ? 1 : 0);
AddParameter("@HAS_TRIANGULO", dto.HasTriangulo == true ? 1 : 0);
AddParameter("@FLUEL_LEVEL", dto.NivelCombustivel);
AddParameter("@UTILIZADOR", dto.Utilizador);
ExecuteNonQuery();
dto.Sucesso = true;
}
catch (Exception ex)
{
dto.MensagemErro = ex.Message.Replace("'", string.Empty);
}
finally
{
FecharConexao();
}
}
public List <StageDTO> GetAllStageData(int interviewType, IQueryable <int> completedCheckList, IQueryable <int> completedStagesList)
{
int totalStageScore;
int totalCheckListCount;
int completedCheckListCount;
List <StageDTO> stageDetails = new List <StageDTO>();
var stages = _dbContext.Stages.Where(x => x.InterviewTypeId == interviewType);;
foreach (var stage in stages)
{
StageDTO stageDetailItem = new StageDTO();
totalStageScore = 0;
completedCheckListCount = 0;
totalCheckListCount = 0;
stageDetailItem.Name = stage.StageName;
stageDetailItem.StageId = stage.Id;
stageDetailItem.Sequence = stage.Sequence;
stageDetailItem.IsCompleted = completedStagesList.Any(x => x == stageDetailItem.StageId);
var stageGroups = _dbContext.StageGroups.Where(x => x.StageId == stageDetailItem.StageId);
stageDetailItem.StageGroups = new List <GroupDTO>();
foreach (var group in stageGroups)
{
GroupDTO groupItem = new GroupDTO();
groupItem.GroupId = group.Id;
groupItem.Name = group.GroupName;
groupItem.Sequence = group.Sequence;
var groupCheckList = GetCheckList(groupItem.GroupId);
groupItem.GroupCheckList = new List <CheckListDTO>();
foreach (var checkList in groupCheckList)
{
CheckListDTO checkListItem = new CheckListDTO();
checkListItem.CheckListId = checkList.Id;
checkListItem.Name = checkList.Name;
checkListItem.Points = checkList.Points;
checkListItem.IsChecked = completedCheckList.Any(x => x == checkList.Id);
if (checkListItem.IsChecked)
{
totalStageScore = totalStageScore + checkList.Points;
completedCheckListCount++;
}
totalCheckListCount++;
groupItem.GroupCheckList.Add(checkListItem);
}
stageDetailItem.StageGroups.Add(groupItem);
}
stageDetailItem.TotalCheckListCount = totalCheckListCount;
stageDetailItem.CompletedCheckListCount = completedCheckListCount;
stageDetailItem.StageScore = totalStageScore;
stageDetails.Add(stageDetailItem);
}
return(stageDetails);
}
public async Task <Object> PutEditCheckList(CheckListDTO model)
{
try
{
string userId = User.Claims.First(c => c.Type == "UserID").Value;
var newObject = _mapper.Map <CheckList>(model);
newObject.LastModficationDate = DateTime.Now;
newObject.UserId = userId;
return(Ok((_mapper.Map <CheckListDTO>(await _checkListRepository.UpdateAsync(newObject, model.Id.ToString())))));
}
catch (Exception ex)
{
return(ex.ToString());
}
return(StatusCode(403));
}
public List <CheckListDTO> GetCheckListDTOList(int groupId)
{
var CheckListDataList = GetCheckList(groupId);
List <CheckListDTO> checkListDTOList = new List <CheckListDTO>();
foreach (var checkListItem in CheckListDataList)
{
var checkListDTOItem = new CheckListDTO()
{
Name = checkListItem.Name,
CheckListId = checkListItem.Id,
Points = checkListItem.Points
};
checkListDTOList.Add(checkListDTOItem);
}
return(checkListDTOList);
}
public int SalvarCheckList(CheckListDTO checklist)
{
using (var tran = new TransactionScope(TransactionScopeOption.RequiresNew))
{
checklist.CheckListID = this.InserirOuAtualizarCheckList(checklist, DateTime.Now);
this.SalvarCheckListGruposItens(checklist.GruposItens, checklist.CheckListID);
var todosItens = checklist.GruposItens.SelectMany(g => g.Itens).Select(it => it.CheckListItemID);
this.ApagarCheckListItensNaoEncontrados(checklist.CheckListID, todosItens);
var todosGrupos = checklist.GruposItens.Select(g => g.CheckListGrupoItemID);
this.ApagarCheckListGrupoItensNaoEncontrados(checklist.CheckListID, todosGrupos);
tran.Complete();
return(checklist.CheckListID);
}
}
private int InserirOuAtualizarCheckList(CheckListDTO checklist, DateTime dataAtualizacao)
{
#region SQL +
const string sqlInsert = @"
INSERT INTO MDS.CheckList
(Nome, Descricao, DataCriacao, UsuarioCriacaoID, DataAtualizacao, UsuarioAtualizacaoID)
VALUES (@Nome, @Descricao, @DataCriacao, @UsuarioCriacaoID, @DataAtualizacao, @UsuarioAtualizacaoID)
DECLARE @ID INT = SCOPE_IDENTITY();
EXEC MDS.usp_GravarCheckListHistorico @ID
SELECT @ID";
const string sqlUpdate = @"
UPDATE MDS.CheckList SET
Nome = @Nome
,Descricao = @Descricao
,DataAtualizacao = @DataAtualizacao
,UsuarioAtualizacaoID = @UsuarioAtualizacaoID
WHERE CheckListID = @CheckListID
EXEC MDS.usp_GravarCheckListHistorico @CheckListID
SELECT @CheckListID";
var sql = checklist.CheckListID > 0 ? sqlUpdate : sqlInsert;
#endregion
return(base.Repository.ExecuteScalar <int>(sql, p =>
{
p.AddWithValue("@CheckListID", checklist.CheckListID);
p.AddWithValue("@UsuarioCriacaoID", checklist.UsuarioCriacaoID);
p.AddWithValue("@Nome", checklist.Nome);
p.AddWithValue("@Descricao", checklist.Descricao);
p.AddWithValue("@DataCriacao", dataAtualizacao);
p.AddWithValue("@DataAtualizacao", dataAtualizacao);
p.AddWithValue("@UsuarioAtualizacaoID", checklist.UsuarioAtualizacaoID);
}));
}
public async Task <Object> PostAddCheckList(CheckListDTO model)
{
try
{
string userId = User.Claims.First(c => c.Type == "UserID").Value;
if (model != null)
{
model.CreationDate = DateTime.Now;
model.LastModficationDate = model.CreationDate;
model.ShopPrice = 0.0f;
var newObject = _mapper.Map <CheckList>(model);
newObject.User = await _userManager.FindByIdAsync(userId);
newObject.Status = CheckListStatus.Active;
return(Ok(_mapper.Map <CheckListDTO>(await _checkListRepository.AddAsync(newObject))));
}
}
catch (Exception ex)
{
return(ex.ToString());
}
return(StatusCode(403));
}
public int SalvarCheckList(CheckListDTO checklist)
{
return(this._repository.SalvarCheckList(checklist));
}
