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);
}