public Boolean setDocUniOrg(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_DocUniOrg"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("cDocCodigo", Request.cDocCodigo); cm.Parameters.AddWithValue("nUniOrgCodigo", Request.nUniOrgCodigo); cm.Parameters.AddWithValue("nDocUniOrgTipo", Request.nDocUniOrgTipo); cm.Parameters.AddWithValue("nDocUniOrgEstado", Request.nDocUniOrgEstado); cm.Connection = cn; using (SqlDataReader dr = cm.ExecuteReader()) { Item = true; } } } } 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 Boolean updEstadoDocumento(BE_Req_Documento Request) { Boolean Item = new Boolean(); string codigo = ""; 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_upd_EstadoDocumento"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("cDocCodigo", Request.cDocCodigo); cm.Parameters.AddWithValue("nDocEstado", Request.nDocEstado); cm.Parameters.AddWithValue("cDocObserv", Request.cDocObserv); cm.Parameters.AddWithValue("cPerModCodigo", Request.cPerCodigo); cm.Parameters.AddWithValue("nDocPerEdiTipo", Request.nDocPerTipo); cm.Connection = cn; using (SqlDataReader dr = cm.ExecuteReader()) { while (dr.Read()) { codigo = dr.GetString(dr.GetOrdinal("cDocCodigo")).ToString(); } } if (codigo.Equals("")) { Item = false; } else { Item = true; } } } } 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 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); }
public BE_Res_Documento getTipoPersona(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_TipoPersona"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("cPerCodigo", Request.cPerCodigo); cm.Connection = cn; using (SqlDataReader dr = cm.ExecuteReader()) { while (dr.Read()) { Item.cPerCodigo = dr.GetString(dr.GetOrdinal("cPerCodigo")); Item.nAdministrativo = dr.GetInt32(dr.GetOrdinal("Administrativo")); Item.nAlumno = dr.GetInt32(dr.GetOrdinal("Alumno")); } } } } } catch (Exception) { throw; } return(Item); }
public BE_Res_Documento getUltimoDocumentoBycPerCodigo(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_UltimoDocumentoBycPerCodigo"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("cPerCodigo", Request.cPerCodigo); cm.Connection = cn; using (SqlDataReader dr = cm.ExecuteReader()) { while (dr.Read()) { Item.cDocNDoc = dr.GetString(dr.GetOrdinal("cDocNDoc")); Item.dDocFecha = dr.GetDateTime(dr.GetOrdinal("dDocFecha")); Item.cPerApellido = dr.GetString(dr.GetOrdinal("cPerApellido")); } } } } } catch (Exception) { throw; } return(Item); }
public DataTable getDocPendientesConAcuerdo(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_DocPendientesConAcuerdo_BycPerCodigo"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("cPerCodigo", Request.cPerCodigo); cm.Parameters.AddWithValue("FiltroPersona", Request.FiltroPersona); cm.Parameters.AddWithValue("FiltroFecha", Request.FiltroFecha); cm.Parameters.AddWithValue("FecIni", Request.dFechaIni); cm.Parameters.AddWithValue("FecFin", Request.dFechaFin); cm.Connection = cn; using (SqlDataReader dr = cm.ExecuteReader()) { Rs.Load(dr); } } } } catch (Exception) { throw; } return(Rs); }
public Int32 getNumCorrelativoDocTratamiento(BE_Req_Documento Request) { Int32 Item = new Int32(); 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_NumCorrelativo_From_DocTratamiento"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("cDocCodigo", Request.cDocCodigo); cm.Parameters.AddWithValue("cPerCodigo", Request.cPerCodigo); cm.Connection = cn; using (SqlDataReader dr = cm.ExecuteReader()) { while (dr.Read()) { Item = dr.GetInt32(dr.GetOrdinal("Correlativo")); } } } } } catch (Exception) { throw; } return(Item); }
public BE_Res_Documento getTipoPersona(BE_Req_Documento Request) { DADocumento ObjDocumento = new DADocumento(); return(ObjDocumento.getTipoPersona(Request)); }
public Boolean setDocUniOrg(BE_Req_Documento Request) { DADocumento ObjDocumento = new DADocumento(); return(ObjDocumento.setDocUniOrg(Request)); }
public BE_Res_Documento getDocumentoBycDocNDoc_nDocTipo(BE_Req_Documento Request) { DADocumento ObjDocumento = new DADocumento(); return(ObjDocumento.getDocumentoBycDocNDoc_nDocTipo(Request)); }
public Boolean setDocPersona(BE_Req_Documento Request) { DADocumento ObjDocumento = new DADocumento(); return(ObjDocumento.setDocPersona(Request)); }
public BE_Res_Documento getCorrelativoBynDocTipo_nPrdCodigo(BE_Req_Documento Request) { DADocumento ObjCorrelativo = new DADocumento(); return(ObjCorrelativo.getCorrelativoBynDocTipo_nPrdCodigo(Request)); }
public DataTable getPerCopias(BE_Req_Documento Request) { DADocumento ObjDocumento = new DADocumento(); return(ObjDocumento.getPerCopias(Request)); }
public DataTable getDocPendientes(BE_Req_Documento Request) { DADocumento ObjDocumento = new DADocumento(); return(ObjDocumento.getDocPendientes(Request)); }
public BE_Res_Documento getUltimoDocumentoBycPerCodigo(BE_Req_Documento Request) { DADocumento ObjDocumento = new DADocumento(); return(ObjDocumento.getUltimoDocumentoBycPerCodigo(Request)); }
public Boolean setDocumento(BE_Req_Documento Request) { Boolean Item = new Boolean(); string codigo = ""; 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_Documento"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("cDocCodigo", Request.cDocCodigo); cm.Parameters.AddWithValue("dDocFecha", Request.dDocFecha); cm.Parameters.AddWithValue("cDocObserv", Request.cDocObserv); cm.Parameters.AddWithValue("nDocTipo", Request.nDocTipo); cm.Parameters.AddWithValue("nDocEstado", Request.nDocEstado); cm.Parameters.AddWithValue("cAsunto", Request.Asunto); cm.Parameters.AddWithValue("cDetalle", Request.Detalle); cm.Parameters.AddWithValue("dFechaIni", Request.dFechaIni); cm.Parameters.AddWithValue("dFechaFin", Request.dFechaFin); cm.Parameters.AddWithValue("cNumDocumento", Request.cDocNDoc); cm.Parameters.AddWithValue("nPrdCodigo", Request.nPrdCodigo); cm.Parameters.AddWithValue("cCodPerSolicita", Request.CodPerSolicita); cm.Parameters.AddWithValue("nPerRelSolicita", Request.PerRelSolicita); cm.Parameters.AddWithValue("nCodUORemite", Request.CodUORemite); cm.Parameters.AddWithValue("nDocPerTipo", Request.nDocPerTipo); cm.Parameters.AddWithValue("cCodPerRegistra", Request.CodPerRegistra); cm.Parameters.AddWithValue("cCodPerRecibe", Request.CodPerRecibe); cm.Parameters.AddWithValue("nCodUODestino", Request.CodUODestino); cm.Connection = cn; using (SqlDataReader dr = cm.ExecuteReader()) { while (dr.Read()) { codigo = dr.GetString(dr.GetOrdinal("cDocCodigo")).ToString(); } } if (codigo.Equals("")) { Item = false; } else { Item = true; } } } } catch (Exception) { throw; } return(Item); }
public Boolean setCopiaDocumento(BE_Req_Documento Request) { DADocumento ObjDocumento = new DADocumento(); return(ObjDocumento.setCopiaDocumento(Request)); }
public DataTable getDocConAcuerdo(BE_Req_Documento Request) { DADocumento ObjDocumento = new DADocumento(); return(ObjDocumento.getDocConAcuerdo(Request)); }
public DataTable getDocInformacion(BE_Req_Documento Request) { DADocumento ObjDocumento = new DADocumento(); return(ObjDocumento.getDocInformacion(Request)); }
public DataTable getDocAcuerdoBySustentar(BE_Req_Documento Request) { DADocumento ObjDocumento = new DADocumento(); return(ObjDocumento.getDocAcuerdoBySustentar(Request)); }
public Boolean updEstadoDocumento(BE_Req_Documento Request) { DADocumento ObjDocumento = new DADocumento(); return(ObjDocumento.updEstadoDocumento(Request)); }
public DataTable getDocAcuerdoAvanceByPersona(BE_Req_Documento Request) { DADocumento ObjDocumento = new DADocumento(); return(ObjDocumento.getDocAcuerdoAvanceByPersona(Request)); }
public Boolean setDocProProveido(BE_Req_Documento Request) { DADocumento ObjDocumento = new DADocumento(); return(ObjDocumento.setDocProProveido(Request)); }
public Int32 getNumCorrelativoDocTratamiento(BE_Req_Documento Request) { DADocumento ObjDocumento = new DADocumento(); return(ObjDocumento.getNumCorrelativoDocTratamiento(Request)); }