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");
}
}
void applyStyles()
{
FormStylist.SetBgColorAndImage(btnNewRegister, SystemColors.Control, Properties.Resources.NewRegIcon);
FormStylist.SetBgColorAndImage(btnEditRegister, SystemColors.Control, Properties.Resources.EditRegIcon);
FormStylist.SetBgColorAndImage(btnDeleteRegister, SystemColors.Control, Properties.Resources.DeleteRegIcon);
FormStylist.SetBgColorAndImage(btnUserInfo, SystemColors.Control, Properties.Resources.UserIcon);
FormStylist.SetBgColorAndImage(btnPDF, SystemColors.Control, Properties.Resources.PDFIcon);
FormStylist.SetBgColorAndImage(btnExcel, SystemColors.Control, Properties.Resources.ExcelIcon);
toolTip.SetToolTip(btnNewRegister, "Agregar registro");
toolTip.SetToolTip(btnEditRegister, "Editar registro");
toolTip.SetToolTip(btnDeleteRegister, "Eliminar registro");
toolTip.SetToolTip(btnUserInfo, "Información del usuario");
toolTip.SetToolTip(btnPDF, "Abrir PDF");
toolTip.SetToolTip(btnExcel, "Exportar a Excel");
}
