//SysConfigParametros public BE_ResGenerico Set_SysConfigParametros(BE_ReqSysConfig Request) { BE_ResGenerico Item = new BE_ResGenerico(); DA_Sistema Obj = new DA_Sistema(); Item = Obj.Set_SysConfigParametros(Request); return Item; }
//-------------------------------------------------- // 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; }
//[usp_Get_SysConfigParametros] public int Get_SysConfigParametros(BE_ReqSysConfig Request) { DA_Sistema Obj = new DA_Sistema(); return Obj.Get_SysConfigParametros(Request); }
//------------------------------------------------------------------- //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; }