private void populateFields(int pGetID = 0) { mdc = new ModelDataContext(); try { if (pGetID > 0) { Model.Aluno aluno = mdc.Aluno.First(alu => alu.idAluno == pGetID); tbCodAluno.Text = pGetID.ToString(); tbNome.Text = aluno.Nome.Trim(); tbEndereco.Text = aluno.Endereco.Trim(); tbCep.Text = aluno.Cep.Trim(); tbTelefone.Text = aluno.Telefone.Trim(); tbCelular.Text = aluno.Celular.Trim(); tbDataNasc.Text = aluno.dataNascimento.ToString(); } else { Response.Redirect("Aluno.aspx"); } } catch (Exception) { throw; } finally { mdc.Dispose(); } }
private void OnUpdate() { mdc = new ModelDataContext(); try { Model.Aluno aluno = mdc.Aluno.First(alu => alu.idAluno == int.Parse(tbCodAluno.Text.Trim())); aluno.Nome = tbNome.Text.Trim(); aluno.Endereco = tbEndereco.Text.Trim(); aluno.Cep = tbCep.Text.Trim(); aluno.Telefone = tbTelefone.Text.Trim(); aluno.Celular = tbCelular.Text.Trim(); aluno.dataNascimento = DateTime.Parse(tbDataNasc.Text.Trim()); aluno.dataAtualizacao = DateTime.Parse(DateTime.Now.ToShortDateString()); mdc.SubmitChanges(); Response.Redirect("Aluno.aspx"); } catch (Exception) { throw; } finally { mdc.Dispose(); } }
private void onInsert() { try { using (ModelDataContext mdc = new ModelDataContext()) { Model.Aluno aluno = new Model.Aluno() { Nome = tbNome.Text.Trim(), Endereco = tbEndereco.Text.Trim(), Cep = tbCep.Text.Trim(), Telefone = tbTelefone.Text.Trim(), Celular = tbCelular.Text.Trim(), dataNascimento = DateTime.Parse(tbDataNasc.Text.Trim()), dataCadastro = DateTime.Parse(DateTime.Now.ToShortDateString()) }; mdc.Aluno.InsertOnSubmit(aluno); mdc.SubmitChanges(); Response.Redirect("Aluno.aspx"); } } catch (Exception) { } }
private void onDelete() { mdc = new ModelDataContext(); try { Model.Aluno aluno = mdc.Aluno.First(alu => alu.idAluno == int.Parse(tbCodAluno.Text.Trim())); mdc.Aluno.DeleteOnSubmit(aluno); mdc.SubmitChanges(); Response.Redirect("Aluno.aspx"); } catch (Exception) { } finally { mdc.Dispose(); } }
partial void DeleteAluno(Aluno instance);
partial void UpdateAluno(Aluno instance);
partial void InsertAluno(Aluno instance);
public AlunoVM() { ModeloAluno = new Aluno (); EntrarCommand = new Command (this.Entrar); }