public static List <Models.Nacimientos> getNacSheetData() { using Models.notariadbContext db = new Models.notariadbContext(); var result = db.Nacimientos.ToList(); return(result); }
private void btnNewRegister_Click(object sender, EventArgs e) { if (tabControl.SelectedTab == tabPageNAC) { using (var form = new FormNacRegister()) { var result = form.ShowDialog(); if (result == DialogResult.OK) { Models.Nacimientos reg = form.Register; using (Models.notariadbContext db = new Models.notariadbContext()) { db.Add(reg); db.SaveChanges(); SheetController test = new SheetController(); test.UpdateSheets(nacSheetGridView, matSheetGridView, defSheetGridView, userSheetGridView); } } } } if (tabControl.SelectedTab == tabPageMAT) { using (var form = new FormMatRegister()) { var result = form.ShowDialog(); if (result == DialogResult.OK) { //DatabaseModel.insert(reg); } } } }
public static List <Models.Usuarios> getUserSheetData() { using Models.notariadbContext db = new Models.notariadbContext(); var result = db.Usuarios.ToList(); return(result); }
public static List <Models.Defunciones> getDefSheetData() { using Models.notariadbContext db = new Models.notariadbContext(); var result = db.Defunciones.ToList(); return(result); }
public static List <Models.Matrimonios> getMatSheetData() { using Models.notariadbContext db = new Models.notariadbContext(); var result = db.Matrimonios.ToList(); return(result); }
public void UpdateSheets(NacSheet ns, MatSheet ms, DefSheet ds, UserSheet us) { using (Models.notariadbContext db = new Models.notariadbContext()) { ns.DataSource = QueryController.getNacSheetData(); FormStylist.HideColumns(ns, "BloodtypeId", "BirthHour", "NotaryId", "WitnessId", "AttachId", "AttachDescription", "Fileroute", "Attach", "Bloodtype", "Dad", "Mom", "Notary", "Place", "Relateduser", "Witness"); ms.DataSource = QueryController.getMatSheetData(); FormStylist.HideColumns(ms, "NotaryId", "WitnessId", "AttachId", "AttachDescription", "Fileroute", "Attach", "Notary", "Place", "Relateduser1", "Relateduser2", "Witness"); ds.DataSource = QueryController.getDefSheetData(); FormStylist.HideColumns(ds, "MedicId", "WitnessId", "NotaryId", "AttachDescription", "Fileroute", "Medic", "Notary", "Place", "Relateduser", "Witness"); us.DataSource = QueryController.getUserSheetData(); FormStylist.HideColumns(us, "Doctype", "Notarios", "DefuncionesRelateduser", "DefuncionesWitness", "MatrimoniosRelateduser1", "MatrimoniosRelateduser2", "MatrimoniosWitness", "NacimientosDad", "NacimientosMom", "NacimientosRelateduser", "NacimientosWitness"); } }
public static Models.Usuarios userById(string id) { using Models.notariadbContext db = new Models.notariadbContext(); var result = db.Usuarios.Where(s => s.Id == id).ToList(); if (result.Count() == 0) { return(null); } return(result.First()); }
private void cDepartment_SelectedIndexChanged(object sender, EventArgs e) { int selection = int.Parse(cDepartment.SelectedValue.ToString()); using (Models.notariadbContext db = new Models.notariadbContext()) { cCity.DisplayMember = "Name"; cCity.ValueMember = "Id"; cCity.DataSource = (from p in db.Places join c in db.Cities on p.CityId equals c.Id where p.DepartmentId == selection select new { Id = p.PlaceId, Name = c.Name }).ToList(); cCity.SelectedItem = null; } }
private void FormNacRegister_Load(object sender, EventArgs e) { Controls.Add(gbMom.toGroupBox()); Controls.Add(gbDad.toGroupBox()); Controls.Add(gbWitness.toGroupBox()); using (Models.notariadbContext db = new Models.notariadbContext()) { // Sexo cSex.Items.Clear(); cSex.Items.Add("MASCULINO"); cSex.Items.Add("FEMENINO"); // Tipo de sangre cBloodtype.Items.Clear(); setComboBoxDisplay(cBloodtype, "BloodtypeId", "Name"); cBloodtype.DataSource = db.Bloodtypes.Select(s => new { s.BloodtypeId, s.Name }).ToList(); cBloodtype.SelectedItem = null; // Departamento cDepartment.Items.Clear(); setComboBoxDisplay(cDepartment, "Id", "Name"); cDepartment.DataSource = db.Departments.Select(s => new { s.Id, s.Name }).ToList(); cDepartment.SelectedIndex = 1; // Tipo de anexo cAttachtype.Items.Clear(); setComboBoxDisplay(cAttachtype, "AttachId", "Name"); cAttachtype.DataSource = db.NacAttaches.Select(s => new { s.AttachId, s.Name }).ToList(); // Notario cNotary.Items.Clear(); setComboBoxDisplay(cNotary, "Id", "Name"); cNotary.DataSource = db.Notarios.Join(db.Usuarios, n => n.UserId, u => u.Id, (n, u) => new { Id = n.UserId, Name = string.Concat(u.Name, " ", u.Surname) }).ToList(); } }