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