protected void cmbTipo_SelectedIndexChanged(object sender, EventArgs e)
{
MaquinaDTO maquinaDTO = new MaquinaDTO();
maquinaDTO.idTipo = int.Parse(cmbTipo.SelectedValue.ToString());
maquinaDTO.idAluno = int.Parse(hdIdAluno.Value);
MaquinaBRL _brl = new MaquinaBRL();
DataTable dt = _brl.searchMaquinaByIdTipoAndIdAluno(maquinaDTO);
if (dt != null && dt.Rows.Count > 0)
{
txtNrSerie.Text = dt.Rows[0]["NrSerieMaquina"].ToString();
txtModelo.Text = dt.Rows[0]["ModeloMaquina"].ToString();
hdIdMaquina.Value = dt.Rows[0]["IdMaquina"].ToString();
hdIdAluno.Value = dt.Rows[0]["IdAluno"].ToString();
}
else
{
txtNrSerie.Text = "";
txtModelo.Text = "";
cmdAtualizar.Visible = false;
cmdGravar.Visible = true;
}
}
private void preencherDados()
{
try
{
MaquinaDTO _dto = new MaquinaDTO();
_dto.idAluno = int.Parse(hdIdAluno.Value);
MaquinaBRL _maquinaBRL = new MaquinaBRL();
DataTable dtMaquina = _maquinaBRL.searchMaquinaByIdAluno(_dto);
if (dtMaquina != null && dtMaquina.Rows.Count > 0)
{
cmbTipo.SelectedValue = dtMaquina.Rows[0]["IdTipo"].ToString();
txtNrSerie.Text = dtMaquina.Rows[0]["NrSerieMaquina"].ToString();
txtModelo.Text = dtMaquina.Rows[0]["ModeloMaquina"].ToString();
hdIdMaquina.Value = dtMaquina.Rows[0]["IdMaquina"].ToString();
hdIdAluno.Value = dtMaquina.Rows[0]["IdAluno"].ToString();
cmdGravar.Visible = false;
}
else
{
cmdAtualizar.Visible = false;
}
}
catch (Exception ex)
{
throw ex;
}
}
protected void cmdGravar_Click(object sender, EventArgs e)
{
try
{
if (Page.IsValid)
{
MaquinaDTO dto = new MaquinaDTO();
dto.modeloMaquina = txtModelo.Text;
dto.nrSerieMaquina = txtNrSerie.Text;
dto.idTipo = int.Parse(cmbTipo.SelectedValue);
//HttpCookie Session = Request.Cookies["BEPiDUCB.Site"];
//if (Session != null && !Session["I"].Equals("0")) //0 é para os administradores
dto.idAluno = int.Parse(hdIdAluno.Value);
MaquinaBRL brl = new MaquinaBRL();
if (brl.insertMaquina(dto))
{
//Response.Redirect("AllVinculo?Situacao=1");
lblResultado.Text = "Inserido com sucesso.";
}
}
}
catch (Exception ex)
{
lblResultado.Text = "Um erro aconteceu - " + ex.Message.ToString() + ex.StackTrace.ToString();
}
}
protected void cmdGravar_Click(object sender, EventArgs e)
{
try
{
if (Page.IsValid)
{
MaquinaDTO dto = new MaquinaDTO();
dto.modeloMaquina = txtModelo.Text;
dto.nrSerieMaquina = txtNrSerie.Text;
dto.idTipo = int.Parse(cmbTipo.SelectedValue);
dto.imei = txtIMEI.Text;
//HttpCookie Session = Request.Cookies["BEPiDUCB.Site"];
dto.idAluno = int.Parse(Session["IAluno"].ToString());
MaquinaBRL brl = new MaquinaBRL();
if (brl.insertMaquina(dto))
{
Response.Redirect("AddMaquina?Situacao=1");
}
}
}
catch (Exception ex)
{
lblResultado.Text = "Um erro aconteceu - " + ex.Message.ToString() + ex.StackTrace.ToString();
}
}
private void preencherGridMaquina()
{
MaquinaBRL brl = new MaquinaBRL();
grdMaquinas.DataSource = brl.allMachines();
grdMaquinas.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
//HttpCookie Session = Request.Cookies["BEPiDUCB.Site"];
//if (Session == null || Session["I"].ToString().Equals("0"))
if (Session == null)
{
Response.Redirect("Login");
}
else
{
//int idAluno = int.Parse(Session["I"].ToString());
int idAluno = int.Parse(Request.Params["id"].ToString());
AlunoDTO dto = new AlunoDTO();
dto.idAluno = idAluno;
BEPiD.Business.BRL.AlunoBRL alunoBRL = new Business.BRL.AlunoBRL();
DataTable dtAluno = alunoBRL.searchDadosPrincipais(dto);
if (dtAluno != null && dtAluno.Rows.Count > 0)
{
Session.Add("Endereco", dtAluno.Rows[0]["endereco"].ToString());
Session.Add("Cidade", dtAluno.Rows[0]["cidade"].ToString());
Session.Add("Identidade", dtAluno.Rows[0]["Identidade"].ToString());
Session.Add("Orgao", dtAluno.Rows[0]["orgao"].ToString());
Session.Add("Nacionalidade", dtAluno.Rows[0]["Nacionalidade"].ToString());
Session.Add("EstadoCivil", dtAluno.Rows[0]["EstadoCivil"].ToString());
Session.Add("CEP", dtAluno.Rows[0]["CEP"].ToString());
Session.Add("N", dtAluno.Rows[0]["Nome"].ToString());
Session.Add("C", dtAluno.Rows[0]["CPF"].ToString());
//buscando as máquinas
MaquinaDTO dtoMaquina = new MaquinaDTO();
dtoMaquina.idAluno = idAluno;
MaquinaBRL maquinaBRL = new MaquinaBRL();
DataTable dtMaquina = maquinaBRL.searchMaquinaByIdAluno(dtoMaquina);
for (int i = 0; i < dtMaquina.Rows.Count; i++)
{
Session.Add("NRSerie" + i, dtMaquina.Rows[i]["NrSerieMaquina"].ToString());
}
if (dtMaquina.Rows.Count == 0)
{
Session.Add("NRSerie0", "");
Session.Add("NRSerie1", "");
Session.Add("NRSerie2", "");
}
}
}
}
private void preencherGrid()
{
//HttpCookie Session = Request.Cookies["BEPiDUCB.Site"];
if (Session["IAluno"] != null) //0 é para os administradores
{
MaquinaDTO dto = new MaquinaDTO();
dto.idAluno = int.Parse(Session["IAluno"].ToString());
MaquinaBRL brl = new MaquinaBRL();
grdMaquinas.DataSource = brl.searchMaquinaByIdAluno(dto);
grdMaquinas.DataBind();
}
}
protected void grdMaquinas_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Deletar")
{
int _index = int.Parse((string)e.CommandArgument);
string chave = grdMaquinas.DataKeys[_index]["IdMaquina"].ToString();
MaquinaDTO dto = new MaquinaDTO();
dto.idMaquina = int.Parse(chave);
MaquinaBRL brl = new MaquinaBRL();
if (brl.deleteMaquina(dto))
{
Response.Redirect("AddMaquina.aspx?id=deletado");
}
}
}
protected void cmdAtualizar_Click(object sender, EventArgs e)
{
try
{
MaquinaDTO _dto = new MaquinaDTO();
_dto.idAluno = int.Parse(hdIdAluno.Value);
_dto.idMaquina = int.Parse(hdIdMaquina.Value);
_dto.modeloMaquina = txtModelo.Text;
_dto.nrSerieMaquina = txtNrSerie.Text;
_dto.idTipo = int.Parse(cmbTipo.SelectedValue);
MaquinaBRL _brl = new MaquinaBRL();
if (_brl.updateMaquina(_dto))
{
lblResultado.Text = "Atualizado com sucesso.";
}
}
catch (Exception ex)
{
throw ex;
}
}