private void BtnAceptar_Click(object sender, EventArgs e) { using (Entities db = new Entities()) { if (id == null) { nRegistro = new formulario_104(); } nRegistro.periodo = LblAño.Text; nRegistro.Ruc_Usuario = TxtRuc.Text; nRegistro.c401 = Convert.ToDouble(Lbl401.Text); nRegistro.c409 = Convert.ToDouble(Lbl409.Text); nRegistro.c411 = Convert.ToDouble(Lbl411.Text); nRegistro.c419 = Convert.ToDouble(Lbl419.Text); nRegistro.c421 = Convert.ToDouble(Lbl421.Text); nRegistro.c429 = Convert.ToDouble(Lbl429.Text); nRegistro.c499 = Convert.ToDouble(Lbl499.Text); nRegistro.r601 = Convert.ToDouble(Lbl601.Text); nRegistro.r605 = Convert.ToDouble(Lbl605.Text); nRegistro.r608 = Convert.ToDouble(Lbl608.Text); nRegistro.r609 = Convert.ToDouble(Lbl609.Text); nRegistro.r615 = Convert.ToDouble(Lbl615.Text); nRegistro.r620 = Convert.ToDouble(Lbl620.Text); nRegistro.r699 = Convert.ToDouble(Lbl699.Text); if (id == null) { db.formulario_104.Add(nRegistro); } //db.Entry(nRegistro).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); MessageBox.Show("Su formulario se registro exitosamente"); } }
private void cargarDatos(int?id) { using (Entities db = new Entities()) { if (id != null) { nRegistro = new formulario_104(); } var list = from d in db.formulario_104 where d.Ruc_Usuario == TxtRuc.Text && d.periodo == LblAño.Text select d; if (list.Count() > 0) { LblAño.Text = nRegistro.periodo; TxtRuc.Text = nRegistro.Ruc_Usuario; Lbl401.Text = Convert.ToString(nRegistro.c401); Lbl409.Text = Convert.ToString(nRegistro.c409); Lbl411.Text = Convert.ToString(nRegistro.c411); Lbl419.Text = Convert.ToString(nRegistro.c419); Lbl421.Text = Convert.ToString(nRegistro.c421); Lbl429.Text = Convert.ToString(nRegistro.c429); Lbl499.Text = Convert.ToString(nRegistro.c499); Lbl601.Text = Convert.ToString(nRegistro.r601); Lbl605.Text = Convert.ToString(nRegistro.r605); Lbl608.Text = Convert.ToString(nRegistro.r608); Lbl609.Text = Convert.ToString(nRegistro.r609); Lbl615.Text = Convert.ToString(nRegistro.r615); Lbl620.Text = Convert.ToString(nRegistro.r620); Lbl699.Text = Convert.ToString(nRegistro.r699); } else { MessageBox.Show("Actualizar formulario"); } } }