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 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 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 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; }
//---------------------------- // 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; }
//----------------------------------------------- // 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; }
//--------------------------------------------------- //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; }
//----------------------------------------------- // 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 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; }
//---------------------------------------------------------------- // 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; }
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); }
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); }
//-------------------------- // 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; }
public DataTable Get_Datos_Reniec_Local_by_dni(Reniec Objeto) { 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_Datos_Reniec_Local_by_dni]"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("dni", Objeto.dni); 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; }
//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; }
//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("nPrdCodigo", Request.nPrdCodigo); cm.Parameters.AddWithValue("cFlag", Request.cFlag); 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_CuadreCaja_by_cPerJurCodigo_nTurno_fecini_fecfin]"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("cPerJurCodigo", Request.cPerJurCodigo); cm.Parameters.AddWithValue("nTurno", Request.nTurno); cm.Parameters.AddWithValue("fecini", Request.dCtaCteComFecIni); cm.Parameters.AddWithValue("fecfin", Request.dCtaCteComFecFin); 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; }
//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; }
//------------------------------------- //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 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; }
//---------------------------------------- // 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; }
//---------------------------------------------------------------- // 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); }
public DataTable ObtenerAreaByPersonaInstitucion(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_ListaArea_ByPersona_Institucion"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("cPerCodigo", Request.cPerCodigo); cm.Parameters.AddWithValue("cUniCodigo", Request.cUniCodigo); cm.Connection = cn; using (SqlDataReader dr = cm.ExecuteReader()) { lista.Load(dr); } } } } catch (Exception) { throw; } return(lista); }
//--------------------------------- // Get CtaCteListaServicio - Popup //-------------------------------- public DataTable Get_CtaCteListaServicio_by_cPerJurCodigo_and_cCtaCteSerJerarquia(BE_ReqCtaCteServicio Objeto) { 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_CtaCteListaServicio_by_cPerJurCodigo_and_cCtaCteSerJerarquia]"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("cPerJurCodigo", Objeto.cPerJurCodigo); cm.Parameters.AddWithValue("cCtaCteSerJerarquia", Objeto.cCtaCteSerJerarquia); cm.Connection = cn; using (SqlDataReader dr = cm.ExecuteReader()) dt.Load(dr); } } } catch (Exception) { throw; } return(dt); }
//------------------------------ // 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; }
//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); }
//------------------------------------------------------- //Get CtaCteDetallle //------------------------------------------------------- public DataTable Get_CtaCteDetalle(BE_ReqCtaCteDetalle ctaCteDetalle) { 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_CtaCteDetalle]"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("cCtaCteRecibo", ctaCteDetalle.cCtaCteRecibo); cm.Connection = cn; using (SqlDataReader dr = cm.ExecuteReader()) dt.Load(dr); } } } catch (Exception) { throw; } return(dt); }
//----------------------- //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; }
//----------------------------- // 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); }
//--------------------------------- // Buscar Persona para ser atendida //--------------------------------- public DataTable Android_Get_Persona_by_nPerIdeTipo_cPerIdeNumero(Proforma Objeto) { 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 = "[Android].[usp_Android_Get_Persona_by_nPerIdeTipo_cPerIdeNumero]"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("nPerIdeTipo", Objeto.nPerIdeTipo); cm.Parameters.AddWithValue("cPerIdeNumero", Objeto.cPerIdeNumero); cm.Connection = cn; using (SqlDataReader dr = cm.ExecuteReader()) dt.Load(dr); } } } catch (Exception) { throw; } return(dt); }
//[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; }
//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; }
//------------------------- //OBTIENE AƱo - Periodo //------------------------- public DataTable Get_Periodo_By_nPrdCodigo(BE_ReqPeriodo 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_Periodo_By_nPrdCodigo]"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("nPrdCodigo", Request.nObjCodigo); 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; }
public string Get_FechaHoraServidor(BE_ReqFechaServidor Request, long?nSegundos = 0) { 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 = String.Format("SET LANGUAGE 'EspaƱol' SELECT CONVERT(CHAR(10),DATEADD(ss, {0}, GETDATE()),103) + ' '+ CONVERT(CHAR(8),DATEADD(ss, {0}, GETDATE()),108) FechaHoraServerSQL ", nSegundos); 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("FechaHoraServerSQL")).Trim(); } } } } } catch (Exception) { throw; } return(Item); }
//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; }
//---------------------------- // SELECT Get_ImpuestoServicio //---------------------------- public DataTable Get_ImpuestoServicio(BE_ReqCtaCteSerImpuesto 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_ImpuestoServicio]"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("cPerJurCodigo", Request.cPerJurCodigo); cm.Parameters.AddWithValue("nSysTasContry", Request.nSysTasContry); cm.Parameters.AddWithValue("nCtaCteSerCodigo", Request.nCtaCteSerCodigo); cm.Connection = cn; using (SqlDataReader dr = cm.ExecuteReader()) dt.Load(dr); } } } catch (Exception) { throw; } return(dt); }
//--------------------------------------------------- //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 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); }
public DateTime Get_FechaHoraServidor_MasMenos(BE_ReqFechaServidor Request, long?nSegundos = 0) { DateTime Item = DateTime.Today; 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 = String.Format("SET LANGUAGE 'EspaƱol' SELECT DATEADD(ss, {0}, GETDATE()) as FechaHoraServerSQL ", nSegundos); cm.CommandType = CommandType.Text; //cm.Parameters.AddWithValue("cPerJurCodigo", Request.cPerCodigo); cm.Connection = cn; using (SqlDataReader dr = cm.ExecuteReader()) { while (dr.Read()) { Item = dr.GetDateTime(0); } } } } } catch (Exception) { throw; } return(Item); }
//--------------------------------------------------------- //Obtengo List Empresa del Sistema (90000) -Peridentifica- //--------------------------------------------------------- public DataTable Get_SysEmpresa(BE_ReqFechaServidor 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_PerSysJuridica]"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("cPerCodigo", Request.dFechaServer); cm.Connection = cn; using (SqlDataReader dr = cm.ExecuteReader()) dt.Load(dr); } } } catch (Exception) { throw; } return(dt); }
//------------------------------- // Obtener Resultado de Encuenta //------------------------------- public DataTable Get_EncSatisfaccion(string cPerJurCodigo, string dFecIni, string dFecFin, string cFlag) { 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 = "[Android].[usp_Get_EncSatisfaccion]"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("cPerJurCodigo", cPerJurCodigo); cm.Parameters.AddWithValue("dFecIni", dFecIni); cm.Parameters.AddWithValue("dFecFin", dFecFin); cm.Parameters.AddWithValue("cFlag", cFlag); 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; }
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; }
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; }
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; }
//------------------------------------ //OBTIENE Periodo Contable por defecto //------------------------------------ //public DataTable Get_PeriodoContDefault(BE_ReqPeriodo 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_PeriodoContDefault]"; // cm.CommandType = CommandType.StoredProcedure; // cm.Parameters.AddWithValue("cPerJurCodigo", Request.cPerJurCodigo); // cm.Parameters.AddWithValue("cAnno", Request.cAnno); // cm.Connection = cn; // using (SqlDataReader dr = cm.ExecuteReader()) // dt.Load(dr); // } // } // } // catch (Exception) // { // throw; // } // return dt; //} //-------------------------------------------------- // Parametros de configuracion "SysConfigParametros" //-------------------------------------------------- public BE_ResGenerico Set_SysConfigParametros(BE_ReqSysConfig 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_Set_SysConfigParametros"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("NameHosts", Request.NameHosts); cm.Parameters.AddWithValue("AdressIP ", Request.AdressIP); cm.Parameters.AddWithValue("PathRpt ", Request.PathRpt); cm.Parameters.AddWithValue("NroCaja ", Request.NroCaja); cm.Parameters.AddWithValue("nTipoDocuDefault ", Request.nTipoDocuDefault); cm.Connection = cn; Resultado = cm.ExecuteNonQuery(); Item.Resultado = Resultado; } } } catch (Exception) { throw; } return(Item); }
// Obtengo Ubigeo public string Get_Ubigeo(BE_ReqUbigeo 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 = "SELECT cDptDescripcion + '; ' + cPrvDescripcion + '; ' + cDisDescripcion as DPDUbigeo FROM Ubigeo_2007 WITH(NOLOCK) WHERE Codigo = '" + Request.Codigo + "'"; cm.CommandType = CommandType.Text; //cm.Parameters.AddWithValue("Codigo", Request.Codigo); cm.Connection = cn; using (SqlDataReader dr = cm.ExecuteReader()) { while (dr.Read()) { Item = dr.GetString(dr.GetOrdinal("DPDUbigeo")).Trim(); } } } } } catch (Exception) { throw; } return(Item); }
//---------------------------------------------------------- //Implement: f.2015-12-23 //Obtiene valor "ConfiguraciĆ³n General" del Sistema <CFGGEN> //---------------------------------------------------------- public DataTable Get_General_Get_Configuracion_By_PerJur_Modulo_Jerarquia(BE_ReqSistema 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_General_Get_Configuracion_By_PerJur_Modulo_Jerarquia]"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("cPerCodigo", Request.cPerCodigo); cm.Parameters.AddWithValue("nSisGruCodigo", Request.nSisGruCodigo); cm.Parameters.AddWithValue("cIntJerarquia", Request.cIntJerarquia); cm.Connection = cn; using (SqlDataReader dr = cm.ExecuteReader()) dt.Load(dr); } } } catch (Exception) { throw; } return(dt); }
// Establecer como Empresa del Sistema public BE_ResGenerico Set_EmpresaSys(BE_ReqSistema 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_SetEmpresaSys"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("cPerCodigo", Request.cPerCodigo); cm.Parameters.AddWithValue("cPerJurRepCodigo", Request.cPerJurRepCodigo); cm.Parameters.AddWithValue("nPerJurTipInversion", Request.nPerJurTipInversion); cm.Parameters.AddWithValue("nPerJurSecEconomico", Request.nPerJurSecEconomico); cm.Connection = cn; Resultado = cm.ExecuteNonQuery(); Item.Resultado = Resultado; } } } catch (Exception) { throw; } return(Item); }
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); }
//--------------------------------------------------- //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 UpdChangePassword(BE_ReqSearhUsuario 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_Upd_ChangePasswordPerUsuario"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("cPerCodigo", Request.PerCodigo); cm.Parameters.AddWithValue("cPerUsuClaveNew", Request.cPerUsuClave); cm.Connection = cn; Resultado = cm.ExecuteNonQuery(); Item.Resultado = Resultado; } } } catch (Exception) { throw; } return(Item); }
//---------------------- // Insert: TipodeCambio //--------------------- public BE_ResGenerico Ins_TipodeCambio(BE_ReqInsTipodeCambio 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_TipodeCambio"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("dTasFecha", Request.dTasFecha); cm.Parameters.AddWithValue("nMonCodigo", Request.nMonCodigo); cm.Parameters.AddWithValue("nTasTipo", Request.nTasTipo); cm.Parameters.AddWithValue("fTasValor", Request.fTasValor); cm.Connection = cn; Resultado = cm.ExecuteNonQuery(); Item.Resultado = Resultado; } } } catch (Exception) { throw; } return(Item); }
//----------------------------------- //Obtener Servicio por Tipo de Cuenta //----------------------------------- public DataTable Get_ServicioporTipoCta(BE_ReqServicioporTipoCta 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_ServicioporTipoCta"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("nCtaCteTipoCta", Request.nCtaCteTipoCta); cm.Connection = cn; using (SqlDataReader dr = cm.ExecuteReader()) dt.Load(dr); } } } catch (Exception) { throw; } return(dt); }
//------------------------------------------------ // Establecer por Defaul - Periodo Constable //------------------------------------------------ public BE_ResGenerico Set_PeriodoDefault(BE_ReqPeriodoDefault 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_Set_PeriodoDefault]"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("nPrdCodigo", Request.nPrdCodigo); cm.Parameters.AddWithValue("cAnno", Request.cAnno); cm.Connection = cn; Resultado = cm.ExecuteNonQuery(); Item.Resultado = Resultado; } } } catch (Exception) { throw; } return(Item); }
//----------------------------------------------- // 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; }
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; }