public DatOrder()
{
imdCommonData = new IMDCommonData();
string FsConnectionString = "cnxMeditoc";
database = imdCommonData.DGetDatabase(FsConnectionString, "MeditocComercial", "Meditoc1");
spSaveConektaOrder = "sva_conekta_save_order";
spSaveCustomerInfo = "sva_conekta_save_customerinfo";
spSaveLineItem = "sva_conekta_save_lineitem";
spSaveCharge = "sva_conekta_save_charge";
spGetConektaOrder = "svc_conekta_get_order";
//switch (ConfigurationManager.ConnectionStrings[FsConnectionString].ProviderName)
//{
// case "System.Data.SqlClient":
// spSaveConektaOrder = "Orders.svaSaveConektaOrder";
// spSaveCustomerInfo = "Orders.svaSaveCustomerInfo";
// spSaveLineItem = "Orders.svaSaveLineItem";
// spSaveCharge = "Payments.svaSaveCharge";
// spGetConektaOrder = "Orders.svcGetConektaOrder";
// break;
// case "MySql.Data.MySqlClient":
// spSaveConektaOrder = "sva_save_conekta_order";
// spSaveCustomerInfo = "sva_save_customer_info";
// spSaveLineItem = "sva_save_line_item";
// spSaveCharge = "sva_save_charge";
// spGetConektaOrder = "svc_get_conekta_order";
// break;
// default:
// throw new Exception("No se ha especificado el motor de base de datos");
//}
}
public DatPromociones()
{
imdCommonData = new IMDCommonData();
string FsConnectionString = "cnxMeditoc";
database = imdCommonData.DGetDatabase(FsConnectionString, "MeditocComercial", "Meditoc1");
spSaveCupon = "sva_meditoc_save_cupon";
spGetCupones = "svc_meditoc_cupones";
spUnsubscribeCupon = "sva_meditoc_cupon_unsubscribe";
spGetNewIdCupon = "svc_meditoc_cupones_newid";
spGetCuponUsed = "svc_meditoc_cupones_used";
spGetCuponAutocomplete = "svc_meditoc_cupones_autocomplete";
//switch (ConfigurationManager.ConnectionStrings[FsConnectionString].ProviderName)
//{
// case "System.Data.SqlClient":
// spSaveCupon = "Orders.svaSaveConektaOrder";
// spGetCupones = "Orders.svaSaveCustomerInfo";
// spUnsubscribeCupon = "sve_unsubscribe_cupon";
// spGetNewIdCupon = "";
// spGetCuponUsed = "";
// spGetCuponAutocomplete = "";
// break;
// case "MySql.Data.MySqlClient":
// spSaveCupon = "sva_save_cupon";
// spGetCupones = "svc_get_cupones";
// spUnsubscribeCupon = "sve_unsubscribe_cupon";
// spGetNewIdCupon = "svc_get_new_id_cupon";
// spGetCuponUsed = "svc_get_cupon_used";
// spGetCuponAutocomplete = "svc_get_cupones_autocomplete";
// break;
// default:
// throw new Exception("No se ha especificado el motor de base de datos");
//}
}
public DatBoton()
{
imdCommonData = new IMDCommonData();
string FsConnectionString = "cnxMeditoc";
database = imdCommonData.DGetDatabase(FsConnectionString, "MeditocComercial", "Meditoc1");
spSaveBoton = "sva_cgu_save_boton";
}
public DatSubmodulo()
{
imdCommonData = new IMDCommonData();
string FsConnectionString = "cnxMeditoc";
database = imdCommonData.DGetDatabase(FsConnectionString, "MeditocComercial", "Meditoc1");
spSaveModulo = "sva_cgu_save_submodulo";
}
public DatCorreo()
{
imdCommonData = new IMDCommonData();
string FsConnectionString = "cnxMeditoc";
database = imdCommonData.DGetDatabase(FsConnectionString, "MeditocComercial", "Meditoc1");
spInsCorreo = "sva_meditoc_save_correo";
spGetCorreo = "svc_meditoc_correos";
}
public DatCallCenter()
{
imdCommonData = new IMDCommonData();
string FsConnectionString = "cnxMeditoc";
database = imdCommonData.DGetDatabase(FsConnectionString, "MeditocComercial", "Meditoc1");
spCallCenterOnline = "sva_meditoc_callcenter_online";
}
public DatProducto()
{
imdCommonData = new IMDCommonData();
string FsConnectionString = "cnxMeditoc";
database = imdCommonData.DGetDatabase(FsConnectionString, "MeditocComercial", "Meditoc1");
spSaveProducto = "sva_meditoc_save_producto";
spGetProductos = "svc_meditoc_ObtenerProductos";
}
public DatPermiso()
{
imdCommonData = new IMDCommonData();
string FsConnectionString = "cnxMeditoc";
database = imdCommonData.DGetDatabase(FsConnectionString, "MeditocComercial", "Meditoc1");
spSavePermiso = "sva_cgu_save_permiso";
spGetPermisosPerfil = "svc_cgu_system";
}
public DatReportes()
{
imdCommonData = new IMDCommonData();
string FsConnectionString = "cnxMeditoc";
database = imdCommonData.DGetDatabase(FsConnectionString, "MeditocComercial", "Meditoc1");
spGetReporteVentas = "svc_get_ventas_report";
spGetReporteDoctores = "svc_get_historial_doctores_report";
}
public DatEmpresa()
{
imdCommonData = new IMDCommonData();
string FsConnectionString = "cnxMeditoc";
database = imdCommonData.DGetDatabase(FsConnectionString, "MeditocComercial", "Meditoc1");
spSaveEmpresa = "sva_meditoc_save_empresa";
spGetEmpresa = "svc_meditoc_empresa";
}
public DatPaciente()
{
imdCommonData = new IMDCommonData();
string FsConnectionString = "cnxMeditoc";
database = imdCommonData.DGetDatabase(FsConnectionString, "MeditocComercial", "Meditoc1");
spSavePaciente = "sva_meditoc_save_paciente";
spGetPacientes = "svc_meditoc_pacientes";
spUpdPaciente = "sva_meditoc_upd_paciente";
}
public DatCatalogo()
{
imdCommonData = new IMDCommonData();
string FsConnectionString = "cnxMeditoc";
database = imdCommonData.DGetDatabase(FsConnectionString, "MeditocComercial", "Meditoc1");
spGetCatalogos = "svc_get_catalogos";
spSaveEspecialidad = "sva_cat_save_especialidad";
spGetEspecialidad = "svc_cat_especialidades";
spGetEspecialidadFiltrado = "svc_cat_especialidades_filtro";
}
public DatUsuario()
{
imdCommonData = new IMDCommonData();
string FsConnectionString = "cnxMeditoc";
database = imdCommonData.DGetDatabase(FsConnectionString, "MeditocComercial", "Meditoc1");
spSaveUsuario = "sva_cgu_save_usuario";
spGetUsuario = "svc_cgu_usuarios";
spChangePassword = "******";
spGetLogin = "******";
spValidaUsuarioCorreo = "svc_cgu_ValidaUsuarioCorreo";
}
public DatConsulta()
{
imdCommonData = new IMDCommonData();
string FsConnectionString = "cnxMeditoc";
database = imdCommonData.DGetDatabase(FsConnectionString, "MeditocComercial", "Meditoc1");
spSaveConsulta = "sva_meditoc_save_consulta";
spGetHistorialMedico = "svc_meditoc_historialclinico";
spGetDetalleConsulta = "svc_meditoc_consultas";
spGetDisponibilidadConsulta = "svc_meditoc_consultas_disponibilidad";
spDelConsulta = "sva_meditoc_del_consulta";
spSaveHistorialClinico = "sva_meditoc_save_historialclinico";
spGetConsultaMomento = "svc_meditoc_consultas_momento";
spGetConsultaPaciente = "svc_ObtenerConsultasByPaciente";
}
public DatColaborador()
{
imdCommonData = new IMDCommonData();
string FsConnectionString = "cnxMeditoc";
database = imdCommonData.DGetDatabase(FsConnectionString, "MeditocComercial", "Meditoc1");
spSaveColaborador = "sva_meditoc_save_colaborador";
spGetColaborador = "svc_meditoc_colaboradores";
spSaveColaboradorFoto = "sva_meditoc_save_colaboradorfoto";
spGetColaboradorFoto = "svc_meditoc_colaboradorfoto";
spDeleteColaboradorFoto = "sva_meditoc_del_colaboradorfoto";
spGetColaboradorDirectorio = "svc_meditoc_colaboradordirectorio";
spGetObtenerSala = "svc_app_ObtenerSala";
spGetColaboradorStatus = "svc_meditoc_colaborador_status";
}
public DatFolio()
{
imdCommonData = new IMDCommonData();
string FsConnectionString = "cnxMeditoc";
database = imdCommonData.DGetDatabase(FsConnectionString, "MeditocComercial", "Meditoc1");
spSaveFolio = "sva_meditoc_save_folio";
spGetloginApp = "svc_app_login";
spGetFolios = "svc_meditoc_folios";
spUpdFechaVencimiento = "sva_meditoc_upd_foliovigencia";
spDelFolioEmpresa = "sva_meditoc_del_folioempresa";
spUpdTerminosYCondiciones = "svc_meditoc_upd_terminosyCondiciones";
spUpdPassword = "******";
spSaveFolioVC = "sva_meditoc_save_foliovc";
spSaveFolioRequest = "sva_meditoc_save_folio_request";
spGetFolioRequest = "svc_meditoc_folio_request";
}
