// Insert Adm Solicitud Atencion public bool Ins_AdmSolAtencion(BE_ReqAdmSolAtencion 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_Ins_AdmSolAtencion]"; 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("cPerCodigo", Request.cPerCodigo); cm.Parameters.AddWithValue("dFecExamen", Request.dFecExamen); cm.Parameters.AddWithValue("nAdmSolEstado", Request.nAdmSolEstado); cm.Parameters.AddWithValue("nImpTotal", Request.nImpTotal); cm.Parameters.AddWithValue("cPerUseCodigo", Request.cPerUseCodigo); cm.Parameters.AddWithValue("nCtaCteSerCodigo", Request.nCtaCteSerCodigo); cm.Parameters.AddWithValue("nCtaCteCantidad", Request.nCtaCteCantidad); cm.Parameters.AddWithValue("nCtaCteCosto", Request.nCtaCteCosto); cm.Connection = cn; if (cm.ExecuteNonQuery() > 0) { exito = true; } else exito = false; } } } catch (Exception) { throw; } return exito; }
//Obtiene correlativo Admision Solicitud Atencion public string Get_Correlativo_Sol(BE_ReqAdmSolAtencion 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_NewId_AdmSolAtencion]"; cm.CommandType = CommandType.StoredProcedure; //cm.Parameters.AddWithValue("cPerJurCodigo", Request.cPerCodigo); cm.Connection = cn; using (SqlDataReader dr = cm.ExecuteReader()) { while (dr.Read()) { Item = dr.GetString(dr.GetOrdinal("NewCodigo")).Trim(); } } } } } catch (Exception) { throw; } return Item; }