public bool InsDocContenido(BE_ReqDocContenido Request) { bool exito = false; try { clsConection Obj = new clsConection(); string Cadena = Obj.GetConexionString("Naylamp"); using (SqlConnection cn = new SqlConnection(Cadena)) { cn.Open(); using (SqlCommand cm = new SqlCommand()) { cm.CommandText = "[usp_Ins_DocContenido]"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("cDocCodigo", Request.cDocCodigo); cm.Parameters.AddWithValue("nDocConTipo", Request.nDocConTipo); cm.Parameters.AddWithValue("tDocConContenido", Request.tDocConContenido); cm.Connection = cn; if (cm.ExecuteNonQuery() > 0) { exito = true; } else throw new ApplicationException("se ha producido un error procedimiento almacenado: [usp_Ins_DocContenido]; Consulte al administrador del sistema"); } } } catch (Exception) { throw; } return exito; }
//para obtener correlativo SP: Get_NewCorrelativoRecCtaCteItem public string Get_NewCorrelativoRecCtaCteItem() { string Item = ""; try { clsConection Obj = new clsConection(); string Cadena = Obj.GetConexionString("Naylamp"); using (SqlConnection cn = new SqlConnection(Cadena)) { cn.Open(); using (SqlCommand cm = new SqlCommand()) { cm.CommandText = "usp_Get_NewCorrelativoRecCtaCteItem"; cm.CommandType = CommandType.StoredProcedure; cm.Connection = cn; SqlParameter pCod = new SqlParameter(); pCod.ParameterName = "cNewCorrelativo"; pCod.DbType = DbType.String; pCod.Size = 15; pCod.Direction = ParameterDirection.Output; cm.Parameters.Add(pCod); cm.ExecuteNonQuery(); Item = cm.Parameters["cNewCorrelativo"].Value.ToString(); } } } catch (Exception) { throw; } return Item; }
public Boolean delDelegado(BE_Req_Persona Request) { Boolean Item = new Boolean(); try { clsConection Obj = new clsConection(); string Cadena = Obj.GetConexionString("Naylamp"); using (SqlConnection cn = new SqlConnection(Cadena)) { cn.Open(); using (SqlCommand cm = new SqlCommand()) { cm.CommandText = "sp_del_Delegado"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("@cPerCodigo", Request.cPerCodigo); cm.Parameters.AddWithValue("@nPerParTipo", Request.nPerParTipo); cm.Parameters.AddWithValue("@cPerParCodigo", Request.cPerParCodigo); cm.Connection = cn; using (SqlDataReader dr = cm.ExecuteReader()) { Item = true; } } } } catch (Exception) { throw; } return Item; }
//Get_CtasCtes_Get_LibroVentas_Electronico public DataTable Get_CtasCtes_Get_LibroVentas_Electronico(BE_ReqBookElectronicoVta Request) { DataTable dt = new DataTable(); try { clsConection Obj = new clsConection(); string Cadena = Obj.GetConexionString("Naylamp"); using (SqlConnection cn = new SqlConnection(Cadena)) { cn.Open(); using (SqlCommand cm = new SqlCommand()) { cm.CommandText = "[usp_CtasCtes_Get_LibroVentas_Electronico]"; //cm.CommandTimeout = 0; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("Year", Request.Year); cm.Parameters.AddWithValue("Month", Request.Month); cm.Parameters.AddWithValue("Empresa", Request.Empresa); cm.Connection = cn; using (SqlDataReader dr = cm.ExecuteReader()) dt.Load(dr); } } } catch (Exception) { throw; } return dt; }
//---------------------------- // SELECT Get_ReportCuadraCaja //---------------------------- public DataTable Get_ReportCuadraCaja(BE_ReqRptCuadreCaja Request) { DataTable dt = new DataTable(); try { clsConection Obj = new clsConection(); string Cadena = Obj.GetConexionString("Naylamp"); using (SqlConnection cn = new SqlConnection(Cadena)) { cn.Open(); using (SqlCommand cm = new SqlCommand()) { cm.CommandText = "[usp_Get_ReportCuadreCaja]"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("cFlag", Request.cFlag); cm.Parameters.AddWithValue("dCtaCteComFecIni", Request.dCtaCteComFecIni); cm.Parameters.AddWithValue("dCtaCteComFecFin", Request.dCtaCteComFecFin); cm.Connection = cn; using (SqlDataReader dr = cm.ExecuteReader()) dt.Load(dr); } } } catch (Exception) { throw; } return dt; }
//Get_CtaCteNumeracion public DataTable Get_CtaCteNumeracion(BE_ReqCtaCteNumeracion Request) { DataTable dt = new DataTable(); try { clsConection Obj = new clsConection(); string Cadena = Obj.GetConexionString("Naylamp"); using (SqlConnection cn = new SqlConnection(Cadena)) { cn.Open(); using (SqlCommand cm = new SqlCommand()) { cm.CommandText = "usp_Get_CtaCteNumeracion"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("cPerJurCodigo", Request.cPerJurCodigo); cm.Connection = cn; using (SqlDataReader dr = cm.ExecuteReader()) dt.Load(dr); } } } catch (Exception) { throw; } return dt; }
public DataTable Get_SearhUsuario(BE_ReqSearhUsuario Request) { //string Item = ""; try { clsConection Obj = new clsConection(); string Cadena = Obj.GetConexionString("Naylamp"); using (SqlConnection cn = new SqlConnection(Cadena)) { cn.Open(); using (SqlCommand cm = new SqlCommand()) { cm.CommandText = "usp_Get_PerUsuario"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("cPerCodigo", Request.PerCodigo); cm.Parameters.AddWithValue("cPerUsuClave", Request.cPerUsuClave); cm.Connection = cn; using (SqlDataReader dr = cm.ExecuteReader()) dt.Load(dr); } } } catch (Exception) { throw; } return dt; }
//------------------------------------- //Buscar AdmSolicitud - para actualizar //-------------------------------------- public DataTable Get_AdmSolicitudAcademica(BE_ReqSolRegistro Request) { DataTable dt = new DataTable(); try { clsConection Obj = new clsConection(); string Cadena = Obj.GetConexionString("Naylamp"); using (SqlConnection cn = new SqlConnection(Cadena)) { cn.Open(); using (SqlCommand cm = new SqlCommand()) { cm.CommandText = "usp_Get_AdmSolicitudAcademica"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("nSolAdmNumero", Request.nSolAdmNumero); cm.Connection = cn; using (SqlDataReader dr = cm.ExecuteReader()) dt.Load(dr); } } } catch (Exception) { throw; } return dt; }
//----------------------------------------------- // Select: Interface por (nIntClase and nIntTipo) //----------------------------------------------- public DataTable Get_Interface(BE_ReqInterface Request) { DataTable dt = new DataTable(); try { clsConection Obj = new clsConection(); string Cadena = Obj.GetConexionString("Naylamp"); using (SqlConnection cn = new SqlConnection(Cadena)) { cn.Open(); using (SqlCommand cm = new SqlCommand()) { cm.CommandText = "[usp_Get_Interface]"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("nIntClase", Request.nIntClase); cm.Parameters.AddWithValue("nIntTipo", Request.nIntTipo); cm.Parameters.AddWithValue("cFlag", Request.cFlag); cm.Connection = cn; using (SqlDataReader dr = cm.ExecuteReader()) dt.Load(dr); } } } catch (Exception) { throw; } return dt; }
public DataTable GetPeriodosByActividad(BE_Req_Periodo Request) { DataTable Rs = new DataTable(); try { clsConection Obj = new clsConection(); string Cadena = Obj.GetConexionString("Naylamp"); using (SqlConnection cn = new SqlConnection(Cadena)) { cn.Open(); using (SqlCommand cm = new SqlCommand()) { cm.CommandText = "sp_get_PeriodosByActividad"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("nPrdActividad", Request.nPrdActividad); cm.Connection = cn; using (SqlDataReader dr = cm.ExecuteReader()) { Rs.Load(dr); } } } } catch (Exception) { throw; } return Rs; }
public SqlDataReader DRListaDelegados_BycPerCodigo(BE_Req_Persona Request) { SqlDataReader Rs; try { clsConection Obj = new clsConection(); string Cadena = Obj.GetConexionString("Naylamp"); using (SqlConnection cn = new SqlConnection(Cadena)) { cn.Open(); using (SqlCommand cm = new SqlCommand()) { cm.CommandText = "sp_get_Delegados"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("cPerCodigo", Request.cPerCodigo); cm.Connection = cn; using (SqlDataReader dr = cm.ExecuteReader()) { Rs = dr; } } } } catch (Exception) { throw; } return Rs; }
//---------------------------------------------------------------- // SELECT usp_Get_CtaCteItem_for_cCtaCteRecibo_by_range_fechas //---------------------------------------------------------------- public DataTable Get_CtaCteItem_for_cCtaCteRecibo_by_range_fechas(BE_ReqBuscaComprobante Request) { DataTable dt = new DataTable(); try { clsConection Obj = new clsConection(); string Cadena = Obj.GetConexionString("Naylamp"); using (SqlConnection cn = new SqlConnection(Cadena)) { cn.Open(); using (SqlCommand cm = new SqlCommand()) { cm.CommandText = "[usp_Get_CtaCteItem_for_cCtaCteRecibo_by_range_fechas]"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("cFlag", Request.cFlag); cm.Parameters.AddWithValue("dFecIni", Request.dFecIni); cm.Parameters.AddWithValue("dFecFin", Request.dFecFin); cm.Parameters.AddWithValue("cCtaCteRecibo", Request.cCtaCteRecibo); cm.Connection = cn; using (SqlDataReader dr = cm.ExecuteReader()) dt.Load(dr); } } } catch (Exception) { throw; } return dt; }
//--------------------------------------------------- //Obtener Lista de dias por mes (form tipo de cambio) //--------------------------------------------------- public DataTable Get_DiasxMes(BE_ReqGetDias Request) { DataTable dt = new DataTable(); try { clsConection Obj = new clsConection(); string Cadena = Obj.GetConexionString("Naylamp"); using (SqlConnection cn = new SqlConnection(Cadena)) { cn.Open(); using (SqlCommand cm = new SqlCommand()) { cm.CommandText = "usp_Get_ListaFechaporMes"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("sMes", Request.sMes); cm.Connection = cn; using (SqlDataReader dr = cm.ExecuteReader()) dt.Load(dr); } } } catch (Exception) { throw; } return dt; }
public BE_ResGenerico ExecInsUpdConstante(BE_ReqInsUpdConstante Request) { BE_ResGenerico Item = new BE_ResGenerico(); long Resultado = 0; try { clsConection Obj = new clsConection(); string Cadena = Obj.GetConexionString("Naylamp"); using (SqlConnection cn = new SqlConnection(Cadena)) { cn.Open(); using (SqlCommand cm = new SqlCommand()) { cm.CommandText = "usp_InsUpd_Contante"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("flag", Request.flag); cm.Parameters.AddWithValue("nConCodigo", Request.nConCodigo); cm.Parameters.AddWithValue("cConDescripcion", Request.cConDescripcion); cm.Parameters.AddWithValue("nConValor", Request.nConValor); cm.Connection = cn; Resultado = cm.ExecuteNonQuery(); Item.Resultado = Resultado; } } } catch (Exception) { throw; } return Item; }
//--------------------------------------------------- //Obtener PerInterface "Get_PerInterface" //-------------------------------------------------- public DataTable Get_PerInterface() { DataTable dt = new DataTable(); try { clsConection Obj = new clsConection(); string Cadena = Obj.GetConexionString("Naylamp"); using (SqlConnection cn = new SqlConnection(Cadena)) { cn.Open(); using (SqlCommand cm = new SqlCommand()) { cm.CommandText = "[usp_Get_PerInterface]"; cm.CommandType = CommandType.StoredProcedure; cm.Connection = cn; using (SqlDataReader dr = cm.ExecuteReader()) dt.Load(dr); } } } catch (Exception) { throw; } return dt; }
public DataTable ObtenerInstitucionesBycPerCodigo(BE_Req_UniOrgPerExt Request) { DataTable lista = new DataTable(); try { clsConection Obj = new clsConection(); string Cadena = Obj.GetConexionString("Naylamp"); using (SqlConnection cn = new SqlConnection(Cadena)) { cn.Open(); using (SqlCommand cm = new SqlCommand()) { cm.CommandText = "sp_get_Instituciones_BycPerCodigo"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("cPerCodigo", Request.cPerCodigo); cm.Connection = cn; using (SqlDataReader dr = cm.ExecuteReader()) { lista.Load(dr); } } } } catch (Exception) { throw; } return lista; }
public BE_Res_Periodo get_PeriodoActual_ByActividad(BE_Req_Periodo Request) { BE_Res_Periodo Item = new BE_Res_Periodo(); try { clsConection Obj = new clsConection(); string Cadena = Obj.GetConexionString("Naylamp"); using (SqlConnection cn = new SqlConnection(Cadena)) { cn.Open(); using (SqlCommand cm = new SqlCommand()) { cm.CommandText = "sp_get_PeriodoActual_ByActividad"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("nPrdActividad", Request.nPrdActividad); cm.Connection = cn; using (SqlDataReader dr = cm.ExecuteReader()) { while (dr.Read()) { Item.cPrdDescripcion = dr.GetString(dr.GetOrdinal("cPrdDescripcion")).Trim(); Item.nPrdCodigo = dr.GetInt32(dr.GetOrdinal("nPrdCodigo")); } } } } } catch (Exception) { throw; } return Item; }
public DataTable getDocAcuerdoAvanceByPersona(BE_Req_Documento Request) { BE_Res_Documento Item = new BE_Res_Documento(); DataTable Rs = new DataTable(); try { clsConection Obj = new clsConection(); string Cadena = Obj.GetConexionString("Naylamp"); using (SqlConnection cn = new SqlConnection(Cadena)) { cn.Open(); using (SqlCommand cm = new SqlCommand()) { cm.CommandText = "sp_get_Acuerdo_Anvance_By_Persona"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("cDocCodigo", Request.cDocCodigo); cm.Parameters.AddWithValue("cPerCodigo", Request.cPerCodigo); cm.Connection = cn; using (SqlDataReader dr = cm.ExecuteReader()) { Rs.Load(dr); } } } } catch (Exception) { throw; } return Rs; }
public DataTable getUbigeoBycUbiGeoCodigo(BE_Req_Ubigeo Request) { DataTable Rs = new DataTable(); try { clsConection Obj = new clsConection(); string Cadena = Obj.GetConexionString("Naylamp"); using (SqlConnection cn = new SqlConnection(Cadena)) { cn.Open(); using (SqlCommand cm = new SqlCommand()) { cm.CommandText = "sp_getUbigeoBycUbiGeoCodigo"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("cUbiGeoCodigo", Request.cUbiGeoCodigo); cm.Connection = cn; using (SqlDataReader dr = cm.ExecuteReader()) { Rs.Load(dr); } } } } catch (Exception) { throw; } return Rs; }
//----------------------- //fecha servidor (global) //----------------------- public string Get_FechaServidor(BE_ReqFechaServidor Request) { string Item = ""; try { clsConection Obj = new clsConection(); string Cadena = Obj.GetConexionString("Naylamp"); using (SqlConnection cn = new SqlConnection(Cadena)) { cn.Open(); using (SqlCommand cm = new SqlCommand()) { cm.CommandText = "SET LANGUAGE 'Español' SELECT CONVERT(CHAR(10),GETDATE(),103) FechaServerSQL "; cm.CommandType = CommandType.Text; //cm.Parameters.AddWithValue("cPerJurCodigo", Request.cPerCodigo); cm.Connection = cn; using (SqlDataReader dr = cm.ExecuteReader()) { while (dr.Read()) { Item = dr.GetString(dr.GetOrdinal("FechaServerSQL")).Trim(); } } } } } catch (Exception) { throw; } return Item; }
//------------------------------ // Get Comprobante(s) de venta //------------------------------- public DataTable Get_Comprobante_Venta_by_cPerJurCodigo_nCtaCteComCodigo_cCtaCteComNumero(BE_ReqBuscaComprobante Request) { DataTable dt = new DataTable(); try { clsConection Obj = new clsConection(); string Cadena = Obj.GetConexionString("Naylamp"); using (SqlConnection cn = new SqlConnection(Cadena)) { cn.Open(); using (SqlCommand cm = new SqlCommand()) { cm.CommandText = "[usp_Get_Comprobante_Venta]"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("cPerJurCodigo", Request.cPerJurCodigo); cm.Parameters.AddWithValue("nCtaCteComCodigo", Request.nCtaCteComCodigo); cm.Parameters.AddWithValue("cCtaCteComNumero", Request.cCtaCteComNumero); cm.Parameters.AddWithValue("fecini", Request.dFecIni); cm.Parameters.AddWithValue("fecfin", Request.dFecFin); cm.Parameters.AddWithValue("Flag", Request.cFlag); cm.Connection = cn; using (SqlDataReader dr = cm.ExecuteReader()) dt.Load(dr); } } } catch (Exception) { throw; } return dt; }
public DataTable GetConstante(BE_Req_Constante Request) { DataTable Item = new DataTable(); try { clsConection Obj = new clsConection(); string Cadena = Obj.GetConexionString("Naylamp"); using (SqlConnection cn = new SqlConnection(Cadena)) { cn.Open(); using (SqlCommand cm = new SqlCommand()) { cm.CommandText = "sp_Get_Constantes_BynConCodigo"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("nConCodigo", Request.nConCodigo); cm.Parameters.AddWithValue("cConValor", Request.cConValor); cm.Connection = cn; using (SqlDataReader dr = cm.ExecuteReader()) { Item.Load(dr); } } } } catch (Exception) { throw; } return Item; }
//----------------------------- // SELECT SysConfParametrosServ //----------------------------- public DataTable Get_SysConfParametrosServ(BE_ReqCtaCteSysConfigParamterServicio Request) { DataTable dt = new DataTable(); try { clsConection Obj = new clsConection(); string Cadena = Obj.GetConexionString("Naylamp"); using (SqlConnection cn = new SqlConnection(Cadena)) { cn.Open(); using (SqlCommand cm = new SqlCommand()) { cm.CommandText = "[usp_Get_SysConfParametrosServ]"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("cPerJurCodigo", Request.cPerJurCodigo); cm.Parameters.AddWithValue("nSisModulo", Request.nSisModulo); cm.Parameters.AddWithValue("nParCodigo_nProCodigo", Request.nParCodigo_nProCodigo); cm.Parameters.AddWithValue("cFlag", Request.cFLag); cm.Connection = cn; using (SqlDataReader dr = cm.ExecuteReader()) dt.Load(dr); } } } catch (Exception) { throw; } return dt; }
public DataTable Get_CboListUsuario(BE_ReqSearhUsuario Request) { //string Item = ""; //DataTable dt = new DataTable(); try { clsConection Obj = new clsConection(); string Cadena = Obj.GetConexionString("Naylamp"); using (SqlConnection cn = new SqlConnection(Cadena)) { cn.Open(); using (SqlCommand cm = new SqlCommand()) { cm.CommandText = "SELECT cPerCodigo , cPerUsuCodigo FROM PerUsuario"; cm.CommandType = CommandType.Text; cm.Connection = cn; using (SqlDataReader dr = cm.ExecuteReader()) dt.Load(dr); } } } catch (Exception) { throw; } return dt; }
//---------------------------------------- // SELECT usp_Get_RptVarios_for_Colegiado //--------------------------------------- public DataTable usp_Get_RptVarios_for_Colegiado(BE_ReqRptColegiado Request) { DataTable dt = new DataTable(); try { clsConection Obj = new clsConection(); string Cadena = Obj.GetConexionString("Naylamp"); using (SqlConnection cn = new SqlConnection(Cadena)) { cn.Open(); using (SqlCommand cm = new SqlCommand()) { cm.CommandText = "[usp_Get_RptVarios_for_Colegiado]"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("cNameRpt ", Request.cNameRpt); cm.Parameters.AddWithValue("dFecIni", Request.dFecIni); cm.Parameters.AddWithValue("dFecFin", Request.dFecFin); cm.Parameters.AddWithValue("cPerCodigo", Request.cPerCodigo); cm.Parameters.AddWithValue("nCtaCteSerCodigo", Request.nCtaCteSerCodigo); cm.Parameters.AddWithValue("cEstado ", Request.cEstado); cm.Connection = cn; using (SqlDataReader dr = cm.ExecuteReader()) dt.Load(dr); } } } catch (Exception) { throw; } return dt; }
//CtaCte_Get_Colegiadohabil_By_Servicio public DataTable CtaCte_Get_Colegiadohabil_By_Servicio(BE_ReqCtaCte_Get_Colegiadohabil_By_Servicio Request) { DataTable dt = new DataTable(); try { clsConection Obj = new clsConection(); string Cadena = Obj.GetConexionString("Naylamp"); using (SqlConnection cn = new SqlConnection(Cadena)) { cn.Open(); using (SqlCommand cm = new SqlCommand()) { cm.CommandText = "[usp_CtaCte_Get_Colegiadohabil_By_Servicio]"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("cPerCodigo", Request.cPerCodigo); cm.Parameters.AddWithValue("cperideNumero", Request.cperideNumero); cm.Parameters.AddWithValue("fechaCorte", Request.fechaCorte); cm.Parameters.AddWithValue("nintCodigo", Request.nintCodigo); cm.Connection = cn; using (SqlDataReader dr = cm.ExecuteReader()) dt.Load(dr); } } } catch (Exception) { throw; } return dt; }
//-------------------------- // DELETE CtaCteSerImpuesto //-------------------------- public BE_ResGenerico Del_CtaCteSerImpuesto(BE_ReqCtaCteSerImpuesto Request) { BE_ResGenerico Item = new BE_ResGenerico(); long Resultado = 0; try { clsConection Obj = new clsConection(); string Cadena = Obj.GetConexionString("Naylamp"); using (SqlConnection cn = new SqlConnection(Cadena)) { cn.Open(); using (SqlCommand cm = new SqlCommand()) { cm.CommandText = "usp_Del_CtaCteSerImpuesto"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("cPerJurCodigo", Request.cPerJurCodigo); cm.Parameters.AddWithValue("nCtaCteSerCodigo", Request.nCtaCteSerCodigo); cm.Parameters.AddWithValue("nSysTasContry", Request.nSysTasContry); cm.Parameters.AddWithValue("nSysTasCodigo", Request.nSysTasCodigo); cm.Connection = cn; Resultado = cm.ExecuteNonQuery(); Item.Resultado = Resultado; } } } catch (Exception) { throw; } return Item; }
//[usp_Get_PerCuenta] Obtener Entidad financieras segun Forma de pago public DataTable Get_EntidadFinaciera_Tarjetas(BE_ReqBuscarEntidadFinanciera Request) { DataTable dt = new DataTable(); try { clsConection Obj = new clsConection(); string Cadena = Obj.GetConexionString("Naylamp"); using (SqlConnection cn = new SqlConnection(Cadena)) { cn.Open(); using (SqlCommand cm = new SqlCommand()) { cm.CommandText = "[usp_Get_PerCuenta_for_entidad_bancaria]"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("cFlag", Request.cFlag); cm.Parameters.AddWithValue("cPerJurCodigo", Request.cPerJurCodigo); cm.Parameters.AddWithValue("cPerCodigo", Request.cPerCodigo); cm.Parameters.AddWithValue("nPerIntCodigo", Request.nPerIntCodigo); cm.Connection = cn; using (SqlDataReader dr = cm.ExecuteReader()) dt.Load(dr); } } } catch (Exception) { throw; } return dt; }
public DataTable get_TraDoc_Procesos(BE_Req_TraDoc Request) { BE_Res_TraDoc Item = new BE_Res_TraDoc(); DataTable Rs = new DataTable(); try { clsConection Obj = new clsConection(); string Cadena = Obj.GetConexionString("Naylamp"); using (SqlConnection cn = new SqlConnection(Cadena)) { cn.Open(); using (SqlCommand cm = new SqlCommand()) { cm.CommandText = "SP_TraDoc_Procesos"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("Opcion", Request.iOpcion); cm.Parameters.AddWithValue("cPerCodigo", Request.cPerCodigo); cm.Parameters.AddWithValue("nPerRemFiltro", Request.nPerRemFiltro); cm.Parameters.AddWithValue("nPerRecFiltro", Request.nPerRecFiltro); cm.Parameters.AddWithValue("nDocNumFiltro", Request.nDocNumFiltro); cm.Parameters.AddWithValue("cDocNDoc", Request.cDocNDoc); cm.Parameters.AddWithValue("nItemFiltro", Request.nItemFiltro); cm.Parameters.AddWithValue("nAsuFiltro", Request.nAsuFiltro); cm.Parameters.AddWithValue("cDocConContenido", Request.cDocConContenido); cm.Parameters.AddWithValue("nPrdCodigo", Request.nPrdCodigo); cm.Parameters.AddWithValue("nDocTipo", Request.nDocTipo); cm.Parameters.AddWithValue("nFilMes", Request.nFilMes); cm.Parameters.AddWithValue("cInvPerCodigo", Request.cInvPerCodigo); cm.Parameters.AddWithValue("cDocEstado", Request.cDocEstado); cm.Parameters.AddWithValue("nMesCodigo", Request.nMesCodigo); cm.Parameters.AddWithValue("cUniOrgTransferencia", Request.cUniOrgTransferencia); cm.Parameters.AddWithValue("cDocPerTipo", Request.cDocPerTipo); cm.Parameters.AddWithValue("cFecIni", Request.cFecIni); cm.Connection = cn; using (SqlDataReader dr = cm.ExecuteReader()) { Rs.Load(dr); } } } } catch (Exception) { throw; } //return Item; return Rs; }
//----------------------------------------------- // Procedimiento: usp_Set_ProgramarCuotaOrdinaria //------------------------------------------------ public long Set_ProgramarCuotaOrdinaria(BE_ReqProgramacionBath Request) { long nRowCount = 0; try { clsConection Obj = new clsConection(); string Cadena = Obj.GetConexionString("Naylamp"); using (SqlConnection cn = new SqlConnection(Cadena)) { cn.Open(); using (SqlCommand cm = new SqlCommand()) { cm.CommandText = "[usp_Set_ProgramarCuotaOrdinaria]"; cm.CommandType = CommandType.StoredProcedure; cm.CommandTimeout = 0; cm.Parameters.AddWithValue("cPerJurCodigo", Request.cPerJurCodigo); cm.Parameters.AddWithValue("nPrdCodigo", Request.nPrdCodigo); cm.Parameters.AddWithValue("nCtaCteSerCodigo", Request.nCtaCteSerCodigo); cm.Parameters.AddWithValue("nMesProceso", Request.nMesProceso); cm.Parameters.AddWithValue("cPerCodigo", Request.cPerCodigo); cm.Parameters.AddWithValue("cPerColeFalle", Request.cPerColeFalle); cm.Parameters.AddWithValue("dFecFallece", Request.dFecFallece); cm.Connection = cn; SqlParameter nParametro = new SqlParameter(); nParametro.ParameterName = "nEstado"; nParametro.DbType = DbType.Int32; nParametro.Direction = ParameterDirection.Output; cm.Parameters.Add(nParametro); cm.ExecuteNonQuery(); nRowCount = Convert.ToInt32(cm.Parameters["nEstado"].Value); if (nRowCount == 0) { throw new ApplicationException("No se encontraron Colegiado para crear cronograma."); } //OJO hay que corregir esto para futuras actulizacion colocar la logica en el BL //para verificar si exito o no registro para luego insertar //else throw new ApplicationException("se ha producido un error procedimiento almacenado: [usp_Set_ProgramarCuotaOrdinaria]; Consulte al administrador del sistema"); } } } catch (Exception) { throw; } return nRowCount; }
//------------------------- // Insert CtaCteIntDetalle //------------------------- public bool Ins_CtaCteIntDetalle(ReqCtaCteIntDetalle Objeto) { bool exito = false; try { clsConection Obj = new clsConection(); string Cadena = Obj.GetConexionString("Naylamp"); using (SqlConnection cn = new SqlConnection(Cadena)) { cn.Open(); using (SqlCommand cm = new SqlCommand()) { cm.CommandText = "[usp_Ins_CtaCteIntDetalle]"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("cCtaCteRecibo", Objeto.cCtaCteRecibo); cm.Parameters.AddWithValue("nIntCodigo", Objeto.nIntCodigo); cm.Parameters.AddWithValue("nIntClase", Objeto.nIntClase); cm.Parameters.AddWithValue("cIntJerarquia", Objeto.cIntJerarquia); cm.Parameters.AddWithValue("cIntValor", Objeto.cIntValor); cm.Connection = cn; if (cm.ExecuteNonQuery() > 0) { exito = true; } else { throw new ApplicationException("se ha producido un error procedimiento almacenado: [usp_Ins_CtaCteIntDetalle]; Consulte al administrador del sistema"); } } } } catch (Exception) { throw; } return(exito); }
//---------------------- // Insert AdmSolPerToken //---------------------- public bool Upd_AdmSolPerToken(AdmSolPerToken admSolPerToken) { bool exito = false; try { clsConection Obj = new clsConection(); string Cadena = Obj.GetConexionString("Naylamp"); using (SqlConnection cn = new SqlConnection(Cadena)) { cn.Open(); using (SqlCommand cm = new SqlCommand()) { cm.CommandText = "[usp_Upd_AdmSolPerToken]"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("cPerCodigo", admSolPerToken.cPerCodigo); cm.Parameters.AddWithValue("cPerJurCodigo", admSolPerToken.cPerJurCodigo); cm.Parameters.AddWithValue("cToken", admSolPerToken.cToken); cm.Parameters.AddWithValue("nTipo", admSolPerToken.nTipo); cm.Parameters.AddWithValue("nSolAdmNumero", admSolPerToken.nSolAdmNumero); cm.Connection = cn; if (cm.ExecuteNonQuery() > 0) { exito = true; } else { throw new ApplicationException("se ha producido un error procedimiento almacenado: [usp_Upd_AdmSolPerToken]; Consulte al administrador del sistema"); } } } } catch (Exception) { throw; } return(exito); }
//---------------------------------- //Update Solicitud - AdmSolAcademica //---------------------------------- public bool Upd_AdmSolicitudAcademica(BE_ReqSolRegistro Request) { bool exito; try { clsConection Obj = new clsConection(); string Cadena = Obj.GetConexionString("Naylamp"); using (SqlConnection cn = new SqlConnection(Cadena)) { cn.Open(); using (SqlCommand cm = new SqlCommand()) { cm.CommandText = "usp_UpdAdmSolicitudAcademica"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("cPerJuridica", Request.cPerJuridica); cm.Parameters.AddWithValue("nProCodigo", Request.nProCodigo); cm.Parameters.AddWithValue("nSolAdmNumero", Request.nSolAdmNumero); cm.Parameters.AddWithValue("cPerJurCodigo", Request.cPerJurCodigo); cm.Parameters.AddWithValue("dAdmSolAcaFecEgreso", Request.dAdmSolAcaFecEgreso); cm.Parameters.AddWithValue("nAdmSolEspCodigo", Request.nAdmSolEspCodigo); cm.Connection = cn; if (cm.ExecuteNonQuery() > 0) { exito = true; } else { exito = false; } } } } catch (Exception) { throw; } return(exito); }
//------------------ // Insert DocPersona //------------------ public bool Ins_DocPersona(BE_ReqDocPersona Request) { bool exito = false; try { clsConection Obj = new clsConection(); string Cadena = Obj.GetConexionString("Naylamp"); using (SqlConnection cn = new SqlConnection(Cadena)) { cn.Open(); using (SqlCommand cm = new SqlCommand()) { cm.CommandText = "[usp_Ins_DocPersona]"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("cDocCodigo", Request.cDocCodigo); cm.Parameters.AddWithValue("nDocPerTipo", Request.nDocPerTipo); cm.Parameters.AddWithValue("cPerCodigo", Request.cPerCodigo); cm.Parameters.AddWithValue("nPerRelacion", Request.nPerRelacion); cm.Parameters.AddWithValue("nDocTipo", Request.nDocTipo); cm.Connection = cn; if (cm.ExecuteNonQuery() > 0) { exito = true; } else { throw new ApplicationException("se ha producido un error procedimiento almacenado: [usp_Ins_DocPersona]; Consulte al administrador del sistema"); } } } } catch (Exception) { throw; } return(exito); }
//---------------------- // DELETE CtaCteIteLine //---------------------- public bool Del_CtaCteIteLine(BE_ReqCtaCteIteLine Request) { bool exito = false; try { clsConection Obj = new clsConection(); string Cadena = Obj.GetConexionString("Naylamp"); using (SqlConnection cn = new SqlConnection(Cadena)) { cn.Open(); using (SqlCommand cm = new SqlCommand()) { cm.CommandText = "[usp_Del_CtaCteIteLine]"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("cPerJurCodigo", Request.cPerJurCodigo); cm.Parameters.AddWithValue("cPerCodigo", Request.cPerCodigo); cm.Parameters.AddWithValue("cCtaCteRecibo", Request.cCtaCteRecibo); cm.Parameters.AddWithValue("nCtaCteRecLine", Request.nCtaCteRecLine); cm.Parameters.AddWithValue("nCtaCteSerCodigo", Request.nCtaCteSerCodigo); cm.Connection = cn; if (cm.ExecuteNonQuery() > 0) { exito = true; } else { throw new ApplicationException("se ha producido un error procedimiento almacenado: [usp_Del_CtaCteIteLine]; Consulte al administrador del sistema"); } } } } catch (Exception) { throw; } return(exito); }
public String Get_PerAsigPromotor_By_nPerAsigEstado_dEffDate(PerAsigPromotor perAsigPromotor) { string Item = ""; try { clsConection Obj = new clsConection(); string Cadena = Obj.GetConexionString("Naylamp"); using (SqlConnection cn = new SqlConnection(Cadena)) { cn.Open(); using (SqlCommand cm = new SqlCommand()) { cm.CommandText = "[usp_Get_PerAsigPromotor_By_nPerAsigEstado_dEffDate]"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("@cPerAsigCodigo", perAsigPromotor.cPerAsigCodigo); cm.Parameters.AddWithValue("@nPerAsigEstado", perAsigPromotor.nPerAsigEstado); cm.Parameters.AddWithValue("@nPerAsigTipo", perAsigPromotor.nPerAsigTipo); // cm.Connection = cn; SqlParameter dEffDate = new SqlParameter(); dEffDate.ParameterName = "@dEffDate"; dEffDate.DbType = DbType.String; dEffDate.Size = 8; dEffDate.Direction = ParameterDirection.Output; cm.Parameters.Add(dEffDate); cm.ExecuteNonQuery(); //Item = cm.Parameters["cCtaCteSerie"].Value.ToString() + '-' + cm.Parameters["cCtaCteNumero"].Value.ToString(); Item = cm.Parameters["@dEffDate"].Value.ToString(); } } } catch (Exception) { throw; } return(Item); }
//-------------------------- // Delete AdmSolDiagnostico //-------------------------- public bool Del_AdmSolDiagnostico(BE_ReqSolAtencion Request) { bool exito = false; try { clsConection Obj = new clsConection(); string Cadena = Obj.GetConexionString("Naylamp"); using (SqlConnection cn = new SqlConnection(Cadena)) { cn.Open(); using (SqlCommand cm = new SqlCommand()) { cm.CommandText = "[usp_Del_AdmSolDiagnostico]"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("cPerJuridica", Request.cPerJuridica); cm.Parameters.AddWithValue("nIntCodigo", Request.nIntCodigo); cm.Parameters.AddWithValue("nSolAdmNumero", Request.nSolAdmNumero); cm.Parameters.AddWithValue("cDiagCodigo", Request.cDiagCodigo); cm.Connection = cn; if (cm.ExecuteNonQuery() > 0) { exito = true; } else { throw new ApplicationException("se ha producido un error procedimiento almacenado: [usp_Del_AdmSolDiagnostico]; Consulte al administrador del sistema"); } } } } catch (Exception) { throw; } return(exito); }
//------------------------------------ //Obtiene Periodo (nPrdCodigo) Actual //------------------------------------ public int Get_Periodo_by_cPerJurCodigo(BE_ReqSistema Request) { int nPrdCodigo = 0; try { clsConection Obj = new clsConection(); string Cadena = Obj.GetConexionString("Naylamp"); using (SqlConnection cn = new SqlConnection(Cadena)) { cn.Open(); using (SqlCommand cm = new SqlCommand()) { cm.CommandText = "[usp_Get_Periodo_by_cPerJurCodigo]"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("cPerJurCodigo", Request.cPerJurRepCodigo); cm.Connection = cn; SqlParameter pCod = new SqlParameter(); pCod.ParameterName = "nPrdCodigo"; pCod.DbType = DbType.Int32; pCod.Direction = ParameterDirection.Output; cm.Parameters.Add(pCod); cm.ExecuteNonQuery(); nPrdCodigo = Convert.ToInt32(cm.Parameters["nPrdCodigo"].Value); if (nPrdCodigo == 0) { throw new ApplicationException("Periodo actual no existe, verique el módulo de Contabilidad (Periodo).: [usp_Get_Periodo_by_cPerJurCodigo]; Consulte al administrador del sistema"); } } } } catch (Exception) { throw; } return(nPrdCodigo); }
//---------------------------------------------- // DELETE PerDetallePorcentajeDscto por Muestra //---------------------------------------------- public bool Del_PerDetallePorcentajeDscto_by_cPerCodigo_cPerParCodigo_nIntCodigo_nCtaCteSerCodigo(BE_ReqPerPorcentajeDscto Objeto) { bool exito = false; try { clsConection Obj = new clsConection(); string Cadena = Obj.GetConexionString("Naylamp"); using (SqlConnection cn = new SqlConnection(Cadena)) { cn.Open(); using (SqlCommand cm = new SqlCommand()) { cm.CommandText = "[usp_Del_PerDetallePorcentajeDscto_by_cPerCodigo_cPerParCodigo_nIntCodigo_nCtaCteSerCodigo]"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("cPerCodigo", Objeto.cPerCodigo); cm.Parameters.AddWithValue("cPerParCodigo", Objeto.cPerParCodigo); cm.Parameters.AddWithValue("nCtaCteSerCodigo", Objeto.nCtaCteSerCodigo); cm.Parameters.AddWithValue("nIntCodigo", Objeto.nIntCodigo); cm.Connection = cn; if (cm.ExecuteNonQuery() > 0) { exito = true; } else { throw new ApplicationException("se ha producido un error procedimiento almacenado: [usp_Del_PerDetallePorcentajeDscto_by_cPerCodigo_cPerParCodigo_nIntCodigo_nCtaCteSerCodigo]; Consulte al administrador del sistema"); } } } } catch (Exception) { throw; } return(exito); }
public BE_Res_Interface getInterface(BE_Req_Interface Request) { BE_Res_Interface Item = new BE_Res_Interface(); try { clsConection Obj = new clsConection(); string Cadena = Obj.GetConexionString("Naylamp"); using (SqlConnection cn = new SqlConnection(Cadena)) { cn.Open(); using (SqlCommand cm = new SqlCommand()) { cm.CommandText = "sp_get_Interface"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("nIntClase", Request.nIntClase); cm.Parameters.AddWithValue("nIntCodigo", Request.nIntCodigo); cm.Connection = cn; using (SqlDataReader dr = cm.ExecuteReader()) { while (dr.Read()) { Item.nIntClase = dr.GetInt32(dr.GetOrdinal("nIntClase")); Item.nIntCodigo = dr.GetInt32(dr.GetOrdinal("nIntCodigo")); Item.nIntTipo = dr.GetInt32(dr.GetOrdinal("nIntTipo")); Item.cIntDescripcion = dr.GetString(dr.GetOrdinal("cIntDescripcion")); Item.cIntJerarquia = dr.GetString(dr.GetOrdinal("cIntJerarquia")); Item.cIntNombre = dr.GetString(dr.GetOrdinal("cIntNombre")); } } } } } catch (Exception) { throw; } return(Item); }
//---------------------------------------------------------------------------------------------- // Update Proforma [nPerIdeTipo, cPerIdeNumero] si hay correccion de documento en la validación //--------------------------------------------------------------------------------------------- public bool Android_Update_Proforma_by_cPerIdeNumero(Proforma Objeto) { bool exito = false; try { clsConection Obj = new clsConection(); string Cadena = Obj.GetConexionString("Naylamp"); using (SqlConnection cn = new SqlConnection(Cadena)) { cn.Open(); using (SqlCommand cm = new SqlCommand()) { cm.CommandText = "[Android].[usp_Update_Proforma_by_cPerIdeNumero]"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("nPerIdeTipo", Objeto.nPerIdeTipo); cm.Parameters.AddWithValue("cPerIdeNumero", Objeto.cPerIdeNumero); cm.Parameters.AddWithValue("nPerIdeTipo_New", Objeto.nPerIdeTipo_New); cm.Parameters.AddWithValue("cPerIdeNumero_New", Objeto.cPerIdeNumero_New); cm.Connection = cn; if (cm.ExecuteNonQuery() > 0) { exito = true; } else { throw new ApplicationException("se ha producido un error procedimiento almacenado: [Android].[usp_Update_Proforma_by_cPerIdeNumero]; Consulte al administrador del sistema"); } } } } catch (Exception) { throw; } return(exito); }
//----------------------------------------------------- // Update Adm Solicitud for_cPerJuridica_nSolAdmNumero //----------------------------------------------------- public bool Upd_AdmSolAtencion_for_cPerJuridica_nSolAdmNumero(BE_ReqSolAtencion Request) { bool exito; try { clsConection Obj = new clsConection(); string Cadena = Obj.GetConexionString("Naylamp"); using (SqlConnection cn = new SqlConnection(Cadena)) { cn.Open(); using (SqlCommand cm = new SqlCommand()) { cm.CommandText = "[usp_Upd_AdmSolAtencion_for_cPerJuridica_nSolAdmNumero]"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("cPerJuridica", Request.cPerJuridica); cm.Parameters.AddWithValue("nSolAdmNumero", Request.nSolAdmNumero); cm.Parameters.AddWithValue("cCtaCteRecibo", Request.cCtaCteRecibo); cm.Parameters.AddWithValue("nAdmSolEstado", Request.nAdmSolEstado); cm.Parameters.AddWithValue("cPerUseCodUpd", Request.cPerCodigoAut); cm.Connection = cn; if (cm.ExecuteNonQuery() > 0) { exito = true; } else { exito = false; } } } } catch (Exception) { throw; } return(exito); }
public BE_Res_Login ValidaterUser(BE_Req_Login Request) { BE_Res_Login Item = new BE_Res_Login(); try { clsConection Obj = new clsConection(); string Cadena = Obj.GetConexionString("Naylamp"); using (SqlConnection cn = new SqlConnection(Cadena)) { cn.Open(); using (SqlCommand cm = new SqlCommand()) { cm.CommandText = "sp_User_Validate"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("cPerUsuCodigo", Request.cPerUsuCodigo); cm.Parameters.AddWithValue("cPerUsuClave", Request.cPerUsuClave); cm.Connection = cn; using (SqlDataReader dr = cm.ExecuteReader()) { while (dr.Read()) { Item.cPerCodigo = dr.GetString(dr.GetOrdinal("cPerCodigo")).Trim(); Item.cPerApellido = dr.GetString(dr.GetOrdinal("cPerApellido")); Item.cPerNombre = dr.GetString(dr.GetOrdinal("cPerNombre")); Item.cPerAlias = dr.GetString(dr.GetOrdinal("Alias")); Item.cPerKey = dr.GetString(dr.GetOrdinal("cPerKey")); } } } } } catch (Exception) { throw; } return(Item); }
//------------------------ // Update CuentaCorriente //------------------------ public bool Upd_CuentaCorriente(BE_ReqCuentaCorriente Request) { bool exito = false; try { clsConection Obj = new clsConection(); string Cadena = Obj.GetConexionString("Naylamp"); using (SqlConnection cn = new SqlConnection(Cadena)) { cn.Open(); using (SqlCommand cm = new SqlCommand()) { cm.CommandText = "[usp_Upd_CuentaCorriente_set_dCtaCteFecPago_nCtaCteEstado]"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("cCtaCteRecibo", Request.cCtaCteRecibo); cm.Parameters.AddWithValue("dCtaCteFecPago", Request.dCtaCteFecPago); cm.Parameters.AddWithValue("nTipoOperacion", Request.nTipoOperacion); cm.Connection = cn; if (cm.ExecuteNonQuery() > 0) { exito = true; } else { throw new ApplicationException("Se ha producido error en procedimiento almacenado: [usp_Upd_CuentaCorriente_set_dCtaCteFecPago_nCtaCteEstado]; Consulte al administrador del sistema"); } } } } catch (Exception) { throw; } return(exito); }
public DataTable GetMenu_By_Persona_Clase(BE_ReqMenu Request) { long Resultado = 0; DataTable Item = new DataTable(); try { clsConection Obj = new clsConection(); string Cadena = Obj.GetConexionString("Naylamp"); using (SqlConnection cn = new SqlConnection(Cadena)) { cn.Open(); using (SqlCommand cm = new SqlCommand()) { cm.CommandText = "usp_Web_Get_Permisos"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("cPerCodigo", Request.cPerCodigo); cm.Parameters.AddWithValue("cPerJurCodigo", Request.cPerJurCodigo); cm.Parameters.AddWithValue("nIntClase", Request.nIntClase); cm.Parameters.AddWithValue("nSisGruTipo", Request.nSisGruTipo); cm.Parameters.AddWithValue("nSisGruCodigo", Request.nSisGruCodigo); cm.Connection = cn; using (SqlDataReader dr = cm.ExecuteReader()) { Item.Load(dr); } } } } catch (Exception) { throw; } return(Item); }
public int Get_CtaCteListaServicio(CtaCteListaServicio Objeto) { int nCtaCteSerCodigo = 0; try { clsConection Obj = new clsConection(); string Cadena = Obj.GetConexionString("Naylamp"); using (SqlConnection cn = new SqlConnection(Cadena)) { cn.Open(); using (SqlCommand cm = new SqlCommand()) { cm.CommandText = "[usp_Get_CtaCteListaServicio]"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("@cPerJurCodigo", Objeto.cPerJurCodigo); cm.Parameters.AddWithValue("@cCtaCteSerJerarquia", Objeto.cCtaCteSerJerarquia); cm.Connection = cn; SqlParameter sqlParameter = new SqlParameter(); sqlParameter.ParameterName = "@nCtaCteSerCodigo"; sqlParameter.DbType = DbType.Int32; sqlParameter.Direction = ParameterDirection.Output; cm.Parameters.Add(sqlParameter); cm.ExecuteNonQuery(); nCtaCteSerCodigo = Convert.ToInt32(cm.Parameters["@nCtaCteSerCodigo"].Value); } } return(nCtaCteSerCodigo); } catch (Exception) { throw; } }
//------------------------------------------------------ //Get_CtaCteListServicio Detalle preparacion paraciente //----------------------------------------------------- public string Get_CtaCteListaServicio_by_cPerJurCodigo_nCtaCteSerCodigo(BE_ReqCtaCteSerImpDefault Request) { string cPreparacionPaciente = ""; try { clsConection Obj = new clsConection(); string Cadena = Obj.GetConexionString("Naylamp"); using (SqlConnection cn = new SqlConnection(Cadena)) { cn.Open(); using (SqlCommand cm = new SqlCommand()) { cm.CommandText = "[usp_Get_CtaCteListaServicio_by_cPerJurCodigo_nCtaCteSerCodigo]"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("cPerJurCodigo", Request.cPerJurCodigo); cm.Parameters.AddWithValue("nCtaCteSerCodigo", Request.nCtaCteSerCodigo); cm.Connection = cn; SqlParameter pImp = new SqlParameter(); pImp.ParameterName = "StrPreparacion"; pImp.DbType = DbType.String; pImp.Size = 200; pImp.Direction = ParameterDirection.Output; cm.Parameters.Add(pImp); cm.ExecuteNonQuery(); cPreparacionPaciente = Convert.ToString(cm.Parameters["StrPreparacion"].Value); } } } catch (Exception) { throw; } return(cPreparacionPaciente); }
public DataTable ListarConstantes(BE_Req_Constante Request) { DataTable Item = new DataTable(); try { clsConection Obj = new clsConection(); string Cadena = Obj.GetConexionString("Naylamp"); using (SqlConnection cn = new SqlConnection(Cadena)) { cn.Open(); using (SqlCommand cm = new SqlCommand()) { cm.CommandText = "sp_ListarConstante"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("nConCodigo", Request.nConCodigo); cm.Parameters.AddWithValue("nConValor", Request.nConValor); cm.Parameters.AddWithValue("ConLeft", Request.ConLeft); cm.Parameters.AddWithValue("ConValLeft", Request.ConValLeft); cm.Parameters.AddWithValue("ConRight", Request.ConRight); cm.Parameters.AddWithValue("ConValRight", Request.ConValRight); cm.Parameters.AddWithValue("NotIn", Request.NotIn); cm.Parameters.AddWithValue("In", Request.cConValor); cm.Connection = cn; using (SqlDataReader dr = cm.ExecuteReader()) { Item.Load(dr); } } } } catch (Exception) { throw; } return(Item); }
//------------------------------------- //Get_CtaCteServicio_nCtaCteSerImpDef - //------------------------------------- public double Get_CtaCteServicio_nCtaCteSerImpDef(BE_ReqCtaCteSerImpDefault Request) { double ImpDefault = 0; try { clsConection Obj = new clsConection(); string Cadena = Obj.GetConexionString("Naylamp"); using (SqlConnection cn = new SqlConnection(Cadena)) { cn.Open(); using (SqlCommand cm = new SqlCommand()) { cm.CommandText = "[usp_Get_CtaCteServicio_nCtaCteSerImpDef]"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("cPerJurCodigo", Request.cPerJurCodigo); cm.Parameters.AddWithValue("nCtaCteSerCodigo", Request.nCtaCteSerCodigo); cm.Connection = cn; SqlParameter pImp = new SqlParameter(); pImp.ParameterName = "nCtaCteSerImpDef"; pImp.DbType = DbType.Double; pImp.Direction = ParameterDirection.Output; cm.Parameters.Add(pImp); cm.ExecuteNonQuery(); ImpDefault = Convert.ToDouble(cm.Parameters["nCtaCteSerImpDef"].Value); } } } catch (Exception) { throw; } return(ImpDefault); }
public Boolean setDocTratamiento(BE_Req_Documento Request) { Boolean Item = new Boolean(); try { clsConection Obj = new clsConection(); string Cadena = Obj.GetConexionString("Naylamp"); using (SqlConnection cn = new SqlConnection(Cadena)) { cn.Open(); using (SqlCommand cm = new SqlCommand()) { cm.CommandText = "sp_set_DocTratamiento"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("cDocCodigo", Request.cDocCodigo); cm.Parameters.AddWithValue("cPerCodigo", Request.cPerCodigo); cm.Parameters.AddWithValue("nEleCodigo", Request.nEleCodigo); cm.Parameters.AddWithValue("nCarCodigo", Request.nCarCodigo); cm.Parameters.AddWithValue("cCarObs", Request.cCarObs); cm.Parameters.AddWithValue("nPercent", Request.nPercent); cm.Parameters.AddWithValue("dDocTraFec", Request.dDocTraFec); cm.Connection = cn; using (SqlDataReader dr = cm.ExecuteReader()) { Item = true; } } } } catch (Exception) { throw; } return(Item); }
//Obtener correlativo cIntJerarquia para la Tabla [Interface] public string Get_NewIdcIntJerarquia(BE_ReqInterface Request) //BE_ReqSolCorrelativo Request) { string nNewId = ""; try { clsConection Obj = new clsConection(); string Cadena = Obj.GetConexionString("Naylamp"); using (SqlConnection cn = new SqlConnection(Cadena)) { cn.Open(); using (SqlCommand cm = new SqlCommand()) { cm.CommandText = "usp_Get_NewIdcIntJerarquia"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("nIntClase", Request.nIntClase); cm.Parameters.AddWithValue("nIntTipo", Request.nIntTipo); cm.Connection = cn; SqlParameter pCod = new SqlParameter(); pCod.ParameterName = "nNewId"; pCod.DbType = DbType.String; pCod.Size = 25; pCod.Direction = ParameterDirection.Output; cm.Parameters.Add(pCod); cm.ExecuteNonQuery(); nNewId = cm.Parameters["nNewId"].Value.ToString(); } } } catch (Exception) { throw; } return(nNewId); }
//------------------------------------------------------------------ // Select: Interface por (nIntClase and nIntCodigo) - Configuracion //------------------------------------------------------------------ public string Get_Interface_CFG(BE_Req_Interface Request) { string Item = ""; try { clsConection Obj = new clsConection(); string Cadena = Obj.GetConexionString("Naylamp"); using (SqlConnection cn = new SqlConnection(Cadena)) { cn.Open(); using (SqlCommand cm = new SqlCommand()) { cm.CommandText = "[usp_Get_Interface_CFG]"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("nIntClase", Request.nIntClase); cm.Parameters.AddWithValue("nIntCodigo", Request.nIntCodigo); cm.Connection = cn; SqlParameter pCod = new SqlParameter(); pCod.ParameterName = "cIntNombre"; pCod.DbType = DbType.String; pCod.Size = 200; pCod.Direction = ParameterDirection.Output; cm.Parameters.Add(pCod); cm.ExecuteNonQuery(); Item = cm.Parameters["cIntNombre"].Value.ToString(); } } } catch (Exception) { throw; } return(Item); }
//------------------------------------------------------------------------ //VERIFICANDO SI EXISTE DATA - VALIDANDO SI EXISTE REGISTRO FOR CONDICION //------------------------------------------------------------------------ public Int32 Get_ValidarCondicion(BE_ReqValidaCondicion Request) { Int32 nRegCant = 0; try { clsConection Obj = new clsConection(); string Cadena = Obj.GetConexionString("Naylamp"); using (SqlConnection cn = new SqlConnection(Cadena)) { cn.Open(); using (SqlCommand cm = new SqlCommand()) { cm.CommandText = "[usp_Get_ValidarCondicion]"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("Table", Request.Table); cm.Parameters.AddWithValue("campo", Request.campo); cm.Parameters.AddWithValue("condicion", Request.condicion); cm.Connection = cn; SqlParameter pCount = new SqlParameter(); pCount.ParameterName = "nResultadof"; pCount.DbType = DbType.Int32; pCount.Direction = ParameterDirection.Output; cm.Parameters.Add(pCount); cm.ExecuteNonQuery(); nRegCant = Convert.ToInt32(cm.Parameters["nResultadof"].Value); } } } catch (Exception) { throw; } return(nRegCant); }
//------------------------------------------------------------------- //Verifica si existe Caja y Host ya registrados "SysConfigParametros" //------------------------------------------------------------------- public int Get_SysConfigParametros(BE_ReqSysConfig Request) { int nRows = 0; try { clsConection Obj = new clsConection(); string Cadena = Obj.GetConexionString("Naylamp"); using (SqlConnection cn = new SqlConnection(Cadena)) { cn.Open(); using (SqlCommand cm = new SqlCommand()) { cm.CommandText = "[usp_Get_SysConfigParametros]"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("NameHosts", Request.NameHosts); cm.Parameters.AddWithValue("AdressIP", Request.AdressIP); cm.Parameters.AddWithValue("NroCaja", Request.NroCaja); cm.Connection = cn; SqlParameter pCod = new SqlParameter(); pCod.ParameterName = "nExiste"; pCod.DbType = DbType.Int32; pCod.Direction = ParameterDirection.Output; cm.Parameters.Add(pCod); cm.ExecuteNonQuery(); nRows = Convert.ToInt32(cm.Parameters["nExiste"].Value); } } } catch (Exception) { throw; } return(nRows); }
//------------------------------------------------ // SysConTasImpuesto: tabla impuestos por Country //------------------------------------------------ public BE_ResGenerico Set_SysConTasImpuesto(BE_ReqSysConTasImpuesto Request) { BE_ResGenerico Item = new BE_ResGenerico(); long Resultado = 0; try { clsConection Obj = new clsConection(); string Cadena = Obj.GetConexionString("Naylamp"); using (SqlConnection cn = new SqlConnection(Cadena)) { cn.Open(); using (SqlCommand cm = new SqlCommand()) { cm.CommandText = "usp_Ins_SysConTasImpuesto"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("nSysTasContry", Request.nSysTasContry); cm.Parameters.AddWithValue("nSysTasCodigo", Request.nSysTasCodigo); cm.Parameters.AddWithValue("nSysTasFecha", Request.nSysTasFecha); cm.Parameters.AddWithValue("cSysTasDescripcion", Request.cSysTasDescripcion); cm.Parameters.AddWithValue("cSysTasNombre", Request.cSysTasNombre); cm.Parameters.AddWithValue("fSysTasValor", Request.fSysTasValor); cm.Connection = cn; Resultado = cm.ExecuteNonQuery(); Item.Resultado = Resultado; } } } catch (Exception) { throw; } return(Item); }
//---------------- // PerImagen //---------------- public BE_ResGenerico InsPerImagen(BE_ReqPerPhoto Request) { BE_ResGenerico Item = new BE_ResGenerico(); long Resultado = 0; try { clsConection Obj = new clsConection(); string Cadena = Obj.GetConexionString("Naylamp"); using (SqlConnection cn = new SqlConnection(Cadena)) { cn.Open(); using (SqlCommand cm = new SqlCommand()) { cm.CommandText = "[usp_Ins_PerImagen]"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("cPerCodigo", Request.cPerCodigo); cm.Parameters.AddWithValue("nPerTipImagen", Request.nPerTipImagen); SqlParameter pImg = new SqlParameter("iPerImaFoto", SqlDbType.Image); pImg.Value = Request.iPerImaFoto; cm.Parameters.Add(pImg); cm.Connection = cn; Resultado = cm.ExecuteNonQuery(); Item.Resultado = Resultado; } } } catch (Exception) { throw; } return(Item); }
//------------------------------------------------------------------------------ //[usp_Get_ExistePerIdentifica] para Verificar si existe Nro. docu PerIdentifica //------------------------------------------------------------------------------ public int Get_ExistePerIdentifica(BE_ReqPerIdentifica Request) { int nResultado = 0; try { clsConection Obj = new clsConection(); string Cadena = Obj.GetConexionString("Naylamp"); using (SqlConnection cn = new SqlConnection(Cadena)) { cn.Open(); using (SqlCommand cm = new SqlCommand()) { cm.CommandText = "[usp_Get_ExistePerIdentifica]"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("nPerIdeTipo", Request.nPerIdeTipo); cm.Parameters.AddWithValue("cPerIdeNumero", Request.cPerIdeNumero); cm.Connection = cn; SqlParameter pCod = new SqlParameter(); pCod.ParameterName = "nRows"; pCod.DbType = DbType.Int32; //pCod.Size = 25; pCod.Direction = ParameterDirection.Output; cm.Parameters.Add(pCod); cm.ExecuteNonQuery(); nResultado = Convert.ToInt32(cm.Parameters["nRows"].Value); } } } catch (Exception) { throw; } return(nResultado); }
//-------------------------- // CtaCteNumeracion //-------------------------- //Insert public BE_ResGenerico InsCtaCteNumeracion(BE_ReqCtaCteNumeracion Request) { BE_ResGenerico Item = new BE_ResGenerico(); long Resultado = 0; try { clsConection Obj = new clsConection(); string Cadena = Obj.GetConexionString("Naylamp"); using (SqlConnection cn = new SqlConnection(Cadena)) { cn.Open(); using (SqlCommand cm = new SqlCommand()) { cm.CommandText = "usp_Ins_CtaCteNumeracion"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("cPerJurCodigo", Request.cPerJurCodigo); cm.Parameters.AddWithValue("nCajCodigo", Request.nCajCodigo); cm.Parameters.AddWithValue("nComCodigo", Request.nComCodigo); cm.Parameters.AddWithValue("nCtaCteNumero", Request.nCtaCteNumero); cm.Parameters.AddWithValue("cCtaCteSerie", Request.cCtaCteSerie); cm.Parameters.AddWithValue("nCtaCteNumIni", Request.nCtaCteNumIni); cm.Parameters.AddWithValue("nCtaCtaNumFin", Request.nCtaCtaNumFin); cm.Connection = cn; Resultado = cm.ExecuteNonQuery(); Item.Resultado = Resultado; } } } catch (Exception) { throw; } return(Item); }
public BE_Res_Documento getDocumentoBycDocNDoc_nDocTipo(BE_Req_Documento Request) { BE_Res_Documento Item = new BE_Res_Documento(); try { clsConection Obj = new clsConection(); string Cadena = Obj.GetConexionString("Naylamp"); using (SqlConnection cn = new SqlConnection(Cadena)) { cn.Open(); using (SqlCommand cm = new SqlCommand()) { cm.CommandText = "sp_get_DocumentoBycDocNDoc_nDocTipo"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("cDocNDoc", Request.cDocNDoc); cm.Parameters.AddWithValue("nDocTipo", Request.nDocTipo); cm.Connection = cn; using (SqlDataReader dr = cm.ExecuteReader()) { while (dr.Read()) { Item.cDocCodigo = dr.GetString(dr.GetOrdinal("cDocCodigo")); Item.nDocTipoNum = dr.GetInt16(dr.GetOrdinal("nDocTipoNum")); Item.cDocNDoc = dr.GetString(dr.GetOrdinal("cDocNDoc")); } } } } } catch (Exception) { throw; } return(Item); }
public DataTable getDocInformacion(BE_Req_Documento Request) { BE_Res_Documento Item = new BE_Res_Documento(); DataTable Rs = new DataTable(); try { clsConection Obj = new clsConection(); string Cadena = Obj.GetConexionString("Naylamp"); using (SqlConnection cn = new SqlConnection(Cadena)) { cn.Open(); using (SqlCommand cm = new SqlCommand()) { cm.CommandText = "sp_get_DocInformacion"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("cPerCodigo", Request.cPerCodigo); cm.Parameters.AddWithValue("cPerDestCodigo", Request.cPerDestCodigo); cm.Parameters.AddWithValue("cDocCodigo", Request.cDocCodigo); cm.Parameters.AddWithValue("cDocPerTipo", Request.cDocPerTipo); cm.Parameters.AddWithValue("cDocEstado", Request.cDocEstado); cm.Parameters.AddWithValue("cDocConTipo", Request.cDocConTipo); cm.Connection = cn; using (SqlDataReader dr = cm.ExecuteReader()) { Rs.Load(dr); } } } } catch (Exception) { throw; } return(Rs); }