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