protected void btnSearch_Click(object sender, EventArgs e)
{
TechnicianDTO dto = new TechnicianDTO();
conn = ConfigurationManager.ConnectionStrings["ConnectionString"].ToString();
SqlConnection myConn = new SqlConnection(conn);
myConn.Open();
string selectStatement = "Select * from Technicians where (technicianID="; selectStatement += dropDownTechID.SelectedValue + ")";
SqlCommand selectCmd = new SqlCommand(selectStatement, myConn);
SqlDataReader myReader;
myReader = selectCmd.ExecuteReader();
while (myReader.Read())
{
if (myReader.GetString(0) == dropDownTechID.SelectedValue)
{
dto.id = myReader.GetString(0);
dto.name = myReader.GetString(1);
dto.type = myReader.GetString(2);
break;
}
}
myConn.Close();
Session["TechnicianDTO"] = dto;
Server.Transfer("TechniciansEdit2.aspx");
}
public TechnicianDTO Adicionar(TechnicianDTO dto)
{
try
{
BaseDados.ComandText = "stp_GER_TECNICO_ADICIONAR";
BaseDados.AddParameter("@ENTIDADE", dto.Entity.Codigo);
BaseDados.AddParameter("@COMISSAO", dto.Comissao <= 0 ? (object)DBNull.Value : dto.Comissao);
BaseDados.AddParameter("@FILIAL", dto.Entity.Filial);
BaseDados.AddParameter("@GRUPO", dto.GroupID <= 0 ? (object)DBNull.Value : dto.GroupID);
BaseDados.AddParameter("@VALOR_COMISSAO", dto.ValorComissao);
BaseDados.AddParameter("@USERNAME", dto.Utilizador);
BaseDados.AddParameter("@UTILIZADOR", dto.CreatedBy);
BaseDados.AddParameter("@NOME_TECNICO", dto.Entity.NomeCompleto);
BaseDados.AddParameter("@SENHA", dto.CurrentPassword);
BaseDados.AddParameter("@PERFIL", dto.UserProfile);
BaseDados.AddParameter("@EMAIL", dto.Email);
BaseDados.AddParameter("@TIPO", dto.Tipo);
BaseDados.ExecuteNonQuery();
dto.Sucesso = true;
}
catch (Exception ex)
{
dto.Sucesso = false;
dto.MensagemErro = ex.Message.Replace("'", "");
}
finally
{
BaseDados.FecharConexao();
}
return(dto);
}
public async Task <IActionResult> InsertTechnician([FromBody] TechnicianDTO technician)
{
try
{
Technician objTechnician = new Technician(technician.Name, technician.Lastname, technician.CI, technician.Phone,
technician.Email);
await _technicianRepository.Insert(objTechnician);
await _unitOfWork.Commit();
return(Ok(new
{
Ok = true,
Message = "Registro insertado exitosamente"
}));
}
catch (Exception e)
{
return(BadRequest(new
{
Ok = false,
Error = e
}));
}
}
public Technician createTechnician(TechnicianDTO dto)
{
Technician technicianObject = new Technician();
technicianObject.technicianID = dto.id;
technicianObject.technicianName = dto.name;
technicianObject.technicianType = dto.type;
return(technicianObject);
}
private void getSessionData()
{
TechnicianDTO dto = (TechnicianDTO)Session["TechnicianDTO"];
ModelFacade facade = new ModelFacade();
Technician technician = facade.createTechnician(dto);
lblID.Text = technician.technicianID;
lblName.Text = technician.technicianName;
lblType.Text = technician.technicianType;
}
protected void btnInsert_Click(object sender, EventArgs e)
{
TechnicianDTO dto = (TechnicianDTO)Session["TechnicianDTO"];
ModelFacade facade = new ModelFacade();
Technician technician = facade.createTechnician(dto);
TechnicianDAO dao = new TechnicianDAO();
dao.saveTechnician(technician);
Session.Abandon();
Response.Redirect("~/Staff/AdminHome.aspx");
}
public TechnicianDTO Salvar(TechnicianDTO pTecnico)
{
pTecnico.Entity = EntidadeRN.GetInstance().Salvar(pTecnico.Entity);
if (pTecnico.Entity.MensagemErro.Equals(string.Empty) || pTecnico.Entity.Sucesso == true)
{
dao.Adicionar(pTecnico);
}
return(pTecnico);
}
protected void btnNext_Click(object sender, EventArgs e)
{
String techID = txtTechID.Text;
String techName = txtTechName.Text;
String techType = dropDownType.SelectedValue;
TechnicianDTO technician = new TechnicianDTO();
technician.id = techID;
technician.name = techName;
technician.type = techType;
Session["TechnicianDTO"] = technician;
Server.Transfer("TechniciansInsert2.aspx", true);
}
public async Task <IActionResult> GetTechnicianById(Guid id)
{
try
{
TechnicianDTO technician = await _mediator.Send(new GetTechnicianByIdQuery(id));
return(Ok(new
{
Technician = technician
}));
}
catch (Exception e)
{
return(BadRequest(e));
}
}
public TechnicianDTO ObterPorPK(TechnicianDTO pTecnico)
{
try
{
BaseDados.ComandText = "stp_GER_TECNICO_OBTERPORPK";
BaseDados.AddParameter("@CODIGO", pTecnico.Entity.Codigo);
MySqlDataReader dr = BaseDados.ExecuteReader();
pTecnico = new TechnicianDTO();
if (dr.Read())
{
pTecnico.Entity = new EntidadeDTO
{
Codigo = int.Parse(dr[0].ToString()),
NomeCompleto = dr[1].ToString(),
Categoria = dr[2].ToString(),
Identificacao = dr[3].ToString(),
Nacionalidade = !String.IsNullOrEmpty(dr[4].ToString()) ? int.Parse(dr[4].ToString()) : -1,
Rua = dr[5].ToString(),
Bairro = dr[6].ToString(),
Provincia = dr[7].ToString(),
MunicipioMorada = int.Parse(dr[8].ToString()),
Telefone = dr[9].ToString(),
TelefoneAlt = dr[10].ToString(),
Email = dr[11].ToString(),
};
pTecnico.FuncionarioID = dr[12].ToString();
pTecnico.GroupID = !String.IsNullOrEmpty(dr[13].ToString()) ? int.Parse(dr[13].ToString()) : -1;
pTecnico.Tipo = dr[14].ToString();
pTecnico.Filial = !String.IsNullOrEmpty(dr[13].ToString()) ? dr[13].ToString() : "-1";
pTecnico.ValorComissao = decimal.Parse(dr["COM_COMISSAO"].ToString());
}
}
catch (Exception ex)
{
pTecnico.Sucesso = false;
pTecnico.MensagemErro = ex.Message.Replace("'", "");
}
finally
{
BaseDados.FecharConexao();
}
return(pTecnico);
}
public List <TechnicianDTO> ObterPorFiltro(TechnicianDTO dto)
{
List <TechnicianDTO> lista;
try
{
BaseDados.ComandText = "stp_GER_TECNICO_OBTERPORFILTRO";
BaseDados.AddParameter("@NOME", dto.Entity.NomeCompleto);
BaseDados.AddParameter("@FILIAL", dto.Filial);
MySqlDataReader dr = BaseDados.ExecuteReader();
lista = new List <TechnicianDTO>();
while (dr.Read())
{
dto = new TechnicianDTO();
var entity = new EntidadeDTO();
entity.Codigo = int.Parse(dr[0].ToString());
entity.NomeCompleto = dr[1].ToString();
entity.Telefone = dr[2].ToString();
entity.TelefoneAlt = dr[3].ToString();
dto.Entity = entity;
dto.ValorComissao = decimal.Parse(dr[4].ToString());
dto.DesignacaoEntidade = dr[1].ToString();
dto.ProfissionalID = int.Parse(dr[0].ToString());
dto.FuncionarioID = dr[7].ToString();
lista.Add(dto);
}
}
catch (Exception ex)
{
dto = new TechnicianDTO();
dto.Sucesso = false;
dto.MensagemErro = ex.Message.Replace("'", "");
lista = new List <TechnicianDTO>();
lista.Add(dto);
}
finally
{
BaseDados.FecharConexao();
}
return(lista);
}
public async Task <IActionResult> InsertTechnician([FromBody] TechnicianDTO technician)
{
try
{
await _mediator.Send(new InsertTechnicianCommand(technician));
return(Ok(new
{
Ok = true,
Message = "Registro insertado exitosamente"
}));
}
catch (Exception e)
{
return(BadRequest(new
{
Ok = false,
Error = e
}));
}
}
public TechnicianDTO Excluir(TechnicianDTO dto)
{
try
{
BaseDados.ComandText = "stp_GER_TECNICO_EXCLUIR";
BaseDados.AddParameter("@ENTIDADE", dto.Entity.Codigo);
BaseDados.ExecuteNonQuery();
dto.Sucesso = true;
}
catch (Exception ex)
{
dto.Sucesso = false;
dto.MensagemErro = ex.Message.Replace("'", "");
}
finally
{
BaseDados.FecharConexao();
}
return(dto);
}
public InsertTechnicianCommand(TechnicianDTO technician)
{
technicianDTO = technician;
}
public List <TechnicianDTO> ObterPorFiltro(TechnicianDTO dto)
{
return(dao.ObterPorFiltro(dto));
}
public TechnicianDTO ObterFuncionario(TechnicianDTO dto)
{
return(dao.ObterPorPK(dto));
}
